I’ve written this view for a number of different clients over the years, so am posting it here for future reference. It returns only open backorders which have yet top be transferred to order or invoice; it includes PO information so users can easily see if a PO has been raised and if any of it has been receipted.
The SQL below includes the
CREATE VIEW uv_AZRCRV_SOPOpenBackorders AS /*
Continue Reading Ian Grieve’s Article on their blog
Blog Syndicated with Ian Grieve’s Permission
More About This Author
- #Dyn365GP2021.01.19Implementing Post Master Enterprise: Who are Envisage Software?
- #Dyn365GP2021.01.18Implementing Post Master Enterprise: Series Index
- #Dyn365GP2021.01.15SQL View for to Extract Accruals from Microsoft Dynamics GP Payables Management Module
- #Dyn365GP2021.01.14Identify and Fix Corrupt SOP Transactions in Microsoft Dynamics GP