VENDPACKINGSLIPJOUR does not keep Exchange Rate! Why?

(0) Share

Report

Posted on by Community Member

Dear All,

I am working on PO Cost sheet report, the requirement is to show purchase order cost report on basis of its status. For example if purchase order status is Confirmed->PackingSlip->Invoiced. The report is required to check when purchase order confirmed what was the exchange rate at that time and its cost, when receipt list aka packing slip is generated and when invoiced. I don't want to get exchange rate from exchange rate table but I have to get stamped exchange rate on basis of status. I am using VendPurchOrderJour, VendPackingSlipJour and VendInvoiceJour Tables for this purpose. I got stamped exchange rate from VendPurchOrderJour and VendInvoiceJour but there is no exchange rate column in VendPackingSlipJour table. Kindly give me a solution how I can get stamped exchange rate on the basis of VendPackingSlipJour.

Regards & Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Packing slip and inventory transactions in general are not recorded in foreign currency but only in the accounting currency used.

Best regards

Ludwig

Was this reply helpful? Yes No