Consolidating reports between databases

From NEOSYS User Support Wiki
Jump to navigationJump to search

1 Consolidating Reporting

1.1 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

1.2 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

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