You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FCCS_110 rule to load 0 in place of #missing

Received Response
edited Jun 5, 2023 7:45PM in Financial Consolidation and Close 20 comments


Need to write a config consol rule to replace #missing values with 0

Content (required):

DSO application. I'm running into a variant of the issue where an account goes to 0 and is subsequently not loaded to FCC, causing the periodic calculation to not occur and YTD to not go to 0. I would like to use configurable consol rule 110 to load "hard zeroes" to those intersections in order to trigger the periodic calculation. I load BS to ClosingBalance_Input and P&L to FCCS_Mvmts_NetIncome, so would need additional logic to handle that (the auto-reversal works for the BS since I load Replace, ClosingBalance_Input, YTD_Input, but that won't work for the P&L). So, essentially I want the rule to say:

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!