Home Page link  

Global Customers "not in balance" and can not close billing cycle

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Global Customers "not in balance" and can not close billing cycle DDowningMO 10-01-2008
Posted by DDowningMO on October 1, 2008, 3:38 pm
Please log in for more thread options


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 ?


--
DDowningMO

HQ 2.0.0110 / RMS 2.0.0110
4 Lanes, 4 Back Office
Server 2003 SP2


Posted by DDowningMO on October 7, 2008, 12:50 pm
Please log in for more thread options


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?


--
DDowningMO

HQ 2.0.0110 / RMS 2.0.0110
4 Lanes, 4 Back Office
Server 2003 SP2



""Todd Berger [MSFT]"" wrote:

> Good morning,
>
> Thank you for posting your question about global customers not in balance.
>
> You would want to run the SQL query from KB 869930 at HQ: Error
> "Customer(s) Had a Balance Error. Accounts Will Not Be Closed." When
> Attempting to Close the Billing Cycle in Store Operations Manager
> https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;869930
>
>
> Todd Berger
> Microsoft Online Support Engineer
>
> Get Secure! - www.microsoft.com/security
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> Subject: Global Customers "not in balance" and can not close billing cycle
> Date: Wed, 1 Oct 2008 12:38:01 -0700
>
> 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 ?
>
>
> --
> DDowningMO
>
> HQ 2.0.0110 / RMS 2.0.0110
> 4 Lanes, 4 Back Office
> Server 2003 SP2
>
>

Posted by DDowningMO on October 9, 2008, 12:31 pm
Please log in for more thread options


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
--
DDowningMO

HQ 2.0.0110 / RMS 2.0.0110
4 Lanes, 4 Back Office
Server 2003 SP2



""Todd Berger [MSFT]"" wrote:

> Good morning,
>
> Thank you for the follow up.
>
> That leading space is not required; and can lead to no records being
> updated.
>
> Please remove the leading space.
>
> Todd Berger
> Microsoft Online Support Engineer
>
> Get Secure! - www.microsoft.com/security
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> Subject: RE: Global Customers "not in balance" and can not close billing cy
> Date: Tue, 7 Oct 2008 09:50:05 -0700
>
> 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?
>
>
> --
> DDowningMO
>
> HQ 2.0.0110 / RMS 2.0.0110
> 4 Lanes, 4 Back Office
> Server 2003 SP2
>
>
>
> ""Todd Berger [MSFT]"" wrote:
>
> > Good morning,
> >
> > Thank you for posting your question about global customers not in balance.
> >
> > You would want to run the SQL query from KB 869930 at HQ: Error
> > "Customer(s) Had a Balance Error. Accounts Will Not Be Closed." When
> > Attempting to Close the Billing Cycle in Store Operations Manager
> >
> https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;869930
> >
> >
> > Todd Berger
> > Microsoft Online Support Engineer
> >
> > Get Secure! - www.microsoft.com/security
> > =====================================================
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> > =====================================================
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > --------------------
> > Subject: Global Customers "not in balance" and can not close billing cycle
> > Date: Wed, 1 Oct 2008 12:38:01 -0700
> >
> > 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 ?
> >
> >
> > --
> > DDowningMO
> >
> > HQ 2.0.0110 / RMS 2.0.0110
> > 4 Lanes, 4 Back Office
> > Server 2003 SP2
> >
> >
>

Similar ThreadsPosted
Global Customers "not in balance" and can not close billing cycle November 6, 2006, 6:48 pm
Close Billing Cycle - Statements print with 0.00 balance April 16, 2008, 3:59 pm
Close a billing cycle October 18, 2006, 3:33 pm
HQ Close Billing Cycle Error June 19, 2007, 5:06 am
Close Billing Cycle - Filter does not work July 16, 2008, 4:52 pm
Close billing cycle early early? June 28, 2006, 1:13 pm
HQ Billing Cycle August 15, 2007, 7:10 am
Closing billing cycle February 4, 2006, 12:07 pm
HQ Billing Cycle Errors August 15, 2007, 1:12 pm
Closing the Billing Cycle October 3, 2007, 7:28 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap