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 > Purchases Reports

Purchases Reports

Buyer Purchase Invoice Print
Expired Purchase Orders
Expired Purchase Quotes
Open Purchase Orders Report
Open Purchase Quotes Report
Open Purchase Shipments Report
Outstanding Purchase Approvals
Purchase Invoice Report
Purchase Order Analysis
Purchase Variance Analysis
Purchases Invoice Register
Purchases Supply Statistics
Purchasing Authorities Report
Shipment Binning Report
Shipment Costing Report
Status of Purchase Invoices
Status of Purchase Orders
Status of Purchase Quotes
Status of Purchase Shipments
Vehicle Purchase Fwd Cover

Buyer Purchase Invoice Print

The Buyer Purchase Invoice Print option provides the capability for printing buyer generated purchase invoices and purchase credits for a specified date. They may be printed as a consolidated group for each supplier, optionally within postcodes, or simply in invoice number sequence. The production of the document formats is preceded by the printing of a summary or control report, listing the documents produced and the output type, i.e. print, fax or email, applicable for each. Note that format printing is prohibited for supplier's with no tax number defined. View sample reports TCSDocuPInvBatch, and TCSDocuPInvFormat.

Expired Purchase Orders

The Expired Purchase Orders option provides the capability for listing and cancelling purchase orders which have expired. The report provides a prooflist of proposed order cancellations presenting order numbers, order dates, expiry dates, supplier account numbers and names, internal references, due dates, payment dates and terms and total order values, accompanied by 'line' level data including item codes and descriptions, order quantities, unit costs and order values. The 'update' option provides for the cancellation and automatic submission of orders for transaction processing. View sample report TCSDocuPOrdExpiry.

Expired Purchase Quotes

The Expired Purchase Quotes option provides the capability for listing and cancelling purchase quotations which have expired. The report provides a prooflist of proposed quote cancellations, presenting quote numbers, quote dates, expiry dates, supplier account numbers and names, internal references, payment terms, payment dates and total quote values, accompanied by 'line' level data including item codes and descriptions, purchase quantities, unit costs and quote values. The 'update' option provides for the cancellation and automatic submission of expired purchase quotes for processing. View sample report TCSDocuPQuoExpiry.

Open Purchase Orders Report

The Open Purchase Orders Report option provides the capability for producing selective listings of open, i.e. outstanding, purchase orders, as defined by the department, order number range, order date range, due date range and format requirements specified. Additionally, 'New' status orders, i.e. incomplete or in-process documents, may be optionally included. The summary format presents order numbers, order dates, expiry dates, supplier account numbers and names, due dates, payment terms and dates, and total quantities and total values outstanding. The details format incorporates the summary information, accompanied by order line level data including item codes and descriptions, and the quantities, unit costs and values remaining on order. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in order number, order date, due date, payment date, supplier name, creating user name or department order, with sub-totals provided for the by supplier, by user and by department selections. View sample reports TCSDocuPOrdOpen-Sum, TCSDocuPOrdOpen-Sum-Supp, TCSDocuPOrdOpen-Det, and TCSDocuPOrdOpen-Det-Supp.

Open Purchase Quotes Report

The Open Purchase Quotes Report option provides the capability for producing selective listings of open, i.e. outstanding, purchase quotations, as defined by the department, quote number range, quote date range and format requirements specified. The summary format presents quote numbers, quote dates, expiry dates, supplier account numbers and names, and total quantities and total values outstanding. The details format incorporates the summary information, accompanied by quote line level data including item codes and descriptions, and quantities, unit costs and values awaiting acceptance. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in quote number, quote date, supplier name or department order, with sub-totals provided for the by supplier and by department selections. View sample reports TCSDocuPQuoOpen-Sum, TCSDocuPQuoOpen-Sum-Supp, TCSDocuPQuoOpen-Sum-FX, TCSDocuPQuoOpen-Det, TCSDocuPQuoOpen-Det-Dept, and TCSDocuPQuoOpen-Det-FX.

Open Purchase Shipments Report

The Open Purchase Shipments Report option provides the capability for producing selective listings of open, i.e. outstanding, purchase shipments, as defined by the department, shipment number range, shipment date range and format requirements specified. The summary format presents shipment numbers, shipment dates, supplier account numbers and names, shipment references, and total quantities and total values outstanding. The details format incorporates the summary information, accompanied by shipment line level data including item codes and descriptions, and quantities, unit costs and values awaiting supplier invoice processing. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in shipment number, shipment date, supplier name or department order, with sub-totals provided for the by supplier and by department selections. View sample reports TCSDocuPShpOpen and TCSDocuPShpOpen-Det.

Outstanding Purchase Approvals

The Outstanding Purchase Approvals option provides the capability for producing selective listings of purchase order, purchase shipment and purchase invoice documents requiring authorisation or approved submission for processing as a consequence of exceeding departmental order value limits, or price variance limits in regard to subsequent expenditures. Report content is determined by the department, supplier and authorising employee selections and may be optionally restricted to purchase orders only. The report lists document numbers, types and dates, supplier account numbers and names, approving personnel, and document status and values, sequenced in either department, supplier name or authorising employee name order. View sample report TCSDocuPurchAuth.

Purchase Invoice Report

The Purchase Invoice Report option provides the capability for producing listings of the charges or expenditures on purchase invoice documents, as defined by the document number specified. The report presents the document header details in regard to supplier account number and name, invoice reference and date, payment due date and narration, accompanied by document line details in regard to purchased item account numbers and names, purchases descriptions, quantities, unit costs and extended values. Additionally, where inter-company charges have been entered, the company code and charged to account number within that company is also included. View sample reports TCSDocuPInv-Inventory, TCSDocuPInv-Outwork, and TCSDocuPInv-InterCo.

Purchase Order Analysis

The Purchase Order Analysis option provides the capability for producing selective listings of purchase orders as defined by the department, supplier account number range and account numbers, date range, and format requirements specified. The analysis presented may optionally include or exclude inter-warehouse transfer orders. The summary format lists the number of orders, and their total value, placed in the selected time period, accompanied by comparative statistics for both the prior period and the same period in the previous year, and may be presented as either order type or freight mode analyses within department, product franchise or supplier account. The detailed format presents the summarised information for the current period, accompanied by the individual purchase order numbers, and order dates, types and values from which the department, franchise or supplier totals have been accumulated. View sample reports TCSDocuPOrdAnalysis-Sum, and TCSDocuPOrdAnalysis-Det.

Purchase Variance Analysis

The Purchase Variance Analysis option provides the capability for producing selective analyses of variances between purchase invoice, purchase shipment and purchase order pricing as defined by the department, supplier, invoice number range, invoice date range, percent variance, and format requirements specified. The effect of varying exchange rates between processing phases for overseas purchases may be eliminated through the comparison of forex values for invoice, shipment and order prices. The summary format presents invoice numbers and dates, supplier account numbers and names, total invoiced values, total shipment values and amount and percentage variances, and total ordered values and amount and percentage variances. The detailed format incorporates the summary information, accompanied by 'line' level data regarding item codes and descriptions, invoice quantities and unit costs, shipment unit costs and variances, and order unit costs and variances. Both formats may be presented in either invoice number, invoice date, department, or supplier name sequence, with sub-totals for by department and by supplier selections. View sample reports TCSDocuPInvVarAnal-Sum, TCSDocuPInvVarAnal-Sum-Supp, TCSDocuPInvVarAnal-Sum-FX, TCSDocuPInvVarAnal-Det, TCSDocuPInvVarAnal-Det-Dept, and TCSDocuPInvVarAnal-Det-FX.

Purchases Invoice Register

The Purchases Invoice Register option provides the capability for producing selective listings of purchase invoice document details, as defined by the document number range, date type and date range requirements specified. The register presents purchase invoice document numbers and creation dates, supplier account numbers and names, supplier invoice numbers and dates, financial transaction dates, and tax inclusive (i.e. gross values), tax exclusive (i.e. net values) and tax values. These details may be presented in either document number or the selected type of date sequence, and the report totals include a count of the number of documents. View sample report TCSDocuInvRegister-Purch.

Purchases Supply Statistics

The Purchases Supply Statistics option provides the capability for producing selective listings of purchase order fulfilment rates achieved as defined by the warehouse, supplier account number range and account numbers, date range, and format requirements specified. The statistics presented may optionally include or exclude inter-warehouse transfer orders. The summary format lists order quantities and the number of order lines, received quantities and the number of order lines received in full by due date, and quantity received percentages and lines supplied percentages respectively for the selected time period, accompanied by comparative statistics for both the prior period and the same period in the previous year, and may be presented as either item franchise, item group or supplier account analyses. The detailed format lists the summarised information for the current period, accompanied by the individual purchase order numbers, order dates and delivery due dates from which the franchise, group or supplier totals have been accumulated. View sample reports TCSDocuPOrdSuppStats-Sum-Supp, TCSDocuPOrdSuppStats-Sum-Grp, TCSDocuPOrdSuppStats-Det-Supp, and TCSDocuPOrdSuppStats-Det-Grp.

Purchasing Authorities Report

The Purchasing Authorities Report option provides the capability for producing listings of default purchase order limits, shipment and invoice price variance limits, and the checking criteria under which warning emails will be generated if budget limits are exceeded. These settings are accompanied by details of authorising personnel and their specific approval limits. Report content is determined by the companies selected, and includes both the company and all department level overrides that have been established. View sample report TCSCodePurchAuth.

Shipment Binning Report

The Shipment Binning Report provides the capability for producing warehousing schedules from purchase shipments, detailing the bin locations, and their current contents, in which the items are stored and the quantities to now be received, accompanied by details of linked sales orders and total quantities on backorder. If items are supplied in outer packaging, i.e. cartons, then both the current stock balance and the received quantity are presented in carton equivalent terms. Schedules may be produced in shipment document line number, account number, i.e. inventory item, or bin location code sequence, and optionally, within case number sequence if applicable. Where bin management is in force for a warehouse, multiple bin locations and associated quantities may be incorporated for inventory item accounts. Additionally, lot/serial references are incorporated if applicable. View sample reports TCSDocuPShpBin, TCSDocuPShpBin-Pack, TCSDocuPShpBin-Serial, TCSDocuPShpBin-BM-LP, TCSDocuPShpBin-BM-Case, TCSDocuPShpBin-BM-Pack, and TCSDocuPShpBin-BM-Serial.

Shipment Costing Report

The Shipment Costing Report option provides the capability for producing selective listings of purchase shipment costings, as defined by the document number range specified. The report includes supplier account number and name, shipment reference and due date, and for each item in the shipment, purchase order references, inventory account numbers and descriptions, quantities, and unit costs and total costs in both forex and local currency. The calculated unit costs are accompanied by last costs and percentage variances, and where freight costs have been allocated on a volume basis these statistics for each item are incorporated. View sample reports TCSDocuPShp, and TCSDocuPShp-Vol.

Status of Purchase Invoices

The Status of Purchase Invoices option provides the capability for producing selective listings of the status of purchase invoices, as defined by the department, invoice number range, invoice date range, invoice document status and format requirements specified. The summary format presents invoice numbers, supplier account numbers and names, invoice dates, total quantities and total values originally ordered, total quantities and total values shipped, i.e. received, and total quantities and total values invoiced. The details format incorporates the summary information, accompanied by invoice line level data regarding item codes and descriptions, quantities and values ordered, quantities and values received, and quantities and values invoiced. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in invoice number, invoice date, supplier name or department order, with sub-totals provided for the by supplier and by department selections. View sample reports TCSDocuPInvStatus, and TCSDocuPInvStatus-Det.

Status of Purchase Orders

The Status of Purchase Orders option provides the capability for producing selective listings of the status of purchase orders, as defined by the department, order number range, order date range, due date range, order status and format requirements specified. The summary format presents order numbers, supplier account numbers and names, order dates, and total quantities and total values ordered, accompanied by total quantities and total values shipped, i.e. received, and total quantities and total values invoiced, consistent with subsequent procedures that have been completed. The details format presents the summary information, accompanied by order line level data regarding item codes and descriptions, quantities outstanding, quantities and values ordered, and quantities and values received, and quantities and values invoiced, as applicable. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in order number, order date, due date, supplier name or department order, with sub-totals provided for the by supplier and by department selections. View sample reports TCSDocuPOrdStatus-Sum, TCSDocuPOrdStatus-Sum-Supp, TCSDocuPOrdStatus-Sum-FX, TCSDocuPOrdStatus-Sum-Date-Ord, TCSDocuPOrdStatus-Sum-OutStand, TCSDocuPOrdStatus-Det, TCSDocuPOrdStatus-Det-Dept, TCSDocuPOrdStatus-Det-Supp, TCSDocuPOrdStatus-Det-FX, and TCSDocuPOrdStatus-Det-OutStand.

Status of Purchase Quotes

The Status of Purchase Quotes option provides the capability for producing selective listings of the status of purchase quotations, as defined by the department, quote number range, quote date range, open or all quotes, and format requirements specified. The summary format presents quote numbers, supplier account numbers and names, quote dates, and total quantities and total values quoted, supplemented by total quantities and total values ordered consistent with quotations that have been accepted and processed. The details format incorporates the summary information, accompanied by quote line level data regarding item codes and descriptions, quantities and values quoted, and quantities and values ordered as applicable. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in quote number, quote date, supplier name or department order, with sub-totals provided for the by supplier and by department selections. View sample reports TCSDocuPQuoStatus-Sum, TCSDocuPQuoStatus-Sum-Supp, TCSDocuPQuoStatus-Sum-FX, TCSDocuPQuoStatus-Det, TCSDocuPQuoStatus-Det-Supp, and TCSDocuPQuoStatus-Det-FX.

Status of Purchase Shipments

The Status of Purchase Shipments option provides the capability for producing selective listings of the status of purchase shipments, as defined by the department, shipment number range, shipment date range, shipment status and format requirements specified. The summary format presents shipment numbers, supplier account numbers and names, shipment dates, total quantities and total values originally ordered, total quantities and total values shipped, i.e. received, and if applicable, total quantities and total values invoiced. The details format presents the summary information, accompanied by shipment line level data regarding item codes and descriptions, quantities and values ordered, quantities and values received, and quantities and values invoiced as applicable. Optionally, values may be presented in the currency applicable for each supplier, and both formats may be sequenced in shipment number, shipment date, supplier name or department order, with sub-totals provided for the by supplier and by department selections. View sample reports TCSDocuPShpStatus-Sum, TCSDocuPShpStatus-Sum-Supp, TCSDocuPShpStatus-Sum-FX, TCSDocuPShpStatus-Det, TCSDocuPShpStatus-Det-Supp, and TCSDocuPShpStatus-Det-FX.

Vehicle Purchase Fwd Cover

The Vehicle Purchase Fwd Cover option provides the capability for producing listings of the foward cover allocated to open purchase orders. Report is ordered by currency with totals of the covered and uncovered amounts.