Detailed Sales Reort time issue

When you run the HQ detailed sales report, it does it by 12:00am to 11:59pm (24hrs)by default. I have a customer needs to run this report from the time of 8:00am to 7:59am. How do I get the report to change for that particular time instead of using the default 12:00am to 11:59pm? Thanks for your support Dave

Reply to
DCR
Loading thread data ...

Dave,

This will get you started. There is a Detailed Sales Report by Hour on Partner/CustomerSource.

formatting link

Reply to
Jeff

Yes, I've already downloaded it from the reports library, but I'm having a problem on the seach filters. I tried using "greater than" or "less than" filters for the Time sold field. I'm not sure what filters to try to have it work between 8:00am to 8:00am(24hrs). Do you know what filters to use?

Thanks Dave

"Jeff" wrote:

Reply to
DCR

Dave,

I doubt you will be able to use the Filter functions. You will need to create a Dataset, View or Selection criteria in the report itself for the info you need to see. After that, generate the report based on that info.

Here's another hint, go into PartnerSource KB and search for "yesterday" or look at the Item Movement report for a sample View creation.

This will be a moderately complex report to create and definitely not a freebie, as least as I see the issues briefly.

Maybe post on the Partner newsgroup and somebody can help or write it for you. They may already have something similar.

Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.