Open Forum

Expand all | Collapse all

Sales batch is interrupted while posting. Invoice is not posted to History.

  • 1.  Sales batch is interrupted while posting. Invoice is not posted to History.

    Posted 13 days ago
    Edited by HAITAO YU 13 days ago
    Hello everyone,

    I have a sales invoice batch that was interrupted while posting and I was able to unmark the batch from posting with SQL query
    update sy00500 set MKDTOPST = 0, BCHSTTUS = 0 where BACHNUMB = 'xxx'
    then repost all other invoices in the batch but one.

    This invoice is still open, but the products on it have been removed from inventory.
    I was able to find the invoice number under Item Transaction Inquiry, but when trying to zoom in by clicking on the "Number", it shows the error message "This document has been removed from Sales Order Processing history". The same error message appears when I look up the invoice number under the Receivable Transaction Inquiry and Sales Documents Inquiry window in the "Unposted" option.

    I have tried "Reconcile-Remove Sales Documents" and Check Links for Sales (Sales work/Sales history/Receivable open transaction files/Receivable transaction history), it did not work. There is no record exist in the Batch Recovery sales series.

    There are a few things found in the SQL tables:
    The invoice record exists in open sales transaction tables SOP10100, SOP10200, SOP10201/ receivable tables RM00401, RM20101,
    The invoice record does NOT exist in history tables SOP30200, SOP30300/ RM0301, RM30301.
    The PSTGSTUS value in my SOP10100 table for this invoice is 252.

    It seems that the inventory was updated, and records have been created in receivable tables, but it was interrupted when moving records to sales history tables and deleting them from open tables.

    Any help or suggestion is appreciated!

    ------------------------------
    Haitao Yu
    IT Manager
    Gold Coast Ingredients, Inc
    Commerce CA
    ------------------------------
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 2.  RE: Sales batch is interrupted while posting. Invoice is not posted to History.

    TOP CONTRIBUTOR
    Posted 13 days ago
    Since the invoice has been posted and is complete but did not move to history, set the SOP10100.SOPSTATUS = 0 and the SOP10100.PSTGSTUS = 0.
    Make sure there are no table dex locks by bringing it up in the GP UI and saving it in a new Batch by itself. Delete the old batch. At that time verify that the sop doc is completed.
    Then run your Sales Utility Reconcile/Remove Sales Documents to History using the Remove for that specific document

    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 3.  RE: Sales batch is interrupted while posting. Invoice is not posted to History.

    Posted 9 days ago
    Thank you for the reply, Thaddues,

    I tried to update the SOP10100.SOPSTATUS = 0 and the SOP10100.PSTGSTUS = 0, then Reconcile/Remove Sales Documents to history, it did not work. The report shows no record was updated, and the invoice is still open.

    One thing I have noticed is that the fulfilled QTY and selected lots still exist on the invoice, even all products were removed from the inventory. (may because the records still exist in sop10201 table). And when I run the edit list for the new batch with this invoice, it shows the error message "Lot number does not exist for this item/site".

    Thank you,


    ------------------------------
    Haitao Yu
    IT Manager
    Gold Coast Ingredients, Inc
    Commerce CA
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 4.  RE: Sales batch is interrupted while posting. Invoice is not posted to History.

    TOP CONTRIBUTOR
    Posted 9 days ago
    So now that you have the invoice in a batch and can access it in the UI you will need to resolve that error message and complete the invoice. Then you can remove it to history. Start by figuring out why the lot number for the item site does not exist. Did someone delete it in SQL? Was it supposed to be a different lot number. You say the Item was relieved from the site. What lot number was used to do that? Look in the Item transaction inquiry. Many many things...

    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 5.  RE: Sales batch is interrupted while posting. Invoice is not posted to History.

    Posted 9 days ago
    The invoice was fulfilled completely before posting and but it was "halfway through" due to the interruption while posting.
    The PSTGSTUS in SOP10100 was 252.

    On the inventory side, the correct fulfilled lot numbers were posted. I can look up those transactions under Item Transaction Inquiry.
    But on the sales side, because it was not moved to the history, when trying to zoom in by clicking on the "Number", it shows the error message "This document has been removed from Sales Order Processing history".

    The lot numbers still show fulfilled on this invoice just because the records in SOP10201 were never moved to the history table.
    They actually do not exist anymore in the inventory. If I try to remove those lot numbers from this invoice, they will not be available anymore.

    I think I am looking for a way/SQL query to properly move the open invoice records to the history table SOP30200/SOp30300 and delete it from SOP10100/SOP10200.

    Thank you for any input.





    ------------------------------
    Haitao Yu
    IT Manager
    Gold Coast Ingredients, Inc
    Commerce CA
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


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