Ship by date for Orders

Couple of code snips to help with this in a bpm.

 

from EpicWeb

Example #5 To convert a date to the day of the week e.g. 1/1/2007 to Monday.

(If WEEKDAY(LaborHed.ActualClockinDate) = 1 then "Sunday" else

 

(if WEEKDAY(LaborHed.ActualClockinDate) = 2 then "Monday" else

(If WEEKDAY(LaborHed.ActualClockinDate) = 3 then "Tuesday" else

( IF WEEKDAY(LaborHed.ActualClockinDate) = 4 then "Wednesday" else

(IF WEEKDAY(LaborHed.ActualClockinDate) = 5 then "Thursday" else

(If WEEKDAY(LaborHed.ActualClockinDate) = 6 then "Friday" else

( If WEEKDAY(LaborHed.ActualClockinDate) = 7 then "Saturday" else "0" )))) )) )

 

Skip Weekends

 

ShipDate = needDate - customer_shippingdays

 

If Weekday(ShipDate) = 1 Then ShipDate = ShipDate - 2.

If Weekday(ShipDate) = 7 Then ShipDate = ShipDate - 1.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 02, 2015 11:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Ship by date for Orders.

 

 

It's a function that Microsoft provides in Excel VBA addons.  I did find some C# to use for calculating M-days.  I'll try it out and report back.



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

Hey, Group:

We have a list of customers with special lead times that are calculated by m-days.  In order to automate the ship by date fields, is it possible to create a table of customers with these lead times and use a BPM with customization to populate the Shipby date in the Order?


Thanks in advance!


--SF

I would just add it in a numberxx field on the customer or shipto screen. Then in salesorder.update if the  need by date is filled in then get the lead time from the customer and set the ship by date on the header, detail and most importantly the releases.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 02, 2015 3:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Ship by date for Orders.

 

 

Hey, Group:

We have a list of customers with special lead times that are calculated by m-days.  In order to automate the ship by date fields, is it possible to create a table of customers with these lead times and use a BPM with customization to populate the Shipby date in the Order?

 

Thanks in advance!

 

--SF



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
Yeah, I'm going to start by adding the custom field to the Customer ShipTo.

So, I add the number of days, but these are m-days.  Our Sales Entry person uses a function in Excel mdays() to calculate the days, but how to do this in Vantage? 

Thanks.

Is mdays a macro?  I cannot even find that in google, so it must not exist. J

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 2, 2015 2:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Ship by date for Orders.

 

 

Yeah, I'm going to start by adding the custom field to the Customer ShipTo.

 

So, I add the number of days, but these are m-days.  Our Sales Entry person uses a function in Excel mdays() to calculate the days, but how to do this in Vantage? 

 

Thanks.

It's a function that Microsoft provides in Excel VBA addons.  I did find some C# to use for calculating M-days.  I'll try it out and report back.