Using POS Data Tables in LS Central - CloudFronts

Using POS Data Tables in LS Central

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:

  1. https://help.lscentral.lsretail.com/Content/LS%20Retail/POS/Data/Data%20Tables.htm
  2. https://help.lscentral.lsretail.com/Content/Fields/T_99001565_11.htm
  3. https://help.lscentral.lsretail.com/Content/Fields/T_99001565_14.htm


Pre-requisites:

  • Microsoft Dynamics 365 Business Central
  • LS Central

Demonstration:

The most important fields in the General Tab are:

FieldDescription
Data Table IDSpecify a unique ID for this Data Table.
Table NoSpecify the ID of the Table, whose data this Data Table will be showing on POS.
Table ColumnsSpecifies the columns that will be visible in the Data Table.
Table RowsSpecifies how many rows should be visible by default, if there are more you can simply scroll.
Key Value FieldsSpecifies the key fields of the select table.
Start PositionDefines which record should be selected when this Data Table is opened.
Selection ModeThis is useful when you are using your Data Table in a lookup, the options available are “MultiSelect“, “SelectOne” or “NoSelect.”
Default Search TypeSpecifies the search type, the options available are: “Any Part“, “Beginning” or “Whole.
Default Search CommandYou can specify different searching commands like Filter, Search or Find.
Distribution LocationSpecifies 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.

FieldDescription
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 FilterSpecify a value in this field for filtering the table.
Preferred WidthSpecify the preferred width of the column.
Default ColumnSetting this value to true, makes the current column be selected by default when opening the data table.
Sort FixedSetting 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.
EditableMakes the field modifiable when we use Record Zoom Controls.
Validate InputValidates the input when we use Record Zoom Controls.
Filter TagsUsed to set a filter using “POS Tags” on that column.
POS Command CodeUsed 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.
Customer names have been covered up for privacy reasons.

Conclusion:

Thus, we saw how to create our own Data Table and the different properties associated with a Data Table.

Thanks for reading!


Share Story :