web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Automatically Offset Field values on Sales Orders

(1) ShareShare
ReportReport
Posted on by 183
I have received a request to offset three different fields on a Sales Order by default and I was wondering if there is an Administration setting page or possibly elsewhere like where on a Customer Card that I can go to do this on and what it is called if there is such a page.
 
The fields are:
  • Shipment Date - This is an item line field on the Sales Order.
  • Requested Delivery Date - This is a header field on the Sales Order.
  • Planned Delivery Date - This is an item line field on the Sales Order.
My intention was to apply Today's date + 3 days on them after I select a customer on a new Sales Order. I would like to avoid having to enter the values manually each and every single time I create a new Sales Order in Business Central.
 
My troubleshooting so far:
  • On the Customer Card, I went to the Shipping section and added the code 3D on the Shipping Time field. Result: I see Shipping Time 3D on the sales order but it did not offset the 3 fields when expected to.
  • I saw the Order Promising Lines window but I don't quite understand how to use this properly.
My understanding was that when a requested delivery date is set, the planned shipment date is calculated by subtracting the shipping time off of it. And when outbound whse. handling time is subtracted from a planned shipment date, the shipment date is calculated too. I am unsure if this is something that is configurable or predefined and unable to be changed.
 
Your help is much well appreciated.
I have the same question (0)
  • Verified answer
    Ben Baxter Profile Picture
    6,616 Super User 2025 Season 2 on at
    On your Location card (or Inventory Setup if no Location card), set the Outbound Handling Time to 3D.  This will push your "Planned Shipment Date" into the future (note this does not change the Shipment Date field).  The Shipping Time is added to the Planned Shipment Date to calculate the Planned Delivery Date.
     
    As you mentioned, if you set a Requested Delivery Date in the header, the Shipment Date will be backward calculated based on the other fields (Shipping Time and Outbound Warehousing Time).
     
    Other than these fields, there are no settings that will offset the dates on an Order.
     
    Best Regards,
    Ben Baxter
    Accent Software, Inc
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,010

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,270 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,085 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans