Skip to main content
Answer

Production WIP Variance Breakdown

  • July 15, 2025
  • 3 replies
  • 61 views
P
Freshman I

Hi,

Does anybody have created a GI to extract subjected details?

Thanks, 

Prasad

Best answer by dgodsill97

The data you’re looking for in in AMProdTotals.  The variances are not accounting entries. If you want the accounting entries they are in AMMTran as WIP Adjusments, This article I wrote may help  https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=1ce567e9-7d64-4f0d-aa14-d894a35a8fc3p

Ignore the part about customizations; the JAMS objects were ported to Acumatica in 2020R2.

    3 replies

    dgodsill97
    Varsity I
    Forum|alt.badge.img+3
    • dgodsill97
    • Varsity I
    • Answer
    • July 15, 2025

    The data you’re looking for in in AMProdTotals.  The variances are not accounting entries. If you want the accounting entries they are in AMMTran as WIP Adjusments, This article I wrote may help  https://help.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=1ce567e9-7d64-4f0d-aa14-d894a35a8fc3p

    Ignore the part about customizations; the JAMS objects were ported to Acumatica in 2020R2.

    Chris Hackett
    P
    R
    Captain II
    Forum|alt.badge.img+2

    ​@plakmina97 If possible you to share what kind of fields you are expecting that WIP variance generic Inquiry.

    🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀
    Chris Hackett
    P
    P
    Freshman I
    • plakmina97
    • Author
    • Freshman I
    • July 16, 2025

    ​@ranjithduraisamy72 & ​@dgodsill97 Thank you so much for support. ​@dgodsill97 your article is really helpful, and I will review and let you know the feedback. 🙂

    Regards,

    Prasad

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved