During periodic settlement of WBS to AUC the settlement entries are not showing correct values and expected. The expected value of settlement should match with the Actual Balances for the current period 9 which is in CJI3 (Actual Cost Line-Item Report)
The settlement entries from WBS to AUC are behaving as below:
Cost booked on Level 5 WBS lets say is 100 dollars
AUC is at level 1 WBS
Running CJB2 and then running CJ88 settles the cost correctly to AUC with 100 dollars.
CJI3 shows correctly as the total cost of the project is 0
Original posting with debit/credit indicator as "D" and the settlement posting as "O"
When we reverse the settlement the cost comes back to AUC with a debit/credit indicator as "D"
1. Original journal entry + 100 dollar debit to WBS with Dr/Cr indicator "D"
2. Settlement entry - 100 dollar credit to WBS with Dr/Cr indicator "O"
3. Settlement Reversal + 100 dollar debit to WBS with Dr/Cr indicator "D"
When we settle again the cost is wrongly taken as + 200 dollar and is omitting the entry of the previous settlement. What can be the reason for this?
So every time we are reversing and settling the values again the cost is wrong and is piling up
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.