D365 Finance & Operations and Dynamics AX Forum

Avalara
Back to discussions
Expand all | Collapse all

Standard Variance Posting Profile - Production Quantity Variance

  • 1.  Standard Variance Posting Profile - Production Quantity Variance

    GOLD CONTRIBUTOR
    Posted Dec 03, 2019 10:00 AM
    We have been back-flushing standard route time as direct labor as part of our Production process.  We now have a need to post actual labor hours and are struggling with the Posting Profile.  Our base set-up flushes all Production Quantity variance (labor or material) to the same GL account (material Usage Variance.  We would like to see the Material and the Labor to go to different accounts.  I have attempted using the "table, group, all" on the item to make this happen but have been unsuccessful.  Any insight would be helpful.
    The original posting profile below groups material and labor qty variance into the the same account

    I have tried using Group = Direct Manufacturing as an additional line as well as Table associated with the Route Cost Group.  Shown below with both set-ups however in testing i did them separately

    I still end up with the entire quantity variance (material & labor) posting to 523000

    Any help or suggestions would be appreciated.

    Thanks!


    ------------------------------
    Jody Cronk
    HBD Industries
    ERP Supply Chain Specialist
    US-AXUG OH (Columbus) Chapter Co-Lead
    ------------------------------
    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role