 Calculating Ageing fields - OBI Answers [message #607655] |
Mon, 10 February 2014 11:29 |
 |
mcintyresteven
Messages: 1
Registered: February 2014
Location: Walsall
|
Junior Member |
|
|
Hi
The standard OBIA reporting for AR/AP Ageing is not reporting correctly therefore we have attempted to recreate the Ageing fields ourselves to reconcile with current reporting totals.
In terms of calculating the ageing fields for '1-30,'31-60′ etc we have had to hard code the dates
ie for December Fiscal Period selected or filtered the calculation for 'Ageing 1-30′ is : ifnull(FILTER("Facts AR Transactions"."AR Amount" USING ("Payment Due Date"."Payment Due Fiscal Day Date" BETWEEN timestamp '2013-12-01 00:00:00′ AND timestamp '2013-12-31 00:00:00′)),0)
How do we replace the dates in this expression to look at the Fiscal Period selected and filter the 'Payment Due Fiscal Day Date' accordingly?
The dates would need to move in each Ageing field based on the Fiscal Period that the user selects.
Thanks
Steve
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
