Open Forum

Expand all | Collapse all

Shipped Not Invoice Field on Sales Header

  • 1.  Shipped Not Invoice Field on Sales Header

    TOP CONTRIBUTOR
    Posted 9 days ago
    On the Sales Order Header there is a field "Shipped Not Invoiced" that shows in About this Page as field 5751. A search tells me this field supports infrastructure and is only for internal use. I'm able to use fields on the Sales Order Line to report sales quantities and amounts that have shipped but are not invoiced and that are still outstanding. However, we're curious about the header field. Does anyone know how this field 5751 is used or calculates?

    #Technical
    #NAV 2018

    ------------------------------
    Noreen Fujita-Sacco
    Applications Coordinator
    Coghlan's/Gear Aid
    Bellingham WA
    360-392-2703
    noreen.fujitasacco@gearaid.com
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Shipped Not Invoice Field on Sales Header

    Posted 8 days ago
    we have NAV 4.03, so really old and may not be the same but the one thing we learned is that field is triggered to invoiced by the act of initiating a post- so even if the post does not go through for some reason, it will consider the item invoiced- because I believe when you hit "post", the invoice number is assigned (a the start of the process)  This caused us to have some orders in "limbo" when we relied only on the sales header ship not invoiced field to look for orders that needed to be posted.

    ------------------------------
    Jeanmarie curley
    quality biological
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Shipped Not Invoice Field on Sales Header

    TOP CONTRIBUTOR
    Posted 8 days ago
    5751 is a calculated field with this formula:
    Exist("Sales Line" WHERE (Document Type=FIELD(Document Type),Document No.=FIELD(No.),Qty. Shipped Not Invoiced=FILTER(<>0)))​

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


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