This content has been marked as final. Show 6 replies
not an expert too... but maybe you can use the same approach with another element ""Offset Accrued Gratuity Provision for transfer".
thanks Giuseppe. I thought the same as well. Only problem comes with costing, because it means I have to add the offset element in the previous month and cost it based on account parameter set up at that point in time.
It would be nice if I didn't have to attach a ledger in GL flexfield mapping. If oracle could pick up the set of books automatically, then modifying the account in the element entry is all I would need. that would be something. Oh well
Assuming the below scenarion:
Gratuity in Company A:
Balancing Account(Accruind Account)
Now define your offset element with costing and balancing segments as below:
Balancing Account (Accruing Account in Company 02)
In this case when the payroll and costing is processed for the offset element, it would debit: 01.200 and credit 02.300. But this will work assuming company 01 and 02 are configured as company segments in the same set of books. If your company are in 2 different SOB, a finance expertise would be required.
Not sure if you can work with a set of elements "Previously Accrued Gratuity Provision transfer from A --> B", then play with the link balancing as already suggested.
Thanks Ram and Guiseppe, I've tried playing with the link cost and balancing segments. Have partially got it to work.
In January payroll (company code 01) I am checking to see if a change has been made to the assignment payroll. If so, I get the accrued amount for gratuity, spin it off as an element which is then reverse costed,so that the total for the account in January becomes 0 after gl transfer et al is done. I then push the accrued amount into a balance.
In February, this accrued balance amount is generated as a provision and costed according to the new payroll (company code 02). So for 02 account I now have total accrued in 01 account + total accrued in february. For 01 account I now have 0.
The problem is with the accounting date though. Because this means that as at 31-JAN the total for the account is 0 which according to the clients finance office is wrong. The accrued amount in payroll 1 should be 0 as at 01-FEB not as at 31-JAN because the employee transfer happened on this date.
I was actually wondering if the retropay costing process can be used for this? What if I add a provision entry manually. This triggers the retropay process. If I run retrocosting process with an end date of 01-FEB, will it pick the set of books id for the old payroll for only my new entry, then use the new SOB id for the other entries in the run?
Anyway testing this to see what happens.
Many Thanks for the help so far. Unfortunately for me the client is insisting on this and I have never seen this done before to be honest.
Nope the retropay costing won't work either because of the time period.
The real problem is the different set of books. Would be nice if you could run one payroll with different set of books.