By Hoa Pham on February 29th, 2012
Many customers who use HFM have a typical close cycle where G/L data is first loaded using Financial Quality Data Management (FDM) and then, supplemental inputs are made directly in HFM using data forms. Since the close cycle is iterative, what happens to supplemental input data when G/L data is loaded again via FDM? If the FDM data load mode is set to either Merge or Replace, it’s very possible that the supplemental input data is going to be overwritten and users will have to key them in again. This redundancy is a problem for companies that want a quick moving close cycle. We have a dynamic solution to resolve that problem. We call it FDM Smart Merge.
FDM Smart Merge leverages the default FDM data load process to dynamically clear only data intersections from the most recent data load. You no longer have to worry about other data intersections outside of the data file being cleared. To best understand how it works, follow the illustrations below.
Second, FDM Smart Merge will dynamically copy all the data lines in that previous data file and change the data amounts to the special HFM code “noData”. And all those data lines will be appended to the top of your new data file.
Illustration 2: FDM Smart Merge creates data lines to clear the first load data records
Typical of the close cycle, the next load of G/L data will have changes to the data lines. It’s very common for data records to disappear because adjustments have been made in the G/L. For example, let’s assume the “Discounts” lines do not appear for valid accounting reasons in the new G/L data file.
Illustration 3: New G/L data file
Third and last, FDM Smart Merge will ensure that the previous data records that loaded to the “Discounts” lines will be cleared out in HFM. The full file that FDM will load into HFM will look like this example below:
In HFM, if the entities California and Texas have supplemental data via data forms or data grids, they will not be affected. That supplemental data will still show up in HFM.