I have been noticing with every update to Adagio our system seems to run slower. We updated to Order Entry 8.1D over the weekend. The process of invoicing seems to have more than doubled in time.

This is the process of simply double clicking on a order (takes 8-10 seconds versus about 2 in the previous version).
Clicking "OK" (takes another 8-10 seconds versus about 2).
The actual invoicing after that is a lot FASTER actually. But the whole process is about 2x-3x times a long.

This is combined with importing 100s of orders from our website which need to simply be double clicked on followed by pressing "OK" to invoice (no bulk invoicing in Order Entry). BTW I am looking into Adagio Invoices for this process.

Any tips for speed drop offs in new versions?

Nick,
Check if you have the option 'Check for duplicate reference' turned on. If you have it turned on try turning it off and see what the speed difference is.

Nick:

Which version of OE did you upgrade from? Did you upgrade any other modules at the same time.

Every upgrade of ADagio adds new features, therefore more overhead. Older computers or those with less than 2GB of RAM can be a problem if you have skipped a number of upgrades.

Chris, I do not have "Check for duplicate reference" checked on.

Douglas, I am running on a quad core @ 3.5Ghz with 8 GB DDR3 and a SSD. Our server is a bit dated though! 2x Xeon 3.0Ghz (Pentium 4 era) and 2GB RAM.

Probably not enough horsepower on the server (RAM specifically). Also, how fast is the network? The faster the better.

Also, which version were you coming from?

We are experiencing the same problem as Nick describes but only for one particular customer's Invoices. If we double click on an Order/Invoice/Credit for any other customer, it's fast (1-2 seconds). However, if we double click on an Invoice for this one customer (who happens to be a very high volume account with thousands of invoices in history), it takes more than 10 seconds to open any of their invoices.

Hi Susan,
If this is happening for a single high volumne customer, look to see if you have 'Include orders in credit check' option turned on in the company profile.

"Include orders in credit check" is not checked and neither is "Check for duplicate reference".

Hi Susan,

Here's the reason V 8.1D is slower than V8.1C:

With large numbers of completed invoices in your current file, they must each be read and perhaps added to the outstanding customer balance to determine if the customer is over their credit limit. Keeping the number of documents in the "Current" file to a minimum will speed up this process.

This feature was added as a result of many customer requests and to make the management of credit limits more accurate.

I printed all Invoices to Softrak Softfax today and they now have the status "Invoice Printed". Hopefully they'll move out of current after day end?

I have found that if I run Order Entry directly from the server, everything is lightning fast. I've transferred some files to and from my server and average roughly 12MB/sec (nearly the full potential of the 100Mb routers and switches). Is it time for Gigabit? or maybe some weird latency issue?

Everthing on your network should be at the Gigabit level, 100Mb equipment is not up to the job.

Upgraded everything to Gigabit this morning. Runs easily 3 times as fast!

Excellent!

Since running into this problem with OE 8.1D, as per Softrak's instructions we moved thousands of invoices out of current. We now have only 7 days worth of current invoices. Unfortunately it is still a problem for our high volume account. In the last 7 days we have over 674 invoices for this particular customer. When entering a new order, it takes 5 or more seconds to open and about the same or more to post. Our staff are complaining that their jobs are taking them excessively longer than before. They keep getting a message that says, "processing credit check".

Is there a way to deselect this credit check on current invoices? Or can we remove the credit check altogether for selected customers? I can try keeping only 1 days worth of current invcoices to see if that helps?

Please advise.

P.S. We already have a gigabit lan.

Hi Susan,

There is an option in the OE Company Profile to 'include orders in credit check'. Try disabling this option, if it has been enabled. This totals all outstanding orders for the customer and includes this amount to determine if the customer is over their credit limit.

Any invoices or credit notes that have yet to be processed by Day End will automatically be included, and there is no option to disable this. Typically there is not as high a volume of shipped invoices that have yet to be Day Ended.

You can disable the credit check for specific TERMS codes.

The plot thickens...

This customer is already set up with a terms code that is set to skip the credit check.

Hmm - perhaps this flag is not being checked in the new feature.

OrderEntry 8.1D is correctly not displaying the credit check screen if a customer is over the credit limit, and the terms code on the customer is defined to skip the check.

There is something else happening; perhaps the timing of what is checked for and when OE knows it can skip it. In order to change this, we'd have to do something in a future service pack.

I guess I'll try limiting current to only 1 day? Staff are saying that it gets slower as the day goes on (as they enter more invoices). Each day the cycle repeats as some are cleared out of current and more are added.

The only complaint I'm getting regarding going to history instead of current for everything is that when they "restore" instead of "copy" an invoice, it seems to do the same thing except it won't copy the serial numbers.

Susan:
I can't speak for Softrak, but that may be a deliberate design decision based on the concept that serial numbers are usually unique and therefore wouldn't be invoiced a second time.

Why would you want the same serial numbers?

OrderEntry calculates the (true) balance outstanding for a customer before it worries about whether it needs to do a credit check.

We will investigate whether the number is expected elsewhere in the program. My guess is that it must work this way because you might change the TERMS to one that does require a complete credit check.

It should only be getting "slower" for this one high volume client. How many orders/invoices are you processing a day for them? Why not just add additional items onto the first order for the day and invoice once?

We want the same serial numbers in the case where we have to credit an invoice back for some reason and reinvoice it again at different pricing.

We cannot add additional items to the first order for this customer because of the way payment comes in. We have to keep each invoice separate for payment match up purposes.

OK. Thanks for the clarification about the serial numbers.

About how may orders/inoices are we talking about daily from this active customer?

The number of invoices per day for this high volume customer varies anywhere from approximately 20 to 200 per day. I've eliminated everything from current now except for 1 day and staff are saying that invoices for that customer are running faster today. We may only have an issue now towards the later part of the day when we do hundreds on the same day. If the "restore" in history would work the same as "copy" in current and include the serial numbers, would also be helpful.

One more thing regarding serial numbers that I have mentioned before that still creates problems here is that we are currently not able to save serial numbers at the order stage (without ship quantites). We are required to designate specific serial numbers to orders long before the invoicing stage and Adagio does not allow us to do this.

Hi Susan,

A HotFix for OrderEntry V8.1D has been uploaded to our web site that skips the reading of the invoices if Receivables has disabled credit limit checking OR or the TERMS code in use on the order/invoice skips the credit check.

Against your data it improved the response time for this customer by a factor of 8.

Merry Christmas!

Nice! What happened to Hawaii?

Please send me a link to the hotfix.

Susan:

Hot fixes can only be obtained from your Adagio dealer.