ACCOUNT TRANSACTION DETAILS tag no Account Name

[pauln]

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?

[pauln]

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

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

Automatic insertion of the Date for Description Template for created documents

Here are the supported description template values. [WEEK] [NEXT WEEK] [MONTH] [NEXT MONTH] [YEAR] [ACCOUNT NAME] [:XXX] Reads Custom Field value if account attached to an entity. XXX Should be the custom field name. It also works for Default Balance value. I’ve implemented these while trying to create automatic description for wage transactions so some obvious values might be missing. I’ll add [DATE] and if more needed please let me know.

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