how customer ledger entry table amount field is updating

(0) Share

Report

Posted on by Community Member Microsoft Employee

hi experts,

Please tell me how the customer ledger entry table is updating from which table its take data i want to see code for amount filed my field is updating incorrectly please tell me from which table they written code for amount field in customer ledger entry table

Thank you

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

Are you calculating the new discount amount on Sales Invoice itself.?

If yes then NAV will take care of posting .Try to do calculation on Sales Invoices itself
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

Hello Ashwini,

As suggested by Andrey, Amount in Cust. Ledg. Entry is flowfield and it calculates the same from Detailed Cust. Ledg. Entry.

Where do you have custom field for Discount and how you are trying to update Customer Ledger Entry based on your discount? Can you please explain exact requirement?

Anyways, you can create flowfield in Customer Ledger Entry based on your requirement but it is always advisable to use standard discount functionality within NAV instead of customizing.

-Yogesh Kulkarni
Please verify, if you find answer helpful.
Community Member Microsoft Employee on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

Hi andrey,

Thank you for reply i have create a new discount filed based on discount amount in getting correct invoice amount with my discount amount but that invoice amount not updating in cust ledger table thats my problem

thank you
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

Don't make a mistake!

Customer ledger entries appear after posting of sales order for example. And you'll get a lot of troubles changing posted values.

So you can use standard Line discount field in sales lines to change total amount. After Order posting you'll get customer ledger entry with desirable amount without any changes.
Community Member Microsoft Employee on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

Hi Andrey

i have found that i have added new discount on that i need to calculate that value in amount field how can i do this please tell.

Thank you
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

No code.

It's a flow field which shows you a sum of "Detailed Cust. Ledg. Entry".Amount which has Customer leger entry No. equals to Entry No.
Hannes Holst 5,767 on at

Like (0)

Report

RE: how customer ledger entry table amount field is updating

Hi,

check this tool here: https://www.stati-cal.com/

It will help you to analyze your code.