POA 8.1A (091029)

We had a Receipt to the wrong vendor in POA, so we changed the Vendor (POA allows this) and posted the Invoice using the right Vendor. Now we have this error in POA's Integrity Check:

2-RC 00002340 has critical error: Actual number of vendors found not equal to number stored in the header file. This data may be corrupt

"Rebuild" is not available (greyed out).

1. Is there a way to get rid of this error?

2. If changing the Vendor causes a Critical error can you disable this ability in POA?

There is an option in the Company Profile (Interface Tab) which allows you to disallow the changing of a vendor at invoicing.

Thanks PwC. I unchecked "Vendor Change on Invoice" to prevent this problem in the future. Can anyone tell me if there's a way to get rid of the Integrity error? I have a bunch of new errors in POA Integrity Check today after deleting some obsolete item codes. Can we get rid of the errors?? Rebuild is greyed out and not available. Please help.

1-PO 00001218 has a critical error: IC Item ZZ10Y13S does not exist.
1-PO 00001221 has a critical error: IC Item ZZEX6141R does not exist.
1-PO 00001298 has a critical error: IC Item ZZEX6141R does not exist.
1-PO 00001632 has a critical error: IC Item ZZCARDREADER does not exist.
2-RC 00002089 has a critical error: IC Item ZZEX6141R does not exist.
2-RC 00002159 has a critical error: IC Item ZZCARDREADER does not exist.
2-RC 00002300 has a critical error: IC Item ZZEX6141R does not exist.
2-RC 00002300 has a critical error: IC Item ZZEX5920 does not exist.
2-RC 00002340 has critical error: Actual number of vendors found not equal to number stored in the header file. This data may be corrupt

I restored from a back up due to the errrors after deleting obsolete item codes, but still need to know if I can get rid of the 1 error:

2-RC 00002340 has critical error: Actual number of vendors found not equal to number stored in the header file. This data may be corrupt

Thanks,

Hi Susan,

Use the Toolkit for Adagio to merge all obsolete items into a single item number.

Sounds like a good plan! I suppose I can also avoid this in DataCare, "Application Integrity... 795 error(s) Orphan History Records found ................................... FAILED".

BTW, I still need an answer on how to get rid of the 2-RC 00002340 has critical error: Actual number of vendors found not equal to number stored in the header file. This data may be corrupt. Or maybe I can just ignore this error and let it eventually move to history?

Thanks,

Hi, Susan,

We haven't been able to duplicate this issue. We've tested changing vendors on invoice/adjustments and not created any data integrity errors as a result. Something else must have occurred on your system.

As the error cannot be rebuilt, you would require a database repair to get rid of the error. You can choose to ignore the error; however, we cannot guarantee it won't create other problems down the road.

On a brand new POA install, with only one test PO in the whole database, I got the same error message after installing POA 8.1A 091029 - "Actual number of vendors found not equal to number stored in the header file. This data may be corrupt". I hadn't changed the vendor code. DIC was clean.

When I went back into the order, the error had disappeared and all seems OK. I chalked it up as a fluke until reading this thread. Now I think there may be some flaw in the service pack that reported this, even though there is no real error.

Steve

Hi, Steve,

We're still unable to reproduce this error either in the document itself, when posting or in a data integrity check.

Are you able to provide steps and perhaps any other information that might make what you did a little different than what we're doing? Any extra kind of detail lines? Number of vendors (eg. only header vendor or multiple vendors in detail lines and how many)? When exactly did you receive this error? After creating the order? When creating it?

Any more information you can provide could be useful as we are still unable to recreate it and are using this SP also.

I wasn't paying attention and now I can't get it to happen. I'll keep my eyes open for it again.

Hi, Susan,

Do you have a backup of your data from before the errors occurred as well as after? I'm wondering if you could zip it up (would need GL/AP/IC/PO and AR/OE if you send info from OE to PO also, otherwise not) and upload it to our database repair site. We'd like to take a closer look at it.

I'll email you with instructions.

I sent my data a couple of weeks ago.. any updates?

We are still having problems with integrity errors in POA. We get the "actual number of vendors" error every night (I suppose until the receipt with the problem moves to history). Plus we have been getting some other errors, "Quantity on purchase order per item record 6, Quantity on purchase order IR line records, 0". We were able to click Fix to resolve this. We also got the error, "Quantity on Purchase Order (0) doesn't match quantity in IC Locations (0). We were also able to fix this one. Last night we had an Application error in Adagio Inventory saying "Item TV 32CL708 total quantity on hand is 0, but should be 20". Data Repair Phanse - "Correcting Phase 2 Errors Item TV32CL708 has total quantity on hand set to 20.00".

I'm not sure what's going on here but it seems to be stemming from an issue in POA. We haven't done anything unusual or new other than installing a hot fix to correct the due date issue when it posts to AP.

Hi, Susan,

The problem is being investigated and is with R&D.

Does anyone know if there was a solution for the POA issue described by Susan Tennier?

One of my clients is experiencing the exact same problem. They did a data integrity on the weekend, and received the following error on a number of items:

"Quantity purchase order per item record XX, Quantity on purchase order IR line records 0".

The client clicked on “Fix All”. Adagio integrity check then listed the items as “Fixed”:

Item number : XXXXXXXX – Quantity on Purchase Order (0) does not match quantity in IC Locations (0). Location = 1 .. Fixed.

The client thought that everything was okay. However, when they used Adagio yesterday, they realized that “Quantity on PO” is now showing zero for all the items, even those with backorder on PO.

The client is using PO 8.1B(110325) and IC 8.1C(101104) plus other modules.

I will take a closer look at the data but would appreciate if someone can offer a suggestion on how to fix the problem.

Thanks,

If integrity errors were found and 'fixed', but the nature of the integrity problems were such that Rebuild set incorrect values, then the best course of action is to restore data from a backup. The data may also need to be repaired.

Thank you for your response.

The client cannot restore from backup. They did not realize that ALL (yes, "ALL") the “Quantity on PO” in IC module was incorrectly set to zero by Adagio Data Integrity Check until after they had too many transactions.

The incorrect quantity on PO is making the inventory re-order process very difficult, so the client is getting the data repaired.

I recieved the data and ran a DIC in PO.
First time thru it did set the IC Qty on PO to zero.
An Additional DIC in PO then set the IC Qty on PO correctly.
You should always perform the Check/Rebuild until there are no errors.

I'm not sure if this is relevant to your conversation, but we do what we can to fix integrity errors in POA and correct manually whatever possible. If the errors still won't go away in POA integrity check, we let them move to history. When we run integrity check in POA, we do not check history. I know we have some errors in history that we've never been able to resolve, but they don't cause any issue.

Your thread was hijacked by the "Qty on PO" issue. My answer has nothing to do with the the issue you described.