Average Daily Balances - Daily Ledger
We are trying to introduce a daily ledger (DTD) and would like some guidance/best practices for setup and running the ADB Process Request.
Example:
Current Date is 6/17 (open period May and June)
JE #1 is entered and posted with a 5/31 journal date -- we would like to appear in period 151
JE#2 is entered and posted with a 6/16 journal date-- we would like this to appears in period 167
How do we setup the run control parameter to capture the data correctly and does this mean that for each BU we have to row effectively for each day in the open period (in this example 61 -- a row for each day in May and a day for each row in June).