Small and medium business | Business Central, N...

How to view a report of Items to see Sales and COGS (Cost of Goods Sold)

(0) Share

Report

Posted on by ERPlatanos

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?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CrackBC on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Manan_Shah 1,459 on at

Like (0)

Report

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

Was this reply helpful? Yes No