Plugin: AccountInfoCockpit

From iDempiere en
Jump to navigation Jump to search

Account Info Cockpit


This Page is under construction




Plugin AccountInfoCockpit
  • 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)
  • Binaries : For iDempiere Version 3.1, 4.1, 6.2 and 7.1 AccountInfoCockpit(bin)
  • 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

  1. In the sql-folder of the plugin-source are two files.
  2. pat_facource.sql -> Is the needed view.
  3. pat_accountcourse.sql -> The function for AccountCourse
  4. The view and the function must be created in the database.
  5. 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.

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 AccountInfoCockpit


The Toolbar

The Toolbar
  1. AccountCourse
  2. Accountsoverview
  3. Accountoverview
  4. SummaryAccountDocument
  5. Summary
  6. BalanceOfAccountsList
  7. TreeSummary
  8. HTML-Export
  9. CSV-Export




Overview of all implemented functionality

Toolbar Oerview




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.


Parameter AccountCourse


  • 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.



Result AccountCourse

Accountsoverview

Displays a overview of all accounts from the COA with a current balance.


Parameter Accountsoverview


  • 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.



Result Accountsoverview

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.


Parameter Accountoverview


  • 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.



Result Accountoverview

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.


Parameter SummaryAccountDocument


  • 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.


Result SummaryAccountDocument

Summary

Shows the balance per year, month or day for a selected account.


Summary on Year
Parameter 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.



Result Summary on Year
Summary on Month
Parameter 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.



Result Summary on Month




Summary on Day
Parameter 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.



Result Summary on Day

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.


Parameter BalanceOfAccountsList


  • 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.



Result BalanceOfAccountsList

TreeSummary

Displays a matrix of accounts (summary-entries) in horizontal representation. Balances per year, month and day.



TreeSummary on Year
Parameter 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.



Result TreeSummary on Year


TreeSummary on Month
Parameter 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.



Result TreeSummary on Month


TreeSummary on Day
Parameter 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.



Result TreeSummary on Day

Export as html

Result of HTML-Export

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.


Result of Text-Export in your favorite text editor


Result of Text-Export in your favorite spredsheet program