DSA Reporting Packages

From DataSelf Knowledge Base
Jump to: navigation, search

{{#breadcrumb: Main_Page}}

SA Sales Analysis Reporting Packages

SA Sales

Source Data: Invoice header and detail tables.

Common Uses: Designed to analyze historical sales, quantity sold and gross profit by customer, acct manager, product and product groupings, territory, customer address, ship to, and location/warehouse.


SO Sales Order

Source Data: Sales Order history header and detail tables. Includes Sales Order measures for amounts and quantities Booked, Sold and Lost.

Common Uses: This is a favorite with salespeople who want to track their booked orders by order date. Also analyzes the open sales orders by salesperson, customer, acct manager, product or other product groupings, territory, customer address, ship to, and location/warehouse.


Inventory Reporting Packages

IN Inventory Transaction History

Source Data: Inventory transaction history table. In most ERP systems, these tables contain inventory moves such as sales, receipts, adjustments and inventory transfers among locations/warehouses.

Common Uses: Designed to analyze inventory sales and moves over time, cost and quantity.

Common Customization: Item costing can be modified to present historical transactions at today's standard or average cost, for better trend analysis.


IN Inventory On Hand Today

Source Data Inventory On Hand, On Purchase Order, On Sales Order by item by warehouse/location table.

'Common Uses For current On Hand values and Qty Available (On Hand + PO - SO) by item (or other item groupings) and warehouse/location. This table is also often used in DataSelf Analytics as a "blend" table with another Reporting Package. For example, used with SA Sales or IN Transaction History, to compare current On Hand with historical sales or usage trends.

Common Customization: Item costing can be modified to also present cost on hand at standard cost.


IN Historical OH by Date

Source Data A combination of today's On Hand and the IN Transaction History records, which are used to calculate backward from today's On Hand to determine the OH costing and quantity at any user-selected date, by item and warehouse/location.

'Common Uses To determine the Inventory On Hand at any one historical date by item (or other item groupings) and warehouse/location.


IN Historical OH by Month

Source Data Historical On Hand table, when available in the ERP. Or calculated by taking today's On Hand and calculating backward through the IN Transaction History records to determine the OH costing and quantity at the end of every month for the past several years.

'Common Uses For historical On Hand trending reporting by item (or other item groupings) and warehouse/location.


PO Purchase Order

Source Data: Purchase Order header and detail tables. For most ERP systems, these tables will not contain historical PO records.

Common Uses: Designed to analyze the outstanding purchase orders by vendor, product, warehouse/location, PO date and expected date.


AR Open Receivables

Source Data: Transactions from open Receivable transaction tables, with aging as of today's date.

Common Uses: Designed to analyze the outstanding receivables by customer, acct manager, salesperson, territory, other customer groupings, due date, discount date and aging.


AP Open Payables

Source Data: Transactions from open Payable transaction tables, with aging as of today's date.

Common Uses: Designed to analyze the outstanding payables by vendor, vendor groupings, due date, discount date and aging.


General Ledger Reporting Packages

GL Transactions

Source Data: GL Transaction History Files, which contain GL journal entries and the journal postings from other modules such as Accounts Payable and Accounts Receivable. The level of detail available through GL reporting varies by ERP package and setup options selected. I.E. Some systems post individual AR invoice information (such as customer number/invoice number) to the General Ledger, but most systems summarize posting batches. The Out-of-the-box reporting includes the level of detail as contained in the GL postings.

Common Uses: designed to analyze posting details, such as source journals posting to different accounts or account groups, account segments, dates, posting comments, financial ratios, etc. Posting amounts are available both as-posted (i.e. credits are negative) and "normalized" (for natural credit accounts, such as Sales, the signs are reversed, so that, for example, Sales become a positive number).

Common Customizations: journal entries may be linked back to source data, Option Fields (User Defined Fields), or comments expanded to include such information as Customer, for a Customer-based Profit and Loss.


GL Financials

This reporting package consists of two parts: GL Income Statement and GL Balance Sheet.

Source Data: GL financial statement balances files, which provide the total debits, credits, and ending balances for each GL account per fiscal month. The Income Statement includes two budgets, either from the ERP or from an optional outside budget source (such as an Excel file), to provide Budget versus Actual comparative analysis.

Data Format: SSAS Cube technology supports the more sophisticated data structure found in financial statements. Financial statements require that the accounts be grouped into a varying number of subheading levels, that credit accounts be shown as positive numbers, and various subgroupings be added or subtracted from one another. (The cube’s “Parent-Child” dimensions provide this functionality.)

User Interfaces:

Formal Financial Statements: Because of its flexibility and ease of formatting, MS Excel is the preferred front end for formal financial statement presentation (which are usually printed to pdf or otherwise published). The cube structures in combination with Excel allow users a great deal of flexibility to easily customize financial reports (rearranging account groupings, adding calculations or additional lines such as a Gross Margin Percent line, and fine-tuning the formatting).

Financial Statement Ad Hoc Analysis: Both DataSelf Analytics and Excel provide non-formal financial statement presentations that are easy to use and interact with, including the ability to drill down from a one or two line report displaying just the major groups (Assets, Liabilities and Equity, or Income Statement) through the grouping levels to the individual accounts' monthly totals.

Other Financial Analysis: Both Excel and DataSelf Analytics can provide financial analysis and graphics, such as graphing the trend of the relationship between open Accounts Receivable against Net Income.