Home Page link  

Date sold filter value

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Date sold filter value Jennifer 07-21-2007
Posted by Jennifer on July 21, 2007, 9:41 pm
Please log in for more thread options
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

Posted by Akber Alwani on July 22, 2007, 1:00 am
Please log in for more thread options
hi Jennifer
use the <Today> instead of 0. that's all never give up we all are here for
yous to help

"Jennifer" wrote:

> 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
>

Posted by Jennifer on July 22, 2007, 11:53 am
Please log in for more thread options
Akber Alwani wrote:
> hi Jennifer
> use the <Today> instead of 0. that's all never give up we all are here for
> yous to help
>
> "Jennifer" wrote:
>
>> 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
>>
I'll try not to give up. Microsoft doesn't believe in making it easy,
tho! Just FYI when you choose <Today> or <Week to Date> or <Year to
Date> on this report, the Operator defaults to <Equal> with a Value of
0. 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.

Posted by Akber Alwani on July 23, 2007, 12:44 am
Please log in for more thread options
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 = "<Today>"
FilterHilim = "<Today>"
End Filter

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




"Jennifer" wrote:

> Akber Alwani wrote:
> > hi Jennifer
> > use the <Today> instead of 0. that's all never give up we all are here for
> > yous to help
> >
> > "Jennifer" wrote:
> >
> >> 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
> >>
> I'll try not to give up. Microsoft doesn't believe in making it easy,
> tho! Just FYI when you choose <Today> or <Week to Date> or <Year to
> Date> on this report, the Operator defaults to <Equal> with a Value of
> 0. 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.
>

Posted by Jason on July 24, 2007, 4:10 pm
Please log in for more thread options
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.


> Akber Alwani wrote:
>> hi Jennifer
>> use the <Today> instead of 0. that's all never give up we all are here
>> for yous to help
>>
>> "Jennifer" wrote:
>>
>>> 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
>>>
> I'll try not to give up. Microsoft doesn't believe in making it easy,
> tho! Just FYI when you choose <Today> or <Week to Date> or <Year to Date>
> on this report, the Operator defaults to <Equal> with a Value of 0. 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.



Similar ThreadsPosted
Items with last received date greater than last sold date March 21, 2006, 9:23 pm
Statement filter date July 8, 2008, 9:31 pm
Report date filter problem August 18, 2005, 4:49 am
Date Not Changing on Report Filter May 4, 2007, 5:32 pm
Purchase order and transfers date filter October 2, 2007, 12:04 am
Add sale price Sale Start Date & Sale End Date -Item Wiz filter July 2, 2007, 4:54 pm
Items sold based on date and supplier February 14, 2007, 12:36 pm
Report for items not sold yet or Last Sold is empty June 29, 2005, 3:56 pm
Transaction Date VS Business Date February 19, 2008, 12:24 pm
Filter value December 6, 2006, 12:16 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap