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


Pages: 1
Send Topic Print
Business Status Stuck on Refresh (Read 1485 times)
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Business Status Stuck on Refresh
04/12/06 at 12:57:59
 
When I open the Business Status, it is hung in the refresh mode. Numbers just flash away forever and never stop. I even set the SD-Q setting to not refresh on start up, but it still does.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Business Status Stuck on Refresh
Reply #1 - 04/12/06 at 13:57:06
 
Mine refreshes for a very looooooooooooooong time, but eventually stops.  The numbers aren't right, but I haven't had time to delve into the "why".
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Business Status Stuck on Refresh
Reply #2 - 04/12/06 at 14:29:07
 
I wonder if you initialize the ISBSF file and clear out all the old data would help. I wonder if when it refreshes, it will rebuild prior periods?  By the look of the data in MDB I would say no!
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #3 - 04/15/06 at 08:41:34
 
I first loaded the Business status in September so right now I have data from September to present.
I ran the rebuild in a test company and all my historical data ( some of it not worth much) was lost. The only date was April.  I have not had a chance to check the data.  
I would rather keep all of the current year data and try to fix the numbers.  
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: Business Status Stuck on Refresh
Reply #4 - 04/17/06 at 05:00:57
 
I have had trouble with Business Status as well.  As my company is on the Silver Support Plan, we have requested email support.  The only way we have been able to keep the numbers correct is to rebuild (not refresh) the business status, which wipes out all the old data.  I have our system set up to do a refresh when the program is opened.  The last time I did this, my inventory value more than doubled, and the other numbers went really wacky.  After clearing and rebuilding, the numbers were right again.  
 
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: Business Status Stuck on Refresh
Reply #5 - 04/17/06 at 06:33:21
 
If you can get it right and then limit the type of transactions that occur bfore you check it again, it will help us identify the problems.  (Easier said than done, I know).
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #6 - 04/17/06 at 10:16:26
 
I was checking this out this weekend and noticed that :
I have one batch of Cash Disbursements that was entered on 2/28/06 with a post date  of 03/01/06.  THe numbers are a close match to the error that started in February.  Since it is only close I can't say it caused the error.  But if these transactions were in the temp file on 2/28/06 for a post at a later date, could they have been used to refresh February?  
I can't tell when they were posted since it seems that most of the cash disbursements don't have audit info. (Some do, and since I don't do this I am not sure how the few with audit info are done.)
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
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #7 - 04/17/06 at 12:10:19
 
Here is an interesting development.  On Saturday when I was checking the BS balances, I also checked the Temp files, (BKGLTEMP,BKGLTMP, BKGLTMP2, BKGLTMP3) and all were completely empty.  There were no transactions in GL-O.  THe cash balance was (68780.96), real balance (42878.41).  A carry over from a error in the BS calculation from February.
HOwever...
Today, with NO transactions in THe BKGLTMP files, and with a bunch of WO transactions in the BKGLTEMP file, none of which had anything to do with our cash account, no transactions except for the above WO  transaction s in GL-O, and only one transaction posted to the cash account of 40.69, the current refreshed balance in the BS is (56967.39), a difference of 11813.57.
The WO tranactions in the TEMP file did not have the "99" in the BKGL.TRAN.PERIOD field.  I refreshed the BS and checked again and there still was a 0 in the PERIOD field. of the TEMP file.
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
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #8 - 04/17/06 at 12:41:30
 
Okay, just ignore all my previous ramblings.  I figure that even though when you open the BS and it says refreshing data, it's not really refreshing.  I must not have hit the refresh button on Saturday, which accounts for the difference in Saturday's total and today's.  
New data though, and I suspected something was amiss with this before but couldn't pinpoint it--
There were unposted transaction to the cash account in GL-O which I could see in BKGLTEMP.  
Total in the BS before these were entered- (56967.39)
Total deposits in GL-O and TEMP file- 31442.00
Total in BS after refreshing- (25525.39)-- Correct!
HOwever, we also had in the unposted transactions a Journal Entry to transfer $$ from our LOC to the cash account.  These were not showing up in the BS balance even though they were present in the GL-O as a type GJ.  Unfortunately, they were posted before I got a chance to check the TEMP file to see if they were in there.  However, when I refreshed after the transaction was posted, the balance was the same as before, (25525.39).  The BS is not looking at transfers between our LOC and our cash account, done  as a GJ type.
WE had several of these, in and out,  in the Feb and March months.
Hope this helps.
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
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #9 - 04/17/06 at 13:29:08
 
Well, I think I need a nap!  One of the transactions in the total deposit above was the LOC transfer done as a Journal entry, CR type.  However, there were transactions between these accounts in Feb and March that were done as GJ types that could account for the error in those months.
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Business Status Stuck on Refresh
Reply #10 - 04/18/06 at 10:45:28
 
That is true, GJ types will not be picked up but CD and CR and OT will.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #11 - 04/18/06 at 12:01:31
 
I have instructed my accounts payable person to only use CD and CR type Journal entries when posting to the cash account, (as it should be!)  This should fix that problem.
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
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Business Status Stuck on Refresh
Reply #12 - 04/24/06 at 12:23:45
 
First let me say that I should remove the several posts I last made to this subject!
I have a new piece of data though and this one is for real- ie all the reports document it.  My AP is off by exactly 464.68- AP account is 206870.86 and Business Status is 206406.18.  There are two transactions in the detailed trial balance:
voucher (type RP transaction) entered on 3/28 with post date 4/1 for 464.68- credit (increase) AP acct.
check (type CD transaction) entered on 3/31 with post date 4/1 for 464.38- debit (decrease) AP acct.
Either the voucher was not processed by the Business status or the check was processed twice.
 
---------------
PS it looks like the payable didn't process since my payables for April are also off by 464.68.
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: Business Status Stuck on Refresh
Reply #13 - 04/24/06 at 12:50:00
 
How about this one-
Ran Open Sales Order Report- total $32,939.27 (correct).
Then ran Business Status, after refresh- Open Orders- $82,856.97
 ???
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
Pages: 1
Send Topic Print