Hi
Did anyone experienced followind problem:
History of transfers does not match while comparing to number of items, For instance:
We had in database (quantity) 3 items. 3 items were sold (this data is in database - if I remember correctly tabel inventory trasfer log). However in table Item (quantity) there is still 1 item (and should be
0).Have you met simillar problem? Perhaps hot fix could resolve that if it is combined with software.
Thank you for help in advance
Use the Item - Movement report to find the model history. Remove the date filter, and add model number or ILCode. The report will show sum of movement change that should match the current stock level, if not, change the quantity with a sql statement like:
update item set quantity=x where itemlookupcode='y'
"Adam" wrote:
Hi,
I have met similar problem. Especially with the client who has connection from POS to the database server working over WAN. When there occurs a network problem during the transaction saving process the saved data may be inconsistent. A sales transaction must update transaction, transactionentry, taxentry, tenderentry etc tables and also change item table quantity. I've seen that in case of connection problems only some information was saved. This is also answer to "Offline Transactions - duplicated" question
18.08.2009 - RMS has problem with data consistency check. Sorry Microsoft, but seems that RMS programmers do not follow SQL Server basic rule - ACID: the ACID (Atomicity, Consistency, Isolation, and Durability) properties are a core requirement for SQL Server and other transactional, reliable database products.Regards, Koit Lahesoo
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.