Sage 100

I have a client who has been experiencing significant delays in posting the Daily Sales Order Sales Journal. Today, she called to tell me that she kicked off batch with 15 invoices in to (average 2 lines per invoice). 3 hours later, it is still running. Outside of rebuilding key and sort files, any ideas as what could be causing the issue? It appears to be limited to SO invoices as no one else is having problems with other processes. We tested from two different machines under two different user id's. MAS 200 is running as an application on the server.

Does it happen in a test company? When you did the rebuild of keys, did you include the inventory files?

anything happening during that update - credit cards, avalara, or just standard invoices being posted?

What happens if you run it from the server?

I haven't done a rebuild yet. It was reported to me about 30 minutes ago. I went on-site earlier to get a copy of their MAS90 directory and it is 20.6 GB in size. As such, running a rebuild is no small task. I was getting a copy of their data to work on some custom reports for them in Work Order and BOM and wanted samples of live data to make sure what I plan to do will work from an information stand point and from a time-to-process stand point. I plan to do some testing at my office on this issue as well once I get the data. I will run the process here and see if I get the same results, thus isolating the server. If I get the problem here, it is data related and I will run the rebuilds to see 1) how long it takes to process and 2) if it resolves the problem. I am looking to make sure I am on the right path to fix the issue or if there is some other elephant in the room to which I have not been introduced. (Sage 100 has a whole herd of them so better to find them with friends than when in front of an irritated client.)

What version are they on @ShawnSlavin? I had a similar issue Sage 100 Advanced, 4.5 with a PO Receipt of Invoice (the only one in the batch) for one line, with a quantity of 803,000 that would hang during printing (to PPO) of the register. I deleted the ROI then rebuilt PO keys and sorts and reentered the ROI. The printing of the registers was back to normal speed.

Is this customer using Sage CRM? I ran into an issue where updating SO invoices ran into a bad script in CRM. All other posting processes were running fine. You may want to try posting invoices in a backup company (without CRM).

OK @KerryEsser , you got me ears perked up. They do indeed have Sage CRM and this morning were having trouble creating sales orders via CRM. They were able to create SO's directly through Sage 100. Are you suggesting the backup company as a temporary test to isolate CRM as the culprit? @EricAnderson , they have credit card but not avalara. I will find out if any of the invoices involved credit card sales.

@Moria Groggin, They are on 4.5. I am confirming PU level tomorrow.

Posting invoices in the backup company is what helped to isolate CRM as the culprit for our customer.

Same here re: Sage CRM, although I'm unaware how it was ultimately resolved because the client (4.5.3) typically handles their Sage CRM related stuff on their own. Also, if it works fine in a test company which isn't integrated with Sage CRM, you can then try disabling the Integration Engine to see what happens in the live company. Do you know if this issue is happening on all workstations? I think with my client we had thoughts that it was somehow related to the workstations but I can't be sure. @KerryEsser, do you recall how your client ended up resolving it once they isolated it to Sage CRM?

The customer had an issue with a custom script in CRM that updated customer records. The invoice update triggered the script to run for ALL customer records for each invoice. Turning off the script and changing the trigger resolved this issue.

OK, more information. MAS version 4.50.4.0. CRM version 7.1.D.1. While I was on-site today resolving another issue, I watched a sales person save a sales order from which he created an opportunity in CRM. It took MAS over 3 minutes to respond after hitting the Accept button on the Sales Order. He told me this typically took between 2 and 5 minutes to save a sales order linked to an opportunity. It really is looking like something is going on with the sync between MAS and CRM. What is everyone's experience with this interface? Is it typically quick? Does it put a small drain on resources or does it put a boat anchor on a sprinter like my client is experiencing?

Wow, this almost gives the sales person enough time to write the order via pencil.................

Ouch!

The achilles heel of Sage CRM is the integration with Sage ERP 100. Sage wants to sell more CRM, but there is a huge difference between what customers expect in terms of performance and integation between CRM and ERP and what Sage is actually delivering. Peformance is slow and there are a number of integration issues that Sage has not resolved.

@MyronStevenson I don't have past experience with CRM. My client is seeing excessive interface speed issues. Is the 10 to 15 minute per SO invoice posting time consistent with your experience? Isn't there something we can do to speed this up? Surely to heaven there is something we can do. The servers are fairly healthy, they are on the same gigabit switch so network communications can't be that slow. Is the interface that inefficient?

Are they using the SOTAMAS ODBC driver or some version thereof?

We haven't ever seen behavior like that with the SageCRM and Sage100 integration, so I don't believe that's typical. It would be nice to have some input from @PeterWolf on this if someone wants to wake him up for a few minutes.

Still kinda early for him. He is probably trying on the silk pajamas for tonight's Hefner act!

Sorry all.. I wasn't actively monitoring because the initial issue didn't mention crm. We have assembled a bunch of ammunition regarding the crm-100 integration and I have a meeting later today with sage team responsible for this. I will report back to the group after. In the meantime, if anyone wants to jump on the bandwagon and help me raise visibility on this stuff, please email me details of any specific client headaches. I don't need client details but rather details of integration issues. And number of clients that are having problems. That would be enormous help in driving action on this. I would greatly appreciate your contribution and it will help me stress that it's something that needs to be addressed. Email pwolf@azamba.com