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

Posted by David Parrish on April 18, 2006, 2:08 pm

Please log in for more thread options

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 Jason on April 18, 2006, 3:33 pm

Please log in for more thread options

Sorry, but you can't do that. When someone buys two items each from a
different department, but pays with Cash and Check, HOW do you allocate the
two tenders to the two departments? The tender amounts/types are not
allocated to each item on the transaction (or those departments assigned to
the items), but rather is allocated to the entire transaction itself. It's
impossible to break that down any further into smaller details (Depart.,
Category, Item, Supplier, et). Sorry to burst your bubble.

Jason

>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 18, 2006, 4:04 pm

Please log in for more thread options

Actually, Jason, they are.

Right now I am assembly this information via 2 reports. A canned report
"Detailed Sales Report" will give you transaction # for each 'item'.

The tender summary by date report (custom) also includes Transaction #. So
with a little excel work I can show

By Tender Type, Cash, Debit Card ect, each Item purchased and what
department that item is in.

Do a subtotals and you have it.

I'm just looking for a way to combine the two reports.

David

> Sorry, but you can't do that. When someone buys two items each from a

> different department, but pays with Cash and Check, HOW do you allocate

> the

> two tenders to the two departments? The tender amounts/types are not

> allocated to each item on the transaction (or those departments assigned

> to

> the items), but rather is allocated to the entire transaction itself.

> It's

> impossible to break that down any further into smaller details (Depart.,

> Category, Item, Supplier, et). Sorry to burst your bubble.

> Jason

>>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 David Parrish on April 19, 2006, 9:37 am

Please log in for more thread options

I think you are talking about a split payment.

Larry and Joe split a bottle wine and a cheese plate. They each pay for
50%. One pays with cash the other with an AMEX. I can see how this would
cause problems but I don't think RMS has a way to truly take one item from
inventory and split it anyway.

> Sorry, but you can't do that. When someone buys two items each from a

> different department, but pays with Cash and Check, HOW do you allocate

> the two tenders to the two departments? The tender amounts/types are not

> allocated to each item on the transaction (or those departments assigned

> to the items), but rather is allocated to the entire transaction itself.

> It's impossible to break that down any further into smaller details

> (Depart., Category, Item, Supplier, et). Sorry to burst your bubble.

> Jason

>>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 19, 2006, 9:39 am

Please log in for more thread options

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