ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Evo Menu & Evo-ERP >> Queries - Business Status
http://www.istechforum.com/YaBB.pl?num=1156506338

Message started by karjon on 08/25/06 at 03:45:38

Title: Queries - Business Status
Post by karjon on 08/25/06 at 03:45:38

I have had no training in Queries and unfortunately attending any of your symposiums is out of the question so I am no sure how the Business Status is supposed to work.

I entered it and waited for it to finish updating. Looking at the figures I am totally confused. They only figure that bears any resemblance to the Financial Statement or Income statement is the COGS. All the other figures are totally bizare.

I wish we had 319 thousand+ in cash. Inventory is 77000 higher and billing are also higher. Deposits, no idea where figure is coming from.

How do we get accurate figures in this program

I would like to be able to use the bar codes and other features but if the figures are so far out of line what is the point.

Title: Re: Queries - Business Status
Post by Vman on 08/25/06 at 04:33:57

I have similar problems with Business Status since it was first introduced, and have found no resolution. Inventory values almost double the actual value; sales figures much higher than actual amounts.
There are procedures for reinitalizing Business Status, but you wipe out any historical data. I do this every month end so that I can get some relatively accurate figures, and then get screen captures. After that, if I run Business Status again, the figures go awry.

Title: Re: Queries - Business Status
Post by cathyh on 08/25/06 at 08:10:28

I have done a lot of investigating to try and verify the numbers in the Business Status and have a lot more confidence in it now.
Some things to keep in mind:
Any activity in the general ledger that has not been posted and so is not reflected in the Balance sheet or Income Statement IS included in the Business Status.

There are temp files that hold the SO. PO, and WO transactions since the last update of the BS. If you are looking at a screen print you did an hour ago ( or even 5 minutes!)and others have done PO receipts or WO transactions, etc. your numbers won't match.

Many of the numbers in the Business status are NOT from the General Ledger, such as Sales Orders, PUrchase orders, and Work Orders. There are other reports that can verify these amounts.

I loaded this back in 2005 and until IS tech revamped it in I think February (?) there were things that weren't working. I don't want to reinitialize since I have corrected many fields as of about March and don't want to lose that historical data-- I just ignore everything before that.

For instance for cash accounts:
1) All of the transactions have to be CD or CR types. (When I first started looking at this I realized (or rather Lynn pointed out) that there were some GJ types and the BS does not look at GJ type transactions. I got the correct balances from the balance sheet, corrected the totals in Maintain Database, ISBSF file, made sure that the accounting department posted ONLY CD or CR type transactions to the bank accounts.)
2) Use only bank accounts in the BS Cash ( at first we had the BS looking at a petty cash account but the BS must only capture transactions to "BanK" accounts set up in AD-B).
After entering the correct balances (sometime in April or May) my cash account balances in the BS have been to the penny ever since.

I have a list of reports that will verify a lot of the numbers seen in the BS. I have sent it to a number of people but haven't heard back as to how it is working for them. If IS Tech is agreeable, they could post it on there website for others to look at.

This is a long post-- too much coffee this morning!

Title: Re: Queries - Business Status
Post by Vman on 08/25/06 at 08:37:53

My company does not use EVO's accounting modules. After reintializing BS, the numbers for the current month(the only month now available) appear reasonably correct. A few days later, after normal activities, such as entering sales orders, completing workorders, posting invoices, etc. if I run BS again, after the refresh the numbers are wrong.
For example, as I write this post, BS says that I have about 83K in open sales orders- but the Open Sales Order report shows 43K. Right now, the inventory value looks right, but after refreshes, I have seen it almost double in value.
I don't know if it's related to specific installs of EVO, or the fact that Accounting is disabled in my install, but BS isn't working right, at least for me and karjon.

Title: Re: Queries - Business Status
Post by Lynn Pantic on 08/25/06 at 13:32:28

If accounting is disabled, then it definitely won't work right because some of the information comes from GL postings. But things like Open SO and Inventory balances should still be reasonably correct. We are still working on fine tuning the activities that are not correctly updating hte totals.