on 07-18-2007 4:39 PM
Dear Expert,
Understand sometime invoice / billing is created (VF01) but it can't auto post to FI due to certain error messages. I have a report which wish to only display invoice that has accouting document (has posting to FI).
Any ideas which table/fields that i may use to check if accouting document has been created after invoice / billing is saved (VF01).
Regards.
Logic to derive Accounting Document Number for Billing Document:
Table Joint: VBRK-XBLNR = BKPF-XBLNR
Accounting Document Number: BKPF-BELNR
Regards,
Rajesh Banka
reward suitable points
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
All you need to do is run t code VFX3.
This will show all billing docs that have not been passed to accounting.
Not only that it will provide the reason as well in the log.
Please award points if useful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For a Billing document you can get the Accounting document number from Table VBRK (Billing document header data).
Document flow details can be obtained from VBFA.
Thanks
Murali.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.