Welcome, Guest. Please Login.
05/16/25 at 05:00:04
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
GL-R Business Status (Read 2900 times)
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 459
Gender: female
GL-R Business Status
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
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: GL-R Business Status
Reply #1 - 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
 
 
 
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

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

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: GL-R Business Status
Reply #3 - 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??
 
 
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

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

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: GL-R Business Status
Reply #5 - 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????
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Vman
Senior Member
****


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

Posts: 460
Gender: male
Re: GL-R Business Status
Reply #6 - 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?
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: GL-R Business Status
Reply #7 - 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.
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: GL-R Business Status
Reply #8 - 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!  Cheesy
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
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 459
Gender: female
Re: GL-R Business Status
Reply #9 - 08/16/05 at 08:40:37
 
Lynn, when will the patch for this be ready?
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: GL-R Business Status
Reply #10 - 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.
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: GL-R Business Status
Reply #11 - 08/16/05 at 12:06:11
 
Where are the "WO issues" and " Booked PO's" numbers coming from?
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
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 459
Gender: female
Re: GL-R Business Status
Reply #12 - 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??
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

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

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 459
Gender: female
Re: GL-R Business Status
Reply #14 - 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!
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
Pages: 1 2 
Send Topic Print