Clarity

As an org we are just now starting to look in to setting up Financials (on 13.0, with a planned upgrade just around the corner so if you are aware of changes in this regard let me know that as well please) and I had a question from what we saw in our testing and the documentation.

Once timesheets are posted to financials, how are adjustments handled? From what we saw in the docs, it looks like after posted to WIP, you have to go in and create manual WIP adjustments. Is that correct? Is there a way to automate this process or am I just completely missing the boat on this one?

If you need adjustments where the hours do not change, but something else changes then you do the WIP adjustments.

Automate that? In the GUI that is strictly  manual. If you have automatic input data generation then you could take that a step further and create XML input file for transaction import, then do Post transactions to Financials and Post to WIP in batches.

urmas wrote:

 

If you need adjustments where the hours do not change, but something else changes then you do the WIP adjustments.

Automate that? In the GUI that is strictly  manual. If you have automatic input data generation then you could take that a step further and create XML input file for transaction import, then do Post transactions to Financials and Post to WIP in batches.

Sorry for taking so long to get back to this. For now atleast, we're only talking about adjustments to hours, via timesheet adjustments. Are those automatically applied or does that require manual WIP intervention?

If you just want to adjust the hours the designed way is to do adjustment timesheets and process them normally and eventually post to WIP.

You can automated the creation of the adjustment timessheets through XOG and schedule the postings except for the post to WIP.

Check this -

TEC562321 - Explain WIP Reversal and WIP Transfer actions.docx

NJ

no WIP intervention is needed for adjusting hours from the timesheets. You would adjust, submit, approve the timesheets, run Post Transactions to Financials, do Post to WIP. and check the result

Ahh... ok

NJ

They would need to be adjusted one by one, this is where the enhancement comes in. Please vote on this idea:

Batch WIP Adjustments

It's on page 3 among all the ideas ranked by the number of votes, anyone reading this should vote if you haven't done so and if it will help simplify your business process

Can't you do that in batches of transaction pairs one reversing the original and the second applying what it should have been in the first place?

If you are only going to report on the aggregated total from the WIP table, yes.

But if you are going to also consolidate timesheets with WIP, there will be a chance of reported 'out of sync' depending on how the queries are written. Because now you have 1 transaction from timesheet matching with 3 transactions from WIP for the same transaction (x hours for an assignment on that day)

Thanks.