# How can I print account transaction amount? Please help

**URL:** <https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970>\
**Category:** V5 Question\
**Created:** [April 28, 2019, 3:01pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970 "2019-04-28T15:01:23Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![delale](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/a4c791/32.png) [@delale](https://forum.sambapos.com/u/delale)\
**Post date:** [April 28, 2019, 3:01pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/1 "2019-04-28T15:01:23Z")

</div>

Hello everyone,

I would like to know how can I print the amount of the transaction (account based).

Using Printer Templates, I was only able to print the total account amount (for the workperiod) and the total account balance, but what i am after is the individual transaction amount.

Can it be done with printer templates or using report template?

 ![a6d143cc-b58d-474c-a656-4f0de274df64](https://forum.sambapos.com/uploads/default/original/3X/1/6/165c4d7e0ed4545ef20c751d3068d2116b4b348f.jpeg) ![47f3ea91-89ae-499c-a8ff-54863f584c34](https://forum.sambapos.com/uploads/default/original/3X/d/0/d08c5c6c25f8e42ab7de55d98396ebccda0b06d4.jpeg)

Please help  
This is what i tried so far:

[LAYOUT]  
– General layout  
\<T\>Receipt  
\<J00\>Date: {DATE}  
\<J00\>Time: {TIME}  
\<J00\>{DATE:X}  
\<J00\>{ACCOUNT BALANCE:Retiros Yrigoyen}  
\<J00\>{AMOUNT:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TOTAL:Retiros Yrigoyen}  
\<J00\>{ACCOUNT DEBIT TOTAL:Retiros Yrigoyen}  
\<J00\>{ACCOUNT CREDIT TOTAL:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TYPE BALANCE:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TYPE DEBIT BALANCE:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TYPE CREDIT BALANCE:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TRANSACTION TOTAL:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TRANSACTION DEBIT TOTAL:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TRANSACTION CREDIT TOTAL:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TRANSACTION DETAILS:Retiros Yrigoyen}  
\<J00\>{ACCOUNT TRANSACTION COUNT:Retiros Yrigoyen}  
\<J00\>{REPORT ACCOUNT TRANSACTION DETAILS:Retiros Yrigoyen}

\<J00\>{DESCRIPTION:Retiros Yrigoyen} Transaction Description  
\<J00\>{AMOUNT:Retiros Yrigoyen} Transaction Amount  
\<J00\>{EXCHANGE RATE:Retiros Yrigoyen} Transaction Exchange Rate  
\<J00\>{TRANSACTION TYPE NAME:Retiros Yrigoyen} Transaction Type Name  
\<J00\>{SOURCE ACCOUNT TYPE:Retiros Yrigoyen} Source Account Type  
\<J00\>{SOURCE ACCOUNT:Retiros Yrigoyen} Source Account  
\<J00\>{SOURCE DEBIT:Retiros Yrigoyen} Source Debit  
\<J00\>{SOURCE CREDIT:Retiros Yrigoyen} Source Credit  
\<J00\>{SOURCE AMOUNT:Retiros Yrigoyen} Source Amount  
\<J00\>{SOURCE BALANCE:Retiros Yrigoyen} Source Balance  
\<J00\>{TARGET ACCOUNT:Retiros Yrigoyen} TYPE Target Account Type  
\<J00\>{TARGET ACCOUNT:Retiros Yrigoyen} Target Account  
\<J00\>{TARGET DEBIT:Retiros Yrigoyen} Target Debit  
\<J00\>{TARGET CREDIT:Retiros Yrigoyen} Target Credit  
\<J00\>{TARGET AMOUNT:Retiros Yrigoyen} Target Amount  
\<J00\>{TARGET BALANCE:Retiros Yrigoyen} Target Balance

\<J00\>Total|{ACCOUNT TRANSACTION TOTAL:Retiros Yrigoyen OUT:Cash}

\<J00\>{CURRENT USER}  
\<J00\>{DESCRIPTION}  
\<J00\>{DOCUMENT BALANCE}  
\<J00\>{AMOUNT}  
\<J00\>{TRANSACTION TYPE NAME:}  
\<J00\>{SOURCE ACCOUNT TYPE}  
\<J00\>{SOURCE DEBIT}  
\<J00\>{SOURCE CREDIT}  
\<J00\>{TARGET BALANCE}  
\<J00\>{ACCOUNT TOTAL:X}  
\<J00\>{ACCOUNT CREDIT TOTAL:X}  
\<J00\>{ACCOUNT TRANSACTION DETAILS:X}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{ACCOUNT NAME:Cash}  
\<J00\>{PAYMENTS}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{}  
\<J00\>{ACCOUNT TRANSACTION DETAILS:Booking Account Transaction:{ENTITY NAME}}

\<J00\>{TRANSACTION DATE} | {TRANSACTION DESCRIPTION} | {TRANSACTION AMOUNT}

\<J00\>Date: {DOCUMENT DATE} Time:{DOCUMENT TIME}  
\<L00\>{DESCRIPTION}  
\<J00\>{SOURCE ACCOUNT} | {AMOUNT}  
\<J00\>Balance:|{SOURCE BALANCE}  
\<F\>-  
{TRANSACTIONS}  
\<F\>-

[TRANSACTIONS]  
\<J00\>Total|{ACCOUNT TRANSACTION TOTAL:Retiros Yrigoyen OUT:Cash}  
\<J00\>{SOURCE ACCOUNT:Retiros Yrigoyen} | {AMOUNT}  
\<J00\>Balance:|{SOURCE BALANCE:Cash}

---

<div class="post-metadata">

**Author:** ![delale](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/a4c791/32.png) [@delale](https://forum.sambapos.com/u/delale)\
**Post date:** [April 28, 2019, 4:43pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/2 "2019-04-28T16:43:45Z")

</div>

Anyone knows how this can be done?

---

<div class="post-metadata">

**Author:** ![Jesse](https://forum.sambapos.com/user_avatar/forum.sambapos.com/jesse/32/61493_2.png) [@Jesse](https://forum.sambapos.com/u/Jesse)\
**Post date:** [April 28, 2019, 5:03pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/3 "2019-04-28T17:03:34Z")

</div>

This may help you.

[https://kb.sambapos.com/en/9-1-5-creating-accounting-reports-with-custom-reporting-tags/](https://kb.sambapos.com/en/9-1-5-creating-accounting-reports-with-custom-reporting-tags/)

---

<div class="post-metadata">

**Author:** ![delale](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/a4c791/32.png) [@delale](https://forum.sambapos.com/u/delale)\
**Post date:** [April 28, 2019, 5:56pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/4 "2019-04-28T17:56:45Z")

</div>

Thanks Jesse

I placed all account related tags but still cannot achieve to print the last/most recent account transaction.

seems all the tags show totals, but no individual transaction, exept for the “account transaction details” which shows all transactions…

 ![account%20tags](https://forum.sambapos.com/uploads/default/original/3X/4/5/455269a46558b6108a8469e0c044d08f79a49c3a.png)

---

<div class="post-metadata">

**Author:** ![Posflow](https://forum.sambapos.com/user_avatar/forum.sambapos.com/posflow/32/63001_2.png) [@Posflow](https://forum.sambapos.com/u/Posflow)\
**Post date:** [April 29, 2019, 3:29am UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/5 "2019-04-29T03:29:41Z")

</div>

You can filter it using source or trarget accounts stated in your Account Transactiom Type

Just an example of what I mean  
{ACCOUNT TRANSACTION DETAILS:Expense Payment:Cash}

{ACCOUNT TRANSACTION DETAILS:Expense Payment:Bank}

---

<div class="post-metadata">

**Author:** ![delale](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/a4c791/32.png) [@delale](https://forum.sambapos.com/u/delale)\
**Post date:** [April 29, 2019, 5:19pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/6 "2019-04-29T17:19:08Z")

</div>

I tried that already and does not work; it will list all transactions, not the individual transacion.

I was able to achieve printing the last (current) transaction using SQL inside a report. Using Print Report Action and a Rule to print right after transaction is made.

 ![image](https://forum.sambapos.com/uploads/default/original/3X/0/5/0513839d60ed556864c710f6ca3f7e8bf99daa50.png)

---

<div class="post-metadata">

**Author:** ![delale](https://forum.sambapos.com/letter_avatar_proxy/v4/letter/d/a4c791/32.png) [@delale](https://forum.sambapos.com/u/delale)\
**Post date:** [April 29, 2019, 5:21pm UTC](https://forum.sambapos.com/t/how-can-i-print-account-transaction-amount-please-help/19970/7 "2019-04-29T17:21:43Z")

</div>

Here is the report Template if anyone needs it; this will print the last (most current transaction).

Only thing to do is go in to database AccountTransactionValues and find AccountId number of the desired account

Then change below: [AccountId] = 59

[Retiros:4,3,3,6]

> Fecha | Hora | Monto | Descripcion

{REPORT SQL DETAILS:

SELECT [Date]  
,convert(nvarchar,Date,108) as Time  
,[Debit]  
,[Name]  
FROM [AccountTransactionValues]  
WHERE [AccountId] = 59  
AND [Date] = ( select max([date])  
from [AccountTransactionValues]  
where [AccountId] = 59 )

:F.Date,F.Time,F.Debit,F.Name::{0} |{1}| {2}| {3}  
}