Category Archives: D365 Business Central
How to setup FieldGroups in Business Central
Introduction: A field group in table or table extension objects defines the fields to display in a drop-down control on pages that use the table and fields that display when these pages are shown in the tile view. Syntax of fieldgroup is as follows: fieldgroup(<Name>;<Field>) <Name> : It can be either Dropdown, so as to … Continue reading How to setup FieldGroups in Business Central
Share Story :
Difference in configuration of Role Center between NAV and Business Central.
Introduction: Difference in configuration of Role Center between Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central. Pre-requisites: Microsoft Dynamics NAV Microsoft Dynamics Business Central Solution: In Microsoft Dynamics NAV After creation of Role Center. When assigning the Role Center Page to the User the following process is followed. 1. Creating a new Profile in … Continue reading Difference in configuration of Role Center between NAV and Business Central.
Share Story :
Create a Customer, Vendor, or Bank Account from a Contact
Introduction: Companies want to record some of contacts as customers, vendors, or bank accounts. Creating a customer, vendor, or bank account from a contact enables you use existing data. When you create a customer, vendor, or bank account this way, it is synchronized with the contact. Prerequisite: Setup Business relations Select Business relation codes in … Continue reading Create a Customer, Vendor, or Bank Account from a Contact
Share Story :
Formatting Address Data separated by delimiter in the single field
Introduction: Whenever the a single field in NAV contains Name, Address and other values seperated by delimiter such as ‘,’. But this field cannot formated in SSRS to look appropriate as follows. For Example in NAV: John Peter, Long Island, New York,US. Formatting in SSRS: John Peter, Long Island, New York, US. Pre-requisites: Microsoft Dynamics … Continue reading Formatting Address Data separated by delimiter in the single field
Share Story :
Item Attributes in D365 Business Central
Item Attributes are user-defined classifications that can be assigned to your items for ease of searching, filtering, and reporting. For example, a Marketing team could use attributes to help with classifying their items to aid in the grouping, sorting, and filtering for a catalog or website. The Sales team could use these same Attributes to … Continue reading Item Attributes in D365 Business Central
Share Story :
Configure Web Services through Code in Business Central
Introduction: When coding an app that uses Webservices to connect to the integration solutions, it is generally recommended that there is a Setup, which we can configure, where the Webservices are created as well as deleted. Pre-requisites: Business Central VS Code with AL Language Extension Demonstration: Create a Setup Page having a boolean variable say … Continue reading Configure Web Services through Code in Business Central
Share Story :
Sales Quote Dynamics 365 Business Central
Sales Quote use to record an offer to a customer to sell certain product on certain delivery and payment term. You can send quote to customer, negotiate with the customer, you can change and resend the sales quote as much as needed. When the customer accepts the quote, you convert the sales quote to a … Continue reading Sales Quote Dynamics 365 Business Central
Share Story :
How to fetch a custom table created in Business Central into PowerApps using CDS and Odata.
Introduction: In this blog, I have introduced how to fetch a custom table from Microsoft Dynamics 365 Business Central into Microsoft PowerApps using Common Data Service(CDS) and OData. The table that was created in Business Central was fetched into a custom entity(MatchingLists) in CDS that allows me to create a local database in PowerApps for … Continue reading How to fetch a custom table created in Business Central into PowerApps using CDS and Odata.
Share Story :
Correct Posted Purchase Invoices – Dynamics 365 Business central
Introduction : This functionality helpful to correct posted Purchase invoice if user make mistake or want to do any changes. You cannot correct posed purchase invoice which are partially or fully paid. Steps: In search bar enter Posted Purchase Invoice and chose the related link. Select and open Posted Purchase Invoice which you want to … Continue reading Correct Posted Purchase Invoices – Dynamics 365 Business central
Share Story :
Custom Transformation Rule for ACH using AL Extension in Business Central
Introduction: Dealing with Electronic Bank Payment Setup can be tedious and time consuming. In this blog, I’ve a unusual requirement where the payment date should be the next day of the check issue date. Pre-requisite: 1. Microsoft Dynamics Business Central 2. VS Code and AL Language Extension Demonstration: 1. In standard Data Exchange Definition, I … Continue reading Custom Transformation Rule for ACH using AL Extension in Business Central