I have a small set of data that I want to assign accounts and transaction codes to, based on whether the account is <>0.
If the amount is >0, then I want to assign transaction code 05 to the ST account and 06 to the LT account
Data
Account mapping table
Desired output
Hi @tiverson, see attached example workflow.
@binuacs , your solution worked, I just needed to add a formula to switch signs with the LT account amount