% Lead Time

tazzy30

Hello,

I am trying to create a report which shows whether a vendor meets the PO if not how many days late and the % of time they do manage it by using the lead time calc field. However i'm not familiar with dateformular fields can calculations be made using this field

Thank you in advance

tazzy30

I have inserted the following code which gives me the difference in days but now i'm trying to calculate whether DaysLate is greater than the Lead Time Calc field if so then Lead Time - DaysLate should give me how many days late the order is is there a way of converting dateformular fields to integer? Or am i going the completely the wrong way about this?

IF "Expected Receipt Date" <>0D THEN
DaysLate := "Posting Date" - "Expected Receipt Date"

DaveT

Hi,

The "Expected Receipt Date" is already adjusted by the lead time calculation. i.e.

"Expected Receipt Date" = order date + lead time calculation.

If you what to use a data formula for comparison then the easiest way is to calculate the appropriate dates and compare these (using the CALCDATE function).

tazzy30

Thank you for your reply the CALCDATE function worked great.
In-regards to the 'Expected Receipt Date' when creating a PO for example the lead time is pulled through when a vendor is inserted however it does not populate the 'Expected Receipt Date' in the header but it does however adjust the dates within the lines, is it not standard navision to populate the date within the header?