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
Hello,
Get the details on this table [Detailed Cust_ Ledg_ Entry].
Regards,
Marlon
Hi, Yes, I was able to get the values. i’ll provide you the tables on Monday (GMT +8).
Regards,
Marlon
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
Thank you.
You need to write subqueries for getting the data for that fields as it is populated from other tables..
Thank you for your reply Amol. If that's the case how can I get the values of those fields?
Regards,
MARLON
The mentions fields are flow fields and not stored physically due to this it is not visible in sql server table.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (