Open Forum

Expand all | Collapse all

Payable WORK transaction missing in batch

  • 1.  Payable WORK transaction missing in batch

    GOLD CONTRIBUTOR
    Posted 20 days ago
    Edited by Lydia Ebinyo Derri 20 days ago
    A batch of payable invoices were posted.  When user posted, an error appeared but they didn't not capture what that specific error said.  The end user can view the invoices from the batch posted to GL except for one transaction.  The specific invoice has a WORK status while all others show OPEN.  The batch ID is still visible in purchasing. When the end user goes to the batch's edit list report, there are messages for each invoice that shows the transactions has been posted except for that specific problem transaction. We tried to edit the batch in order to delete all the posted invoices and leave remaining the unposted transaction to we can attempt to post again within Purchasing / Transactions / Batches but that transaction is missing.  Remember, this transaction is visible within AP Edit list report but we cannot access to the transaction within the batch.

    PM10000 shows posting status as 20, posted shows 1, docprinted shows 1 for this invoice.

    How can we get access to the transaction to try to post again?

    GP2018R2

    ------------------------------
    Lydia Ebinyo Derri
    OSU Physicians, Inc
    Columbus OH
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Payable WORK transaction missing in batch

    TOP CONTRIBUTOR
    Posted 20 days ago
    Try accessing the problem transaction from PM Transaction Entry, delete it, and re-enter it.
    If that is not possible, you need to have a consultant to assist you in deleting the transaction from SQL.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Payable WORK transaction missing in batch

    TOP CONTRIBUTOR
    Posted 20 days ago
    Another option is to re-enter the transaction with a slightly different document number (like adding a dot) and process it, and fix the transaction later when your consultant is visiting to resolve other matters.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: Payable WORK transaction missing in batch

    TOP CONTRIBUTOR
    Posted 11 days ago
    HI @Lydia Ebinyo Derri
    You may have already resolved this, but ​my first question would be does the edit list show any kind of error for that transaction?  That would give you some idea as to why it didn't post.  You could them potentially edit that one transaction - and/or save it to a new batch - to allow the first batch to process through.
    Thanks
    Windi


    ------------------------------
    Windi Epperson
    President/GP Senior Consultant
    Advanced Integrators, Inc.
    norman OK
    405-946-1774 ext. 102
    ------------------------------

    GPUG Summit - Post


  • 5.  RE: Payable WORK transaction missing in batch

    SILVER CONTRIBUTOR
    Posted 7 days ago
    I would run checklinks on Payables Transaction Logical file, and then run Reconcile on the batch.​​

    ------------------------------
    Rochelle Mausteller
    Customer Care Specialist
    CSSI Technologies
    ------------------------------

    GPUG Summit - Post


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