ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> GL-R Business Status
http://www.istechforum.com/YaBB.pl?num=1119645034

Message started by Lenette on 06/24/05 at 12:30:34

Title: GL-R Business Status
Post by Lenette on 06/24/05 at 12:30:34

I like this new report however I wish I had a better understanding where the information is pulling from. Some lines match actually to the reports I normally run and some don't. The one thing I have found over the past 3 years using DBA is that take nothing for granted. In other words, just because the DBA/ISTS programmers call something "X", doesn't mean the owner of our company calls it "X". Once I realized that, then the software implementation became a lot easier.

Lynn, perhaps you could just expand on the HELP page for this screen.

Lenette

Title: Re: GL-R Business Status
Post by lmk223a on 06/27/05 at 04:04:02

This is what I figured out so far:

A/R balance = G/L account balance
A/R Billings = Sales Journal activity for GL account for A/R
A/R receipts = Cash Receipts Journal activity for for GL account for cash
A/R Discounts = Cash Receipts Journal for GL account for discounts
A/R COGS = Sales Journal G/L account for COGS

A/P balance = G/L account balance
A/P payables = Purchase Journal activity for A/P GL act
A/P payments = Cash Disbursements Journal activity for G/L account for A/P

CASH balance = GL account balance

SALES ORDERS Shipments = SO-O-H monthly invoice report for sales invoices

Title: Re: GL-R Business Status
Post by Lynn Pantic on 06/27/05 at 05:20:36

Very Close. A/R COGS actually comes from Inventory Transaction activity, type S (Shipments) but otherwise you are correct. I also posted a rather lengthy description in response to another post under General DBA Topics - New Menu GL-R that you should read.

Purchasing and WIP activity also pull from inventory transaction data because those GL Postings can be turned off in the defaults. Order balances and bookings are updated as orders are entered and processed.

Title: Re: GL-R Business Status
Post by lmk223a on 06/28/05 at 05:32:12

Has anyone else experienced out of sync balances on the Business Status screen when refreshed?

Our Business Status GL-R does not agree with Cash Balance nor Accounts Payable "payments" processed. The Cash Disbursements Journal amount for payments is correct, but is not being reflected here, nor is "CASH" balance accurate.

The Cash balance is off by the amount of the last A/P run and so is the Accounts Payables payments. This last payment was run after we processed the lastest
June update.

I went to SD-Q and did not find any settings relating to Accounts Payable information, but I did define the accounts that comprise "CASH" and select the automatically update cash feature. These selections also did not result in the proper amounts shown for "CASH" and "AP payments".

Any suggestions??

Title: Re: GL-R Business Status
Post by Lynn Pantic on 06/28/05 at 06:56:16

I just tested and can't duplicate. I picked checks to pay and printed and posted them and the GL-R Cash, AP and Payments values updated properly.

Title: Re: GL-R Business Status
Post by lmk223a on 06/30/05 at 07:31:00

Update on GL-R "A/P payments" and "Cash Balance" -

Today I just ran payables dated July 1st. The July GL-R properly reflects the payments in "A/P Paymens", but the "Cash Balance" is still incorrect because the month of June still does not reflect the A/P checks dated June 24th in "A/P Payments " and in "Cash Balance."

Lynn, Is there anyway I can fix this????

Title: Re: GL-R Business Status
Post by Vman on 07/01/05 at 04:10:53

We use Quickbooks for our accounting and hope to use the Business Status to give us some of the financial data that we use for our end of month processes. In our specific case, the bookings and open order figures are waaaay off. Could we get some more information on how these are generated?

Title: Re: GL-R Business Status
Post by Lynn Pantic on 07/01/05 at 07:30:59

We just found an issue with the order & bookings total - edited orders were getting added in again as a total order amount rather than just an incremental amount. Will have a patch shortly.

Title: Re: GL-R Business Status
Post by cathyh on 08/16/05 at 08:30:18

I just loaded the 6/20 update last weekend and already generated much excitement about this Business Status report; I have been looking also for confirmation numbers and here is what I have found:
AR- Balance- AR-F aging total
AR Billings- SO-O-H Invoice listing for period
AR Receipts- AR-R Payment history for period
AP Payments- AP-R Payment history for period
SO- Open orders- SO-O-A all orders no date range
SO Shipments- I match with SA-B Profit by invoice and also get AR COGS on this report for period
PO Open PO's - PO-I-A Open PO's with no date range
PO Receipts- PO-I-E by period
Inventory value- IN-F for all types no date

So far I can't find any report that matches WO Issues, PO Booked , and SO Booked. I know how to run a SO Bookings report ( my numbers don't match this report however) but how do I run a PO Booked- what exactly does that mean?
This is really a great report- Thanks Lynn and all IS Techies! :D

Title: Re: GL-R Business Status
Post by Lenette on 08/16/05 at 08:40:37

Lynn, when will the patch for this be ready?

Title: Re: GL-R Business Status
Post by Lynn Pantic on 08/16/05 at 10:21:44

The latest version is dated 7/6/05 (available at www.istechsupport.com/dl/620patch.zip) but we have just identified a problem with the Open SO and Bookings totals ongoing balances based on incorrect handling of voushers and backorders. Will be in the next update.

Title: Re: GL-R Business Status
Post by cathyh on 08/16/05 at 12:06:11

Where are the "WO issues" and " Booked PO's" numbers coming from?

Title: Re: GL-R Business Status
Post by Lenette on 08/16/05 at 13:48:15

Lynn, i re-installed the 6/20 patch and still have many problems with GL-R. (First being it thinks the current month is September 2005... please do let this be true.)

Any ETA of the next update/patch??

Title: Re: GL-R Business Status
Post by Lynn Pantic on 08/16/05 at 13:58:41

The "current" month will be the latest month with activity - have you posted anything dated in September? The Back button should take you from September back to August.

Trying to get the patch out this week.

Title: Re: GL-R Business Status
Post by Lenette on 08/16/05 at 14:21:15

HUMMMM.... so I turned my back and Production posted August receiving in September..... I better smack them with my ruler!

Title: Re: GL-R Business Status
Post by cathyh on 08/17/05 at 05:50:36

Hello out there.....
or maybe only DBA knows where these numbers come from? ::)

Title: Re: GL-R Business Status
Post by Lynn Pantic on 08/17/05 at 06:09:02

Cathy -

The WO Issues are itemized on the WO Info screen. JC-E should support the Material amount and JC-E for Labor type parts and/or JC-C & JC-D should support the Labor and Overhead. There really is no report to look at to validate the Booked PO number.

Title: Re: GL-R Business Status
Post by Lenette on 08/17/05 at 06:15:22

Lynn, our "customer deposit" account shows ZERO at the end of July HOWEVER on the GL-R for August it reflects -$1,440.00 ??? Any insight?

Title: Re: GL-R Business Status
Post by cathyh on 08/17/05 at 06:33:46

Well then, what does the booked PO number represent?
(I just know someone is going to ask me this!)

Title: Re: GL-R Business Status
Post by lmk223a on 08/17/05 at 07:03:21

Lenette wrote:

Lynn, our "customer deposit" account shows ZERO at the end of July HOWEVER on the GL-R for August it reflects -$1,440.00 ??? Any insight?

I second this issue. We also have $0 balance in Customer deposits, but GL-R shows a balance on the cash screen and on summary screen. It appears to be a timing issue. Both the cash deposit and application of the deposit to the sales invoice occurred with a transaction date of June 29th. However, only the application of the deposit to the sales invoice shows in June's Business Status under "deposis". The receipt of the deposit is showing up in July. Not sure why.

Title: Re: GL-R Business Status
Post by GasGiant on 08/17/05 at 08:28:16

Lenette wrote:

HUMMMM.... so I turned my back and Production posted August receiving in September..... I better smack them with my ruler!

At least weekly. Oftener if they don't enjoy it.

I'm glad that this is getting fixed now. We are planning our upgrade for this weekend... us less we don't do it until next weekend ::)

Title: Re: GL-R Business Status
Post by GasGiant on 09/07/05 at 11:26:26

Vouchers... looks like internal sales are going to blow our "Shipments" numbers out of proportion. SO-O-H allows us to ignor AR voucher invoices, but will that be an option for GL-R?