185
I have a customer who is looking at the Items page in Business Central. He sees that he can filter by Sales and COGS, however, he is unable to see the column for it. I was going to personalize the page for him, but it looks like those fields are not available to add on the page, unless we create a custom column. Is there a better report for him to view the Sales and COGS for items?
Hi,
You can build custom report from Value Entry table where you can get detail Document & Item wise.
Also you can check Customer/ Item Statistics report it's base report possible a information you looking for you can find in it.
Hope this will help.
Many Thanks,
Manan
Could you pls explain little bit more
if we go with power bi also what are the tables and fields we need to take for this
Fields from cost of good and value entries and item ledger entires need to take?
You will have to make custom fields for this. The only thing you can show in the item list is qty sold.
If you want the amount sold and the cost of sold goods you have to look at the Item ledger entries and the value entries.
One option can be to make a report in Power BI or create a query. If you are in BC online then i think i would go the Power BI path.
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 (