7 Replies Latest reply: Dec 4, 2014 8:15 AM by Dermot mcgoldrick RSS

    Brick Wall - Sales Order Managment

    Dermot mcgoldrick

      Lets say I am loading three tables, open SO Lines, Open Purchase Orders and open Internal Purchase Orders (See attached QV).  I would like to be able to tag those open Sales Order lines that haven't had stock allocated but have an open PO for the item, and then also tag those SO line that haven't had stock allocated but have no open PO or IPO etc.

       

      I can do this by filtering within the report but would rather work out how to do this during load if possible?  Can anyone give me some direction here?  TIA!!!