web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Cust. Ledger Entry Table
Microsoft Dynamics NAV (Archived)

Cust. Ledger Entry Table

(0) ShareShare
ReportReport
Posted on by Community Member

Dear All,

Just wondering if the [Cust. Ledger Entry] table and [Cust_ Ledger Entry] (Found in sql server) are same?

Because the Amount, RemainingAmount and AmountLCY columns are not available in [Cust_ Ledger Entry] table. We are using NAV 2016.

Thank you.

Marlon

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    The mentions fields are flow fields and not stored physically due to this it is not visible in sql server table.

  • Community Member Profile Picture
    Community Member on at

    Thank you for your reply Amol. If that's the case how can I get the values of those fields?

    Regards,

    MARLON

  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    You need to write subqueries for getting the data for that fields as it is populated from other tables..

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Thank you.

  • Jojop1972 Profile Picture
    Jojop1972 on at

    Hello

    I'm having a similar problem.  My client has asked me to replicate the Aged debt report in PowerBI and SQL.  I am struggling to work out how to replicate the flow fields in Amount, Remaining Amount and Amount (LCY) in SQL.  Have you managed to achieve this?  If so I would be grateful if you could advise me on the code.  Many thanks

  • Community Member Profile Picture
    Community Member on at

    Hi, Yes, I was able to get the values. i’ll provide you the tables on Monday (GMT +8).

    Regards,

    Marlon

  • Jojop1972 Profile Picture
    Jojop1972 on at

    Thank you very much for your help.  It is much appreciated!

  • Community Member Profile Picture
    Community Member on at

    Hello,

    Get the details on this table [Detailed Cust_ Ledg_ Entry].

    Regards,

    Marlon

  • Jojop1972 Profile Picture
    Jojop1972 on at

    Thank you very much for all your help.  I have used the amount column and my report now works.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans