Rule to aid a YTD data load doesn't work every of the time
Summary:DSO application. YTD GL data loads. Created a rule that aids with entering a zero as appropriate to assists with the Movement rollforwards (the ClosingBalance Input member).
Content (required):This rule works most of the time, however sometimes we have to load a 2nd or a 3rd time to trigger the functionality.
Version (include the version you are using, if applicable): 21.12
Code Snippet (add any code snippets that support your topic, if applicable):
FIX ("Entity Currency", "Entity Input", "FCCS_Periodic")
FIX ("[CostCenter].[No CostCenter]", "[General].[No General]",
@Relative("Total LegalEntity", 0),
@Relative("Total ProfitCenter", 0))
FIX (@REMOVE(@RELATIVE("FCCS_Total Balance Sheet", 0),