2,390
Amount and Amount(LCY) field formula is changed from 2009 to 2016 in the table Vendor ledger entry. A new field(Ledger Entry Amount) is introduced in "Detailed Vendor Ledger Entry" Table . I have upgraded database from 2009 to 2016 but value to Amount and Amount(LCY) is not updated because "Ledger Entry Amount" is false for all the values. Due to which data is reports not matching .How can I solve it .
*This post is locked for comments
Hi
You can update Ledger Entry Amount field using the Entry Type Field like below and check
"Ledger Entry Amount" := NOT (("Entry Type" = "Entry Type"::Application) OR ("Entry Type" = "Entry Type"::"Appln. Rounding"));
not sure where it went wrong but you can create a codeunit and add the code from those above functions and run the codeunit.
no, they wont be blank if you dont run the 2nd step.
did you directly upgrade from 2009 to 2016 or did you use 2009 to 2015 and then from 2015 to 2016?
you can create a codeunit and add the code from those above functions and run again.
Did you run 2nd step of upgrade toolkit? i mean data upgradE?
if yes then there are 2 functions in the upgrade codeunit like
UpdateDtldCustLedgEntry and UpdateDtldVendLedgEntry which will update the field Ledger Entry Amount to show you the correct result.
How data is upgraded from NAV 2009 to NAV 2016 ??
Is it by opening balance or using upgrade data utility ?
Share
Report
All responses (
Answers (
