The Item Master Attributes Bulk Change, will allow you to update various item master information through a template upload.
Requirements:
|
Uniq_Key
|
Primary key from Inventor Table
|
Can be empty if Part_no/revision is provided
|
If all three are provided, validate that part_no/revision is matching the uniq_key in the database
|
|
Part_no
|
Part number
|
Can be empty if uniq_key is provided
|
|
Revision
|
Revision
|
Can be empty (not a required field in Manex)
|
Here is a list of attributes you can update:
|
Attributes that user can bulk update:
|
Description:
|
Notes:
|
| ABC |
ABC CODE |
Must use an ABC type that is in the Setup module |
|
Package
|
Part Package
|
|
|
Buyer_Type
|
Buyer Code
|
|
|
Scrap
|
Scrap %
|
Scrap % , has to be >0
|
|
SetupScrap
|
Setup Scrap Qty
|
Has to be >0
|
|
stdBldQty
|
Standard Build Qty used for Calculating Setup Scrap
|
If setup Scrap is not 0, stdBldQty has to be >0 (default 1)
|
|
INSP_REQ
|
Inspection Required
|
1= true
0= False
Nothing, would be no update
|
|
FirstArticle
|
First Article Required
|
Not available for parts with Part source ‘Phantom’
|
|
Cert_req
|
Certificate Required
|
Not available for parts with Part source ‘Phantom’
|
|
Cert_type
|
Certificate Type
|
Can be entered only if Cert_Req=1
Certificate types:
Receive , ship , both
|
|
MRC
|
MRC
|
Pre-set, see System settings, Material Risk Code for valid values.
|
|
TargetPrice
|
Target Price
|
|
|
Ord_Policy
|
Order Policy (MRP)
|
Valid Values
Lot for Lot, Daily, Weekly, Semi-monthly, Monthly, Quarterly
|
|
Day
|
Day of the week
|
Required if Ord_Policy = ‘Weekly’
Monday-Saturday
Possible values: 1-6
|
|
Dayofmo
|
Day of the month
|
Required if Ord_policy is one of these values:
Monthly, Semi-Monthly, Quarterly
|
|
Pull_in
|
Number of days allowed to pull in
|
>=0
|
|
Push_out
|
Number of days allowed to push out
|
>=0
|
|
ReordQty
|
Qty to Reorder
|
>=0
|
|
ReordPoint
|
Qty below which new order have to be place
|
>=0
|
|
MinOrd
|
Minimum Qty to Order
|
>=0
|
|
OrdMult
|
Order Multiple
|
>=0
|
|
Pur_ltime
|
Purchase Lead Time
|
>=0
Only if Part Source= ‘Buy’ or Make_Buy
|
|
Pur_Iunit
|
Purchase Lead Time Unit
|
Required If purchase Lead time is >0
Values: DY, WK, MO
|
|
Kit_Itime
|
Kit Lead Time
|
>=0
Only if Part Source= ‘Buy’ or Make_Buy
|
|
Kit_Iunit
|
Kit Lead Time Unit
|
Required if Kit Lead time is >0
Values: DY, WK, MO
|
|
Prod_Itime
|
Production Lead time
|
>=0
|
|
Prod_Iunit
|
Production Lead Time Unit
|
Required if production lead time is >0
Values: DY, WK, MO
|
|
Inv_note
|
Item Note
|
|
|
Taxable
|
Item is Taxable
|
1= True
0= False
|
You can first download a blank template, right off Item Master Attribute Bulk Change screen.
Once you have the template filled up, proceed to the screen "browse" to the template and click "upload" after selecting the file.
If it uploads successfully you will get the below message.
If there are any exceptions during the upload process, you will get an error message up top and a excel sheet with the exceptions will generate and download to your computer.
Here is an example of an error I had. I had Cert_req= 1 but I did not put a Cert_Type.
Notes:
- You can change any number of attribute columns, the ones that you do not enter any information will not be modified
- You can remove all the attribute columns that you are not changing, leaving only the ones that are going to be changed. Must have at least Uniqkey and/or PartNo and Revision columns.
|