Sage 100

Rebuild P/O sort files stops short with message ""Record is missing from ."" Info says ""Error #11: Record not found or Duplicate key on write"" Program: POZUZA Line: 0123 end of story. Rebuild IM and SO work. Customer has major issues with QonPO

What version is this?

4.50.1

What version? To use old terminology, it sounds like you have an item number in PO2 that doesn't exist in IM2 (It's actually the item / whse code combination of the PO2 line) Maybe you can write a report to identify what's in PO2 that's not in IM2

Hmm. it's 4.50 so the file names are different but it might be possible since they do a lot of importing. But wouldn't the VI job skip an item that was not in the system?

Could the line on the PO maybe be missing the warehouse code?

I sincerely doubt that

If that is vs. 4.50 then there is a missing Item/WH rec referred to by a PO line. See if you can find the PurchaseOrderNo$ variable and see which one.

I doubt it has anything to do with V/I just a bad data condition. The error is indicating a item/whse record exists in PO2 that doesn't exist in IM2.

Thanks I will check on it and get back to you guys

I checked on this and the only lines that do not have whse codes are for /C and /M

A missing whse code was probably a longshot anyway. More likely you have an unmatched item / whse PAIR between the 2 tables in question. IOW compare the ItemCode / WarehouseCode records in PO_PurchaseOrderDetail AS A PAIR against the same fields in IM_ItemWarehouse. I just intentionally duplicated your exact error in ABC on my 4.50. Specifically here are 2 ways for you to check: 1. Run this attached quick and dirty report that will show you unmatched pairs between the 2 tables causing your Error 11. OR 2. At the error click on Info then Debug and type these 3 statements: PRINT PurchaseOrderNo$ PRINT ItemCode$ PRINT WarehouseCode$ If you want to put those in the Windows clipboard so you can paste it into Notepad or wherever substitute the PRINT above with: CLIP_BOARD WRITE

Thanks Almoor. The report gave me 2 POs and when I changed the warehouse I was able to complete the rebuild sort file which fixed all the negative quantity on PO