Monthly sales on items also filtered to a dimension

(0) Share

Report

Posted on by AmberPFC

I would like to be able to pull up my the monthly posted sales per SKU item and filter on a dimension code

Is this possible and can anyone help me?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Alok.kulshreshtha 934 on at

Like (0)

Report

Hi ,

Look for customer/Item sales where filter on Posting date column for month wise and use Filter Total By for section for dimension filter.

Regards,

Alok Kulshreshtha

Please Verify my answer if you find my post helpful.

Was this reply helpful? Yes No
AmberPFC 52 on at

Like (0)

Report

Hi Alok,

Thank you, great! This worked, see below print screen.

But now I need to change the actual report layout, and remove the profit and proft% column, and discount amount column also. Basically I need to customize this report in "Custom Reports Layout"

To do that I need the report ID. Where can I find the report ID? can you help me with that?

We need this report to pay commission on items sold to the designer .

Was this reply helpful? Yes No
Verified answer

Alok.kulshreshtha 934 on at

Like (0)

Report

Hi,

it's 113. to find Go to Report layout and search for Customer/Item Sales.

Regards,

Alok

Please Verify my answer if you find my post helpful.

Was this reply helpful? Yes No
AmberPFC 52 on at

Like (0)

Report

Unfortunately this does not show up in Custom Report Layout

But is does show up in Report Layout (Without the Custom). I don'tt know how to change the layout in REport Layout, but I do in Custom Report Layout.

do you know?

Was this reply helpful? Yes No
Verified answer

Alok.kulshreshtha 934 on at

Like (1)

Report

To add in custom layout, click on new. system will show you a new popup screen.

Enter Report ID i.e,. 113, select which layout you want to add in customer layout report list. here I have selected "Insert RDLC layout". and press OK.

Regards,

Alok Kulshreshtha

Was this reply helpful? Yes No
AmberPFC 52 on at

Like (0)

Report

Alok, you are a star! You solved in a few minutes what I asked our BC partner for for many times and they did not know!

Thank you so much!!

Was this reply helpful? Yes No
Suggested answer

Alok.kulshreshtha 934 on at

Like (1)

Report

Many Thanks for Appreciation. it means a lot for me

Regards,

Alok Kulshreshtha

Was this reply helpful? Yes No