There might be a case where the vendor sends a single invoice for multiple purchase orders receipts, in this scenario we will see how to post one invoice for multiple purchase receipts of the same vendor. You can use Combine Receipt function to Invoice more than one purchase receipt. In search option, enter Purchase order and then choose related link Click on New button to create Purchase Order. Enter all necessary information on Purchase order which are required and click on Post button. Select receive and choose OK button to post purchase receipt. Repeat steps from 1 to 4 to create multiple Purchase order and post purchase receipt. Now in search option, enter Purchase Invoices and choose related link. Click on New button to create Purchase Invoice. Select Vendor in Vendor Name field. On the LinesFastTab, choose the Get Receipt Lines. Select multiple receipt lines that you want to include in the invoice and choose the OK button. In Line section, You can see the added purchase receipt lines. To post the invoice, choose the Post action.    

There might be a case where the company sends a single invoice for multiple Sales orders shipments, in this scenario we will see how to post one invoice for multiple sales shipment of the same customer. You can use Combine Shipment function to Invoice more than one sales shipment. In search option, enter Sales order and then choose related link. Click on New button to create Sales Order. Enter all necessary information on Sales order which are required and click on Post button. Select ship and choose OK button to post Sales Shipment. Repeat steps from 1 to 4 to create multiple Sales order and post sales shipment. Now in search option, enter Sales Invoices and choose related link. Click on New button to create Sales Invoice. Select Customer in Customer Name field. On the LinesFastTab, choose the Get shipment Lines. Select multiple Shipment lines that you want to include in the invoice and choose the OK button. In Line section, You can see the added sales shipment lines. To post the invoice, choose the Post    

Introduction: In this blog, I want to depict how a table structure can be integrated into an Email in Business Central using the HTML tags. Pre-Requisites : Microsoft Dynamics 365 Business Central HTML Steps: Create an Email Structure using the SMTP Mail setup Codeunit and pages. The body that is to be attached to the Mail will be the table structure that will be created using HTML tags. The HTML tags used are as follows: <th> : To create the heading for the table <tr>: To create the rows for the table <td>: To input the data for the table Code for the table structure and mail is as follows: SMTPSetup.CreateMessage(”, SMTPMailSetup.”User ID”, Rec_Contact2.”E-Mail”, ‘Scheduling Report’, ”, TRUE); SMTPSetup.AppendBody(MailBody); SMTPSetup.AppendBody(‘<br>’); SMTPSetup.AppendBody(UserDetails); SMTPSetup.AppendBody(‘<br>’); SMTPSetup.AppendBody(‘<table border=”1″>’); SMTPSetup.AppendBody(‘<tr>’); SMTPSetup.AppendBody(‘<th>Purchase Conformation</th>’); SMTPSetup.AppendBody(‘<th>Vendor Name</th>’); SMTPSetup.AppendBody(‘<th>Vendor Ref:</th>’); SMTPSetup.AppendBody(‘<th>Product Name</th>’); SMTPSetup.AppendBody(‘<th>Estimated PU Date</th>’); SMTPSetup.AppendBody(‘<th>PU Date</th>’); SMTPSetup.AppendBody(‘<th>PU Time Begin</th>’); SMTPSetup.AppendBody(‘<th>PU Time End</th>’); SMTPSetup.AppendBody(‘</tr>’); SMTPSetup.AppendBody(‘<tr>’); SMTPSetup.AppendBody(‘<td>’ + Format(“Blanket PO No.”) + ‘-‘ + Format(“Blanket PO Line No.”) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(Name) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(VSO) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(ProductName) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(EstPUDate) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(PUDate) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(PUStartTime) + ‘</td>’); SMTPSetup.AppendBody(‘<td>’ + Format(PUEndTime) + ‘</td>’); SMTPSetup.AppendBody(‘</tr>’); SMTPSetup.AddCC(Rec_UserSetup.”E-Mail”); SMTPSetup.Send; 3) The table output looks as follows when the mail is sent:               Conclusion: Thus, using the basic HTML table tags a table structure can be integrated into the Email functionality of Business Central.

D365 BC product is being improved continuously and following is the expected improvement coming in April Updates. Improvements to Scrolling in Lists When scrolling in a list page today, your scrolling is periodically interrupted with a “fetching more rows” indicator. Scrolling pauses while Business Central fetches and loads more rows into the page. See below for an example of this: Microsoft’s latest enhancements aim to improve scrolling experience. You will be able to scroll to any position on a list without pause. We’ve been able to see the improved experience in our preview environments and believe this will be a simple but highly valued feature for frequent Business Central users!

D365 BC product is being improved continuously and following is the expected improvement coming in April Updates. Longer Names and Descriptions Microsoft plans to update Business Central to allow for longer name and description values. All name and description fields are being lengthened from 50 to 100 characters, providing you with greater flexibility and fewer compromises when naming or describing entities such as general ledger accounts, customers, vendors or items. The image below illustrates a Business Central vendor record where the vendor’s name has been populated with 100 characters.              

D365 BC product is being improved continuously and following is the expected improvement coming in April Updates. Auto Save Indicator The lack of a save button in Business Central may be a source of confusion for those without prior Business Central experience. Like many other modern web applications, Microsoft plans to add a saved indicator to the application. Here’s what it looks like when a change to a vendor record is underway: Notice the saved indicator when a page is initially opened (in this case the Vendor Card page). Now I’ll change the vendor’s name. Notice below how the autosave indicator updates automatically. When Business Central has finished updating the record, the autosave indicator updates once more, showing this update has been saved in the application.  

Introduction: Attachment is a relatively new functionality in Business Central. Unlike Links you need not store the links to the document but attach the document itself. In this blog I’ll be showing how to customize Business Central to attach documents to any table. Pre-requisite: VS Code Microsoft Dynamics Business Central Demonstration: Attachments are stored in Table 1173 Document Attachment Table. Using the standard document attachment table functionality does not support attaching on all the tables / pages. Currently in Business Central attachment functionality is allowed only on Master and Documents. Adding a field in Document Attachment Table to classify if you want to attach documents for different purpose. In this case I wanted to Attach two types of Documents. So I created an Option Type with Scale Ticket and Lab Report which will be set during the insertion of attachment in the Page. Refer: SaveAttachment2 function. Creating a Custom page with Source table as Table 1173 Attachment Document. I’ve created a Custom Page because the standard pages calls a function that does not allow me to attach different types of attachment. Thus the Custom page contains SaveAttachment2 function which allows to mention the type of Attachment for the record. Adding Custom methods to Attach the documents with different types on Single Record. i.) Export : This function downloads the attachment that is stored in the system wen clicked on the name ii.) SaveAttachment2:This function saves the attachment for the record with the specific type of attachment. It stores the TableID, Record Primary Key and then LoadType to specify type of attachment for that load. GetLoadType: This function is used to pass the type Calling the CustomAttachedPage from the Page/ Table you want to attach. Output: From the Record you want to attach the document To download the Attachment, click on the Attachment FileName. Conclusion: In this way we can attach documents to any record of any table in Business Central.

Microsoft Dynamics 365 Business Central is an all-in-one business solution built for small and mid sized firms that have outgrown their limited accounting software With its emphasis on scalability, Business Central comes with plans to fit various requirements: Essentials and Premium.               Business Central – Essentials Business Central Essentials includes applications that are essential to any ERP platform and costs just $70/user/month. Here is just a high-level look at Essentials functionality: Financial Management GL, AP, AR Allocations Budgets Fixed Assets Month/Year end closing Multiple Currencies   Supply Chain Management Inventory and purchasing control Shipment and distribution Returns and cancellations Procurement and vendor management   Warehouse Management Order Promising Warehouse Receipt/Shipment Warehouse Management Systems Automated Data Capture   Project management Capacity Management Multiple Costs Sales Invoicing, Sales Order Management Estimates Jobs, Time Sheet   Human Resource Management   Built-in CRM Functionality Contact Management Task Management Outlook Client Integration Dynamics 365 for Sales and Customer Service (optional)               Business Central – Premium Premium includes everything in Essentials, plus modules for complete Manufacturing and Service Management, enabling businesses to streamline their entire operations from end-to-end. It’s available for $100 per user/month and includes: Everything in Essentials   Manufacturing Production orders Production Bill of Materials Supply planning Demand forecasting Capacity planning Agile Manufacturing   Service Management Service Order Management Service Price Management Service Contract Management Planning and Dispatching

Introduction: This blog demonstrates how the information that is visible to a user on the window can be controlled and managed. The ‘Importance’ property of a field helps us to control whether a field is seen or hidden on a window. Pre-requisites : Microsoft Dynamics 365 Business Central Steps: The Importance property helps to control the visibility of a field on the window. A field can be shown when clicked on the ‘Show More’ option and can be hidden on the ‘Show Less’ Action, we can even show the field value on the FastTab Header  when the whole FastTab  is collapsed. The values of the Importance property are as follows: Standard : It displays the field on the page by default. Promoted : It displays the field on the page and shows it on the FastTab Header when the FastTab is collapsed. Additional : It hides the field on the page, inorder to view the field user can click on the Show More action on the FastTab. 3. The Example below demonstrates this property : The Buy-From County Field (State) its Importance property is initially set to Additional. Therefore, it can only be seen when Show More action is clicked. After setting its Importance property value as ‘Standard’ the field is visible on the page by default. After setting its Importance property value to ‘Promoted’ its value is seen on  the page and even on the FastTab Header when the FastTab is collapsed. Conclusion: Thus, by using the Importance property of the field the user can control the Amount of information regarding a particular entity that needs to be shown/hidden.

Introduction: In Business Central, to send an Email the sender Email is always the user in SMTP Setup. But, what happens when you are sending email from <admin@yourorganization.com> but should be going department wise ie. <sales@yourorganization.com> and <marketing@yourorganization.com>. Thus in this blog I’ll be showing how to send email from the department email using the admin email. Pre-requisite: 1. VS Code. 2. Office 365. 3. Microsoft Dynamics Business Central. 4. MS Flows. Demonstration: 1. Setting Up MS Flows: Creating the HTTP request: Using Sample Payload as : [{ “sender”:”Test Sender”, “recepient”:”Test recepient”, “subject”:”Test Subject”, “body”:”Test body” }] Add the  Send an Email action: Save the MS Flow and copy the trigger URL in  Postman and passing JSON, check if you the email. Check mail box for delivery of Email 2. Enable email delegation in Office 365. In portal.office.com, navigate to Admin > Admin Center > Exchange > Mail boxes > <–Admin Email–> > Delegate Add you department email here. In this cas Cloudfronts@xyz.com is admin email and olisterr@xyz.com is department email. 3. Call the MS Flows from Business Central. Code: 4. Output Conclusion: Thus in this way we can use MS Flows Webhooks to actually trigger an email passing the data through JSON as an POST http request.