This week’s Management Reporter tip for Microsoft Dynamics ERP is on IF THEN ELSE.

IF THEN ELSE – This allows you to pull in data to other rows such as a negative asset account into the liability section of the balance sheet based on the value. Below is the formula for the asset section; copy the row to the liability section and reverse the sign in the formula.

Row Definition:


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 – Calculations on Hidden Columns.