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

Hi Bruce,

Sorry for the unclear question - I wasn't trying to add a field, more so what you suggested below, just adding the AWB at print time.

Currently we have product codes set up for freight and we do not use the Carriage section of the sales order. Your suggestion makes sense, I will look ...

Hi Bruce,

Is it possible to have a dialog box(like shown below) where I could custom input variables and they're shown in the report?

If this is not possible, do you have an alternate solution? otherwise I will be required to use a message line on each sales order to show that information.

Poorly ...

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 ...

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 ...

Thanks for the suggestions, I'll try these and get back to you

Hi there,

I have edited a Purchase Order report to show STOCK.SUPPLIER_PART_NUMBER and it works perfect for 99% of my colleagues, however, one is having issues.

He keeps receiving this error message(apologies for the small picture);
'The report could not be generated'
'The field 'STOCK.SUPPLIER ...