How to enter a one-sided entry?

[35mph]

Our GL was in balance before we ran GL year-end, but after doing so, our AP balance is incorrect, resulting in an out-of-balance GL.

For now, is there a way to enter a one-sided entry?

Thanks!

 

[jazgeek]

no, that's against every accounting principal out there.

-----------
and they wonder why they call it Great Pains!

jaz

 

[GPSKid]

Try this, go to Great Plains Techknowledge and Search on "Ending Balance Differs from Beginning Balance After Year End Closing" or "Trial Balance is Out of Balance"

 

[35mph]

Thanks GPSKid... we have seen those TKs and are about to dig in a see if they'll help.

jazgeek, you are correct about the rules of accounting... unfortunately, sometimes hardware and software doesn't comply. We also work with other accounting software that EASILY lets us enter a one-sided entry... with a warning and a password required.

From time to time, we are confronted with the comment: "Why in the world would you want to enter a one-sided entry?" The answer is that we may not want to, but sometimes we HAVE to... not because of erroneous accounting practices, but because of situations imposed on us by computing hardware and software.

If everyting else is correct, we simply make that one-sided entry, print out the journal listing, notate the reasoning, and move on.

 

[Luvsql]

It should also be against accounting principals that an accounting system can allow a general ledger to go out of balance. Posting interruptions, blah blah, should never happen in a sql environment with properly written applications. If the total transaction does not commit to the very end, it should roll back.

 

[stef315]

Is the detailed trial balance out of balance also or just the summary? If it's just the summary you should be able to run reconcile (Utilities-Financial-Reconcile) on all open years starting with the oldest.

If it's the detailed trial balance also, you can either do a JE to a "dummy" account as GP suggests or have your partner use the GL Delete tool to delete the unbalanced entry which you would then re-key the intended JE.

Pretty much the only way to fix it is the GL Delete tool. Before doing this though, double check that you are running the report with no account or segment restrictions, not including unit accounts, and including inactive accounts.