Date sold filter value

OK so I give up. What's the Filter Value supposed to be when I run a Daily Sales by Register Report? It defaults to 0. It doesn't accept a date - it wants a numerical value. J

Reply to
Jennifer
Loading thread data ...

Reply to
Akber Alwani

I'll try not to give up. Microsoft doesn't believe in making it easy, tho! Just FYI when you choose or or on this report, the Operator defaults to with a Value of

  1. I got the report to run by not asking the report to filter anything regarding date - it automatically gives me Today Week to Date and YTD in the report format. I guess I just didn't understand the Microsoft logic in the Daily Summary Sales reports.
Reply to
Jennifer

Hi Jen, I think there are some misunderstanding, now I didn't mean that you will say today at the run time. I mean go to store operation folder then go to reports folder there you will find the files with .grp extenstion look at your file i.e. Sales - Detailed Summary whatever then open it to notepad then you will find one section of Filter below is an example: Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropBetween FilterLoLim = "" FilterHilim = "" End Filter

So you can see above that the FilterLoLim and FilterHilim both has caluse of that is what you can do to accomplish the results. if still not get success let me know.

"Jennifer" wrote:

Reply to
Akber Alwani

Want another date irritation?

Try doing a worksheet 250 with Last Updated Today as the criteria. When you enter today's date, it assumes you are talking about 12:00:00am today, so anything you modified today will not get added to the worksheet. The filter is pulling today at 12am - today at 12am. Ummm - that is impossible unless you last updated your item at exactly midnight down to the second.

You have to put the finishing date as some day in the future for it to work properly.

Reply to
Jason

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.