Sage 100

Just upgraded a client from 4.3 to 4.5. When entering items on a S/O, there are several items which, when accepting the line generate a message ""is not on file"", and the line can not be saved. Anyone seen this? So far, I've rebuilt CI_Item.

DFDM CI_Item do you see a lot of blank fields missing data?

Where their IM items imported? If so - check for Primary vendor Division number being populated without a Primary vendor. This will cause this error.

@DianaLaughner, I don't know. They've been on MAS for a long time, and I don't know if any items were ever imported. @AlnoorCassim, no not that. However, in CI_Item, the vendor division is populated, but the vendor id is not. When I go to Item Maintenance and F2 the Primary vendor, I'm getting an Error 41 when I press the Multiple Vendor Lookup button. When I launch the Vendor Task in Item Maintenance, sure enough, the primary vendor is NOF. Ok, now, I go back to 4.3 and see what it looks like there. Thanks so far!

Older versions didn't care about that combination, but 4.5 does. Cleanup means exporting/importing CI_Item, if you have a blank primary vendor number, you need a blank Div number. It's easy to test - take an item that's giving you an issue in SO, edit the item with DFDM, then try it again.

The same situation exists in their 4.3 data, but in Item Maintenance you can see the NOF vendor name. In 4.5, all you see is the blank field. We identified the items with the problem and they will manually clean them up by selecting a new primary vendor, then going to the vendors button and deleting the bad record. That works!

So is the issue in CI_item or in one of the other tables that use the vendor information? Couldn't you just VI the affected records with a blank field for division and vendor?

They don't have VI, and the number of records is not great. I think it might take 2 imports, one to fix CI_Item and one to fix IM_ItemVendor.

this just happened to me on another upgrade - clearing out the division field where there were no primary vendors does the trick, but I don't know what I'd have done without VI - this one had hundreds of records across two companies

Just discovered this on an upgrade but it took me a while... Customer said they couldn't invoice a specific item for a specific customer so I'm thinking it has to be their custom pricing. Nope. They also had issues with item UDF's not coming over correctly so that's where I looked next. Nope. Switched to a different customer, same thing so now I know it is related to the item. Look in IM Maintenance. Item has all the required fields so click on the More and select Vendors - AHA! It shows Vendor Name as Not on file. And THAT'S when I remembered this thread!!! Should have just posted the question here right away...