web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / D365 Business Central by CloudFronts / Using POS Data Tables in LS...

Using POS Data Tables in LS Central

Views (5)
Community Member Profile Picture Community Member

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!

The post Using POS Data Tables in LS Central appeared first on .


This was originally posted here.

Comments

*This post is locked for comments