Open Forum

Expand all | Collapse all

Batch Hung up, need to delete

  • 1.  Batch Hung up, need to delete

    TOP CONTRIBUTOR
    Posted 17 days ago
    I have a Payables Batch that I cannot access it to delete it.  The issue of the real data has long since been resolved.  I just need to get rid of this item in the display.  I am not sure what GP2015 table it is in.  It is a batch from August of 2018.


    ------------------------------
    Thomas Hill
    Staff Accountant
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Batch Hung up, need to delete

    GOLD CONTRIBUTOR
    Posted 17 days ago
    Edited by Gerald Buenafe 17 days ago
    Hi Thomas,

    From the screenshot, the highlighted batch is a computer check batch in remittance processing stage. Are you able to check if that batch is accessible via Transactions >> Purchasing >> Process Remittance >> Lookup (i.e. just see if it is listed in the lookup window)?

    SQL table-wise:
    • PM10300 - computer check trx table
    • PM10100 - distribution table
    • PM10200 - pm apply table
    • SY00500 - batch header table

    On a side note, rather than deleting the batch via the SQL tables outright... resetting the batch status to available (via SQL - update SY00500), then deleting the batch via GP Payables Batch window might be a better option. Here are some related KB articles:

    KB - How to continue a check run that was interrupted in Payables Management in Microsoft Dynamics GP
    https://support.microsoft.com/en-ph/help/852064/how-to-continue-a-check-run-that-was-interrupted-in-payables-managemen

    KB - A batch is held in the Posting, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP
    https://support.microsoft.com/en-us/help/850289/a-batch-is-held-in-the-posting-receiving-busy-marked-locked-or-edited

    *** Make sure to have a backup before you proceed...

    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Batch Hung up, need to delete

    TOP CONTRIBUTOR
    Posted 17 days ago
    Great explanation.  I have printed the email to do these steps.  I am out all of next week.  But once we have closed November I will explore this.  I want to try to clean up before the end of the year.  Have a great week next week.

    ------------------------------
    Thomas Hill
    Staff Accountant
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role