ACCOUNT TRANSACTION DETAILS tag no Account Name

Hi @emre

I am trying to list Customer Account Name and discovered we cannot list the Customers who made the deposit onto their Account?

Here is partial syntax:

[Accounts Activity:3, 1, 1]
>Customer Account
{ACCOUNT TRANSACTION DETAILS:Customer Cash Payment BR1:Cash BR1}
{ACCOUNT TRANSACTION DETAILS:Customer Eftpos Payment BR1:Eftpos BR1}
{ACCOUNT TRANSACTION DETAILS:Customer Voucher Payment BR1:Voucher BR1}
> TOTAL|$
>House Credit
> TOTAL|$
>> GRAND TOTAL|$

RESULTS:

Transaction Details:

Emre or anybody know how I can do this?

Ummm working on an idea kendash passed to me 1 day - trying t get a list of all Entity Account Names?

EDIT:

Well this syntax “sort of” works but I would need to parse it and also it is very inefficient taking 10+ seconds start output as I have 1,500 Accounts!

@{REPORT ENTITY DETAILS:E.Name,EC.Full Name:E.AccountId>0:{0}-{1}:,}
[Accounts Activity:2,2,2,1]
>Customer Account
$1|{ACCOUNT TRANSACTION DETAILS:Customer Cash Payment BR1:$1}

Any ideas @emre to make this more efficient - maybe REPOR SQL DETAILS but need to operate on work period? Issue becomes what if they want to work OUT OF Work Period though Reports Manager :disappointed:

I might have to give up here as Getting WP and Entity Account Name from this below is too hard:

FROM [SAMBAPOS].[dbo].[AccountTransactions]

SOLUTION:
This post Emre saved me :joy:

It would still be great to have more control over these Tags :sweat: