Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Re-print Cost Variance Journal Reports?

Posted on by Microsoft Employee

In our trial balance, we have the following descriptions (and references) for example

 

SALESRCT12843

SALESRCT12843

SALESRCT12942

SALESRCT12993

SALESRCT13004

SALESRCT13004

SALESRCT13004

SALES28027

SALES28028

SALES28030

IVA28006

IVA28007

IVA28011

POPRCT11642

POPRCT11653

POPRCT12156

 

Apparently these are auto generated by GP when there are cost variances.

 

We need the detail to know where they came from, and it appears that detail information might be in the Cost Variance journal reports.

 

Is this the correct place to get what we need and if so How can we re-print these reports?

 

If not, where do we get the detail info from?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Re-print Cost Variance Journal Reports?

    Rosemany,

    Thanks for your info.

    I went to reports >> posting journals in the Financials, Purchasing, Sales and Inventory modules, but I do not see Cost Variance Journal report as a selection in any of the modules.

    Inventory_2D00_Journal_2D00_Selections.pngFinancial_2D00_Posting_2D00_Journals.pngSales_2D00_Posting_2D00_Jouranls.pngInventory_2D00_Journal_2D00_Selections.png

    What I am missing?

    TIA

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Re-print Cost Variance Journal Reports?

    Hi,

    Have a read of this, yes it is auto generated due to cost variances. If you go to reports >> posting journals for the respective modules you can reprint the journals, you can retrieve the audit trail code via the sub ledger or gl(I use the audit trail code).  Relative to the version you are currently at you shouldn't have to make any changes.

    support.microsoft.com/.../an-unexpected-gltrx-batch-appears-in-financial-batch-entry

    www.prophet.ca/.../tracing-purchase-price-variances

    www.velosio.com/.../dynamics-gp-tip-improve-purchase-price-variance-with-dex-ini

    These documents did assist me in finding the initial transactions.

    Regards,

    Rosemary

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans