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?
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?
Many Thanks for Appreciation. it means a lot for me
Regards,
Alok Kulshreshtha
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!!
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
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?
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.
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 .
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,532 Super User 2024 Season 2
Martin Dráb 228,501 Most Valuable Professional
nmaenpaa 101,148