WIP Value report

Hello

For month end closing, we use the WIP value report to reconcile between WIP and GL. When we have a DJ that is created in a previous month, say Sept, during closing for the month of September, i.e. on Oct 1, the report keeps changing if there is any processing done for that DJ. We are running the report with following parameters.

Report Type: Cumulative to Date

Include Closed Jobs: No

1. Is this the expected behavior of WIP value report?

2. Are we using the right report for reconciliation during closing? If not, what report should we be using?

We have another requirement for auditors at the end of the year where the users want to run a report to show the auditors the balances in WIP and GL and how they reconciled. They are expecting to run the WIP value report for a specific month end (9/30/2015) and be able to get the balances in WIP as of that date. But because of the behavior above we are not able to do that. Is there any base oracle report (without us having to build a custom report) that will help achieve this requirement for us?