Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
How to calculate delivery time for purchased items
Mauritsio
Member Posts: 27
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?
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?
0
Comments
Compare the Expected Receipt Date with the posting date of the receipt.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
"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.
http://www.BiloBeauty.com
http://www.autismspeaks.org
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.