fi ap config guide apps vb
TRANSCRIPT
CONFIGURATION GUIDE
ACCOUNTS PAYABLE
ACCOUNTS PAYABLE
© Accounts Payable Configuration Guide
Page 1 of 49
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
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
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
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
The Insert Interval
© Accounts Payable Configuration Guide
Page 6 of 49
Then Save
Assign Number Ranges to Vendor Account Groups
© Accounts Payable Configuration Guide
Page 7 of 49
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
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
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
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
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
Click on the save button and go back.
© Accounts Payable Configuration Guide
Page 13 of 49
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1) Creation of Bank Keys
Go to FI01
Enter the details
For First Tennessee Bank
Save
© Accounts Payable Configuration Guide
Page 34 of 49
For Metro Bank
Enter the details
For Capital One
© Accounts Payable Configuration Guide
Page 35 of 49
Enter required details
© Accounts Payable Configuration Guide
Page 36 of 49
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
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
For First Tennessee (Payroll)
© Accounts Payable Configuration Guide
Page 39 of 49
For Metro Bank
Go to FI12 Then Go to New Entries
© Accounts Payable Configuration Guide
Page 40 of 49
Go to Bank Accounts ( ) and click on
© Accounts Payable Configuration Guide
Page 41 of 49
Go to Bank Accounts ( ) and click on
© Accounts Payable Configuration Guide
Page 42 of 49
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
© Accounts Payable Configuration Guide
Page 44 of 49
© Accounts Payable Configuration Guide
Page 45 of 49
Capital One – Control Disbursement
© Accounts Payable Configuration Guide
Page 46 of 49
Go to Bank Accounts ( ) and click on
© Accounts Payable Configuration Guide
Page 47 of 49
Bank Determination
1) Ranking Order
© Accounts Payable Configuration Guide
Page 48 of 49
© Accounts Payable Configuration Guide
Page 49 of 49