Tuesday, June 18, 2013

Dynamics GP Manufacturing - Automatic GL Journals for small inventory cost adjustments

The system will automatically generate small adjusting entries to correct rounding errors that occur in costing.

This can be seen by going to
MO activity > Double click on Raw Material Relief for your MO>Click Receipt Costs

For example,

  • I Receive 900 units with a total raw material cost of $4,000
  •  The finished good unit cost will be rounded
    • 4000 / 900 = 4.44444 rounded down to 4.44
    • The rounding error = 0.00444 * 900 = 3.996
  • This rounding error should go to a rounding account for overs and unders for inventory rounding errors.
  • The account should be setup in the Manufacturing>Setup>System Defaults>Costing>Rounding Difference Account
  • See this article for full information on all manufacturing accounts setup
  • http://waqasb.blogspot.com/2009/12/microsoft-dynamics-gp-manufacturing.html

No comments:

Post a Comment