on 09-18-2014 8:28 AM
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
Thanks to all
I got as per our requirement.
Regards,
sanjay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sanjay,
All Customer Invoice & Payment details (documents) you can found in FBL5N only. Thanks.
Regards,
Inthiyaz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
did you try by joining the tables BSID and BSAD in SQVI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.