Payment File Line Items

[former_member325328]

Hello Experts,

I have question with reference to payment file.

We have generated the payment file successfully and after that we noticed that system created only one line in payment file against the payment 4 invoices.

Our expectation is system should generate 4 lines (1 line for each invoice) in XML.

Can you please let us know, how to achieve this in SAP Business ByDesign?

Thanks & Regards,

Sujeet Kumar

[former_member226215]

Hi,

try the following:

Goto Supplier Base --> Supplier --> View All --> Financial Data --> Payment Data --> Click "Pay Individually". This should work, otherwise it is all the time a summarized payment by vendor Level. regards Sebastian

[HarshalVakil]

Hi Sujeet,

Can you please check Activity : Outgoing Bank Transfers

Help center : Outgoing Bank Transfers — Configuration Guide

In this activity: you Check the settings maintained payment medium format by clicking Edit payment medium formats -> Sort Sequence and granularity of payments tab.

" On this tab you specify which payments are included within one file. Typically, payments of different companies and to be made by different banks must be included in different files. You must also define which payments should be combined in one logical message within a file. Usually payments in one logical message are debited or credited to your bank account summarized in one item. The system creates a reference number for each logical message so that the payments can be identified during bank statement processing. Note that you must start with the fields that define criteria for including payments into separate files, then continue with the fields that define criteria for including payments into logical messages. If you need to provide the payments sorted by any other criteria, add the entry at the bottom of the list and assign the highest sort sequence number to it."

If required you will need to adjust the settings here or create a new payment medium format according to the requirement.

Regards,

Harshal