Filter on purchase order report (so only pulls through certain suppliers)
Posted: 12 Nov 2018, 10:24
HI Bruce,
Thanks for POP silly question by me ha!.
Makes sense what you said using ACC code as that wont change.
Managed to get it to work with the below expression :
Remaining > 0 AND (PURCHASE_ORDER.ACCOUNT_REF = "POLSPAIN" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTFR" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTIT" OR PURCHASE_ORDER.ACCOUNT_REF = PURCHASE_ORDER.ACCOUNT_REF = "POLYNT")
However, is there a way I can get it to only show POLYNT acc ref outstanding purchase orders for purchase orders that only contain certain prods?
Certain POLYNT prods SKU numbers: 1100
1103
1104
1105
1110
1120
3070
3100
1104
1111
Ive tried the below and it doesnt work:
Remaining > 0 AND ((PURCHASE_ORDER.ACCOUNT_REF = "POLSPAIN" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTFR" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTIT" OR PURCHASE_ORDER.ACCOUNT_REF) OR (PURCHASE_ORDER.ACCOUNT_REF = "POLYNT" AND POP_ITEM.STOCK_CODE = “1100” OR “1103” OR “1104” OR “1105” OR “1110” OR “1120” OR “3070” OR “3100” OR “1104” OR “1111”))
Reading the sage help forum now but struggling a bit trying to reverse engineer expressions from other reports to get the method.
Any help much appreciated
Thanks for POP silly question by me ha!.
Makes sense what you said using ACC code as that wont change.
Managed to get it to work with the below expression :
Remaining > 0 AND (PURCHASE_ORDER.ACCOUNT_REF = "POLSPAIN" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTFR" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTIT" OR PURCHASE_ORDER.ACCOUNT_REF = PURCHASE_ORDER.ACCOUNT_REF = "POLYNT")
However, is there a way I can get it to only show POLYNT acc ref outstanding purchase orders for purchase orders that only contain certain prods?
Certain POLYNT prods SKU numbers: 1100
1103
1104
1105
1110
1120
3070
3100
1104
1111
Ive tried the below and it doesnt work:
Remaining > 0 AND ((PURCHASE_ORDER.ACCOUNT_REF = "POLSPAIN" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTFR" OR PURCHASE_ORDER.ACCOUNT_REF = "POLYNTIT" OR PURCHASE_ORDER.ACCOUNT_REF) OR (PURCHASE_ORDER.ACCOUNT_REF = "POLYNT" AND POP_ITEM.STOCK_CODE = “1100” OR “1103” OR “1104” OR “1105” OR “1110” OR “1120” OR “3070” OR “3100” OR “1104” OR “1111”))
Reading the sage help forum now but struggling a bit trying to reverse engineer expressions from other reports to get the method.
Any help much appreciated