One way we have poked in old data is to get the old data in a spreadsheet,
text file, something, modify it to match One World format, then poke it into
Oracle via SQL.
Knowing exactly what the One World format is can be tricky. And knowing all
the files to poke.
The thing that got us was leading blanks or leading nulls in some files. One
way to find out is to go to the OW screen, in Test, where you normally
create the transaction that makes the record, key a few transactions
(include some multi-line entries and some minus entries), then look at the
records in OW. Also look at them in hex to detect leading blanks and nulls
(some of the JDE programmers like them leadin' blanks, for some unknown
reason).
Also be careful about data types. Example: PO number DOCO, and document
number DOC, are in floating point. In F4311, F43121, etc. And many other
fields.
Example of multiple files getting updated: inventory receipt: writes to
F43121, F41021, F4311, F4105, etc., ad nauseam. Or AP vouchers: F0411,
F43121.
items to pay on AP (vendor invoices and thus AP vouchers). If this is
correct, send me an email and we can discuss details. I do not have
experience on the sales side.
Dave Mallory Denver Water OW 7.332 SP 15.1 Oracle 8.16134 NT 4.0