Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have recently started exporting GL entries from our payroll software (Avanti) into GP. Occasionally, there is an account in the GL export file that does not exist in GP. When this happens the journal entry is created with no account number in the account field. I can fill in the appropriate account number but when I do this GP will never let me post the journal entry. It always gives an error saying 'debits and credits do not balance.' But this is not the case; the JE does balance. It's something to do with the blank account field. Is there something I can do to make sure these JEs post? Unfortunately, I can't fix it in my payroll software because Avanti treats GL accounts differently than GP. Avanti does not tie all 4 accounts segments together so it's possible for staff who are entering their expense claims to enter accounts that don't exist in GP. Thanks for your assistance.
Are you using IM for your import utility?
Yes our payroll software - Avanti - has an Integration Module that I use to export the journal entries.
If you are using IM, you could run an integration to create the missing account first and then go ahead with your import. An alternative is to create a suspense account to hold the transactions that do not have a good account. You can accomplish all of this with bits of VB script that you can insert at different parts of the integration.