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 using the Customer Table.

Pre-requisites

  • Microsoft Dynamics 365 Business Central
  • LS Central

References

Configuration

The most important fields in the General Tab are:

Field Description
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 selected 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 commands like
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.
FieldDescriptionColumn No. Specifies the order of the Columns
Field Description
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.






Conclusion

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

Thanks for reading!

Comments

Post a Comment

Popular posts from this blog

Using Notifications in Business Central via AL

-
Image
Introduction Notifications in Business Central are alerts that appears in the Notification bar based on User actions. Notifications stack up from top to bottom, lasting until the user dismisses them, including those from sub-pages.  Validation errors are prioritized and shown before other notifications. We can use this to alert the user regarding something without taking all the user's notification towards it, in the way messages or errors do. They also have the option to allow Users to make a corrective action by embedding the action button directly into the notification. Let's see how it works. Source Code Pre-requisites Business Central OnPrem/Cloud. References Notification - Business Central Docs Configuration Here, for an example, I've created one simple page which takes two inputs. 1. The message that is to be shown in the notification. 2. The message to be shown after the User clicks on the action embedded in the notification.     And I have two actions which I'l...
Read more

Actionable Error Messages in Business Central

-
Image
Introduction Error handling is an important concept in every technical field.  It helps programs deal with unexpected problems and mistakes smoothly.  It makes sure software works reliably and doesn't crash unexpectedly.  Error handling also helps developers find and fix issues quickly, making the software better for users. Plus, it gives users clear messages when something goes wrong, making their experience smoother. It shows that the team has considered the scenario and has measures in place for it indicating a well designed solution. Microsoft has an amazing document which lists the things to keep in mind for writing resilient code. In Business Central, we have try functions to handle errors and error function to show those errors to the Users.  In this blog, we'll learn how we can enhance the error messages so that the Users can resolve the errors themselves or at the very least we can point them towards where the error is. Pre-requisites Business Central OnPrem...
Read more

Configure Gmail SMTP service in Business Central without "Allow Less Secure" setting

-
Image
 Introduction Business Central has great email features like sending email, editing it with Rich Text, adding attachments, etc, but to send emails, you'll need to connect it with services like Outlook or Gmail. There is no outlook side configuration that is to be done if you are using Microsoft Outlook however if you are using Google's Gmail then there's a litte change that has happened on the configuration end. Starting May, 2022, Google has removed the "Allow Less Secure Apps" settings from the Google Accounts, which was essential is using Gmail to send emails from Business Central. However, to replace that we have "App Passwords" which we can use instead. Also, just something to keep in mind, Google is going to remove this from the "Google Workspace" accounts as well by Sept, 2024 so it would be wise for you to migrate your configurations to use app passwords. Reference 1.  How to Setup Email in Business Central 2.  Google Support - Less sec...
Read more