Purchase order - receipt – Invoice.

· Hi ,

I am working on 4.0 SP3

My customer is asking the Link between Purchase order - receipt – Invoice.

But In 4. 0 I have the Link Purchase order – Invoice

And Pruchse order – Receipt , Receipt - > Invoice .

But I don’t have the link between Order - > Receipt - > Invoice.

How to solve this issue

One way to solve it would be to use the Get Receipts Function.

Create a Purchase Invoice for the supplier, then goto Functions>>Get Receipts. This then enables you to place specific receipts onto an invoice.

Hope this is of some help

Thanks

Using Get Receipt Lines it give the relation to only Receipt - Invoice

There is no relation Order - Receipt – Invoice.

If u use the Get receipt line s u cannot get the order no .

We did a very simple mod for a customer which placed the sales order into the line aswell. I know this was for the sales side, but in effect it is the same thing. We placed the sales order no. into the shipment line, and then moved that into the invoice line when the Get Shipments function was used. This then gave us all the links required.

Andrew

Hi Lally,

Depending on your version - there is a link between the receipt and the Invoice. You will need to go from the item ledger entry to the value ledger entry (or vise versa) tables using the item ledger entry no. as the link. The PO should be linked to the receipt header and also to the invoice header if invoiced from the order.

Hope this helps.