"Cost Amount (Actual)" vs "Cost Amount (Expec

EugeneEugene Member Posts: 309
in codeunit 5804
in the function CalculateAverageCost
i found the following code

AverageCost := "Cost Amount (Actual)" + "Cost Amount (Expected)";


Is it right to assume that either one or other field will hold the value but never both of them?

I ask this because i also was thinking this to be always true but recently i have found some entries in the value entries table that have non zero values in both fields. And i wonder what process could have caused this ?

Comments

  • EugeneEugene Member Posts: 309
    forgot to mention that all those bogus entries (where both fields non zero) are of Output type (Item Ledger Entry Type= ::Output) so i guess this has something to do with manufacturing module
  • darshanmdarshanm Member Posts: 280
    Hi !

    Navision calculates Item Avg cost on its item card with below formula

    Cost Amnt(Expected) + Cost Amnt(actual) / invoiced qty
    Darshan Mungekar
    Senior Consultan
Sign In or Register to comment.