MBS Description (XRef) Import

Modified on Wed, 17 Jul 2019 14:59 by Freddy Donovan — Categorized as: Import- Export Manager, Item Control, Warehouse Management System

Table of Contents [Hide/Show]

   General Information
   Additional Information
   MBS Description File Definitions

General Information¶

Default Menu Location Transactions >> Importers/Exporters >> Item Control >> MBS Description Import

Screen Name IMPORTMBSDESC

Item File Name/Browse: Use the Browse button to locate and select the completed MBS Description (XRef) Import template file (in XLS format).

Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.

Export Template: Generates a blank MBS Description Import file

Delete ALL existing records before import: If checked, ALL existing MBS Description details will be deleted prior to importing. This checkbox should only be used if you intend to do a complete re-import of ALL MBS Description details.

Import duplicate records: If checked, duplicate line entries for the same item record will be imported and will append to any existing MBS Description details for the same item record. If unchecked, only the last line of information associated with an item record will be imported.

Additional Information¶

MBS X-REF Attribute: The MBS X-Ref Attribute (text1 Name = 'MBS X-REF') must exist in Rule Maintenance with the 'MBSDESCRIP' form name. The MBS Description (XRef) Import will NOT create the required MBS X-REF attribute for all imported item records. The MBS X-REF attribute must be added to each item record before or after the MBS Description (XRef) Import.

MBS Description File Definitions¶

Required fields are indicated with an *

*Item - Item code in Adjutant

*MBSDesc - MBS Description used to match the MBS import details to the Adjutant item code (allows 50 characters, alphanumeric)

MBSColor - MBS color value from MBS file (allows 20 characters, alphanumeric)

MBSPart - MBS part value from MBS file (allows 21 characters, alphanumeric)

MBSThick - MBS thickness value from MBS file (allows 6 digits, with a decimal in the format ##.#### or ###.###)

MBSCCode - MBS color code value from MBS file (allows 2 characters, alphanumeric)

MBSClass - MBS color value from MBS file (allows 30 characters, alphanumeric)