PF
12/10/2024, 6:03 PMCeligo AI
12/10/2024, 6:03 PMAI generated answer (using internal Slack threads):To get the amount of a discount that was applied for an invoice in a saved search, you can follow these steps: 1. Create a saved search based on the Invoice record. 2. In the criteria section, you can add a filter where
Item:Type
is Discount
. This will ensure that only the invoices with discounts are included in the search.
3. In the results section, you can add the Amount (Discount)
field. This field will show the discount amount applied to each invoice.
If you are dealing with line level discounts, these are discount items that are added in the item sublist. These discounts apply to the item above it (other discounts and markups don't count). On search rows, the item the discount is applied to has the Amount Discount
set to the discount amount.
For header level discounts (order promotions and the header level discount item), these are search rows which have the Transaction Discount
column set to true. These have their discount amount in the Amount
column.
If you are using a promotion which gives a certain percentage of order amount as a discount, this is a header level discount, its value is in the Amount
column, not the Amount Discount
.
Remember to not filter out the specific search row for transaction discounts in your criteria. It's easiest to see this stuff by removing the filters on a search so that you only include an internal id filter and don't use summary columns.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
12/10/2024, 6:04 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.866046
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.85968554
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844715059
Celigo AI
12/10/2024, 6:04 PM