We adjusted 2 customer balances, in August but... We did not run a 350 worksheet before the end of the month of August
Now we can not close the September billing cycle because 2 accounts are out of balance.
I would like information on how to fix this. Is it just a SQL query to set the LastClosingBalance equal to the Balance.
on HQ and Each Store ?
Thank You for your reply
I have tried to run that sql query once it failed due to me not using the overlooked single quote around the acccount number.
But now I need to know another typographical question. The KB article shows a space between the first single quote and the first character of the account number.
Is this leading space required?
Todd
Thanks for the help with the single quotes issue.
BUT, KB 869930 is not the correct method of correcting this problem. KB869930 is for Store Operations. If you run a Worksheet 51 and change the stores the information is not relayed to HQ, and is in fact the store information is reverted by the 401 to what HQ has in its database.
With HQ you need to run the SQL Query script in HQ Administrator
Update Customer Set LastClosingBalance = X Where AccountNumber = 'Y'
(note: Single quotes around Y are required)
To change the HQ database, and run a 401 Worksheet to send the changes to the stores. Then close the billing cycle and run statements.
I have contacted Microsoft and hopefully the KB 869930 will edited and or a new KB article will be posted, I worked with them for a week to resolve this issue.
They alluded that it is different for the "new" HQ
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.