Dears
Good Day
are there any recomendation to get a query & Report like this
41100 Sales 5000
51100 Cost of goods sold ( 2000 )
_________________________________________
Gross profit 3000 Calculated
admin General Expenses (500)
other expenses (100)
_______________________________________
Income or loss by Operation (1500) Calculated
______________________________________________________________________________________________________
1- Table Data Transactions like this
Acc accname details debit Credit
____________________________________________________________________
41101 Sales sales invoice 0 1500
41102 sales sales invoice 0 3500
51101 Cost sales invoice 600 0
51102 Cost sales invoice 1400 0
61101 AdminExp salaries 500 0
71101 other other expenses 100 0
____________________________________________________________________
2- Table Chart of Account like this
Acc accname
______________________
41100 sales Total Title Account no Transactions
41101 Sales Transactions Account
41102 sales Transactions Account
51100 Cost Total Title Account no Transactions
51101 Cost Transactions Account
51102 Cost Transactions Account
61100 AdminExp Total Title Account no Transactions
61101 AdminExp Transactions Account
71100 other Total Title Account no Transactions
71101 other Transactions Account
____________________
Good Day
are there any recomendation to get a query & Report like this
41100 Sales 5000
51100 Cost of goods sold ( 2000 )
_________________________________________
Gross profit 3000 Calculated
admin General Expenses (500)
other expenses (100)
_______________________________________
Income or loss by Operation (1500) Calculated
______________________________________________________________________________________________________
1- Table Data Transactions like this
Acc accname details debit Credit
____________________________________________________________________
41101 Sales sales invoice 0 1500
41102 sales sales invoice 0 3500
51101 Cost sales invoice 600 0
51102 Cost sales invoice 1400 0
61101 AdminExp salaries 500 0
71101 other other expenses 100 0
____________________________________________________________________
2- Table Chart of Account like this
Acc accname
______________________
41100 sales Total Title Account no Transactions
41101 Sales Transactions Account
41102 sales Transactions Account
51100 Cost Total Title Account no Transactions
51101 Cost Transactions Account
51102 Cost Transactions Account
61100 AdminExp Total Title Account no Transactions
61101 AdminExp Transactions Account
71100 other Total Title Account no Transactions
71101 other Transactions Account
____________________