Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Item Due Date
03-10-2018, 02:00 AM,
#1
Item Due Date
In SelectOrderItems.php is the item due date intended to be the date it arrives at the customer or the date it is to be shipped? Assuming it is the date to be shipped, is there a way to change the default value from the current date to to the current day + 7 days?

Thanks,

Jeff


Attached Files Thumbnail(s)
   
Reply
03-10-2018, 02:16 PM,
#2
RE: Item Due Date
You can use it anyway you like ... but intended to be the date the customer wants it by after shipped.
You can enter the default number of days to deliver in the customer branch set up - this is used to date the invoice ahead of the dispatch date - so there is no attempt to collect the debt before the expiry of the terms + the expected number of days to deliver,
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
03-13-2018, 01:23 AM,
#3
RE: Item Due Date
Is this working? I set up a customer branch with default number of days to deliver greater than 1 in both my installation and the demo site. In both cases I couldn't find any place where the date was later than the current date.
In SelectOrderItems.php , DeliveryDetails.php or on the invoice.

Upon additional investigation, the manual says the delivery days field is "not currently used" yet it looks like the code is there to use it in SelectOrderItems.php.

I would appreciate any clarification you could give me.

Thanks,
Jeff
Reply
03-13-2018, 03:14 AM, (This post was last modified: 03-13-2018, 04:06 AM by VortecCPI.)
#4
RE: Item Due Date
Looks like this:
PHP Code:
$NewItemDue date($_SESSION['DefaultDateFormat']); 

Should be this in a few places:
PHP Code:
$NewItemDue DateAdd (Date($_SESSION['DefaultDateFormat']),'d'$_SESSION['Items'.$identifier]->DeliveryDays); 

Specifically on lines 1222 and 1271 in my case of non-kit parts being sold.

Also... Should we not compare that value to purchdata.leadtime value to be sure the dates work?

Can a webERP expert please help clarify?
https://www.linkedin.com/in/eclipsepaulbecker
Reply
03-13-2018, 04:58 AM, (This post was last modified: 03-13-2018, 05:30 AM by phil.)
#5
RE: Item Due Date
No it doesn't work sorry - my dodgy memory!
Needs a fix to CalcEarliestDispatchDate() function in includes/DateFunctions.inc to add this many days to it ... must've intended to use it but never did!


The date it is due - needs to be manually set as this is the customer's requirement and may not be (although mostly I suspect is) ASAP.
If the assumption is ASAP then we would need to look at the preferred supplier lead time from purchdata - if it is setup and if it is a manufactured item we'd need to look at the sum of labour type components x quantity ordered in the BOM to accumulate manufacturing time and then work back based on current factory loading and capactities - which we don't currently hold any data for :-( So not really possible for manufactured items as it stands.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
03-13-2018, 06:17 AM,
#6
RE: Item Due Date
Phil,

Thanks for clearing that up. It looks like it would be fairly easy to modify the code to put in a different default date. I just wanted to make sure I wasn't trying to do something that was already built in. With our current system it averages about 7 days (5 business days) from sales order entry to invoicing, so I'd rather have the target at 7 days out. If the customer really needs it before then it can be adjusted inward. The DIFOT Report is kind of useless if everything is late!
The complexity of doing capacity planning would be crazy especially with a large variety of products. Not something I'd be looking for.

Thanks,
Jeff
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)