I need to create a saved search list of Invoice line Items to determine Entitlement. We sometime have to issue a Credit Memo after an invoice is created because a Customer may cancel. I need to exclude the any reference to Invoices that were considered Paid in Full by a Credit Memo.
I am trying to accomplish when an Invoice, Applying Transaction Type is Credit Memo, do not return any row for the Invoice
I have watched Guide to Applied Transaction& Applying Transaction fields on Saved Search Video & I have reviewed SuiteAnswer 92641, 95483 (I reported an error in this SuiteAnswer at Select Credit Memo: Fully Applied, should be "None of" ) & 93503 but that formula should be Formula (Numeric) and not Text. No results from this formula.
I started without considering Credit Memos which also returned invoices that were cancelled by creating a Credit Memo against it.
- Obsolete Criteria as of 6/27/2023, see the next set of screenshots. I added criteria Formula (Text) {applyingtransaction} does not contain 'Credit Memo'
The results are below but still include a Deferred Revenue journal entry for Document # 2042240, which I need to exclude as well, without impacting the Invoice # 2042499..... - Obsolete Results as of 6/27/2023, see the next set of screenshots.
6/27/2023
Updated screenshots to include a change in criteria to for all necessary Invoice Lines. Was missing one line, previously
Results: I need to include the lines marked with Green and need to exclude the line marked with Red X
Can anyone suggest how I might create a list of Invoice Lines but exclude the any reference to Invoices that were considered Paid in Full by a Credit Memo?
Thanks.