Open Forum

Expand all | Collapse all

Sales Header Does Not Exist

  • 1.  Sales Header Does Not Exist

    Posted Nov 28, 2018 01:41 PM
    We are trying to close orders that are still open from when we launched in August.  When I attempt to invoice these orders I get the sales header does not exist error.  I have tried deleting the lines, but there are shipments posted against them.  Anyone have a suggestion on how we might fix this?

    ------------------------------
    Carrie Cottle
    Greenhouse Megastore
    Danville IL
    ------------------------------


  • 2.  RE: Sales Header Does Not Exist

    TOP CONTRIBUTOR
    Posted Nov 28, 2018 02:16 PM
    Edited by Lewis Rosenberg Nov 28, 2018 02:17 PM
    ​I think I saw this scenario once.  I would try to create a sale header record in table 36 (using the object designer in the development environment) for the order that has lines, but no header and then see if you can delete or finish processing the order.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    -----------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl/
    ------------------------------



  • 3.  RE: Sales Header Does Not Exist

    Posted Nov 28, 2018 02:35 PM
    Thank you.  We do not have access to this due to our host.

    ------------------------------
    Carrie Cottle
    International Greenhouse Company
    Danville IL
    ------------------------------



  • 4.  RE: Sales Header Does Not Exist

    Posted Nov 29, 2018 09:18 AM
    Do you have access to the database? You could do the same thing through SQL.

    I would only attempt that as a last resort though. So many things in NAV are tied together that doing an INSERT in a SQL table may not apply things in other tables that need them in order to function.

    ------------------------------
    Matthew Miller
    Farmers Investment Co
    Sahuarita AZ
    ------------------------------



  • 5.  RE: Sales Header Does Not Exist

    TOP CONTRIBUTOR
    Posted Nov 30, 2018 12:45 PM

    Have you tried to undo Shipments, then ship it again using the same date. You should now be able to invoice.
    Otherwise do the undo shipment again, delete the order. Create a new order with the same date to finish it up.
    Good luck.



    ------------------------------
    Geovanny Fuentes
    San Diego CA
    ------------------------------



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