FIN General Ledger Roundtrip Hardcoding Steps

Owned by Adam Davis
Aug 04, 2023
3 min read

This chapter demonstrates how roundtrip was utilized to provide the live versions data hardcoding task.

Staging of source system data

Prerequisites

Data aggregated to granularity of FIN General Ledger. Data is stored in fiscal time, data need to be converted to fiscal time if input data are in calendar date and less than monthly granularity

Source

  • External Source System data.

Target

  • FIN General Ledger TB.

Result

Data copied from source system to FIN General Ledger TB. Depending on nature of data, you may load data into TB Load (default), Credit or Debit consolidation value measures.

Data Checks (Trial Balance)

Prerequisites

Global default setting Default tolerated TB discrepancy set in global setting in Administration > System >Settings > Apliqo FPM Params. Settings are stored in the }APQ Settings cube.

Source

FIN General Ledger TB – data checked per each company and month

Target

N/A

Result

Trial balance check passed – further processing of roundtrip allowed.

Trial balance check error – processing stops with error, continue as follows:

  • If TB error is relatively big, restage source data by repeating Staging step with corrected data from the source system

  • If TB error is relatively small, adjust TB error tolerances in UX by accessing Administration > Data Integration > Data Processing > Trial Balance. Trial Balance button orange and indicating number of TB errors. The UI accesses following backend objects:

    • }APQ Settings (global default setting Default tolerated TB discrepancy).

    • Per individual company in }APQ C3 FIN General Ledger TB Check Control

    • Per individual TB error in }APQ C3 FIN General Ledger TB Check

Calculate Operating Value

Prerequisites

TB_Mult attribute properly set for all FIN OCoA accounts. Run setup of operational CoA in Adminstration > Chart of Accounts > Operational CoA.

Trial balance check passed.

Source

FIN General Ledger TB – data stored under TB rollup (TB Load, Credit, Debit) in FIN Consolidated Value Measure.

Target:

FIN General Ledger TB

Result:

Operating value calculated for each account having value in source under TB rollup, stored into OPV in FIN Consolidated Value Measure.

First round of hardcoding

Prerequisites

Following parameters set in Administration > System > Settings > Apliqo FPM Params:

  • Number of actively calculated years (input)

  • First ACT Year FIN (read only, set through Apliqo Settings – Time and Versions – Current Period)

  • Current Year Fin (read only, calculated from two above parameters),

Source

FIN General Ledger TB – ACT version and LOCAL currency data stored under OPV rollup in FIN Consolidated Value Measure

Target

FIN General Ledger – version ACT for LOCAL currency

Result

Staged data copied to enable rule calculations in active versions, which are reading ACT/LOCAL data. Active versions are all versions descending from Live XR rollup in FIN Version:
ACT_RULE
ACTPYACT_RULE
ACTBUD_RULE
ACTFCST_RULE
PYACT_RULE
PYFBUD_RULE
PYACTPYPYACT_RULE

Scope of rule calculations is limited according to settings in }APQ Settings, parameter Number of calculated years in ACT and according to time span defined by First ACT Year FIN and Current Year Fin parameters.

Second round of hardcoding

Prerequisites

  • Currency setup finished, leading and reporting currencies set. Administration > Currency Conversion > Currency Setup.

  • Splicer successfully spliced FIN General Ledger rule.

Source

FIN General Ledger – all active versions, OPV and all Reporting Currencies.

Target

FIN General Ledger TB

Result

Data calculated by rules in active versions were staged into the OPV/all reporting currencies and static versions. Static versions are derived from active versions by removing _RULE suffix from version name:
ACT_RULE -> ACT
ACTPYACT_RULE -> ACTPYACT
ACTBUD_RULE -> ACTBUD
ACTFCST_RULE -> ACTFCST
PYACT_RULE -> PYACT
PYFBUD_RULE -> PYFBUD
PYACTPYPYACT_RULE -> PYACTPYPYACT

Third round of hardcoding

Source

FIN General Ledger TB – all static versions, OPV and all reporting currencies

Target

FIN General Ledger

Result

Data copied 1:1 into static versions in FIN General Ledger ready for distribution into reports.

Â