You’re offline. This is a read only version of the page.
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
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
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.
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
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (