Human Resource Module in BC
In Business Central, you have a Human Resource Module. You can keep detailed records of your employees information, such as confidential information, qualifications, absences, and contacts. To start using the Human Resources functionality, you must first set up employees and other basic information. You can then associate various codes to an employee, which allows you to filter information… Continue Reading thatnavguy’s...
Item List page vs Item Lookup page
Item Lookup page In BC, there are two pages that list up your items master: Item List page and Item Lookup page. The Item List page contains a lot of fields (with flowfields) and actions. Item Lookup page only contains minimal fields (without flowfields) and Advanced View action. As the name implies, the Item Lookup page is designed to be used when you are doing a lookup on your… Continue Reading thatnavguy’s Article on...
Posted General Journal
Posted General Journal In NAV or Business Central, when you post the General Journal, it will create the General Ledger Entries (and the its related entries ), then the journal lines will be deleted. There is no way you can go back to check the General Journal input. Not anymore. From BC 2020 Release Wave 2, there is a new feature called Posted General Journal. With this feature, you can… Continue Reading thatnavguy’s...
Service Posting
When you post the Service Order, BC will give you four options to choose: Ship, Invoice, Ship and Invoice, Ship and Consume. You can actually divide those four options into two categories:– Invoice : Ship, Invoice, Ship and Invoice – Consume : Ship and Consume Notice that there is an option to only post invoice, but there is no option to only post consume. That is because once you… Continue Reading thatnavguy’s...
Table Type = Temporary
BC17 introduces great new features to increase your BC performance, such as partial record and temporary table type. Creating a temporary table is the concept of holding the data temporarily in the memory which will reduce the load on the network and server. Previously, you can only do this in variable or page. Starting from BC17, you can create a table with Table Type = Temporary. < pre class=”brush: plain; title: ;…...
Protected Variables in AL
Protected Variables If you want to make a global variable accessible from table to table extension, or from page to page extension, you would normally need to create a procedure to get or set the variables. With protected variables, you no longer need to do that. The protected keyword can be used to make variables accessible between tables and table extensions and between pages and page… Continue Reading thatnavguy’s...
Create View in AL
If you are tired of typing the same filters over and over again, the Save View is a great way to help you avoid having to set the respective filters over and over again. It will save time and increase your productivity. What if you want to do it for all users, here comes the extension development. Let’s say you want to add a View to Sales Order List for filtering Completely Shipped… Continue Reading thatnavguy’s...
Undo Shipment
If you found out that the quantity on your Sales Order has been shipped incorrectly, you can undo the shipment as long as the quantity has not been invoiced yet. You don’t need to undo the whole document, you can undo the quantity per line. To undo the posted quantity:1) Go to the Posted Sales Shipment and find the document.2) Select the line that you want to undo.3) On the lines,… Continue Reading thatnavguy’s Article on...
Deprecated Features and Fields in BC
Business Central is evolving faster than the old NAV. Every 6 months, Microsoft releases a new major version that may or may not break the changes. To keep up with the list of tables and functionalities that are deprecated, Microsoft provides some information about these breaking changes. The following links can provide you with what, why, and how to navigate around these deprecated… Continue Reading thatnavguy’s Article...
How to Create Reservation Entry in AL
If you need to insert reservation, SN, or Lot No to your document, you will need to insert the record to Reservation Entry table. To do that, you can make use of Codeunit 99000830 “Create Reserv. Entry”. Why are we not using Tracking Specification table ? Because BC is using Reservation Entry table to fill in the Tracking Specification table temporarily. That is why we need to fill in… Continue Reading...
Post Sales Shipment or Invoice using AL
If you want to post Sales Shipment or Invoice from your extension, you can use Codeunit 80 Sales-Post. Before you send the Sales Header record to the codeunit, it is necessary for you to tag if you want to post the Shipment or Invoice. You can do this by modifying the fields in the Sales Header record and send the modified Sales Header to the codeunit. First we need to define the… Continue Reading thatnavguy’s Article on...
