Category Archives: Blog

Customizing POS Receipt Layout

Introduction POS Receipts are generated after every transaction that occurs on POS. The default receipt provided by LS Central is generally sufficient but as is in all things there are always exceptions. There are two approaches we can use to modify the POS Receipts and we are going to see them both. This is the … Continue reading Customizing POS Receipt Layout

Share Story :

Use Microsoft Forms with Power BI Reports

Posted On April 3, 2021 by Jaison Menezes Posted in Tagged in ,

Sometimes we would want to ask users about their thoughts , opinions or ask some questions along with a PowerBI report. That is, we would need  to collect information about the user through PowerBI App.  This can be done by creating a Microsoft Form inside PowerBI interface to collect user information. This can be demonstrated … Continue reading Use Microsoft Forms with Power BI Reports

Share Story :

Configuring Scheduled Jobs – Part II

Introduction: In the previous Blog, we saw how to configure the Schedule Job Header, this time we will configure the Sub-jobs. In Sub-jobs, we can define the Table structures to be followed, Tables the Data is supposed to be sent to, filters, replication counter fields and so on. References: Repl. Counter Interval, Scheduler Subjob (lsretail.com) … Continue reading Configuring Scheduled Jobs – Part II

Share Story :

How to solve OLE DB or ODBC errors in PowerBI

Introduction: Sometimes while refreshing our dataset in PowerBI or importing new data from existing sources we may encounter OLE DB or ODBC errors as shown in the image below. This might be due to caching issues. To solve this follow the steps: Go to File tab on the ribbon in PowerBI Desktop , then click … Continue reading How to solve OLE DB or ODBC errors in PowerBI

Share Story :

How to extract information from XML/HTML/FSON and convert it into PlainText in Canvas PowerApps without Flow

Posted On March 16, 2021 by Ethan Rebello Posted in Tagged in , ,

If you are curious about the data in XML/HTML/JSON and want to fetch data from it without flow. Here’s something what you can do There’s an inbuilt function in PowerApps that converts HTML/XML to string text. Function Name is ‘PlainText‘. But all tags are neglected and extracting certain data is difficult. Consider you want to … Continue reading How to extract information from XML/HTML/FSON and convert it into PlainText in Canvas PowerApps without Flow

Share Story :

How can you set one on one approval workflow in Business Central?

Introduction: One of the scenarios where you want the Person A approval request should be approved by Person B and Person B approval request should be approved by Person A. How to achieve this goal: Go to Workflows page I want to create a Purchase Order Approval Workflow from Templates. Go to New-> New Workflow … Continue reading How can you set one on one approval workflow in Business Central?

Share Story :

Control elements in PowerApps with different font-size

Posted On March 15, 2021 by Ethan Rebello Posted in Tagged in , ,

Its good to have a user’s choice based font-size but without controlling how it displays on screen may not look good. I have created a simple design that consists of a header, gallery and font-size slider to show how elements react on certain font size. Here’s how it looks. How to make this, Set your … Continue reading Control elements in PowerApps with different font-size

Share Story :

Inventory lookup feature to be operational in 10.0.19 release of D365 Retail(Commerce)

As of now as a POS user if you want to check the inventory of an Item , you will need to click on the inventory lookup button on homepage and you will have to then enter the item number to display a list of store wise inventory. While this feature is useful, there is … Continue reading Inventory lookup feature to be operational in 10.0.19 release of D365 Retail(Commerce)

Share Story :

Database error on POS while adding products to cart in D365 Retail POS

Posted On March 13, 2021 by Rutvik Mehta Posted in Tagged in

This particular error ‘A database error has occurred’ took a very long time to resolve for us as neither us or Microsoft were able to figure out what was causing it. We verified and double checked following to resolve the issue but to no avail. I suggest you to first ensure the below things before … Continue reading Database error on POS while adding products to cart in D365 Retail POS

Share Story :

Register/Create customer accounts of store employees on POS in D365 Retail(Commerce)

In Retail store you will need to assign address books i.e. One for store staff/employees and the second one for customers. If you fail  to do that then on POS you will not be able to login or see/search for customers The above setup is the ideal for the store to function properly. However, some … Continue reading Register/Create customer accounts of store employees on POS in D365 Retail(Commerce)

Share Story :