One of the employees while posting from subledger selected "re-interface distribution" checkbox also and what it did was to double or triple the entries in the gl. Is there a way to reverse or remove duplicate entries from GL? doing this manually is a big pain!!! We have progressions 7.6.300spb on sql. Thanks
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reversing GL postings
- Thread starter impress
- Start date
First things First. The only reason that checkbox is even available is that in GL Setup, the "Interface to G/L Journal Trx File" is checked. This should never be checked IMHO. What is does is twofold:
1) Rather than posting directly to the GL, it creates an unposted G/L Journal Trx batch, which must be posted manually.
2) It disables drilldown features of Macola's G/L.
If you can see an upside in either of those 2 situations, please let me know.
So First things First, change the flag in GL Setup, and this will never happen again.
On to your question, I know of know what to reverse an entry after the fact, as entries are normally defined as reversing entries (or not) at the time they are entered.
However, if you can isolate the duplicate and triplicate entries in question, then delete them from the GLTRXHST_SQL table, then run a recalculate GL Account Balances, you should be fine.
Having said all of that, I would definitely tread cautiously and try this in a test environment until you are sure this is the answer.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
1) Rather than posting directly to the GL, it creates an unposted G/L Journal Trx batch, which must be posted manually.
2) It disables drilldown features of Macola's G/L.
If you can see an upside in either of those 2 situations, please let me know.
So First things First, change the flag in GL Setup, and this will never happen again.
On to your question, I know of know what to reverse an entry after the fact, as entries are normally defined as reversing entries (or not) at the time they are entered.
However, if you can isolate the duplicate and triplicate entries in question, then delete them from the GLTRXHST_SQL table, then run a recalculate GL Account Balances, you should be fine.
Having said all of that, I would definitely tread cautiously and try this in a test environment until you are sure this is the answer.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
jdavissrusa
IS-IT--Management
Having been through the last weekend from hell of posting to the GL, I can agree the posting directly to the GL by-passing the G/L Journal Trx batch is the way to go. We used to post using the 2 step method.
We had a posting from G/L Journal Trx batch to the GL die in mid post and had to remove all if the inventory transactions from the GL for inv in that time period.
Removing and isolating the entries are fairly straight forward in SQL. If it is only from one module say "IM" you could search on the date range and the module.
Joe
We had a posting from G/L Journal Trx batch to the GL die in mid post and had to remove all if the inventory transactions from the GL for inv in that time period.
Removing and isolating the entries are fairly straight forward in SQL. If it is only from one module say "IM" you could search on the date range and the module.
Joe
One option is to delete all transactions that have been interfaced into the GLTRXFIL_SQL and GLTRXHST_SQL for the month (non manual journal entries) and repost the entire month. You would have to delete them through a SQL script though.
Kevin Scheeler
Kevin Scheeler
- Status
Similar threads
- Locked
- Question