Data Import Manager

Stated property length on the following fields is incorrect: Billing.Address.State - says 3, should say 2 Billing.Address.ZipCode - says 13, should say 10 Billing.Fax.Number -says 15, should say 13 Delivery.ThirdPartyFreight.Customer.CustomerNumber - says 7, should say 6 Tax.Vat.Iso.CountryCD.IsoCountrycode - says 3, should say 2

Fields in tables below not found in object Part INVENTORY_MSTR code_total qty_recvd_not_insp qty_mfg_reqmts code_extra_desc pct_order_disc qty_beginning amt_beg_cost code_exception code_perm_fix date_exception ctr_back_order -> sets Backorder on Options screen date_last_verify qty_last_onhand flag_6_cost INVENTORY_MST2 amt_cost_1 amt_cost_2 amt_cost_3 lifo_base Cutting_charge shp_cnv_factor ship_um base_part INVENTORY_MST3 po_certs_reqd INVENTORY_COST none missing FG_STD_COST none missing Part OBJECT MISSING FILE, TABLE, COLUMN NAMES, and PROPERTY LENGTH InventoryStatus.Allocated InventoryStatus.Available InventoryStatus.Consigned InventoryStatus.InInspection InventoryStatus.InQuality InventoryStatus.InTransit InventoryStatus.Net FIELDS WE SHOULD REMOVE FROM IMPORT (Per Rhonda) All Proerties that start with StandardCost.xxx , from FileName JSTND. INTEGER MASK NOT WORKING Mask on excel template for integers is not allowed when import processes. Template allows for -9999999 to 9999999; however, when you enter -1234567, it is not allowed. Postive numbers are only allowed. I have the log file and some screen shots if it will help. DISCREPANCIES FOUND Packing.Nmfc Sub Code: NMFC Sub no is 4 in length on template but only accepts 3 on screen Purchasing.UnitofMeasure.UnitOfMeasureCode is 3 in length on template & INVENTORY_MSTR but only accepts 2 on screen Information.UnitOfMeasure.UnitOfMeasureCode is 3 in length on template & INVENTORY_MSTR but only accepts 2 on screen Manufacturing.Issue.UnitOfMeasure.UnitOfMeasureCode is 3 in length on template & INVENTORY_MSTR but only accepts 2 on screen Pricing.Vat Product Retention Type. Vat Product type (INVENTORY_MST3: VAT_PRODUCT_TYPE) does not populate VAT Prod Type on screen (my Vat is off), so possible validation already in code that I'm not selecting? Usage.Last Roll Month (INVENTORY_MSTR: YEAR_LAST_ROLL) Screen says Month, where does Year come in? Confusing to customer/user. Usage periods (0,1,2,etc.) do not match object to pcc field (1,2,3,etc.) - NEED A SPECIAL NOTE to lessen confusion? Warranty Code XX did not come across on screen, only shows in table (no validation selected in DIM) Warranty table does require this to be numeric. Should we do the same here? Let me know if you have questions.

Collections.AverageDaysPayment . Value in Excel = 32, value loaded = 16

I have found a few objects that display empty when selected in DIM. Examples would be the CRMCommentsOld, Events, EDILines. I haven't checked the rest.

I have a customer sample inventory file that is throwing an error "Row#1 has incorrect number of fields. Fields: 162. Headers: 161. I have picked it apart, and if I remove the comma in the Part Description, it works. The csv file has double quotes around the description ("GEO, PLE-SB-XXX"); however, DIM doesn't recognize the double quotes. It is reacting to the comma inside the quotes as a new field and not a comma within a description field, resulting in the number of fields as one greater than the number of headers. DM me for the files that I cannot attach here. (Jamie Papp)

There are objects listed that customers should not be loading data into (i.e. - EDI anything). Should we start a list of tables that should not be in DIM?

When you are a new user, it's hard to tell what to do if you want to access a template. I'd like to change up the options on the Welcome Page. Graphic 1: Need a template? Start here. Get started by selecting and object and a template to download. Graphic 2: Ready to import? Select an object . . .. Graphic 3: Pick up where you left off.... Open to other ways to address this, but this is my initial thought.

Since there are a lot of objects to choose from, I'd like to see a way to filter to narrow my choices down to the objects that will be most frequently used such as BOMs, routers, employees, customers, vendors, inventory, item master, GL, etc. This would just make it a little easier for the end user.

I'd like to be able to add the description to the gridview in the column chooser instead of having to click on the string to view it. Table name might also be helpful. It may eliminate the need to have that information in "Additional References" in the Help.

This also goes along with the filtering option, but if the object name could also have the commonly referenced name. For instance, in the Data Import Manager the object for inventory master is Inventory > Part. It would be nice for it to say Inventory > Part (Inventory Master). It's just not super clear, and I know that knowledge will come with time as we use the new Manager, but this would really help the end user.