on 12-22-2009 6:53 AM
Hi All,
I need to extract all the invoices for a time period which have been raised without refrence to PO and with refrence to a GL account.
If possible I need to get a table from where I can get all these invoices which have been raised with refrence to a GL by giving certain selection parameters.
Awaiting an early reply
Pratiksha
HI
You can find out the vendor invoices with the tables BSIK (Vendor Open items and BSAK(Vendor cleaed items)..with the document type..
If you want the vendor invoices without PO then you have to extract all the vendor invoices open items and cleared items from the above table and give the same document numbers in the table BSEG by mentioning with the not equal to option in the Purchasing Doc field with the blank details.
Try the above solution and let me know if you have any queries...
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
You can join the two tables with the T.code "Sq01"
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Usually when invoice posting take place without reference to PO document , invoice document type is KR.
from t.code FB03 or table BKPF, BSEG details could be extracted.
regards,
Neha Duseja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
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.