Advanced Installation TopicsMicrosoft Dynamics NAV Changes

Microsoft Dynamics NAV Changes

Sana Commerce 8.1
Your provider

Changed Objects Overview

These are the standard NAV objects that have been changed by Sana Commerce. For details concerning code changes on standard objects please read this chapter. Note that the changes described below are included in the SC_Standard_objects.fob & .txt files.
 
Object ID Object Name Object Type WSExposed
9 Country/Region Table FALSE
13 Salesperson/Purchaser Table FALSE
18 Customer Table FALSE
27 Item Table FALSE
30 Item Translation Table FALSE
36 Sales Header Table FALSE
37 Sales Line Table FALSE
110 Sales Shipment Header Table FALSE
111 Sales Shipment Line Table FALSE
112 Sales Invoice Header Table FALSE
113 Sales Invoice Line Table FALSE
114 Sales Cr.Memo Header Table FALSE
115 Sales Cr.Memo Line Table FALSE
280 Extended Text Header Table FALSE
279 Extended Text Header Table FALSE
5050 Contact Table FALSE
5715 Item Substitution Table FALSE
5722 Item Category Table FALSE
5723 Product Group Table FALSE
6660 Return Receipt Header Table FALSE
6661 Return Receipt Line Table FALSE
7002 Sales Price Table FALSE
11123304 SC - Shop Account Table FALSE
11123305 SC - Setup Table FALSE
11123306 SC - Translation Table FALSE
11123308 SC - Catalog Filter Table FALSE
11123310 SC - Parameters Collection Table FALSE
11123312 SC - Shop Account Cue Table FALSE
11123313 SC - Webshop Table FALSE
11123314 SC - Order Import Information Table FALSE
11123315 SC - Manual Process Requests Table FALSE
11123316 SC - Process Requests Setup Table FALSE
10 Countries/Regions Form FALSE
30 Item Card Form FALSE
41 Sales Quote Form FALSE
42 Sales Order Form FALSE
386 Extended Text Form FALSE
5401 Item Variants Form FALSE
5716 Item Substitution Entry Form FALSE
5730 Item Categories Form FALSE
5731 Product Groups Form FALSE
11123304 SC - Setup Form FALSE
11123305 SC - Shop Accounts Form FALSE
11123306 SC - Shop Account Card Form FALSE
11123307 SC - Translations Form FALSE
11123309 SC - Catalog Filters Form FALSE
11123312 SC - Webshops Form FALSE
11123313 SC - Webshop Card Form FALSE
11123314 SC - Manual Process Requests Form FALSE
11123315 SC - Process Requests Setup Form FALSE
11123302 SC - Import Roles Dataport FALSE
1 ApplicationManagement Codeunit FALSE
60 Sales-Calc. Discount Codeunit FALSE
80 Sales-Post Codeunit FALSE
7000 Sales Price Calc. Mgt. Codeunit FALSE
11123303 SC - NAV2009 WebService Codeunit TRUE
11123304 SC - NAS MessageHandler Codeunit FALSE
11123305 SC - Execution Context Codeunit FALSE
11123306 SC - Request Dispatcher Codeunit FALSE
11123308 SC - XML/System Functions Codeunit FALSE
11123309 SC - Common Functions Codeunit FALSE
11123310 SC - Validation Codeunit FALSE
11123311 SC - Settings Functions Codeunit FALSE
11123313 SC - Customer Functions Codeunit FALSE
11123314 SC - Customer Helper Codeunit FALSE
11123315 SC - Shop Account Functions Codeunit FALSE
11123316 SC - Shop Account Helper Codeunit FALSE
11123317 SC - Product Functions Codeunit FALSE
11123318 SC - Catalog Helper Codeunit FALSE
11123319 SC - Orders Functions Codeunit FALSE
11123320 SC - Order/Basket Functions Codeunit FALSE
11123321 SC - Custom Filter Codeunit FALSE
11123322 SC - Log Codeunit FALSE
11123399 SC - Uninstall Codeunit FALSE
52 Sana Commerce MenuSuite FALSE
1052 Dept - Sana Commerce MenuSuite FALSE
10 Countries/Regions Page FALSE
30 Item Card Page FALSE
41 Sales Quote Page FALSE
42 Sales Order Page FALSE
386 Extended Text Page FALSE
5401 Item Variants Page FALSE
5716 Item Substitution Entry Page FALSE
5730 Item Categories Page FALSE
5731 Product Groups Page FALSE
11123304 SC - Setup Page FALSE
11123305 SC - Shop Accounts Page FALSE
11123306 SC - Shop Account Card Page FALSE
11123307 SC - Translations Page FALSE
11123309 SC - Catalog Filters Page FALSE
11123312 SC - Manager Role Center Page FALSE
11123313 SC - Administrator Activities Page FALSE
11123314 SC - Administrator Role Center Page FALSE
11123315 SC - Webshops Page FALSE
11123316 SC - Webshop Card Page FALSE
  
 The list of changes in the standard objects is described below:
 
Object Type ID Object Name Description
Table 9 Country/Region Field 'Customer Template Code' (11123302 Code[10]) - TableRelation ='Customer Template' added
Table 9 Country/Region Field 'Visible in Webshop' (11123303 Boolean) added
Table 13 Salesperson/Purchaser Key 'Name' added
Table 18 Customer Field 'B2C Customer' (11123302 Boolean) added
Table 18 Customer Field 'Sana Customer No.' (11123303 Text[50]) added
Table 18 Customer Keys 'Name', 'City', and 'Primary Contact No.' added (in NAV2009 the only 'Primary Contact No.' key should be added)
Table 27 Item Field 'Visible in Webshop' (11123302 Boolean) added
Table 27 Item Field 'Last Date/Time Modified' (11123304 DateTime) added - Editable=No
Table 27 Item Key 'Description' added (in NAV2009 this key is added by default)
Table 27 Item Key 'Item Category Code,Product Group Code,Blocked,Visible in Webshop' added
Table 27 Item C/AL code added on OnModify trigger (see chapter 'Code changes' for details)
Table 27 Item New 'UpdateSCLastDateModified' procedure added (see chapter 'Code changes' for details).
Table 30 Item Translation C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Table 30 Item Translation Key 'Description, Language Code' added
Table 36 Sales Header Field 'Payment Method Name' (11123302 Text[50]) added - Editable=No
Table 36 Sales Header Field 'Payment Method Status' (11123303 Text[50]) added - Editable=No
Table 36 Sales Header Field 'Custom Fields' (11123304 BLOB) added
Table 36 Sales Header Field 'Sana Order' (11123305 Boolean) added - Editable=No
Table 36 Sales Header Field 'Sana Order Date Received' (11123306 Date) added - Editable=No
Table 36 Sales Header Field 'Sana Order Time Received' (11123307 Time) added - Editable=No
Table 36 Sales Header Field 'Sana Order No.' (11123308 Text[50]) added - Editable=No
Table 36 Sales Header Field 'Sana Promotion Code' (11123309 Text[50]) with code on the OnValidate trigger added (see chapter 'Code changes' for details)
Table 36 Sales Header Field 'Sana Promotion Title' (11123310 Text[80]) with code on the OnValidate trigger added (see chapter 'Code changes' for details)
Table 36 Sales Header Field 'Sana Promotion Discount Type' (11123311 Option[ ,Fixed Amount,Percentage]) with code on the OnValidate trigger added (see chapter 'Code changes' for details)
Table 36 Sales Header Field 'Sana Promotion Discount Value' (11123312 Decimal) with code on the OnValidate trigger added (see chapter 'Code changes' for details)
Table 36 Sales Header Field 'Sana Promotion Discount Amount' (11123313 Decimal) added
Table 36 Sales Header Field 'Sana Shipment Method Name' (11123314 Text[80]) added - Editable=No
Table 36 Sales Header Field 'Sell-to Shopaccount Code' (11123315 Code[20]) added - TableRelation="SC - Shop Account"
Table 36 Sales Header Key 'Order Date' added
Key 'Sell-to Contact' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Key 'Payment Method Status,Order Date,Sell-to Customer No.,Salesperson Code,Sell-to Contact No.' added
Key 'Sana Order No., Document Type' added
Table 36 Sales Header TextConst 'Text11123303' added
TextConst 'Text11123304' added
TextConst 'Text11123305' added
Table 37 Sales Line C/AL code changed (see chapter 'Code changes' for details)
Table 37 Sales Line Field 'Payment Cost Line' (11123302 Boolean) added - Editable=No
Table 37 Sales Line Key 'Document Type, Type, Document No.' added
Table 110 Sales Shipment Header Field 'Payment Method Name' (11123302 Text[50]) added - Editable=No
Table 110 Sales Shipment Header Field 'Payment Method Status' (11123303 Text[50]) added - Editable=No
Table 110 Sales Shipment Header Key 'Order Date' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Table 111 Sales Shipment Line Field 'Payment Cost Line' (11123302 Boolean) added - Editable=No
Table 112 Sales Invoice Header Field 'Payment Method Name' (11123302 Text[50]) added - Editable=No
Table 112 Sales Invoice Header Field 'Payment Method Status' (11123303 Text[50]) added - Editable=No
Table 112 Sales Invoice Header Key 'Order Date' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Table 113 Sales Invoice Line Field 'Payment Cost Line' (11123302 Boolean) added - Editable=No
Table 114 Sales Cr. Memo Header Key 'Posting Date' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Table 115 Sales Cr.Memo Line Field 'Payment Cost Line' (11123302 Boolean) added - Editable=No
Table 279 Extended Text Header Field 'Visible in Webshop' (11123302 Boolean) added - Editable=No
Table 280 Extended Text Line C/AL code changed (see chapter 'Code changes' for details)
Table 5050 Contact Field 'Customer Template Code' (11123350 Code[10]) - TableRelation="Customer Template" added
Table 5715 Item Substitution Field 'Relation Type' (11123302 Integer) added
Table 5715 Item Substitution C/AL code added on OnInsert, OnModify, OnDelete, CreateInterchangeableItem, and DeleteInterchangeableItem triggers (see chapter 'Code changes' for details)
Table 5722 Item Category Field 'Visible in Webshop' (11123302 Boolean) added
Table 5722 Item Category Field 'Sort No.' (11123303 Integer) added
Table 5722 Item Category C/AL code added on OnDelete and OnRename triggers (see chapter 'Code changes' for details)
Table 5722 Item Category TextConst 'Text11123302' added
Table 5723 Product Group Field 'Visible in Webshop' (11123302 Boolean) added
Table 5723 Product Group Field 'Sort No.' (11123303 Integer) added
Table 5723 Product Group C/AL code added on OnDelete and OnRename triggers (see chapter 'Code changes' for details)
Table 5723 Product Group TextConst 'Text11123302' added
Table 6660 Return Receipt Header Key 'Order Date' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Table 6661 Return Receipt Line Field 'Payment Cost Line' (11123302 Boolean) added - Editable=No
Table 7002 Sales Price C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Form 10 Countries/Regions Control 'Customer Template Code' added
Form 10 Countries/Regions Control 'Visible In Webshop' added
Form 10 Countries/Regions C/AL code added (see chapter 'Code changes' for details)
Form 30 Item Card Control 'Visible in Webshop' & header label added (E-Commerce tab)
Form 30 Item Card Control 'Last Date/Time Modified' added (E-Commerce tab)
Form 30 Item Card C/AL code added (see chapter 'Code changes' for details)
Form 41 Sales Quote Control 'Payment Method Name' added (Invoicing tab)
Form 41 Sales Quote Control 'Payment Method Status' added (Invoicing tab)
Form 41 Sales Quote Global variable 'SanaCustomerNo' (Text[50]) added
Form 41 Sales Quote C/AL code added (see chapter 'Code changes' for details)
Form 41 Sales Quote Control 'Sana Quote' added (E-Commerce tab)
Form 41 Sales Quote Control 'Sana Quote No.' added (E-Commerce tab)
Form 41 Sales Quote Control 'Sana Customer No.' added (E-Commerce tab)
Form 41 Sales Quote Control 'Sana Quote Date Recieved' added (E-Commerce tab)
Form 41 Sales Quote Control 'Sana Quote Time Recieved' added (E-Commerce tab)
Form 41 Sales Quote Control 'Sana Shipment Method Name' added (E-Commerce tab)
Form 41 Sales Quote Control 'Sell-to Shopaccount Code' added (E-Commerce tab)
Form 41 Sales Quote Header label 'Sana Promotion' added (E-Commerce tab)
Form 41 Sales Quote Control 'Promotion Code' added (E-Commerce tab)
Form 41 Sales Quote Control 'Promotion Title' added (E-Commerce tab)
Form 41 Sales Quote Control 'Promotion Discount Type' added (E-Commerce tab)
Form 41 Sales Quote Control 'Promotion Discount Value' added (E-Commerce tab)
Form 41 Sales Quote Control 'Promotion Discount Amount' added (E-Commerce tab)
Form 42 Sales Order Control 'Payment Method Name' added (Invoicing tab)
Form 42 Sales Order Control 'Payment Method Status' added (Invoicing tab)
Form 42 Sales Order Global variable 'SanaCustomerNo' (Text[50]) added
Form 42 Sales Order C/AL code added (see chapter 'Code changes' for details)
Form 42 Sales Order Control 'Sana Order' added (E-Commerce tab)
Form 42 Sales Order Control 'Sana Order No.' added (E-Commerce tab)
Form 42 Sales Order Control 'Sana Customer No.' added (E-Commerce tab)
Form 42 Sales Order Control 'Sana Order Date Recieved' added (E-Commerce tab)
Form 42 Sales Order Control 'Sana Order Time Recieved' added (E-Commerce tab)
Form 42 Sales Order Control 'Sana Shipment Method Name' added (E-Commerce tab)
Form 42 Sales Order Control 'Sell-to Shopaccount Code' added (E-Commerce tab)
Form 42 Sales Order Header label 'Sana Promotion' added (E-Commerce tab)
Form 42 Sales Order Control 'Promotion Code' added (E-Commerce tab)
Form 42 Sales Order Control 'Promotion Title' added (E-Commerce tab)
Form 42 Sales Order Control 'Promotion Discount Type' added (E-Commerce tab)
Form 42 Sales Order Control 'Promotion Discount Value' added (E-Commerce tab)
Form 42 Sales Order Control 'Promotion Discount Amount' added (E-Commerce tab)
Form 336 Extended Text Control 'Visible in Webshop' added (Sales tab)
Form 336 Extended Text C/AL code added (see chapter 'Code changes' for details)
Form 5401 Item Variants New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Form 5716 Item Substitution Entry Control 'Relation Type' added
Form 5716 Item Substitution Entry Control 'Sort No.' added
Form 5716 Item Substitution Entry C/AL code added (see chapter 'Code changes' for details)
Form 5730 Item Categories Control 'Visible in Webshop' added
Form 5730 Item Categories Control 'Sort No.' added
Form 5730 Item Categories C/AL code added (see chapter 'Code changes' for details)
Form 5731 Product Groups Control 'Visible in Webshop' added
Form 5731 Product Groups Control 'Sort No.' added
Form 5731 Product Groups C/AL code added (see chapter 'Code changes' for details)
Codeunit 1 Application Management C/AL code added (see chapter 'Code changes' for details)
Codeunit 60 Sales-Calc. Discount CalculateInvoiceDiscount procedure changed (see chapter 'Code changes' for details)
Codeunit 80 Sales-Post OnRun trigger changed (see chapter 'Code changes' for details)
Codeunit 7000 Sales Price Calc. Mgt. Property 'Local' of CalcLineAmount procedure changed from Yes to <No>.
  
Changes for NAV Standard Only
These are the objects that have been changed for NAV standard only.
Those changes should not be applied when using the Pebblestone Fashion add-on.
 
Object Type ID Object Name Description
Table 5715 Item Substitution Field 'Sort No.' (11123303 Text[40]) added
Form 5716 Item Substitution Entry Control 'Sort No.' added
Form 5730 Item Categories Command button 'Translations' added
Form 5731 Product Groups Command button 'Translations' added
 
Additional Changes for NAV with the Pebblestone Fashion Add-on 
The changed objects described here should only be applied when the Pebblestone Fashion add-on is used. Note that the changes described apply to NAV 5 and are included in the Pfs Fashion add-on pack.
 
Object Type ID Object Name Description
Table 37 Sales Line Key 'Document Type,Type,Document No.,Pfsvertical component,Pfshorizontal component' added
Table 37 Sales Line C/AL code added in procedure 'PfsCreatePrepackLines' (see chapter 'Code changes' for details)
Table 11006167* PfsPrepack Header Key 'Sorting' added
Table 11006168* PfsPrepack Line Key 'Horz. Component Sorting' added
Table 110061173 PfsTranslation New 'UpdateItem' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Form 11006110 PfsItem Vert components New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Form 11006111 PfsItem Horz components New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
*Changes in tables 11006167 and 11006168 are relevant only for PFS modules starting from v9.0
 
Additional Changes for NAV 2009
The changed objects described here should only be applied when the NAV 2009 (Standard or PFS) is used.
  
Object Type ID Object Name Description
Table 36 Sales Header Property Clustered=Yes is moved from the 'Document Type,No.' to the 'No.,Document Type' key
Table 37 Sales Line Property Clustered=Yes is moved from the 'Document Type,Document No.,Line No.' to the 'Document No.,Line No.,Document Type' key
Page 10 Countries/Regions Control 'Customer Template Code' added
Page 10 Countries/Regions Control 'Visible In Webshop' added
Page 10 Countries/Regions Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 10 Countries/Regions C/AL code added (see chapter 'Code changes' for details)
Page 30 Item Card Control 'Visible in Webshop' & header label added (E-Commerce tab)
Page 30 Item Card Control 'Last Date/Time Modified' added (E-Commerce tab)
Page 30 Item Card Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 30 Item Card C/AL code added (see chapter 'Code changes' for details)
Page 41 Sales Quote Control 'Payment Method Name' added (Invoicing tab)
Page 41 Sales Quote Control 'Payment Method Status' added (Invoicing tab)
Page 41 Sales Quote Global variable 'SanaCustomerNo' (Text[50]) added
Page 41 Sales Quote Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 41 Sales Quote C/AL code added (see chapter 'Code changes' for details)
Page 41 Sales Quote Control 'Sana Quote' added (E-Commerce tab)
Page 41 Sales Quote Control 'Sana Quote No.' added (E-Commerce tab)
Page 41 Sales Quote Control 'Sana Customer No.' added (E-Commerce tab)
Page 41 Sales Quote Control 'Sana Quote Date Recieved' added (E-Commerce tab)
Page 41 Sales Quote Control 'Sana Quote Time Recieved' added (E-Commerce tab)
Page 41 Sales Quote Control 'Sana Shipment Method Name' added (E-Commerce tab)
Page 41 Sales Quote Control 'Sell-to Shopaccount Code' added (E-Commerce tab)
Page 41 Sales Quote Header label 'Sana Promotion' added (E-Commerce tab)
Page 41 Sales Quote Control 'Promotion Code' added (E-Commerce tab)
Page 41 Sales Quote Control 'Promotion Title' added (E-Commerce tab)
Page 41 Sales Quote Control 'Promotion Discount Type' added (E-Commerce tab)
Page 41 Sales Quote Control 'Promotion Discount Value' added (E-Commerce tab)
Page 41 Sales Quote Control 'Promotion Discount Amount' added (E-Commerce tab)
Page 42 Sales Order Control 'Payment Method Name' added (Invoicing tab)
Page 42 Sales Order Control 'Payment Method Status' added (Invoicing tab)
Page 42 Sales Order Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 42 Sales Order Global variable 'SanaCustomerNo' (Text[50]) added
Page 42 Sales Order C/AL code added (see chapter 'Code changes'  for details)
Page 42 Sales Order Control 'Sana Order' added (E-Commerce tab)
Page 42 Sales Order Control 'Sana Order No.' added (E-Commerce tab)
Page 42 Sales Order Control 'Sana Customer No.' added (E-Commerce tab)
Page 42 Sales Order Control 'Sana Order Date Recieved' added (E-Commerce tab)
Page 42 Sales Order Control 'Sana Order Time Recieved' added (E-Commerce tab)
Page 42 Sales Order Control 'Sana Shipment Method Name' added (E-Commerce tab)
Page 42 Sales Order Control 'Sell-to Shopaccount Code' added (E-Commerce tab)
Page 42 Sales Order Header label 'Sana Promotion' added (E-Commerce tab)
Page 42 Sales Order Control 'Promotion Code' added (E-Commerce tab)
Page 42 Sales Order Control 'Promotion Title' added (E-Commerce tab)
Page 42 Sales Order Control 'Promotion Discount Type' added (E-Commerce tab)
Page 42 Sales Order Control 'Promotion Discount Value' added (E-Commerce tab)
Page 42 Sales Order Control 'Promotion Discount Amount' added (E-Commerce tab)
Page 336 Extended Text Control 'Visible in Webshop' added (Sales tab)
Page 336 Item Variants Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 336 Item Variants C/AL code added (see chapter 'Code changes'  for details)
Page 5401 Item Variants New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Page 5716 Item Substitution Entry Control 'Relation Type' added
Page 5716 Item Substitution Entry Control 'Sort No.' added
Page 5730 Item Substitution Entry Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 5730 Item Substitution Entry C/AL code added (see chapter 'Code changes'  for details)
Page 5730 Item Categories Control 'Visible in Webshop' added
Page 5730 Item Categories Control 'Sort No.' added
Page 5730 Item Categories Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 5730 Item Categories C/AL code added (see chapter 'Code changes'  for details)
Page 5731 Product Groups Control 'Visible in Webshop' added
Page 5731 Product Groups Control 'Sort No.' added
Page 5731 Product Groups Global variable 'SanaCommerceEnabled' (Boolean IncludeInDataset=Tes) added
Page 5731 Product Groups C/AL code added (see chapter 'Code changes'  for details)
 
Additional Changes for NAV 2009 (Standard)
The changed objects described here should only be applied when the NAV 2009 (Standard) is used.
 
Object Type ID Object Name Description
Page 5730 Item Categories Action button 'Translations' added
Page 5731 Product Groups Action button 'Translations' added
 
Additional Changes for NAV 2009 with the Pebblestone Fashion Add-on (PFS)
The changed objects described here should only be applied when the NAV 2009 with the Pebblestone Fashion Add-on is used.

Object Type ID Object Name Description
Page 11006110 PfsItem Vert Components New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Page 11006111 PfsItem Horz Components New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
Advanced Installation TopicsMicrosoft Dynamics NAV Changes