Calculation error in Requisition Worksheet (Production/SKU)

cvdmooren
Member Posts: 10
I have the following problem in NAV 5.01 using the Requisition Worksheet.
Item is a Pizza, with two locations and SKU’s to go along.
Sales Location SKU’s:
Pizza, Transferred from Production Location, Policy = Order.
Pizza Crust, Purchased for Sales Location, Policy = None
Pizza Sauce, Purchased for Sales Location, Policy = None
Pizza Cheese, Purchased for Sales Location, Policy = None
Production Location SKU’s:
Pizza, Produces at Production Location, Policy = Order.
Pizza Crust, Transferred from Sales Location, Policy = Max, Reorder 10, Max 25
Pizza Sauce, Transferred from Sales Location, Policy = Max, Reorder 10, Max 25
Pizza Cheese, Transferred from Sales Location, Policy = Max, Reorder 10, Max 25
With no Purchase/Salesorders the Requisition Worksheet generates:
Pizza Crust, to be transferred from Sales Location, 25
Pizza Sauce, to be transferred from Sales Location, 25
Pizza Cheese, to be transferred from Sales Location, 25
Seems fine.
Problem occurs when I input a Salesorder, at the Sales Location for 10 Pizza’s:
Pizza, to be transferred from Production Location, 10
Pizza, to be produced at Production Location, 20 :?:
Pizza Crust, to be transferred from Sales Location, 25
Pizza Sauce, to be transferred from Sales Location, 25
Pizza Cheese, to be transferred from Sales Location, 25
I really don’t get the 20 Pizza’s to be produced, when I open the Order Tracking it shows a quantity of 20… But when I let it show the Requisition Line that shows the 10 I expect!!
Solution anyone? I've had a quick look for a hotfix/servicepack with no result.
TIA
Item is a Pizza, with two locations and SKU’s to go along.
Sales Location SKU’s:
Pizza, Transferred from Production Location, Policy = Order.
Pizza Crust, Purchased for Sales Location, Policy = None
Pizza Sauce, Purchased for Sales Location, Policy = None
Pizza Cheese, Purchased for Sales Location, Policy = None
Production Location SKU’s:
Pizza, Produces at Production Location, Policy = Order.
Pizza Crust, Transferred from Sales Location, Policy = Max, Reorder 10, Max 25
Pizza Sauce, Transferred from Sales Location, Policy = Max, Reorder 10, Max 25
Pizza Cheese, Transferred from Sales Location, Policy = Max, Reorder 10, Max 25
With no Purchase/Salesorders the Requisition Worksheet generates:
Pizza Crust, to be transferred from Sales Location, 25
Pizza Sauce, to be transferred from Sales Location, 25
Pizza Cheese, to be transferred from Sales Location, 25
Seems fine.
Problem occurs when I input a Salesorder, at the Sales Location for 10 Pizza’s:
Pizza, to be transferred from Production Location, 10
Pizza, to be produced at Production Location, 20 :?:
Pizza Crust, to be transferred from Sales Location, 25
Pizza Sauce, to be transferred from Sales Location, 25
Pizza Cheese, to be transferred from Sales Location, 25
I really don’t get the 20 Pizza’s to be produced, when I open the Order Tracking it shows a quantity of 20… But when I let it show the Requisition Line that shows the 10 I expect!!
Solution anyone? I've had a quick look for a hotfix/servicepack with no result.
TIA
0
Comments
-
Have you tried this in 5.0 without SP1?
The planning engine is rewritten in SP1 so it might be a bug._____________________
NAV Freelance Consultant0 -
Bumping to the top...0
-
So HAVE you tried it without SP1 then?The art of teaching is clarity and the art of learning is to listen0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions