Hello everyone, I'm writing to request your assistance with the following:I have a saved search that contains sales invoices and customer payments. The options are as shown in the image:Option 1: Sales invoices and their amounts are displayed on the same line. I need to include some customer payment information on the same line, such as the payment method and check number. When this information is included, the search should not display the payment data; all the payment information should remain on the same line as the invoice.Option 2: I could work with customer payments, but I need to include invoice data such as the document number, the invoice item, and the amount. (As with the previous option, the invoice results should not be displayed in the report; everything should remain associated with the customer payment line.)
My search criteria are structured as follows:
I would like to know if I can retrieve these fields from the results to link them, or if I can use an advanced formula to achieve this.Thank you in advance for your support.Best regards