Generate Inventory Worksheet - Record already exists error

[johnhugh]

Hi,

I'm using Accpac 5.6 with I/C PU3.
When generating an inventory worksheet I suddenly receive a "Record already exists" error.
Never used to get this error.
The error only hsows up when I sort by Picking Sequence. Sorting by Item number works.
Any ideas what might be the cause of that error?

 

[Jay Converse]

Analyze your data, you have a duplicate record.

 

[johnhugh]

Thanks for your reply tuba.
There error only happens when I sort the inventory worksheet by picking sequence.
But a picking sequence surely can be duplicate cause you can have more than 1 item on a shelf.

How would I analyze my data? Where would you start?

 

[Jay Converse]

Rvspy

 

[DjangMan]

There are a few tables (three, I think) involved with Phys. Inv. so it could be within one of the tables dealing with the different units of measure.