Open Forum

Expand all | Collapse all

Cannot Invoice- SO not found

  • 1.  Cannot Invoice- SO not found

    SILVER CONTRIBUTOR
    Posted 6 days ago

    I have an unusual situation where an end-user altered a SO to change one item of three from a drop ship ($) to a sample (free). This was done after the PO was created and processed. Sales and purchasing were somehow able to push this through (manual tweaking suspected), and warehouse can now receive, post and invoice 2 of 3 items. That third item that was changed can be received but will not post and invoice. The error is- 

    "sales line does not exist. Identification fields and values"

    NAV is not wrong. The related SO has already been archived and cannot be restored. My question to you is whether there is anything at all that can be done to repair this. Its a zero dollar sale so really just a matter of housekeeping. I don't want to import these errors into our new system if it can be helped.

    Thanks for any thoughts,
    Devora




    ------------------------------
    Devora Locke
    Shin-Etsu MicroSi, Inc
    Phoenix AZ
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Cannot Invoice- SO not found

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hello Devora,

    We are running NAV 2015 and see this message randomly.  Check your purchase order to see if the open line of the PO is still tied to the sales order (sales order number and sales order line number).  If it is, you will want to remove the sales order information and the drop ship designation.

    Next, check your item ledger entries to see if both the purchase order receipt and sales order receipt have drop ship checked.  If they do not, you will need to correct one so they match.  (We reach out to our partner to un-check drop shipment from the table because we do not have a developer's license.)  If you do not, your table "Inventory by Location" will not calculate correctly for the corresponding item.

    Let me know if you have any questions.

    Thank you,

    ------------------------------
    Kristina Frank
    Controller
    Cline Tool & Services
    Newton IA
    ------------------------------

    Academy - Online Interactive Learning from Experts


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