InstallationMicrosoft Dynamics NAV Changes

Microsoft Dynamics NAV Changes

Next

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 SCL_Standard_objects.fob & .txt files.
 
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 'SclB2xCountry' (11123303 Boolean) added
Table 13 Salesperson/Purchaser Key 'Name' added
Table 18 Customer Keys 'Name', 'City', and 'Primary Contact No.' added
Table 18 Customer Field 'ScB2cCustomer' (11123302 Boolean) added
Table 18 Customer Field 'Sana Customer No.' (11123303 Text[50]) added
Table 27 Item Field 'Visible in webshop' (11123302, Boolean) added
Table 27 Item Field 'Main Navigation Code' (11123303 Code[200]) with code on the OnLookup trigger added (see chapter 'Code changes' for details)
Table 27 Item Field 'Scl Last Date Modified' (11123304 DateTime) added - Editable=No
Table 27 Item Key 'Description' added
Table 27 Item Key 'Main Navigation Code' added
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 Key 'Description, Language Code' added
Table 30 Item Translation C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes' for details)
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
Table 36 Sales Header Field 'Payment Method Name' (11123302 Text[50]) added
Table 36 Sales Header Field 'Payment Method Status' (11123303 Text[50]) added
Table 36 Sales Header Field 'CustomFields' (11123304 BLOB) added
Table 36 Sales Header Field 'Sana Order' (11123305 Boolean) added
Table 36 Sales Header Field 'Order Date Received' (11123306 Date) added
Table 36 Sales Header Field 'Order Time Received' (11123307 Time) added
Table 36 Sales Header Field 'Sana Order No.' (11123308 Text[50]) added - Editable=No
Table 37 Sales Line Key 'Document Type, Type, Document No.' 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
Table 110 Sales Shipment Header Key 'Order Date' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Table 110 Sales Shipment Header Field 'Payment Method Name' (11123302 Text[50]) added
Table 110 Sales Shipment Header Field 'Payment Method Status' (11123303 Text[50]) added
Table 111 Sales Shipment Line Field 'Payment Cost Line' (11123302 Boolean) added
Table 112 Sales Invoice Header Key 'Order Date' added
Key 'Bill-to Name' added
Key 'Ship-to Name' added
Table 112 Sales Invoice Header Field 'Payment Method Name' (11123302 Text[50]) added
Table 112 Sales Invoice Header Field 'Payment Method Status' (11123303 Text[50]) added
Table 113 Sales Invoice Line Field 'Payment Cost Line' (11123302 Boolean) added
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
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, and OnDelete triggers (see chapter 'Code changes' for details)
Table 5722 Item Category Field 'Visible in webshop' (11123302, Boolean) added
Table 5722 Item Category Field 'OrderNr' (11123303, Integer) added
Table 5722 Item Category C/AL code added on OnDelete and OnRename triggers (see chapter 'Code changes' for details)
Table 5723 Product Group Field 'Visible in webshop' (11123302, Boolean) added
Table 5723 Product Group Field 'OrderNr' (11123303, Integer) added
Table 5723 Product Group C/AL code added on OnDelete and OnRename triggers (see chapter 'Code changes' for details)
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
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 'SclB2xCountry' added
Form 30 Item Card Control 'Visible in webshop' & header label added
Form 30 Item Card Control 'Main Navigation Code' added
Form 30 Item Card Control 'Scl Last Date Modified' added
Form 41 Sales Quote Control 'Payment Method Name' added
Form 41 Sales Quote Control 'Payment Method Status' added
Form 41 Sales Quote Global variable 'SanaCustomerNo' (Text[50]) added
Form 41 Sales Quote C/AL code added on OnAfterGetRecord trigger (see chapter 'Code changes' for details)
Form 41 Sales Quote Control 'Sana Quote' added
Form 41 Sales Quote Control 'Sana Quote No.' added
Form 41 Sales Quote Control 'Sana Customer No.' added
Form 41 Sales Quote Control 'Date Recieved' added
Form 41 Sales Quote Control 'Time Recieved' added
Form 42 Sales Order Control 'Payment Method Name' added
Form 42 Sales Order Control 'Payment Method Status' added
Form 42 Sales Order Global variable 'SanaCustomerNo' (Text[50]) added
Form 42 Sales Order C/AL code added on OnAfterGetRecord trigger (see chapter 'Code changes' for details)
Form 42 Sales Order Control 'Sana Order' added
Form 42 Sales Order Control 'Sana Order No.' added
Form 42 Sales Order Control 'Sana Customer No.' added
Form 42 Sales Order Control 'Date Recieved' added
Form 42 Sales Order Control 'Time Recieved' added
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 5730 Item Categories Control 'Visible in webshop' added
Form 5730 Item Categories Control 'OrderNr' added
Form 5731 Product Groups Control 'Visible in webshop' added
Form 5731 Product Groups Control 'OrderNr' added
Codeunit 1 Application Management Startup codes added (see chapter 'Code changes' for details)
Codeunit 7000 Sales Price Calc. Mgt. Startup codes added (see chapter 'Code changes' for details)
  
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 module.
 
Object Type ID Object Name Description
Table 5715 Item Substitution Field 'SclSorting' (11123303 Text[40]) added
Form 5716 Item Substitution Entry Control 'SclSorting' 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 module 
The changed objects described here should only be applied when the Pebbleston fashion module 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 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 v9.0, v9.01, v10.0
 
Additional changes for NAV 2009 SP1
The changed objects described here should only be applied when the NAV 2009 SP1 (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 'SclB2xCountry' added
Page 30 Item Card Control 'Visible in webshop' & header label added
Page 41 Sales Quote Control 'Payment Method Name' added
Page 41 Sales Quote Control 'Payment Method Status' added
Page 41 Sales Quote Global variable 'SanaCustomerNo' (Text[50]) added
Page 41 Sales Quote C/AL code added on OnAfterGetRecord trigger (see chapter 'Code changes' for details)
Page 41 Sales Quote Control 'Sana Quote' added
Page 41 Sales Quote Control 'Sana Quote No.' added
Page 41 Sales Quote Control 'Sana Customer No.' added
Page 41 Sales Quote Control 'Date Recieved' added
Page 41 Sales Quote Control 'Date Recieved' added
Page 42 Sales Order Control 'Payment Method Name' added
Page 42 Sales Order Control 'Payment Method Status' added
Page 42 Sales Order Global variable 'SanaCustomerNo' (Text[50]) added
Page 42 Sales Order C/AL code added on OnAfterGetRecord trigger (see chapter 'Code changes'  for details)
Page 42 Sales Order Control 'Sana Order' added
Page 42 Sales Order Control 'Sana Order No.' added
Page 42 Sales Order Control 'Sana Customer No.' added
Page 42 Sales Order Control 'Date Recieved' added
Page 42 Sales Order Control 'Time Recieved' added
Page 5716 Item Substitution Entry Control 'Relation Type' added
Page 5716 Item Substitution Entry Control 'Sorting' added
Page 5730 Item Categories Control 'Visible in webshop' added
Page 5730 Item Categories Control 'OrderNr' added
Page 5731 Product Groups Control 'Visible in webshop' added
Page 5731 Product Groups Control 'OrderNr' added
Page 5401 Item Variants New 'UpdateItemDate' procedure added. C/AL code added on OnInsert, OnModify, and OnDelete triggers (see chapter 'Code changes'  for details)
 
 Additional changes for NAV 2009 SP1 (Standard)
The changed objects described here should only be applied when the NAV 2009 SP1 W1 (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 SP1 with the Pebblestone fashion module (PFS)
The changed objects described here should only be applied when the NAV 2009 SP1 with the Pebblestone fashion module 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)
Next
InstallationMicrosoft Dynamics NAV Changes

Sitemap

Installation

Product Versions

Sana Software Links

Sana Commerce does not accept any liability for the content of this website, or for the consequences of any actions taken on the basis of the information provided. The information below should be interpreted as an example. No rights can be derived from this information.

Sana Software – e-Commerce for Microsoft Dynamics
© 1998 - 2013 Sana Software. All rights reserved
Updated: September 2011