Open Forum

Expand all | Collapse all

Header dates in NAV2018

  • 1.  Header dates in NAV2018

    Posted 10 days ago
    Hi All- I was wondering how people use the header dates in NAV in regards to posting date, doc date, shipment date etc
    We do alot of resell, so we often have a week or two elapse before we ship out an order. Right now the due date for the invoice calculates from the document date (the date we enter the order)- this causes issues because our agreement with the customer is the due date clock starts ticking from the date the order is shipped. How do you handle this?
    Also, ideally we would want the posting date to default to the date the shipment was posted and for the shipment date to default to the same. Is there a way to set this in NAV?
    Can you please clarify what happens to the posting date if we set the work date to equal to today
    Thank you
    Jeanmarie
    #Trade
    #Functional
    #NAV2018

    ​​

    ------------------------------
    Jeanmarie Curley
    Sr Director Bus Ops
    Quality Biological Inc
    Gaithersburg MD 20878
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Header dates in NAV2018

    SILVER CONTRIBUTOR
    Posted 10 days ago
    Hi Jeamarie,

    I have a customer that uses the Batch Post Sales Orders function when they post their sales orders which allows them to "Replace Posting Date" and "Replace Document Date". Their process is that the warehouse posts the warehouse shipment but they post the sales orders for invoicing as a separate step using this routine. I know this function exists in both 2015 and Business Central so would assume it is in 2018 as well. Below are a couple of screen shots from each version. I hope you find this useful.

    2015 Batch Post Sales Orders
    BC Batch Post Sales Orders
     
    Thanks,

    ------------------------------
    Jim Wilson
    Independent Consultant
    Launch Project Management Ltd
    Bolton ON
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Header dates in NAV2018

    TOP CONTRIBUTOR
    Posted 7 days ago
    Many companies set the default for the posting date to blank on the Sales & Receivables setup page.  This forces the user to enter the posting date at shipment which will then update the due date based on the posting date and the payment terms on the order.
    The shipment date on the sales order is NOT the date the order ships it is the date the order is planned to be packed for shipment and the date that drives the demand for planning. There are modifiers like outbound warehouse handling time and deliver time that will effect the shipment date.  The actual date shipped is usually identified as the posting date of the posted sales shipment.

    ------------------------------
    Kevin Fons
    Senior Application Consultant
    Innovia Consulting
    Windsor WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Header dates in NAV2018

    Posted 7 days ago
    Thank you both for your replies. They are very helpful. I guess, when looking at a posted sales invoice to sell to the customer, we interpreted that date as the date the order shipped to them and did not know if it would cause confusion on their side of things.
    I appreciate the responses!

    ------------------------------
    Jeanmarie Curley
    Sr Director Bus Ops
    Quality Biological Inc
    Gaithersburg MD 20878
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Header dates in NAV2018

    GOLD CONTRIBUTOR
    Posted 7 days ago
    Posting Date is the GL/sub-ledger effective date, so generally you want that to be the actual date the transaction occurred.  Document Date is used as the Invoice Date and thereby affects the "Due Date" of the invoice.  So it is possible that on August 5, you are completing an invoice that occurred on 7/31.  I would suggest setting Posting Date to 7/31 and Document Date to 8/5 (otherwise, it will age it as of 7/31 which may cause your customer to complain that you are not actually giving them the full term period to pay the invoice.
    Ultimately, different organizations use these differently as there are multiple options and reasons for changing how you set these fields.  My suggestion is to use a "Sandbox" environment to play around and test various scenarios and document what happens so that you can train people on the best way to use these for your organization.

    ------------------------------
    Ken Sebahar
    Solution Systems, Inc.
    ken@solsyst.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


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