Custom Period Ranges and Date Handling in FSG Balance Function

For aggregating balances over a user-defined, non-standard period range, you must use the CTD (Custom-to-Date) Amount Type parameter . In the Period Name parameter of the `br_balance` function, you specify the range using a hyphen as the delimiter, such as `Feb-07-Aug-07` . This balance type specifically summarizes movement data across those defined periods .

When using JED (Journal Effective Date), JEDU (Unposted JED), or JEDP (Posted JED), the Period Name parameter functions as a date parameter , accepting entries like a date range (e.g., `01/01/2007-05/01/2007`) . A crucial limitation is that the hyphen (`-`) serves as a range delimiter within Blitz FSG and cannot be used as the date separator within the date string itself (e.g., `01-01-2007` would be invalid if your regional settings use hyphens as date delimiters) . We recommend using slashes (`/`) as date separators and formatting the Excel cells as text to avoid regional setting conflicts .

If you leave a segment value field blank, or explicitly enter a percent sign (`%`), the function is instructed to include all possible values for that segment . This typically results in an ‘OR’ condition for lists, meaning all accounts matching any of the specified criteria will be returned .

If the Period Name entered does not exactly match the format configured in Oracle (including case sensitivity, e.g., ‘JAN-2007’ versus ‘Jan-07’), the function will return no data and will likely trigger an ‘invalid (Period)’ message . Exact matching of Oracle’s configured format is mandatory for correct data retrieval .