This discussion is archived
6 Replies Latest reply: May 8, 2012 2:00 AM by SH RSS

FDM Mappings (One source account to Many Target account)

916534 Newbie
Currently Being Moderated
Hi All,

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.

Thanks,

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points