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

Hi there,

I'm creating a price list report & have a nested if statement that makes another variable disappear and I am unable to figure out why?

PRICE.STOCK_CODE In ("PRODUCT") and CURRENCY In (2) ? LISTPRICE1*1.3333

When the code is PRICE.STOCK_CODE In ("PRODUCT") ? LISTPRICE1*1.3333 everything works perfectly, however when I add and CURRENCY In (2) the stock.description field disappears and I don't know why? Note: STOCK.Description disappears on every currency & the formula actually works, ie. Listprice1 is only multiplied by 1.3333 when currency = 2, just the stock.description field disappears?

Also, is the "IN" ("product") the best thing to use? is IN the same as IS?

Fixed. I added Price_List. before Currency and everything is back to working normally. I only had currency there because that's what came up when I selected Currency from the dialog box in the expression editor?

I suppose all I need an answer for is this: Also, is the "IN" ("product") the best thing to use? is IN the same as IS?

Thanks Bruce, you're a champ!

I'm a champ and I didn't even do anything!