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,
Jesse
January 2, 2016, 2:27am
2
You should use reports for that. Reports give better idea vs looking at accounting.
1 Like
but i had followed your tutorial
This tutorial will show how to handle Supplier and Utility Payouts. This is continuation of my previous Method K tutorials.
DISCLAIMER: This is setup to use the Bank Account as the primary source it is not setup for paying out of Drawer. See Expenses and Payouts Method K: Bank Deposits for explanation of the Bank Account setup.
Overview of the process flow:
[image]
Create the Account Type:
[image]
Create the Accounts:
[image]
Create the Account Screens:
[image]
Supplier Account…
And i am trying to access that information, how can i get that on a report??
Jesse
January 2, 2016, 3:24am
4
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)
emre
January 3, 2016, 2:15am
6
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}