DynEntTech / CBKnownIssues

0 stars 0 forks source link

Import Manager, Customer Ship-To, Multiple Issues (CB Tickets PUT NUMBERS HERE) #26

Open davidonelson opened 3 years ago

davidonelson commented 3 years ago

PART 1: There is no way to set the primary ship-to from the legacy system. All ship-to rows import as secondary ship-to. See this sister issue noted under the Customer import: https://github.com/DynEntTech/CBKnownIssues/issues/18

WORKAROUND: (a) load the primary ship-to rows into SQL (b) use direct SQL commands to update the original unwanted ship-to rows (c) Delete the loaded primary ship-to rows from the database

PART 2: Column ShippingSource is required in reality but it is not required in the import manager If this column is NULL the sales order and invoice forms will crash

WORKAROUND: Populate the ShippingSource column with "Item"