Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Jet Enterprise for GP Change Log


Jet Enterprise for GP v3.3 (Released 11/9/15)

 

  • Upgraded projects to support Jet Enterprise 2016
  • Implemented Dynamic Perspectives for all cubes
  • Incorporated new Date table functionality specific to Jet Enterprise 2016

Jet Enterprise for GP v3.2

  • General improvements to make project compatible with JDM 14.2.5

Jet Enterprise for GP v3.1

  • Stage
    • Updated GL20000 and GL30000 tables so that Closing Entry field would use SOURCDOC = 'BBF' instead of ORGNTSRC = 'CLOSE'
    • Added SY40100, GL10110 and GL10111 tables as source for Financial Period Balances table that was added to data warehouse
  • Data Warehouse
    • Added Financial Period Balances table
  • Cubes
    • Updated Beginning Balance and Ending Balance fields
    • Removed attribution relationships from Account dimension

Jet Enterprise for GP v3.0

 

  • Stage
    • Removed unused tables and fields
    • Unchecked Physical Valid Table setting for all stage tables
    • Added historic period balance table (GL10111)
    • Added receivables history table (RM30101)
    • Added payables history table (PM30200)
    • In IV30300 split off CUSTNMBR field into separate Customer No and Vendor No fields based on Document Type
  • Data Warehouse
    • Removed unused tables and fields
    • Unchecked Physical Valid Table setting for all data warehouse tables
    • Added TrimRight transformation to all text fields
    • Added "MonthSortOrder" field to "Date" table
    • Added data movement for Financial Period Balances (GL10111)
    • Added data movement for receivables history table (RM30101) to Receivables Transactions table
    • Added data movement for payables history table (PM30200) to Payables Transactions table
    • Added Customer No and Vendor No fields to Inventory Transactions table
    • Changed the name of "Aging Periods" table to "Aging Period"
    • Renamed "Source Document" table to "Finance Document"
  • Cubes
    • Deleted inline scripts on all six cubes
    • Changed dimension keys to only use the Code/No instead of the Code/No + Company
    • Changed the Key Column of "Year Month" attribute in "Date" dimension to "MonthSortOrder + YearValue"
    • Renamed "Company Name" attribute in "Company" dimension to "Company"
    • Renamed "Date Calculations" dimension to "Date Calculation"
    • Added "Date Calculation" dimension to "Inventory", "Payables", "Purchasing" and "Receivables" cubes
    • Renamed "by Country State City" hierarchy in "Location" dimension to "by Country by State by City"
    • Renamed "Shipping Methods" dimension to "Shipping Method"
    • Renamed "Vendor By Class" hierarchy in "Vendor" dimension to "by Class"
    • Renamed "by Country State City" hierarchy in "Vendor" dimension to "by Country by State by City"
    • Added Vendor dimension to Inventory cube
    • Changed the dimension name from "Aging Periods" to "Aging Period"
    • Changed the attribute name form "Aging Buckets" to "Aging Period"
    • Changed the dimension name in the Payables cube from "Payables Aging Periods" to "Aging Period"
    • Changed the dimension name in the Receivables cube from "Receivables Aging Periods" to "Aging Period"
    • Changed the attribute name on the "Customer" dimension from "Parent Customer" to "Corporate Customer No"
    • Changed the hierarchy name on the "Customer" dimension from "by Country State City" to "by Country by State by City"
    • Added the hierarchy "by Country by City" to the "Customer Address" dimension
    • Changed the attribute name on the "Inventory Document Type" dimension from "Document Type" to "Inventory Document Type"
    • Changed the attribute name on the "Location" dimension from "Location Code" to "Location"
    • Changed the attribute name on the "Location" dimension from "Location City" to "City"
    • Changed the attribute name on the "Location" dimension from "Location State" to "State"
    • Changed the attribute name on the "Location" dimension from "Location Country" to "Country"
    • Changed the attribute name on the "Payables Distribution Type" dimension from "Distribution Type" to "Payables Distribution Type"
    • Changed the attribute name on the "Payables Document Type" dimension from "Document Type" to "Payables Document Type"
    • Changed the name of the "Purchasing PO Status" dimension to "Purchase Order Status"
    • Changed the attribute name on the "Purchasing PO Status" dimension from "PO Status" to "Purchase Order Status"
    • Changed the name of the "Purchasing PO Type" dimension to "Purchase Order Type"
    • Changed the attribute name on the "Purchasing PO Type" dimension from "PO Type" to "Purchase Order Type"
    • Changed the attribute name on the "Purchasing Receipt Type" dimension from "Receipt Type" to "Purchasing Receipt Type"
    • Changed the attribute name on the "Receivables Distribution Type" dimension from "Distribution Type" to "Receivables Distribution Type"
    • Changed the attribute name on the "Receivables Document type" dimension from "Document Type" to "Receivables Document Type"
    • Changed the attribute name on the "Sales Document Type" dimension from "Document Type" to "Sales Document Type"
    • Changed the attribute name on the "Sales Territory" dimension from "Territory" to "Sales Territory"
    • Changed the hierarchy name on the "Sales Territory" dimension from "by Country Territory Manager" to "by Country by Manager"
    • Changed the attribute name on the "Salesperson" dimension from "Active" to "Inactive Status"
    • Changed the attribute name on the "Vendor" dimension from "Vendor City" to "City"
    • Changed the attribute name on the "Vendor" dimension from "Vendor State" to "State"
    • Changed the attribute name on the "Vendor" dimension from "Vendor Country" to "Country"
    • Changed the attribute name on the "Vendor" dimension from "Vendor User Defined 1" to "User Defined 1"
    • Changed the attribute name on the "Vendor" dimension from "Vendor User Defined 2" to "User Defined 2"
    • Changed the attribute name on the "Vendor" dimension from "Vendor Hold" to "Hold Status"
    • Changed the hierarchy name on the "Vendor" dimension from "by Class" to "by Vendor Class"
    • Changed the hierarchy on the "Vendor" dimension from "by Country by State by City" to "by Country by City"
    • Added the hierarchy on the "Vendor" dimension "by State by City"
    • Added Date Calculation script to all cubes
    • Rebuilt all Business Functions based on the v3.1 Business Function library
    • Renamed "Credit" measure in Finance cube to be "Credit Amount"
    • Renamed "Debit" measure in Finance cube to be "Debit Amount"
    • Removed Budget Variance % YTD measure from Finance cube
    • Removed Budget Variance YTD measure from Finance cube
    • Removed Credit Amount YTD measure from Finance cube
    • Removed Debit Amount YTD measure from Finance cube
    • Removed Amounts and YTD measure folders from Finance cube
    • Rename Credit Amount to GL Credit Amount in Inventory cube
    • Renamed Debit Amount to GL Debit Amount in Inventory cube
    • Rename Credit Amount to GL Credit Amount in Payables cube
    • Renamed Debit Amount to GL Debit Amount in Payables cube
    • Delete GL Transactions measure folder in Payables cube
    • Deleted Vendor Transactions measure folder in Payables cube
    • Deleted Amount measure folder in Purchasing cube
    • Rename Credit Amount to GL Credit Amount in Purchasing cube
    • Renamed Debit Amount to GL Debit Amount in Purchasing cube
    • Deleted GL Transactions measure folder in Purchasing cube
    • Deleted Quantity measure folder in Purchasing cube
    • Deleted Customer Transactions measure folder in Receivables cube
    • Converted Profit measure to Business Function in Receivables cube
    • Rename Credit Amount to GL Credit Amount in Receivables cube
    • Renamed Debit Amount to GL Debit Amount in Receivables cube
    • Deleted GL Transactions measure folder in Receivables cube
    • Converted Gross Profit measure to Business Function in Sales cube
    • Cleared Description field from all measures in all cubes
    • Renamed "Actual" measure in "Finance" cube to "Net Change"
    • Renamed "Actual YTD" measure in "Finance" cube to "Net Change YTD"
    • Renamed "Source Document" dimension to "Finance Document"
    • Renamed "Gross Profit" to "Profit" in Sales cube
    • Renamed "Gross Profit %" to "Profit %" in Sales cube
    • Renamed "Tax" to "Sales Tax" in Sales cube
    • Renamed "Sales Document Type" to "Sales Document" in Sales cube
    • Renamed "Miscellaneous Charges Amount" to "Miscellaneous Charge Amount" in Purchasing cube
    • Added "Freight Tax Amount" measure to Purchasing cube
    • Renamed "Miscellaneous" to "Miscellaneous Charge Amount" in Receivables cube
    • Renamed "Transaction Amount" to "Document Amount" on Receivables cube
    • Renamed "Miscellaneous Amount" to "Miscellaneous Charge Amount" in Payables cube
    • Removed "Originating Currency" dimension from all cubes
    • Removed "Qty Decrease" measure from Inventory cube
    • Removed "Qty Increase" measure from Inventory cube
    • Removed "Value Decrease" measure from inventory cube
    • Removed "Value Increase" measure from Inventory cube
    • Removed attribute relationships from Account Dimension
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments