Accounts Setup Assistance

V5 Question
41

Now show accounts > Transactions.

42

Pasted image1202×281 5.58 KB

43

So Cash is not an account name for Voucher Cash Payment account type.

{ACCOUNT TRANSACTION TOTAL:Voucher Cash Payment:8766393850} should be valid though.

44

No but its wasnt for the booking accounts on the other system last month…

Pasted image1700×554 46.4 KB

Pasted image1403×225 23.9 KB

Pasted image1691×80 6.33 KB

45

Show your Account Transaction Type screen.

46

From which setup hotel or gift voucher??

47

HMM try {ACCOUNT TRANSACTION TOTAL:Voucher Payment Cash:Voucher Cash}

48

49

Voucher Cash is not an account anywhere… (doesnt work anyway lol)

50

Yeah sorry without seeing it in front of me im having to guess.

51

Looks like it should have worked. Are you still in that work period?

52

No, ended it as when was asking before suggestion was might be a cashing issue…

53

instead of using the built in report preview… go to actual reports then try report preview again.

54

Did, is the same…

Ignore voucher transactions, was working on something else. Payments -> voucher payments is the part in question

55

You sure your viewing the right report date? Can you show the accounts screen with those payment transactions?

56

Is only one work period on the system.

Pasted image417×1015 15.7 KB

57

Interestingly account total:voucher accounts only shows credits (sales–>voucher) transactions;

Pasted image1451×179 15.4 KB

58

Can you show the full report syntax it could be something completely different like a tag interfering.

59 
[Sales:1, 1]
{REPORT TICKET TYPES:!PreOrder && TotalAmount >= 0}

[Pre Orders:1, 1]
{REPORT TICKET TYPES:PreOrder && TotalAmount >= 0}

[Refunds:1, 1]
{REPORT TICKET TYPES:TotalAmount < 0}

[Payments:2, 2]
>>Ticket Payments
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}
>>Voucher Payments
Cash|{ACCOUNT TRANSACTION TOTAL:Voucher Cash Payment:Cash}
Credit Card|{ACCOUNT TRANSACTION TOTAL:Voucher Credit Card Payment:Credit Card}
{ACCOUNT TOTAL:Voucher Accounts}

[Refund Payments:2, 1, 2]
{REPORT REFUND PAYMENTS}

[Voucher Transactions:2, 1, 2]
>Voucher Credits
{ACCOUNT DEBIT TOTAL:Cash}
>Voucher Debits
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}

[Ticket Details:2, 1, 2]
>>Ticket Counts
@!{TICKET TYPE LIST}
$1|{REPORT TICKET COUNT:(TY=$1)}|{REPORT TICKET TOTAL:(TY=$1)}
Total|{REPORT TICKET COUNT}|{REPORT TICKET TOTAL}
Amount per Ticket||[=F(TN('{REPORT TICKET TOTAL}')/TN('{REPORT TICKET COUNT}'))]
>>Order Counts
@!{TICKET TYPE LIST}
$1|{REPORT ORDER COUNT:(TY=$1)}|{REPORT ORDER TOTAL:(TY=$1)}
Total|{REPORT ORDER COUNT: }|{REPORT ORDER TOTAL: }
Orders per Ticket||[=F(TN('{REPORT ORDER COUNT: }')/TN('{REPORT TICKET COUNT: }'))]
Amount per Order||[=F(TN('{REPORT ORDER TOTAL: }')/TN('{REPORT ORDER COUNT: }'))]
>>Ticket Counts per State
{REPORT TICKET STATES}
>>Order Counts per State
{REPORT ORDER STATES}

[Ticket Tags:1, 1, 1]
{REPORT TICKET TAGS}

[Payment Details:2, 1, 2]
@{TICKET TYPE LIST}
@{TAX TYPE LIST}
>$1
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(TY=$1)}
{REPORT CALCULATION DETAILS:C.Name,C.X,C.CalculationAmount.Sum:(TY=$1)}
$2||{REPORT TICKET DETAILS:TX.$2.Sum:(TY=$1)}

[User Sales:1, 1] 
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} 
[Settled by $1:1, 1, 1] 
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)} 
>Total Income|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}

[Item Sales:2, 1, 2]
{REPORT ORDER DETAILS:O.ItemGroup,O.ExactTotal.Percent,O.ExactTotal.Sum}
Total||{REPORT ORDER DETAILS:O.ExactTotal.Sum}
60

try putting

[Payments:2, 2]
>>Ticket Payments
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}
>>Voucher Payments
Cash|{ACCOUNT TRANSACTION TOTAL:Voucher Cash Payment:Cash}
Credit Card|{ACCOUNT TRANSACTION TOTAL:Voucher Credit Card Payment:Credit Card}

In its own report.