cancel
Showing results for 
Search instead for 
Did you mean: 

customer payment report against sales invoice

Former Member
0 Kudos

Dear Experts.

My client has requirement to track customer payment against sales invoice. Actually client sometimes do partial payment also. I know we can get from bsid(open item) & bsad(cleared item) table. I unable to find actual required data.

regards

sanjay verma

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

Thanks to all

I got as per our requirement.

Regards,

sanjay

Former Member
0 Kudos

Hi Sanjay,

Thanks for update.

Regards,

Inthiyaz

Former Member
0 Kudos

Hi Sanjay,

Check the DZ document attachments,  In real time Users attach the supporting documents for each transaction.  If you have not found please check with your users.  Thanks.

Regards,

Inthiyaz

phanikumar_v3
Active Contributor
0 Kudos

Dear Sanjay,

While making payments --currently what was the procedure followed at your client.

Normally invoice will be created with RV (FI) doc type and payments with DZ.

Also while receiving payments users will be maintaining some texts(F-28) like ""partial payment for invoice numberXXXXXX)

As mentioned you can track this in FBL5n.

Phanikumar

Former Member
0 Kudos

Hi Sanjay,

All Customer Invoice & Payment details (documents) you can found in FBL5N only.  Thanks.

Regards,

Inthiyaz

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Dear Sanjay,

Apart form the FBL5N,  Please check the below path for more standard reports which helps you to fulfill your requirement.  Hope its helpful.

In SAP Easy Access screen

Regards,

Inthiyaz

Former Member
0 Kudos

This message was moderated.

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

did you try by joining the tables BSID and BSAD in SQVI

Lakshmipathi
Active Contributor
0 Kudos

Before posting such queries, better check with your FI consultants who would have advised you to make use of FBL5N where system would show line item wise details.

G. Lakshmipathi