on 08-29-2008 5:34 PM
Hi Guys,
I am basically a FI guy who has been asked to create this extarct - it would be great if you guys can help me out with it:
1) Sum of all open orders in the system which have not been shipped
2) Sum of all open orders in the system which have been shipped by not yet invoiced.
3) Sum of all open billing, invoice document created but no AR doc created.
Which tables i can consider - i have a lill. idea - VBUK and VBUP tables. What should be the criteria to get all the above.
Please help me out.
Thanks,
Maulik Shah
Dear Maulik
1) Sum of all open orders - T.Code VA05 - Table VBBE
2) Sum of open orders shipped but not invoiced - T.Code VF04 Table VBFA. Here input M in the field Subs.doc.categ and execute. Wherever this field is blank, those are not invoiced
3) List of invoices created but Accounting document not created T.Code VFX3 - Table VBRK Field RFBSK where the status of the document would be A if Accounting document has not been generated and C if Accounting document would be created
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Maulik Shah,
Good Day,
1) Sum of all open orders in the system which have not been shipped
Transaction VA05
2) Sum of all open orders in the system which have been shipped by not yet invoiced.
Transaction VF04
3) Sum of all open billing, invoice document created but no AR doc created.
Transaction VFX3
Best Regards,
KSK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
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.