Sales Quote Expiry Date
You can specify the Sales Quote expiry date on a field called Quote Valid To Date. If you want BC to calculate the expiry date automatically, you can specify the date formula in the Quote Validity Calculation field on the Sales & Receivables Setup page. If you want to batch delete expired sales quotes, there is a function called Delete Expired Quotes that only accessible from… Continue Reading thatnavguy’s Article on...
Unit Volume vs Cubage
BC has two places to put Volume or Cubage information: the Item Card and Item Units of Measure. Why and which one to use for your business process ? Item Units of Measure – CubageThe cubage field is automatically calculated from the Item Unit of Measure’s width, length and height and is predominantly used in WMS documents (pick, put-away, movement, etc) to calculate if an item can be… Continue Reading...
Change Default Map From Bing to Google Maps
Business Central uses Bing as the default online map. You can change the default from Bing to Google Maps from the Online Map Setup. You will need to add a new Map Parameter Setup Code. Create a new GOOGLE code with below parameters.Maps Service : http://www.google.com/maps/search/?api=1&query={1}+{2}+{4}Directions Service :
Drag and Drop File in BC
Drag and Drop As of now, BC still does not have an official way to do drag and drop for file. However, there is a hidden workaround it. When the Choose File dialog box appears (before the actual Windows file picker), you can actually drag and drop your file onto the “Choose…” button. Make sure you put the file on the button. The file will get imported straight away. Continue Reading thatnavguy’s Article on their blog...
Error on Posting Purchase Invoice – Item Entry Relation does not exist
There are times when BC does not give you a clear error messages. This is one of them. When you try to post purchase invoice for item receipt but not invoiced, the “Item Entry Relation does not exist” error shows up. Upon inspection, the issue is actually coming from the Item Tracking Lines. You will see that Qty. to Invoice is zero there. Update the Qty. to Invoice,… Continue Reading thatnavguy’s Article on...
Batch Schedule Customer Statements
Scheduled Statements One of the requirements that users asked is the ability to batch email customer statement. Since there is no standard way of doing this in NAV or BC, we always ended up developing an extension for them. Well, not anymore. I noticed recently that there is a new “Scheduled Statements” button on the Customer card. How does it work ? Let’s first talk about the setup…. Continue Reading...
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...