There are certain scenarios where you have mistakenly applied the payment to the wrong vendor or you need to refund the vendor. There are two methods in order to resolve these issues. Steps to achieve the goal: Method 1: Globally search vendors. Select the vendor in which payment is applied incorrect. Go to Vendor Tab-> Ledger Entries tab. Open the Ledger entries of that vendor and then select the payment which you want to unapply. Go to Process tab and Unapply Entries. A Unapply Vendor Entries page gets open select the payment line and then click on Unapply action and click on OK. Once you click Ok the payment line in vendor ledger entries its remaining amount will not be 0. In order to balance the G/L entries we need to post the refund entry. Go to payment journal-> select the document type Refund Posting date must be same as Payment Posting Date or actual refund date. Assign the Account type as Vendor and assign the Vendor number. Select the Applies to Doc Type as Payment and in Applies to Doc No assign the Payment Document Number. Select the payment method code of return. Select the balance account number appropriately. Post the entry. If you go and check the vendor ledger entries it will be nullified against the refund.                                                                      OR Method 2: Repeat above step number 1,2,3,4,5 and 6 from Method 1 Go to Process tab-> Reverse transaction. Reverse Transaction entries page is open and in which there is action called as Reverse Transaction click on it and entries will be reversed. Conclusion: Thus we saw how we can reverse/unapply the payment mistakenly applied to the wrong vendor in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

References: Data Access – Business Central | Microsoft Docs Database.SelectLatestVersion Method – Business Central | Microsoft Docs Explanation: Caching is one of the methods which systems use to improve performance and respond to requests rapidly. In a Business Central system, caching is done at two levels: Business Central Server Instance Data Cache SQL Server Data Cache. Whenever a User requests data from Business Central, it firsts check whether The data is available in the Server Instance’s cache, If not, then it checks the SQL Server Data Cache, And if not here then it fetches the data from the database. The Business Central Server Instance’s Cache is accessible to all the Users connected to that Server Instance. There are two types of cache stored here, Global Cache Private Cache Global cache is the one which is accessible to all the Users connected to the SQL Server. Private cache is only accessible over a transaction, for a particular User, for a particular company. This cache is cleared as soon as the transaction is completed. Which cache is to be used for which User depends on whether the Table from which the User is requesting data is locked or not. In case it is locked, Private Cache is queried else Global Cache is queried. The following procedures in Business Central support using Cache: GET GETBYSYSTEMID FIND FINDFIRST FINDLAST FINDSET COUNT ISEMPTY CALCFIELDS Whenever we make a call to the “FIND” functions, 1024 records are cached. The Data Cache size in Business Central can be changed using the “Data Cache Size” setting of the Business Central Server Configuration file. The default value is set to 9 which is equivalent to 500mb. Increasing the value by 1 doubles the cache size. If we want to latest data from the database to be fetched, i.e. if we want to bypass the cache, we can use the “SelectLatestVersion” procedure. The results from Query objects in Business Central are not cached. If there are multiple Server Instances over a single database, Business Central synchronizes the cache every 30 seconds by default. We can change this by using the “CacheSynchronizationPeriod” parameter in the CustomSettings.config file. Conclusion: Thus we saw how to Caching works in Business Central and how we can optimize it usage for maximum performance in Business Central.

Introduction: Drop shipment is used when the shipping on the items is done from the vendor directly to the customer without the item coming back home to your warehouse and you delivering them. Steps to achieve the goal: To do so first create sales order and then add field drop shipment which is of boolean type using personalize features in business central Add item in sales order line and mark drop shipment if you want that item to be transported directly from vendor to customer Then create purchase order assign vendor to it and then don’t add any purchase lines instead of that go to shipment and payment tab in Ship-to field select customer and then add that customer which you want And go to action tab in purchase order page -> Drop shipment -> Sales Order ->Sales order list window Select the item that you want to get shipped directly and that item will be added in purchase orders line  In order to check the link is established between sales and purchase order. Go to Sales order then in sales order line -> Order -> Drop Shipment -> Purchase orders It will open the corresponding purchase orders which you created And post the Sales order. Conclusion: Thus we saw how we can use Drop shipments in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

Introduction: Business Central allows us to load records partially, i.e. only certain fields from a table which can be defined by the User. As this requires less data to be pulled out from SQL and similarly less data to be sent over the network, using partial records provides a significant performance gain. Even more so if the table has multiple extensions attached to it. The methods for partial loading are also available on Record References. References: Partial Records – Business Central | Microsoft Docs Record.SetLoadFields Method – Business Central | Microsoft Docs Usage: There are two groups of methods which we can use for Partial Loading. First, which set the Fields to be loaded prior to fetching the records and secondly which load the fields after the initial fetching. SetLoadFields – It is used to specify the fields which are to be loaded when the record is to be fetched using the “GET” or “FIND” procedures. Reusing this on the same record variable leads to resetting of the fields to be loaded.  AddLoadFields – It is used to load another field, in additional to the fields that have been loaded. Calling this Procedure repeatedly on a record does not lead to resetting of the fields that are to be loaded.  AreFieldsLoaded – It is used to check if the fields mentioned are loaded already or not.  LoadField – It is used to load more fields in addition to the fields that have been loaded already. To load the fields it uses a technique known as JIT Loading. Conclusion: Thus we saw how we can make use of partial loading of records with minimal code in Business Central! As a side note, I would like to mentioned that it is not recommended to use a partially loaded record for Insert, Update or Delete operations as these operations require a record will all fields loaded.

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.

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.

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!

Introduction LS Central allows us to use HTML content on the POS which includes both Text and Images. Users can add extra information related to the Items here which can assist in the POS Users to make the sales much more efficiently. In this blog, I’ll be demonstrating how to configure the same. References https://help.lscentral.lsretail.com/Content/Fields/T_10001411.htm Pre-requisites Microsoft Dynamics 365 Business Central LS Central Configuration Open Business Central and search for POS Terminals. Open the POS Terminal for the current Store and set the “Item HTML” and “Item Image” property to true. Search for Retail Items and open the Item you want to add description and image for. Open the Item Card and Go to Navigate -> Master Data -> Item HTML. Here you can specify the description for the Item that you want to be displayed on the POS and click on Save. For instance: After that go to Navigate -> Master Data -> Images and click on New. Click on Import and select the Image of that Item and then Click on OK. Go to POS and search for the Item. Double Click on the description of that Item to see the Image and the HTML Content. You can even embed Videos if required! Conclusion: Thus, in this blog we saw how we can utilize HTML content on POS. As an additional side note I’d like to mention even using Javascript is possible, to a certain extent, so for those who are curious you can even create basic games for it. Thanks for reading!

Introduction: Business Central provides you the feature to export the data in Excel in General Ledger entries, Customer Ledger entries, etc. But we can export data in a text file. In this blog, we will see how we can export data in the form of a text file. Steps to achieve the goal: Create a codeunit that will export the data in text. We will be needing Temp Blob Codeunit, Instream, and OutStream to read and write the data in the file. Below is the code which will read and write the data in the text file. You can use dynamic filename also by assigning a field value in the FileName variable; FileName: Rec_ComapanyInformation.FileNameText // FileNameText is the field present in the Company Information Page which will be used as Filename of the exported text file. We will be also using an action that will call the Codeunit function (GenerateTextFile) The output of the above code is To avoid using multiple times Write Text function if there is a lot of data that needs to be pulled from multiple fields. You can use a variable and store all the values in that variable and then assign that variable in the WriteText function. 9. The output of the above code is Conclusion:    Thus we saw how we can export data from Business Central in a text file.    Thank you very much for reading my work. Hope you enjoyed the article!

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 default receipt provided by LS. I have marked division of sections using color. Red – Header Green – Body Blue – Footer References https://www.archerpoint.com/blog/Posts/learn-how-set-pos-receipt-enhancements-ls-retail https://help.lscentral.lsretail.com/Content/How-Tos-Created-By-Support/How-To-Set-Up-Receipts-LS-Central.htm Pre-requisites Microsoft Dynamics 365 Business Central LS Central Development Environment Setup for Business Central Configuration Using Receipt Printing from POS Terminal / Store Card We can add text directly into the Header or the Footer of the POS Receipts and also define some basic properties like bold, italic or wide for the text. It can be defined at POS Level or Store Level i.e. for individual POS Terminals or for all the POS Terminals in a Store. Go to POS Terminal Card. Go to Printing -> Receipt Printing Here you add static content, like Store Name, GST/VAT No, Store Address, etc in both header and footer. Here you can also define, if you want to specify the Item No. or Barcode in the POS Receipt. Similar, to this, we can also define for Store level, i.e. all the POS Terminals in a Store. Using the “POS Print Utility” procedure: In this method, we will write actual code to modify the receipt. If you are using NAV, then this is pretty straight forward, but in case of Business Central, we only have access to Events which we can subscribe to, to change the behaviour of the procedure. The highlighted four procedures do the majority of the work done in printing. PrintHeader -> Prints the content of the header defined in the Receipt Printing. PrintSubHeader: It prints the Information related to the current Transaction. PrintSalesInfo: It prints the actual Items of the Transaction along with VAT and other details at the bottom. PrintFooter: It prints the Footer Text defined in the Receipt Printing. Now that we know which procedure is responsible for which part of the Receipt, we can subscribe to that procedure’s event. For example, let’s try me modify the “Sub Header” part of the Receipt. As such we need to modify the “PrintSubHeader” procedure, so we subscribe to its event. The parameter, sender gives us a reference to the current instance of “POS Print Utility” codeunit which we can use to call all the procedures of that codeunit with the correct values. TransactionHeader is the current “Transaction Header” record. At the start of the procedure, we need to set the IsHandled variable to True so that once your procedure ends, the parent “PrintSubHeader” procedure exits immediately. DSTR – It is the design String, here we define the design of the Line that will be printed. It is at max up to 40 characters. It follows the pattern “#(alignment)##…”. The Design String is divided into sections, each section contains one piece of data. Value – It is a text array, which defines the data which is to be printed in the sections. The number of values set in the Value should be equal to the sections in the design string. Node – It is used as a Label for the data in the section. The number of values in this array should be the same as the values in Value array. Next, the essential part is the “FormatStr” procedure, the 4 booleans at the end are used to specify whether the String is going to be Wide, Bold, High or Italic respectively. After this, the final piece of the puzzle is the “AddPrintLine” procedure, the first argument is the “Section ID”, it is related to which part of the receipt we are printing in, it is better to set it the same as the procedure from which this event is being triggered. Next argument, specifies the maximum number of Sections that will be in the design string, just make sure it is more than the values you have provided. Next, we pass the Node and Value array, the Design String and specify whether the String is going to be Wide, Bold, High or Italic and the Tray at the end. The value for Tray can be taken directly from the Event’s parameters. Similar to this, we will add one more line and then we will check the results. The “PrintSeperator” procedure is used to draw a horizontal line across the receipt using dashes. Here is the final result: Conclusion: Thus we saw how to customize POS Receipts in LS Central either through POS/Store Receipt Printing or for advanced customizations through Event subscriptions.