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 will return a list of items calculating the status of serial number tracked items based on the posting status and the sales transaction type.
/*
Created by Ian Grieve of azurecurve |...
Continue Reading azurecurve’s Article on their blog
SQL Scripts for Microsoft Dynamics GP: Status of Items Based on Serial Number
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 will return a list of items calculating the status of serial number tracked items based on the posting status and the sales transaction type.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP2023.02.01New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Remove Modification Limits For Triggering Flows- Dyn365GP2023.02.01New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Support Dynamic Environment And Company In Power Platform Connector
- Dyn365GP2023.01.31New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: New Approval Workflow Experience With Power Automate Templates
- Dyn365GP2023.01.31New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Get Started With More Sample Power Automate Templates And Power Apps
