04-30-2013, 02:26 AM,
(This post was last modified: 05-01-2013, 12:34 PM by MacPhotoBiker.)
|
|
MacPhotoBiker
Senior Member
|
Posts: 149
Threads: 34
Joined: Dec 2012
|
|
Solved:Purchase Orders: Lead time not considered for Delivery Date
When creating a new Purchase Order, the suggested Delivery Date only shows the current date, it does not take into consideration the Lead Time for this article set up in Purchasing Details.
The Delivery Date should be estimated as Today + Lead Time.
(Nice to have but not too important: Delivery Date can only be a weekday, i. e. if "Today + Lead Time" is a Saturday or Sunday, then Delivery Date will be the following Monday. That´s not crucial though.)
MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
|
|
04-30-2013, 06:52 AM,
|
|
MacPhotoBiker
Senior Member
|
Posts: 149
Threads: 34
Joined: Dec 2012
|
|
RE: Purchase Orders: Lead time not considered for Delivery Date
Thanks for your reply, Phil. Obviously I can only speak for myself and my particular situation, but for me Lead Time means how long it takes from the day I place an order with my supplier until I get the product delivered (I am not using the MRP module at all). My supplier gives me for every product an average Lead Time, e. g. 30 days. So when I place the order today, I know I will receive it quite precisely in 30 days. I. e. when I place the order, the Requested Date will always be Today + Lead Time. Of course the Lead Time can vary, but only if something unforeseen happens.
If a product would usually be sold ex stock, I'd put Lead Time one or two days. My products are all manufactured, so Lead Time is always 30 days. I am aware of that rule "Don't program exceptions" and I agree with it, but in this case, I'd say more often than not Requested Date should be Today + Lead Time.
But of course, that's not a "killer", it would just make webERP a bit smoother (for my purpose, though).
Cheers!
MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
|
|
04-30-2013, 12:30 PM,
|
|
PakRicard
Senior Member
|
Posts: 252
Threads: 81
Joined: Jan 2012
|
|
RE: Purchase Orders: Lead time not considered for Delivery Date
Hi Phil:
I agree with him. It is not exact but (today + lead time) is much closer to reality than Today. In our case suppliers never get it on time :-( but it will show us when we should start pestering suppliers.
Regards,
Pak Ricard
|
|
04-30-2013, 11:35 PM,
|
|
MacPhotoBiker
Senior Member
|
Posts: 149
Threads: 34
Joined: Dec 2012
|
|
RE: Purchase Orders: Lead time not considered for Delivery Date
PakRicard,
thanks for supporting and sharing your thoughts on that.
MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
|
|
05-01-2013, 07:22 AM,
(This post was last modified: 05-01-2013, 07:28 AM by phil.)
|
|
phil
Administrator
|
Posts: 1,239
Threads: 14
Joined: Jan 2012
|
|
RE: Purchase Orders: Lead time not considered for Delivery Date
Code: //...got the Purchasing Data for the supplier of the item
$LeadTime = $PurchRow['leadtime'];
} else { // no purchasing data setup
$PurchPrice = 0;
$ConversionFactor = 1;
$SupplierDescription = $ItemRow['description'];
$SuppliersUnitOfMeasure = $ItemRow['units'];
$SuppliersPartNo = '';
$LeadTime = $ItemRow['leadtime'];
}
/* Work out the delivery date based on today + lead time
* if > header DeliveryDate then set DeliveryDate to today + leadtime
*/
$DeliveryDate = DateAdd(Date($_SESSION['DefaultDateFormat']),'d',$LeadTime);
if (! Date1GreaterThanDate2($DeliveryDate,$_SESSION['PO'.$identifier]->DeliveryDate)){
$DeliveryDate = $_SESSION['PO'.$identifier]->DeliveryDate;
}
So the delivery date is defaulted to today + the lead time from the supplier purchasing data unless the header delivery date is later than this - in which case the header delivery date is defaulted for the line item delivery date.
The system was not using the stock item lead time (it was using the purchasing data lead time specific to the supplier). However, I have modified it as above to now use the stock master lead time if no supplier specific lead time is set up.
I also added the link to print the order after creation as suggested by MacPhotoBiker ... not sure why that was not there already!
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
|
|
05-01-2013, 12:22 PM,
|
|
MacPhotoBiker
Senior Member
|
Posts: 149
Threads: 34
Joined: Dec 2012
|
|
RE: Purchase Orders: Lead time not considered for Delivery Date
That´s great Phil, thank you very much. I will check out the information you provided in another thread ( http://www.weberp.org/forum/showthread.p...18#pid2618) to learn how to update the system.
Thank you for being so responsive.
MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
|
|
|