Daily Sale Report for each store

(0) Share

Report

Posted on by Community Member

Hi guys !

I am working on Dynamics AX and I need to write a job that will send email at some specified email IDs. in that email daily sale report will be send in the form of text. I have written the code for sending email and I have obtained the daily sale. But I am stuck at obtaining the daily sale for each category. Like a store "A" sales 4 category items e.g electronics, supermarket, crockery and clothing. Now I need to get daily sale category wise. I am getting data from RetailTransactionSaleTrans table. Is there any solution for this issue ?

Any help will be appreciated. Thanks in advance.

Please see the image for better understaning.

Best Regards:

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Oksana Kovaliova 3,597 on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

Single product (ItemId) can belong to multiple categories.
What behavior is expected for the report in this case?

If you need to find what categories product belongs to, you can use standard class ItemDataManager from Microsoft.Dynamics.Retail.Pos.DataManager.DLL:

var itemManager = new ItemDataManager(PosApplication.Instance.Settings.Database.Connection, PosApplication.Instance.Settings.Database.DataAreaID);
var productCategories = itemManager.GetCategoryHierarchy(itemId); //your ItemId from RetailTransactionSalesTrans in parameters

Regards,
Oksana

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I think you misunderstood. I am doing this job in X++. I have created a job and coding in X++ in it.

the code you provided in the comment is probably related to Retail POS SDK.

Can you please guide me for AX( X++ ).

Thanx by the way.

Was this reply helpful? Yes No
Verified answer

venkatesh vadlamani 3,180 on at

Like (1)

Report
Copy link

Link copied!

RetailTransactionSalesTrans has itemID ---> ecoresProduct --->EcoresProductCategory --->EcoresCategory-->EcoResCategoryHierarchy--->EcoResCategoryHierarchyRole

you need to base the query on these tables.

Based on the category hierarchy role you need to build your query. Like you have different hierarchies for different purposes namely retail,sales, procurement and supplementary.

Categories you mentioned might not be on the same level you attached the item , for these you need to use nestedSetLeft and nestedSetRight fields on the ecoRescategory table. If its retail hierarchy then you can also use retailCategoryContainment table also.

So request you to be more specific when you ask a question

Was this reply helpful? Yes No
Verified answer

Oksana Kovaliova 3,597 on at

Like (0)

Report
Copy link

Link copied!

Hi Muhammad,

Sorry for misunderstanding.

AX OLAP Report 'Sales performance by category' can show sales split by category.

So if we have a look how it works, it uses view EcoResProductCategoryExpanded to fetch item categories.

Please, have a look if you can use this view to read item categories + please, consider that each category can have parent category - most probably you should also include sales for parent categories to your report:

Regards,
Oksana

Was this reply helpful? Yes No