Howdy, Stranger!
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
- 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
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Issue: NAV recognizes rounding difference as variance
ShanilAlg
Member Posts: 2
Environment: Unmodified Cronus Database – 9.0.47042.0 (NAV 2016)
Scenario:
Define two items.
Raw Material
No: RM001
Description: Raw Material
Costing Method: FIFO
Unit Cost - $0.013 (this is common if it is purchased in bulk qty, e.g. $32.50 for qty 2160)
Replenishment: Purchase
Rounding Precision: 0.00001
Finished Good
No: FG001
Description: Finished Good
Costing Method: Standard
Assembly BoM: 1 qty of RM001
Unit Cost - $0.013 (Calculated)
Replenishment: Assembly
Rounding Precision: 0.00001
Process: Create an Assembly Order for 300 quantities. Carryout multiple postings 80, 40, 180. Check the financial entries.
Problem: There are Material Variance financial entries passed on to the Material Variance account and Inventory account. In the above scenario there is no cost or quantity difference. The system is recognizing a rounding difference as variance. E.g.: on the second posting the variance is 0.003*40 = 0.12. Anything beyond the 2nd decimal is considered as a variance which is wrong.
The Inventory Setup parameters are as follows,
Automatic Cost Posting: Yes
Expected Cost Posting to G/L: Yes
Automatic Cost Adjustment: Always
Average Cost Period: Day
This above issue can be also replicated in:
NAV 2013 R2 – 7.1.39665.0
NAV BC on premise – 13.0.27183.0
This does not occur if the RM cost does not exceed two decimals.
Does anyone know if there is some fix for this?
Scenario:
Define two items.
Raw Material
No: RM001
Description: Raw Material
Costing Method: FIFO
Unit Cost - $0.013 (this is common if it is purchased in bulk qty, e.g. $32.50 for qty 2160)
Replenishment: Purchase
Rounding Precision: 0.00001
Finished Good
No: FG001
Description: Finished Good
Costing Method: Standard
Assembly BoM: 1 qty of RM001
Unit Cost - $0.013 (Calculated)
Replenishment: Assembly
Rounding Precision: 0.00001
Process: Create an Assembly Order for 300 quantities. Carryout multiple postings 80, 40, 180. Check the financial entries.
Problem: There are Material Variance financial entries passed on to the Material Variance account and Inventory account. In the above scenario there is no cost or quantity difference. The system is recognizing a rounding difference as variance. E.g.: on the second posting the variance is 0.003*40 = 0.12. Anything beyond the 2nd decimal is considered as a variance which is wrong.
The Inventory Setup parameters are as follows,
Automatic Cost Posting: Yes
Expected Cost Posting to G/L: Yes
Automatic Cost Adjustment: Always
Average Cost Period: Day
This above issue can be also replicated in:
NAV 2013 R2 – 7.1.39665.0
NAV BC on premise – 13.0.27183.0
This does not occur if the RM cost does not exceed two decimals.
Does anyone know if there is some fix for this?
0
Answers
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!