We pay the child subsidiaries' customer refunds via the parent subsidiaries' bank account. In the customer refund, we select a dummy or clearing bank account and manually create an intercompany JE to move it from the clearing account of the child subsidiary to the actual bank account of the parent subsidiary. We want to kinda automate it. Theoretically, this can be scripted but I'm wondering if that can be avoided. I've tried using Intercompany Allocation Schedule and it works except that it aggregates the refunded amount (lump sum) which is not ideal for bank reconciliation. I've also tried creating a saved search patterned to the format of advanced intercompany JE, so that users can just export and then import it back to NS. I was able to generate the lines for the source subsidiary in the saved search. Cr. Intercompany Clearing and Dr. Dummy or Bank Clearing. I'm missing the lines for the other subsidiary which is Dr. Intercompany Clearing and Cr. Dummy or Bank Clearing. I can theoretically create 2 saved searches and let the users combine them manually outside of NS to create the advanced ICJE template but it may be too much work for them. Is there any way to achieve it without scripting?