Profile cover photo
Profile photo
Harry Lee
75 followers -
Life's what happens while you're making other plans...
Life's what happens while you're making other plans...

75 followers
About
Posts

Post has attachment
Lot Availability Query
Recently I have been working with a client who has implemented Inventory Bill of Materials to Assemble materials having lot tracked components. It is important to fulfill orders with a single lot. So, quickly viewing component lot availability was a must. W...
Add a comment...

Post has attachment
CASE Statement for BOMCAT_I in Dynamics GP Manufacturing BOM Revision Table
I have amassed a number of useful CASE statements, which can be incorporated into SQL queries run against Dynamics GP. When Querying the BOMCAT_I Field in Dynamics GP Manufacturing BOM Revision Table [BM010415].[BOMCAT_I] table: use the following case state...
Add a comment...

Post has attachment
I climbed 1,000 floors with my #Fitbit and earned the Skydiver badge.
Photo
Add a comment...

Post has attachment
I covered 736 miles with my #Fitbit and earned the Italy badge.
Photo
Add a comment...

Post has attachment
Urgent, Late Breaking News... Integration Manager and Macros Failing after several hundred records? Microsoft's New Navigation the Culprit!
I am working hard to maintain my sense of humor about this post! Many months ago, July 2015, according to my One Note notes, I worked with a client who was having difficulty running an Integration using Integration Manager. The problem was a failure after s...
Add a comment...

Post has attachment
I took 25,000 steps and earned the Classics badge! #Fitbit
Photo
Add a comment...

Post has attachment
Add a comment...

Post has attachment
I took 20,000 steps and earned the High Tops badge! #Fitbit
Photo
Add a comment...

Post has attachment
Purchase Order Ship to Address Assignment or Why won't Purchase Order Ship to Address Auto Fill?
Purchase Order addressing requires several data points to auto assign the Ship to Address to line items on Purchase Orders. First you need to select Standard, or Drop Ship – a selection here is of course mandatory.  The shipping method selected works in com...
Add a comment...

Post has attachment
Sales Reporting for Vendor Items
From time-to-time, key vendors request sales figures on items they supply. Below is a SQL Query, which creates a view that can be used as a foundation for a SmartList or SSRS Report to support this effort. USE [COMPANYID] GO SET ANSI_NULLS ON GO SET QUOTED_...
Add a comment...
Wait while more posts are being loaded