CSV Import Update of Assembly Item Results to an Unexpected Error
Published on
June 29, 2023 at 2:15:43 PM PDT June 29, 2023 at 2:15:43 PM PDTth, June 29, 2023 at 2:15:43 PM PDT
Scenario
User is updating Assembly Item via CSV Import by navigating to Setup > Import/Export > View CSV Import Status.
Sample Scenario:
- Message : 0 of 1 records imported successfully
- CSV Response: An unexpected error has occurred.
Upon checking the CSV Response, user notes the error: "This item type (Assembly, subtype=) is missing a required unit parameter."
Note: Assembly may be replaced by InvtPart.
Solution
To resolve:
- Navigate to List > Accounting > Items > List
- Edit the Assembly record or Component Record
- Check if the following fields have values
- Unit Type
- Stock Units
- Purchase Units
- Sales Units
- Enter necessary values on the fields
- If the fields above have values and user is still experiencing the error, Edit then Save the assembly record(without making any changes)
Note: User must also ensure that the component records have values for the same fields. - Navigate back to Setup > Import/Export > Import CSV Records
- Retry the import