This week’s Management Reporter tip for Microsoft Dynamics ERP is on P&L Check Figure.

Ever wonder if you are pulling all the GL accounts and your formula is working correctly in your P&L row definitions? Add a check figure to validate and warn you if there are accounts missing, duplicated, or if the formulas are wrong. The first step is to add a non-printing check figure to add up all your P&L accounts. Now, add a row that subtracts the calculated net income from the check figure and make it non-printing if it is zero. Caution: If using a tree with the P&L, this will not check to make sure all departments are in the tree.


This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please visit our calendar to register for an event.

Be sure to subscribe to our blog so you don’t miss next week’s tip.