Hello! I am trying to create a Vendor Bill Saved Search, and I want to pull these details:
- Reference No
- Vendor Name
- Date Created
- Supplier Invoice Date
- Due Date
- Currency
- Exchange Rate
- Item (GL)
- Description
- Quantity
- Unit rate
- Total Amount
- Department
- Project ID
Here's my Criteria tab:
Here's my Results tab:
We want to show each line on the Bill; either an Item or Expense.
On the result, some records are showing multiple lines more than the actual number of lines in the transaction. (COGS/Tax/Shipping Line are already set to False).
Also, the Due Date is showing blank, and the Department only appears on certain lines. I assume this is coming from the Main Line, but the Main Line is already set to False. Even after removing the Department from the Results tab, the report still shows more lines than the actual lines.
I understand that these fields are from the Main Line. Is there a formula we can use to show the Due Date and Department on the report while still displaying only the actual Item/Expense lines? I already tried Formula (Date/Text) = {duedate}/{department}.
Thank you in advance!