Hi, I have an odd one. On my invoices I was printing both ListPriceEx and the SoldFor fields - so that customers can see what the price difference is.
However, I recently removed the ListPriceEx field, leaving only the SoldFor field.
For some reason, the soldfor price only appears when there is a calculated value.
So I need to pick up the default list price if the soldfor field is empty.
I tried this as formula, but to no avail.
The Test Function didn't show any syntax errors, but now all I get is *** on the first line in the SoldFor column.
Any suggestions would be greatly appreciated. Thanks