| Dear our team | |||
|---|---|---|---|
| In our company we manage some account asa special account ( not customers - nor suppliers ) | |||
| our management need one report shows informayion for all theses accounts together as below example | |||
| Account | Debit | Credit | Balance |
| Special account 1 | 5,000.00 | 1,000.00 | 4,000.00 |
| Special account 2 | 10,000.00 | 1,000.00 | 9,000.00 |
| Special account 3 | - | ||
| Special account 4 | - | ||
| Special account 5 | - | ||
| In manager I can collect this information for every special account but alone we need for all together | |||
|  | ||
|  |
You can get the exact information by drilling down the control account for the special accounts either from Summary tab or Balance Sheet and similar reports.
Can you show me please how can i collect this information that i need
I have a related party balances control account composed of special accounts.
I went to Summary tab then drilled down to Related Party Balances account and this is what I got:
You can also get the same results from the Balance Sheet report.
I agree with you but what i need report like table shows special accounts like below
First column : Special account name
Second column : Debit transaction
Third column : Credit transaction
Fourth column : Balance
This report was requested by senior management
Maybe that could be an idea
1 Like
Is it possible for the development team to implement it, I think it is very good in the analysis
1 Like
This is Maximum possible report which i am able to generate
Balance is not possible for now
But may be implemented in future.
This report not clear and not give us what we need
I think it would be better for a programmer to create such a report
I am puzzled by this. The custom report by @Omnipotent.inc seems to show exactly what you showed in your first post, except for the balance column. From the report view you can select the table information and copy to a spreadsheet where you can add the column. The programmer allows you to develop such custom reports be-it that arithmetic functions are not available. You can search the forum about this and why it is not enabled.
The @Omnipotent.inc one is different
Here is the edit screen
In case you need @taha1
Sorry forgot to collapse the group, it works as you showed.
If you also want to exclude the entries where special account name is not present you can should include in edit screen under Where… the following:
