A recent project required a report of serial numbers received into Microsoft Dynamics GP on purchase orders and to which sales transaction they’d been allocated. I had a hunt around in my scripts folder and found an old script I’d written which only required some small changes to add the required fields.
The script uses INNER JOIN
clauses as only assigned serial numbers were wanted, but this…
Continue Reading Ian Grieve’s Article on their blog
https://www.azurecurve.co.uk/2021/02/sql-view-showing-serial-number-allocated-to-sop-from-pop-in-microsoft-dynamics-gp/
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP7 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Improvement of Czech Localization Reports
- Dyn365GP7 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Process Czech Bank Statements, Payment Orders More Productively
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use a New Role Center for Collection Management
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Ensure Accurate Inventory Valuation by Controlling Cost Adjustment