Hi There
- I am trying to create a saved search to calculate the number of days between when a bill is entered and when it is paid.
For this, I need to be able to reference the payment date field.
The payment information for a vendor bill is stored in a sublist. I can't see any option for this in the related records (the records that can be joined) when doing a saved search
How do I reference these fields?
The vendor bill:
I have tried adding fields for all possibly related transactions
e,g,
though these are coming up with blanks in the results, Is there an easier way to see what the joins should be to bring up sublist related fields?
2 I have tried to create a custom sublist for an employee record. The sublist is supposed to show which projects the employee has been allocated as a resource to. However, this is showing all resources for a project. How can I filter the sublist so that only where the employee is allocated as a resource shows up?
Thanks