fi ap config guide apps vb

54
CONFIGURATION GUIDE ACCOUNTS PAYABLE ACCOUNTS PAYABLE © Accounts Payable Configuration Guide Page 1 of 54

Upload: windsor2004

Post on 10-Mar-2015

102 views

Category:

Documents


8 download

TRANSCRIPT

Page 1: Fi AP Config Guide Apps Vb

CONFIGURATION GUIDE

ACCOUNTS PAYABLE

ACCOUNTS PAYABLE

© Accounts Payable Configuration Guide

Page 1 of 49

Page 2: Fi AP Config Guide Apps Vb

Account Payable

Define Vednor Accounts Groups with Screen Layout

Transaction Code SPRO or OBD3

IMG Menu Financial Accounting Account Receivable and Accounts Payable Vendor Accounts Master Records Preparations for creating vendor master records Define account groups with screen layout

No Account Group

Description Number Ranges

Reconciliation Accounts

1 0001 Standard Vendor 0-79999 211000

2 0007 Plants A-ZZZZ 211999

3 0099 One-time Vendor 80000-89999 211000

4 HRTP Employees 90000-99999 211020

Go to

© Accounts Payable Configuration Guide

Page 2 of 49

Page 3: Fi AP Config Guide Apps Vb

Field name Description R/O/C User action and values

Comment

Account Group Vendor Account Group

R 0001

Name R Standard Vendor

Then Select

Then Click on Account Management

Make Reconciliation as Required Entry

Save

© Accounts Payable Configuration Guide

Page 3 of 49

Page 4: Fi AP Config Guide Apps Vb

Create with same steps for 0007 and HRTP

Field name Description R/O/C User action and values

Comment

Account Group R 0007

Name Plants R

Account Group R HRTP

Name Employees R

One Time Vendor Creation

Field name Description R/O/C User action and values

Comment

Account Group R 0099

Name One Time Vendor R One Time Vendor

One-time Account

R X

Then Select

Then Click on Account Management

© Accounts Payable Configuration Guide

Page 4 of 49

Page 5: Fi AP Config Guide Apps Vb

Make Reconciliation as Required Entry

Save

Create Number Ranges for Vendor Accounts

Transaction Code SPRO or XKN1

IMG Menu Financial Accounting Account Receivable and Accounts Payable Vendor Accounts Master Records Preparations for creating vendor master records Create number ranges for vendor accounts

© Accounts Payable Configuration Guide

Page 5 of 49

Page 6: Fi AP Config Guide Apps Vb

The Insert Interval

© Accounts Payable Configuration Guide

Page 6 of 49

Page 7: Fi AP Config Guide Apps Vb

Then Save

Assign Number Ranges to Vendor Account Groups

© Accounts Payable Configuration Guide

Page 7 of 49

Page 8: Fi AP Config Guide Apps Vb

Transaction Code SPRO

IMG Menu Financial Accounting Account Receivable and Accounts Payable Vendor Accounts Master Records Preparations for creating vendor master records Assign number ranges t to vendor account groups

© Accounts Payable Configuration Guide

Page 8 of 49

Page 9: Fi AP Config Guide Apps Vb

Automatic Payment Program.

Transaction Code SPRO or FBZP

IMG Menu Financial Accounting Account Receivable and Accounts Payable Business transactions Outgoing payments Automatic outgoing payments Payment method/Bank selection Set up all Company Codes for Payment Transactions

Configuration

1) Enter transaction code “FBZP” in the SAP Easy Access command field.

2) Once in the Customizing: Maintain Payment Program screen, click on the

button and then click on the button.

© Accounts Payable Configuration Guide

Page 9 of 49

Page 10: Fi AP Config Guide Apps Vb

2) Once in the New Entries: Details of Added Entries screen, enter the required information according to the table below:

Field name Description R. /O. /C User action and values

Comment

BUKRS Company Code R AFCO

ABSBU Sending company code

R AFCO

ZBUKR Paying company code

R AFCO

© Accounts Payable Configuration Guide

Page 10 of 49

Page 11: Fi AP Config Guide Apps Vb

Click on the save button and go back.

3) Repeat the step 2 using the information in the table below:

Field name Description R. /O. /C User action and values

Comment

BUKRS Company Code R AFCO

ABSBU Sending company code

R AFCO

ZBUKR Paying company code

R AFCO

© Accounts Payable Configuration Guide

Page 11 of 49

Page 12: Fi AP Config Guide Apps Vb

4) In the Customizing: Maintain Payment Program screen, click on the

button, then click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values

Comment

Paying co. code R AFCO

Minimum amount for incoming payment

R

Minimum amount for outgoing payment

R 1.00

No exchange rate differences

O X

Separate payment for each ref.

O X

Form for the Payment Advice

R F110_US_AVIS

EDI accompanying sheet form

R F110_US_DTA

Text ID R ADRS

Letter header R ADRS_HEADER

Footer R ADRS_FOOTER

Signature text R ADRS_SIGNATURE

Sender R ADRS_SENDER

© Accounts Payable Configuration Guide

Page 12 of 49

Page 13: Fi AP Config Guide Apps Vb

Click on the save button and go back.

© Accounts Payable Configuration Guide

Page 13 of 49

Page 14: Fi AP Config Guide Apps Vb

Payment methods in Country

5) In the Customizing: Maintain Payment Program screen, click on the

button, then click on the button and enter the required information according to the table below:

Payment Method : (ACHEFT)

Field name Description R. /O. /C User action and values

Comment

Country R US

Pymt Method R A

Description RACH (EFT)

Outgoing payments

R X

Bank transf R X

Allowed for personnel payments

O X

Street, P.O. box or P.O. box pst code

O X

Bank details O X

Account Number Required

O X

Document type for payment

R KZ

Clearing document type

R ZV

Use Classic payment medium programs (RFFO*)

O X

Payment medium program

O RFFOEDI1

© Accounts Payable Configuration Guide

Page 14 of 49

Page 15: Fi AP Config Guide Apps Vb

Click on the save button and go back.

Payment Method: (Wire Transfer)

Repeat the step 6 using the information in the tables below:

Field name Description R. /O. /C User action and values

Comment

Country R US

Pymt Method R W

Description R Wire Transfer

Outgoing payments

R X

Bank transf R X

Allowed for personnel payments

O X

© Accounts Payable Configuration Guide

Page 15 of 49

Page 16: Fi AP Config Guide Apps Vb

Street, P.O. box or P.O. box pst code

O X

Bank details O X

Account Number Required

O X

Document type for payment

R KZ

Clearing document type

R ZV

Use Classic payment medium programs (RFFO*)

O X

Payment medium program

O RFFOEDI1

© Accounts Payable Configuration Guide

Page 16 of 49

Page 17: Fi AP Config Guide Apps Vb

Click on the save button and go back.

Payment Method: (Check)

Field name Description R. /O. /C User action and values

Comment

Country R US

Pymt Method R C

Description R Check

Outgoing payments

R X

Check R X

Allowed for personnel payments

O X

Street, P.O. box or P.O. box pst code

O X

Document type for payment

R KZ

Clearing document type

R ZV

Use Classic payment medium programs (RFFO*)

O X

Payment medium program

O RFFOUS_C

Name of print dataset

O LIST1S

© Accounts Payable Configuration Guide

Page 17 of 49

Page 18: Fi AP Config Guide Apps Vb

Click on the save button and go back.

Payment Methods in Company Code

6) In the Customizing: Maintain Payment Program screen, click on the

button, then click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

Paying co. code R AFCO

Pymt Method R A (ACHEFT)

Minimum amount R 1.00

Maximum amount R 9,999,999.00

© Accounts Payable Configuration Guide

Page 18 of 49

Page 19: Fi AP Config Guide Apps Vb

Single Payment for marked item

O X

Foreign Business Partner Allowed

O X

No optimization O X

Form for the payment medium

R F110_EDI_01

Next Form R F110_US_DTA

Drawer on the form

O AFCO Industries, Roy Ave, 3400, Alexandria 71302

As many as req O X

NoPytAdv O X

© Accounts Payable Configuration Guide

Page 19 of 49

Page 20: Fi AP Config Guide Apps Vb

Click on the save button and go back.

7) Repeat Step 8 using the information contained in the tables below:

Field name Description R. /O. /C User action and values Comment

Paying co. code R AFCO

Pymt Method R W

Minimum amount R 1.00

Maximum amount R 9,999,999.00

Single Payment for marked item

O X

Foreign Business Partner Allowed

O X

No optimization O X

Form for the payment medium

R F110_EDI_01

Next Form R F110_US_DTA

Drawer on the form

O AFCO Industries, Roy Ave, 3400, Alexandria 71302

As many as req O X

NoPytAdv O X

© Accounts Payable Configuration Guide

Page 20 of 49

Page 21: Fi AP Config Guide Apps Vb

8) In the Customizing: Maintain Payment Program screen, click on the

button, then click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

Paying co. code R AFCO

Pymt Method R C

Minimum amount R 1.00

Maximum amount R 9,999,999.00

Single payment for marked item

O X

Foreign Business Partner Allowed

O X

© Accounts Payable Configuration Guide

Page 21 of 49

Page 22: Fi AP Config Guide Apps Vb

No optimization O X

Form for the payment medium

R F110_PRENUM_CHCK

Drawer on the form

O AFCO Industries, Roy Ave, 3400, Alexandria 71302

As many as req O X

NoPytAdv O X

Click on the save button and go back.

© Accounts Payable Configuration Guide

Page 22 of 49

Page 23: Fi AP Config Guide Apps Vb

9) In the Customizing: Maintain Payment Program screen, click on the

button, then click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

PM R A

Crcy R USD

Rank order R 1

House Bk R WFB01

PM R A

Crcy R USD

Rank order R 2

House Bk R WFB02

PM R B

Crcy R USD

Rank order R 1

House Bk R WFB01

PM R C

Crcy R USD

Rank order R 1

House Bk R WFB01

PM R C

Crcy R USD

Rank order R 2

House Bk R WFB02

PM R W

Crcy R USD

Rank order R 1

House Bk R WFB01

PM R W

Crcy R USD

Rank order R 2

House Bk R WFB02

Click on the save button and double click on “Bank Accounts”.

© Accounts Payable Configuration Guide

Page 23 of 49

Page 24: Fi AP Config Guide Apps Vb

10) In the Change View “Bank Accounts” screen, click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

House Bank R WFB01

Pay.Method R A

Currency R USD

Account ID R WFOPR

Bank subaccount R 1006503

House Bank R WFB01

Pay.Method R B

Currency R USD

Account ID R WFRFN

Bank subaccount R 1006605

House Bank R WFB01

Pay.Method R C

Currency R USD

Account ID R WFOPR

Bank subaccount R 1006505

House Bank R WFB01

© Accounts Payable Configuration Guide

Page 24 of 49

Page 25: Fi AP Config Guide Apps Vb

Pay.Method R W

Currency R USD

Account ID R WFOPR

Bank subaccount R 1006501

House Bank R WFB02

Pay.Method R A

Currency R USD

Account ID R WFCRC

Bank subaccount R 1004103

House Bank R WFB02

Pay.Method R C

Currency R USD

Account ID R WFPYR

Bank subaccount R 1006705

House Bank R WFB02

Pay.Method R W

Currency R USD

Account ID R WFCNC

Bank subaccount R 1006401

Click on the save button and double click on “Available Amounts”.

11) In the New Entries: Overview of Added Entries screen, click on the

button and enter the required information according to the table below:

© Accounts Payable Configuration Guide

Page 25 of 49

Page 26: Fi AP Config Guide Apps Vb

Field name Description R. /O. /C User action and values Comment

House Bank R WFB01

Account ID R WFOPR

Days R 999

Currency R USD

Available for outgoing payments

R 999,999,999,999.00

House Bank R WFB01

Account ID R WFRFN

Days R 999

Currency R USD

Available for outgoing payments

R 999,999,999,999.00

House Bank R WFB02

Account ID R WFCNC

Days R 999

Currency R USD

Available for outgoing payments

R 999,999,999,999.00

House Bank R WFB02

Account ID R WFCRC

Days R 999

Currency R USD

Available for outgoing payments

R 999,999,999,999.00

House Bank R WFB02

Account ID R WFPYR

Days R 999

Currency R USD

Available for outgoing payments

R 999,999,999,999.00

© Accounts Payable Configuration Guide

Page 26 of 49

Page 27: Fi AP Config Guide Apps Vb

Click on the save button and go back.

12) In the Customizing: Maintain Payment Program screen, click on the

button, and then enter the company code “AFCO”.

13)On the Change View “House Banks”: Overview screen, double click on the line corresponding to the House Bank “WFB01”, click on the

button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

EDI partner number

R 125008547

© Accounts Payable Configuration Guide

Page 27 of 49

Page 28: Fi AP Config Guide Apps Vb

Click on the save button . If some warning message like the one showed below arises, just click “Enter” to bypass it.

14) In the Change View “House Banks”: Details screen, click on the button

, then in button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

Pymt Method R A

Pymt Method R W

© Accounts Payable Configuration Guide

Page 28 of 49

Page 29: Fi AP Config Guide Apps Vb

Click on the save button and go back.

15) In the Change View “House Banks”: Details screen, click on the button

, then in button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

Ty R US

Agent R User provided by Basis Note: DON’T use “marco”, a Basis person should provide real user.

Language R EN

Note: User “marco” was used just for testing purposes, however a dedicated user for Idocs processing must be provided by a Basis person and used during the configuration in Client 100.

Click on the save button .

16) In the Partner Profiles screen, click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

© Accounts Payable Configuration Guide

Page 29 of 49

Page 30: Fi AP Config Guide Apps Vb

Partner no R 125008547

Partn.Type R B

Message Type R PAYEXT

Receiver Port R PAYMT_WF

Transfer Idoc Immed

O X

Start subsystem O X

Basic Type R PEXR2002

Cancel processing after syntax error

O X

Click on the save button and go back.

17) In the Partner Profiles screen, click on the button and enter the required information according to the table below:

Field name Description R. /O. /C User action and values Comment

Partner no R 25008547

Partn.Type R B

Message Type R EUPEXR

© Accounts Payable Configuration Guide

Page 30 of 49

Page 31: Fi AP Config Guide Apps Vb

Receiver Port R PAYMT_WF

Collect IDocs O X

Do not start subsystem

O X

Basic Type R IDCREF01

Cancel processing after syntax error

O X

Click on the save button and go back to the SAP Easy Access screen.

18)Repeat the steps 15 to 17 using the information contained in the tables below:

Company Code: AFCOHouse Bank: WFB02

Field name Description R. /O. /C User action and values Comment

© Accounts Payable Configuration Guide

Page 31 of 49

Page 32: Fi AP Config Guide Apps Vb

EDI partner number

R 121000248

Field name Description R. /O. /C User action and values Comment

Pymt Method R A

Pymt Method R W

Company Code: AFCOHouse Bank: WFB01

Field name Description R. /O. /C User action and values Comment

EDI partner number

R 125008547

Field name Description R. /O. /C User action and values Comment

Pymt Method R A

Pymt Method R W

Company Code: AFCOHouse Bank: WFB02

Field name Description R. /O. /C User action and values Comment

EDI partner number

R 121000248

Field name Description R. /O. /C User action and values Comment

Pymt Method R A

Pymt Method R W

Finally, Click on the save button

1List of Transaction Codes

Transaction Code Description

FBZP Customizing: Maintain Payment Program

© Accounts Payable Configuration Guide

Page 32 of 49

Page 33: Fi AP Config Guide Apps Vb

SE38 ABAP Editor: Initial Screen

2Glossary of Frequently Used Icons/Buttons

Icon Description Use

 ENTER Green checkmark means

enter. Or, you can also use the enter key on your keyboard.

  Command Enter the transaction code to quickly perform certain functions within SAP.

  LIST Selecting this icon displays recent transaction codes accessed.

Dropdown Menu button

You will encounter this button connected to any textbox which has pre-populated values to choose from

 SAVE Selecting this icon saves the

document along with any changes that have been made.

 BACK Selecting this icon takes

user to the previous screen.

 EXIT Selecting this icon exits the

current menu or transaction without saving data.

 CANCEL Selecting this icon cancels

the transaction.  If information has been entered, the system will ask for confirmation so data is not accidentally lost.

House Banks Creation

© Accounts Payable Configuration Guide

Page 33 of 49

Page 34: Fi AP Config Guide Apps Vb

1) Creation of Bank Keys

Go to FI01

Enter the details

For First Tennessee Bank

Save

© Accounts Payable Configuration Guide

Page 34 of 49

Page 35: Fi AP Config Guide Apps Vb

For Metro Bank

Enter the details

For Capital One

© Accounts Payable Configuration Guide

Page 35 of 49

Page 36: Fi AP Config Guide Apps Vb

Enter required details

© Accounts Payable Configuration Guide

Page 36 of 49

Page 37: Fi AP Config Guide Apps Vb

2) Define House Banks

Transaction Code FI12

IMG Menu SPRO Financial Accounting Bank AccountingBank Accounts Define House Banks

© Accounts Payable Configuration Guide

Page 37 of 49

Page 38: Fi AP Config Guide Apps Vb

Go to New Entries

Then Click on Bank Accounts

Then Go to New Entries - For Tennessee Bank

© Accounts Payable Configuration Guide

Page 38 of 49

Page 39: Fi AP Config Guide Apps Vb

For First Tennessee (Payroll)

© Accounts Payable Configuration Guide

Page 39 of 49

Page 40: Fi AP Config Guide Apps Vb

For Metro Bank

Go to FI12 Then Go to New Entries

© Accounts Payable Configuration Guide

Page 40 of 49

Page 41: Fi AP Config Guide Apps Vb

Go to Bank Accounts ( ) and click on

© Accounts Payable Configuration Guide

Page 41 of 49

Page 42: Fi AP Config Guide Apps Vb

Go to Bank Accounts ( ) and click on

© Accounts Payable Configuration Guide

Page 42 of 49

Page 43: Fi AP Config Guide Apps Vb

Creation of House Bank separately for Capital One – Control Disbursement since there is a different Bank Key

© Accounts Payable Configuration Guide

Page 43 of 49

Page 44: Fi AP Config Guide Apps Vb

© Accounts Payable Configuration Guide

Page 44 of 49

Page 45: Fi AP Config Guide Apps Vb

© Accounts Payable Configuration Guide

Page 45 of 49

Page 46: Fi AP Config Guide Apps Vb

Capital One – Control Disbursement

© Accounts Payable Configuration Guide

Page 46 of 49

Page 47: Fi AP Config Guide Apps Vb

Go to Bank Accounts ( ) and click on

© Accounts Payable Configuration Guide

Page 47 of 49

Page 48: Fi AP Config Guide Apps Vb

Bank Determination

1) Ranking Order

© Accounts Payable Configuration Guide

Page 48 of 49

Page 49: Fi AP Config Guide Apps Vb

© Accounts Payable Configuration Guide

Page 49 of 49