Re: Product Sales report error

Name    : 
E-Mail  : 
Subject : 

Comments:
: It was a duplicate item in the Product Database. We did the check for duplicates as instructed, but could not get to the duplicate records to delete. However, compressing the database did eliminate both duplicates. We reentered the corrected product and everything came back as before.

: Thanks for the help!

: Butch Bernhardt 

: 
: : Well, it sounds like the products database is the core of the problem, but we rarely (almost never) encounter problems with that one. I suspect a duplicate product number has been created, although that is hard to do within ODP. 

: : Here are some things you can do. You will need to be the only person in ODP and enter with the Design Password. 

: : 1) Check for duplicate product numbers, which are not allowed:
: : * Go to the worksheet menu and display the Products Worksheet.  * Under Worksheet on the top menu bar, select Find, then Find Assistant. 
: : * On the first page, change the "Type of find" to "Find duplicate records". 
: : * Click Next. 
: : * Select the PRODNUMBER field and the Add button. 
: : * Click Done. 
: : If any duplicates are found, you must change the prodnumbers to be unique or delete the duplicate and leave only one of them. 

: : 2) Compress the database to rebuild the index which could be "corrupted":
: : * Go into Design Mode (Ctrl+D) on any view. 
: : * Click File on the top menu bar, then User setup, then Approach Properties. 
: : * Go to  the tab marked "Database". 
: : * Select in the top field the products database and click the Compress button. 
: : * Just in case, then select the ordetail database and the Compress button. 
: : * Then click the OK button. 
: : When Approach is finished with the process, you will be back on the screen where you started. 

: : At this point check to see if the problem has been resolved. If so, you do not need to do any more of these things.

: : 3) Create a new products database:
: : * Go to the worksheet menu and display the Products Worksheet. * Under File on the top menu bar, Export Data. 
: : * Position yourself in the production ODP folder first. 
: : * Then type in a name for the exported product file --- TempProd is a good one. 
: : * In the Database Fields area select each of the fields and the Add button. Stop when you get to "CustNumSave" in italics and do not export that one. 
: : * Click the Export button. 
: : * Exit ODP. 
: : * Use the Windows Explorer to rename the files named products.dbf, products.dbt and products.adx to oldprod.dbf, etc. 
: : * Now rename the TempProd files to products.dbf, products.dbt and products.adx. 

: : Test ODP again to see if things are OK. If not, let me know and we will explore it further. Also check the ODP folder for any files with a type of OYZ. If there is one, post the name of that file so we can fix the problem.

: : Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL: