Delete Change Not Working

Question

Sage 100 2014 
 
 Imported two part numbers using Visual Integrator into the DeleteChange table. Went to the Item Maint/Utility and ran the utility. The parts were displayed with the starting and ending part numbers, each line jhad a unique line no. 
 Clicked Proceed. 
 Printed the two reports that Sage requires during the process, but the parts were not deleted. 
 I went into Item Maint, and deleted the part numbers manually. 
 Does the Delete/Change utility work? 
 
 Also.. I have deleted parts using the BOI, but wanted to try this option. 
 Regards,

sevendogzero · Accepted Answer

Ok. 
 When I added the following fields to my import in Visual integrator: 
 AllFiles, DeleteItems, DeleteItemWarehouses,DeleteItemCosting, DeleteAlternateItems, DeleteItemPricing, DeleteEBMItemsCategories 
 ..and on the [Data Tab] for the import; Set the Import Field Properties as follows for each of those fields: 
 Operation: [Assign] 
 Default Value: ["Y"] 
 
 The items are now gone. Very cool...takes awhile, but it worked. 
 I suppose the field names in the DeleteChange table are somewhat self explanatory, but... 
 Being the curious sort, is there any documentation besides the File Layout in Sage regarding these fields, ..which ones are required, logic etc 
 Thanks for your reply

Sage 100

Delete Change Not Working

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING