Overview – Analysis Reports

• Analysis types are used to create the report
  • Each Analysis Type code has a default Item Ledger Entry Type filter, Value Entry Type filter, and Value Type that together define the values in the item and budget entries to retrieve
  • This is assigned on the Column template
• Each report consist of a Line template and a Column template
• Analysis Reports – 3 different options
  • Sales Analysis
  • Purchase Analysis
  • Inventory Analysis

Setup – Analysis Type

Analysis Type Codes – BC comes with default Analysis types, but this screen may be blank.  The screenshot shows all the default Analysis types provided by BC.  If this screen is blank, follow the following steps.


If the Analysis Type field is blank click on Reset Default Analysis Type to have the system create the defaults.  Note: enter a “Dummy”  code prior to clicking on Reset Default Analysis Types or you will get an error message.

Manually create Analysis Type
In the Analysis type screen click on +New to create a new Analysis Type code.  Create a Code and Name
Select Value Type from the list that is associated with the code you are setting up.  Select the Entry type on the Item Ledger entries if Applicable.


Build an Analysis Report
Analysis Reports consist of Line and Column Template (Sales, Purchase, Inventory) similar to an Account Schedule.

If you use the Business Manager Role Center you can find these reports under Finance or use the “Search” functionality


An Analysis report consist of an Analysis Line and Column Template. This applies to Inventory, Sales and Purchase Analysis Reports.


Analysis Lines is like Account Schedule which is the “Row” format of the report.  Lines can manually be added or can be inserted from Customer, Vendor and item list depending on the type of report you are creating.
 

• Row Reference No. - A row reference number for the analysis line. Row reference numbers are optional and are only used in formulas. They have no relation to other number series in the program. If you use the same row reference number on more than one line, the report treats the lines as a group. For example, if you include the row reference number in a formula in the Totaling field, it will represent the sum of all the lines with that row reference number. If you use one of the insert functions on the Actions tab, this field is automatically copied from the No. or Code field from the inserted record
• Description - A description for the analysis line. If you use one of the insert functions on the Actions tab, this field is automatically copied from the Name or Description field from the inserted record
• Type - The type to total. You can select one of the following options: • Item • Item Group • Customer • Customer Group • Vendor • Sales Person/Purchaser • Formula The program uses the value in this field combined with the value in the Range field to determine the total for the analysis line
• Range - The number or formula of the type that is used to calculate the total for on this line.
• Dimension Codes – Specifies what dimension value amounts will be totaled on the line.  The ability to hard code a line to specific dimension.

To pull in master data go to “Actions” and pull in data from Items, Customers or Vendor depending on the type of report.  When insert items, customers or vendors are selected it will populate the screen with all the records.  Use Search to filter on specific records to fine tune your selection
Based on the filtered selection select the items to be brought into the report by using select more option.

In the example below, The item No. becomes the row number.Note:  from testing in this example BC does not like have row ref no.  With – (Alpha) In the sample below or using  a range 1900-S..2000-S BC calculations did not with the formula.

A formula line can be added totals Note: Formula can be calculated two different ways (see below).  Best option is to use the inventory items because the row ref no shows up on the report


Analysis Column is the column layout of the report

• Column No. - A number for the analysis column. The column numbers are optional and are used only in formulas. They have no relation to other number series in the program. You can use the same column number on more than one line. The columns are then treated as a group. For example, if you include the column number in a formula, it will represent the sum of all the lines that share the column number
• Column Header - The column header that you want to appear on printed reports. The program prints the header on reports that include this column.
• Invoiced - Specifies if you want the analysis report to be based on invoiced amounts. If you leave this field blank, the program bases the analysis report on expected amounts (shipped but not invoiced).
• Column Type - The column type for the analysis column. The type determines how the amounts in the column are calculated.
• Ledger Entry Type - The type of ledger entries to include in the amounts in the analysis column. The options include the following: • Item Entries: The program calculates the total from the item ledger entries or from the item value entries. • Item Budget Entries: The program calculates the total from the item budget entries.
• Formula - Contains a formula. The result of the formula appears in the column when the analysis report prints. The formula in this field can include other columns (referenced by their column number) so that the report can perform calculations on other columns.
• Comparison Date Formula – Specifies a date formula that specifies which date should be used to calculate the amount in this column
• Analysis Type code - Specifies the analysis type to apply to the column. When you select an analysis type for a column, the program automatically fills in the Item Ledger Entry Type Filter, Value Entry Type Filter, and the Value Type fields. Click the drop-down arrow in the Analysis Type Code field and then click Advanced to view the Analysis Type List page. To view, create, or change analysis type codes, click Setup on the Home tab of the Analysis Type List page, or enter “analysis types” in the Search box, and then select the related link. Both will open the Analysis Types page. Each Analysis Type Code has a default Item Ledger Entry Type Filter, Value Entry Type Filter, and Value Type that together define the values in the item and budget entries to retrieve. Default analysis type codes for most of the relevant analyses are included in the program. To set up these default types, click Reset Default Analysis Types on the Actions tab on the Analysis Types page.
• Value Type - The value type that the program uses to calculate the column. The options include the following: • (blank) • Quantity • Sales Amount • Cost Amount • Non-Inventoriable Amount • Unit Price • Standard Cost • Indirect Cost • Unit Cost The Quantity field and the three amount fields obtain their values from the item ledger entries. The values in the three cost fields originate from the item card, and the Unit Price field derives its value from the Sales Prices table. If you select one of the default analysis types in the Analysis Type field, the program fills in this field automatically

Add a column and start filling in the appropriate data to be entered under each column.  In the Analysis Type column select the Type that best describes the column.  This is how the system knows what information to pull each column should pull a different Analysis type code.



Generate a report from the Matrix
From the Analysis report screen enter a Line Template and a Column Template.  Click Edit Analysis report in menu to move to the next screen to generate reports.  Analysis report shows the report name, line and column template.  In the Matrix option you can view from Day – Accounting Period.

Click on Show Matrix to generate report.  There is no date filter from this screen.  The Matrix uses the “Work Date” on “My Settings” as the basis to compile the data for the report.  If you drill down into the detail the supporting data is displayed.
Generate a report to PDF; Which will allow you to use a date filter
Generate report with Dates- From the Menu go to Related>Reports>Print
Analysis Report filter – The report can now be filtered by date.  From the Matrix the date is driven by the Work Date but from this process you have control over the date range.