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

Appologies if this has been addressed before

When i print a purchase order it inserts our product code by default however our product codes are different to our suppliers part numbers.

How can i change this to insert the suppliers part number instead of our stock code?

Please help and thanks

Open the layout you are using in the report designer.

Where the product Code is remove the field STOCK.STOCK_CODE
Insert the Fields STOCK.SUPPLIER_PART_NUMBER

The only problem for this is that where there is no SUPPLIER_PART_NUMBER set you will get blanks.

You can get around this a lots of ways.

You could put both fields on there and use conditional formatting to hide the SUPPLIER_PART_NUMBER if it is blank and to hide the STOCK_CODE if SUPPLIER_PART_NUMBER is not blank so only one of them will show.

You could use a conditional expression to select the field to show depending on the value of SUPPLIER_PART_NUMBER.

Thanks Bruce Sorted