how customer ledger entry table amount field is updating

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

It will help you to analyze your code.

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,943 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Andrey Baludin 3,943 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No