FMS for sales analysis

[dagivar_lebesby]

Hello I hope someone could help me out with an FMS.

What I want to achieve is a result similar to what you could get with built in "sales report"-"Sales analysis report"

Selection "Items" secondary selection : Customer (Only one by one).

Bbetween  date to date , individually displayed.

The "third" selection I want that not is possible with the built in "sales report" is to select by "Ship to address" (CRD1 table).

So when I visit one of the BP store I can see what items and qty this store bought not only the whole company.

Thanks in advance for any help.

BR

Dag-Ivar

[kothandaraman_nagarajan]

Hi,

To view particular BP sales, I don't think you need selection criteria. Further, it is not possible to add selection criteria in FMS.

Thanks.

[dagivar_lebesby]

Thanks for your reply, I think maybe I did not explained very good. I try to  explain better 🙂

In FMS/Query you can have selection criteria . Like [%0] so that is not the problem.

And you can get sales for BP in "sales report" - "Sales analysis" - "Sales analysis report - Selection criteria"), but as i wrote I would like to drill down on delivery address. So qty on each item (SKU/ItemCode) on a spesific delivery adress for that decided  BP. In a date range from date to date.

So I can not use the built in "Sales analysis report - Selection criteria", but need help to make an FMS/Query to generate this report.

[former_member409651]

Hi,

Can you share your query?