We have a case where a user wants to add the Requested By on a Sales Order and have that contact shown on the Advanced PDF/HTML Template.
I have been working on this for a while now and everything that I have set up should show the contact from the customer, however it is not filtering correctly, in fact, it is not showing any 'contacts' at all but when adding a NEW contact via the custom field the new contact does show in the custom field and on the customer.
What I have done so far:
- Created custom transaction Body Field called Requested by Contact
- Type = List/Record
- List/Record = Contact (this is the first issue, as this list is actually 'employee's' and there isn't a Contacts list for customer contacts
- I added Filter Using Customer ID (customer isn't available), and Compare to Field Customer ID (again customer isn't available).
- This should have worked, it resulted in no contacts in the dropdown field
I tested the filtering using a standard Sales Order and got the same results.
I removed the filtering, and all customer contacts were available to choose from. I can choose the customer, and the result is the customer name:contact name. I can edit the Advanced PDF to trim to only after the :, however that is not best use of real estate.
I started looking for a contacts (customer contacts) list, but there isn't one in the system to choose from under List/Record in the primary section of the field.
I will probably spend another couple of hours creating a contacts list to see if I can use that on the custom field and then filter by name, but if anyone has any other suggestions, it would be greatly appreciated and save me a lot of time trial and error.
Why does something so simple like pulling a customer name require so much work!
Thank you for your assistance in advance.