About Alex Henderson

This author has not yet filled in any details.
So far Alex Henderson has created 51 blog entries.

Top 5 ERP Failures

For many businesses, the idea of implementing an enterprise resource planning solution — or ERP — is very interesting. Unifying all the various processes from all the different business units — including finance, HR, support and procurement — into one streamlined system holds a lot of promise. It can significantly speed up processes, facilitate data [...]

2019-05-22T05:26:11-08:00April 30th, 2019|General ERP articles|Comments Off on Top 5 ERP Failures

Business Central Integration With Office 365

With the October 2018 release of Dynamics 365 Business Central, the business world gained a powerful new tool. Dynamics 365 Business Central comprises a suite of tools intended to improve the way your business runs. Encompassing the entire spectrum of business processes — including marketing, sales, service, operations and finance — it allows users to [...]

2019-05-16T06:28:03-08:00January 15th, 2019|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Business Central Integration With Office 365

Business Central Deployment

When choosing an ERP solution, businesses must consider the various features and integration possibilities offered. It’s equally critical to consider if the system's deployment will correspond with the organization’s unique structure, as well as its security and financial demands. In recent years, ERP producers have incorporated ongoing technological advancements into their products to offer a [...]

2019-01-16T05:25:56-08:00January 15th, 2019|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Business Central Deployment

Microsoft Dynamics NAV (Navision) – A History

Back in 1984, 3 college students in Denmark created a simple accounting system called PC Plus.  Amazingly, now more than 30 years later, millions of people log into the solution and its owned by the worlds largest software company, Microsoft.  Today it's known as Microsoft Dynamics NAV and more recently, a cloud version is Dynamics [...]

2019-01-16T11:13:42-08:00May 1st, 2017|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Microsoft Dynamics NAV (Navision) – A History

Microsoft Dynamics NAV 2016

General Journals: Is the Paste Rows Option Missing? In NAV 2013 and later versions, functionality was available to copy and paste rows from journal pages (i.e. General Journals, Sales Journals, etc.)  to Excel, and then back from Excel to the journal page.   The functionality made uploading journal entries from Excel into journals very easy for [...]

2019-01-16T11:15:09-08:00August 9th, 2016|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Microsoft Dynamics NAV 2016

Dynamics Nav – Jet Reports and NAV Security

Microsoft Dynamics Nav (Navision) Jet Reports and NAV Security Options for setting up NAV security to for Jet Reports for NAV 2009 R2 and earlier Microsoft NAV 2009 R2. How to setup NAV permissions to enable Jet Report Data Source connectivity for databases with multiple companies for NAV 2009 R2 and earlier. With NAV 2009 [...]

2019-01-16T11:13:42-08:00May 17th, 2016|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Dynamics Nav – Jet Reports and NAV Security

Microsoft Dynamics Nav (Navision) – Lanham E-ship

Microsoft Dynamics Nav (Navision) How to manage package dimensions for Lanham E-ship Microsoft NAV 2015, 2013 R2, NAV 2009. Lanham E-Ship SEO.60 and above. This article discusses Lanham E-ship package dimension processing and related “Tips”.  This following topics will be outlined: The formula for calculating dimensional package weight. Lanham Rate Shopping options as per package [...]

2019-01-16T11:13:42-08:00April 28th, 2016|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Microsoft Dynamics Nav (Navision) – Lanham E-ship

Dynamics NAV 2016: Extensions and SQL Azure

Dynamics NAV 2016 is the first version of NAV that allows running the database on SQL Azure, a fully managed and high available SQL as a Service. It is also the first version of NAV that has NAV Extensions, a new way to publish add-ons to NAV. There are very good articles that provide information [...]

2019-01-16T11:15:09-08:00February 16th, 2016|Dynamics 365 Business Central (Dynamics NAV)|Comments Off on Dynamics NAV 2016: Extensions and SQL Azure

SAP Business One Training Tips #6

Finally, an Inventory Aging report by warehouse SELECT T0.ITEMCODE , T0.ONHAND as 'Total Qty', CASE WHEN Datediff(day, T1.LASTPURDAT,GETDATE())= 45 AND DateDiff(day, T1.LASTPURDAT,GETDATE()) < 90 THEN T0.ONHAND END '45 to 90 Days(Qty)' , CASE WHEN DateDiff(day, T1.LASTPURDAT,GETDATE()) >= 45 AND DateDiff(day, T1.LASTPURDAT,GETDATE()) < 90 THEN T0.ONHAND*T0.AVGPRICE END '45 to 90 Days(Value)', CASE WHEN Datediff(day, T1.LASTPURDAT,GETDATE()) >= [...]

2019-01-16T11:22:42-08:00September 14th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #6

SAP Business One Training Tips #5

SAP Business One - Planned Production Order Shortages Query This query uses only standard fields, and lists for any production order in Planned status, component shortages. The "AND T0.[Status] = 'P'" can be changed to " AND T0.[Status] = 'R'" to show release production order shortages, or " AND T0.[Status] <> 'L'" to show Planned [...]

2019-01-16T11:22:42-08:00April 2nd, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #5

SAP Business One Training Tips #4

Negative Gross Profit and Sales Report from A/R Credit Memos SELECT T0.[DocDate], T4.[GroupName], T0.[CardCode], T0.[CardName], ((T1.[Quantity]* -100)/100) AS 'Qty Returned', (T1.[Price]*((T1.[Quantity]* -100)/100)) AS 'Net Sales', (T1.[PriceBefDi]*((T1.[Quantity]* -100)/100)) AS 'Gross Sales', T2.[SlpName] FROM ORIN T0 INNER JOIN RIN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OSLP T2 ON T1.SlpCode = T2.SlpCode INNER JOIN OCRD T3 ON [...]

2019-01-16T11:22:42-08:00March 16th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #4

SAP Business One Training Tips #3

Shipping Performance Report - Monitor your on time shipping performance Great report to measure your on-time delivery performance. SELECT DISTINCT DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) AS 'Lapsed Days', CASE WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) >= 5 THEN 'Late by 5 Days or More' WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) BETWEEN 1 AND 4 THEN 'Late by 1 to 4 Days' [...]

2019-01-16T11:22:42-08:00February 26th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #3

SAP Business One Training Tips #2

Projected MRP Procurement Costs for specified MRP Scenario This report will prompt the user for the desired MRP Scenario and Price List. The report lists all the buy items in the respective MRP scenario, displaying the cost, multiplied by requested quantity. This is an ideal report to use when doing What-If MRP Scenario's in SAP [...]

2019-01-16T11:22:42-08:00February 5th, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #2

SAP Business One Training Tips #1

Linking Customer/Vendor to a specific P&L account   A customer recently approached one of our Implementation Consultants and asked, “How can I track revenue/expenses to a specific P&L GL account by customer/vendor?” While the Accounting Tab of the Business Partner Master allows the user to define Payables and Receivables accounts for each customer/vendor accordingly, it [...]

2019-01-16T11:22:42-08:00January 22nd, 2015|SAP Business One|Comments Off on SAP Business One Training Tips #1

SAP Business One 9.0 Drag & Relate

SAP Business One 9.0 has many functions to make daily use easier and more convenient, especially in the area of reporting.  Out of the box, SAP Business One comes with multiple System and Crystal Reports to deliver standard report capabilities that all or most customers will need.  In addition to these standard reports, SAP Business [...]

2019-01-16T11:22:42-08:00May 5th, 2014|SAP Business One|Comments Off on SAP Business One 9.0 Drag & Relate

SAP Business One 9.0 Authorizations & Form Settings

SAP Business One 9.0 provides Authorizations and Form Settings to ensure that users see only the data they need and affect changes only in areas where management desires. Authorizations allow a user to view, create and update documents they’ve been assigned, according to a company’s system definitions.  These definitions can be applied to a specific [...]

2019-05-14T09:06:22-08:00April 28th, 2014|SAP Business One|Comments Off on SAP Business One 9.0 Authorizations & Form Settings
>