POS Data Tables are used to display data from any table in POS. The default POS Screen that we see where we enter our items for sale also consists of a Data Table.
Data Tables are also used with Lookups, Record Zooms and Data Grids.
In this blog, we are going to create our own POS Data Table based on the Customer Table.
- Microsoft Dynamics 365 Business Central
- LS Central
The most important fields in the General Tab are:
|Data Table ID||Specify a unique ID for this Data Table.|
|Table No||Specify the ID of the Table, whose data this Data Table will be showing on POS.|
|Table Columns||Specifies the columns that will be visible in the Data Table.|
|Table Rows||Specifies how many rows should be visible by default, if there are more you can simply scroll.|
|Key Value Fields||Specifies the key fields of the select table.|
|Start Position||Defines which record should be selected when this Data Table is opened.|
|Selection Mode||This is useful when you are using your Data Table in a lookup, the options available are “MultiSelect“, “SelectOne” or “NoSelect.”|
|Default Search Type||Specifies the search type, the options available are: “Any Part“, “Beginning” or “Whole.“|
|Default Search Command||You can specify different searching commands like Filter, Search or Find.|
|Distribution Location||Specifies where the POS Data Table should get the data from.|
Do note that Web Service configuration should be done for this to work and if the record you selected does not exist on your local system, you may get an error.
For Data Table Columns:
In this tab, we specify the columns we want in our Data Table and the properties of those columns.
|Column No.||Specifies the order of the Columns|
|Field No.||Specifies the Field No. to be used from the Table for the column.|
|Key No.||Specify a value in this field if you want to search using this field.|
|Fixed Filter||Specify a value in this field for filtering the table.|
|Preferred Width||Specify the preferred width of the column.|
|Default Column||Setting this value to true, makes the current column be selected by default when opening the data table.|
|Sort Fixed||Setting this value to true, disables changing the sort order for that column.|
|Special Field Type||It is used to identify that the current column is a special type of field, there are very limited options on this field and we usually do not need to use them. Read more at Reference #3.|
|Editable||Makes the field modifiable when we use Record Zoom Controls.|
|Validate Input||Validates the input when we use Record Zoom Controls.|
|Filter Tags||Used to set a filter using “POS Tags” on that column.|
|POS Command Code||Used to specify a Command which is to be executed when user clicks on this column. A good example of this is the “Quantity” column of main POS Screen which executes the “Change Quantity” command when clicked on it.|
Thus, we saw how to create our own Data Table and the different properties associated with a Data Table.
Thanks for reading!