No of days to Reciept of payment

[sanilbhandari]

Hi

We have an issue in which we want to find out the number of days in which payment has been recieved against a particular invoice. Suppose an invoice 1232 has been generated on 1.4.2009 and payment against the same has been recvd on 3.4.2009 through document number 23232. The gap between the same is 3 days. I want to know in which table and field this data is stored both in case of partial and complete payments.

Regards

Sanil

[former_member182098 · Accepted solution]

Hello,

There is no direct report available like that.

You can depend on BSAD table (cleared items customers) and develop a SAP report with the help of ABAPer. - this contains both invoice as well as payment document details. You can differentiate by using the document type.

The difference between dates:

both days may be inclusive

both days may be exclusive

only first day may be exclusive

Regards,

Ravi