Plugin: AccountInfoCockpit
Account Info Cockpit
This Page is under construction
- Status: Testing
- Licence: GPLv2
- Author: Patric Massing (Hans Auler GmbH - p.massing (at) auler.gmbh)
- Date: 2019
- Required environment: iDempiere with PostgreSQL-Database
- Source : AccountInfoCockpit(src)
- Description: Provides a custom form to display accounting information.
- Documentation: Patric Massing (Hans Auler GmbH - p.massing (at) auler.gmbh)
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
Documentation
Setup
Install the plugin over the osgi-console
For iDempiere 3.1 and 4.1 you need additional steps
- In the sql-folder of the plugin-source are two files.
- pat_facource.sql -> Is the needed view.
- pat_accountcourse.sql -> The function for AccountCourse
- The view and the function must be created in the database.
- A Update is coming soon, so the additional step in sql is no longer necessary.
Using the Cockpit
Menu
The plugin creates a new menu.
First a overview
The AccountInfoCockpit window has two tabs.
- The Query Tab: Corresponding parameters for the selected function.
- The Result Tab: Result are displayed here. After you pressed the refresh button, the AccountInfoCockpit switched automaticaly to the result Tab.
The Toolbar
- AccountCourse
- Accountsoverview
- Accountoverview
- SummaryAccountDocument
- Summary
- BalanceOfAccountsList
- TreeSummary
- HTML-Export
- CSV-Export
Overview of all implemented functionality
AccountCourse
Shows the current cumulated balance up to date at this line for the defined account in the defined date range. The starting balance is on the first line. The ending balance is on the last line.
- Client: The Client is the current used client. This parameter is not editable.
- Organisation: The Organisation is a list of organisations of the current client. You can choose any one of the organisations.
- Accounting-Schema: A list of all created Accounting-Schemas of the client.
- PeriodType: The PreriodType is an importand parameter. If you have the anualstatement posted, in the most cases this is posted in a Adjustment-Periode, so you can include or exclude or display only the Adjustment-Records.
- From/To Date: You have to define a timerange to filter the records.
- ValueFrom: With this function you have to select one of a account. In this function is only one account possible to display. So only one account makes sense.
Accountsoverview
Displays a overview of all accounts from the COA with a current balance.
- Client: The Client is the current used client. This parameter is not editable.
- Organisation: The Organisation is a list of organisations of the current client. You can choose any one of the organisations.
- Accounting-Schema: A list of all created Accounting-Schemas of the client.
- PeriodType: The PreriodType is an importand parameter. If you have the anualstatement posted, in the most cases this is posted in a Adjustment-Periode, so you can include or exclude or display only the Adjustment-Records.
Accountoverview
Displays a overview of the defined account with balance per accounting post.
You can select a record and zoom to document-source of the Accounting post.
- Client: The Client is the current used client. This parameter is not editable.
- Organisation: The Organisation is a list of organisations of the current client. You can choose any one of the organisations.
- Accounting-Schema: A list of all created Accounting-Schemas of the client.
- PeriodType: The PreriodType is an importand parameter. If you have the anualstatement posted, in the most cases this is posted in a Adjustment-Periode, so you can include or exclude or display only the Adjustment-Records.
- From/To Date: You have to define a timerange to filter the records.
- ValueFrom: With this function you have to select one of a account. In this function is only one account possible to display. So only one account makes sense.
- Dimensions: You can filter the content to dimentsions, to get only accounting facts for the defined account for a product, business partner, sales region or project.
SummaryAccountDocument
In the most cases each product (combination) generate a separate accounting post. If you
have 100 positions in your invoice as example, then the view of the
accounting posts for a document can be a bit confusing. The view in SummaryAccountDocument
show the posting as summary per account.
- Accounting-Schema: A List of all created Accounting-Schemas of the client.
- Documenttype: List of all document types.
- Document: You can choose the document for the selected doctype.
Summary
Shows the balance per year, month or day for a selected account.
Summary on Year
- Year Checkbox to show the totals of Debit, Credit and the balance per year.
- Month Checkbox to show the totals of Debit, Credit and the balance per month.
- Day Checkbox to show the totals of Debit, Credit and the balance per day.
- Client: The Client is the current used client. This parameter is not editable.
- Organisation: The Organisation is a list of organisations of the current client. You can choose any one of the organisations.
- Accounting-Schema: A list of all created Accounting-Schemas of the client.
- PeriodType: The PreriodType is an importand parameter. If you have the anualstatement posted, in the most cases this is posted in a Adjustment-Periode, so you can include or exclude or display only the Adjustment-Records.
- ValueFrom: With this function you have to select one of a account. In this function is only one account possible to display. So only one account makes sense.
Summary on Month
- DateFrom: You have to define the DateFrom to filter the records.
- DateTo: The Date To is automaticaly calculated to the end of the year.
Summary on Day
- DateFrom: You have to define the DateFrom to filter the records.
- DateTo: The Date To is automaticaly calculated to the end of the month.
BalanceOfAccountsList
List of all accounts with the balance for each account int the defined time period.
Also the balance before defined the time range (balance carried forward) and the ending balance.
- Client: The Client is the current used client. This parameter is not editable.
- Organisation: The Organisation is a list of organisations of the current client. You can choose any one of the organisations.
- Accounting-Schema: A list of all created Accounting-Schemas of the client.
- PeriodType: The PreriodType is an importand parameter. If you have the anualstatement posted, in the most cases this is posted in a Adjustment-Periode, so you can include or exclude or display only the Adjustment-Records.
- From/To Date: You have to define a timerange to filter the records.
TreeSummary
Displays a matrix of accounts (summary-entries) in horizontal representation. Balances per year, month and day.
TreeSummary on Year
- Year Checkbox to show the totals of Debit, Credit and the balance per year.
- Month Checkbox to show the totals of Debit, Credit and the balance per month.
- Day Checkbox to show the totals of Debit, Credit and the balance per day.
- Client: The Client is the current used client. This parameter is not editable.
- Organisation: The Organisation is a list of organisations of the current client. You can choose any one of the organisations.
- Accounting-Schema: A list of all created Accounting-Schemas of the client.
- PeriodType: The PreriodType is an importand parameter. If you have the anualstatement posted, in the most cases this is posted in a Adjustment-Periode, so you can include or exclude or display only the Adjustment-Records.
TreeSummary on Month
- DateFrom: You have to define the DateFrom to filter the records.
- DateTo: The Date To is automaticaly calculated to the end of the year.
TreeSummary on Day
- DateFrom: You have to define the DateFrom to filter the records.
- DateTo: The Date To is automaticaly calculated to the end of the month.
Export as html
Export as CSV
Export the result as a txt-file, tab as delimiter and linebreak \(\\n\). So it is possible to import the file or copy and paste the information in your favorite spreadsheet program.
