These “new” interactive reports can be difficult to grasp in theory, so below is specific example I used on a recent implementation of this type of business logic check I blogged about a couple weeks ago. I built a report to enhance the Interfund Management module in Dynamics GP. My customer was okay with the module not specifically stopping illogical relationships between funds, only if they could be notified right away if something crossed from fund to fund where it should not cross. If it was not for this type of custom reporting, we would have been off to purchase an ISV solution that would have cost them roughly $2,500 a year plus additional implementation cost. Instead we built the solution you will see next week and kept them under there budget and completely happy.
So here it is – in this example I show how a control is put in place to control what Funds interact with each other in the General Ledger. It does not stop incorrect transactions, but it does tell the team very quickly if something is awry.