Skip to Content
author's profile photo Former Member
Former Member

Sales Order - How to make Delivery Date default to Lead Time?

My scenario is this:

- We have items that go thru several production stages before it is a finished item that can be sold.

- Each production item has its lead time loaded.

- I would like the delivery date of a finished item to equal the sum of the productions items lead times.

I dont want my sales people to have to look at calendars are calculate how long until something is ready for delivery.

I would like my sales orders delivery date to default to a date that sales people can use.

Is this possible? I would think this would be part of core functionality but I do not see this.

Thank you,

John Sefton

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 03:45 PM

    John,

    Knowing what Items are added to the Sales Order at the time of entry would not be possible without SDK since the line level details are stored internally in temp location.

    Only on Submitting the Sales Order would it be possible to calculate the date.

    Let me know how you would want to move on this

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 03:46 PM

    Hi John,

    Probably a FMS on Sales Order line -Row Delivery Date will be a good solution for you. I suggest you create Item Level UDF first if your finished items has no sum of the productions items lead times.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I added a query to row level delivery date that added lead time to current date to come up with delivery date.

      Issue resolved.

      SELECT DATEADD(day, (SELECT LeadTime FROM OITM WHERE ItemCode = $[$38.1.0]), $[$10.0.DATE])

      Thank you,

      John

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 06:06 PM

    Good to know my suggestion works.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.