Requesting in a Saved Search on Customer Deposit, what is the name of the field to find the amount of the invoice?

AI generated answer (using internal Slack threads):

The field to find the amount of the invoice in a Saved Search on Customer Deposit is not directly available. However, you can get this information by using a join. You can use the

Applying Transaction Fields...

join to get the details of the invoice that the customer deposit was applied to. To get the amount of the invoice, you can use the

Amount

field under the

Applying Transaction Fields...

join. This will give you the total amount of the invoice that the customer deposit was applied to. To get the unapplied amount, you can use the

Amount Remaining

field. This field shows the remaining amount that has not been applied from the customer deposit. To get the applied amount, you can do a grouped search summarizing Deposit Application(s) applied against the Customer Deposit. This can be done via the

Applying

join. You then take

max(Customer Deposit amount)-sum(applying amount)

where the applying amount is the total of all the Deposit Applications. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******