Purchase Order Layout Problem

[largada]

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

[brucedenney]

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.

[largada]

Thanks Bruce Sorted