[Robert Sekley]

I recently had negative amounts posted and stored as Debits.  This resulted from retroactively posting adjustments using variable allocation accounts.  In the prior periods  some of the unit accounts used in the allocation had zeros as values.   The allocation process could not handle this and posted erroneous debits in some accounts and an offsetting negative (as  debit) in another account. In total we balance, but individual entries are not correct.

The question is, will this negative cause me issues down the road?  Or should I go in and delete these records from the table and reconcile the year, then re-enter the allocations manually?  Or leave them and post adjusting entries to correct it leaving the negatives as debits.

Any thoughts?

——————————
Robert Sekley
Red Dot Storage
Louisville CO
——————————

[Bridget Sandlin]

I recently saw a similar issue in client data. I can’t say whether this will cause an issue down the road since the data I reviewed was still in an open year, but rather than risking an issue during year-end close, I opted to correct the value via SQL by moving the negative debit to a positive credit value in the GL20000 and then reconciling.

My recommendation is to delete or correct via SQL. I do not recommend leaving the negative debits.

——————————
Bridget Sandlin
Informed Systems, Inc.
Blue Bell PA
——————————
——————————————-