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
/*
Created...
Continue Reading Ian Grieve’s Article on their blog
SQL View on Sales Order Processing Backorder Transactions
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 invo…
Blog Syndicated with Ian Grieve’s Permission