Welcome, Guest. Please Login.
05/13/25 at 02:24:16
News:
Home Help Search Login


Pages: 1
Send Topic Print
Queries - Business Status (Read 845 times)
karjon
Browser
*


I love YaBB 1G -
SP1!

Posts: 41
Gender: female
Queries - Business Status
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.
 
 
Back to top
 
 
  IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Queries - Business Status
Reply #1 - 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.
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: Queries - Business Status
Reply #2 - 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!
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Queries - Business Status
Reply #3 - 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.  
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Queries - Business Status
Reply #4 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print