Sage 100

Verison 2014 standard. Trying to import a CSV file to IM_Item CustomerHistoryByPeriod. There are only a few fields. All are valid but the import still fails. See below screen shot. Any ideas? I searched the current and old KBs and didn't see anything useful.

Hey Doug, Make sure the year and the month are not in the future as set in Inventory Options. Had the same problem. You must import to a prior period

Doug were you trying to create new records or update existing ones? If the 5 fields that make up the key end up creating a new key in the data file, the business object itself (IM_CommonHistory.pvc) specifically stops you with the error you're getting. IOW, most IM History files won't allow creating NEW records including this one. And it can't be fixed with a dictionary tweak either.

In your screenshot the CustomerNo and ItemCode look similar. Is the source data correct?

Doug, I believe Alnoor is correct in that it wont let you create new records. I guess I was importing into existing records..

@AlnoorCassim The source data is correct. That particular customer has some items numbers that begin with the customer number... strange but true. Well that sucks... I guess I will have to import to SO invoice data entry and update the sales journal to populate the history. Thanks @AlnoorCassim and @KennyDaniel for your suggestions.