Sage 100

Looks like it is a week of imports for me! Different client had a server crash a few months back and lost data in the IM_ItemTransactionHistory table during the crash. As far as I can tell, that was the only table affected. We have a backup of the data available (restored it to a backup company) and exported the table, however when trying to import the data from the backup into the history table, I get the ""record invalid or write failed. The record is not in an editable state"" error. Has anyone been able to import to the IM_ItemTransactionHistory table? Is there something I am missing?

You could give this a try to allow imports to the transaction history table. Reference Id: 30-10097 Area: Sage 100 Description: Allowing Import to read only file in MAS Details: How to modify VI Data Dictionaries for 4.x framework 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.

Great! Hopefully this will work for me. The only additional question I have regarding field 20, it doesn't seem as simple as 0 or 1: 20 [extn.ReadOnly=0,extn.FormatType$="""",extn.Validation$="""",extn.NextNum$= 20: """",extn.SetValueIndex$="""",extn.ValidationGroup$="""",extn.ValidationSeqN 20: o=0,extn.EnhancementCode$="""",extn.ChangeTag$=""Replace0""] There was not a particular line that failed, it just said the record failed, so this is on the Item Code, but it appears to be the same on all fields within the key... thoughts?

I have never tried this with the IM_ItemTransactionHistory table and when I look at it I see what you do. I tried changing the value in field 20, position 15 from 0 to 1 and that didn't work either. I have used this method successfully on other files but it doesn't appear to work on this one. Sorry about that.

darn, well thanks for trying!! If I come up with anything I will let you know