Follow these instructions to install an AL extension in Visual Studio Code. 1. Open Visual Studio Figure 1 – Open Visual Studio 2. Navigate to View-> Extensions Figure 2 – Navigate to Extensions through the View menu bar 3. Type AL in the search bar and install AL Language Figure 3… Continue reading Installing the AL Language Extension in Visual Studio Code
Category: How To General
Creating a Ranking Report in Jet Reports
Those of us who use Jet Reports are painfully aware that Jet does not have a ranking feature for replicated lists. However, there is a workaround: you can create an automatically sorted Jet report with nested Jet functions and use Excel’s rank function to give you a ranked Jet report. This blog will walk through… Continue reading Creating a Ranking Report in Jet Reports
Jet Reports Made Easy – Creating an Income Statement
This video provides a quick overview on creating an income statement with Jet Professional or Jet Express. While a Jet report may look complex and difficult to create, the reality is far from that. Setting up a Jet Report is an easy and intuitive process. This video walks you through the steps of using Jet to… Continue reading Jet Reports Made Easy – Creating an Income Statement
Jet Reports Web Portal Setup
The new Jet Reports Web Portal brings collaboration and sharing to a new level. Features include version control, central permissions, sharing settings as well as the ability to use Office 365 to use your reports anywhere. Jet Reports: Server Setup To publish reports to the Jet Web Portal you first need to install the Services… Continue reading Jet Reports Web Portal Setup
How to Decipher an EDI Functional Acknowledgement
Reading a Functional Acknowledgement When sending an EDI document such as an 810 – a sales invoice –the Trade Partner will generally send back a 997 Functional Acknowledgment (FA) in acknowledgement of receipt. The Trade Partner will tell you whether the document was Accepted, Accepted with Errors, or Rejected. Some Trade Partners will also give… Continue reading How to Decipher an EDI Functional Acknowledgement
Microsoft Azure and Multifactor Authentication
Multifactor Authentication or MFA for those in know, is a method of logging into your various devices. You may be familiar with MFA from using physical fobs to generate an authentication number. Typically, you log in with a user name and a single form of authentication being the password. As cloud technology progresses, security needs… Continue reading Microsoft Azure and Multifactor Authentication
Attention Lanham E-Ship Clients: What the August 1, 2016 UPS Changes mean to You
As of August 1, 2016 Lanham E-Ship customers will need to be on E-Ship Version SE0.60.03 or higher to commission UPSLink accounts. This will impact your ability to add new UPS accounts (shipping locations) as well as new NAV servers. This will not impact your ability to continue shipping with your existing Lanham software; this… Continue reading Attention Lanham E-Ship Clients: What the August 1, 2016 UPS Changes mean to You
Reducing the Quantity of Inventory Sub-Ledger Entries
We often hear the comment that Dynamics NAV posts too many Inventory Sub-Ledger entries to the General Ledger. There is a way in Dynamics NAV to reduce the number of General Ledger entries when running the batch report “Post Inventory Cost to G/L”. When running the batch report, select “Per Posting Group” and the system… Continue reading Reducing the Quantity of Inventory Sub-Ledger Entries
How to Set Optional Services in Lanham E-Ship
Options like Saturday Delivery and Signature Required are additional options that can be applied to a main Shipping Agent Service in Lanham’s E-Ship. However, the Shipping Agent Options are specific to the carrier, so FedEx options are different than those for UPS. This blog gives an example of how to set optional services for FedEx.… Continue reading How to Set Optional Services in Lanham E-Ship
How to Use “Item Type” for Non-Stock Items
One of the least known features in Microsoft Dynamics NAV is the “Type” field on the item card. This is a new field that provides some functionality that did not previously exist in NAV. Most of us aren’t aware of this field because you don’t see it on the item card page. You can identify… Continue reading How to Use “Item Type” for Non-Stock Items