Unit Cost on Posted Assembly Order not Updated
markborges
Member Posts: 170
Hello,
I create 4 items: 3 components (000A, 000B, 000C), and 1 main item (000), which has an Assembly Order composed by those 3 components.
I assembled 15 units to Stock, and for those, I put some manual resource lines on the Assembly Order. Then I posted, and my cost was 15.19.
Later on, I sold 5 units.
Later on, I created a sales order with 20 units, being 10 from Stock and 10 to be assembled. This time, my assembly orders did not have the resource lines, so my cost should be 13.25.
When I posted this order, the assembly order was posted partially correct: The item cost was correct on the Item Ledger Entries (13.25), however, on the POSTED ASSEMBLY ORDER, the unit cost showing there is still 15.19. If I view this posted document, you can clearly see that the sum of the costs does not match 15.19.
Is this a design error? Even though it posted with this wrong amount, all my costs are fine, and my item cost and profit is fine. However I'm wondering if this field with the wrong value is not used anywhere else for statistics, and eventually will cause a discrepancy.
Thanks a lot, regards,
I create 4 items: 3 components (000A, 000B, 000C), and 1 main item (000), which has an Assembly Order composed by those 3 components.
I assembled 15 units to Stock, and for those, I put some manual resource lines on the Assembly Order. Then I posted, and my cost was 15.19.
Later on, I sold 5 units.
Later on, I created a sales order with 20 units, being 10 from Stock and 10 to be assembled. This time, my assembly orders did not have the resource lines, so my cost should be 13.25.
When I posted this order, the assembly order was posted partially correct: The item cost was correct on the Item Ledger Entries (13.25), however, on the POSTED ASSEMBLY ORDER, the unit cost showing there is still 15.19. If I view this posted document, you can clearly see that the sum of the costs does not match 15.19.
Is this a design error? Even though it posted with this wrong amount, all my costs are fine, and my item cost and profit is fine. However I'm wondering if this field with the wrong value is not used anywhere else for statistics, and eventually will cause a discrepancy.
Thanks a lot, regards,
Marcelo Borges
D365 Business Central Solutions Architect
BC AL/NAV C/AL Developer
BC Repositories.com
D365 Business Central Solutions Architect
BC AL/NAV C/AL Developer
BC Repositories.com
0
Answers
-
Hi
I checked the source code in assembly header, at first system will get the "Unit cost" in Item card, if you want the correct cost, you can click the "Update Unit Cost" in Assembly Order.
So I think no problem with your design, it is just standard behavior of NAV. And as you say, value entry will be correct, so unit cost in posted assembly order is just a "Expected" value not "Acutal" value.0
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
- 328 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
