Sage 100

Has anyone seen sales orders just ""disappear"" from order entry and from history? In this case a whole series of orders. I can't even fathom a reasonable theory of how this can happen. Below is a synopsis of what the client has described. They have since reentered the orders so I'm not sure what I can look at/for other than the system activity log. Sage 100 version 2014 with job ops installed. One user entered a group of 17 sales orders, then entered a matching work ticket/sales orders for the same parent items. (This is their normal process.) The sales orders are now gonethere is no record of them in open order table or history tables. All of the sales orders and/or work ticket sales orders entered before and after this group of orders are still there. (Work tickets are entered separately and are not linked to the Sales order). In sales order inquiry if you type in one of the missing order numbers you get an error message ""0021637 is not on file"" (0021637 is the order number). In sales order entry, if you type in one of the missing order numbers you get a message ""The sales order is already used. Do you want to continue?"" And it did allow them to reenter the order number. I""m stumped any thought from the group?

I think the ""sales order is already used"" requires there to be a record in history. Otherwise, how would the system know it has already been used. Someone else may know of another place being checked. If it is missing from both, check the activity log for logins. I have had two clients recently ""move-to-the-cloud"" and the IT company had setup replication and set some users to use one instance and other users to another instance. They were loosing a days at a time. What I found is the activity log was missing login records for those days. This let me know this was an install wide issue not just these individual files.

@JobOps ??

I think the message is generated from records in a sort file. If they were not getting this message I would suspect something like a restore might have happened so the idea of replication is a good thought except for the message The Job ops rep was notified and said they had no idea either.

OMG, @LarryBradford - I had about that exact same thing with a client! It was PO instead of SO. Totally screwed them up for a bit.

I had a client lose 6 weeks of data. The IT company did not believe it was them nor that the client would have to reenter. He called around and found out I was correct.

I will ask the client to find out if replication is used on their server and I'll check the activity log to see if that user was logged in. If I understood her correctly, that user entered other orders that were not missing, but at least I have some more questions for her based on this.

confirm the status of the records using DFDM. maybe they are still there but corrupted and could be fixed.

Or there might be an alternate data source being stored within the Sage share point. Alternate data sources seen by MAS has many symptoms. Just make sure that renamed files, folders and directories no longer have a valid extension, any MAS files being stored within the share are in zip file format, are being stored outside the share point or the MAS files, folders and directories names have been butchered. (AR_Customer.m4t.old Old MAS90, MAS90backup all have the potential to still be read by MAS). I know I probably sound like a scratched LP record but you've looked into most all else Also. Damaged pointers (embedded IO) always seems to go hand in hand with Alternate Data Sources. It wouldn't hurts to run the Embedded IO replacement script as well..

Didn't @DougHiggs have this issue also??

The issue my client had was similar, although it was in Ar customer maintenance. For some of the customers, all of the invoices on the invoices tab were missing. I went to a backup company that had been created a week earlier and all of the invoices were there. My first thought was that someone did a period end and all of the paid invoices were inadvertently deleted based on the setup option "" number of days to retain paid invoices"". That wasn't the case as I checked the library master log file. Just as mysteriously I received an email the next day from the owner stating that the data has re-appeared. The only explanation I can think of is that maybe for the brief period we were looking at the invoice tab there was a process running on the server that was using a lt of resources and preventing the invoices to display... they may have been in the data files (transaction/payment history) all along but just not displaying... I never actually looked at the data, but if it happens again that will be the first thing I do.

Just to update everyone: at this point, Activity log did not provide any clues (thanks for the suggestion to make sure that user showed a login it did show login at the same time each day for several weeks. DFDM on sales order and SO history tables did not help either. Joan, I have not checked for your suggestion yet, and if there is some poorly renamed file or folder, I think that seems like the first suggestions that is even remotely reasonable as a culprit. So I'm going to connect with them again and look for that (their too busy today to let me spend 15 minutes on one of their computers). This whole thing just seems so random. We upgraded them to a new version on 12/19 and for the most part everything has been fine then suddenly we loose 17 consecutive sales orders? If a batch of invoices went missing I could assume network drop during update but sales orders are saved every time you hit the ACCEPT button. Other users were performing data entry in different areas of Sage while this user was saving the orders and all of the other data is fine. Top that off with the fact that this user was switching back and forth entering work tickets and sales orders and the work tickets were still there but the sales orders are not??? The fact that they were getting warning messages of sales order already used leads me to believe a record hit the sort file; yet the sales orders and history are missing??? I typically love puzzles but this one is stumping me.