I have a few questions around import formats as I have recently seen some new approached that I have not seen before:
Firstly are Import Formats auditable? Can the changes etc be tracked?
Secondly the formats I see are concatenating GL accounts and a few things from the GL to create a new "unique" account that is then mapped in FDM.
in the GL
810000 - Revenue $10,000
BL - Blue
T1 - Dakota
Then creates a source GL Account of
810000BLT1 = TO_00001
Has anyone seen this before, where effectively a new account is created from the import format ?
1. I can't make a comment on FDMEE, but what is now 'classic' FDM does not audit the import format table. However if it is a requirement, then i am sure your DBA could sort something out
2. Yes, this is quite common, but perhaps more for the other dimensions rather than the account dimension.