Journal Entries > Related Records tab > Payments subtab > view applied to and applying transaction to this transaction
Published on
May 31, 2023 at 8:42:01 AM PDT May 31, 2023 at 8:42:01 AM PDTst, May 31, 2023 at 8:42:01 AM PDT
Scenario
- Journal Entry#1 (JE1) has Accounts Receivable debited while Journal Entry#2 (JE2) has the same Accounts Receivable account credited for the same amount
- These journals were applied to each other via Customer Payment
- Related Records tab > Paymentssub tab of:
- JE1showsJE2as the payment applied to it
- JE2shows no value
- User needs to viewJE1in theJE2transaction form >Related Records tab > Paymentssub tab
Solution
- Navigate toLists > Search > Saved Searches > New > Transaction
- Set the following values:
- Public =True
- Available as Sublist =True
- In theCriteriatab:
- SetUse Expressions =True
- Add the following filters in theStandardsub tab:
- Type =Journal
- (Applied To Transactions : Internal ID (Number) =is not empty or
- Applying Transactions : Internal ID (Number)=is not empty)
- In theResults tab > Columnssub tab
- SetSummary Type =Groupfor the following fields:
- Date
- Number
- Applied To Transaction
- Applying Transaction
- On theAvailableFilterssubtab, add at least one available filter to the search, and ensure that the first filter listed is aList/Record type. Otherwise, the saved search is not available to assign as a sublist.
- Renamethe search
- Example: Journals Applied
- ClickSave
- Set the following values:
- Navigate toCustomization > Forms > Sublists > Transactiontab
- Set:
- Search =Journals Applied
- Label =Journals Applied
- Tab =Related Records
- Journal =True
- ClickSave
- Set: