Sage 100

v2015 Advanced - Created a new company and copied over ar_customer, ci_item, ap_vendor. In item maintenance I am unable to delete items. I know I can use the utility but I am wondering why items can;t be deleted in item maintenance. Verified the following tables are empty: CI_ItemHistoryByPeriod.m4t , CI_ItemTransactionHistory.m4t, IM_ItemCustomerHistoryByPeriod.m4t, IM_ItemTransactionHistory.m4t, IM_ItemTransactionRecalc.m4t, IM_ItemVendorHistoryByPeriod.m4t, IM_ItemWhseHistoryByPeriod.m4t, IM_LotSerialTransactionHistory.m4t, IM_PeriodPostingHistory.m4t. Any ideas?

First, do a *INFO and make sure you're dealing with the data you think you are

Yes, seems I am in the right folder structure. Perplexing. Not a serious issue but very curious.

Figured it out. I changed the totalquantiyonhand, averageunitcost, totalinventoryvalue fields to 0 in ci_item.

I need to use VI to set the totalquantiyonhand, averageunitcost, totalinventoryvalue fields to 0 in ci_item. These fields are not available. Can someone give me the instructions on changing the field(s) to allow access to these fields in VI? Thank you!

Never mind. Found an old post from Alnoor.

How to modify VI Data Dictionaries for 4.x framework to enable import to fields otherwise defined as read only. USE CAUTION - MAKE A BACKUP DFDM MAS90\providex.ddf Lookup by name to find the VI entity to modify - get the key ID. DFDM MAS90\providex.dde Search by Key. Find the field record you want to modify Edit field 20 (15,1) a zero is importable. a 1 is read only.

Thanks Wayne.

@DougHiggs, you could also have used the File, Run, SVTRNA option to copy the IM masterfile. This still works in 2016 and would have eliminated the details you mentioned.

Thanks Diana. Would have saved me some hassle. Got it squared away now.

Just curious ... why does averageunitcost need to be zeroed in order to delete items?

One might assume that if there is an average unit cost, then there would be some units on hand as well??

I was just experimenting to determine what fields the program was looking at when the message was displayed and the delete aborted. I set the three fields to 0 ( totalquantiyonhand, averageunitcost, totalinventoryvalue), and it worked... so not certain the ave unit cost needs to be set to 0, but it makes sense that it should. If there is an ave unit cost then there must have been some activity for the item.. ditto what Jeff said.