ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> Business Status Stuck on Refresh
http://www.istechforum.com/YaBB.pl?num=1144875479

Message started by JNAPIER on 04/12/06 at 12:57:59

Title: Business Status Stuck on Refresh
Post by JNAPIER on 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

Title: Re: Business Status Stuck on Refresh
Post by Karen Mason on 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".

Title: Re: Business Status Stuck on Refresh
Post by JNAPIER on 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

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.

Title: Re: Business Status Stuck on Refresh
Post by Vman on 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.

Title: Re: Business Status Stuck on Refresh
Post by Lynn Pantic on 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).

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.)

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.

Title: Re: Business Status Stuck on Refresh
Post by Lynn Pantic on 04/18/06 at 10:45:28

That is true, GJ types will not be picked up but CD and CR and OT will.

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.

Title: Re: Business Status Stuck on Refresh
Post by cathyh on 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.

Title: Re: Business Status Stuck on Refresh
Post by Vman on 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
???