what is wrong with my XML here?

[kskinne]

what i'm trying to do is loop through each report tender, and if the tender
is CASH then generate the row below. the other tenders are set up is there
anything wrong with the way I have this set up, because when I generate my Z
report, it is not adding the 200 in for my CASH tender. is there something
incorrect with the way i'm trying to test to see if the tender is cash? or
is it not 'kosher' to add 200 the way i'm trying to do it? please help

thank you,
kevin


<FOR each = "ReportTender">
<IF>
<CONDITION> Report.Tender.Description = "CASH" </CONDITION>
<THEN>
<ROW>
(Report.Tender.ShiftTotal + 200) -
Report.Tender.CloseTotal
</ROW>
</THEN>
<ELSE>
<ROW>
Report.Tender.ShiftTotal - Report.Tender.CloseTotal
</ROW>
</ELSE>
</IF>
</FOR>

 

[Jason Hunt]

What is the 200 your are trying to add? Is this your float? If it is your
float, you should enter $200 under Cash in your "Opening Amounts"
(Open/Close function).

And yes you have to do this every morning. I tell stores to make it a
routine where they count their float in the morning, and then enter the $200
opening amount.

 

[kskinne]

the 200 is the correct beginning balance in the register at the start of each
day - what i'm trying to do is for cash, have the Z report calculate the
over/short amount correctly, even if the cashiers include cash in their
opening amount greater than $200. this can happen if they Z out the previous
night before closing the doors, then someone comes in and purchases something
and cash gets added to the drawer. then the following day that cash gets
counted and included in the opening amount, then also gets added in as part
of the shifttotal, so it gets counted twice.

if i tell my cashiers that, regardless of what they count in the drawer from
the previous night, they should just enter 200 as the opening cash amount,
pretty soon they won't even be counting the cash, they'll just be entering
the 200.

i really want to try to get this modification working - what do i have
incorrect that's preventing it from working?

thanks,
kevin

 

[Jason Hunt]

Well, to answer your question, you can't compare strings unless they are
both in variables (I don't know why it is this way, but it's stupid if you
ask me)

This should work:

<SET name="CashString" type="vbString"> "CASH" </SET>

and then

<CONDITION> Report.Tender.Description = CashString </CONDITION>

However, I think the cashiers should just be trained to handle the situation
by adjusting the opening/closing amounts if necessary, because now you're
depending on that customized template with a hard-coded value which modifies
the numbers being printed. This might make it confusing if there is a
discrepency. Also, because you are just changing that numbers which get
printed, those numbers are not being recorded for batch totals in the
database. This could be a problem if you ever want to export to an account
software, because those numbers will differ from what gets printed.