Hello,
I am attempting to put a search together that is to be used to import small balance write-off's. I need to set the account the debit posts to and the account the credit posts to, but due to the import template can only have 1 account column listed and the nature of the journal entries require a debit and credit on the same transaction. I do not want to do separate imports as that would be cumbersome for my cash app team.
I am running a transaction search and pulling in Amount and Amount Remaining, but cannot determine the logic so the "else" appears.
Header example:
Customer Account Amount ExternalID
CUS123 DebitAcct 0.01 WO123
CUS123 CreditAcct 0.01 WO123
Can anyone help with this?
Thank you,
Jocelyn