How to calculate delivery time for purchased items

Mauritsio · 2014-04-09

Hi,

I'm using NAV5.01 and I would like to know how can I calculate actual delivery time for items I have purchased and received from the vendor... any idea?

Alex_Chow · 2014-04-09

Mauritsio wrote:

Hi,

I'm using NAV5.01 and I would like to know how can I calculate actual delivery time for items I have purchased and received from the vendor... any idea?

Compare the Expected Receipt Date with the posting date of the receipt.

Savatage · 2014-04-10

We calculate Avg Lead times from Vendors using

"Purch. Rcpt. Header"."Posting Date" - "Purch. Rcpt. Header"."Order Date";

I made a processing report that adds up all the date differences & divides it by the number of orders per vendor. Then updates the Vendor."Lead Time Calculation" field.

Mauritsio · 2014-04-11

Hi,

Thanks for you answers and tips.

I think I'll use "Purch. Rcpt. Line"."Posting Date" - "Purch. Rcpt. Line"."Order Date" for the calculation of delivery time for purchased item(s). And follow then Savatage's suggestion to calculate the average time for item by summing up the delivery times and dividing the sum by the amount of orders of the item.

How to calculate delivery time for purchased items

Comments

Categories