on 2024 Aug 28 10:04 AM
Dear Experts,
We are uploading the bank statement file (inbound file) in SAP Business ByDesign. but in this file, the banker is not given the vendor invoice reference ID. They provided only the vendor name. How to define vendor payment memo line rules?
The vendor payments are done with Direct Debit.
Please guide me on how to define supplier payment memo line rules with all types of payments and without reference ID.
Thanks & Regards,
DNRAO
Request clarification before answering.
Hello DNRAO,
In this scenario the assumption is the clearing of an open Payables document (e.g. Supplier Invoice) or at least an on-account payment for an identified supplier.
For clearing an open invoice a pertinent Invoice Reference (Document Number, External Number, Payment Reference) - would be required to set up targeted Rules for Analyzing Memo Lines.
Content and structure of payer/payee-references largely depend on often localization-specific standard formats (e.g. MT940, ISO20022).
For example, in MT940 DE (Germany) - the supplier name is parsed in field :86: / Subfield: ?32
In case of a business partner name match this would lead to an on-account payment. An identification via IBAN is also possible.
In ISO20022 statements the business partner would be identified based on Name as well as IBAN.
Example:
<RltdPties>
<Cdtr><Nm>Example_Supplier</Nm></Cdtr>
<CdtrAcct><Id><IBAN>DEXXXXXXXXXXXXXXXXXXXX</IBAN></Id></CdtrAcct>
</RltdPties>
Rules for Analyzing Memo Lines will not be directly applicable here as the Rule Type '5 - Supplier' identifies a Supplier ID.
Hope this helps,
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
22 | |
13 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.