Feature - Support Item Case Size in New Item CSV Import and Change Existing Item Import
Release Date: 5/1/19
Version: 8.5 and up
This feature allows the user to specify the item case size when importing items through the New Item CSV Import and the Change Existing Item Import. The item case size can be specified only if the quantity per box option is set up in Global Setup -> Dist -> I/M Global Control, Screen 2, flag “2. Use Which Item Field For Quantity/Box ?” for cases (option "C").
See https://support.netcellent.com/portal/en/kb/articles/feature-case-size-support-for-quantity-per-box for more information on Case Size Support for Quantity Per Box.
The New Item CSV Import supports column BI, Case Size.
Case Size (ITEM-CASE-SIZE in Item Master File):
Field is not required.
If provided:
The field is only allowed if Global Setup -> Dist -> I/M Global Control, Screen 2, flag “2. Use Which Item Field For Quantity/Box ?" is set to "C." Otherwise this is an error.
Value must be between 0 and 999.
Field is not required.
If provided:
The field is only allowed if Global Setup -> Dist -> I/M Global Control, Screen 2, flag “2. Use Which Item Field For Quantity/Box ?" is set to "C." Otherwise this is an error.
Value must be between 0 and 999.
The BI column is shown on the report output, and any error, if applicable.
The Change Existing Item Import now supports column BQ, Case Size.
When importing change records, the following rules apply:
Case Size (ITEM-CASE-SIZE in the Item Master File):
If provided:
The field is only allowed if Global Setup -> Dist -> I/M Global Control, Screen 2, flag “2. Use Which Item Field For Quantity/Box?" is set to "C." Otherwise this is an error.
Value must be between 0 and 999.
Case Size (ITEM-CASE-SIZE in the Item Master File):
If provided:
The field is only allowed if Global Setup -> Dist -> I/M Global Control, Screen 2, flag “2. Use Which Item Field For Quantity/Box?" is set to "C." Otherwise this is an error.
Value must be between 0 and 999.
The BI column is shown on the report output, and any error, if applicable.
Programs Modified: ITEMDFLT.WS, IMIMPCSV, IMIMSITM, IMITMUDS, IMITMUDI
CLS
Related Articles
Change - CSV Import Programs to Support File Names Longer Than 20 Characters
Release date: 5/5/2021 Version 8.5 & Up There were many Elliott CSV Import programs which had a limitation that the maximum file name could not be greater than 20 characters. See the following KB article: ...Common Issues with Importing CSV Files Into Elliott
Release Date: 12/18/2020 Version: 7.0 & Up Elliott Business Software has extensive features with CSV file export and import. It provides a gateway to view Elliott's data in Excel spreadsheets and optionally allow users to edit the data in ...Change Customer Number or Create New Customer and Import Ship-To
Release Date: 02/18/2022 Version: 8.5 & Up Q - We had to create a new customer number for our T&EAZ account. We are doing a web project and the website does not like the "&" symbol that is in this customer number. My question for you is…. Is it ...ARECIMNT Accounts Receivable Customers and Contacts Import Utility
Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...Feature - New Item Import Through CSV File
Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...