Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Jet Enterprise for NAV Change Log


Jet Enterprise for NAV v4.0 (Releases 4/25/17)

General

  • Enabled Managed Deployment
  • Sorted objects in Stage and Data Warehouse
  • Added Execution Packages
  • Added Transfer Prioritization
  • Reworked Date Calculation

Data Warehouse

  • Renamed "ID" field to "Aging" on "Aging" table
  • Renamed "Description" field to "Aging Description" on "Aging" table
  • Renamed "Name" field to "Company" on "Company" table
  • Removed "Customer Discount Group" field from "Customer" table
  • Removed "Customer Discount Group Description" field from "Customer" table
  • Removed "Customer Price Group" field from "Customer" table
  • Removed "Customer Price Group Description" field from "Customer" table
  • Removed "Date Aggregation" table
  • Removed "Date Comparison" table
  • Renamed "Cost Amount" field to "Cost" on "Inventory Transactions" table
  • Renamed "Aging ID" field to "Aging" on "Payables Transactions" table
  • Removed "Due Date" field from "Payables Transactions" table
  • Removed "Days Overdue" field from "Payables Transactions" table
  • Removed "Credit Amount" field from "Payables Transactions" table
  • Removed "Credit Amount LCY" field from "Payables Transactions" table
  • Removed "Days Outstanding" field from "Payables Transactions" table
  • Removed "Debit Amount" field from "Payables Transactions" table
  • Removed "Debit Amount LCY" field from "Payables Transactions" table
  • Renamed "Discount Amount LCY" field to "Discount LCY" on "Payables Transactions" table
  • Renamed "Purchase Amount LCY" field to "Purchase LCY" on "Payables Transactions" table
  • Removed "Document Line No" field from "Posted Purchase Transactions" table
  • Renamed "Type" field to "Line Type" on "Posted Purchase Transactions" table
  • Renamed "Cost Amount" field to "Cost" on "Posted Purchase Transactions" table
  • Renamed "Discount Amount" field to "Discount" on "Posted Purchase Transactions" table
  • Renamed "Purchase Quantity" field to "Quantity" on "Posted Purchase Transactions" table
  • Renamed "Posted Purchase Transactions" table to "Purchase Posted Transcations" table
  • Renamed "Cost Amount" field to "Order Cost" on "Purchase Order Transactions" table
  • Renamed "Discount Amount" field to "Order Discount" on "Purchase Order Transactions" table
  • Renamed "Outstanding Cost Amount" field to "Outstanding Cost" on "Purchase Order Transactions" table
  • Renamed "Quantity" field to "Order Quantity" on "Purchase Order Transactions" table
  • Renamed "Aging ID" field to "Aging" on "Receivables Transactions" table
  • Removed "Due Date" field from "Receivables Transactions" table
  • Removed "Days Overdue" field from "Receivables Transactions" table
  • Removed "Credit Amount" field from "Receivables Transactions" table
  • Removed "Credit Amount LCY" field from "Receivables Transactions" table
  • Removed "Days Outstanding" field from "Receivables Transactions" table
  • Removed "Debit Amount" field from "Receivables Transactions" table
  • Removed "Debit Amount LCY" field from "Receivables Transactions" table
  • Renamed "Discount Amount LCY" field to "Discount LCY" on "Receivables Transactions" table
  • Removed "Document Line No" field from "Posted Sales Transactions" table
  • Renamed "Type" field to "Line Type" on "Posted Sales Transactions" table
  • Renamed "Cost Amount" field to "Cost" on "Posted Sales Transactions" table
  • Renamed "Discount Amount" field to "Discount" on "Posted Sales Transactions" table
  • Removed "Invoiced Quantity" field from "Posted Sales Transactions" table
  • Renamed "Sales Amount" field to "Sales" on "Posted Sales Transactions" table
  • Renamed "Shipped Quantity" field to "Quantity" on "Posted Sales Transactions" table
  • Renamed "Posted Sales Transactions" table to "Sales Posted Transactions"
  • Renamed "Cost Amount" field to "Order Cost" on "Sales Order Transactions" table
  • Renamed "Discount Amount" field to "Order Discount" on "Sales Order Transactions" table
  • Renamed "Outstanding Cost Amount" field to "Outstanding Cost" on "Sales Order Transactions" table
  • Renamed "Outstanding Sales Amount" field to "Outstanding Sales" on "Sales Order Transactions" table
  • Renamed "Quantity" field to "Order Quantity" on "Sales Order Transactions" table
  • Renamed "Sales Amount" field to "Order Sales" on "Sales Order Transactions" table

Cubes

  • Renamed "Aging Bucket" attribute to "Aging" on "Aging" dimension
  • Removed "by Document Type" hierarchy from "Customer Document" dimension
  • Removed "by Document Type" hierarchy from "GL Document" dimension
  • Removed "by Document Type" hierarchy from "Inventory Document" dimension
  • Removed "by Document Type" hierarchy from "Purchase Document" dimension
  • Removed "by Document Type" hierarchy from "Sales Document" dimension
  • Removed "by Document Type" hierarchy from "Vendor Document" dimension
  • Removed "by State by City" hierarchy from "Customer" dimension
  • Removed "by Country by City" hierarchy from "Customer" dimension
  • Removed "by Customer Posting Group" hierarchy from "Customer" dimension
  • Removed "by Salesperson on Customer Card" hierarchy from "Customer" dimension
  • Removed "by Business Posting Group" hierarchy from "Customer" dimension
  • Removed "Customer Discount Group" attribute from "Customer" dimension
  • Removed "Customer Pricing Group" attribute from "Customer" dimension
  • Removed "by Inventory Posting Group" hierarchy from "Item" dimension
  • Removed "by Item Category by Product Group" hierarchy from "Item" dimension
  • Removed "by Product Posting Group" hierarchy from "Item" dimension
  • Removed "by Line Type" hierarchy from "Line Type" dimension
  • Removed "by Purchaser on Vendor Card" hierarchy from "Vendor" dimension
  • Removed "by Vendor Posting Group" hierarchy from "Vendor" dimension
  • Removed "by Country by City" hierarchy from "Vendor" dimension
  • Removed "by State by City" hierarchy from "Vendor" dimension
  • Renamed "Purchaser Code" attribute to "Purchaser on Document Code" on "Purchaser on Document" dimension
  • Renamed "Salesperson Code" attribute to "Salesperson on Document Code" on "Salesperson on Document" dimension
  • Renamed "Variance" to "Var" in "Finance" cube
  • Removed "Beginning Quantity" measure from "Inventory" cube
  • Removed "Beginning Value" measure from "Inventory" cube
  • Renamed "Value" measure to "Cost" in "Inventory" cube
  • Renamed "Ending Quantity" measure to "Quantity on Hand" in "Inventory" cube
  • Renamed "Ending Value" measure to "Cost on Hand" in "Inventory" cube
  • Removed "Due Date" dimension from "Payables" cube
  • Removed "Average Days Outstanding" from "Payables" cube
  • Removed "Beginning Balance" measure from "Payables" cube
  • Removed "Beginning Balance LCY" measure from "Payables" cube
  • Removed "Credit Amount" measure from "Payables" cube
  • Removed "Credit Amount LCY" measure from "Payables" cube
  • Removed "Debit Amount" measure from "Payables" cube
  • Removed "Debit Amount LCY" measure from "Payables" cube
  • Renamed "Discount Amount LCY" measure to "Discount LCY" in "Payables" cube
  • Removed "Document Count" measure from "Payables" cube
  • Renamed "Ending Balance" measure to "Balance" in "Payables" cube
  • Renamed "Ending Balance LCY" measure to "Balance LCY" in "Payables" cube
  • Renamed "Purchase Amount LCY" measure to "Purchase LCY" in "Payables" cube
  • Renamed "Average Unit Cost" measure to "Avg Unit Cost" in "Purchase" cube
  • Renamed "Cost Amount" measure to "Cost" in "Purchase" cube
  • Renamed "Cost Amount YTD" measure to "Cost YTD" in "Purchase" cube
  • Renamed "Discount Amount" measure to "Discount" in "Purchase" cube
  • Renamed "Discount Amount %" measure to "Discount %" in "Purchase" cube
  • Renamed "Purchase Order Cost Amount" measure to "Order Cost" in "Purchase" cube
  • Renamed "Purchase Order Discount Amount" measure to "Order Discount" in "Purchase" cube
  • Renamed "Purchase Order Discount %" measure to "Order Discount %" in "Purchase" cube
  • Renamed "Purchase Order Quantity" measure to "Order Quantity" in "Purchase" cube
  • Renamed "Purchase Order Outstanding Cost Amount" measure to "Outstanding Cost" in "Purchase" cube
  • Renamed "Purchase Order Outstanding Quantity" measure to "Outstanding Quantity" in "Purchase" cube
  • Removed "Due Date" dimension from "Receivables" cube
  • Removed "Average Days Outstanding" from "Receivables" cube
  • Removed "Beginning Balance" measure from "Receivables" cube
  • Removed "Beginning Balance LCY" measure from "Receivables" cube
  • Removed "Credit Amount" measure from "Receivables" cube
  • Removed "Credit Amount LCY" measure from "Receivables" cube
  • Removed "Debit Amount" measure from "Receivables" cube
  • Removed "Debit Amount LCY" measure from "Receivables" cube
  • Renamed "Discount Amount LCY" measure to "Discount LCY" in "Receivables" cube
  • Removed "Document Count" measure from "Receivables" cube
  • Renamed "Ending Balance" measure to "Balance" in "Receivables" cube
  • Renamed "Ending Balance LCY" measure to "Balance LCY" in "Receivables" cube
  • Renamed "Average Profit" measure to "Avg Profit" in "Sales" cube
  • Renamed "Average Unit Cost" measure to "Avg Unit Cost" in "Sales" cube
  • Renamed "Average Unit Price" measure to "Avg Unit Price" in "Sales" cube
  • Renamed "Cost Amount" measure to "Cost" in "Sales" cube
  • Renamed "Cost Amount YTD" measure to "Cost YTD" in "Sales" cube
  • Renamed "Discount Amount" measure to "Discount" in "Sales" cube
  • Renamed "Discount Amount %" measure to "Discount %" in "Sales" cube
  • Renamed "Profit % YTD" measure to "Profit YTD %" in "Sales" cube
  • Renamed "Sales Amount" measure to "Sales" in "Sales" cube
  • Removed "Sales Amount LY" measure from "Sales" cube
  • Renamed "Sales Amount YTD" measure to "Sales YTD" in "Sales" cube
  • Removed "Sales Amount YTD LY" measure from "Sales" cube
  • Renamed "Sales Order Amount" measure to "Order Sales" in "Sales" cube
  • Renamed "Sales Order Cost Amount" measure to "Order Cost" in "Sales" cube
  • Renamed "Sales Order Discount Amount" measure to "Order Discount" in "Sales" cube
  • Renamed "Sales Order Discount %" measure to "Order Discount %" in "Sales" cube
  • Renamed "Sales Order Quantity" measure to "Order Quantity" in "Sales" cube
  • Renamed "Sales Order Outstanding Amount" measure to "Outstanding Sales" in "Sales" cube
  • Renamed "Sales Order Outstanding Cost Amount" measure to "Outstanding Cost" in "Sales" cube
  • Renamed "Sales Order Outstanding Quantity" measure to "Outstanding Quantity" in "Sales" cube
  • Removed "Invoiced Quantity" measure from "Sales" cube
  • Removed "Invoiced Quantity YTD" measure from "Sales" cube
  • Renamed "Shipped Quantity" measure to "Quantity" in "Sales" cube
  • Renamed "Shipped Quantity YTD" measure to "Quantity YTD" in "Sales" cube

 

Jet Enterprise for NAV v3.2 (Released 3/21/16)

 

  • Upgraded projects to support Jet Enterprise 2016 (Build 16.2.3)
  • Changed Index Automation setting to "Manual" for all projects
  • Added an additional dimension level to some commonly used dimensions that represents just the key of the dimension. This will facilitate easier cube reporting and filtering using Jet Essentials. The dimension levels added are:
    • Customer No
    • GL Account No
    • Global Dimension 1 Code
    • Global Dimension 2 Code
    • Item No
    • Purchaser Code
    • Salesperson Code
    • Vendor No

 

Jet Enterprise for NAV v3.1 (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 NAV v3.0 (Released 8/31/15)

  • Cubes
    • General
      • Removed the Payment Terms dimensions levels from the Customer and Vendor dimensions
    • Finance
      • Added Amount Variance measure
      • Added Amount Variance % measure
      • Added Amount YTD LY measure
      • Added Amount YTD Variance measure
      • Added Amount YTD Variance % measure
      • Added Balance LY measure
      • Added Balance Variance measure
      • Added Balance Variance % measure
      • Added Budget YTD Variance measure
      • Added Budget YTD Variance % measure
      • Renamed Ending Balance measure to Balance
      • Removed the Debit Amount measure
      • Removed the Credit Amount measure
      • Removed the Customer dimension
      • Removed the Vendor dimension
      • Removed exchange rate functionality as this needs to be implemented on a client by client basis to behave correctly
    • Sales
      • Removed the Document Count and Document Count Hidden measures
      • Added Sales Amount LY measure
      • Added Sales Amount YTD LY measure
    • Purchase
      • Removed the Document Count and Document Count Hidden measures
    • Inventory
      • Removed the following measures that were related to calculating inventory turns: Average Value, COGS, COGS 365, Inventory Days, Inventory Turns.
  • Data Warehouse
    • Removed Currency Exchange Rate table
    • Removed Load Currency Exchange Rate script
    • Removed Debit Amount , Credit Amount , Customer No, and Vendor No fields from the Finance Transactions table
    • Removed Payment Terms  Code and Payment Terms Description fields from Customer table
    • Removed Payment Terms  Code and Payment Terms Description fields from Vendor table
  • Staging Database
    • Removed Currency Exchange Rate table
    • Removed Debit Amount , Credit Amount , Customer No, and Vendor No fields from the G/L Entry table
    • Removed data selection rule on G/L Account table
    • Removed Payment Terms  Code and Payment Terms Description fields from Customer table
    • Removed Payment Terms  Code and Payment Terms Description fields from Vendor table
    • Removed Payment Terms table

Jet Enterprise for NAV v2.9

Jet Enterprise for NAV v2.8

  • General improvements to make project compatible with JDM 14.2.5 and later

Jet Enterprise for NAV v2.7

  • Stage
    • Moved "Date" table from data warehouse to staging database to facilitate the inclusion of multiple calendars for specific clients
    • Added Work Center Group table to support manufacturing cube
    • Added Machine Center table to support manufacturing cube
    • Added Work Center table to support manufacturing cube
    • Added Work Center Group table to support manufacturing cube
    • Added Production Order table to support manufacturing cube
    • Added Scrap table to support manufacturing cube
    • Added Stop table to support manufacturing cube
    • Added Prod. Order Component table to support manufacturing cube
    • Added Prod. Order Routing Line table to support manufacturing cube
    • Added Capacity Ledger Entry table to support manufacturing cube
    • Added Calendar Entry table to support manufacturing cube
  • Data Warehouse
    • Added Machine Center table to support manufacturing cube
    • Added Production Order table to support manufacturing cube
    • Added Scrap table to support manufacturing cube
    • Added Stop table to support manufacturing cube
    • Added Work Center table to support manufacturing cube
    • Added Manufacturing Transactions table to support manufacturing cube
  • Cubes
    • Added Manufacturing cube
    • Added Machine Center dimension
    • Added Production Order dimension
    • Added Scrap dimension
    • Added Stop dimension
    • Added Work Center dimension

Jet Enterprise for NAV v2.6

  • Stage
    • Removed "Company" table
    • Added "Invoiced Quantity" field to "NAV_dbo_Value Entry" table
    • Added "Salesperson Code" field to "NAV_dbo_Sales Shipment Header" table
    • Added "Salesperson Code" field to "NAV_dbo_Return Receipt Header" table
    • Added "Salesperson Code" field to "NAV_dbo_Service Shipment Header" table
    • Added "NAV_dbo_Sales Shipment Line" table
    • Added "NAV_dbo_Return Receipt Line" table
    • Added "NAV_dbo_Service Shipment Line" table
    • Added fixed transformation to "Currency Factor" field in "NAV_dbo_Service Invoice Line" table
    • Added fixed transformation to "Currency Factor" field in "NAV_dbo_Service Cr.Memo Line" table
  • Data Warehouse
    • Changed data movement for Company table to pull from General Ledger Setup instead of Company in staging database. This will now only return companies selected in NAV adapter in project
    • Renamed "Sales Quantity" field to "Shipped Quantity" in "Posted Sales Transactions" table
    • Added "Invoiced Quantity" field to "Posted Sales Transactions" table
    • Added copy movements to "Posted Sales Transactions" table from "NAV_dbo_Sales Shipment Line" table
    • Added copy movements to "Posted Sales Transactions" table from "NAV_dbo_Return Receipt Line" table
    • Added copy movements to "Posted Sales Transactions" table from "NAV_dbo_Service Shipment Line" table
  • Cubes
    • Renamed "Deviation" to "Budget Variance" in "Finance" cube
    • Renamed "Deviation %" to "Budget Variance %" in "Finance" cube
    • Renamed "Quantity" to "Shipped Quantity" in "Sales" cube
    • Renamed "Quantity YTD" to "Shipped Quantity YTD" in "Sales" cube
    • Added "Invoiced Quantity" to "Sales" cube
    • Added "Invoiced Quantity YTD" to "Sales" cube
    • Added German translations

Jet Enterprise for NAV v2.5

  • Stage
    • Added "NAV_dbo_Service Header" table
    • Added "NAV_dbo_Service Line" table
    • Deleted "Item No" field from the "NAV_dbo_Purchase Line" table
    • Deleted "Item No" field from the "NAV_dbo_Sales Line" table
    • Updated joins for lookup fields in "NAV_dbo_Purchase Line" table to include "Document Type"
    • Updated joins for lookup fields in "NAV_dbo_Sales Line" table to include "Document Type"
    • Changed the custom transformation for "Outstanding Sales Amount LCY" field in "NAV_dbo_Sales Line" table
    • Changed the custom transformation for "Outstanding Sales Amount LCY" field in "NAV_dbo_Service Line" table
    • Changed the data selection rule on "NAV_dbo_Purch. Cr. Memo Line"
    • Changed the data selection rule on "NAV_dbo_Purch. Inv. Line"
    • Changed the data selection rule on "NAV_dbo_Sales Cr.Memo Line"
    • Changed the data selection rule on "NAV_dbo_Sales Invoice Line"
  • Data Warehouse
    • Added "Line Type" field to "Item" table
    • Added "Line Type" field to "Inventory Transactions"
    • Deleted "Item No" field from the "Purchase Order Transactions" table
    • Deleted "Item No" field from the "Sales Order Transactions" table
    • Added copy movement to "Sales Document" table from "NAV_dbo_Service Header" table
    • Added copy movement to "Sales Order Transactions" table from "NAV_dbo_Service Line" table
  • Cubes
    • Changed the Key Column of "Item" attribute in "Item" dimension to "No + Line Type"
    • Added "Average Profit" measure to "Sales" cube
    • Added Spanish translations to all objects in the OLAP database
    • Added Japanese translations to all objects in the OLAP database

 

Jet Enterprise for NAV v2.4

  • General
    • Updated the project with new business functions
    • Added Full Update script for Incremental Loading setup
  • Stage
    • Alphabetized tables as much as possible
    • Removed "LCY Code" field in "NAV_dbo_Company" table
    • Added "Local Currency" field to "NAV_dbo_Currency" table
    • Removed "Currency Name" field in "NAV_dbo_General Ledger Setup" table
    • Added "Local Currency" field to "NAV_dbo_General Ledger Setup" table
    • Renamed "Currency Factor" field to "Exchange Rate" in "NAV_dbo_Currency Exchange Rate" table
    • Removed "Ending Date" field in "NAV_dbo_Currency Exchange Rate" table
    • Removed fixed transformation on "Relational Exch. Rate Amount" field in "NAV_dbo_Currency Exchange Rate" table
    • Removed "Exchange Rate Ending Date" script action
    • Added "NAV_Option_G/L Entry.Document Type" table
    • Added "NAV_Option_Purchase Line.Document Type" table
    • Added "NAV_Option_Sales Line.Document Type" table
    • Added "Document No." and "Document Type" fields to "NAV_dbo_G/L Entry" table
    • Added "Document Type Description" lookup to "NAV_dbo_G/L Entry" table
    • Added "Document Type Description" lookup to "NAV_dbo_Detailed Vendor Ledg. Entry" table
    • Added "Document Type Description" lookup to "NAV_dbo_Detailed Cust. Ledg. Entry" table
    • Added "Document Type Description" lookup to "NAV_dbo_Value Entry" table
    • Added "Document Type" field to "NAV_dbo_Sales Shipment Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Sales Shipment Header" table
    • Added "Document Type" field to "NAV_dbo_Sales Invoice Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Sales Invoice Header" table
    • Added "Document Type" field to "NAV_dbo_Return Receipt Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Return Receipt Header" table
    • Added "Document Type" field to "NAV_dbo_Sales Cr.Memo Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Sales Cr.Memo Header" table
    • Added "Document Type" field to "NAV_dbo_Service Shipment Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Service Shipment Header" table
    • Added "Document Type" field to "NAV_dbo_Service Invoice Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Service Invoice Header" table
    • Added "Document Type" field to "NAV_dbo_Service Cr. Memo Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Service Cr. Memo Header" table
    • Added "Document Type" field to "NAV_dbo_Sales Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Sales Header" table
    • Added "Document Type" field to "NAV_dbo_Sales Line" table
    • Added "Document Type" field to "NAV_dbo_Purch. Rcpt. Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Purch. Rcpt. Header" table
    • Added "Document Type" field to "NAV_dbo_Purch. Inv. Header" table
    • Added "Document Type Description" lookup to ""NAV_dbo_Purch. Inv. Header" table
    • Added "Document Type" field to "NAV_dbo_Return Shipment Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Return Shipment Header" table
    • Added "Document Type" field to "NAV_dbo_Purch. Cr. Memo Hdr." table
    • Added "Document Type Description" lookup to "NAV_dbo_Purch. Cr. Memo Hdr." table
    • Added "Document Type" field to "NAV_dbo_Purchase Header" table
    • Added "Document Type Description" lookup to "NAV_dbo_Purchase Header table
    • Added "Document Type" field to "NAV_dbo_Purchase Line" table
    • Renamed "Module" field to "Item Ledger Entry Type" in "NAV_dbo_Purch. Inv. Line" table
    • Renamed "Module" field to "Item Ledger Entry Type" in "NAV_dbo_Purch. Cr. Memo" table
    • Renamed "Module" field to "Item Ledger Entry Type" in "NAV_dbo_Sales Invoice Line" table
    • Renamed "Module" field to "Item Ledger Entry Type" in "NAV_dbo_Sales Cr.Memo Line" table
    • Added "Aging" table
    • Deleted "Dimension Code" field from "NAV_dbo_Dimension Value"
    • Added "NAV_Option_Service Invoice Line.Type" table
    • Added "NAV_dbo_Service Cost" table
    • Added "NAV_dbo_Service Invoice Line" table
    • Added "NAV_dbo_Service Cr.Memo Line" table
  • Data Warehouse
    • Alphabetized tables as much as possible
    • Removed "LCY Code" field in "Company' table
    • Removed "Exchange Rate Transactions" table
    • Removed "Reporting Currency" table
    • Renamed "Currencies" table to "Currency"
    • Added "Local Currency" field to "Currency" table
    • Removed "Load Exchange Rate Transactions" script action
    • Added "Load Currency Exchange Rate" script action
    • Updated "Currency Exchange Rate" table with new fields and copy movements from stage
    • Added "GL Document" table
    • Added "Document No" and "Document Type" fields to "Finance Transactions" table
    • Renamed "Customer Document Type" table to "Customer Document"
    • Added "Company", "Document No" and "Entry No" fields to "Customer Document" table
    • Renamed "Vendor Document Type" table to "Vendor Document"
    • Added "Company", "Document No" and "Entry No" fields to "Vendor Document" table
    • Added "Inventory Document" table
    • Added "Document Type" and "Document No" fields to "Inventory Transactions" table
    • Added "Purchase Document" table
    • Added "Document Type" field to "Purchase Order Transactions" table
    • Added "Sales Document" table
    • Added "Document Type" field to "Sales Order Transactions" table
    • Renamed "Module" field to "Item Ledger Entry Type" in "Posted Purchase Transactions" table
    • Renamed "Module" field to "Item Ledger Entry Type" in "Posted Sales Transactions" table
    • Changed "Aging" table to copy data from the stage table
    • Deleted "Document Type" table
    • Deleted "Account Type" field from "GL Account" table
    • Added copy movement from "NAV_dbo_Service Cost" stage table to "Line Type" table
    • Added copy movement from "NAV_dbo_Service Invoice Line" stage table to "Posted Sales Transactions" table
    • Added copy movement from "NAV_dbo_Service Cr.Memo Line" stage table to "Posted Sales Transactions" table
  • Cubes
    • Removed all the reporting currency (RCY) business functions in Finance cube
    • Removed "Reporting Currency" dimension
    • Renamed "Transaction Currency" dimension to "Currency"
    • Renamed "Transaction Currency" dimension to "Currency" in "Payables" cube
    • Renamed "Transaction Currency" dimension to "Currency" in "Receivables" cube
    • Set the Unknown member to be hidden on "Currency" dimension
    • Added "Currency" in the Finance cube
    • Added "Currency" script command in the Finance cube
    • Added "Currency Exchange Rate" fact table to Finance cube
    • Changed "Exchange Rate" measure to pull data from "Currency Exchange Rate" fact table
    • Changed "Exchange Rate" measure to use "LastChild" as the Type
    • Removed "Exchange Rate Transactions" fact table in the Finance cube
    • Deleted all "Data Calculation" business functions in all the cubes
    • Added new "Date Calculation" script command to all the cubes
    • Added "GL Document" dimension to "Finance" cube
    • Renamed "Customer Document Type" dimension to "Customer Document"
    • Added "Document No" attribute to "Customer Document" dimension
    • Renamed "Vendor Document Type" dimension to "Vendor Document"
    • Added "Document No" attribute to "Vendor Document" dimension
    • Added "Inventory Document" dimension
    • Added "Inventory Document" dimension to "Inventory" cube
    • Added "Purchase Document" dimension
    • Added "Purchase Document" dimension to "Purchase" cube
    • Deleted "Document Type" dimension from "Purchase" cube
    • Added "Sales Document" dimension
    • Added "Sales Document" dimension to "Sales" cube
    • Deleted "Document Type" dimension from "Sales" cube
    • Deleted "Document Type" dimension
    • Deleted "Sales Order Amount YTD" measure

 

Jet Enterprise for NAV v2.3

 

  • Stage
    • Removed unused tables and fields
    • Unchecked Physical Valid Table setting for all stage tables
    • Checked Force Codepage Conversion setting
    • Checked Force Unicode Conversion setting
    • Changed Data Selection Rule on "G/L Account" table to "Account Type In List 0,3"
    • Updated "Currency Code" field in "NAV_dbo_Detailed Vendor Ledg. Entry" and "NAV_dbo_Detailed Cust. Ledg. Entry" tables to use strongly typed variables
    • Changed the Sql Mode to Group by on "Line Type Description" lookup in "NAV_dbo_G/L Account", "NAV_dbo_Fixed Asset", "NAV_dbo_Item Charge" and "NAV_dbo_Resource" tables
    • Removed the "Update G/L Account" Data Cleansing Post Step on "NAV_dbo_G/L Entry" table
  • Data Warehouse
    • Removed unused tables and fields
    • Unchecked Physical Valid Table setting for all data warehouse tables
    • Converted all text fields to Unicode
    • Synchronized data types and lengths between Stage and Data Warehouse fields
    • Removed Custom Data from "Budget Name" table
    • Added "MonthSortOrder" field to "Date" table
    • Changed custom transformation for "DisplayMonth" field in "Date" table
    • Renamed "General Business Posting Group" table to "Business Posting Group"
    • Removed Custom Data from "Business Posting Group" table
    • Renamed "General Product Posting Group" table to "Product Posting Group"
    • Removed Custom Data from "Product Posting Group" table
    • Removed Data Selection Rule on "GL Account" table
    • Renamed "Cost Amount Actual" field to "Cost Amount" in "Inventory Transactions" table
    • Renamed "Shortcut Dimension 1 Code" field to "Global Dimension 1 Code" in "Purchase Order Transactions" table
    • Renamed "Shortcut Dimension 2 Code" field to "Global Dimension 2 Code" in "Purchase Order Transactions" table
    • Renamed "Global Dimension 1" field to "Global Dimension 1 Code" in "Posted Sales Transactions" table
    • Renamed "Global Dimension 2" field to "Global Dimension 2 Code" in "Posted Sales Transactions" table
    • Renamed "Shortcut Dimension 1 Code" field to "Global Dimension 1 Code" in "Sales Order Transactions" table
    • Renamed "Shortcut Dimension 2 Code" field to "Global Dimension 2 Code" in "Sales Order Transactions" table
  • Cubes
    • Renamed "Date Calculations" dimension and measure to "Date Calculation"
    • Added "Date Calculation" to Receivables and Payables cube
    • Changed the Key Column of "Year Month" attribute in "Date" dimension to "MonthSortOrder + YearValue"
    • Changed the Name Column of "Quarter" attribute in "Date" dimension to "QuarterName"
    • Renamed "Budget Version" dimension (also renamed it in the Finance cube) and attribute to "Budget Name"

 

Jet Enterprise for NAV v2.1

 

  • General
    • Upgraded the project to Jet Data Manager 2012 (12.4.8)
    • Updated custom transformations/procedures/functions/scripts to use strongly typed variables

 

Jet Enterprise for NAV v2.0

 

  • Stage
    • Reworked all sales and purchase related tables
  • Data Warehouse
    • Reworked "Sales Transactions" and "Purchase Transactions" tables to use "Value Entry" as the primary sales table
    • Split off posted and unposted data for sales and purchase
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments