Link Sales Order to AR Invoice
I imported historical data for one of my clients, Sales Orders and AR invoices, and they would like to have them linked so they can view them together in the Relationship Map.
My question is, what field do I have to fill in on the AR Invoice to link it to a Sales Order?
Any help will be appreciated, thanks!
Unnikrishnan Balan replied
At the time of importing Invoices into SAP B1 thru DTW, you have to mention base type, base entry, base line no in INV1 table.
Base type of AR Invoice may be sales Quotation , Sales Order and Sales Delivery.
if you do this in this way, system will automatically close base document and you can see relation ship map also.
If you didnt do this, Sales order(or any base document) will remains open.
Thanks & regards