6 Replies Latest reply: May 8, 2012 4:00 AM by SH RSS

    FDM Mappings (One source account to Many Target account)

    916534
      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