Interoperability Item Master Load Preferences

[Alan2011]

Hi All,
Doing Item Master load in DV for the first time, wondering if anyone has prefrences in method and best practice for data load.

I found some useful documents on oracle which describes the load from F4101Z1 F4101 Item Master Unedited Transaction table. That seems to be a bit tricky where you have to make sure you have minimum required fileds are there and they contain valu(?) but it doesn't tell where the actual load process will start. It may sound dum question but that is some thing I am not really clear.

My assumption is that I should choose Add from P4101Z1, and in the Add screen doing import rows into the grid as when you normally import data from an excel file.
The other asumption I had was through import export utility of SQL Developer into the table as I usually load data into other normal tables but I know doing this in Item Master table is not the same.

Again, never had to do this before and have no clear idea from where to start and how to proceed.

Thanks your reply.

Alan
JDE 8.11
Oracle 10g
OAS App Server
Win 2003

 

[Mike Mackinnon]

We initially used a VB application to load the data but after initial data load have used Excel to load the information by importing data and it worked fine for us. If you can just setup the data in an Excel file and create spreadsheet with all fields from P4101Z1 grid and then import data into screen and process. The nice thing about using the interactive application is you get immediate feedback since it will display any errors as opposed to just not working.

Note: this is from JDE8.0 system.

To update Item Master Unedited Transactions (F4101Z1)

EDI Batch Number String 15 characters EDBT
EDI Transaction number String 22 characters EDTN
EDI Line Number Number 7, 3 decimals EDLN
Item Number String - 9 characters LITM
Item Description 1 String 30 characters DSC1
Item Description 2 String 30 characters DSC2
Search Text String 30 characters SRTX
Unit of Measure String 2 characters UOM1
Lot Processing Type String 1 character SRCE
Serial Number Required String 1 character SRNR
Commitment Method String 1 character CMGL
Back Order Available String 1 character BACK
Taxable Product String 1 character TAX1
Third Item Number String 25 characters AITM
GL Class Code String 4 characters GLPT
Category Code 1 String 3 characters SRP1
Category Code 2 String 3 characters SRP2
Category Code 3 String 3 characters SRP3
Primary/Last Supplier Numeric 8 characters VEND
Leadtime Level Numeric 5 characters LTLV
Shelf Life Days Numeric 6 characters SLD
Stocking Type String 1 character STKT

Additional settings for records in F4101Z1:
EDI Processing Flag EDSP Set to blank
Direction Indicator DRIN Set to 1
Update Flag ITBR Set to 1
Transaction Action TNAC Set to “02”
Transaction Type TYTN Set to “JDEITEM”
Number of Lines EDDL Set to 1
Line Type LNTY Set to “S”
EDI UserID EDUS Set to “XXXXXXXXX”
Branch Plant MCU Set to blank
Cost Level CLEV Set to “3”
Item Price Level PLEV Set to “2”
Purchasing Price Level PPLV Set to “1”
Fixed or Variable Leadtime MRPP Set to “F”
Order Policy Code SZOPC Set to zero
Planning Code MPST Set to zero
Issue Type Code ITC Set to “I”
Round to Whole Number SNS Set to “U”
Issue and Receipt POC Set to zero
Quantity – Accounting Cost ACQ Set to 1.00
Category Code 8 SRP8 Set to “CMN”

All other fields will be set to blank (or zero if they are numeric). You may have some fields here that you do not use and possibly other fields in file that you require. You may need to tweak this list as required within your company.

 

[Mikechan]

only think you need to look the amount and date to make sure it is correct before posting. Mike explain very nicely in his post.

Thanks