Open Forum

View My Drafts

Back to discussions
Expand all | Collapse all

Suspended AR Payment application batch

  • 1.  Suspended AR Payment application batch

    SILVER CONTRIBUTOR
    Posted Jan 06, 2021 10:00 AM

    I have a payment application batch that is giving me  the error below:

    System Message 6124: Process started: Wed Jan 06 09:49 A.M.

    Module: 'AR'

    Batch: '493050'

    Processing: Module: 'AR' , Batch: '493050'

    System Message 12341: Inter-company account/subaccount was not found. The batch

                          cannot be released.

    System Message 6125: Process ended: Wed Jan 06 09:49 A.M.

     

    I am stumped (doesn't happen often) . I don't understand what the message is telling me.  It is time to ask for help.

    Looking at the intercompany accounts/subs set up in Multi-Company, all the accounts appear to be correct.
    Has anyone seen this message before.  Can you help.



    ------------------------------
    Mark Schrier
    Information Systems Director
    Mackay Communications, Inc
    Raleigh NC
    ------------------------------


  • 2.  RE: Suspended AR Payment application batch

    TOP CONTRIBUTOR
    Posted Jan 06, 2021 10:24 AM

    I'd first examine the Crtd_Prog and EditScrnNbr values in the Batch table row.

     

    -Jonathan




    Original Message


  • 3.  RE: Suspended AR Payment application batch

    GOLD CONTRIBUTOR
    Posted Jan 07, 2021 08:26 AM
    Have you tried running ARDebug?  This may help pinpoint the exact item causing the error.

    ARdebug 'batnbr'

    ------------------------------
    Karla Johnson
    System Architect
    Carrollton TX
    ------------------------------

    Original Message


  • 4.  RE: Suspended AR Payment application batch

    SILVER CONTRIBUTOR
    Posted Jan 08, 2021 11:16 AM
    Thanks to all for your help.
    Jonathan, you were correct as to the step in debug

    I added a new debug step (and then removed it later by recompiling the original PP_0840000)
    It printed out the contents of the WRK_GLtran table.
    Here I found a reference to the incorrect ARdoc.refnbr that caused the null return on the join.
    I corrected the ARtran (after confirming with our collections department
    I then corrected the ApplBatnbr and Applbatseq in the related ardoc rows.

    The batch released successfully
    and I know a lot more about PP_0840000

    I added this code after the error tram in the PP_0840000

    SELECT @Err=@@ERROR, @R_C=@@ROWCOUNT
    -- added code below
    IF (@Debug = 1)
    BEGIN
    PRINT CONVERT(VARCHAR(30), GETDATE(), 113)
    PRINT 'Debug...Step 3201: Intercompany trans - Intercompany pass one'
    SELECT *
    FROM WRK_GLTRAN t WHERE t.FromCpnyID <> t.CpnyID
    AND t.UserAddress = @UserAddress
    END

    From this I could see the problem clearly.

    ------------------------------
    Mark Schrier
    Information Systems Director
    Mackay Communications, Inc
    Raleigh NC
    ------------------------------

    Original Message


  • 5.  RE: Suspended AR Payment application batch

    TOP CONTRIBUTOR
    Posted Jan 07, 2021 09:42 AM
    Years ago we started having a similar issue.    We have many companies in our system, but do not run "mutli-company" as each database is stand-alone.    Even so, having many companies in the company table but not owning the mutli-company module (which technically isn't required) has caused a couple of issues.

    So every time I add a new database, I have to populate the SYTEMDB..Intercompany table with at least one record for each company record.    That record looks like:
    FromAcct FromCompany FromSub Module Screen ToAcct ToCompany ToSub User1 User2 User3 User4 tstamp
               AFG07                               ZZ                    AFG07                                                                                             0 0 0x000000000107B190

    Also, in the company table, we have to populate two fields in SQL for every company record.   These are not editable but are necessary for lookups to work properly.   Those are the screen columns labeled "Master Chart of Accounts" and Master Subacct Table".

    Not sure if this is your situation, but that's where I've seen this error before.

    ------------------------------
    Gail Jones-Nemeth
    Financial Systems Analyst
    Creative Associates Int'l
    Washington DC
    ------------------------------

    Original Message


  • 6.  RE: Suspended AR Payment application batch

    BRONZE CONTRIBUTOR
    Posted Jan 07, 2021 10:59 AM
    Is the account/subaccount combination a valid combination set up in the Account/subaccount Maintenance screen in the general ledger module?  That is usually the issue when we get errors like that.  ​

    ------------------------------
    Nancy Ludin
    Chief Accounting Officer
    MyPath Support Services
    Dousman WI
    ------------------------------

    Original Message


  • 7.  RE: Suspended AR Payment application batch

    SILVER CONTRIBUTOR
    Posted Jan 08, 2021 08:55 AM
    Absolute basics here, but I think many of us are guilty of overlooking them from time to time.  Did you verify that the accounts involved in the batch are available and active in the Acct and Sub table?  I've had this happen when the controllers remove something or inactivate something.

    ------------------------------
    Joe Miller
    Director of Systems Architecture
    Harrison, Walker & Harper
    Paris TX
    ------------------------------

    Original Message