Thursday, 20 June 2013

Automatic Payment Program FAQS

Q1:  What is the process of payments using the Automatic Payment Program?

A: The process in general is as follows.
You launch transaction F110 and specify parameters for the selection of items to be paid. Then you run Proposal Run which creates Payments Proposal. This proposal is analysed by Treasury / Accountants / somebody else and then it is approved immediately or with some corrections. After that you run Productive Run. At this moment postings are done (or not done – see separately). When Productive Run is finished, you can create payment file or paper payment documents for the bank and/or payment recipients.


Q2: What should I start an APP configuration from?

A: The process begins with understanding of payment types in use. Have a look at the bank statement, talk to the people responsible for payments and statements. You will create special payment method for each of the payment types.
Basic configuration of APP is carried out in transaction FBZP. Go through all the sections in it and understand what you will configure and what you will copy from existing examples (maybe just use existing examples without copying).


Q3: We have a special payment type when paper fax is sent to the “bank”. This fax contains all the parameters for the payment processing. The “bank” is not a real bank but company within our holding. It gives us periodic statements like paper bank statements. Payments of this type are absolutely manual. Do I need to set up special payment method for this?

A: 1)
If the payment is done for the preliminary known open items, you can simply use “Manual payments” transaction F-53 without APP. No payment method is required in this case. Payment document can be printed out in external system (Word/Excel) or via Correspondence functionality.

2) If you want APP to choose the documents to be paid via “fax”, then you have to use it. Special payment method is required. Of course, you can set up your own printing program for this payment method, as for usual payment method.


Q4: We periodically pay to the government authorities. For example, taxes. How should we process these payments?

A: I saw 3 scenarios:
1) Russian. You create special vendor with reconciliation account in area of “tax” GL accounts. You post “invoice” from this vendor, even though there is no actual invoice. Amount is taken from the tax return. Then you pay the amount to vendor as usual.
2) Western with direct debit. Very simple. Tax authorities take money from the bank account by themselves.
3) Western with invoice. It is like scenario 1, but actual invoice exists.


Q5: Bill of exchange. What is this? IMG has lots of settings about it, but I do not understand if I need them.

A: It is payment with notes (bill of exchange, bill). I have never seen it in use. Simply forget about it.


Q6

: Are there any recommendations as to best usage of Identification field in transaction F110? The one below the date, on the first screen. Should we put clerk’s initials in there, country code, company code?

A: The approach depends on number of people processing the payments, if they have on-line connection to each other etc. If people are locates in several geographical locations, then it is logical to put code of the country or Company Code. If they sit next to each other, they can work out their own rules.


Q7: Why do I have Vendors and Customers on the selection screens of APP? What is relations between Customers and Payment program which is used for outgoing payments?

A: First of all, we can pay Customers too. For example, refunds or returns of down payments.
Second, APP can be also used for payments collection. For example, direct debits.
That’s why customers are pretty much on their place in APP.


Q8: Are there any recommendations as to how to use “Next run date” field in APP? How often should the Payment Run be executed?

A: If you use early settlement discount functionality and automatic payment optimization, then the field “Next run date” should contain the date of next run. Frequency of them depends on company rules and varies from 1 day to 1 month. If you select open items manually using the external lists and factors, then 31.12.9999 will do.


Q9: What is the trigger for APP run? Vendor invoice? Purchase order?

A: APP processes posted invoices and down payment requests. Purchase orders have nothing to do with APP. Frankly speaking, Purchase Orders are not relevant to Finance whatsoever.


Q10: We can control outgoing payments: what and how to pay. There is different situation with incoming payments. How would we know that customer has paid us in order to process the incoming payment in APP? How shall we know which bank account it sent us the money to, if we have several bank accounts? It is also unclear how customer calculates early settlement discount.

A: APP is used for the outgoing payments initiated by our company. Incoming payments are only processed via APP if we initiate them (i.e. direct debit).


Q11: Can we specify payment method in open items? Is it done in invoice?

A: Payment method is specified in several places in SAP system:
1) Vendor master record. You can specify several payment methods in there, and APP will automatically select the best one.
2) Directly in the invoice.
3) In the payment terms, and then this value will be inherited into the invoice.
Payment method in the invoice has a priority over the payment method in vendor master record.


Q12: I have specified payment method in the vendor master record. But it is not automatically copied into the posted invoice. Why? What should I do?

A: You can specify several payment methods in vendor master record. How should system decide which one you want to copy into the document, what do you think? That is why there is no such functionality in SAP.
As an alternative solution, you can specify payment method in the payment terms and then put payment terms into the vendor master record. Payment terms will be inherited into the document and will bring the payment method too.


Q13: Is it possible to change payment method in Payment proposal? Or we need to block the payment and change the payment method somewhere else?

A: When APP has analysed the open items and created a Payment Proposal, you can edit the Proposal: change payment methods, banks, regroup payments etc. There is a button for this on the Edit Proposal screen.


Q14: Do I need to make any developments for the APP?

A: You will need development only for the output forms, and only if:
1) extraordinary requirement from the bank in regards of output file. For example, development is required for the integration with Russian bank-client systems;
2) amend forms for cheques/ /Payment advice for the company/bank requirements (logo, fields location and other small details)


Q15: How will the bank know that it has to process the payment? What is the file format for the bank? Does APP process have a step for the output file generation?


A: Formats for the bank – you should as the bank yourself. SAP has lots of standard formats used worldwide and locally. You should only understand which ones to switch on.
Based on my own experience, international banks work well with formats SWIFT MT101 or MT103. They are in the standard delivery of PMW (Payment Medium Workbench).
Unfortunately, Russian banks a very self-conceited and only accept their own formats. One of the national standard (but not official) is format of “1C” system, but standard SAP does not support it. That is why file extract for the bank-client system is a development in this case.
Of course, file or printout for the bank is one of the results of APP work. You can generate them using the “Print” button on the instrument panel in APP.


Q16: Which format can we extract data from the system to send it to the bank?


A: It depends on the formats which bank accepts. SWIFT MT101 is very convenient and widespread. Some countries have their own requirements for the format. As a rule, they are already in SAP standard delivery.
If you are on the cross-road and do not know what to start with, try to give SWIFT MT101 file to the bank as look at their reaction. You can also ask Treasury which format they use at present.


Q17: What do I need to do in APP settings to enable generation of file with information about outgoing payments?


A: There are 6 buttons in transaction FBZP which you should start with. One of them (Payment method for the country) has a choice of “classical” payment program or Payment Medium Workbench.
Next we set up a variant for “classical” program or set up PMW (also known as DMEE).
You can find lots of customizing options for the extraction file in the IMG:
Financial Accounting > AP/AR > Business Transactions > Outgoing Payments > Automatic Outgoing Payments. Exact list of nodes you need to go into depends on format you have chosen.
IDOC is another option for the sending payments to the bank. Program RFFOEDI1 generates IDOCs and is always available in F110 on the “Print” tab.


Q18: I have decided to use SWIFT MT101 format. Which settings are required in the system in this case? Do I need to make settings for each individual bank?


A: Format MT101 is defined by SWIFT which is international organisation. It should not be changed. In the meantime, there are some parameters (fields) values in which can be changed because of requirements of client or bank.


Q19: Bank asks different structure of field 59 in format SWIFT MT101 for domestic and international payments. How should I set it up?


A: Separate payment method is usually used for international payment. Different payment methods can have different variants in PMW.


Q20: How can I set up instruction key which defines who pays commission for the payment, payer or payee? This instruction key is used in field 71A of format SWIFT MT10. How can I assign the key to the bank or vendor?


A: IMG Node
Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Media > Data Medium Exchange > Define Instruction Keys.
You define instruction key for the payment method. Then, payment method is assigned to the vendor or invoice (see above).
By the way, my own experience shows that banks are usually ignore this instruction and always charge payer with the commission.


Q21: How can I activate functionality “State Central Bank indicator” (SCB indicator), which is used in the field 77B of format SWIFT MT101?


A: IMG Node:
Financial Accounting (New) > General Ledger Accounting (New) > Periodic Processing > Report > Foreign Trade Regulations > Enter Company Data for Foreign Trade Regulations
Here we put the Company Code, i.e. “activate” SCB for it.
Next IMG node allows us to create our own SCB indicators.
When “SCB indicator” functionality is activated for the Company Code, “Details” tab of Invoice entry transaction (FB60) will have relevant fields: SCB ind and Suppl.Cntry. The condition: vendor should belong to the country different from country of Company Code. Play with these fields and see which information is taken to the field 77B. The rest is just a technical question.


Q22: Where do I set up output forms?

A: Output forms are defined in the payment methods. You can assign program/form or Payment Payment Medium Workbench (PMW) structure. There are tons of output forms ready to use. All the standard (including European) forms are supported. Print programs can be found using the RFFO* mask. List of PMW variants can be seen using the F4 key. You can create your own PMW forms in transaction DMEE. Please read PMW and DMEE documentation.
Other than payment order itself, company may require to produce Payment Advice which informs vendor about the payment details. You can configure the form for Payment Advice in the Paying Company Code section of transaction FBZP.


Q23: Do I need to configure anything for format SWIFT MT101 in transaction DMEE? I do not see anything like this in PAYM tree. If I need to create my own format, which option to choose: flat file or XML message? How can I assign / activate my own new format?

A: Format SWIFT MT101 exists in standard PMW delivery. DMEE covers only few PMW formats. Fortunately, SWIFT MT101 requires only minimal configuration, and it is not done in DMEE. Have a look at:
Financial Accounting (New) > General Ledger Accounting (New) > Business Transactions > Outgoing Payments > Automatic Outgoing Payments> Payment Media > Make Settings for Payment Medium Formats from Payment Medium Workbench > (Adjust Payment Medium Format).
And also Create/Assign Selection Variants (OBPM4) in the same IMG node.
If you need to create something very new, you can use DMEE for configuration and then assign newly created format to payment method in the same IMG node which I already mentioned.
Type of the tree (xml / flat file) depends on the bank’s preferences and requirement.


Q24: I have run the Payment Program, posted the documents and planned the print phase. Where should I see the file in the format SWIFT MT101?

A: F110 – Environment – Payment Media


Q25: I need to print a document for vendor which informs him about payment details. Where can I configure it?


A: You can do this in transaction FBZP, section “Paying Company Code”. This is called “Payment Advice”. It is usual form. SAP has delivered form for IDES which can be adjusted with a little ABAP.


Q26: Company uses bank chains. What is this? Does APP support them?


A: Bank chains are usually used in international payments, and very rare in domestic payments. Generally speaking, banks can usually determine how to transfer money from payer to payee themselves. But if company wants to help the bank and speed up the process, bank chains can help.
In short, here is the purpose of bank chains. If you want to transfer money from one bank to another, these banks should have accounts for each other (correspondence accounts). It means that banks put money into these accounts. When client of bank A pays client of bank B, then bank B increases the balance of the correspondence account and bank A reduces the balance. There is no physical money transfer unless the balances are negative. As soon as there are too many banks in the world, it is impossible to have correspondence accounts for each pair of the banks. There are some historical banks which carry out functions of intermediate banks. For example, Bank of New York (BONY). In this case banks A and B open correspondence accounts with BONY, but not with each other. When client of bank A transfers money to client of bank B, there are only movements on the correspondence accounts which link banks (A and BONY) and (BONY and B). Again, there is no physical money movement. BONY has no impact on its balance, but it gets commissions from the transaction. If payer wants to specify bank chain, it has to let its own bank know that BONY is an intermediate bank, and sometimes correspondence accounts of bank A in BONY.
There can be 2 intermediate banks in the worst scenario.
SAP has very simple customizing of bank chains. IMG Node: Financial Accounting (New) > Bank Accounting > Bank Chains. Сами банковские цепочки – это Основные данные, вводятся в основном меню Accounting – Financial Accounting – Banks – Master Data – Bank Chains.
If bank chains are active, system will automatically find the necessary chain and put it into internal table of APP. These data will get into payment order.


Q27: What are the possible options to display Payment Proposal and list of items in Proposal?


A: Payment Proposal and list of items in it can be viewed in 2 variants: classical and ALV-grid. You can customize classical display in IMG. If you want to switch display to ALV-grid, you have to put parameter in user master record (transaction SU3). Parameter code is F110OALV.

No comments:

Post a Comment

SAP FINANCE AND CONTROLLING