1. Home
  2. Point-Of-Sale Software
  3. Problems with account payments for transactions from different sto

Problems with account payments for transactions from different sto

Hello, Our Client use RMS 1.3Refresh 1006. Database on SQL 2005.

We have encountered a big problem when trying to pay in one store (let's say store A) for the transactions from other store (store B). All the information are saved in the table ARHistoryMirror but when the system tries to send data to HQ during worksheet 401 Data Upload there is an error "-2147217900: There are fewer columns in the INSERT statement than values specified in the VALUES clause. Number of values in the VALUES clause must match the number if columns in the INSERT statement". Transactions stays not payed. Nothing hasn't been changed in the RMS tables structure. Also paying for transactions from store A in the same store that transactions were made are ok so the problem occurs when there is a record in ARHistoryMirror table. What's the problem?!

Thanks for any help.

Reply to
Hubert Mikołajczyk
Loading thread data ...

Hello, Our Client use RMS 1.3Refresh 1006. Database on SQL 2005.

We have encountered a big problem when trying to pay in one store (let's say store A) for the transactions from other store (store B). All the information are saved in the table ARHistoryMirror but when the system tries to send data to HQ during worksheet 401 Data Upload there is an error "-2147217900: There are fewer columns in the INSERT statement than values specified in the VALUES clause. Number of values in the VALUES clause must match the number if columns in the INSERT statement". Transactions stays not payed. Nothing hasn't been changed in the RMS tables structure. Also paying for transactions from store A in the same store that transactions were made are ok so the problem occurs when there is a record in ARHistoryMirror table. What's the problem?!

Thanks for any help.

Reply to
Hubert Mikołaj

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.