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
- Dyn365GP26 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
- Dyn365GP25 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
- Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
- Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company