Using POS Data Tables in LS Central

Posted On February 25, 2021 by Rahul Bansode Posted in

Tagged in Business Central, LS Central, LS Retail, POS Data Tables

Introduction:

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.

References:

Pre-requisites:

Microsoft Dynamics 365 Business Central
LS Central

Demonstration:

The most important fields in the General Tab are:

Field	Description
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.

Dynamics 365 Business Central
pos DATA TABLE CARD I WORK DATE: 1/28/2021
CUSTOMERS
2
3
Create New From
General
Data Table ID
Description
Table No.
Table Columns
Temporary
a Table Rows
5 Key Value Field 1
Key Value Field 2
Key Value Field 3
pos Data Table Columns
Where used
Manage
More options
CUSTOMERS
Customers
Special Field
Source Expr. ID
Type
10
12
Assist Lookup
6 Start Position
7 Selection Mode
g Default Search Type
9 Default Search Command
Minimum Width
10 Distribution Location
Insert Allowed
Delete Allowed
Total Width %
Column NO.
Default Sort
Order
Ascend ina
Sort...
Fixed
SelectOne
Any Part
pos Tag Link
Is
Edit...
Vali...
Input
Zoom Glyph Text
Filter Tags
v SAVED
Command
Code
Paran

For Data Table Columns:

In this tab, we specify the columns we want in our Data Table and the properties of those columns.

Field	Description
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.