Are you doing the load as a Merge or Replace to HFM?
If you take the .dat file generated by FDM in the outbox and manually load it to HFM using the same load method as you select in FDM, does it load in the same manner?
Its Replace .We dont manually load data .Its automated .But in case the data load fails at FDM we want to ensure if the prior load was actually loaded to HFM.Just want to know what are the tables in HFM that we can check for amounts loaded from FDM .
Thanks in advance.
The amounts in HFM are not going to be marked as loaded by FDM, they are just going to show as loaded by the user who performed the load, just as if you were to load the data manually into HFM.
Are you just looking for the tablename in HFM that stores the data?
If so, you may want to post this to the HFM Forum.
Thanks JeffJon.Just want to know the tables in HFM where amount is stored.
The amounts are stored in different tables in HFM. You may want to post to the HFM Forum for a response on what tables store the amounts of the GL data that is loaded.