We have requirement from one source account 32100 (ICP Receivables and Payables Account) to be mapped to Two HFM target accounts the Debit amount (ICP Payables) should be mapped to one account & Credit amont (ICP Receivables) should be mapped to another acccount.
1. IF debit balance will map to HFM account 1000 (Receivable)
2. IF credit balance will map to HFM account 2000 (Payable)
I know it is not possible in one to one mappings (Explicit Maps).
Is it possible through like maps, if yes please suggest me how it is.
My Import file format is as follows.
Account(Local) - Description - Beginning Bal - Period Activity - Ending Bal
321000 Icp rec/pay 1100 100 1200
Please suggest me what needs to be done in this case.
This is possible via a conditional mapping script. Us an In mapping specify 32100 as the source value and #Script as the target. Then in the Expression/Sctipt box write a script that checks the the Vlaue field in the varValues array to see if it is a positive or negative number and set the target member as appropriate.