Detailed Sales Reort time issue

May 25, 2006 3 Replies

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



Dave,

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

formatting link

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:

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.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required