Amount field calculation in Vendor Ledger Entry

(0) Share

Report

Posted on by NavTech

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

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

How data is upgraded from NAV 2009 to NAV 2016 ??

Is it by opening balance or using upgrade data utility ?

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

Using upgrade data utility ,Provided by Microsoft

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

Yes I run data upgrade otherwise vendor ledger entry would be blank . Is there a way I can run these two function separately . Will it fix the issue.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

I upgraded into 2015 and then 2016.

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

not sure where it went wrong but you can create a codeunit and add the code from those above functions and run the codeunit.

Was this reply helpful? Yes No
Verified answer

Rajasekhar@MS 5,569 on at

Like (0)

Report

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"));

Was this reply helpful? Yes No
NavTech 2,390 on at

Like (0)

Report

Thanks alot mohana . It has fixed the issue . now data is matching in reports.

Was this reply helpful? Yes No