I'm getting errors in the Sales Order Detail table whenever I run a Data Integrity Check or Datacare on the Adagio OE module. A repair/rebuild fixes the errors. I assume those errors are caused by Edisoft's Merchant software, but I don't know for sure because I'm not getting any detailed information on those errors (see attached screenshot). I checked the 'Show detailed information' (something like that) box, but this is all I'm getting.
How do I find out what exactly the errors are? Things like Sales Order Number, the field name(s) etc.?


Thanks in advance,

Andre

I forgot to attach the screenshot. Here it is...

Andre

Hmm... Either I must have overlooked something blatantly obvious in the Datacare manual or no one appears to know the answer to my question... Which one is it? I hope it's not the former... Is it the latter? Or is there someone out there who knows the answer? If so, please...;-)

Thanks!

Andre

Hi Andre,

The screenshot link doesn't work for me - could you repost it?

Thanks

Here it is again. Thanks!

Andre

Ok. I just tried uploading the screenshot again. Everything seem to work, but when one tries to download the file - it's not there. Maybe something you should check on your end?
In the meantime, I have uploaded there file here:

http://xserve2.companion-group.com/~akuehnemund/Picture2.jpg

Hi Andre,

The File Integrity Phase just checks the indexes against the data file. This means that there is a key/item mismatch.

The rebuild of the index will always fix these errors. If the second phase then proceeds without errors, then it's likely something that EDIsoft is doing.

I wouldn't be overly concerned if you haven't noticed anything unusual.

Thanks, Andrew! We haven't noticed anything yet, but at the same time, I wouldn't want to find out there's a serious problem several weeks down the road.;-)
Based on your response, I assume it's OK to not worry about it too much. The second pass fixed whatever the problem was. I still think it would be nice to get a little more detail during the DIC.

Thanks again,

Andre

I agree about the "more detail". We'll see about making it a little more useful.

Thanks for using Adagio!

Thanks for understanding! You can't imagine how much happier I am using Adagio compared to ACCPAC Plus.;-)

I checked with the guy who runs Edisoft's Merchant software to process our EDI orders. He showed me how he posts and order from Merchant to (ACCPAC) Order Entry. We don't use ACCPAC OE anymore, but Merchant still thinks it's talking to ACCPAC. He showed me that the first time he ships an order from Adagio OE (using the Ship All button), he gets an error for every line item in the order. I didn't write down the exact error description, but it's something along the lines of 'error deleting entry from Order Detail'. I assume it has to do with moving the item quantities from the 'ordered' colum to the 'shipped' colum.
He acknowledges the errors and gets to post the order at the end. The next order he ships won't have those errors anymore. It's only the first order he ships after importing it from Merchant.

Anyway, I know there's nothing you guys can do about it and I doubt Edisoft is going to fix this... I just want to describe what happens in case someone else encounters this issue. Supposedly, Edisoft is working on a Merchant for Adagio version of its software. In the meantime, this will work for us.

Cheers,

Andre

When you start OE after posting orders from Edisoft, Adagio runs a routine to update the orders, just as it would if you had entered them directly in Plus. I assume this adds fields that are in Adagio but not in Plus.

If Adagio OE is already open when you post orders from Edisoft, this updating would not happen. Does the same error during "Ship All" happen if OE is closed when Edisoft posts and then Adagio OE runs the updating when it is opened?

Hi Kate:

I'll have to check on that. Interesting question.
We're now leaning towards a different pice of software as being the culprit, though. Someone with UPS set up a connector between our ACCPAC Plus data and UPS Worldship some time ago. One enters the ship to code in Worldship and the rest of the data gets pulled from Accpac into Worldship via the ACCPAC ODBC Connector.
What we have been experiencing for a couple of weeks now, is that whenever anyone open Adagio OE or accesses an order, Adagio pops up a message saying order postings have to be updated. This happens even if no one is using Edisoft. The ODBC connector, however, is up and running all day long.
We're in the process of looking into Shiplinx as a replacement.

Andre