Custom Report creation in Sage 100 ERP (in explorer?)

Hi there,

I searched and couldn't quite find what I was looking for.

I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue from 2019-2023. I'd like to see the total $ sold of items.

I've been exploring explorer but I'm having serious trouble isolating the specific customers and specific items (as well as isolating the report to between 2019-2023).

If you have any advice or guidance on this I'd really appreciate it. Thank you for reading!

Parents
  • 0

    I created the following in Sage Intelligence.

    The sample show 3 items and 3 Customers. Data from from 2017.

    It shows Totals by CustID & Item No. for current & previous 4 years YTD Sales

    Report can be broken up by Year,Qtr, &Period

    If interested my email is on my profile.

    Doug

Reply
  • 0

    I created the following in Sage Intelligence.

    The sample show 3 items and 3 Customers. Data from from 2017.

    It shows Totals by CustID & Item No. for current & previous 4 years YTD Sales

    Report can be broken up by Year,Qtr, &Period

    If interested my email is on my profile.

    Doug

Children
No Data