Consolidating reports between databases: Difference between revisions
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
== Consolidating Reporting == | |||
=== Consolidating Financial Statements === | |||
These are Trial Balances, Profit and Loss, Balance sheets etc showing balances, movement etc per account. | These are Trial Balances, Profit and Loss, Balance sheets etc showing balances, movement etc per account. | ||
| Line 13: | Line 13: | ||
Works in NEOSYS now | Works in NEOSYS now | ||
=== Consolidating Billing Analysis Reports === | |||
These are reports of total billing, costs etc by client, supplier, type and market etc. | These are reports of total billing, costs etc by client, supplier, type and market etc. | ||
| Line 23: | Line 23: | ||
Doesnt work in NEOSYS now but it will be eventually | Doesnt work in NEOSYS now but it will be eventually | ||
=== Consolidating Ledger Statements === | |||
These require access to individual transactions and are unlikely to be provided by NEOSYS in the future since they can be done happily within a database. | These require access to individual transactions and are unlikely to be provided by NEOSYS in the future since they can be done happily within a database. | ||
If a client wants a separate database to do their own thing then there is this price to pay. NEOSYS does not support all three consolidations because there is too little demand to justify the programming when there is an alternative for the client. | If a client wants a separate database to do their own thing then there is this price to pay. NEOSYS does not support all three consolidations because there is too little demand to justify the programming when there is an alternative for the client. | ||
Latest revision as of 08:47, 25 February 2018
Consolidating Reporting
Consolidating Financial Statements
These are Trial Balances, Profit and Loss, Balance sheets etc showing balances, movement etc per account.
Data is always aggregated and never shows any individual transactions.
Differing account numbers between datasets can be handled by using NEOSYS mapping procedure.
Technically these reports just require inter-database access to the NEOSYS BALANCES file
Works in NEOSYS now
Consolidating Billing Analysis Reports
These are reports of total billing, costs etc by client, supplier, type and market etc.
Data is always aggregated and never shows any individual transactions
Technically these reports just require inter-database access to the NEOSYS ANALYSIS file and reference files.
Doesnt work in NEOSYS now but it will be eventually
Consolidating Ledger Statements
These require access to individual transactions and are unlikely to be provided by NEOSYS in the future since they can be done happily within a database.
If a client wants a separate database to do their own thing then there is this price to pay. NEOSYS does not support all three consolidations because there is too little demand to justify the programming when there is an alternative for the client.
