Payments on accounts not posting to global customer accounts

I just realized that every since I applied the latest hotfix KB959321 a month ago, when a store selects a customer and retreives the account balance and applies a payment the payment is not reflecting in the balance or the account history. When you look up the invoice for the payment the transaction does show as a payment on the correct account. The client needs to run statements in 3 days and they will all be incorrect. If need be I can manually adjust the balances from HQ however that will not fix the problem. Has anyone else had this happen? Any assistance would be greatly appreciated.

Reply to
Nate
Loading thread data ...

Did you first start having the issue when you installed the hotfix as well? I am logging an issue but if they don't have a fix I'm screwed. Maybe I can back out the service pack but I would have to do it on 4 stores and 13 pcs and could leave me with worse issues.

Reply to
Nate
3x?T]oÜF |ß_ÁÂ@?"]ZÃIã|\Ï5??¶v? o??¶??êîêå??k¬?8àDq?äÌp¯? ÃæàR"©s??@qd ?.¥ñr³?ç¹ lïÃ?Ü{Úü?Ë@>?}Öò¤ÿ=§b?o?ÄEÛs?}a§?x ð%ïü?§E?Á??¹?3,
Reply to
Dee

Hi! I had a problem too when making remote payment from one store to another store. Nothing good found searching this newsgroup; something when searching

formatting link
("problem with posting payments on account for multiple stores"); at last found a solution myself. I post here my solution.RMS version 1.3.1006, HQ and some stores. When making a payment from one store to a transaction made in another store got 401 worksheet error. When debugging HQ Client I got error: "Error -2147217900: There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement." after Upload ARHistoryMirror from store. First I checked that all data is correct (store ID's etc) then checked regional settings and changed decimal separator from ',' to '.' - and everything worked. This is a bug because everything else works with ',' too - transactions, orders and also payments to local store. PS In hotfixes definitions there is also mentioned regional rettings date format problem in one of 2.0 hotfixes.

Koit Lahesoo

" snipped-for-privacy@sunrisepos.com" wrote:

Reply to
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.