I needed to check how many serial numbers were assigned to sales transactions and the cumulative length of them. I’m not aware of any function in Microsoft Dynamics GP which would give me this information, so I wrote the below SQL statement to return both values along with the transaction type and document number.
It selects from the Sales Serial/Lot Work and History (SOP10201) table which,…
Continue Reading azurecurve’s Article on their blog
Get Serial Number Count and Length in Microsoft Dynamics GP
I needed to check how many serial numbers were assigned to sales transactions and the cumulative length of them. I’m not aware of any function in Microsoft Dynamics GP which would give me this information, so I wrote the below SQL statement to return both values along with the transaction type and document number.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP2023.03.23New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Set Default Dimensions on Locations, Inventory Documents and Journals
Dyn365GP2023.03.22New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Easier to Create Opening Balances for Item Tracked Inventory
Dyn365GP2023.03.22New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Demo Tool and Data for Warehouse and Inventory Scenarios
Dyn365GP2023.03.21New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Catalog Items Use Standard Number Series, Can Include in Blanket Sales Orders
