Sage 100

Customer on v2014 Standard PU4 is getting an error when trying to print WO Operation tickets. The error is: ""Record: 0049212 is missing from SY0FRM.SOA"" which is referencing a WO number that does not exist. Info gives you Error 11, same key and file but references WO1 Work Order Masterfile. True, it does not exist so I analyzed and relinked WO2 - no errors found but then when I tried again, got the same error but now referencing WO3 OperationDetail which I then rebuilt and a record for that WO number was removed. Rebuilt WO sort files, same error. Thoughts??? @BethBowers ??

Hi - this section of the program is reading WOX, records that start with ""6"" - if you debug, you can print next_ky$, which shows you the record in WOX that is being read. it is trying to read the work order that is in next_ky$(12,7) .... it is reading it on channel wo1_chan_vall so you can also print fid(wo1_chan_vall) and see if you get the WO1 file - if you get something else, then the wrong file is open on that channel......

Thanks @JeffFiddelman but are you saying to type next_ky$ in the Debug window? That gave me a syntax error.

sorry was not specific enough - in the debug: PRINT NEXT_KY$ also PRINT WO1_CHAN_VALL and PRINT FID(WO1_CHAN_VALL) ...... on 3 different lines, you have to type PRINT or ?

Never mind - I found that WO referenced in WOX and it WAS a 6LAYUP record. Deleted it and all is well. Thank you, thank you, thank you @JeffFiddelman !!!