ORCA Financial developed by TCS Created with Caché
Home Page Solutions Services Company Partnerships Contact Us Site Map  
> Solutions > ORCA Financial Product Overview > Functionality > Reporting > Query Reports

Query Reports

Account Transactions
Account References
Aged Account References
Overdue Documents Summary
Account Summary
Account Budget
Control Account Drill Down
Account Drill Down
Account Posting Drill Down
Account Posting Transactions
Supplier Expense Analysis
Inventory Sales History
Outstanding Purchase Orders
Outstanding Sales Orders
Outstanding Sales Shipments
Account Images
Account Notes
Payment Overdue Calls
Inventory Purchasing Analysis
Job Billing Summary
Account Redirection Schedule
Warehouse Account Costs

Account Transactions

Print action from the Trans option in Account Query produces listings of transactions on the account. Report content is determined by the date range, transaction type and code, forex code, all or current transactions only, earliest or latest date sequence, and if cash reporting is enabled, cash basis selections. Optionally, break references, i.e. lot/serial references for inventory accounts or analysis references for ledger accounts, may be incorporated where applicable. View sample reports TCSAcctTran, TCSAcctTran-Cash, TCSAcctTran-FX, TCSAcctTran-FX-Cash, TCSAcctTran-Ledg, TCSAcctTran-Ledg-Cash, TCSAcctTran-Inv, and TCSAcctTran-Inv-Brks.

Account References

Print action from the Reference option in Account Query produces listings of net values by transaction reference for the account. Report content is determined by the reference, transaction type and code, all or current transactions only, and if cash reporting is enabled, cash basis selections. View sample reports TCSAcctRef, and TCSAcctRef-Cash.

Aged Account References

Print action from the Age option in Debtor or Receivable Query and Creditor or Payable Query produces listings for the account of net values by transaction reference, in due date sequence. Report content is determined by the as at date, and if cash reporting is enabled, cash basis selections, and may be presented in either summary format at reference level, detailed format including individual transaction level information for all references, or in variance format where transaction level information is restricted to only those references for which the amount outstanding differs from the amount originally due. View sample reports TCSAcctAgedRef-Sum, TCSAcctAgedRef-Det, and TCSAcctAgedRef-Var.

Overdue Documents Summary

Documents action from the Age option in Debtor or Receivable Query produces summary or prooflist reports detailing outstanding debtor documents to be re-printed. The report content is determined by the list of documents, i.e. invoices, credit notes, cash receipts, etc, that have been selected, typically to provide supporting documentation for overdue letters. View sample report TCSAcctAgedRefDocu.

Account Summary

Print action from the Summary option in Account Query produces listings of periodic values and quantities for the account. Report content is determined by the date range, transaction type and code, forex code, and if cash reporting is enabled, cash basis selections. Additional selections provide for the inclusion or exclusion of brought forward balances and year end closing entries, and the presentation of total values only, or absolute (i.e. unsigned) values for comparative purposes. View sample reports TCSAcctSumm, and TCSAcctSumm-Cash.

Account Budget

Print action from the Budget option in Account Query produces listings of periodic financial, budget and variance values for composite, ledger, bank and control accounts. Report content is determined by the date range, transaction code, forex code, and if cash reporting is enabled, cash basis selections. Additional selections provide for the inclusion or exclusion of brought forward balances and year end closing entries. View sample reports TCSAcctBudget, and TCSAcctBudget-Cash.

Control Account Drill Down

Print action from the Drill option in Control Account Query produces listings of balances for subsidiary, or sub-ledger, accounts. Report content is determined by the date range, transaction type and code, and forex code selections. Zero balance accounts may be optionally included. View sample report TCSAcctCtrlDrill.

Account Drill Down

Print action from the Drill option in Composite Account Query produces listings of balances for linked, or associated, composite accounts. Report content is determined by the date range, transaction type and code, and forex code selections. Additionally, the listing may be restricted to balances associated with selected analysis filters only. View sample reports TCSAcctDrill, and TCSAcctDrill-Sel.

Account Posting Drill Down

Print action from the aCcount option in Composite Account Query produces listings of balances for linked, or associated, posting level accounts. Report content is determined by the date range, transaction type and code, and forex code selections. View sample report TCSAcctPostDrill.

Account Posting Transactions

Print action from the Trans option in Composite Account Query produces listings of transactions on linked, or associated, posting level accounts. Report content is determined by the date range, transaction type and code, forex code, and all or current transactions only selections. Additionally, the listing may be restricted to transactions associated with selected analysis filters only. View sample reports TCSAcctPostTran, and TCSAcctPostTran-Sel.

Supplier Expense Analysis

Print action from the Expenses option in Creditor or Payable Query produces listings of supplier invoice expenditures analysed by expense account number. Report content is determined by the date range specified and the expense type selection, that enables transactions for either all accounts, those other than inventory, or inventory only to be be presented. Additional selections provide for the presentation of values in the supplier's foreign currency if applicable, and the listing of outstanding supplier orders. View sample reports TCSCredExpAnal-All, TCSCredExpAnal-Excl-Inventory, TCSCredExpAnal-Only-Inventory, TCSCredExpAnal-Order-All, and TCSCredExpAnal-Order-FX-All.

Inventory Sales History

Print action from the History option in Inventory Account Query produces listings of annual sales quantities, accompanied by the 12 individual months sales quantities, analysed by either source warehouse or selling department. The report content also includes summary totals for the item across all warehouses or departments as appropriate. View sample reports TCSInvSalesHist-Whse, and TCSInvSalesHist-Dept.

Outstanding Purchase Orders

Print action from the Order option in Account Query produces listings of outstanding purchase orders on the account, e.g. a supplier, or for the account, e.g. an inventory item. The report content is determined by the date range and expiry date selections, and for suppliers, by the summary, i.e. document totals only, or details, i.e. document lines and totals, report type selection. Additionally, where the item ordered is a job account with a vehicle defined, the details listed may include the registration number and the name of the current operator of the vehicle. Inventory item orders are accompanied by details from any associated 'in process' purchase shipments. An additional selection provides the ability to list outstanding purchase quotes. View sample reports TCSAcctPOrdSupp-Sum, TCSAcctPOrdSupp-Det, TCSAcctPOrdSupp-Det-Job, TCSAcctPOrdItem, TCSAcctPOrdItem-PShp, TCSAcctPQuoSupp-Sum, TCSAcctPQuoSupp-Det, and TCSAcctPQuoItem.

Outstanding Sales Orders

Print action from the eXpected option in Account Query produces listings of outstanding sales orders on the account, e.g. a customer, or for the account, e.g. an inventory item. The report content is determined by the order date range and expiry date selections, and for customers, by the summary, i.e document totals only, or details, i.e. document lines and totals, report type selection. Additional selections provides the ability to list outstanding sales quotes and outstanding hire contracts. View sample reports TCSAcctSOrdCust-Sum, TCSAcctSOrdCust-Det, TCSAcctSOrdItem, TCSAcctSQuoCust-Sum, TCSAcctSQuoCust-Det, TCSAcctSQuoItem, TCSAcctSHireCust-Sum, TCSAcctSHireCust-Det, and TCSAcctSHireItem.

Outstanding Sales Shipments

Print action from the Unposted option in Account Query produces listings of outstanding sales shipments on the account, e.g. a customer, or for the account, e.g. an inventory item. Report content is determined by the shipment date range selections. View sample reports TCSAcctSShpCust, and TCSAcctSShpItem.

Account Images

Print action from the Image option in Account Query produces listings of the image, e.g. a jpg or gif file, associated with the account. Both inventory and vehicle accounts offer a sub-selection of either Image or Drawing. View sample report TCSAcctImage.

Account Notes

Print action from the Notes option in Account Query produces listings of notes text recorded on the account. View sample report TCSAcctNote.

Payment Overdue Calls

Unpaid action in Debtor Contacts Query or Creditor Contacts Query produces listings of payment overdue call details and associated follow-up actions either taken or proposed. All calls, or open calls only, may be specified and the listing may optionally include call notes. View sample report TCSAcctCallPmntODue-DR.

Inventory Purchasing Analysis

Print action from the inVentory option in Creditor or Payable Query produces listings of inventory items purchased from the supplier. Report content includes account numbers and names, supplier item numbers, supplier costs in supplier currency, last purchase order numbers and dates, annual order quantities, on hand stocks, average costs and total inventory values, and annual sales quantities. View sample report TCSCredInvItems.

Job Billing Summary

Print action from the Billing option in Job Account Query produces listings of accumulated costs, and subsequent billing and adjustment details, analysed by cost category and summarised by total job cost, total job revenue billed, total job revenue written off, and total value cleared from the job account, i.e. work in progress. The details simulate the job invoice presentation, enabling both a preview of that document's content prior to the job billing process, or a detailed analysis after job billing or any subsequent credit adjustment activity. Labour charges may be presented in either summarised or detailed format, and optionally, job descriptive information may be restricted to remedial action text only. View sample reports TCSJobBillSumm-Labour-Sum, TCSJobBillSumm-Labour-Det, TCSJobBillSumm-Remedy-Only, and TCSJobBillSumm-Invoiced.

Account Redirection Schedule

Print action from the Redirection option in Account Audit Query produces listings of the accounts that have a posting redirection to this account. Report content is determined by the redirection types selection. View sample reports TCSAcctRedirect-Debt, and TCSAcctRedirect-Cred.

Warehouse Account Costs

Print action from the Costs option in Warehouse Acct Costs Query produces listings of transactions on the account, analysed into inwards and outwards inventory movement sections, on either a FIFO or LIFO costing basis. Report content is determined by the basis, bin location and as at date selections, and presents transaction dates, source document numbers and types, transaction set and line numbers, and transaction quantities, accompanied by remaining quantities and values. All transactions may be listed, or the report may be optionally restricted to only those inwards transactions with a remaining quantity for FIFO or LIFO as applicable. View sample reports TCSAcctWhseCosting-FIFO, and TCSAcctWhseCosting-LIFO.