brobins
Member
I'm consulting for an old client and trying to import the F1201Z1 table. Running R1201Z1I results in all records being in Error status. Going back to P1201Z1 and resetting the error code and then doing a Row Submit I get a "Record Invalid" returned. There are no records in either the F1201 nor the F1202 tables. Since the transactions are set to 02/Add I assume that some data is being duplicated somewhere but can't figure out where. To be clear, there are no fields marked in red to designate the value that is being duplicated. If it makes any difference, we couldn't get the batch import program to work so the F1201Z1 was loaded from Access via ODBC driver. This client basically has very little technical support so I'm on my own here. I believe they're on 9.0 and my experience with JDE is somewhat limited and I'm more of an iSeries programmer in a previous life. Also, which field or data controls whether or not the F1202 is loaded simultaneously? It seems like it might be FAEDDL but the help doc I have says that controls whether the F1217 is loaded. Thanks for any assistance. Bill
Last edited: