Bad title perhaps; I’m not an accountant, but they’ve asked me why and I don't know.
Not sure how to explain this since, but basically they’re saying somehow the transaction was processed with negative GST. In the Journal it shows the #’s reversed for this 1,149.91
All others look like this (Debit left column, Credit right):
There’s hundreds as above, but this one below the values are in the opposite accounts and no one appears to know how this happened (including myself):
Anyone able to please enlighten me on what may have gone wrong?
Best answer by nmizzell9000
Makes sense that a credit memo or reversion entry would have the debits and credits flipped.
The flipped transactions can only be one of the following:
Credit memo, void or reversal - Likely what these transactions are
User error - claims this is not the issue
System error - if the transactions are auto posted, perhaps a setting has been changed to reverse some of the entries erroneously.
Either way, if these entries are an issue and lead to incorrect totals, a reversal to the reversal entry may be booked to zero out the bad entries.
Posted manually into acumatica? - If so, maybe the accountant mistakenly reversed the debits and credits in the system.
Using velixo writeback? - User error, reversed debits and credits in the upload template. Maybe the import scenario has changed causing debits and credits to be reversed?
Using a 3rd party integration? - Could be an issue with the integration or how the user interacted with the data to get it posted.
In summary, looks like a user error unless it's an entry that is automatically created. In that case it might be an issue with the data used to create the entry or an issue with the system used to make the entry.
Posted manually into acumatica? - If so, maybe the accountant mistakenly reversed the debits and credits in the system.
Using velixo writeback? - User error, reversed debits and credits in the upload template. Maybe the import scenario has changed causing debits and credits to be reversed?
Using a 3rd party integration? - Could be an issue with the integration or how the user interacted with the data to get it posted.
In summary, looks like a user error unless it's an entry that is automatically created. In that case it might be an issue with the data used to create the entry or an issue with the system used to make the entry.
Thanks for the response @nmizzell9000 … it was manually entered; the accountant says they did it correctly though ;) Most of the issues we end up with are revolving around retainage. This one has retainage from multiple invoices; some of those were dual payments made, then credit memo or voided payment to correct. I think I should drop this back to the accounting side and have them work through the system and find every entry that affects this until they find the one that was done wrong.
