TrueERP wiki - User contributions [en]

Export to Report DB

2011-02-09T00:42:09Z

Admin:

<menu name=myMenu align=center>
More Detail=
[[Audit Trail List]]
[[Backup]]
[[Company Information]]
[[Email To]]
[[Export to Report DB]]
[[Multi-site]]
[[Preferences]]
[[Restore]]
[[Setup Docs Path]]
[[Utilities Reports]]
</menu>
== Overview ==

This enables you to copy the tables from ERP and export them in an ODBC (Open Data Base Connectivity) format to enable the tables to be used in any application that you want. eg. Excel, Access, Open Office

== Compatibility ==

NOTE: MS Windows 7 no longer supports ODBC so this functionality is restricted to earlier versions of Windows

*Select Utilities tab
*Export to Report DB button

There will be a list of tables that can be export 

*Select by clicking in the box along side of the Table you require. The button '''Select all''' automatically selects all of the tables The button '''Unselect all''' clears the selection
*Then select the Export Button

== Preparing ODBC Alias: ==

*Go to the Control Panel and select Administrative Tools
*Double click Data Sources (ODBC) option
*Select User DSN tab then select Add
*From the list select MySQL ODBC driver and press the Finish button (if you do not have the MySQL ODBC driver, download it from the internet) at http://dev.mysql.com/downloads/connector/odbc/5.1.html

Change the values of the following fields:

*Connection Name: ERP_Export
*Host name/IP address: Name of MySQL server, in this case "Localhost"
*Port: 3309
*User Name: Export
*Password: Export then press OK

First time you export to the read only tables the password is not active. Export to the read only tables again to make the password active.

== Connecting the application to the reporting Data: ==

Make sure that you have prepared ODBC Alias as described above Start up the Application eg. Excel and from the main menu select Data=>Import External Data=>New Database Query From the Tab Databases select Export Data Alias and press OK (You should get the List of exported Tables)

Export to Report DB

2011-02-09T00:41:24Z

Admin:

<menu name=myMenu align=center>
More Detail=
[[Audit Trail List]]
[[Backup]]
[[Company Information]]
[[Email To]]
[[Export to Report DB]]
[[Multi-site]]
[[Preferences]]
[[Restore]]
[[Setup Docs Path]]
[[Utilities Reports]]
</menu>
== Overview ==

This enables you to copy the tables from ERP and export them in an ODBC (Open Data Base Connectivity) format to enable the tables to be used in any application that you want. eg. Excel, Access, Open Office

NOTE: MS Windows 7 no longer supports ODBC so this functionality is restricted to earlier versions of Windows

*Select Utilities tab
*Export to Report DB button

There will be a list of tables that can be export 

*Select by clicking in the box along side of the Table you require. The button '''Select all''' automatically selects all of the tables The button '''Unselect all''' clears the selection
*Then select the Export Button

== Preparing ODBC Alias: ==

*Go to the Control Panel and select Administrative Tools
*Double click Data Sources (ODBC) option
*Select User DSN tab then select Add
*From the list select MySQL ODBC driver and press the Finish button (if you do not have the MySQL ODBC driver, download it from the internet) at http://dev.mysql.com/downloads/connector/odbc/5.1.html

Change the values of the following fields:

*Connection Name: ERP_Export
*Host name/IP address: Name of MySQL server, in this case "Localhost"
*Port: 3309
*User Name: Export
*Password: Export then press OK

First time you export to the read only tables the password is not active. Export to the read only tables again to make the password active.

== Connecting the application to the reporting Data: ==

Make sure that you have prepared ODBC Alias as described above Start up the Application eg. Excel and from the main menu select Data=>Import External Data=>New Database Query From the Tab Databases select Export Data Alias and press OK (You should get the List of exported Tables)

Payroll Posting

2011-02-01T05:25:20Z

Admin: Created page with "== Overview == From withing the Payroll History Report, there is a GL button on each line. By selecting this button you can see each of the account postings that arise from the ..."

== Overview ==

From withing the Payroll History Report, there is a GL button on each line. By selecting this button you can see each of the account postings that arise from the individuals pay.  Some of these postings bare some scrutiny to understand.

== Leave ==

Where applicable leave is accrued each pay (this may be based on a "per pay", "per hour" or "per week" depending on the selections made in each award).  The value of that leave accrued is posted as an expense to the leave expense account (by default Leave Provision) and the other side of the posting is to the Leave Liability account because this is money not yet paid, but liable to be paid at some future date when leave is taken.  The actual accounts used are selected under payroll preferences. 

When leave is taken, the Liability account is reduced and the expense is moved from Leave Provision to Net Wages and PAYG Tax.  This last posting is to allow for easier reporting.  The Profit & Loss report will show both accounts so that you can see which expense has been paid, and which is still liable for payment.  It is possible for the Leave Provision to appear as a positive in the Profit And Loss if more leave has been taken in the current year than has been accrued or in other words, leave accrued in prior years has been taken in the current year.

Pay History

2011-02-01T04:49:54Z

Admin:

<menu name="myMenu2" align="center">
More Detail =
[[Address]]
[[Allowances]]
[[Banking]]
[[Commission]]
[[Custom Fields]]
[[Deductions]]
[[Documents]]
[[Fringe Benefits]]
[[Hours]]
[[Information]]
[[Leave accruals]]
[[Pay Details]]
[[Pay History]]
[[Photo ID]]
[[Report]]
[[Superannuation]]
[[Taxation]]
[[Workcover]]
</menu>

== Overview==

Pay History is a list and printable report detailing all wages your Company has paid to date, and recorded within your ERP program. This report can be run by date range based on the 'Pay Date', or by selection the 'Date Paid'. This report can be accessed from within the Payroll Tab by using the 'Pay History' button, or from within the 'Report Selector', Payroll radio button.

== How To Use Pay History ==

*Select the 'Payroll Tab'
*Select the 'Pay History' Button

As per other lists within ERP you can: -

*Customise Pay History.
*Export Pay History.
*Perform Searches within Pay History.
*Execute Filters within Pay History.
*Print Pay History.
*Select a Date Range or Custom Range to display in the list refer to Global Features.

Please refer to Global Features for details on the functionality of the above choices.

*Select the relevant radio button to display the required list, i.e. 'Pays', 'Deleted Pays', 'All Pays'.
*Select 'Use Date Paid' to view your Pay History by the actual date of paying the wages. The criteria will load thelist in respect to the Date Range selection you have chosen.

*Select the + sign (once selected it will display as - ), in the 'GL' column to display the General Ledger account breakdown of the [[Payroll Posting|payroll posting]] for each individual employee pay.
*Select the + sign (once selected it will display as - ), in the 'Split' column to display the breakdown of how a wage has been split between bank accounts or method of payment.

e.g. An employee may wish to have the bulk of their pay credited to their main bank account, and have a portion credited to their savings account. This would display in the split field against each pay that it applied to. See New Employee Banking

*Select the 'Print Report' button to preview/print the 'Pay History Report'.

All columns with values displayed in the Pay History list, display a column tally at the bottom.

'Total Records' in the current list being viewed is displayed at the bottom left of screen. 'Current Filter', e.g. 'Deleted=F' is also displayed at bottom left of screen. 'Auto List Updates Disabled' is displayed at bottom right of screen when this preference is on.

Pay History

2011-02-01T04:46:02Z

Admin:

<menu name="myMenu2" align="center">
More Detail =
[[Address]]
[[Allowances]]
[[Banking]]
[[Commission]]
[[Custom Fields]]
[[Deductions]]
[[Documents]]
[[Fringe Benefits]]
[[Hours]]
[[Information]]
[[Leave accruals]]
[[Pay Details]]
[[Pay History]]
[[Photo ID]]
[[Report]]
[[Superannuation]]
[[Taxation]]
[[Workcover]]
</menu>

== Overview==

Pay History is a list and printable report detailing all wages your Company has paid to date, and recorded within your ERP program. This report can be run by date range based on the 'Pay Date', or by selection the 'Date Paid'. This report can be accessed from within the Payroll Tab by using the 'Pay History' button, or from within the 'Report Selector', Payroll radio button.

== How To Use Pay History ==

*Select the 'Payroll Tab'
*Select the 'Pay History' Button

As per other lists within ERP you can: -

*Customise Pay History.
*Export Pay History.
*Perform Searches within Pay History.
*Execute Filters within Pay History.
*Print Pay History.
*Select a Date Range or Custom Range to display in the list refer to Global Features.

Please refer to Global Features for details on the functionality of the above choices.

*Select the relevant radio button to display the required list, i.e. 'Pays', 'Deleted Pays', 'All Pays'.
*Select 'Use Date Paid' to view your Pay History by the actual date of paying the wages. The criteria will load thelist in respect to the Date Range selection you have chosen.

*Select the + sign (once selected it will display as - ), in the 'GL' column to display the General Ledger account breakdown of the payroll posting for each individual employee pay.
*Select the + sign (once selected it will display as - ), in the 'Split' column to display the breakdown of how a wage has been split between bank accounts or method of payment.

e.g. An employee may wish to have the bulk of their pay credited to their main bank account, and have a portion credited to their savings account. This would display in the split field against each pay that it applied to. See New Employee Banking

*Select the 'Print Report' button to preview/print the 'Pay History Report'.

All columns with values displayed in the Pay History list, display a column tally at the bottom.

'Total Records' in the current list being viewed is displayed at the bottom left of screen. 'Current Filter', e.g. 'Deleted=F' is also displayed at bottom left of screen. 'Auto List Updates Disabled' is displayed at bottom right of screen when this preference is on.

Pay History

2011-02-01T04:44:21Z

Admin:

<menu align="center" name="myMenu2">
More Detail =
[[Address]]
[[Allowances]]
[[Banking]]
[[Commission]]
[[Custom Fields]]
[[Deductions]]
[[Documents]]
[[Fringe Benefits]]
[[Hours]]
[[Information]]
[[Leave accruals]]
[[Pay Details]]
[[Pay History]]
[[Photo ID]]
[[Report]]
[[Superannuation]]
[[Taxation]]
[[Workcover]]
</menu>

== Overview
Pay History is a list and printable report detailing all wages your Company has paid to date, and recorded within your ERP program. This report can be run by date range based on the 'Pay Date', or by selection the 'Date Paid'. This report can be accessed from within the Payroll Tab by using the 'Pay History' button, or from within the 'Report Selector', Payroll radio button.

== How To Use Pay History ==

*Select the 'Payroll Tab'
*Select the 'Pay History' Button

As per other lists within ERP you can: -

*Customise Pay History.
*Export Pay History.
*Perform Searches within Pay History.
*Execute Filters within Pay History.
*Print Pay History.
*Select a Date Range or Custom Range to display in the list refer to Global Features.

Please refer to Global Features for details on the functionality of the above choices.

Select the relevant radio button to display the required list, i.e. 'Pays', 'Deleted Pays', 'All Pays'. Select 'Use Date Paid' to view your Pay History by the actual date of paying the wages. The criteria will load the list in respect to the Date Range selection you have chosen.

*Select the + sign (once selected it will display as - ), in the 'GL' column to display the General Ledger account breakdown of the payroll posting for each individual employee pay.
*Select the + sign (once selected it will display as - ), in the 'Split' column to display the breakdown of how a wage has been split between bank accounts or method of payment.

e.g. An employee may wish to have the bulk of their pay credited to their main bank account, and have a portion credited to their savings account. This would display in the split field against each pay that it applied to. See New Employee Banking

*Select the 'Print Report' button to preview/print the 'Pay History Report'.

All columns with values displayed in the Pay History list, display a column tally at the bottom.

'Total Records' in the current list being viewed is displayed at the bottom left of screen. 'Current Filter', e.g. 'Deleted=F' is also displayed at bottom left of screen. 'Auto List Updates Disabled' is displayed at bottom right of screen when this preference is on. 
==

Help:Editing

2011-01-21T06:12:07Z

Admin:

== Overview ==
Before creating a new page take note of the layout of other pages on the Trueerp Wiki and maintain as far as possible a consistent layout.

== Headings ==
To create a heading type two = symbols either side of the heading or select the [[File:heading.png]] icon from the top of the edit page.

== Bullet Points ==

In the edit screen the * symbol indicates a bullet point. ** is an indented bullet point

== Links ==
To create a link to another page type the name of the page and highlight it. Then click on the [[File:button_link.png]] icon in the edit bar. This will create a link to the page. The page does not have to exist prior to creating the link but can be created when you click on that link.

== Images ==
Only administrators have access to upload images to be placed in pages. If an images has been uploaded in can be added to a page using the [[File:button_image.png]] icon. You must know the full name of the image you are embedding.

== Languages ==
The default language of the site is English. To create a new version of a page in a supported language other than English, the page name must have the country code appended. eg. Where "Accounts" would be the English version of the Accounts page, "Accounts/fr" is the French version. The create a new page search for the new page name. If it does not exist you will be prompted to create it.

Currently supported languages and their codes are:
*French - fr
*Arabic - ar
*Tagalog - tl
*Hind - hi

== Copying Text ==
Under no circumstances should content be copied from a MS Word document or other wordprocessing document as this will introduce hidden characters with unpredictable results. If copying text copy to notepad, remote unwanted linebreaks and then recopy from notepad to the wiki editor.

== Quote Box ==
To add text in a shaded quote box simply leave a blank space at the start of the line. Note that word wrap doesn't work inside quote boxes so you must add line returns where required.

== Menus ==
A menu (blue button) can be copied from one article to a new one. The menu items are in double square brackets and can be deleted or added to in the same way that you would add a link.

Help:Editing

2011-01-21T06:02:06Z

Admin: /* Languages */

Take note of the layout of other pages on the Trueerp Wiki and maintain as far as possible a consistent layout.

== Headings ==
To create a heading type two = symbols either side of the heading or select the [[File:heading.png]] icon from the top of the edit page.

== Bullet Points ==

In the edit screen the * symbol indicates a bullet point. ** is an indented bullet point

== Links ==
To create a link to another page type the name of the page and highlight it. Then click on the [[File:button_link.png]] icon in the edit bar. This will create a link to the page. The page does not have to exist prior to creating the link but can be created when you click on that link.

== Images ==
Only administrators have access to upload images to be placed in pages. If an images has been uploaded in can be added to a page using the [[File:button_image.png]] icon. You must know the full name of the image you are embedding.

== Languages ==
The default language of the site is English. To create a new version of a page in a supported language other than English, the page name must have the country code appended. eg. Where "Accounts" would be the English version of the Accounts page, "Accounts/fr" is the French version. The create a new page search for the new page name. If it does not exist you will be prompted to create it.

Currently supported languages and their codes are:
*French - fr
*Arabic - ar
*Tagalog - tl
*Hind - hi

== Copying Text ==
Under no circumstances should content be copied from a MS Word document or other wordprocessing document as this will introduce hidden characters with unpredictable results. If copying text copy to notepad, remote unwanted linebreaks and then recopy from notepad to the wiki editor.

== Quote Box ==
To add text in a shaded quote box simply leave a blank space at the start of the line. Note that word wrap doesn't work inside quote boxes so you must add line returns where required.

== Menus ==
A menu (blue button) can be copied from one article to a new one. The menu items are in double square brackets and can be deleted or added to in the same way that you would add a link.

Job Report (Budget vs Actual)

2011-01-21T05:57:56Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget vs Actual

2011-01-21T05:49:39Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget Variation

2011-01-21T05:49:29Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget Reports

2011-01-21T05:49:18Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget Profit and Loss Report

2011-01-21T05:49:07Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget List

2011-01-21T05:48:56Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget Definition List

2011-01-21T05:48:44Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget Definition

2011-01-21T05:48:34Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Budget

2011-01-21T05:48:14Z

Admin:

<menu name=myMenu align=center>
More Detail=
[[Account List for Budget]]
[[Budgets]]
[[Budget Definition]]
[[Budget Definition List]]
[[Budget List]]
[[Budget Profit and Loss Report]]
[[Budget Reports]]
[[Budget Variation]]
[[Budget vs Actual]]
[[Job Report (Budget vs Actual)]]
</menu>
== Budgets and Budgeting ==
''' 
<ul><li>Budget is a future plan which sets out a business’s financial targets. 
<li>Budgeting refers to the preparation of budgets - the drawing up of financial plans and monitoring the performance of a
business in attaining them</ul>
== Formal definition of a budget ==
<ul><li> “A budget is a quantitative statement, for a defined period of time, which may include planned revenues, expenses,
assets, liabilities and cash flows. A budget provides a focus for the organisation and aids the co-ordination of activities
and facilitates control”. (CIMA) 
<li>Budgets are prepared in advance of a defined period of time. They are based on the objectives of the business and
are intended to show how policies are to be pursued in order to achieve objectives.</ul>

== What is a budget? ==
'''
A budget <ul>
<li>is a financial plan.
<li>sets out a businesses financial targets.
<li>is a plan expressed in money.
<li>an agreed plan of action over a given period.
<li>an agreed plan establishing, in numerical or financial terms, the policy to be pursued and the anticipated outcomes
of that policy.</ul>

Within the Budget tab of ERP you are able to create new budgets for the company or any Department/Cost Centre
thereof. You are able to have multiple budgets and what-if scenarios for an unlimited number of fiscal periods. You
are able to create budgets for either daily, weekly, monthly, quarterly or yearly.

The program allows you to track actual figures in comparison to budgeted figures, as well as view the budget in direct
comparison to the Profit and Loss.

These features are also available by using the drop down menu through Accounts / budgets

The objective of this area of the program is allow the forecasting and tracking of figures on an account by account
basis, enabling the operator to quickly and accurately identify any areas that need attention and that have fallen
outside of the parameters, before they become a problem.

The following buttons take you to the differnt areas within budgeting.

== Budget definition ==
- This button allows you to name and define a new budget including which accounts it affects,
time periods, time intervals and which departments or cost centres the new budget relates to.
 See [[Budget_Definition]]

Budget Definition List- This button allows you to view all existing budget definitions and edit these by double
clicking on your selection
 See [[Budget_Definition_List]]

Budget - Allows you to add a new budget
 See [[Budget]]

Budget List - This Button provides a list of all existing budgets, the details of which can be viewed by double
clicking your selection
 See [[Budget_List]]
Budget Profit & Loss Report - This button opens a Profit & Loss report that shows the budgeted figures as they
stand in a reportable format against your profit and loss
 See [[Budget_Profit_&_Loss]]

Budget vs Actual- This button allows the user to view how the company is tracking against a budget for any of the
budgets that currently exist.
 See [[Budget_vs_Actual]]

Account List for Budget - This button will display the Chart of Accounts (list of all accounts) that have an existing
budget set against them
 See [[Account_List_for_Budget]]

Job Report (Budget vs Actual) - View Budget vs Actual figures by customer job allowing you to see how any
particular job is tracking against its budget
 See [[Job_Report_(Budget_vs_Actual)]]

Budget Variation - This button allows you to select an existing budget, and change the period, increase or decrease
the expectations, by either a percentage or dollar amount allowing you to adjust budgets to account for changed
circumstances
 See [[Budget_Variation]]

Budget Reports - This button triggers the report selector with the Budgets area open.
 See [[Budget_Reports]]

Budgets

2011-01-21T05:46:58Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit and Loss Rep..."

Account List for Budget

2011-01-21T05:46:29Z

Admin: Created page with "<menu name=myMenu align=center> More Detail= Account List for Budget Budgets Budget Definition Budget Definition List Budget List [[Budget Profit & Loss Repor..."

<menu name=myMenu align=center>
More Detail=
[[Account List for Budget]]
[[Budgets]]
[[Budget Definition]]
[[Budget Definition List]]
[[Budget List]]
[[Budget Profit & Loss Report]]
[[Budget Reports]]
[[Budget Variation]]
[[Budget vs Actual]]
[[Job Report (Budget vs Actual)]]
</menu>

== Overview ==

To Be Deposited

2011-01-21T05:43:27Z