The (*) sign specifies a like statement in LedgerLink and is converted to a “Like” in FDM.
This is an Automap Name entry and is converted to a “Like” in FDM.
When importing a map file in the LedgerLink format (
) you can also import
account/center descriptions. The description must be placed in the last field within the map file.
0011,CASH.01,Bank America Acct
0011|CASH.01|Bank America Acct
FDM can read and import Hyperion Enterprise account and entity conversion tables. These files
must have the file extension
. Acceptable field delimiters are pipes (
), semicolon (;),
exclamation point (!), and comma (,).
The word “sub” designates that this account should have its sign changed which is indicated by
a check being placed in the Minus column of the account conversion table grid. Other values
that can be used to indicate a sign change are Subtract (-), “True,” and “Yes.”
The word “add” designates that this account should not have its sign changed which is indicated
by no check being placed in the Minus column of the account conversion table grid. Other values
that can be used to indicate a no sign change are Add (+), “False,” and “No.”
Instead of using the Import XLS functionality, you can also import an Excel map using the Maps
form by clicking the Import button and selecting the Excel map. The same formatting rules apply
within the Excel spreadsheet as it would if exporting by using the Import XLS functionality.
Excel map templates with the correct formatting are included in the