SageForum for UK versions of Sage 50- Help and support.

Hi,
I use an existing sage purch order report: Purchase Oder Not Delivered or Part Delivered, Filename PO_TBDEL.

I want to put a filter on the report so it only runs for 4 suppliers. However, I don’t know how to write the expression? Any help much appreciated?
Don’t know if alternatively I need to do it as a sectional filter. Only display rows if…
Current report Filter: Remaining > 0
I thought it would be something along the lines of:

PURCHASE_ORDER.NAME IS JOE BLOGGS LTD OR PURCHASE_ORDER.NAME IS SUCH AND SUCH LTD

Many Thanks in advance

The name on the account is not a good choice as it can change. You want to use the ACCOUNT_REF field as this does not change.

Here is the sort of expression you would need if you were to apply a filter to the report.

HOWEVER

I would suggest leaving the report as it is. Instead use a Filter on the POP screen to only show you the suppliers you are interested in, then use the standard report. This way if you want to add another supplier you can do it in the filter, if you want to use this "group" of supplier with other reports you can.

Hi Bruce,

Apologies for the late response been busy with general day to day but this would make a massive diff to our control.

Can you please confirm what POP screen is?...sorry for being thick

Many Thanks
Gareth

POP = Purchase Order

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

Hi, any ideas guys?

Many Thanks

You could use a filter in the report to exclude the data you do not want, however it is unclear how you are defining the data you do not want.

In general you want to make things as simple as you can, having a single stock category to filter on rather than multiple stock codes makes for a much easier expression for you to get your head round or for someone later on to get their head round.

Whilst doing long complicated expressions work, I suggest you should try and simplify things as much as you can.