Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

How to enable printing of Purchase Receipts Update Detail Report and reprint the Cost Variance Journal in GP 2015 R2

Posted on by Microsoft Employee

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to enable printing of Purchase Receipts Update Detail Report and reprint the Cost Variance Journal in GP 2015 R2

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans