×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Error #11: Record not found or Duplicate key on write

Error #11: Record not found or Duplicate key on write

Error #11: Record not found or Duplicate key on write

(OP)
Receive this error when trying to run an open purchase order report.

Error
Record: B01522 is missing from IM1UNI.SOA

Details
Error 11 Record not found or Duplicate key on write
Program: POWRCC  Line 1310

Error Information
File: IM1UNI.SOA  IM1 I/M Inventorz Master File
Channel: 3
Key: "B01522  "
Last Channel Opened: 32755
Last Channel Accessed: 3

Application: Purchase Order 4.10
L/M Level: 4.10

I had a similar error the other day for a different part number but it related to Sales Orders when accessing Sales Order Inquiry through Inventory Inquiry.  I resolved that by rebuilding the SO sort files.

I tried rebuilding the IM sort files for this issue since it seems like its holding on to part numbers that no longer exist, like the B01522 seen above.

Any suggestions would be great.

Thanks,

Trevor

RE: Error #11: Record not found or Duplicate key on write

The following is from Sage (Resolution ID 1190)

Error 11 POWRCC 1310, when printing an Open Purchase Order Report

Entry Type: Informational

Product: Sage MAS 90 ERP, Sage MAS 200 ERP, Sage MAS 200 ERP - SQL Server Edition

Application: Purchase Order

Version Reported: n/a

Subject:
Error 11 POWRCC 1310, when printing an Open Purchase Order Report

Possible Resolution:
The item number from the error is currently on an open purchase order and this item number does not exist in the Inventory Masterfile (IM1)   If Data File Display and Maintenance of the IM1 file was used to delete the item or if a rebuild key files of IM1 had been performed and this item(record) was removed by the rebuild and the item was not been reentered then this error will occur.

To resolve the error, the item will need to be reentered in Inventory Maintenance.  Use the exact same key.  If this item needs to be deleted from inventory then use Inventory Management Utilities / Item Delete/Renumber/Merge Utility.
 

RE: Error #11: Record not found or Duplicate key on write

(OP)
Thanks jready.  I will give this a shot and post the results.

RE: Error #11: Record not found or Duplicate key on write

(OP)
That seems to have done the trick.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close