Question

Expected date Vs Event date

  • 11 July 2023
  • 4 replies
  • 56 views

Userlevel 1
Badge +3

Hi community,

Looking foreward fo your suggestions on the following,

For an inventory part, purchase lead time is set to 07 days and it shows the expected delivery date of 07/19/2023.

Safety stock is set to 60 and min lot size is set to 80.

No available stock or existing supply/demand.

Aftter performing MRP for the part, it has generated requisition to replenish stock with a qty of 80 at the supply date 07/21/2023 (considering working days of the site)

 

The question is whether the expected date is overwritten by the calculated event date and if so, the expectation defining the ‘expected date’ for the purchase part

 

Thank you,

Nimesha


4 replies

Userlevel 2
Badge +7

Hi Nimesha,

Expected Lead Time Date in Inventory Part is using Distribution calendar given in the Site to decide the next working day of the site and then it counts number of days required based on the Purchasing lead time. This is normally calculated in the Calculate Purchase Leadtime window but also is an user editable field so here we have given the User convenience to define approximate number of days based on the Supplier lead time plus other overheads.

In MRP we do some precise calculation counting from MRP Run Start date and Event date considering site distribution calendar for purchased parts. 

Thanks!

Best Regards,

Lakshan

Userlevel 1
Badge +3

HI @Lakshan Thiranagama,

Really appreciate your response.

It seems the syetm uses the general calendar to calculate the expected date instead of the distribution calendar. 

If the distribution calendar is considered to determine the expected date, then shouldn't it be the same date as the event date calculated by MRP?

Please correct me if I am wrong,

Thank you,

Nimesha

Userlevel 2
Badge +7

Hi Nimesha,

If I’m not mistaken Invent is also looking at Site distribution calendar which is general one for purchased parts. 

Reason for difference is, if there is not any primary supplier for the part, MRP is looking at the distribution calendar for the whole lead time period. But Invent is using calendar just to find the next working day and then it just add the lead time into that particular site date. 

However MRP is more precise because if there is a primary supplier for the part, then MRP will calculate the Leadtime considering supplier manufacturing lead time, inspection lead time, external and internal transport lead times. This direct calculation happens only when there is not any primary supplier for the part in MRP.

Thanks!

Lakshan

Userlevel 1
Badge +3

Thank you very much for the explanation Lakshan!

Reply