Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

how customer ledger entry table amount field is updating

Posted on by 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

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    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_ Profile Picture
    Yogesh Kulkarni_ 1,762 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Andrey Baludin 3,941 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Andrey Baludin 3,941 on at
    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 Profile Picture
    Hannes Holst 5,767 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans