Opera 3 SQL SE - Duplicate Warehouses

jcope

Good afternoon,

I have an Opera 3 SQL SE customer with a recurring issue where there are duplicate warehouses assigned to stock records i.e the MAIN warehouse is assigned to stock item CMAT044 > once.

It may be helpful to note that they use SOP, BOM & Batch traceability. The site has bespoke but, knowing what bespoke they have, I'm unsure how that bespoke would cause an issue such as this.

Has anyone else encountered an issue such as this, particularly in a SQL SE system?

Last checked 01/07 and then corrected another 7 stock records today 31/07, to give an idea of frequency.

I use the filter below, delete duplicates and then manually update balances.

Use Opera3SECompany000A

go

select cs_ref,cs_whar, count (*) as qty
from cstwh
group by cs_ref,cs_whar having count(*)>1

Regards

James

richardd

Morning James, we don't have any SOP / Stock customers on SE yet. Sounds very network / retry related. Opera can't write the transaction so ends up writing it twice. If the customers got a managed switch i'd start looking for network issues. Track down the PC(s) posting the transactions and see if you can isolate a PC or user. Thanks for the heads up - Rick