Summary report by date

Hi,

Sorry to bother you with what is probably a very simple question but I need a report that gives me a dollar total only for cash and credit card transactions by date.

I can't seem to make the reports group by date and give me a sub-total for that group.

Any help is appreciated.

Reply to
JessTzn
Loading thread data ...

hi JessTzn, I have one report Tender Summary by Date and by Cashier also some crystal report this may help you. please send your email. and rate me once you get it.

"JessTzn" wrote:

Reply to
Akber Alwani

Akber Alwani,

Thanks. You can send it to me at snipped-for-privacy@aol.com.

"Akber Alwani" wrote:

Reply to
JessTzn

Akber, Why don't you post these reports so everyone has access? It would help us all so much and you wouldn't have to email everyone seperately. Besides which I have asked you to email me reports in the past and you never did it. There's been many reports uploaded here(I've posted many myself) so I know it can be done easily. It would just be much easier, and benefit everyone. Craig

Reply to
Craig

begin 666 Custom - Tender Detail Report.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

Reply to
MOH.OWN

Reply to
Akber Alwani

We got the report and it works beautifully. I rated your reply as being useful.

Thank you so much.

"Akber Alwani" wrote:

Reply to
JessTzn

Please forward this to me also snipped-for-privacy@addisoncollection.com Thanks

Reply to
Butch

Hi Moh.Own

Thanks for effort....

How about getting the result from your reports comparing with this

SELECT Sum(TransactionEntry.Quantity * TransactionEntry.Price) FROM TransactionEntry,[Transaction] WHERE TransactionEntry.TransactionNumber=[Transaction].TransactionNumber AND Time >= '2007-08-01' -- for example AND Time < '2007-08-02' -- for example

if the records are the same => there is no problem, if not you have to re-check your report.

Reply to
Mahmoud Amin

Hi,

Just wanted you to know that the report you forwarded had a problem on our system. The first 12 days of the month were always reported wrong (month became year, day became month, and year became day so 1 Sep 2007 would be reported as 2009-01-07).

The solution was to change the Style code from 1 to 101 in the line CONVERT(nvarchar, [Transaction].Time,1) AS Date

We use an older version of MDSE so I'm assuming it's a difference in SQL code from a full blown, up-to-date SQL Server package. Just in case anyone else ran into the problem, I thought I'd post this.

Anyway, thanks aga> hi JessTzn,

Reply to
JessTzn

Akber,

Please send me the report also at snipped-for-privacy@msn.com. Thanks

"Akber Alwani" wrote:

Reply to
David Moffatt

Hello Akber,

Do you have any Z summary reports that can be filtered by day, week, etc

Also do you have a sales summary report that can be filtered by date and time. (Our liquor store is open untill 1 AM and I can't get the broken out sales over the "two day" period once sales has started on the next day?

Thanks so much in advance. snipped-for-privacy@agee.com

Jay

"Akber Alwani" wrote:

Reply to
Target

Hello Mahmoud, do you have a sales summary report that can be filtered by date and time. (Our store is open untill 1 AM and I can't get the sales broken over the "two day" period once sales have started at 8 AM on the next day...

Thanks so much in advance. snipped-for-privacy@agee.com

Jay

"Mahmoud Am> Hi Moh.Own

Reply to
Target

Honestly, I would just change my system time by two hours an know that all sales are off by this amount of time.

Reply to
Jason

Hi Akber, Is this report in XML file??? cause that is the limitation for MSPOS.

Thanks

-Nick

"Akber Alwani" wrote:

Reply to
Nick

Hi Akber,

I just ran into this thread. Would be possible if you can send me the report snipped-for-privacy@hotmail.com

Thanx

"Akber Alwani" wrote:

Reply to
RicoTowers

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.