Accounts General view different dates

Hello there,

Is there a way to view the past month under Account General??? so i can view how my month ended??
I know there is a way to set it up for work period, week, month or all
But now that is January i am trying to view december data.
Hope you can help me
Regards,

You should use reports for that. Reports give better idea vs looking at accounting.

1 Like

but i had followed your tutorial

And i am trying to access that information, how can i get that on a report??

http://www.sambapos.com/wiki/doku.php/custom_reporting

That link is a very good starting point.

Specifically study the Custom Report Tags, Accounting Report Tags and the V5 Report Tags sections.

Its a good idea for you to really study it so you can build your own custom reports that shows exactly the data you want to see.

1 Like

Thanks for your help @Jesse

I am almost there getting my report, i onlly need to sum my totals but i am lost

[Gastos Suppliers:3,1,1,1]
Corona|{ACCOUNT TOTAL:Cervezeria Corona}
Sol|{ACCOUNT TOTAL:Cerveceria Sol}
Wings|{ACCOUNT TOTAL:Wings}
Abastos|{ACCOUNT TOTAL:Abastos}
Titi|{ACCOUNT TOTAL:Titi}
Chef Mart|{ACCOUNT TOTAL:Chef Mart}
Salud y Sabor|{ACCOUNT TOTAL:Salud y Sabor}
Chedraui|{ACCOUNT TOTAL:Chedraui}
Sams|{ACCOUNT TOTAL:Sams}
Costco|{ACCOUNT TOTAL:Costco}
Total| ({ACCOUNT TOTAL:Costco}+{ACCOUNT TOTAL:Sams}.sum)

Let me show you the description of ACCOUNT TOTAL tag.

{ACCOUNT TOTAL:X}
This tag returns total balance of X. X can be an account name or account type name. For example if you type {ACCOUNT TOTAL:Cash} it will give you the balance of ‘Cash’ account. If you type {ACCOUNT TOTAL:Payment Accounts} it will give you the balance total of all ‘Payment Accounts.’

So if these accounts have a common account type you can use {ACCOUNT TOTAL:<Account type name of all these accounts>} to print total.

Alternatively using printing expressions like…

 [=TN('{ACCOUNT TOTAL:Costco}') + TN('{ACCOUNT TOTAL:Sams}')]

… will also work.

3 Likes

@emre thank you very much

This is what i got so far. I think it is correct but im not 100% sure.
Numbers do match with what i have in accounting

[Conta:3,1,2,1,1]

Item| Debit|Credit|Balance
Sales||{REPORT TICKET TOTAL}|{ACCOUNT TOTAL:Sales}
Receivables|{REPORT TICKET TOTAL}|{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Payment Accounts}|{ACCOUNT TOTAL:Receivables}
Cash|{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Cash}|{ACCOUNT TOTAL:Suppliers}|{ACCOUNT TOTAL:Cash}
Credit Card|{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Credit Card}||{ACCOUNT TOTAL:Credit Card}