Search this site

Microsoft Business Central Creating a new Campaign The scope for this procedure is to look at the step-by-step required to create a new Campaign within the system. Join On Point Academy to view all content Join the academy → Log in → Step-by-step guide Accessing the Campaigns Go to the search button Search for Campaigns Click on Campaigns Creating a Campaign Click new Insert the Details The newly made Campaigns will be auto saved Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central How to Create Purchase quote This document is as a quick reference to create purchase quote in Business Central. Join On Point Academy to view all content Join the academy → Log in → Purchase quote Go to Purchase Quotes (type Purchase Quotes in the Search box and click on a link) Choose action +New Fill in Vendor information and in the quote line fill in Type, No. , and Quantity Make order out of Purchase Quote: click on Process → Make Order You have created a Purchase order form the Purchase Quote Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central How To Cancel A Posted Sales Invoice A posted invoice can be changed or cancelled. This is helpful if you need to change a sale early on in the ordering process or if you need to fix a typing error. To do this; Join On Point Academy to view all content Join the academy → Log in → Step 1 – Click on the search icon at the top right and type in “POSTED SALES INVOICES”. A list drops down then select the related link. Step 2 – Enter the invoice number in the search section under “POSTED SALES INVOICES”. Step 3 – Among the available options select “CORRECT”. A list drops down then select "CANCEL" Step 4 - Select "YES" to confirm the action Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central How to Import Multiple Item Pictures You can import multiple item pictures in one go. Simply name your picture files with names corresponding to your item numbers, compress them to a zip file, and then use the Import Item Pictures page to manage which item pictures to import. Join On Point Academy to view all content Join the academy → Log in → All common file formats are supported. To name picture files by the item names and prepare the ZIP file At the location where your item pictures are stored, name each files according to the number of the related item. For example: Item No.File Name10001000.bmp10011001.bmp10021002.bmp Collect all the files in a ZIP file. For example, in Windows Explorer, select the files, and then choose Send to , Compressed (zipped) folder . To import item pictures Choose the icon, enter Inventory Setup , and then choose the related link. Choose the Import Item Pictures action. In the Select a ZIP file field, select the relevant ZIP folder, and then choose the Open button. A line for each item and picture is created on the Import Item Pictures page. Note For item cards that already have a picture, the Picture Already Exists check box is selected. If you do not want any existing pictures to be replaced, deselect the Replace Pictures check box. If you do not want individual existing pictures to be replaced, delete the lines in question. Choose the Import Pictures action. The Import Status field is updated to show if the picture import was skipped or completed. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central How to Modify Sales Quote Email Template to Customers You can set up default reports that will be used to print the various documents for sales and purchases, such as orders, quotes, invoices, and credit memos. Join On Point Academy to view all content Join the academy → Log in → For example, if you have a specific layout for sales invoices, you can specify that report in the Report Selections - Sales page so that it will be used to send or print sales invoices. The Report Selections pages specify which report will be printed in different situations. Business Central includes default configurations, but of course you can change these defaults. You can also add reports to the Report Selection pages if you want to print more than one report per document type, for example. Report selection for sales documents 1. Choose the search icon , enter Report Selection - Sales , and then choose the related link. 2. Click on the Email Body Layout Description field action. 3. On the Custom Report Layouts page, select the Default Email Body description. 4. Click on the Layout field and Select Export Layout. 5. Edit the Layout by adding the company logo to the sales quote. 6. Click on the Layout field and Select Import Layout the edited word document. 6. Select the new email template which is created as Copy of Default - Email Body . To send an email with the standard email body template 1. On the Sales quote page, navigate to the Print/Send button and click on Send by Email . 2. Fill in the fields as necessary. 3. Click on OK. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Configuration Packages Configuration Packages (CP) are used to facilitate the deployment of a NAV/Business Central company. This is achieved through the importing of tables and respective data from Microsoft Excel. Join On Point Academy to view all content Join the academy → Log in → Configuration Packages Management Creating a Configuration package The process below will describe the creation of a CP. Note that this operation may require the RapidStart Services Role Center Page. Type Configuration packages into the search box and select the result. Click New to open a new Config. Package Card. Fill in the Code and Package Name fields in the General FastTab Manually Adding tables to a Configuration Package Open the created CP from the Configuration Packages Page In the Tables FastTab, click on the first line under the Table ID and on the adjacent arrow to open the list of Objects Select the tables accordingly A line must only contain one table. To facilitate the process, you may use the Get Related Tables function. This function should be done after you select a table as described above. Adding tables to a Configuration Package using a worksheet If you are planning to use the process for multiple similar companies then a Configuration Worksheet (CW) can be useful. A CW will be used to input all requested tables once, so that a CP can be filled in automatically. Click on Configuration Worksheet -use the Search box accordingly In each Line Type field select Table and in the Table ID specify each table value. In the CP, click on More options than Actions than Functions and select Get tables process Click on the ellipsis button […] next to Select Tables to open the CW. Select the tables needed and press ok. Importing and Exporting a Configuration Package An CP export file is A CP can be imported or exported with the respective CW. However, when using the process between two databases, both databases must have the same schema, that is, the structure of tables, fields and properties. Otherwise some data may not be imported correctly. Applying a Configuration Package Exporting tables as a template Use the search function to get to the Configuration Packages Select and enter the CP On the General Tab select Package and than Export to Excel Exporting Selected fields as a template The previous section illustrated an example of a table export with a full field set. Business Central offers more flexibility as you can also export tables with selected fields. Select and enter a CP. Select a table. Click on the Number of Fields Included on the line of selected table. To select the fields for export, you must tick/untick the Include column per each field accordingly. Tip: The Filter functionality can be very useful when doing this process. To include/exclude all fields at once, you must click on Set Included or Clear Included respectively. Note that all fields can be excluded except for the primary key fields. When you are ready, return to the Configuration Package card and proceed with Export. Importing Data through a CP Once you get the MS Excel file, you can enter data into the tables (MS Excel Sheets) respectively. Tables with existing data can be amended or appended. The process will note the differences and apply accordingly. The import from excel process is triggered from the process next to the export one. Addressing import Errors Errors encountered during the import process are highlighted in red accordingly along with a respective count. To fix the error you must follow the steps below: Click on the count value found under No. of Package Errors . In Figure 13 the count is depicted as 1. The error entry in particular is displayed Click on Show Error The error in this case is data exceeding the character limit. You can either amend the excel and reupload accordingly, or you can amend the data directly from NAV/ Business Central. The latter can be done from the page illustrated in the previous Figure. Find the field causing the error and change the value. The entry should disappear from the screen and the count reduced accordingly. Applying a Package The import done so far has not been committed to the database. To do so, you must apply the package so that all new records and/or amendments are reflected. This is triggered from the Apply Package process. You can get there form Actions → Function → Apply Package Once it is completed a confirmation message with all the results will be displayed. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central End-of-Year Process in NAV The document will provide a step-by-step end of year process Join On Point Academy to view all content Join the academy → Log in → Before Starting the Year End Process Review the Chart of Accounts and make sure that the Income/Balance field is set up correctly for each account. Whatever is meant to be a Balance Sheet Account should be set as Balance Sheet and whatever is meant to be set as an Income Statement Account must be set as Income Statement: Note that when a company is set up with an Additional Reporting Currency, NAV/ Business Central will automatically post the entries when the Close Income Statement is run. If the Additional Reporting Currency is blank, the entries will be created in a journal and the user would then need to post the journal manually. Closing Financial Year Go to accounting Period Click on Process then click Close Year Button Running the Year-End Procedure From the Search Box, type Close Income Statement and select the loaded link. A window will be loaded with a number of fields that need to be populated: Fiscal Year Ending Date is usually loaded automatically Fill in the General Journal Details (Template and Batch) Fill in the other Details as per Company agreed setup: Document No. Posting Description Retained Earnings Account Select the Dimensions being utilised Click OK If the Additional Reporting Currency is populated, NAV will automatically post the entries. In this case, go to the Retained Earnings account in the Chart of Accounts and verify that new entries have been posted: If the Additional Reporting Currency is blank, then the below additional steps are required: Go to the journal template and batch which was previously chosen when running the Close Income Statement Report Post the entries found in the batch Go back to the Account Periods screen and Create the Year. If the year was already created, then skip this step. There is a possibility that errors occur during the Close Income Statement process or the posting process due to Dimensions. If this happens, save a copy of the Account Type Default Dimensions, delete the records and re-try the process. Once the values are posted, re-load the dimensions. Please contact NAV/Business Central support to help with this step. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →