You’re offline. This is a read only version of the page.
Announcements
34
HI Gurus!
Is there a way to pull cost incurred for each customer in BC?
I would like to get a better breakdown of how we got these numbers.
Much appreciated!
No base report available from what I can tell that you provide this type of analysis. If you have a report add-on like Jet Reports then you can devise something fairly nice with the necessary filtering. Failing that you could look at creating a report in NAV/BC directly.
Power BI could be another option but if you are using SaaS then the web services could be fairly so as the ILE table of value entries gets very busy over time.
A report that provides a good view on a high level is below:
So the actual answer is broken up by field.
Total Sales is a SUM field of the "Sales LCY" field from the customer ledger entry table for the current fiscal year.
The same can be said of the Profit. It is summing up the "Profit LCY" field from the customer ledger Entry table.
For the cost this is only used if you sell items or resources. It uses the value entries table for items to sum up the "Cost Amount (Actual)" field for that customer using the "Source No." Field. Only entries which aren't of an entry type "Revaluation" are included. Note that any flowfilters applied to the page will be picked up in the calculation such as "Date Filter" or for the global dimensions. For the resource it goes to the resource ledger Entry table and sums up the "Total Cost" field using the "Source No." Field as the customer no. in question. Again flowfilters apply.
Hello,
In W1 this is not to be found or I am looking at the wrong details. Is this a custom report?
Thanks.
#1
André Arnaud de Cal...
294,165
Super User 2025 Season 1
#2
Martin Dráb
232,968
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
