We have recently switched to using the GST module in Navision for our GST. We have multiple companies set up, each under a different dimension. There are 2 types of GST, NZ & AUST, and in this instance 2 companies, a NZ one and an AUST one.
We have separate GL codes for the AUST GST, (specified in the GL to use the AUST company dimension) and our normal GL codes for NZ gst (specified to use the NZ company dimension).
When the system completed its calc and post it correctly removed the GST from the NZ codes and put it into the settlement account in the NZ company. However, for the AUST gst, it also correctly moved the GST from the GL codes in the AUST company (dimension), but put it into the NZ company settlement account. As a result my Trial Balance for both the Aust & NZ companies are out by the AUST gst settlement amount.
As far as I am aware one sided journal entries are impossible, I tried entering a GL journal to correct just moving it from one dimension to the other, but of course the rules do not allow a one sided journal within a dimension.
So 3 questions:
Firstly, how was NAV able to override the rules in place to put this journal through?
How can I fix it?
And how can I stop it from happening again?