SQL View Showing Serial Number Allocated to SOP from POP in Microsoft Dynamics GP

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

SQL View Showing Serial Number Allocated to SOP from POP in Microsoft Dynamics GP

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 fol‎…

Blog Syndicated with Ian Grieve’s Permission