Category Archives: Blog
Inventory adjustment feature in D365 Retail POS(Commerce)
Inventory adjustment in POS can be used to account for items which need to be discarded from the store or they need to be adjusted as per the store requirement. Let’s see how a cashier can do that. Below is the setup required to be done in order for this feature to work In the inventory adjustment form you can do following setup to test the feature out Firstly you need to enable inventory adjustment in POS feature from feature management. Then in the permission group you can allow or disallow the auto inventory adjustment In POS you need to add the required button Then you need to create a journal and enter the item and quantity In the end it will go to HQ and depending on whether you have allowed the auto posting you may need to post the adjustment Hope this helps
Share Story :
Capture Case Resolution data before reopening case using C#
Introduction: When we reactivate cases, the old case resolution record is set as cancelled and a new case resolution record is created, before you re open the case, you can actually store case resolution data, which you can later use when you re-close the case. Solution: Below is the code to get case resolution data Code below is to close case again with data saved as per above string Note: Case Resolution entity is not visible through advance find, for testing purpose, you can filter activities by activity type= case resolution and regarding as your case Id.
Share Story :
Post an MS Form response to MS Teams Channel using Cloud Flows
In this blog, we will learn how to quickly design a simple Cloud Flow to post a message in MS Teams Channel when a user submits a response using MS Form. Step 1: Create an MS Form to get the responses from the targeted user. Go to https://forms.office.com/ and click on New Form to create an MS Form. Now, We will create MS Form that will take the Name, Age, Gender, Service ratting and comment which is optional as feedback. Step 2: Create a Team and Channel to post the responses Here, I am creating an Admin Team (Type — Private Team) that will be used by Management Team for organization. Now, we will add the “Feedback Responses” channel to post responses in Admin Team. Step 3: Create an Org Level Team that will be used by all team member to submit the responses (Optional — You can share the form via email or posted it on the website) Now, we will add the MS Form tab in the newly created “Feedback Form” channel so that team members can submit responses directly from MS Teams. After the channel is created, click on the + button on the top ribbon button to add a new channel tab. Look for MS Form and click to select the type of channel tab. Select Add existing form and choose your created Feedback form. After clicking on the Save button, a new Form Tab will be added to the feedback from channel of your Org Level Teams Check if Team, Channel and Form tab is visible from other users Log in with another and open the Team. Here, I have another user who has access to the Project Name team and Org Team but doesn’t have access to Admin Team as it Private Team for Management. Below is a screenshot for the same: Step 4: Create a Cloud Flow to post the response to the Private Teams channel Login to the Power Automate portal and create an Automated Cloud Flow Look for MS Form Trigger “When a new response is submitted” and click on Create to create Cloud Flow Select the Form in Cloud Flow trigger Add new step Get Response Data from MS Form Connect and select Response Id from triggering body Now, add a new step from Teams Connector Post a message (v3) to post the response in Teams Channel Configure the Team, Channel and Message (According to your requirement) Testing I have submitted the response from the MS Teams using another user: After submitting the response we get the message in the Admin Teams: Hope this helps!!!
Share Story :
Using Security Filters in Business Central
Introduction Business Central allows various levels of security that can be used to restrict User access to different features or objects. We can use Permission Sets to prevent User access to specific objects like reports or pages. For more refined, row-level authorization we can use Security Filters to restrict access to individual record based on some filters. References Using Security Filters in Business Central – Business Central | Microsoft Docs Pre-requisites Business Central OnCloud or OnPremise Configuration Suppose, you want the User to only be able to access a specific set of Customers. You can either create your own Permission Set from scratch, in which you will describe all the objects that the User will have access to or you can copy one of the existing ones by clicking on “Copy Permission Set” and then entering a new name for the permission set. Do note that you require proper permissions to make changes to Permission Sets as well. Open the Permission Set, by clicking on the “Permissions” action and Scroll to the Right. Click on the three dots next to the Security Filter field. Select the field(s) which you want to filter by clicking on the three dots next to the Field Number and then click on OK. Set a value for the filter in the “Field Filter” field. You can add as many filters as required and any Business Central filter is valid in this field (Except for wildcard characters). Once you are done, click on Close. Click on OK and add (in case there are no other permission sets and you have created your own) or replace (in case you have copied the permission set) the new permission set onto the User in the “User Permission Sets” tab of the User card. Login to the User Account and verify that only the records that match the mentioned filters are visible to the Users. Conclusion Thus we saw how to create and configure security filters in Business Central for maintaining record level security. As a side note, I would like to highlight that in Business Central, in case a User has multiple Permission Sets containing different levels of permissions for the same object then Business Central combines these Permission Sets and uses the least restrictive group of Permissions. As such if you apply a Permission Set with a Security Filter and another Permission Set without the filter on the same object, Business Central will use the one without the Security Filter as it is least restrictive.
Share Story :
ScanPayGo by LS Retail
The current Retail process supported by LS Central is simply for the customers to collect the items and bring them to the POS for completing the transaction. LS Retail aims to change this process with the introduction of their new product ScanPayGo. Using this app customers will be able to select the items to be purchased directly from within the app or by scanning the barcode on the item, manage or share multiple shopping lists , pay directly from within the app or pay at the POS by simply scanning one QR code instead of all the items as was done previously. It also allows paying using loyalty points if sufficient points are available. As a security feature the app has random checks in which after a transaction the customer has to confirm with a Staff member to verify the purchased items. It maintains a purchase history so that repeated transactions need not be scanned repeatedly. It help customers find the closest Store by providing a list of all the available Store ordered by the closest Store. It also displays the current available offers in the Store. All of which adds on to the seamless retail experience with minimal interaction. Retailers can customize the color scheme and logo of the app however they wish. Retailers can also offer personalized ads to Users using ScanPayGo! This application is going to be available for both Android and iOS.
Share Story :
How to personalize Password field based on strict Regular Expression (RegEx) formulas in Canvas PowerApps
Hello,In this blog, I’ll show you how to personalize Input Password field with various requirements using strict regular expression in Canvas PowerApp. Now, validation part comes in using RegEx. Let’s say you have a requirement where,1. Password length should be equal or greater than 8.2. Password should contain at least 1 number.3. Password should contain at least 1 lowercase alphabet.4. Password should contain at least 1 uppercase alphabet.5. Password should contain at least 1 special character. After everything all requirements is satisfied, show that password is valid. Let’s say you have 5 labels containing Text of these requirements and will be visible if its respective condition is not satisfied. Hope this helps you.
Share Story :
SQL Trigger not populating with Table in Logic App
Wondered How to solve SQL triggered Azure Logic Apps issue of not being able to select your table in dropdown? This blog will help you fix this issue.
Share Story :
Inventory Adjustments in Business central using Inventory Documents
Introduction: To adjust your inventory there is another ability provided by Business central using Inventory Documents. We can do positive and negative adjustments using Inventory Receipts and Inventory shipments respectively. Steps to achieve the goal: First, we need to set up the number series for Inventory Receipts and Inventory Shipments and Posted Inventory Receipts and Posted Inventory Shipments on Inventory setup. 2. Go to Purchase Receipts and assign the Item in line, fill all the required details. You can reopen and release documents, but it is not required. Once you have filled in the necessary information you can post the Inventory Receipts. The item will be adjusted and you can see it in Item ledger entries. Same we can do it by Inventory Shipments when the item is damaged or needs to be return Fill in the necessary details in Inventory Shipments and post them. You can also print the Inventory Receipts, Inventory Shipments, and Posted Inventory Receipts and Posted Inventory Shipments. But the base application doesn’t include any layouts. So you can create your own report and assign it in Report Selections-Inventory according to usage. Posted Inventory Receipts and Posted Inventory Shipments are nonsearchable in order to print the posted documents you need to visit Item Ledger entries -> Document type=Inventory Receipts -> Find entries-> Item Receipt Header and then you can print the Posted Inventory Receipts. 10. Same for the Posted Inventory Shipments go to Item Ledger entries-> Document Type= Inventory Shipments-> Find entries-> Inventory Shipment Header and then you can print the Posted Inventory Shipments. Conclusion: Thus we saw how we adjust the Inventory using Inventory documents. Thank you very much for reading my work. Hope you enjoyed the article!
Share Story :
Disable field on change of tab in D365 CE
Use case – Our requirement is to enable field description field on invoice line form on clicking of tab General. Let’s see how we can achieve this Solution – Step 1 – Create web resource with below function- var invoiceLineCustomization = { unlockField : function(executionContext) { var formContext = executionContext.getFormContext(); formContext.getControl(“description”).setDisabled(false); }, } Step 2: Add this web resource on tab property event TabStateChange and try. (path to go to event tab – Click on tab -> change properties -> event) Output – Hope this helps !
Share Story :
Configuring Barcodes on POS Receipts
Introduction: Refunding a transaction is an everyday occurrence in Retail. LS Central provides us with the functionality to initiate the refund of a transaction by simply scanning one barcode! In this blog, we will be looking at how to configure this feature. References: https://help.lsnav100.lsretail.com/Content/LS%20Retail/POS/Hardware/Printing%20Receipt%20Barcodes.htm Pre-requisites: Microsoft Dynamics 365 Business Central LS Central Configuration: From Business Central, open the POS Terminal for the current Store. In the “Printing” tab, Set the “Receipt Barcode” ID to 101. Set the “Print Receipt BC Type” to “CODE39” or “CODE128_A”. You can optionally adjust the Barcode Height and Width but depending upon the POS Printer it may or may not be scannable as the resolution of the barcode suffers. The default parameters which are applied if you leave the fields to 0 are width – 8 and height 40. Set the “Receipt Barcode” to true. Once this is done, simply run the POS and generate a Receipt. When the Barcode at the bottom of the Receipt is scanned it should directly take the User to the refund screen of the POS. For instance, this is how it looks on the Virtual Printer: While, this is how it looks when using a real printer. Conclusion: Thus, in this blog we saw how to configure Barcodes on POS Receipt. Thanks for reading!