My accounting clerk was booted out of Macola when entering a Sale Transaction debit memo in A/R. Somehow the transaction posted out of balance. Crediting 1226.08 and Debiting 885.82. I tried to put a credit in to clear it out but surprise (I already knew this) it wont let you post out of balance stating amounts not fully distributed do you wish to abort transaction. Does anyone know how to fix this? I cannot post from sub ledgers until this matter is fixed. Or can I???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AR DISTRIBUTION TO GL OUT OF BALANCE
- Thread starter jeaninski
- Start date
What version of Macola? SQL or Pervasive? You can post an out of balance entry but you have to go to GL setup to allow it first. More details are needed to fully answer your question.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Thread starter
- #3
Go to GL setup and allow out of balance postings.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Thread starter
- #5
Open item load under AR->Maintain.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
I recently worked on an issue that I believe is quite similar to this. We're on v9.5.400 currently, but these had been building up for years. My solution (working with the support of our VAR of course) was to create a journal entry to correct the G/L, and delete the transaction that was written in the banktransactions table to get the subledger back into balance.
I wouldn't reccommend doing this without very close suppervision from whoever is managing your database, but it did work. We cleared up 168 transactions.
I wouldn't reccommend doing this without very close suppervision from whoever is managing your database, but it did work. We cleared up 168 transactions.
jmgarrett,
The user is using Macola Progression which is completely different than Macola ES and in fact does not even have a backtransactions table.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
The user is using Macola Progression which is completely different than Macola ES and in fact does not even have a backtransactions table.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Thread starter
- #9
I was not able to post out of balance. I did click off the box in set-up to allow out of balance posting. It's strange because when I close the year I do a one sided entry for retained earnings and I've been able to post out of balance then. Wonder why I cant now?
When you say you were not able, how did this manifest itself? Did you get an error? If so what was the error?
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Status
Similar threads
