Home Page link  

Tender Summary

 

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

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
Tender Summary Arthur 10-17-2006
Posted by Arthur on October 19, 2006, 4:19 pm
Please log in for more thread options
I didnt't really want to spend a whole bunch of money in purchasing crystal
reports just to generate this one report. Microsoft should fix this problem
as it is clearly an error, and could cause some stores accounting mismatches
if they rely on this report to figure out monthly tender amounts.

"Marc" wrote:

> Have you looked at the Crystal Reports Register Analysis Report? That may
> have what you need.
>
> Marc
> Beverly's Pet
>
>
> > Store Operations- Manger Tender Summary feature doesnt seem to work
> > properly.
> > If I process a Layaway transaction or Workorder, and a customer initially
> > places a deposit, that deposit does not show up as part of the tender
> > summary
> > for that day.
> >
> > To me that makes no sense, as a depoist is still money in the cash
> > register,
> > whether the sale is finalized or not.
> >
> > This has to be a bug (using v1.3)
> >
> > Can anyone shed any light on this issue?
>
>
>

Posted by Jeff on October 19, 2006, 4:57 pm
Please log in for more thread options
: quoted-printable

Arthur,

No money to spend, the report is already there. SO Manager | Utilities =
| Crystal Reports | Register Analysis

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

I didnt't really want to spend a whole bunch of money in purchasing =
crystal=20
reports just to generate this one report. Microsoft should fix this =
problem=20
as it is clearly an error, and could cause some stores accounting =
mismatches=20
if they rely on this report to figure out monthly tender amounts.

"Marc" wrote:

> Have you looked at the Crystal Reports Register Analysis Report? =
That may=20
> have what you need.
>=20
> Marc
> Beverly's Pet
>=20
>=20
> > Store Operations- Manger Tender Summary feature doesnt seem to =
work=20
> > properly.
> > If I process a Layaway transaction or Workorder, and a customer =
initially
> > places a deposit, that deposit does not show up as part of the =
tender=20
> > summary
> > for that day.
> >
> > To me that makes no sense, as a depoist is still money in the cash =

> > register,
> > whether the sale is finalized or not.
> >
> > This has to be a bug (using v1.3)
> >
> > Can anyone shed any light on this issue?=20
>=20
>=20
>
------=_NextPart_000_03A1_01C6F386.8F738E40
Content-Type: text/html;
        charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Arthur,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>No money to spend, the report is already =
there.&nbsp;=20
SO Manager | Utilities | Crystal Reports | Register =
Analysis</FONT></DIV>
<DIV><FONT color=3D#008000></FONT><FONT color=3D#008000></FONT><BR>-- =
<BR>*<BR>Get=20
Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.&nbsp; If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.&nbsp; Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Arthur" &lt;<A=20
=
soft.com</A>&gt;=20
wrote in message <A=20
=
EF373-E260-4C2E-B3FF-C4829833D516@microsoft.com</A>...</DIV>I=20
didnt't really want to spend a whole bunch of money in purchasing =
crystal=20
<BR>reports just to generate this one report.&nbsp; Microsoft should =
fix this=20
problem <BR>as it is clearly an error, and could cause some stores =
accounting=20
mismatches <BR>if they rely on this report to figure out monthly =
tender=20
amounts.<BR><BR>"Marc" wrote:<BR><BR>&gt; Have you looked at the =
Crystal=20
Reports Register Analysis Report? That may <BR>&gt; have what you=20
need.<BR>&gt; <BR>&gt; Marc<BR>&gt; Beverly's Pet<BR>&gt; <BR>&gt; =
<BR>&gt;=20
"Arthur" &lt;<A=20
=
soft.com</A>&gt;=20
wrote in message <BR>&gt; <A=20
=
F4D29-3C3F-48BD-9E03-754C13922B16@microsoft.com</A>...<BR>&gt;=20
&gt; Store Operations- Manger Tender Summary feature doesnt seem to =
work=20
<BR>&gt; &gt; properly.<BR>&gt; &gt; If I process a Layaway =
transaction or=20
Workorder, and a customer initially<BR>&gt; &gt; places a deposit, =
that=20
deposit does not show up as part of the tender <BR>&gt; &gt; =
summary<BR>&gt;=20
&gt; for that day.<BR>&gt; &gt;<BR>&gt; &gt; To me that makes no =
sense, as a=20
depoist is still money in the cash <BR>&gt; &gt; register,<BR>&gt; =
&gt;=20
whether the sale is finalized or not.<BR>&gt; &gt;<BR>&gt; &gt; This =
has to be=20
a bug (using v1.3)<BR>&gt; &gt;<BR>&gt; &gt; Can anyone shed any light =
on this=20
issue? <BR>&gt; <BR>&gt; <BR>&gt;</BLOCKQUOTE></BODY></HTML>

------=
Posted by Arthur on October 19, 2006, 7:41 pm
Please log in for more thread options
Thanks for the reply Jeff. Unfortunately, even though there is good
information in that reporting tool, and does not offer tender information by
tender 'type' (cash, credit-card, debit-card), which I also need.

"Jeff" wrote:

> Arthur,
>
> No money to spend, the report is already there. SO Manager | Utilities |
Crystal Reports | Register Analysis
>
> --
> *
> Get Secure! - www.microsoft.com/security
>
> You must be using Outlook Express or some other type of newsgroup reader to
> see and download the file attachment. If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
>
> **********
>
> I didnt't really want to spend a whole bunch of money in purchasing crystal
> reports just to generate this one report. Microsoft should fix this problem
> as it is clearly an error, and could cause some stores accounting mismatches
> if they rely on this report to figure out monthly tender amounts.
>
> "Marc" wrote:
>
> > Have you looked at the Crystal Reports Register Analysis Report? That may
> > have what you need.
> >
> > Marc
> > Beverly's Pet
> >
> >
> > > Store Operations- Manger Tender Summary feature doesnt seem to work
> > > properly.
> > > If I process a Layaway transaction or Workorder, and a customer initially
> > > places a deposit, that deposit does not show up as part of the tender
> > > summary
> > > for that day.
> > >
> > > To me that makes no sense, as a depoist is still money in the cash
> > > register,
> > > whether the sale is finalized or not.
> > >
> > > This has to be a bug (using v1.3)
> > >
> > > Can anyone shed any light on this issue?
> >
> >
> >

Posted by Jeff on October 19, 2006, 9:00 pm
Please log in for more thread options
: quoted-printable

Arthur,

Then is this something you're looking for? Attached is a Detail Tender =
Report.

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

Thanks for the reply Jeff. Unfortunately, even though there is good=20
information in that reporting tool, and does not offer tender =
information by=20
tender 'type' (cash, credit-card, debit-card), which I also need.

"Jeff" wrote:

> Arthur,
>=20
> No money to spend, the report is already there. SO Manager | =
Utilities | Crystal Reports | Register Analysis
>=20
> --=20
> *
> Get Secure! - www.microsoft.com/security
>=20
> You must be using Outlook Express or some other type of newsgroup =
reader to
> see and download the file attachment. If you are not using a =
reader, follow
> the link below to setup Outlook Express. Click on "Open with =
newsreader"
> under the MS Retail Management System on the right.
>=20
> http://tinyurl.com/75bgz
>=20
> **********
>=20
> I didnt't really want to spend a whole bunch of money in =
purchasing crystal=20
> reports just to generate this one report. Microsoft should fix =
this problem=20
> as it is clearly an error, and could cause some stores accounting =
mismatches=20
> if they rely on this report to figure out monthly tender amounts.
>=20
> "Marc" wrote:
>=20
> > Have you looked at the Crystal Reports Register Analysis Report? =
That may=20
> > have what you need.
> >=20
> > Marc
> > Beverly's Pet
> >=20
> >=20
> > > Store Operations- Manger Tender Summary feature doesnt seem to =
work=20
> > > properly.
> > > If I process a Layaway transaction or Workorder, and a =
customer initially
> > > places a deposit, that deposit does not show up as part of the =
tender=20
> > > summary
> > > for that day.
> > >
> > > To me that makes no sense, as a depoist is still money in the =
cash=20
> > > register,
> > > whether the sale is finalized or not.
> > >
> > > This has to be a bug (using v1.3)
> > >
> > > Can anyone shed any light on this issue?=20
> >=20
> >=20
> >
------=_NextPart_001_057A_01C6F3A8.87F95EC0
Content-Type: text/html;
        charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Arthur,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Then is this something you're looking =
for?&nbsp;=20
Attached is a Detail Tender Report.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.&nbsp; If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.&nbsp; Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Arthur" &lt;<A=20
=
soft.com</A>&gt;=20
wrote in message <A=20
=
EAE19-202B-47D2-BD0A-2452A89409CF@microsoft.com</A>...</DIV>Thanks=20
for the reply Jeff.&nbsp; Unfortunately, even though there is good=20
<BR>information in that reporting tool, and does not offer tender =
information=20
by <BR>tender 'type' (cash, credit-card, debit-card), which I also=20
need.<BR><BR>"Jeff" wrote:<BR><BR>&gt; Arthur,<BR>&gt; <BR>&gt; No =
money to=20
spend, the report is already there.&nbsp; SO Manager | Utilities | =
Crystal=20
Reports | Register Analysis<BR>&gt; <BR>&gt; -- <BR>&gt; *<BR>&gt; Get =
Secure!=20
- <A=20
=
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
<BR>&gt;=20
<BR>&gt; You must be using Outlook Express or some other type of =
newsgroup=20
reader to<BR>&gt; see and download the file attachment.&nbsp; If you =
are not=20
using a reader, follow<BR>&gt; the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>&gt; under the MS Retail Management =
System=20
on the right.<BR>&gt; <BR>&gt; <A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>&gt; =
<BR>&gt;=20
**********<BR>&gt; <BR>&gt;&nbsp;&nbsp; "Arthur" &lt;<A=20
=
soft.com</A>&gt;=20
wrote in message <A=20
=
EF373-E260-4C2E-B3FF-C4829833D516@microsoft.com</A>...<BR>&gt;&nbsp;&nbsp=
;=20
I didnt't really want to spend a whole bunch of money in purchasing =
crystal=20
<BR>&gt;&nbsp;&nbsp; reports just to generate this one report.&nbsp; =
Microsoft=20
should fix this problem <BR>&gt;&nbsp;&nbsp; as it is clearly an =
error, and=20
could cause some stores accounting mismatches <BR>&gt;&nbsp;&nbsp; if =
they=20
rely on this report to figure out monthly tender amounts.<BR>&gt;=20
<BR>&gt;&nbsp;&nbsp; "Marc" wrote:<BR>&gt; <BR>&gt;&nbsp;&nbsp; &gt; =
Have you=20
looked at the Crystal Reports Register Analysis Report? That may=20
<BR>&gt;&nbsp;&nbsp; &gt; have what you need.<BR>&gt;&nbsp;&nbsp; &gt; =

<BR>&gt;&nbsp;&nbsp; &gt; Marc<BR>&gt;&nbsp;&nbsp; &gt; Beverly's=20
Pet<BR>&gt;&nbsp;&nbsp; &gt; <BR>&gt;&nbsp;&nbsp; &gt; =
<BR>&gt;&nbsp;&nbsp;=20
&gt; "Arthur" &lt;<A=20
=
soft.com</A>&gt;=20
wrote in message <BR>&gt;&nbsp;&nbsp; &gt; <A=20
=
F4D29-3C3F-48BD-9E03-754C13922B16@microsoft.com</A>...<BR>&gt;&nbsp;&nbsp=
;=20
&gt; &gt; Store Operations- Manger Tender Summary feature doesnt seem =
to work=20
<BR>&gt;&nbsp;&nbsp; &gt; &gt; properly.<BR>&gt;&nbsp;&nbsp; &gt; &gt; =
If I=20
process a Layaway transaction or Workorder, and a customer=20
initially<BR>&gt;&nbsp;&nbsp; &gt; &gt; places a deposit, that deposit =
does=20
not show up as part of the tender <BR>&gt;&nbsp;&nbsp; &gt; &gt;=20
summary<BR>&gt;&nbsp;&nbsp; &gt; &gt; for that =
day.<BR>&gt;&nbsp;&nbsp; &gt;=20
&gt;<BR>&gt;&nbsp;&nbsp; &gt; &gt; To me that makes no sense, as a =
depoist is=20
still money in the cash <BR>&gt;&nbsp;&nbsp; &gt; &gt;=20
register,<BR>&gt;&nbsp;&nbsp; &gt; &gt; whether the sale is finalized =
or=20
not.<BR>&gt;&nbsp;&nbsp; &gt; &gt;<BR>&gt;&nbsp;&nbsp; &gt; &gt; This =
has to=20
be a bug (using v1.3)<BR>&gt;&nbsp;&nbsp; &gt; =
&gt;<BR>&gt;&nbsp;&nbsp; &gt;=20
&gt; Can anyone shed any light on this issue? <BR>&gt;&nbsp;&nbsp; =
&gt;=20
<BR>&gt;&nbsp;&nbsp; &gt; <BR>&gt;&nbsp;&nbsp; =
&gt;</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_057A_01C6F3A8.87F95EC0--

------=_NextPart_000_0579_01C6F3A8.87F95EC0
Content-Type: application/octet-stream;
        name="Custom - Misc - Tender (Detailed).qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
        filename="Custom - Misc - Tender (Detailed).qrp"

//--- Report Summary --- //

Begin ReportSummary
ReportType =3D reporttypeSales
ReportTitle =3D "Tender Detail Report"
PageOrientation =3D pageorientationPortrait
WordWrap =3D True
ShowDateTimePicker =3D False
OutLineMode =3D True
Groups =3D 1
GroupDescription =3D ""
DisplayLogo =3D True
LogoFileName =3D "MyLogo.bmp"
ProcedureCall =3D ""
PreQuery1 =3D ""
PreQuery2 =3D ""
TablesQueried =3D <BEGIN>
        FROM TenderEntry=20
        LEFT JOIN [Transaction] ON TenderEntry.TransactionNumber =3D =
[Transaction].TransactionNumber=20
        LEFT JOIN Customer c1 ON [Transaction].CustomerID =3D c1.ID=20
        LEFT JOIN Batch ON [TenderEntry].BatchNumber =3D Batch.BatchNumber=20
        LEFT JOIN Register ON Batch.RegisterID =3D Register.ID=20
        LEFT JOIN OrderHistory ON TenderEntry.OrderHistoryID =3D =
OrderHistory.ID=20
        LEFT JOIN [Order] ON OrderHistory.OrderID =3D [Order].ID=20
        LEFT JOIN Customer c2 ON [Order].CustomerID =3D c2.ID=20
        LEFT JOIN Payment on TenderEntry.PaymentID =3D Payment.ID=20
        LEFT JOIN Customer c3 ON Payment.CustomerID =3D c3.ID
        <END>
SelCriteria =3D ""
GroupBy =3D ""
SortOrder =3D ""
End ReportSummary

=20
//--- Title Rows ---//

Begin TitleRow
Text =3D "<Store Name>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 16
Color =3D "Blue"
End TitleRow

Begin TitleRow
Text =3D "<Report Title>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 12
Color =3D "Black"
End TitleRow

Begin TitleRow
Text =3D "Generated On <Report Date>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 10
Color =3D "Black"
End TitleRow

Begin TitleRow
Text =3D "Designed and/or modified by Jean Holland Group, LLC and/or =
Check Point Software"
Font =3D "Arial"
FontBold =3D False
FontSize =3D 8
Color =3D "Black"
End TitleRow


//--- Filters ---//

Begin Filter
FieldName =3D "TenderDate"
FilterOp =3D reportfilteropBetween
FilterLoLim =3D "<Today>"
FilterHilim =3D "<Today>"
FilterNegated =3D False
FilterConnector =3D reportfilterbooleanconAND
End Filter

//--- Columns ---//

Begin Column
FieldName =3D "TenderEntry.Description"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Tender"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftTop
End Column

Begin Column
FieldName =3D "TenderEntry.BatchNumber"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Batch"
VBDataType =3D vbLong
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1000
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "Register.Description"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Register"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2000
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftTop
End Column


Begin Column
FieldName =3D "TransType"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Type"
VBDataType =3D vbString
Formula =3D "CASE TenderEntry.TransactionNumber WHEN 0 THEN (CASE =
WHEN TenderEntry.OrderHistoryID =3D 0 THEN 'Payment' ELSE 'Order' END) =
ELSE 'Sale' END"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "TransID"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Trans #"
VBDataType =3D vbLong
Formula =3D "CASE TenderEntry.TransactionNumber WHEN 0 THEN (CASE =
WHEN TenderEntry.OrderHistoryID =3D 0 THEN Payment.ID ELSE [Order].ID =
END) ELSE [Transaction].TransactionNumber END"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "Customer"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Customer"
VBDataType =3D vbString
Formula =3D "CASE TenderEntry.TransactionNumber WHEN 0 THEN (CASE =
WHEN TenderEntry.OrderHistoryID =3D 0 THEN c3.LastName ELSE c2.LastName =
END) ELSE c1.LastName END =20
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2000
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "TenderEntry.Amount"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Amount"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1000
GroupMethod =3D groupmethodSum
ColFormat =3D ""
ColAlignment =3D flexAlignRightTop
End Column

Begin Column
FieldName =3D "TenderDate"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
StoreIDFieldName =3D ""
Title =3D "Date"
VBDataType =3D vbDate
Formula =3D "CASE TenderEntry.TransactionNumber WHEN 0 THEN (CASE =
WHEN TenderEntry.OrderHistoryID =3D 0 THEN Payment.Time ELSE =
[Order].Time END) ELSE [Transaction].Time END"
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "TenderEntry.CreditCardNumber"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "CC#"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2000
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignCenterCenter
End Column

Begin Column
FieldName =3D "TenderEntry.CreditCardExpiration"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "CC Exp"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1000
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

------=
Posted by M. Koivu on October 20, 2006, 2:40 pm
Please log in for more thread options
Problem Solved...Thanks Jeff!

"Jeff" wrote:

> Arthur,
>
> Then is this something you're looking for? Attached is a Detail Tender Report.
>
> --
> *
> Get Secure! - www.microsoft.com/security
>
> You must be using Outlook Express or some other type of newsgroup reader to
> see and download the file attachment. If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
>
> **********
>
> Thanks for the reply Jeff. Unfortunately, even though there is good
> information in that reporting tool, and does not offer tender information by
> tender 'type' (cash, credit-card, debit-card), which I also need.
>
> "Jeff" wrote:
>
> > Arthur,
> >
> > No money to spend, the report is already there. SO Manager | Utilities |
Crystal Reports | Register Analysis
> >
> > --
> > *
> > Get Secure! - www.microsoft.com/security
> >
> > You must be using Outlook Express or some other type of newsgroup reader to
> > see and download the file attachment. If you are not using a reader,
follow
> > the link below to setup Outlook Express. Click on "Open with newsreader"
> > under the MS Retail Management System on the right.
> >
> > http://tinyurl.com/75bgz
> >
> > **********
> >
> > I didnt't really want to spend a whole bunch of money in purchasing
crystal
> > reports just to generate this one report. Microsoft should fix this
problem
> > as it is clearly an error, and could cause some stores accounting
mismatches
> > if they rely on this report to figure out monthly tender amounts.
> >
> > "Marc" wrote:
> >
> > > Have you looked at the Crystal Reports Register Analysis Report? That
may
> > > have what you need.
> > >
> > > Marc
> > > Beverly's Pet
> > >
> > >
> > > > Store Operations- Manger Tender Summary feature doesnt seem to work
> > > > properly.
> > > > If I process a Layaway transaction or Workorder, and a customer
initially
> > > > places a deposit, that deposit does not show up as part of the
tender
> > > > summary
> > > > for that day.
> > > >
> > > > To me that makes no sense, as a depoist is still money in the cash
> > > > register,
> > > > whether the sale is finalized or not.
> > > >
> > > > This has to be a bug (using v1.3)
> > > >
> > > > Can anyone shed any light on this issue?
> > >
> > >
> > >

Similar ThreadsPosted
Tender Summary report combining all registers and tender types May 7, 2008, 7:08 pm
Tender Summary by Tender Type June 30, 2006, 11:04 am
EDC vs Tender Summary Report July 20, 2006, 7:21 pm
Tender Summary Report at HQ March 12, 2007, 9:52 am
Tender Summary Report March 22, 2007, 2:40 pm
MPOS Tender Summary Report November 2, 2006, 2:41 pm
Cash tender randomly duplicated in tender screen December 19, 2008, 2:17 pm
split tender in POS doesn't show up in tender report in HQ July 29, 2009, 3:37 pm
sales summary October 16, 2007, 9:42 pm
Sales summary report August 15, 2005, 9:45 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