Announcements
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?
*This post is locked for comments
Hi Alfredo, I tried out your suggestion, unfortunately the outcome did not change. It still mistook rounding for a material variance.
Thanks Alfredo, I shall test this and see if it addresses the issue that I am having
If you haven't already checked, I just read on another post in regards to the Unit Cost decimal places in the Gen Ledger Setup:
On this table 98 General Ledger Setup, you can change the decimal places. In my case the decimals are set to 2:5. You can change it to 2:2 and I believe this is what you are looking to do.
Go to the Development Client and run Table 98:
Then change the Unit Cost Decimal places to 2:2
Good Luck!
If you are the VAR/Partner you can open a ticket with Microsoft. If you are the customer, have your VAR/Partner open the ticket. Check Partner Source / Customer Source for any suggestions from Microsoft.
I was trying to avoid customizing the calculation core as it may introduce other issues specially with the variance calculations. I was wondering if Microsoft was aware of this and if there maybe a possible fix
Unless you can raise the assembly requirement to 1000 units consumed making the unit cost 7.15 you'll need to do customization to ignore the standard NAV behavior.
No the rounding precision in the GL is for two decimals. That is why were are having this problem. If you look at the practical side of it having the GL in more than two decimals makes no financial sense and most customers would not want it. But when it comes to Assembly, customers many buy raw materials in large UoMs but use it in smaller UoMs for Assembly. Example they could by a box of 5000 combs for $35.75 but use 1 comb per Assembled item. So now the raw material cost per assembled item ($35.75/5000) goes beyond 2 decimals and that triggers this abnormal variance.
Question........... is the rounding precision in the General Ledger Setup also 0.00001?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156