Home › Discussions › Questions & Answers › Open PO Monitoring and Cost Comparison
Customer · · Questions & Answers · 7 replies
We need a consolidated view of all open purchase orders, including average receipt costs derived from history, and a comparison against a specified cost type. Which Blitz Report should be used?
You should use the CAC Open Purchase Orders report. This report shows open purchase orders and is designed to compare against a specified cost type.
The report documentation mentions using Transaction Date parameters to calculate an average receipt cost. How does that feature work?
The mandatory ‘Transaction Date From’ and ‘Transaction Date To’ parameters define the range of PO Receipt History used to calculate the average receipt cost, which is then used for comparison to the PO unit prices.
If we have foreign currency purchases, how does the report ensure they are converted correctly to our general ledger currency?
You must enter the mandatory ‘Currency Conversion Date’ and ‘Currency Conversion Type’. The report converts foreign currency purchases into the currency of the general ledger (which is defaulted from the inventory organization for your session).
If I only want to see open POs for a specific vendor, is there a parameter for that?
Yes, you can use the optional ‘Supplier Name’ parameter to restrict the report output to a specific vendor.
Sign in with LinkedIn or Google to take part.
