Close Fiscal Year Error Message

  • Thread starter Classic Boatworks
  • Start date

C

Classic Boatworks

Hello,
When I try to close the fiscal year I am getting a message about credit/
DebitCompanyCurrency. Where is Company Currency? When I go to help it tells
me to go to the company menu and choose foreign currency but it is not on my
menu. So, Accounting won't let me close out my fiscal year.
Thank you,
Dean
 
Ad

Advertisements

R

Rick Sparks

I agree that's an odd error message and I'm sure no expert on this software,
but I do use it regularly. I also may be suggesting something you've already
tried.

Have you looked at a P&L for the month of Jan2010?
If you see anything there, I'd guess you can't close the year until the
accounts that have the items you see there are fully reconciled.... which
would be later in January.
 
C

Classic Boatworks

Rick Sparks said:
I agree that's an odd error message and I'm sure no expert on this software,
but I do use it regularly. I also may be suggesting something you've already
tried.

Have you looked at a P&L for the month of Jan2010?
If you see anything there, I'd guess you can't close the year until the
accounts that have the items you see there are fully reconciled.... which
would be later in January.
I looked and the P&L for January 2010 is empty. I have been not posting to
the new year trying to figure this out.

Thanks,
Dean
 
F

Flexdog

I can help - shoot me an email. A tiny sql script will solves this problem.
 
R

Rick Sparks

If you know the solution, can you explain it and post the code here for all
to see?
I'm not sure it's a good idea for people to download code and execute it
sight unseen.
 
F

Flexdog

This bug exists since 2007, msft didn't fix it, I doubt mamut cares. I won't
go to details of why & how to repro this bug but here it is (cut/paste from
old email):
** Run OA 2009, use datatools.backup to backup your company (database) **
a) Download and install -
http://www.microsoft.com/downloads/...83-4cb2-454e-b908-e805e9bd4e28&DisplayLang=en
Need to use Sql Management Studio (as oppose to more obscure osql.exe)
to run sql script
b) Use Sql Management Studio to execute script below:
SELECT *
FROM dbo.CashPostingTable
WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>
amountDebitCompanyCurrency) AND exchangeRate=100
If you get any rows/data back, proceed to step c), if no result, a more
serious problem - good lucks or buy help.
c) Use Sql Management Studio to execute script below:
UPDATE cashpostingtable
SET amountCreditCompanyCurrency = amountCredit,
amountDebitCompanyCurrency = amountDebit,
companyAmountRemainder = accountAmountRemainder
WHERE (amountcredit <> amountCreditCompanyCurrency OR amountDebit <>
amountDebitCompanyCurrency) AND exchangeRate=100

Now open OA 2009 and try to close the fiscal period.
 
Ad

Advertisements

T

tom_willpa

high quality Soccer jerseys NBA Jersey tracksuit and jackets, GHD
hairstraightener supplier from www.willpa.com

Are you a Retail businessman who bother by the purchase price? China
Cheapest TOP wholesale website can help you

we are specialize in replica sport goods manufacturing in china, we can
offer you all kinds of soccer jersey, NBA jersey,shoes and so on. they are
the best brand replica goods whih are look the same as the original goods.
excellent quality and steady supply for them. we have been marketed in Europe
and American for 3 year. all the goods we offer are AAA quality. our soccer
jersey are Thailand style. If any goods you buy from my company have problem,
we will refund or resend them again. Most of ourProducts have no minimum
order requirements,soyou can shop retail goods at wholesale prices. if you
can buy more than 300usd. We offer free shipping. The more you buy the more
discount for you.

National soccer jerseys: http://www.willpa.com
Club soccer jerseys: http://www.willpa.com
NBA Jerseys: http://www.willpa.com
T-shirt and shirt: http://www.willpa.com
Tracksuit: http://www.willpa.com
Hoody & Jackets: http://www.willpa.com
UGG boots: http://www.willpa.com
Hair style: http://www.willpa.com
shopping Index: http://www.willpa.com

EMS shipping. 7days arrive, paypal accept

want more information pls contact us or check our website: www.willpa.com
 
Ad

Advertisements

C

Classic Boatworks

Once I figured out how to install and use SQL Management Studio...
It worked like a CHARM.

THANK YOU!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top