Guest_imported
New member
- Jan 1, 1970
- 0
Greetings All, I need some help.
After spending ALL weekend on site doing data conversion for a client who plans to go live on Monday, the OE data (the last module converted) has some serious issues.
The integrity check on the plus data did not unearth any problems, but during the conversion, after the scanning phase, 3 invoices were reported to be without details and would not be converted, and a few "Customer does not exist" errors. That’s OK, we figure we could re-key and re-post three invoices, although they did not have detail records in Plus either, and we just created the missing customers in AR, and restarted. We went ahead with the conversion.
At the completion of the conversion, an integrity check on ASEE OE4.2 data declared that 3 invoices had no detail records in the Invoice Detail file. This is bad since the same records have details in the Plus database.
Even worse, when we did an Invoice inquiry, I realised that the conversion had mixed-up the invoice details somehow. Invoice header info was OK, but the wrong detail records were linked to the header records!!
I have no idea how this happened. It must be software or data related, because we did the conversion twice & the error happened twice. Somehow the values in invoice number field of the detail records get "shifted". I'll explain.
We compared the data by using the invoice inquiry screens in both Plus & ASEE.
Invoice 295578 is for a stationery store, 295579 for a child day-care centre, 295580 for a restaurant/club.
Invoice 295579 has 10 line items(in both Plus & EE), however in Plus(the correct one), line items 1 & 2 are two different types of cereal. After conversion, the same invoice in EE has line item 3 as the first. It still has 10 detail lines in all having taken lines 1&2 from 295580(wine and rum), while the stationery shop's invoice(295578) now includes the cereal line items from the child care's invoice.
It is almost as if the conversion program lost some invoice detail lines, and just filled in the spaces by tking line items from the next record!!
Plus - SM6.1a, OE6.1b, IC6.1b, AR6.1a
ASEE - SM5.0, OE,IC,AR4.2 (all with latest packs)
Can anybody shed some light as to where we have gone wrong? I would be grateful for any help resolving this.
Mike.
After spending ALL weekend on site doing data conversion for a client who plans to go live on Monday, the OE data (the last module converted) has some serious issues.
The integrity check on the plus data did not unearth any problems, but during the conversion, after the scanning phase, 3 invoices were reported to be without details and would not be converted, and a few "Customer does not exist" errors. That’s OK, we figure we could re-key and re-post three invoices, although they did not have detail records in Plus either, and we just created the missing customers in AR, and restarted. We went ahead with the conversion.
At the completion of the conversion, an integrity check on ASEE OE4.2 data declared that 3 invoices had no detail records in the Invoice Detail file. This is bad since the same records have details in the Plus database.
Even worse, when we did an Invoice inquiry, I realised that the conversion had mixed-up the invoice details somehow. Invoice header info was OK, but the wrong detail records were linked to the header records!!
I have no idea how this happened. It must be software or data related, because we did the conversion twice & the error happened twice. Somehow the values in invoice number field of the detail records get "shifted". I'll explain.
We compared the data by using the invoice inquiry screens in both Plus & ASEE.
Invoice 295578 is for a stationery store, 295579 for a child day-care centre, 295580 for a restaurant/club.
Invoice 295579 has 10 line items(in both Plus & EE), however in Plus(the correct one), line items 1 & 2 are two different types of cereal. After conversion, the same invoice in EE has line item 3 as the first. It still has 10 detail lines in all having taken lines 1&2 from 295580(wine and rum), while the stationery shop's invoice(295578) now includes the cereal line items from the child care's invoice.
It is almost as if the conversion program lost some invoice detail lines, and just filled in the spaces by tking line items from the next record!!
Plus - SM6.1a, OE6.1b, IC6.1b, AR6.1a
ASEE - SM5.0, OE,IC,AR4.2 (all with latest packs)
Can anybody shed some light as to where we have gone wrong? I would be grateful for any help resolving this.
Mike.