Open Forum

Expand all | Collapse all

Sales Header Does Not Exist

  • 1.  Sales Header Does Not Exist

    Posted 20 days ago
    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 20 days ago
    Edited by Lewis Rosenberg 20 days ago
    ​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 20 days ago
    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 19 days ago
    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 18 days ago

    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
    ------------------------------