Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GL Batch posting issue...
Finance | Project Operations, Human Resources, ...
Unanswered

GL Batch posting issue - additional transactions created

(1) ShareShare
ReportReport
Posted on by ChrisP 325

Hi all, I have a very perplexing problem. A 3rd party software interface creates GL batches that are then posted by my customer. The batch seems to be fine and all the transactions post properly. However, somehow - after posting -  the GL10000 and GL10001 tables get populated with batch information related only to the transactions that post to the account associated with the bank. As an example, the batch contains a transaction that debits the cash account and credits the A/R account. After posting, the GL10001 table contains all of the transactions associated with the cash account, and creates two transactions for each of the transactions with both a credit and debit to the cash account. The descriptions are changed so the debit is "Bank Transaction Entry" and the Credit is "Other Account". The GL10000 table has the batch name. The SY00500 table is cleared out. So after this happens it appears that the batch has been posted (and it has). The user sees no error messages.

The issue occurs after we run checklinks. Then the utility sees that there are these items in the GL10000 and GL10001 tables, and stuffs the batch name in SY00500. However, there are numerous missing fields in the GL10000 table such as posting year, series and more. Now, I can go into the SQL tables and clear out all these items. However, new ones will  show up in the same pattern when new GL batches are posted and we do another checklinks. In GP you then see the batches but it says there are no transactions. However, there are in the tables mentioned but data isn't complete.

Again, note that all of the transactions do post, it's just that the ones tied to the cash account "come back in" somehow. I need to stop this from happening as we run the utility after updates and upgrades. The customer has GP2016. We will be upgrading them to GP2018 later this year. BTW, the vendor claims they've never seen this happen before but they also are only looking in GP, not the SQL tables. Their solution is to just delete the batches. This, however, does not fix the problem. If I delete the batch via GP and run checklinks again the issue pops back up.

Can anyone help? I've never seen this sort of thing before. I do have xls files with specific examples for both GL tables.

Categories:
Microsoft Dynamics GP
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Batch posting issue - additional transactions created

    If check links is creating new batches that means this third-party application has already populated your databases with bad records. So you can either create a test company and have someone examine the tables or ship your data to one of us where we can set up a mirror image of your GP installation. Either way it would be a billable event.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Batch posting issue - additional transactions created

    This would be a bit involved. It work best if you made a test company and restored your production company over the test company. Then you import your transactions, print an edit list, run check links then print the edit list again to look for any differences. All the while you examine the GL10000 and GL10001 tables. Do you have anyone on staff who can execute SQL scripts? Can your reseller help or perhaps someone from this third-party vendor? If you are paying for maintenance they should provide assistance. We could certainly help but that would become a billable event. This is more than just loading files. We would need to see what is happening as the process progresses.

  • ChrisP Profile Picture
    ChrisP 325 on at
    RE: GL Batch posting issue - additional transactions created

    aggh, I see this looks like a mess; I'm happy to upload files if someone will tell me how to do so!

  • ChrisP Profile Picture
    ChrisP 325 on at
    RE: GL Batch posting issue - additional transactions created

    Thank you. The version of GP being run is one they (3rd party) (their subsidiary) installed. I was incorrect. The GL10000 table does not have the name of the batch. I will ask the controller to print an edit list before she posts. If I run checklinks before posting it will pull in additional batches that now exist since the last time we ran checklinks and she will scream as another 20 batches will be added to the list of almost 400!  Because of the transactions found in GL10001, checklinks will recreate batches in the SY00500 table and the GL10000 table. I don't quite see how to upload files at this point, however. So I'm pasting items from my spreadsheets.

    The first item is the GL10000 table associated with the batch before posting

    BACHNUMB BCHSOURC JRNENTRY RCTRXSEQ SOURCDOC REFRENCE TRXDATE RVRSNGDT RCRNGTRX BALFRCLC PSTGSTUS LASTUSER LSTDTEDT USWHPSTD TRXTYPE SQNCLINE GLHDRMSG GLHDRMS2 TRXSORCE RVTRXSRC SERIES ORPSTDDT ORTRXSRC OrigDTASeries DTAControlNum DTATRXType DTA_Index CURNCYID CURRNIDX RATETPID EXGTBLID XCHGRATE EXCHDATE TIME1 RTCLCMTD NOTEINDX GLHDRVAL PERIODID OPENYEAR CLOSEDYR HISTRX REVPRDID REVYEAR REVCLYR REVHIST ERRSTATE ICTRX ORCOMID ORIGINJE ICDISTS PRNTSTUS DENXRATE MCTRXSTT DOCDATE Tax_Date VOIDED Original_JE Original_JE_Year Original_JE_Seq_Num Correcting_Trx_Type Ledger_ID Adjustment_Transaction DEX_ROW_TS DEX_ROW_ID
    IUS 33950       GL_Normal       6183 0 GJ          iOne Transfer to GL             00:00.0 00:00.0 0 0 1 WS_MHUFF        00:00.0                 0 0 0x00000000 0x00000000                             2 00:00.0               0                       0 618359763.1 USD             1000                                 0 00:00.0 00:00.0 0 21604 0x06000000 7 2021 0 0 0 0 0 0 0 0       0 0 1 0 0 00:00.0 00:00.0 0 0 0 0 0 1 0 36:04.0 6476

    This is the GL10001 table for this batch before posting (not the number of items, only 5 of which are posting to the cash account (ACTINDX value of 4):

    BACHNUMB JRNENTRY SQNCLINE ACTINDX XCHGRATE DSCRIPTN GLLINMSG GLLINMS2 CURRNIDX GLLINVAL ACCTTYPE FXDORVAR BALFRCLC PSTNGTYP DECPLACS ORCTRNUM ORDOCNUM ORMSTRID ORMSTRNM ORTRXTYP OrigSeqNum ORTRXDESC DTA_GL_Status INTERID RATETPID EXGTBLID EXCHDATE TIME1 RTCLCMTD DEBITAMT CRDTAMNT ORDBTAMT ORCRDAMT DENXRATE MCTRXSTT LNESTAT CorrespondingUnit DEX_ROW_TS DEX_ROW_ID
    IUS 33950       6183 500 24 0 Adjustment #217327              0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 442.4 0 442.4 0 0 5       36:03.9 42209
    IUS 33950       6183 1000 24 0 Adjustment #217330              0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 425.4 0 425.4 0 0 0 5       36:03.9 42210
    IUS 33950       6183 1500 126 0 Adjustment #217326              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 174.1 0 174.1 0 0 0 5       36:03.9 42211
    IUS 33950       6183 2000 132 0 Adjustment #217331              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 50 0 50 0 0 5       36:03.9 42212
    IUS 33950       6183 2500 137 0 Adjustment #217332              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 150.4 0 150.4 0 0 5       36:03.9 42213
    IUS 33950       6183 3000 136 0 Adjustment #217333              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 200 0 200 0 0 5       36:03.9 42214
    IUS 33950       6183 3500 133 0 Adjustment #217334              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 25 0 25 0 0 5       36:03.9 42215
    IUS 33950       6183 4000 127 0 Adjustment #217335              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 218.8 0 218.8 0 0 0 5       36:03.9 42216
    IUS 33950       6183 4500 146 0 Adjustment #217337              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 22 0 22 0 0 0 5       36:03.9 42217
    IUS 33950       6183 5000 147 0 Adjustment #217338              0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 27.5 0 27.5 0 0 0 5       36:03.9 42218
    IUS 33950       6183 5500 24 0 Charge #217328                  0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 137.63 0 137.63 0 0 0 5       36:03.9 42219
    IUS 33950       6183 6000 126 0 Charge #217329                  0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 58.4 0 58.4 0 0 5       36:03.9 42220
    IUS 33950       6183 6500 127 0 Charge #217336                  0x00000000 0x00000000 1000 0x01000000 1 0 0 1 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 79.23 0 79.23 0 0 5       36:03.9 42221
    IUS 33950       6183 7000 24 0 Payment #217319                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 2997.38 0 2997.38 0 0 5       36:03.9 42222
    IUS 33950       6183 7500 24 0 Payment #217321                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 2590.3 0 2590.3 0 0 5       36:03.9 42223
    IUS 33950       6183 8000 24 0 Payment #217323                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 6025.2 0 6025.2 0 0 5       36:03.9 42224
    IUS 33950       6183 8500 24 0 Payment #217325                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 24067.57 0 24067.57 0 0 5       36:03.9 42225
    IUS 33950       6183 9000 24 0 Payment #217340                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 0 88.6 0 88.6 0 0 5       36:03.9 42226
    IUS 33950       6183 9500 4 0 Payment #217318                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 2997.38 0 2997.38 0 0 0 5       36:03.9 42227
    IUS 33950       6183 10000 4 0 Payment #217320                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 2590.3 0 2590.3 0 0 0 5       36:03.9 42228
    IUS 33950       6183 10500 4 0 Payment #217322                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 6025.2 0 6025.2 0 0 0 5       36:03.9 42229
    IUS 33950       6183 11000 4 0 Payment #217324                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 24067.57 0 24067.57 0 0 0 5       36:03.9 42230
    IUS 33950       6183 11500 4 0 Payment #217339                 0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2                                                                                                                                               0 0                                 0 GPPRD                                 00:00.0 00:00.0 0 88.6 0 88.6 0 0 0 5       36:03.9 42231
    36774.48 36774.48

    Now, the GL10000 table is empty for this batch but the GL10001 table has the following:

    BACHNUMB JRNENTRY SQNCLINE ACTINDX XCHGRATE DSCRIPTN GLLINMSG GLLINMS2 CURRNIDX GLLINVAL ACCTTYPE FXDORVAR BALFRCLC PSTNGTYP DECPLACS ORCTRNUM ORDOCNUM ORMSTRID ORMSTRNM ORTRXTYP OrigSeqNum ORTRXDESC DTA_GL_Status INTERID RATETPID EXGTBLID EXCHDATE TIME1 RTCLCMTD DEBITAMT CRDTAMNT ORDBTAMT ORCRDAMT DENXRATE MCTRXSTT LNESTAT CorrespondingUnit DEX_ROW_TS DEX_ROW_ID
    IUS 33950       6184 16384 4 0 Bank Transaction Entry          0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3379 IUS 33950             CONCENTRATION                                                                                     0 1 iONE Payment #217318            0 GPPRD                                 00:00.0 00:00.0 0 2997.38 0 2997.38 0 0 0 5       47:20.2 42232
    IUS 33950       6184 32768 4 0 Other Account                   0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3379 IUS 33950             CONCENTRATION                                                                                     0 2 iONE Payment #217318            0 GPPRD                                 00:00.0 00:00.0 0 0 2997.38 0 2997.38 0 0 5       47:20.2 42233
    IUS 33950       6185 16384 4 0 Bank Transaction Entry          0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3380 IUS 33950             CONCENTRATION                                                                                     0 1 iONE Payment #217320            0 GPPRD                                 00:00.0 00:00.0 0 2590.3 0 2590.3 0 0 0 5       47:20.3 42234
    IUS 33950       6185 32768 4 0 Other Account                   0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3380 IUS 33950             CONCENTRATION                                                                                     0 2 iONE Payment #217320            0 GPPRD                                 00:00.0 00:00.0 0 0 2590.3 0 2590.3 0 0 5       47:20.3 42235
    IUS 33950       6186 16384 4 0 Bank Transaction Entry          0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3381 IUS 33950             CONCENTRATION                                                                                     0 1 iONE Payment #217322            0 GPPRD                                 00:00.0 00:00.0 0 6025.2 0 6025.2 0 0 0 5       47:20.3 42236
    IUS 33950       6186 32768 4 0 Other Account                   0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3381 IUS 33950             CONCENTRATION                                                                                     0 2 iONE Payment #217322            0 GPPRD                                 00:00.0 00:00.0 0 0 6025.2 0 6025.2 0 0 5       47:20.3 42237
    IUS 33950       6187 16384 4 0 Bank Transaction Entry          0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3382 IUS 33950             CONCENTRATION                                                                                     0 1 iONE Payment #217324            0 GPPRD                                 00:00.0 00:00.0 0 24067.57 0 24067.57 0 0 0 5       47:20.3 42238
    IUS 33950       6187 32768 4 0 Other Account                   0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3382 IUS 33950             CONCENTRATION                                                                                     0 2 iONE Payment #217324            0 GPPRD                                 00:00.0 00:00.0 0 0 24067.57 0 24067.57 0 0 5       47:20.3 42239
    IUS 33950       6188 32768 4 0 Other Account                   0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3383 IUS 33950             CONCENTRATION                                                                                     0 2 iONE Payment #217339            0 GPPRD                                 00:00.0 00:00.0 0 0 88.6 0 88.6 0 0 5       47:20.4 42241
    IUS 33950       6188 16384 4 0 Bank Transaction Entry          0x00000000 0x00000000 1000 0x01000000 1 0 0 0 2 3383 IUS 33950             CONCENTRATION                                                                                     0 1 iONE Payment #217339            0 GPPRD                                 00:00.0 00:00.0 0 88.6 0 88.6 0 0 0 5       47:20.4 42240

    Note that the GL10001 table has balanced transactions all going to the cash account (ACTINDX4). None of the other transactions were pushed into here. The DSCRIPTN field has changed from the original values. The original values were pushed to the ORTRXDESC field.  

    If I run checklinks at this point the batch will get pushed into the SY00500 table and also the GL10000 table (with some missing values. However, here is one record that WAS created after this batch was posted and checklinks was run. The series is missing, the year, and more are also missing.  :

    BACHNUMB BCHSOURC JRNENTRY RCTRXSEQ SOURCDOC REFRENCE TRXDATE RVRSNGDT RCRNGTRX BALFRCLC PSTGSTUS LASTUSER LSTDTEDT USWHPSTD TRXTYPE SQNCLINE GLHDRMSG GLHDRMS2 TRXSORCE RVTRXSRC SERIES ORPSTDDT ORTRXSRC OrigDTASeries DTAControlNum DTATRXType DTA_Index CURNCYID CURRNIDX RATETPID EXGTBLID XCHGRATE EXCHDATE TIME1 RTCLCMTD NOTEINDX GLHDRVAL PERIODID OPENYEAR CLOSEDYR HISTRX REVPRDID REVYEAR REVCLYR REVHIST ERRSTATE ICTRX ORCOMID ORIGINJE ICDISTS PRNTSTUS DENXRATE MCTRXSTT DOCDATE Tax_Date VOIDED Original_JE Original_JE_Year Original_JE_Seq_Num Correcting_Trx_Type Ledger_ID Adjustment_Transaction DEX_ROW_TS DEX_ROW_ID
    IUS 33933       GL_Normal       6000 0 GJ          Check links trx reference       00:00.0 00:00.0 0 0 0                 00:00.0                 0 0 0x00000000 0x00000000                             0 00:00.0               0                       0 0 USD             1000                                 0 00:00.0 00:00.0 0 0 0x00000000 6 0 0 0 0 0 0 0 0 0       0 0 0 0 0 00:00.0 00:00.0 0 0 0 0 0 1 0 09:57.9 6332
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Batch posting issue - additional transactions created

    I would check with the provider of this third-party software and make sure the version of GP you are running matches the version of their software. It sounds like records are being written to the GL100001 table with no corresponding records in the GL10000 table. It would take some analysis to figure out what is going on. Take a snapshot of the GL10000 and GL10001 tables before and after the import. Print an edit list to check for errors. Run check links before posting and then again after. Troubleshooting can be such fun. Let us know what you find.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans