This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script returns a list of items with serial numbers which were purchased and the linked sales transaction.
CREATE VIEW uv_AZRCRV_AllocatedSerialNumbers AS
/*
Created by Ian Grieve of azurecurve...
Continue Reading Ian Grieve’s Article on their blog
SQL Scripts for Microsoft Dynamics GP: Purchased Items With Serial Numbers and Linked Sales Transactions
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. …
Blog Syndicated with Ian Grieve’s Permission