Open Forum

 View Only

View My Drafts

  • 1.  System Message 6909 on WrkPost table on AP Batches

    SILVER CONTRIBUTOR
    Posted Feb 23, 2022 02:58 PM
    The client which is on older version of SL and is getting the following error message when trying to post AP batches to the General Ledger: 

    System Message 6909- Another process has already added the wrkpost item. The program must be terminated.

    I have tried to find any issue that could have caused this to occur but cannot find out why. AP batches before, after and between these batches posted without issue. 

    The only workaround that has worked was to delete and reenter the AP Journal Entry in a new batch. 

    There must be a reason why the issue is occurring. 

    Any thoughts would be appreciated. 




    ------------------------------
    David Safstrom
    Senior Consultant
    NexTec Group
    Houston, TX / Roswell GA
    ------------------------------


  • 2.  RE: System Message 6909 on WrkPost table on AP Batches

    TOP CONTRIBUTOR
    Posted Feb 23, 2022 03:50 PM
    That may be an issue in SL 2011 that was fixed in SL 2015. Look after line 330 in the pp_01520 stored procedure. If you see this code:
    Left join VW_AcctXRef vw on t.cpnyid = vw.cpnyid and vw.acct = '000000'

    Alter the stored procedure and change that line to:

    Left join VW_AcctXRef vw on v.cpnycoa = vw.cpnyid and vw.acct = '000000'


    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------

    Original Message