Hi All,

I need to exclude a specific “market_code” in my demand planning server setup. It is currently pulling in intercompany movements to warehouses and is multiplying the sales history. I need to understand what SQL statement I can use to exclude and ‘markey_code’ “inter” sales. 

I have tried to figure this out, and everytime I run the data it fails. Current SQL is below and we need to add something to exclude these sales

SQL: Select contract, part_no, issue_date, issue_qty from IFSAPP.comb_ext_inv_part_issue_pub