Hello,
Our Customer work on : Version: FR Business Central 15.3 (Platform 15.0.40073.40791 + Application 14.0.38650.0);
When we run "Inventory Valuation" according to these conditions :
Starting Date : 01/01/19
Ending Date : 31/12/19
Include Expected Cost = Yes
TOTAL Expected Cost Included displayed by BC is wrong compared to manual cell-by-cell calculation,
The issue is observed only on a certain category of items :
Costing Method = FIFO
The Inventory Setup are as follows:
Automatic Cost Posting = No
Expected Cost Posting = Yes
Automatic Cost Adj. = Never
Default Costing Method = FIFO
Average Cost Calc. Type = Item
Average Cost Period = Month
Our Customer use the standard version of the report "Inventory Valuation".
But my problem lies in the sum of the costs concerning the column: " Cost Posted to G/L" of the "Inventory Valuation" report,
I can't reproduce this case in a Cronus case we don't have a lot of entry.
This report has not actually been modified in the client database,
The sum of "Expected Cost Included" displayed in the column " Cost Posted to G/L " by the report, is not equal to the sum cell for cell (when I do the calculation manually), I cannot explain this difference.
Attached an example :
Starting Date : 01/01/20
Ending Date : 31/01/20
Include Expected Cost = Yes
Inventory Posting Group Name = BUY
Report Expected Cost Included = 2,863,585.36
Manual calculated Expected Cost Included = 2,863,582.98
The difference seems minimal, but when I run the calculation for a year, the difference is significant,
as I said before, I think this is a difficult case to apply to a test database because it depends on the number of transactions,
Thank you in advance,
