Hi there,

Before the item went missing I had the following showing: 125 Qty on Hand, 6 Qty on PO, 10 Qty on S/O
Sometime after that somebody had deleted the picking sequence on that item. When we tried to post an invoice on the item, it wouldn't let us saying there was no stock available. We then put the picking sequence back but the qty on hand was gone.

If I go to inquire on this item, it now shows:
6 qty on hand ( did a receipt for 6 units)
-6 Qty on PO
-10 Qty on S/O ( sold 10 since then)

but if I go to Inquiries and go to Costing, it still shows that I have 131 units on hand.

I/C valuation compared to GL bal is off by the value of the missing item.

What do I do to correct this

Thanks

Hi Henry

I'm not sure what modules you are using, but assuming it's OrderEntry and Inventory....

1) Make a backup of your data
2) Perform dayend processing in OE
3) Run Data Integrity Check in OE - when it reports errors, click on Rebuild to fix them, then repeat this step until there are no errors
4) Run Data Integrity Check in IC - same situation as OE

If this doesn't work, let us know.

Steve

Hi Steve

Thanks for your help! After running the datacare and the item is still missing

FYI: the datacare program ended with a pop up error message - "Citrical Error: [1213] invalid data directory patch". following is its results detail.

please help


Data Integrity of:
Located on: C:\ADDATA120408\ with extension: CNF
Started at: 2008.12.04 15:21 by System Account
Job: CHECK

Adagio BankRec: File Integrity

Bank Notes Header ... Checked OK
Banks ... Checked OK
Bank Notes Detail ... Checked OK
Batch (Active) Status Control ... Checked OK
Reconcillation Detail ... Checked OK
Reconcillation Header ... Checked OK
Reconcillation Sub Detail ... Checked OK
Distribution Codes ... Checked OK
Distribution Sets Detail ... Checked OK
Distribution Sets Header ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Smart Finder Control ... Checked OK
Import Export file Details ... Checked OK
Import Export File Header ... Checked OK
Import Defaults Field Values ... Checked OK
Profiles ... Checked OK
Rececipt History Detail ... Checked OK
Rececipt History Header ... Checked OK
Statement Info ... Checked OK
Tax Descriptions ... Checked OK

Adagio Contacts: File Integrity

Callback Codes ... Checked OK
Customer Callback Dates ... Checked OK
Smart Finder Control ... Checked OK
Import Export File Details ... Checked OK
Import Export File Header ... Checked OK
Import Defaults Field Values ... Checked OK
Notes Detail ... Checked OK
Notes Header ... Checked OK
Prospect Callback Dates ... Checked OK
Profiles ... Checked OK
Prospects ... Checked OK

Adagio DataCare: File Integrity

Applications ... Checked OK
Email Body ... Checked OK
Email Options ... Checked OK
Smart Finder Control ... Checked OK
History Detail ... Checked OK
History Header ... Checked OK
Job Detail ... Checked OK
Job Header ... Checked OK
Profiles ... Checked OK

Adagio Inventory: File Integrity

Alternative Price List ... Checked OK
Item Alerts ... Checked OK
Bill of Material List Detail ... Checked OK
Bill of Material List Header ... Checked OK
Category ... Checked OK
Smart Finder Control ... Checked OK
Transaction History ... 1 error(s) found ....................................... FAILED
Item Locations ... Checked OK
Item Notes Header ... Checked OK
Item Notes Detail ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Import Defaults Field Values ... Checked OK
Items (2) Additional ... Checked OK
Item (3) Extension ... Checked OK
Items (1) ... Checked OK
Locations ... Checked OK
Multiple Smart Finder Control ... Checked OK
Price List Codes ... Checked OK
P/O Receipt Detail ... Checked OK
P/O Receipt Header ... Checked OK
Profiles ... Checked OK
Report Set Details ... Checked OK
Report Groups ... Checked OK
Report Header ... Checked OK
Tax File ... Checked OK
Tax Groups ... Checked OK
Units of Measure ... Checked OK

Adagio Ledger: File Integrity

Account Information (Old) ... Checked OK
Account Reallocation ... Checked OK
Account Notes Header ... Checked OK
Account Notes Detail ... Checked OK
Batch Control File ... Checked OK
Tr Batch Detail A ... Checked OK
Tr Batch Detail C ... Checked OK
Tr Batch Header A ... Checked OK
Tr Batch Header C ... Checked OK
Account Net Changes ... 1 error(s) found ....................................... FAILED
Account Budgets ... Checked OK
Department Information ... Checked OK
Account MC Buckets ... Checked OK
Fiscal Periods ... Checked OK
Import Export Details ... Checked OK
Import Export Header ... Checked OK
Import Defaults ... Checked OK
Account Master ... Checked OK
Retrieval Batches Info ... Checked OK
Revaluation Codes ... Checked OK
Ledger Source Code ... Checked OK
Account Groups ... Checked OK
Source Journal Information ... Checked OK

Adagio OrderEntry: File Integrity

Order Action Template Details ... Checked OK
Order Action Template Header ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Email Queue ... Checked OK
Smart Finder Control ... Checked OK
Sales Order Header ... Checked OK
Sales Order Header Extension ... Checked OK
History Header ... Checked OK
History Header Extension ... Checked OK
History Detail ... 1 error(s) found ............................................ FAILED
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Sales Order Detail ... Checked OK
Miscellaneous Charges ... Checked OK
Profiles ... Checked OK
Report Set Details ... Checked OK
Report Set Header ... Checked OK
Shipto Addresses Alerts ... Checked OK
Shipto Addresses Extension ... Checked OK
Shipto Addresses ... Checked OK
Salespersons ... Checked OK
Special Prices ... Checked OK
Summary Statistics ... Checked OK
Tax Tables ... Checked OK
Text ... Checked OK
Tax Groups ... Checked OK

Adagio Payables: File Integrity

Control Account Sets ... Checked OK
Vendor Alerts ... Checked OK
Archived Inv Batch Detail 15A ... Checked OK
Archived Inv Batch Header 15A ... Checked OK
Bank Account Options ... Checked OK
Bank Account Sets ... Checked OK
Batch Status Control ... Checked OK
Check Reconciliation Detail ... Checked OK
Check Reconciliation Header ... Checked OK
Check Reconciliation Pending ... Checked OK
Distribution Sets Detail ... Checked OK
Distribution Codes ... Checked OK
Distribution Sets Detail 65 ... Checked OK
Distribution Sets Header ... Checked OK
Smart Finder Control ... Checked OK
G/L Disbursements ... Checked OK
Transaction History ... Checked OK
Invoice Batch Detail 0061 ... Checked OK
Invoice Batch Detail 0068 ... Checked OK
Invoice Batch Detail 0069 ... Checked OK
Invoice Batch Header 0061 ... Checked OK
Invoice Batch Header 0068 ... Checked OK
Invoice Batch Header 0069 ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Import Defaults Field Values ... Checked OK
Manual Check Batch Detail 0022 ... Checked OK
Manual Check Batch Header 0022 ... Checked OK
Transaction Matching ... Checked OK
Vendor Payee ... Checked OK
System Check Paylist ... Checked OK
Profiles ... Checked OK
Recurring Batch Detail 15A ... Checked OK
Recurring Batch Header 15A ... Checked OK
Retainage File AJ ... Checked OK
Retainage File ... Checked OK
Revaluation Criteria ... Checked OK
Terms ... Checked OK
Transactions ... Checked OK
Tax Descriptions ... Checked OK
Vendor ... Checked OK
Vendor Notes Header ... Checked OK
Vendor Notes Detail ... Checked OK
Vendor Extension ... Checked OK

Adagio Receivables: File Integrity

Control Accounts ... Checked OK
Customer Alerts ... Checked OK
Batch Control File ... Checked OK
Customer Notes Header ... Checked OK
Customer Notes Detail ... Checked OK
Customer Recurring Charges ... Checked OK
Customers ... Checked OK
Customers Extension ... Checked OK
Billing Cycles ... Checked OK
Distribution Codes ... Checked OK
Email Cover Detail ... Checked OK
Email Cover Header ... Checked OK
Email Queue ... Checked OK
Smart Finder Control ... Checked OK
Transaction G/L Details ... Checked OK
Transaction History ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Import Defaults Field Values ... Checked OK
Transaction Matching File ... Checked OK
Payment Methods ... Checked OK
Profiles ... Checked OK
Recurring Charges ... Checked OK
Report Groups ... Checked OK
A/J Retainage Batch ... Checked OK
Retainage Accounting Batch ... Checked OK
Payment Terms ... Checked OK
Transactions ... Checked OK
Tax Descriptions ... Checked OK

Adagio SalesAnalysis: File Integrity

Archive/Purge Template Details ... Checked OK
Archive/Purge Template Header ... Checked OK
Smart Finder Control ... Checked OK
Import Export file Details ... Checked OK
Import Export File header ... Checked OK
Import Defaults Field Values ... Checked OK
Item Descriptions ... Checked OK
Transactions ... Checked OK
Online Inquiry Template Details ... Checked OK
Online Inquiry Template Header ... Checked OK
Profiles ... Checked OK
Sales Statistics ... Checked OK

Summary

File Integrity ... 3 error(s) found ............................................ FAILED

Finshed at: 2008.12.04 15:24

Data Repair Phase

Rebuilding Transaction History ... Done

OK, I assume from the last line of your post that you raan the Rebuild function, after the 3 errors were found. Have you run another Data Integrity Check in order to see if there are any more errors?

What are the quantities stored in each Location? Look at the Locations tab within Item Inquiry. This is where the information for On Hand, On PO and On Sales Order is really stored, and totalled across each location for the item. The DIC results you posted above indicate that the 'Item Locations' file is clean.

When you say an item is 'missing', I believe you mean that the item has different quantities than what is expected.

The error 1213 typically is the result of a mismatch between the dictionary and the data. From your posted message, it seems that the dictionary is incorrect and you likely need to re-install Adagio DataCare. You may also need to investigate (with your Adagio consultant, perhaps) if you have any mis-dated dictionaries that has prevented the correct ones from installing.