We have an issue where a system-generated entry was created through an Inventory transaction. Inventory of single item had a negative quantity. We then landed additional quantity and the system self-generated an adjusting entry for costing. This is correct. Our problem is that 1) we apparently do not have the Purchase Receipts Update Detail Report enabled for printing, and 2) we need to see the actual detail of the Cost Variance for this transaction but do not know how to reprint, or if this is possible. Any assistance is greatly appreciated!
*This post is locked for comments
As I understand, if the ‘Print’ check box is marked for the Cost Variance Journal in the Posting Setup window for the Sales, Inventory and Purchasing series, then this report is also printed whenever there is a cost
adjustment and there are general ledger transactions that need to be posted. By default, this report
prints in summary.
To print this report to print in detail, there are two modified reports that are available
at the Great Plains Reports Library located at:
https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/gp_reportslibrary.htm that
can be downloaded and added to your reports dictionary. After that is completed, you must also grant
access to the modified report. After those reports and the dex.ini entry is in place, these reports will
provide additional detail supporting the cost changes that are occurring within the Inventory Control
module. The reports will provide:
• outflow (sales or inventory) document number
• Item number affected
• quantity of the item on the outflow transaction
• old unit cost of the item on the outflow transaction
• new unit cost of the item on the outflow transaction
• calculated difference between the two costs
• extended amount (quantity * cost difference)
The PRUD report is a “one time” report that is produced at the time of posting and can’t be regenerated
so it is essential that this report be printed to paper or file anytime it is produced.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156