Link PO with PI

Joeri

Hi Everyone,

When i get a purchase invoice, i always make a new PI for the vendor and choose [Functions]-[Get Receipt Lines]. This is because I can get one invoice for multiple purchase orders.

The problem however is, the link between a PO and a PI is non-existant when i post the PI this way. Is there any way to see on which PI a PO is posted ? There must be a link somewhere, or are these completed seperated when you post a PI this way ? If that's the case, how can i post it without severing the link.

I hope for a quick response,

Thanks.

With Kind Regards,

Joeri

ara3n

Hello Joeri
Yes the link is lost. You need to add two new fields in Sales Invoice Line table and in CU 80 populate the fields so it maintains the fields.

ssingla

Rashed Wrote

You need to add two new fields in Sales Invoice Line table and in CU 80 populate the fields so it maintains the fields.

I guess Joeri is asking for purchase order and Purchase Invoice not Sales.

Well all the purchase receipt lines have the purchase order number. In codeunit 74 "Purch.-Get Receipt" you need to add code and define the field in table 123 'Purch. Inv. Line". Then you run a query/report to locate the P.O. and the resulting PI.