Open Forum

Expand all | Collapse all

Invoice will not post

  • 1.  Invoice will not post

    Posted Mar 26, 2019 11:08 PM
    All: I have a highly technical issue with an invoice. An issue occurred during the posting of the invoice and it is now in limbo.  The order is in the history table, sop30200, but the invoice is in the order work table, sop10100. I ran sales edit list report, where is shows some parts are missing serial numbers.  I queried the IV00200 and they are in fact missing.

    At this point, my suspicions is that  we need to get the serial numbers back into the iv00200 table so that the posting can proceed. Anyone on this forum have an idea how to do this without having to execute a manual SQL statement? Or if SQL is the only route, what other tables should get updated?

    Best,

    Rafael Guerrero
    Gnnovation, Inc.

    ------------------------------
    Rafael Guerrero
    Gnnovation, LLC.
    plano TX
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Invoice will not post

    Posted Mar 27, 2019 05:36 AM
    Rafael,
    Check the SOP10201 (Serial Lot work and History Table for SOP) table for the order number in the SOP10100 that you are having issues with.  It could be the order in the line in the SOP10201 did not flop to an invoice when it was transferred.  If that is the case update the record to the correct invoice (SOPNUMBE) number and SOPTYPE.
    Good luck,
    Neil

    ------------------------------
    Neil Vidt
    Database Analyst 2
    Dynavox Technologies
    Pittsburgh PA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Invoice will not post

    GOLD CONTRIBUTOR
    Posted Mar 27, 2019 08:34 AM
    Rafael,

    You can try running checklinks on the sales and inventory tables (in a test company first) to fix the corruption.  But, I'm quite sure this won't fix it.  This should confirm your question that someone will need to write some SQL scripts to fix it.

    As far as finding the tables to update...   Victoria Yudin's site is an awesome reference.  But, you don't want to give this task to anyone who doesn't already know the tables.  Your partner should be able to deal with this if you don't have the skill on staff.

    This is a fairly common issue.  Good luck!

    Chris

    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Invoice will not post

    SILVER CONTRIBUTOR
    Posted Mar 27, 2019 09:07 AM
    I would run Checklinks first. before messing in SQL.
    Jeff

    ------------------------------
    Jeff Strait
    Ideal Deals, LLC dba Ideal Aluminum Products
    St. Augustine FL
    ------------------------------

    Conference-GPUG_200x200


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