When you login to RMS all looks ok, ring up sale still ok, hit enter to finish it and you get the above error number with:
this statement has been terminated source: MS OLE DB Provider SQL Server SQL state: 01000 Native error: 3621 No help file available
SET NOCOUNT ON INSERT INTO transaction shiptoid, storeid,batchnumber, time, customerid, cashierid, total, sales tax, values (?,?,?......... SELECT @@ IDENTITY AS Transaction number
Any ideas would be really appreciated. Version number 1.20151
When you login to RMS all looks ok, ring up sale still ok, hit enter to finish it and you get the above error number with:
this statement has been terminated source: MS OLE DB Provider SQL Server SQL state: 01000 Native error: 3621 No help file available
SET NOCOUNT ON INSERT INTO transaction shiptoid, storeid,batchnumber, time, customerid, cashierid, total, sales tax, values (?,?,?......... SELECT @@ IDENTITY AS Transaction number
Any ideas would be really appreciated. Version number 1.20151
I have seen a similar problem happen with Physical Inventory and Purchaseorder etc where the POS tries to pick the next numerically incremented number for the new entry. In this case it is the TransactionNumber from the Transaction table. I think the way to fix it would be to find all the existing transactionnumbers with this query:
select transactionnumber from [transaction] order by transactionnumber
Either at the top of the list or the bottom will be an unusual entry that doesn't match the others. once you find it, change it with this query:
update [transacti> When you login to RMS all looks ok, ring up sale still ok, hit enter to
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.