Explode BOM, Purchase order
gmitsuy
Member Posts: 5
Hi, I'm a newbie in Dynamics NAV 5.0
I have a problem..., if a Product X is assembled by 10 A units, 20 B units & 25 C units. In this case X is a big box with A B & C type pair of shoes that come in boxes.
In the case I receive only receive 9 X boxes instead of 10. I want to explode the BOM so it shows me 90A,180B & 225C pair of shoes.
When i put 9 in "Quantity to receive" and explode the BOM, it shows me 100A, 200B & 250C as if I received 10.
Is there an easy way to get 90A,180B & 225C pair of shoes?
I'll appreciate any help!
Kindest Regards
I have a problem..., if a Product X is assembled by 10 A units, 20 B units & 25 C units. In this case X is a big box with A B & C type pair of shoes that come in boxes.
In the case I receive only receive 9 X boxes instead of 10. I want to explode the BOM so it shows me 90A,180B & 225C pair of shoes.
When i put 9 in "Quantity to receive" and explode the BOM, it shows me 100A, 200B & 250C as if I received 10.
Is there an easy way to get 90A,180B & 225C pair of shoes?
I'll appreciate any help!
Kindest Regards
0
Comments
-
Hi,
I think u need little change in CodeUnit 73. Just validate Qty to Receive Also e.g
Before Change
//
FromBOMComp.Type::Item:
BEGIN
Item.GET(FromBOMComp."No.");
ToPurchLine.Type := ToPurchLine.Type::Item;
ToPurchLine.VALIDATE("No.",FromBOMComp."No.");
ToPurchLine.VALIDATE("Variant Code",FromBOMComp."Variant Code");
ToPurchLine.VALIDATE(
Quantity,
ROUND(
"Quantity (Base)" * FromBOMComp."Quantity per" *
UOMMgt.GetQtyPerUnitOfMeasure(Item,FromBOMComp."Unit of Measure Code") /
ToPurchLine."Qty. per Unit of Measure",
0.00001));
END;
//
After Change
//
FromBOMComp.Type::Item:
BEGIN
Item.GET(FromBOMComp."No.");
ToPurchLine.Type := ToPurchLine.Type::Item;
ToPurchLine.VALIDATE("No.",FromBOMComp."No.");
ToPurchLine.VALIDATE("Variant Code",FromBOMComp."Variant Code");
ToPurchLine.VALIDATE(
Quantity,
ROUND(
"Quantity (Base)" * FromBOMComp."Quantity per" *
UOMMgt.GetQtyPerUnitOfMeasure(Item,FromBOMComp."Unit of Measure Code") /
ToPurchLine."Qty. per Unit of Measure",
0.00001));
ToPurchLine.VALIDATE(
"Qty. to Receive",
ROUND(
"Qty. to Receive" * FromBOMComp."Quantity per" *
UOMMgt.GetQtyPerUnitOfMeasure(Item,FromBOMComp."Unit of Measure Code") /
ToPurchLine."Qty. per Unit of Measure",
0.00001));
END;0 -
Thank you! It was very helpful...
Cheers0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 329 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