Customer Pricing on Invoices
  • JeffG
    Posts:91
    Joined:Sat Aug 31, 2013 6:50 pm
    Location:Sydney
    Customer Pricing on Invoices

    by JeffG » Tue Oct 14, 2014 11:43 am

    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.

    If IsEmpty("SoldFor")
    Return Stock->ListPriceEx
    Endif

    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
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Wed Oct 15, 2014 8:28 am

    You're comparing the string "Soldfor" which is never going to be blank. Try:

    Code: Select all

    IsEmpty(Dictionary("SOLDFOR"))


    instead.[/code]

Who is online

Users browsing this forum: No registered users and 4 guests