Data conversion Strategy [message #196865] |
Sun, 08 October 2006 16:55 |
aashi82
Messages: 1 Registered: October 2006
|
Junior Member |
|
|
1)Data Conversion for Open Invoices, Any solutions?
We are planning to reimplement our financials from 11.57 to 11.5.10(not, not an upgrade but reimplementation, as if we are moving form legacy to oracle). The reason being there is too much data corruption happening in the existing 11.5.7 due to wrong setups, clean up the business processes etc.etc.
We are going thru our data conversion strategy and ran into a bottleneck.
We are bringing in all unpaid invoices thru open interface table, Is there any other Approach other than this?
2)Data Conversion for Partially Paid Invoices, Any solutions?
we cannot bring partially Paid Invoices through gateway since it is very difficult identify the lines which have been paid. Is there any Approach for this?
3) Data Conversion for Fully Paid Invoices, Any solutions?
really do this for PAID invoices.
Did any one ever bring over paid informaiton, if so, did you do direct table updates, and if so, did you recreate the PK/FK ID's? Now, my concern is this might make us lose Oracle support, due to the fact that paid information is being populated into almost all of oracle tables with ID's that could cause data corruption?
Any thoughts/suggestions are greatly appreciated.
|
|
|
Re: Data conversion Strategy [message #218581 is a reply to message #196865] |
Thu, 08 February 2007 15:22 |
sravankasyap
Messages: 1 Registered: February 2007
|
Junior Member |
|
|
Hi
2)
A)
To bring the partially paid invoices, we migrated the Invoice with legacy amount(total), and any amount paid against this invoice ( applying Credit Memo / Receipt) can be converted as a single Receipt with to balance the amount.
As part of this, If a credit memo is partially applied we brought only open amount for a credit memo. This would reconcile with the legacy aging report.
B) If the line details is not mandatory, just bring the open amount for that invoice with a memo line approach.
3)
Yes, we can convert fully paid invoices, But it is risky and should be phased approach.
Step1:
Bring the Open Invoices / Credit Memo / Debit Memo with the legacy amounts
Step2:
Bring the Applied Credit Memo / Demit Memos
Step3:
Bring the Receipts as it is
Step4 : Only apply the receipts against the invoices without creating. need a separate extraction for the amount being applied on each invoice.
Hope this is helpful..
Regards,
Sravan Kumar Daggupati
|
|
|