You’re offline. This is a read only version of the page.
We plan to import around 100 new inventory items to Inventory Item Screen. Any suggestions/tips how to do that? Thanks
*This post is locked for comments
hi, just wanted to share with you... there is a reported bug with TI (1025000) which has not been fixed (bug10720) for "Transaction Import into the Inventory Items screen requires serassign and lotserissmthd values even though lotsertrack is NN"
Thanks for the Tip. The original upload file is fine, there is no missing field. It looks like the Serassign, Lotserissmthd and Lotserfxdtype are required to put the values in it even Lot/Serial Tracked is set up as 'NN'. The upload process goes through, now it is only one error message which should be easy to fix it.
The default TI script for Inventory Maintenance has a long list of fields. Unless you need most of the fields for your import data, editing the TI control macro will make it easier to match up with source data and find mapping differences. When you generate a control macro, it will reflect the current screen layout. Disabled fields will be commented out in the control macro and can be deleted from the macro for readability, and user fields added to the screen will appear with a sequence number.
TIP: to proof your import data, copy the data line into Excel, then create a sequence of number fields across the columns to check that the import data is being inserted in the correct fields matching the control macro sequence. That makes it easier to find mapping differences between the control macro and the data file. If the field can be skipped on the data entry screen, it can be bypassed by an import. In your example, specifying 'NN' for items that won't track lot or serial #s should eliminate a need to provide values for the fields on the subscreen - the same fields returning errors on your import.
Remember that you can also specify default values in the control macro itself if you want to simplify the import data. For example, specifying in the import macro for the field
serr = SetObjectValue( "csource", "P" ) rather than the default ImportField(6) means that you won't need to include that field in your import data.
well.... The "none" option is selected for Lot/serial Tracked field, same as other existing inventory items so all these Lot/serial method, fxdtype...fields are blank in the inventory table.
Do you think it is something to do with the mapping issue? maybe there is a missing field in between?
There are many Disabled fields in the control file, without modifying the Ctrl file, do I still count those disabled fields as the fields ?
You can test hand entering an example record of the problem data on the Inventory Item Maintenance screen. You'll note that if the item is lot/serial tracked, several additional fields will be required for that item: Assignment, Issue Method, Prefix Type and Length.
Check the data being imported to confirm whether the item is supposed to track lot or serial numbers, and provide the additional data fields for that item if LSN tracking is required.
A cvs file has created but I got 4 errors- 3 of them are not the required fields and the all are ComboBox. The import file for these fields are blank ???
The last error just indicates it is not allow?????
Any idea how to fix these problems?
************************
'System Message 8011: ========Begin Processing of a Level0 Data Line========
'Level0,HEPTEST0001,HEP TEST ITEM 0001 ,53,,F,P,F,NN,,,,,MECH,EXEMPT,AC,1,CHECKED,SET,SET,SET,0,,,,,,,,,,,,,,1680,10000000,7550,10501000,6485,10150000,2148,10000000,2143,10000000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Q,ABC,,,,999,999,0,0,0,,0,,,,,,,,0,,,,,
'System Message 8005: New Record Requested
'System Message 8020: Invalid possible value for a ComboBox. Control: cserassign Value:
'System Message 8016: Possible values for the control cserassign are R;When Received Into Inventory,U;When Used From Inventory
'System Message 8020: Invalid possible value for a ComboBox. Control: cserassign Value:
'System Message 8016: Possible values for the control cserassign are R;When Received Into Inventory,U;When Used From Inventory
'System Message 8020: Invalid possible value for a ComboBox. Control: clotserissmthd Value:
'System Message 8016: Possible values for the control clotserissmthd are E;Expiration,F;FIFO,L;LIFO,S;Sequential,U;User Enterable
'System Message 8020: Invalid possible value for a ComboBox. Control: clotserfxdtyp Value:
'System Message 8016: Possible values for the control clotserfxdtyp are C;Constant,D;Date,E;Enterable
'System Message 8055: ========Error Processing Level0 Data Line========
'System Message 8026: Insertion of new records on this level are NOT allowed
LEVEL1,HEP,ABC,ABC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Level0,HEPTEST0001,HEP TEST ITEM 0001 ,53,,F,P,F,NN,,,,,MECH,EXEMPT,AC,1,CHECKED,SET,SET,SET,0,,,,,,,,,,,,,,1680,10000000,7550,10501000,6485,10150000,2148,10000000,2143,10000000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Q,ABC,,,,999,999,0,0,0,,0,,,,,,,,0,,,,,
'System Message 8030: The Number of Errors detected was 4
'System Message 8001: Completed Processing 15:18:30
********************************
Customize the inventory screen and mark the field (Control Name) that you’re going to use then compare the control name in the intelligent control file and comment the unwanted field (Control Name) and you may not consider the other fields.
Example:
Field name : inventory.taxcat
Control Name: cslstaxcat
' Field mask is UUUUUUUUUU
' NOTE -- This field is a required field
serr = SetObjectValue( "cslstaxcat", ImportField(14) )
Thanks,
Ajit kannan S R
Thank you for the info.. here are more questions, hope you can help..
I am having an issue to identify what those fields either in the Inventory table or in the control file. For example:
1) what is the field name in the control file for inventory.taxcat or inventory.materialtype ?
2) what does these fields mean in control file: cPackmethod on importfield57? is it the same field as Pack in the inventory table? there are many fields in the control file do not match to the table's.
what is the best way to identify those fields?
Hi Ginny,
It is easy to do. Following are the steps to accomplish this.
The standard import capabilities through the transaction import tool. When using the transaction import screen, the process is powerfully enhanced by use of the Control Macro Generator, which dynamically adjusts for any customization's for field names, and layout.
1. Generate the “intelligent control file” using control macro generator in standard mode for the particular screen. In the intelligent control file comment the unwanted field in the control except the mandatory once.
2. Create a data.csv with multi-level based on the intelligent file then browse those files (data file and .control file) into transaction import screen.
3. In the transaction import screen click option button and check the Edit only box for testing the data without error when importing the data file.
Please let me know how it goes.
Thanks,
Ajit Kannan S R
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (