Home Page link  

HELP! I NEED CUSTOM REPORT: TENDER TYPE Totals by DEPARTMENT

 

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
HELP! I NEED CUSTOM REPORT: TENDER TYPE Totals by DEPARTMENT David Parrish 04-18-2006
Posted by Peter Johnson on April 19, 2006, 2:49 pm
Please log in for more thread options
David:
Say on one sale, a $10 item a and a $20 item B, and they pay with
$25 check and $5 cash, what would the report look like???

Or, are you wanting to just make the assumption that there are never split
tenders and build the report that way?

Peter
AmericanRetailsupply.com

"David Parrish" wrote:

> Some one else please look into this. Again, I am doing this now but by
> using 1 standard report and a custom "Tender Summary" report. See my other
> post with the attachment for the Tender Summary report.
>
> I think Jason is correct about split transactions but the sale of EACH ITEM
> and its METHOD of TENDER of is recorded in the database. If just yet to see
> a report that pulls both at the same time.
>
> David
>
> >I desperately need a custom report. This will immensely help with my
> >accounting checks/balances
> >
> > Thanks in advance
> >
> > I've got a "Tender Summary" from this forum but I need one thing added to
> > it.
> >
> > I need the "Department" break down added to this somehow.
> >
> > The result would be something like this: Of course the date would be
> > selectable
> >
> > DEPT
> > Tender Type1
> > Tender Type2
> > Tender Type3
> >
> >
> > Wine Retail Transactions:
> > Cash $100
> > Debit Card $40
> > AMEX $80
> > MC/Visa $120
> > Checks $21.50
> > Gift Cert Redeemed $25.00
> >
> > Merchandise:
> > Cash $100
> > Debit Card $40
> > AMEX $80
> > MC/Visa $120
> > Checks $21.50
> > Gift Cert Redeemed $25.00
> >
> >
> > Total
> > Cash $200
> > Debit Card $80
> > AMEX $1600
> > MC/Visa $2400
> > Checks $43.00
> > Gift Cert Redeemed $50.00
> >
>
>
>

Posted by David Parrish on April 20, 2006, 11:57 am
Please log in for more thread options
OK, OK, OK

I understand the confusion now.

I kept saying ITEM, as the SUBJ suggestion I am talking about DEPARTMENT.
I found a split transaction. I am not going down the ITEM level really. I
am simply looking at DEPARTMENT.

I found a transaction that was split between a Gift Cert and a VISA.
Looking at the TENDER REPORT there are two items(term used loosely) I should
say 'records' returned with the same trans #. One of the 10.15 and the
other for $8.10. But the actual ITEM of merchandise sold was a single
bottle of wine for 18.25. BUT my reporting is still accurate.

The report I want will show that for the DEPARTMENT of 'WINE RETAIL' I will
have 2 sales: 1 for 10.15 for the tender type of Gift Cert and 1 for 8.10
using Tender Type VISA Credit Card.

Whalla! Eurika and other terms of excitement.

So I sincerely appologize for unintentionally misleading this group/forum.
Please run the report I previously attached and see of yourselves.

Then perhaps we can find a way to combine the two.

Again, thanks for patience and understanding.

David


> David:
> Say on one sale, a $10 item a and a $20 item B, and they pay with
> $25 check and $5 cash, what would the report look like???
>
> Or, are you wanting to just make the assumption that there are never split
> tenders and build the report that way?
>
> Peter
> AmericanRetailsupply.com
>
> "David Parrish" wrote:
>
>> Some one else please look into this. Again, I am doing this now but by
>> using 1 standard report and a custom "Tender Summary" report. See my
>> other
>> post with the attachment for the Tender Summary report.
>>
>> I think Jason is correct about split transactions but the sale of EACH
>> ITEM
>> and its METHOD of TENDER of is recorded in the database. If just yet to
>> see
>> a report that pulls both at the same time.
>>
>> David
>>
>> >I desperately need a custom report. This will immensely help with my
>> >accounting checks/balances
>> >
>> > Thanks in advance
>> >
>> > I've got a "Tender Summary" from this forum but I need one thing added
>> > to
>> > it.
>> >
>> > I need the "Department" break down added to this somehow.
>> >
>> > The result would be something like this: Of course the date would be
>> > selectable
>> >
>> > DEPT
>> > Tender Type1
>> > Tender Type2
>> > Tender Type3
>> >
>> >
>> > Wine Retail Transactions:
>> > Cash $100
>> > Debit Card $40
>> > AMEX $80
>> > MC/Visa $120
>> > Checks $21.50
>> > Gift Cert Redeemed $25.00
>> >
>> > Merchandise:
>> > Cash $100
>> > Debit Card $40
>> > AMEX $80
>> > MC/Visa $120
>> > Checks $21.50
>> > Gift Cert Redeemed $25.00
>> >
>> >
>> > Total
>> > Cash $200
>> > Debit Card $80
>> > AMEX $1600
>> > MC/Visa $2400
>> > Checks $43.00
>> > Gift Cert Redeemed $50.00
>> >
>>
>>
>>



Posted by Jeff on April 20, 2006, 4:14 pm
Please log in for more thread options
David,

You _still_ can't get there from here! Again, the department is tied to
the _item_ sold.


Buy a bottle of $50 wine and a $10 corkscrew, I'm assuming that they are in
different departments.

Pay for it $30 in cash + check of $30.

Look at your reports.

How was the corkscrew department paid for, cash or check?
--
*
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

**********

OK, OK, OK

I understand the confusion now.

I kept saying ITEM, as the SUBJ suggestion I am talking about DEPARTMENT.
I found a split transaction. I am not going down the ITEM level really. I
am simply looking at DEPARTMENT.

I found a transaction that was split between a Gift Cert and a VISA.
Looking at the TENDER REPORT there are two items(term used loosely) I should
say 'records' returned with the same trans #. One of the 10.15 and the
other for $8.10. But the actual ITEM of merchandise sold was a single
bottle of wine for 18.25. BUT my reporting is still accurate.

The report I want will show that for the DEPARTMENT of 'WINE RETAIL' I will
have 2 sales: 1 for 10.15 for the tender type of Gift Cert and 1 for 8.10
using Tender Type VISA Credit Card.

Whalla! Eurika and other terms of excitement.

So I sincerely appologize for unintentionally misleading this group/forum.
Please run the report I previously attached and see of yourselves.

Then perhaps we can find a way to combine the two.

Again, thanks for patience and understanding.

David


> David:
> Say on one sale, a $10 item a and a $20 item B, and they pay with
> $25 check and $5 cash, what would the report look like???
>
> Or, are you wanting to just make the assumption that there are never split
> tenders and build the report that way?
>
> Peter
> AmericanRetailsupply.com
>
> "David Parrish" wrote:
>
>> Some one else please look into this. Again, I am doing this now but by
>> using 1 standard report and a custom "Tender Summary" report. See my
>> other
>> post with the attachment for the Tender Summary report.
>>
>> I think Jason is correct about split transactions but the sale of EACH
>> ITEM
>> and its METHOD of TENDER of is recorded in the database. If just yet to
>> see
>> a report that pulls both at the same time.
>>
>> David
>>
>> >I desperately need a custom report. This will immensely help with my
>> >accounting checks/balances
>> >
>> > Thanks in advance
>> >
>> > I've got a "Tender Summary" from this forum but I need one thing added
>> > to
>> > it.
>> >
>> > I need the "Department" break down added to this somehow.
>> >
>> > The result would be something like this: Of course the date would be
>> > selectable
>> >
>> > DEPT
>> > Tender Type1
>> > Tender Type2
>> > Tender Type3
>> >
>> >
>> > Wine Retail Transactions:
>> > Cash $100
>> > Debit Card $40
>> > AMEX $80
>> > MC/Visa $120
>> > Checks $21.50
>> > Gift Cert Redeemed $25.00
>> >
>> > Merchandise:
>> > Cash $100
>> > Debit Card $40
>> > AMEX $80
>> > MC/Visa $120
>> > Checks $21.50
>> > Gift Cert Redeemed $25.00
>> >
>> >
>> > Total
>> > Cash $200
>> > Debit Card $80
>> > AMEX $1600
>> > MC/Visa $2400
>> > Checks $43.00
>> > Gift Cert Redeemed $50.00
>> >
>>
>>
>>




Posted by David Parrish on April 20, 2006, 4:24 pm
Please log in for more thread options
Jeff - run the report attached. Also please contact me via my direct email
david.parrish@vino100-lakeway DOT com

or call me on my cell 512.557.5215 And we talk abou this. This way I can
share data with you and 'show' you what I mean.

regards,

David



> David,
>
> You _still_ can't get there from here! Again, the department is tied to
> the _item_ sold.
>
>
> Buy a bottle of $50 wine and a $10 corkscrew, I'm assuming that they are
> in
> different departments.
>
> Pay for it $30 in cash + check of $30.
>
> Look at your reports.
>
> How was the corkscrew department paid for, cash or check?
> --
> *
> 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
>
> **********
>
> OK, OK, OK
>
> I understand the confusion now.
>
> I kept saying ITEM, as the SUBJ suggestion I am talking about
> DEPARTMENT.
> I found a split transaction. I am not going down the ITEM level really.
> I
> am simply looking at DEPARTMENT.
>
> I found a transaction that was split between a Gift Cert and a VISA.
> Looking at the TENDER REPORT there are two items(term used loosely) I
> should
> say 'records' returned with the same trans #. One of the 10.15 and the
> other for $8.10. But the actual ITEM of merchandise sold was a single
> bottle of wine for 18.25. BUT my reporting is still accurate.
>
> The report I want will show that for the DEPARTMENT of 'WINE RETAIL' I
> will
> have 2 sales: 1 for 10.15 for the tender type of Gift Cert and 1 for 8.10
> using Tender Type VISA Credit Card.
>
> Whalla! Eurika and other terms of excitement.
>
> So I sincerely appologize for unintentionally misleading this group/forum.
> Please run the report I previously attached and see of yourselves.
>
> Then perhaps we can find a way to combine the two.
>
> Again, thanks for patience and understanding.
>
> David
>
>
>> David:
>> Say on one sale, a $10 item a and a $20 item B, and they pay with
>> $25 check and $5 cash, what would the report look like???
>>
>> Or, are you wanting to just make the assumption that there are never
>> split
>> tenders and build the report that way?
>>
>> Peter
>> AmericanRetailsupply.com
>>
>> "David Parrish" wrote:
>>
>>> Some one else please look into this. Again, I am doing this now but by
>>> using 1 standard report and a custom "Tender Summary" report. See my
>>> other
>>> post with the attachment for the Tender Summary report.
>>>
>>> I think Jason is correct about split transactions but the sale of EACH
>>> ITEM
>>> and its METHOD of TENDER of is recorded in the database. If just yet to
>>> see
>>> a report that pulls both at the same time.
>>>
>>> David
>>>
>>> >I desperately need a custom report. This will immensely help with my
>>> >accounting checks/balances
>>> >
>>> > Thanks in advance
>>> >
>>> > I've got a "Tender Summary" from this forum but I need one thing added
>>> > to
>>> > it.
>>> >
>>> > I need the "Department" break down added to this somehow.
>>> >
>>> > The result would be something like this: Of course the date would be
>>> > selectable
>>> >
>>> > DEPT
>>> > Tender Type1
>>> > Tender Type2
>>> > Tender Type3
>>> >
>>> >
>>> > Wine Retail Transactions:
>>> > Cash $100
>>> > Debit Card $40
>>> > AMEX $80
>>> > MC/Visa $120
>>> > Checks $21.50
>>> > Gift Cert Redeemed $25.00
>>> >
>>> > Merchandise:
>>> > Cash $100
>>> > Debit Card $40
>>> > AMEX $80
>>> > MC/Visa $120
>>> > Checks $21.50
>>> > Gift Cert Redeemed $25.00
>>> >
>>> >
>>> > Total
>>> > Cash $200
>>> > Debit Card $80
>>> > AMEX $1600
>>> > MC/Visa $2400
>>> > Checks $43.00
>>> > Gift Cert Redeemed $50.00
>>> >
>>>
>>>
>>>
>
>
>


begin 666 Custom - Tender Summary by Date.qrp
M+RM+2T@4F5P;W)T(%-U;6UA<GD@+2TM("O#0H-"D)E9VEN(%)E<&]R=%-U
M<&]R=%1I=&QE(#T@(E1E;F1E<B!3=6UM87)Y(&)Y($1A=&4B#0H@("!086=E
M3W)I96YT871I;VX@/2!P86=E;W)I96YT871I;VY0;W)T<F%I= T*(" @5V]R
M9%=R87 @/2!4<G5E#0H@("!3:&]W1&%T951I;650:6-K97(@/2!&86QS90T*
M(" @3W5T3&EN94UO9&4@/2!4<G5E#0H@("!'<F]U<',@/2 Q#0H@("!'<F]U
M<$1E<V-R:7!T:6]N(#T@(B(-"B @($1I<W!L87E,;V=O(#T@5')U90T*(" @
M3&]G;T9I;&5.86UE(#T@(DUY3&]G;RYB;7 B#0H@("!0<F]C961U<F5#86QL
M(#T@(B(-"B @(%!R95%U97)Y,2 ]("))1B!%6$E35%,@*%-%3$5#5"!404),
M15].04U%($923TT@24Y&3U)-051)3TY?4T-(14U!+E9)15=3(%=(15)%(%1!
M0DQ%7TY!344@/2 G5DE%5U1E;F1E<G,G*2!$4D]0(%9)15<@5DE%5U1E;F1E
M15=496YD97)S($%3#0H-"E-%3$5#5"!296=I<W1E<BY$97-C<FEP=&EO;B!!
M4R!296=$97-C+" -"B!296=I<W1E<BY.=6UB97(@05,@4F5G:7-T97(L( T*
M($-A<VAI97(N3F%M92P@#0H@0V%S:&EE<BY.=6UB97(L( T*(%1E;F1E<D5N
M=')Y+D1E<V-R:7!T:6]N+" -"B!;5')A;G-A8W1I;VY=+D-U<W1O;65R240L
M( T*($-/3E9%4E0H9&%T971I;64L($-/3E9%4E0H;G9A<F-H87(L(%M4<F%N
M<V%C=&EO;ETN5&EM92P@,3 Q*2P@,3 Q*2!A<R!$871E+ T*(%M4<F%N<V%C
M=&EO;ETN5&EM92!A<R!4:6UE+" -"B!;5')A;G-A8W1I;VY=+E1R86YS86-T
M:6]N3G5M8F5R+" -"B!.54Q,($%3($]T:&5R3G5M8F5R+ T*(%1E;F1E<D5N
M=')Y+D%M;W5N="P@#0H@0T%312!72$5.(%)E8V%L;%1Y<&4@/2 Q(%1(14X@
M)U)E='5R;B<@14Q312!#05-%(%=(14X@4F5C86QL5'EP92 ](#,@5$A%3B G
M(%1E;F1E<D5N=')Y( T*($Q%1E0@2D])3B!;5')A;G-A8W1I;VY=($].(%1E
M;F1E<D5N=')Y+E1R86YS86-T:6]N3G5M8F5R(#T@6U1R86YS86-T:6]N72Y4
M<F%N<V%C=&EO;DYU;6)E<B -"B!,1494($I/24X@0F%T8V@@3TX@6U1R86YS
M86-T:6]N72Y"871C:$YU;6)E<B ]($)A=&-H+D)A=&-H3G5M8F5R( T*($Q%
M1E0@2D])3B!296=I<W1E<B!/3B!"871C:"Y296=I<W1E<DE$(#T@4F5G:7-T
M97(N240@#0H@3$5&5"!*3TE.($-A<VAI97(@3TX@6U1R86YS86-T:6]N72Y#
M87-H:65R240@/2!#87-H:65R+DE$#0H-"@T*5TA%4D4@4F5G:7-T97(N3G5M
M8F5R($E3(&YO="!N=6QL#0H-"@T*54Y)3TX-"@T*#0H-"E-%3$5#5" -"B!2
M96=I<W1E<BY$97-C<FEP=&EO;B!!4R!296=$97-C+" -"B!296=I<W1E<BY.
M=6UB97(@05,@4F5G:7-T97(L(" -"B!#87-H:65R+DYA;64L( T*($-A<VAI
M97(N3G5M8F5R+" -"B!496YD97)%;G1R>2Y$97-C<FEP=&EO;BP@#0H@4&%Y
M;65N="Y#=7-T;VUE<DE$+ T*($-/3E9%4E0H9&%T971I;64L($-/3E9%4E0H
M;G9A<F-H87(L(%!A>6UE;G0N5&EM92P@,3 Q*2P@,3 Q*2!A<R!$871E+ T*
M(%!A>6UE;G0N5&EM92!A<R!4:6UE+" -"B!.54Q,(&%S(%1R86YS86-T:6]N
M3G5M8F5R+ T*(%!A>6UE;G0N240@87,@3W1H97).=6UB97(L#0H@5&5N9$5R
M96YT<GDN06UO=6YT+" -"B G4&%Y;65N="<@87,@5')X5'EP92 -"@T*1E)/
M32!496YD97)%;G1R>2 -"@T*($Q%1E0@2D])3B!087EM96YT($].(%!A>6UE
M;G0N240@/2!496YD97)E;G1R>2Y087EM96YT240-"B!,1494($I/24X@0F%T
M8V@@3TX@4&%Y;65N="Y"871C:$YU;6)E<B ]($)A=&-H+D)A=&-H3G5M8F5R
M( T*($Q%1E0@2D])3B!296=I<W1E<B!/3B!"871C:"Y296=I<W1E<DE$(#T@
M4F5G:7-T97(N240@#0H@3$5&5"!*3TE.($-A<VAI97(@3TX@4&%Y;65N="Y#
M87-H:65R240@/2!#87-H:65R+DE$#0H-"E=(15)%(%)E9VES=&5R+DYU;6)E
M<B!)4R!.3U0@3E5,3 T*#0H-"@T*54Y)3TX-"@T*4T5,14-4(%)E9VES=&5R
M+D1E<V-R:7!T:6]N($%3(%)E9T1E<V,L#0H@4F5G:7-T97(N3G5M8F5R($%3
M(%)E9VES=&5R+" @#0H@0V%S:&EE<BY.86UE+ T*($-A<VAI97(N3G5M8F5R
M+ T*(%1E;F1E<D5N=')Y+D1E<V-R:7!T:6]N+ T*(# @87,@0W5S=&]M97))
M1"P-"B!#3TY615)4*&1A=&5T:6UE+"!#3TY615)4*&YV87)C:&%R+"!$<F]P
M4&%Y;W5T+E1I;64L(#$P,2DL(#$P,2D@87,@1&%T92P-"B!$<F]P4&%Y;W5T
M+E1I;64@87,@5&EM92P-"B!.54Q,(&%S(%1R86YS86-T:6]N3G5M8F5R+ T*
M($1R;W!087EO=70N240@87,@3W1H97).=6UB97(L#0H@5&5N9&5R16YT<GDN
M06UO=6YT+" -"B G1')O<"]087EO=70G(&%S(%1R>%1Y<&4@( T*#0I&4D]-
M(%1E;F1E<D5N=')Y( T*#0H@3$5&5"!*3TE.($1R;W!087EO=70@3TX@1')O
M<%!A>6]U="Y)1" ](%1E;F1E<D5N=')Y+D1R;W!087EO=71)1 T*($Q%1E0@
M2D])3B!"871C:"!/3B!$<F]P4&%Y;W5T+D)A=&-H3G5M8F5R(#T@0F%T8V@N
M0F%T8VA.=6UB97(@#0H@3$5&5"!*3TE.(%)E9VES=&5R($].($)A=&-H+E)E
M9VES=&5R240@/2!296=I<W1E<BY)1" -"B!,1494($I/24X@0V%S:&EE<B!/
M3B!$<F]P4&%Y;W5T+D-A<VAI97))1" ]($-A<VAI97(N240-"@T*5TA%4D4@
M4F5G:7-T97(N3G5M8F5R($E3($Y/5"!.54Q,#0H-"@T*#0I53DE/3@T*#0I3
M14Q%0U0@4F5G:7-T97(N1&5S8W)I<'1I;VX@05,@4F5G1&5S8RP-"B!296=I
M<W1E<BY.=6UB97(@05,@4F5G:7-T97(L(" -"B!#87-H:65R+DYA;64L#0H@
M0V%S:&EE<BY.=6UB97(L#0H@5&5N9&5R16YT<GDN1&5S8W)I<'1I;VXL#0H@
M6T]R9&5R72Y#=7-T;VUE<DE$+ T*($-/3E9%4E0H9&%T971I;64L($-/3E9%
M4E0H;G9A<F-H87(L($]R9&5R2&ES=&]R>2Y$871E+" Q,#$I+" Q,#$I($%3
M($1A=&4L#0H@3W)D97)(:7-T;W)Y+D1A=&4@87,@5&EM92P-"B!.54Q,(&%S
M(%1R86YS86-T:6]N3G5M8F5R+ T*($]R9&5R2&ES=&]R>2Y/<F1E<DE$(&%S
M($]T:&5R3G5M8F5R+ T*(%1E;F1E<D5N=')Y+D%M;W5N="P@#0H@0T%312!7
M2$5.(%1Y<&4@/2 R(%1(14X@)U=O<FL@3W)D97(G($5,4T4@0T%312!72$5.
M1"!%3D0@87,@5')X5'EP92 -"@T*1E)/32!496YD97)%;G1R>2 -"@T*($Q%
M1E0@2D])3B!/<F1E<DAI<W1O<GD@3TX@3W)D97)(:7-T;W)Y+DE$(#T@5&5N
M9&5R16YT<GDN3W)D97)(:7-T;W)Y240-"B!,1494($I/24X@6T]R9&5R72!/
M3B!/<F1E<DAI<W1O<GDN3W)D97))1" ](%M/<F1E<ETN240-"B!,1494($I/
M24X@0F%T8V@@3TX@3W)D97)(:7-T;W)Y+D)A=&-H3G5M8F5R(#T@0F%T8V@N
M0F%T8VA.=6UB97(@#0H@3$5&5"!*3TE.(%)E9VES=&5R($].($)A=&-H+E)E
M9VES=&5R240@/2!296=I<W1E<BY)1" -"B!,1494($I/24X@0V%S:&EE<B!/
M3B!/<F1E<DAI<W1O<GDN0V%S:&EE<DE$(#T@0V%S:&EE<BY)1 T*#0I72$52
M12!/<F1E<DAI<W1O<GDN5')A;G-A8W1I;VY.=6UB97(@/2 P#0H14Y$/@T*
M(" @5&%B;&5S475E<FEE9" ](")&4D]-(%9)15=496YD97)S($Q%1E0@2D])
M3B!#=7-T;VUE<B!/3B!6:65W5&5N9&5R<RY#=7-T;VUE<DE$(#T@0W5S=&]M
M97(N240B#0H@("!396Q#<FET97)I82 ]("(B#0H@("!'<F]U<$)Y(#T@(B(-
M"B @(%-O<G1/<F1E<B ](")624575&5N9&5R<RY4:6UE+"!624575&5N9&5R
M<RY!;6]U;G0@1$530R(-"D5N9"!297!O<G13=6UM87)Y#0H-"@T*+RM+2T@
M5&ET;&4@4F]W<R M+2TO+PT*#0I"96=I;B!4:71L95)O=PT*(" @5&5X=" ]
M("(4W1O<F4@3F%M93XB#0H@("!&;VYT(#T@(D%R:6%L(@T*(" @1F]N=$)O
M;&0@/2!4<G5E#0H@("!&;VYT4VEZ92 ](#$V#0H@("!#;VQO<B ](")";'5E
M(@T*16YD(%1I=&QE4F]W#0H-"D)E9VEN(%1I=&QE4F]W#0H@("!497AT(#T@
M(CQ297!O<G0@5&ET;&4^(@T*(" @1F]N=" ](")!<FEA;"(-"B @($9O;G1"
M;VQD(#T@5')U90T*(" @1F]N=%-I>F4@/2 Q,@T*(" @0V]L;W(@/2 B0FQA
M/2 B1V5N97)A=&5D($]N(#Q297!O<G0@1&%T93XB#0H@("!&;VYT(#T@(D%R
M:6%L(@T*(" @1F]N=$)O;&0@/2!4<G5E#0H@("!&;VYT4VEZ92 ](#$P#0H@
M("!#;VQO<B ](")";&%C:R(-"D5N9"!4:71L95)O=PT*#0H-"BO+2TM($9I
M;'1E<G,@+2TM+R-"@T*0F5G:6X@1FEL=&5R#0H@("!&:65L9$YA;64@/2 B
M5FEE=U1E;F1E<G,N1&%T92(-"B @($9I;'1E<D]P(#T@<F5P;W)T9FEL=&5R
M;W!"971W965N#0H@("!&:6QT97),;TQI;2 ]("(5&]D87D^(@T*(" @1FEL
M=&5R2&EL:6T@/2 B/%1O9&%Y/B(-"D5N9"!&:6QT97(-"@T*#0HO+RTM+2!#
M;VQU;6YS("TM+2O#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@
M(E9)15=496YD97)S+D1A=&4B#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B
M(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!3=&]R94E$1FEE
M;&1.86UE(#T@(B(-"B @(%1I=&QE(#T@(D1A=&4B#0H@("!60D1A=&%4>7!E
M(#T@=F)$871E#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ]($9A
M;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$
M:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$U-S4-"B @($=R;W5P
M365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*
M(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F=%1O< T*16YD($-O;'5M
M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")624575&5N9&5R
M<RY$97-C<FEP=&EO;B(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@
M("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%-T;W)E241&:65L9$YA
M;64@/2 B(@T*(" @5&ET;&4@/2 B5&5N9&5R(@T*(" @5D)$871A5'EP92 ]
M('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ]($9A
M;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$
M:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$S.34-"B @($=R;W5P
M365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*
M(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F=%1O< T*16YD($-O;'5M
M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")624575&5N9&5R
M<RY296=I<W1E<B(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$
M<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%-T;W)E241&:65L9$YA;64@
M/2 B(@T*(" @5&ET;&4@/2 B4F5G:7-T97(@(R(-"B @(%9"1&%T851Y<&4@
M/2!V8E-T<FEN9PT*(" @1F]R;75L82 ]("(B#0H@("!#;VQ(:61D96X@/2!&
M86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R
M1&ES86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q,#(P#0H@("!'<F]U
M<$UE=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-
M"B @($-O;$%L:6=N;65N=" ](&9L97A!;&EG;DQE9G14;W -"D5N9"!#;VQU
M;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B5DE%5U1E;F1E
M<G,N3F%M92(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ](")#87-H:65R+DYA
M;64B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%-T;W)E241&
M:65L9$YA;64@/2 B(@T*(" @5&ET;&4@/2 B0V%S:&EE<B!.86UE(@T*(" @
M5D)$871A5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O
M;$AI9&1E;B ](%1R=64-"B @($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-
M"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@,3,S
M-0T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9$YO;F4-"B @($-O;$9O
M<FUA=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X06QI9VY,969T5&]P
M#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@
M(E9)15=496YD97)S+DYU;6)E<B(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]
M("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%-T;W)E241&
M:65L9$YA;64@/2 B(@T*(" @5&ET;&4@/2 B0V%S:&EE<B C(@T*(" @5D)$
M871A5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI
M9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@
M("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#DV, T*
M(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9$YO;F4-"B @($-O;$9O<FUA
M=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X06QI9VY,969T5&]P#0I%
M;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E9)
M15=496YD97)S+E1R86YS86-T:6]N3G5M8F5R(@T*(" @1')I;&Q$;W=N1FEE
M;&1.86UE(#T@(EM4<F%N<V%C=&EO;ETN5')A;G-A8W1I;VY.=6UB97(B#0H@
M("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%-T;W)E241&:65L9$YA
M;64@/2 B(@T*(" @5&ET;&4@/2 B5')X(",B#0H@("!60D1A=&%4>7!E(#T@
M=F)3=')I;F<-"B @($9O<FUU;&$@/2 B(@T*(" @0V]L2&ED9&5N(#T@1F%L
M<V4-"B @($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I
M<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@.#0P#0H@("!'<F]U<$UE
M=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"B @
M($-O;$%L:6=N;65N=" ](&9L97A!;&EG;DQE9G14;W -"D5N9"!#;VQU;6X-
M"@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")624575&5N9&5R
M<RY/=&AE<DYU;6)E<B(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@
M("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%-T;W)E241&:65L9$YA
M;64@/2 B(@T*(" @5&ET;&4@/2 B3W1H97(@(R(-"B @(%9"1&%T851Y<&4@
M/2!V8E-T<FEN9PT*(" @1F]R;75L82 ]("(B#0H@("!#;VQ(:61D96X@/2!&
M86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R
M1&ES86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 X-# -"B @($=R;W5P
M365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*
M(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F=%1O< T*16YD($-O;'5M
M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")#=7-T;VUE<BY!
M8V-O=6YT3G5M8F5R(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(D-U<W1O
M;65R+D%C8V]U;G1.=6UB97(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@
M(B(-"B @(%-T;W)E241&:65L9$YA;64@/2 B(@T*(" @5&ET;&4@/2 B0W5S
M=&]M97(@(R(-"B @(%9"1&%T851Y<&4@/2!V8E-T<FEN9PT*(" @1F]R;75L
M82 ]("(B#0H@("!#;VQ(:61D96X@/2!&86QS90T*(" @0V]L3F]T1&ES<&QA
M>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @
M0V]L5VED=&@@/2 Q,3 P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D
M3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"B @($-O;$%L:6=N;65N=" ](&9L
M97A!;&EG;DQE9G14;W -"D5N9"!#;VQU;6X-"@T*#0I"96=I;B!#;VQU;6X-
M"B @($9I96QD3F%M92 ](")#=7-T;VUE<DYA;64B#0H@("!$<FEL;$1O=VY&
M:65L9$YA;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@
M("!3=&]R94E$1FEE;&1.86UE(#T@(B(-"B @(%1I=&QE(#T@(D-U<W1O;65R
M($YA;64B#0H@("!60D1A=&%4>7!E(#T@=F)3=')I;F<-"B @($9O<FUU;&$@
M/2 B0W5S=&]M97(N3&%S=$YA;64@*R G+" G("L@0W5S=&]M97(N1FER<W1.
M86UE(@T*(" @0V]L2&ED9&5N(#T@5')U90T*(" @0V]L3F]T1&ES<&QA>6%B
M;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!4<G5E#0H@("!#;VQ7
M:61T:" ](#@T, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9$YO;F4-
M"B @($-O;$9O<FUA=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X06QI
M9VY,969T5&]P#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE
M;&1.86UE(#T@(E9)15=496YD97)S+D%M;W5N="(-"B @($1R:6QL1&]W;D9I
M96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @
M(%-T;W)E241&:65L9$YA;64@/2 B(@T*(" @5&ET;&4@/2 B06UO=6YT(@T*
M(" @5D)$871A5'EP92 ]('9B0W5R<F5N8WD-"B @($9O<FUU;&$@/2 B(@T*
M(" @0V]L2&ED9&5N(#T@1F%L<V4-"B @($-O;$YO=$1I<W!L87EA8FQE(#T@
M1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H
M(#T@.3 P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D4W5M#0H@("!#
M;VQ&;W)M870@/2 B(@T*(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F
M=%1O< T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M
M92 ](")624575&5N9&5R<RY4<GA4>7!E(@T*(" @1')I;&Q$;W=N1FEE;&1.
M86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*(" @4W1O
M<F5)1$9I96QD3F%M92 ]("(B#0H@("!4:71L92 ](")4<G@@5'EP92(-"B @
M(%9"1&%T851Y<&4@/2!V8E-T<FEN9PT*(" @1F]R;75L82 ]("(B#0H@("!#
M;VQ(:61D96X@/2!&86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS
M90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q
M,C P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L
M1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&
M:65L9$YA;64@/2 B5DE%5U1E;F1E<G,N06UO=6YT(@T*(" @1')I;&Q$;W=N
M1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*
M(" @4W1O<F5)1$9I96QD3F%M92 ]("(B#0H@("!4:71L92 ](")-87@@06UO
M=6YT(@T*(" @5D)$871A5'EP92 ]('9B0W5R<F5N8WD-"B @($9O<FUU;&$@
M/2 B(@T*(" @0V]L2&ED9&5N(#T@5')U90T*(" @0V]L3F]T1&ES<&QA>6%B
M;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L
M5VED=&@@/2 Q,C$U#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D36%X
M#0H@("!#;VQ&;W)M870@/2 B(@T*(" @0V]L06QI9VYM96YT(#T@9FQE>$%L
M:6=N3&5F=%1O< T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I
M96QD3F%M92 ](")624575&5N9&5R<RY!;6]U;G0B#0H@("!$<FEL;$1O=VY&
M:65L9$YA;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@
M("!3=&]R94E$1FEE;&1.86UE(#T@(B(-"B @(%1I=&QE(#T@(DUI;B!!;6]U
M;G0B#0H@("!60D1A=&%4>7!E(#T@=F)#=7)R96YC>0T*(" @1F]R;75L82 ]
M("(B#0H@("!#;VQ(:61D96X@/2!4<G5E#0H@("!#;VQ.;W1$:7-P;&%Y86)L
M92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7
M:61T:" ](#$Q.#4-"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1-:6X-
M"B @($-O;$9O<FUA=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X06QI
M9VY,969T5&]P#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE
M;&1.86UE(#T@(E9)15=496YD97)S+D%M;W5N="(-"B @($1R:6QL1&]W;D9I
M96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @
M(%-T;W)E241&:65L9$YA;64@/2 B(@T*(" @5&ET;&4@/2 B079G($%M;W5N
M="(-"B @(%9"1&%T851Y<&4@/2!V8D-U<G)E;F-Y#0H@("!&;W)M=6QA(#T@
M(B(-"B @($-O;$AI9&1E;B ](%1R=64-"B @($-O;$YO=$1I<W!L87EA8FQE
M(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I
M9'1H(#T@,3(P, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9$%V97)A
M9V4-"B @($-O;$9O<FUA=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X
M06QI9VY,969T5&]P#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @
M1FEE;&1.86UE(#T@(E9)15=496YD97)S+E)E9T1E<V,B#0H@("!$<FEL;$1O
M=VY&:65L9$YA;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B
M#0H@("!3=&]R94E$1FEE;&1.86UE(#T@(B(-"B @(%1I=&QE(#T@(E)E9RX@
M1&5S8W)P=&XN(@T*(" @5D)$871A5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M
M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ](%1R=64-"B @($-O;$YO=$1I<W!L
M87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @
M($-O;%=I9'1H(#T@,3,X, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO
M9$YO;F4-"B @($-O;$9O<FUA=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F
M;&5X06QI9VY,969T5&]P#0I%;F0@0V]L=6UN#0H-"@T*0F5G:6X@0V]L=6UN
M#0H@("!&:65L9$YA;64@/2 B0W5S=&]M97(N1FER<W1.86UE(@T*(" @1')I
M;&Q$;W=N1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@
M/2 B(@T*(" @4W1O<F5)1$9I96QD3F%M92 ]("(B#0H@("!4:71L92 ](")#
M=7-T;VUE<B!&:7)S="!.86UE(@T*(" @5D)$871A5'EP92 ]('9B4W1R:6YG
M#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ](%1R=64-"B @($-O
M;$YO=$1I<W!L87EA8FQE(#T@5')U90T*(" @1FEL=&5R1&ES86)L960@/2!&
M86QS90T*(" @0V]L5VED=&@@/2 X-# -"B @($=R;W5P365T:&]D(#T@9W)O
M=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*(" @0V]L06QI9VYM
M96YT(#T@9FQE>$%L:6=N3&5F=%1O< T*16YD($-O;'5M;@T*#0I"96=I;B!#
M;VQU;6X-"B @($9I96QD3F%M92 ](")#=7-T;VUE<BY,87-T3F%M92(-"B @
M($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.
M86UE(#T@(B(-"B @(%-T;W)E241&:65L9$YA;64@/2 B(@T*(" @5&ET;&4@
M/2 B0W5S=&]M97(@3&%S="!.86UE(@T*(" @5D)$871A5'EP92 ]('9B4W1R
M:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ](%1R=64-"B @
M($-O;$YO=$1I<W!L87EA8FQE(#T@5')U90T*(" @1FEL=&5R1&ES86)L960@
M/2!&86QS90T*(" @0V]L5VED=&@@/2 X-# -"B @($=R;W5P365T:&]D(#T@
M9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*(" @0V]L06QI
I9VYM96YT(#T@9FQE>$%L:6=N3&5F=%1O< T*16YD($-O;'5M;@T*#0H`
`
end


Posted by Jeff on April 20, 2006, 4:45 pm
Please log in for more thread options
David,

I did before sending the first email and deleted my findings to shorten the
message.

It shows exactly what I described.

You are NOT getting the correct information out of your Custom report + the
Detailed Sales report.

_You_ need do exactly what I described in my last email. Humor me

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

**********

Jeff - run the report attached. Also please contact me via my direct email
david.parrish@vino100-lakeway DOT com

or call me on my cell 512.557.5215 And we talk abou this. This way I can
share data with you and 'show' you what I mean.

regards,

David



> David,
>
> You _still_ can't get there from here! Again, the department is tied to
> the _item_ sold.
>
>
> Buy a bottle of $50 wine and a $10 corkscrew, I'm assuming that they are
> in
> different departments.
>
> Pay for it $30 in cash + check of $30.
>
> Look at your reports.
>
> How was the corkscrew department paid for, cash or check?
> --
> *
> 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
>
> **********
>
> OK, OK, OK
>
> I understand the confusion now.
>
> I kept saying ITEM, as the SUBJ suggestion I am talking about
> DEPARTMENT.
> I found a split transaction. I am not going down the ITEM level really.
> I
> am simply looking at DEPARTMENT.
>
> I found a transaction that was split between a Gift Cert and a VISA.
> Looking at the TENDER REPORT there are two items(term used loosely) I
> should
> say 'records' returned with the same trans #. One of the 10.15 and the
> other for $8.10. But the actual ITEM of merchandise sold was a single
> bottle of wine for 18.25. BUT my reporting is still accurate.
>
> The report I want will show that for the DEPARTMENT of 'WINE RETAIL' I
> will
> have 2 sales: 1 for 10.15 for the tender type of Gift Cert and 1 for 8.10
> using Tender Type VISA Credit Card.
>
> Whalla! Eurika and other terms of excitement.
>
> So I sincerely appologize for unintentionally misleading this group/forum.
> Please run the report I previously attached and see of yourselves.
>
> Then perhaps we can find a way to combine the two.
>
> Again, thanks for patience and understanding.
>
> David
>
>
>> David:
>> Say on one sale, a $10 item a and a $20 item B, and they pay with
>> $25 check and $5 cash, what would the report look like???
>>
>> Or, are you wanting to just make the assumption that there are never
>> split
>> tenders and build the report that way?
>>
>> Peter
>> AmericanRetailsupply.com
>>
>> "David Parrish" wrote:
>>
>>> Some one else please look into this. Again, I am doing this now but by
>>> using 1 standard report and a custom "Tender Summary" report. See my
>>> other
>>> post with the attachment for the Tender Summary report.
>>>
>>> I think Jason is correct about split transactions but the sale of EACH
>>> ITEM
>>> and its METHOD of TENDER of is recorded in the database. If just yet to
>>> see
>>> a report that pulls both at the same time.
>>>
>>> David
>>>
>>> >I desperately need a custom report. This will immensely help with my
>>> >accounting checks/balances
>>> >
>>> > Thanks in advance
>>> >
>>> > I've got a "Tender Summary" from this forum but I need one thing added
>>> > to
>>> > it.
>>> >
>>> > I need the "Department" break down added to this somehow.
>>> >
>>> > The result would be something like this: Of course the date would be
>>> > selectable
>>> >
>>> > DEPT
>>> > Tender Type1
>>> > Tender Type2
>>> > Tender Type3
>>> >
>>> >
>>> > Wine Retail Transactions:
>>> > Cash $100
>>> > Debit Card $40
>>> > AMEX $80
>>> > MC/Visa $120
>>> > Checks $21.50
>>> > Gift Cert Redeemed $25.00
>>> >
>>> > Merchandise:
>>> > Cash $100
>>> > Debit Card $40
>>> > AMEX $80
>>> > MC/Visa $120
>>> > Checks $21.50
>>> > Gift Cert Redeemed $25.00
>>> >
>>> >
>>> > Total
>>> > Cash $200
>>> > Debit Card $80
>>> > AMEX $1600
>>> > MC/Visa $2400
>>> > Checks $43.00
>>> > Gift Cert Redeemed $50.00
>>> >
>>>
>>>
>>>
>
>
>





Similar ThreadsPosted
What tables does RMS use to get Department Totals in Z Report? January 26, 2006, 9:39 am
X & Z Totals - Department Sort November 6, 2007, 1:33 pm
Custom Department Sales Report as per Z Departments April 3, 2006, 10:13 am
Tender type on Detailed Sales Report August 21, 2007, 12:10 pm
tender type in detailed sales report October 13, 2007, 3:20 pm
I need a report for Tender Type filtered by date and Time April 14, 2008, 10:41 pm
Custom Report / Z Type June 5, 2007, 10:20 am
How to Customize Detailed Sales Report to add item tender type sol May 8, 2009, 1:33 pm
ways to separate totals for tax and non-tax items at tender time ? March 18, 2007, 8:55 pm
Custom POS buttons > hides Totals & Function Keys January 5, 2009, 12:31 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