Negative stored as Debit

  • Negative stored as Debit

    Posted by DSC Communities on January 23, 2017 at 7:38 pm
    • Robert Sekley


      January 23, 2017 at 7:38 PM

      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


      January 24, 2017 at 9:26 AM

      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

    DSC Communities replied 6 years, 8 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!