This past month we completed a large Microsoft Dynamics GP project in Minnesota where unique requirements drove us to support a framework within Great Plains that supports multiple legal entities within a single SQL Server database.
This is where the power of Microsoft Dynamics GP comes into play. As it turns out, there is a single intervention point within GP that handles the posting of all GL entries. We had one GL segment dedicated to legal entity. All we had to do was to add a trigger to the posting of all general ledger entries that checked the balance of debits and credits by legal entity. If the debits and credits did not equal by legal entity, then this solution automatically added "due to" and "due from" entries to balance the journal entry, just before the entry finished posting. Then the posting contined through, and the intercompany affect was realized.
A great project, a great success. Time to celebrate.