Search this site

Microsoft Business Central G/L Dimension Overview in NAV This document is a quick reference guide on how to use G/L Dimension Overview in General Ledger Entries. Join On Point Academy to view all content Join the academy → Log in → How to find Please open General Ledger Entries using the search box on the top right corner. How to use First of all, you should use the standard filtering function to see only general ledger entries you need. For example, entries posted last month to the cost accounts. Flitering by Dimension values As all dimensions cannot be filtered as standard fields, you can use the Set Dimension Filter button for. This is function especially programmed for filtering General Ledger Entries by dimension values. In order to open it, please click on Entry, then on Set Dimension Filter… Choose dimension code and value, you want to see only. Below is what your window should look like. You can, of course, add more than one filter here. For example, I’ve made my filter show only small businesses. The general ledger entries are now filtered also by dimension values, you have chosen, see the picture below. You can also delete individual filters by clicking X on them, or delete all filters by clicking Reset filters. When you are satisfied with data you have filtered out, you can continue to the Dimension Overview. Dimension overview In order to open the Dimension overview, click on Entry, then on G/L Dimension Overview. Then click on Show Matrix. You can see now General Ledger Entries and their Dimension Values in one page. For a deeper analysis of the data, you can send lines to the excel via the share button. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Jet Reports Customer Sales Report A customer sales report summarizes a business’s sales activities. it helps analyze the volume, and this report might help you to modify your sales approach and some necessary growth for your company. Sales Reports can be created in different types based on what you want your Report to show. To create this customer sales report, we need information from 3 different tables… Join On Point Academy to view all content Join the academy → Log in → a. Customer Table b. Item Table c. Item Ledger Table The following information as shown below will be retrieved from the table. Procedure Step 1 pulling out the information we need Just as I have explained, the NL(Rows) will contain our source of data, which will be pulled from the table “Customer“. The NF (Keys) will be a cell reference, which will be referencing cell $D6, and the fields will be pulled from the names as shown. For the “Item no”, each customer number contains more than 3 different item no, to show each customer number with their respective item number on the same rows, we use NL(Columns) for our Item no. Finally, we call in our Amount with NL(sum). Step 2 Filling in the formulas Since we now know where to pull our table, keys, and fields from, I’ll show you how to do that here. Once you are done creating the functions, you can remove the names on the last row. They are just there to guide you on the name to put in the field when filling in the formulas. filling the formulas for the NL(Rows) Fill in as shown below Filling the formulas for NF fill in as shown below Note: use the same procedure to fill in for all NF, the only difference will be the field. Filling the formulas for NL(Column) Fill in as shown. Note that we lock the row instead, this is because the item ledger entry contains several entry types, and we want each to display separately. This gets tricky at first, but with time, you get to understand how it works. When all these are done, your report should look just as shown below Step 3 Run your Report When you run your report, it should look something like this. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Jet Reports Bank Balance Summary Report A Bank balance report is a financial report that provides information on the cash balance of a customer, a company, or an organization's bank accounts. it typically includes all details on every transaction that has occurred in a bank account over a specified period, such as deposits, withdrawals, and fees. The report shows the total balance of all transactions that occurred during the period. The aim of creating this report is to give a clearer picture of a summary of the cash position of an organization’s bank accounts. This information can be used to make financial decisions about when to invest surplus funds or borrow to meet cash shortfalls. This report is also useful to reconcile any errors in bank transactions by tracking fund’s movement in and out of a bank. Join On Point Academy to view all content Join the academy → Log in → To create this Bank account analysis report, we need information from 2 different tables… Bank account Bank account ledger entries Procedure Step 1 Know where to pull your data from The NL(Rows) will contain our source of data, which will be pulled from the table “Bank Account and Bank Account Ledger Entry“. The NF (Keys) will be a cell reference, which will be referencing cell $D5(Bank Account). Step 2 Creating Report Options I’m applying two filters to my report, “Date filter“ and “Company“ Click on the report options tab in the ribbon, and the pop-out, and fill in as shown. The Company filter is applied in case you want to run the report for a particular company. Note: When Filling in the Date range, you can separate it as “Period Start and Period End“. Each is on a separate line. E.G. Period Start = 1/1/2022 Period End = 12/31/2022. Or use as Date Range as shown here… I want my report to show all transactions from the first one to the selected end date, which speaks to why the formula is (=../02/28/2023) Step 3 Filling in the formulas Since we now know where to pull our table, keys, and fields from, I’ll show you how to do that here. Once you are done creating the functions, you can remove the names on the last row. They are just there to guide you on the name to put in the field when filling in the formulas. filling the formulas for the NL(Rows) Fill in as shown below for the NL for Bank Account, apply the filter for company… referencing to the report Option. Filling the formulas for NF fill in as shown below Note: use the same procedure to fill in for all NF, the only difference will be the field. Go to cell J5, Fill in for NL Amount (Bank Account Ledger Entry) as shown below Apply the date filter and the company filter here… all referencing the report option. Note that when applying the filter on “No.”, we refer to the No. on our report in cell E5. Go to cell K5, Fill in for NL Amount(LCY) (Bank Account Ledger Entry) as shown below Apply the date filter and the company filter here… all referencing the report option. Note that when applying the filter on “No.”, we refer to the No. on our report in cell E5. When you are done filling in the formulas, your report should look as shown below. Step 4 Run your report. When you run your report, it should be like this. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Add More Information to General Ledger Entries Overview The aim for this addon is to provide more insightful information linked to the double entry. The idea is to lessen the number of clicks whilst facilitating the analysis of the data at hand. In this case we wanted to simplify the process by providing the names of the entities. Join On Point Academy to view all content Join the academy → Log in → The Extension The extension in question is named G/L Source Names and the best part of it is that it is completely free of charge, In order to explain the benefits of this we thought of producing a before and after image of the G/L Entries, As you may clearly notice whilst initially we had just the source type and source no, we have now managed to add the Source Name, which provides more insightful information. Before the extension installation After the extension installation What’s next Get in contact with us to assist you in installing the said extension, without incurring extra charges. onpointserv.com/contact-us Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Setting up Key Personalisations Scope The aim of this change is to allow the user to define a set of personalisation which will be utilised by the persons using the same profile. A very important note here is that the personlizations are define at profile level. Join On Point Academy to view all content Join the academy → Log in → Basic Understanding The user may define the profile from: Settings My Settings Change the Role Starting off the Personalizations The process may be started off by: Looking for Profiles (Roles) Clicking on the Profile Click on Customize Pages Important These personlizations will be transferred over to the user who are using the same profile The user may still decide to amend their own personalizations. 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 a fixed asset card and set depreciation.. The fixed asset card in Business Central provides information on the details of a fixed asset and how depreciation will be treated, and how the asset will be maintained. The create a fixed asset card, follow the steps below. Join On Point Academy to view all content Join the academy → Log in → To create a fixed asset card: STEP 1: Click on the search icon at the top right and type in “FIXED ASSET”. Select the related link. STEP 2: A Fixed Asset page opens. On the Fixed Asset page Click on New . STEP 3 : On the Fixed Asset Card, fill in the relevant fields. FIELDS Description : This gives detailed information about the fixed asset. It usually includes the specific name of the fixed asset. FA Class Code : This specifies the fixed asset class the asset belongs to. FA Subclass Code : Under the fixed asset code, there are subcategories that give further information about a fixed asset, this field specifies which subcategory the fixed asset belongs to. Depreciation Method : This will tell the procedure the business will use in calculating depreciation. Depreciation Starting Date : This shows the specific beginning date that depreciation will be calculated for the fixed asset. No. of Depreciation Years : This specifies the number of years of the fixed assets estimated useful lifespan. Depreciation Ending Date : This specifies the date the calculation of depreciation for the fixed asset end. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Creating a Customer Payment Join On Point Academy to view all content Join the academy → Log in → Below is the steps followed upon receiving a payment from a customer in Business Central: Go to Cash Management or please use search field Click on Cash Receipt Journal Click on General Select Payment from the Document Type, Document No. is populated automatically Select Customer from the Account Type Select the Customer’s No. from the Account No. Click the Applied Entries Click on the Invoice you are receiving payment from. Click on the Set Applies-to ID Click OK Click on Post 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 General Ledger budgets To create a new G/L budget follow the steps below. Step 1: Select the search icon, type in G/L Budgets , and then select the related link. 2. Step 2: Select Edit List , enter the required information in the fields and then select Edit Budget . Step 3. Fill in the fields as desired to determine what is displayed. 4. Fill in the amount fields as desired and close budget entries page when done. Join On Point Academy to view all content Join the academy → Log in → 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 and post a Check Computer Checks can be created, printed and posted directly in Business Central. Payment Journal must be used in order to work with Checks. Join On Point Academy to view all content Join the academy → Log in → How to create a Check Open Payment Journal Select “Batch name” with the Bank Account you want to issue the Check from (in our example Citi Disbursement account) Open the list of Batches and select CITI_DISB 3. We need to create a new Journal Line, Account Type and Account No. will specify, who will this Check be issued for (in our example Vendor - Delta Air) a. On the new line we need to select Account Type = Vendor and Account No. = Delta Air b. Then we need to scroll to the right and fill in Description and Amount fields c. Last thing to do on our new Payment Journal Line is to specify that this line is a Computer Check. This is done in a column called “Bank Payment Type”. In this field we need to select the option “Computer Check” The Bank Payment Type field is hidden by default. Sometimes is necessary to add this field using the Personalise option. 4. Now there is a new line with all mandatory fields created. The “Check Printed” indicator is set to FALSE since we haven’t printed the check yet. The system will not allow us to Post this line without it being printed first. How to print a Check When there is a new line of Computer Check type created, it must be printed. Printing is done again from the Payment Journal. Open the Payment Journal Select the line you want to print Select the Print Check action in Check menu 4. The options screen will open and we might have to select the Bank Account from which we want the funds to be taken - Bank Account field, in our case Citi_Disbursement. The system should automatically load the Last Check No. If this is incorrect, you can amend it manually to the next Check No. you’ll be printing 5. Last thing to do is to press the Print option and BC will send this Check to be printed in your printer How to post a Check Now when the line with a Computer Check was printed, we can go ahead and Post the transaction. This is again done in the Payment Journal screen using the Post function 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 Recurring Purchase Lines This document is as a quick reference to create new Recurring Purchase Lines. Recurring Purchase Lines are used when a company frequently orders (for example every month) the same goods. Invoice always contains the same information and we can pre-define this item or service and use in again in the next invoice. Example: we rent an office from a vendor and we pay him the same amount every month Join On Point Academy to view all content Join the academy → Log in → Recurring purchase lines First we will create a new recurring purchase lines: In the Search box, type Recurring Purchase Lines and choose a link In the Home tab click on New Fill in details of your purchase INFO: If the Currency code is different from local currency, you need to fill in Currency code field You have created Recurring Purchase Lines We need to assign created Recurring Purchase Lines to a vendor: Navigate to Vendors (Use Search Box) Choose Vendor and click on Edit in the Manage action group Go to Related, Purchases and click on Recurring Purchase Lines Select a code you want to use for this vendor Now you can use Recurring Purchase Lines while creating a new Purchase Invoice Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Adding Exch. Rates manually in currency table Join On Point Academy to view all content Join the academy → Log in → Go to search and type Currencies and click on link under Go to Pages and Tasks Select the required currency code and click on Process > Exch. Rates Click on New and populate the following fields in the line: Starting Date : date Exchange Rate Amount : rate for the day Relational Exchange Rate Amount : 1 Adjustment Exch. Rate Amount : same as Exchange Rate Amount Relational Adjmt. Exch Rate Amt : 1 Fix Exchange Rate Amount : Relational Currency Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Items, Cross References and Variants Items , among other products, are the basis of your business, the goods or services that you trade in. Each item must be registered as an item card. Item cards hold the information that is required to buy, store, sell, deliver, and account for items. In Business Central, products are called items. Join On Point Academy to view all content Join the academy → Log in → To create a new item card 1. Choose the Search icon, enter Items, and then choose the related link. 2. On the Items page, click on New . 3. Select the template that you want to use for the new item card and click on OK . If only one item template exists, then a new item card opens with some fields filled with information from the template. 4. Proceed to fill or change fields on the item card as necessary. Hover over a field to read a short description. Cross References Cross reference serves as a sub item catalog that is unique to a particular Vendor or Customer . It is used to display the Vendors you normally purchase that item from or Customers you normally sell that items to or the items Bar codes . If you set up a cross reference between the item description that you use for an item and the description that the vendor of that item uses, then the vendor's item description is automatically inserted on purchase documents for the vendor when you fill in the Cross-Reference No. field. The same functionality applies for customer item numbers on sales documents. To set up an item cross reference to an item 1. Choose the Search icon , enter Items , and then choose the related link. 2. Click on the Item Name to open the card. 3. Go to Related , click on item and Select Cross References . 4. On a new line on the Item Cross-Reference Entries page, fill in the fields as necessary. Hover over a field to read a short description. NOTE: Similar process can be followed to the Customer's perspective. To enter an item cross reference on a purchase order 1. Choose the Search icon , enter Purchase Orders , and then choose the related link. 2. Click on New to Create a purchase order for the vendor that you set up an item cross reference. 3. Select the Vendor you created the cross reference for and enter Vendor Invoice No . 4. In the Cross-Reference No. field, select the item cross reference that you have created, then click on OK and enter your quantity in the Quantity field . 5. Click on POST . NOTE: Similar process can be followed on the Sales Order for the Customer’s perspective. Variants Instead of setting up each colour or size of an item as a separate item, you can set up the various colours and sizes as variants of the item. Item variant is a way to indicate that a specific item is available in different colours or sizes , for example. Depending on how you set up your inventory, you can use categories to group chairs versus desks, and then use attributes to group green items versus blue items, for example. You can then supplement this setup by adding variants to each type of chair and desk. By adding variants, you can run reports such as Item Availability by Variant to identify differences between the blue chairs versus the green chairs, for example. To create a new item variant 1. Click on the Search icon and enter Item . 2. Click on the preferred item link . 3. Go to Action , Item and Select Variant . 4. Enter your preferred Variant code . To purchase an Item with Variant using purchase invoice 1. Click on the Search icon and enter Purchase Invoice . 2. Click on New . 3. Select the Item No . 4. Select the required Variant Code . 5. Enter the Quantity and enter the amount in the Direct Unit Cost Excl. VAT. 6. Click on POST. NOTE: Similar process can be followed to sell an item with Variant. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →