this is part of my end of WP report but it wont substract
[=TN('{ACCOUNT TOTAL:EFECTIVO}')-TN('{ACCOUNT TOTAL:Retiro de Caja}')]
Basically i enter a balance float and it substract to Cash Account to know how short or over i’m in my cash drawer by the end of the WP, I appreciate the help
That is not enough information.
There is nothing “wrong” with the formula as-is, meaning the syntax is correct.
Show your entire Report Template.
Show a screenshot of the Report output.
Show screenshots of those Accounts. Show the configuration for both of them and show the view from the Accounts Screen for both of them.
If the result is not what you expect, then you likely have a typo in one or both of your Accounts, that is, one or both of these Accounts does not exist:
EFECTIVO
Retiro de Caja
Remember, everything is case-sensitive and must match exactly. If they don’t match exactly, that is same as them not existing at all.
The other possibility is that one or both of the accounts have no transactions, so their total is zero.
I still don’t see where you used that expression. I do see one above that is wrong however. The first one you posted.
A screenshot of your Report Template does little good. Paste the TEXT of the Template here in the Forum.
[MOVIMIENTOS DE CAJA:5, 2, 2, 2]
>TOTAL ESPERADO EN CAJA||[=(+TN('{ACCOUNT TOTAL:EFECTIVO}')+TN('{ACCOUNT TOTAL:Retiro de Caja}'))]
>> RESUMEN DE MOVIMIENTOS||
>FONDO DE CAJA||{ACCOUNT CREDIT TOTAL:FONDO}
>> +
>ENTRADAS||{ACCOUNT CREDIT TOTAL:Entrada de efectivo}
>> +
>VENTAS NETAS||{ACCOUNT CREDIT TOTAL:VENTAS}
>> -
>SALIDAS||{ACCOUNT DEBIT TOTAL:Salida de efectivo}
>> -
>RETIRO DE CAJA||{ACCOUNT DEBIT TOTAL:Retiro de Caja}
>> =
>SOBRANTE / FALTANTE||[=(-TN('{ACCOUNT TOTAL:EFECTIVO}')+TN('{ACCOUNT TOTAL:Retiro de Caja}'))]
In English will be something like this:
Expected Cash = Quantity
Summary ( Float In and Balance Float )
Float in = Quantity
+
Cash in = Quantity
+
Net Sale = Quantity
-
Balance Float = Quantity
-
Cash Out End of Day = Quantity
=
Over / Short = +-Quantity
I’m Trying to substract Cash Out End of Day from Expected Cash to know how short o over im in money
End of Work Period Rule will be this actions on my setup:
1.-Ask for Cash Out End of Day
2.-Prints WP Report
3.-Finish WP
4.- Send Report to email
5.- The cashier Signs the printed report so i can know how short or over is in money
