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.
Edited by: 913531 on May 2, 2012 7:30 AM
Edited by: 913531 on May 2, 2012 7:33 AM
Edited by: 913531 on May 2, 2012 8:27 AM
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.
The script which will go in the script section of the mapping would be:
If Left(varValues(9),1) = "-" Then
Result = "1000"
Result = "2000"
I've made the assumption that debit is negative, if not simply swap the Result line values.
Thanks for your help,
But still I want some clarification.
My Trail balance Negative values with closed brackets like (567984001) not with minus symbal -567984001.
I hope your script will works if the value is -567984001, but our Trail balance values is (567984001).
Could you please help me out what needs to be done in this scenario.