on 10-23-2015 1:39 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.