Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Link Sales Order to AR Invoice

Hey everyone,

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!

Former Member

Hi John,
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


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question