Welcome, Guest. Please Login.
06/01/25 at 11:08:45
News:
Home Help Search Login


Pages: 1
Send Topic Print
AR Statements do add up (Read 1270 times)
Theran
Member
**


I'm not a browser,
I'm a low end Bronze
member...

Posts: 70
Gender: female
AR Statements do add up
12/31/06 at 11:39:21
 
I updated to IS Tech Support Update 10/31/06.  This is the first month printing statements using this updated version.  Here's the problem.  The Original Amount is $84.50; the Remaining Amount is $24.50: the Balance is $84.50.  My A/R Aging shows $24.50.  This is the correct amount.  For some reason, ALL Statements for any customer that had deposits applied or partial payments applied show a balance due for the Original Invoice Amount.  I tried printing with different flag settings and keep getting the same results.
 
What's going on?
Back to top
 
 

Teres Heran
Armature Coil Equipment, Inc
DBA Classic, Ver 2004.1 with IS Tech 9/21/07
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR Statements do add up
Reply #1 - 01/01/07 at 19:09:16
 
I just tested.  I entered a new customer and a $1000  voucher.  Then I entered $450 payment against the voucher leaving $550 remaining.  I ran a statemtnt for the customer and it correctly shows the $550 balance.  Send me a screen print of the AR-E screen showing how you are answering all the questions - maybe we are doing something different.
Back to top
 
 

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


I'm not a browser,
I'm a low end Bronze
member...

Posts: 70
Gender: female
Re: AR Statements do add up
Reply #2 - 01/06/07 at 11:49:25
 
How do I send you the screen shot?  By email?  By fax?
I don't see any method of attaching to the post.
I have the screen shot of the settings and of the statement using those settings.
Back to top
 
 

Teres Heran
Armature Coil Equipment, Inc
DBA Classic, Ver 2004.1 with IS Tech 9/21/07
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR Statements do add up
Reply #3 - 01/09/07 at 20:07:38
 
Email it to me - lynn@istechsupport.com
Back to top
 
 

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


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: AR Statements do add up
Reply #4 - 03/02/07 at 15:10:28
 
We are also experiencing this.  It was just noticed after my recent update to 02/14/07, however, it may have existed before that and was just now noticed.
 
I tried to duplicate it in the Demo Data (Company 99 - The Manufacturing Answer), and was successful.  
 
Customer ADV-01 had an open invoice for 4266.90.  I entered a customer payment for $1000 dated 03/02/07 and payment for $500 dated 01/10/07 .  The Aging correctly shows the Account balance of $2766.90.  The Statement (click here) (printed with the option 'Print Items with Open Amounts Only?' set to 'Y' ) incorrectly shows a balance of $4266.90.  The balance column seems to be showing a running balance of the Original Amount and not a running balance of the Remaining Amount.  
 
The 'Balance' column and the 'Total Due' is not correct, but the Aging Breakdown is correct.
 
Additional Information:
I just noticed that if 'Print Items with Open Amounts Only? is set to 'N', and a date is entered for '... items dated on/after' then Open items dated before the date entered Do Not Print (they should, because they are still open, the date entered should only affect fully paid items).
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: AR Statements do add up
Reply #5 - 03/05/07 at 13:48:31
 
Quote from kevind on 03/02/07 at 15:10:28:
We are also experiencing this. It was just noticed after my recent update to 02/14/07, however, it may have existed before that and was just now noticed.

I tried to duplicate it in the Demo Data (Company 99 - The Manufacturing Answer), and was successful.

Customer ADV-01 had an open invoice for 4266.90. I entered a customer payment for $1000 dated 03/02/07 and payment for $500 dated 01/10/07 . The Aging correctly shows the Account balance of $2766.90. The Statement (click here) (printed with the option 'Print Items with Open Amounts Only?' set to 'Y' ) incorrectly shows a balance of $4266.90. The balance column seems to be showing a running balance of the Original Amount and not a running balance of the Remaining Amount.

The 'Balance' column and the 'Total Due' is not correct, but the Aging Breakdown is correct.

The Patch file (214GEN1.ZIP) Installed today corrects the Balance column so that it is a running balance of the Remaining Amount.  Smiley
 
Quote from kevind on 03/02/07 at 15:10:28:

Additional Information:
I just noticed that if 'Print Items with Open Amounts Only? is set to 'N', and a date is entered for '... items dated on/after' then Open items dated before the date entered Do Not Print (they should, because they are still open, the date entered should only affect fully paid items).

The Patch file does NOT solve this problem of not printing open items before the paid item cutoff date.
The cutoff date should not be considered for open items.
 cry
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR Statements do add up
Reply #6 - 03/05/07 at 15:27:48
 
Confirmed and we are already working on patch 2.  We are committed to spending the next few weeks (or months if necessary) cleaning up this kind of stuff.
Back to top
 
 

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


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: AR Statements do add up
Reply #7 - 03/06/07 at 06:36:18
 
I am committed to testing anything that you email to me to test   Wink
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: AR Statements do add up
Reply #8 - 03/06/07 at 08:38:08
 
Which brings up something I have been wondering-- is it possible to set up a separate installation of Evo on just my workstation so that I can install updates there and test before I make changes to the server version?  
As it is I wait for several weeks to install updates since I have some rather faint-hearted users who don't deal well with change, especially change that isn't working.  I on the other hand am always anxious to try out the new stuff!
If this is possible, could someone walk me through it?
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: AR Statements do add up
Reply #9 - 03/06/07 at 08:40:14
 
Fixed and posted.  Kevin, I sent it to you directly.  Please confirm that it is fixed.  It looks good here.
Back to top
 
 

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


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: AR Statements do add up
Reply #10 - 03/06/07 at 08:49:46
 
Quote from cathyh on 03/06/07 at 08:38:08:
Which brings up something I have been wondering-- is it possible to set up a separate installation of Evo on just my workstation so that I can install updates there and test before I make changes to the server version?  
As it is I wait for several weeks to install updates since I have some rather faint-hearted users who don't deal well with change, especially change that isn't working.  I on the other hand am always anxious to try out the new stuff!
If this is possible, could someone walk me through it?

 
I can see this working on most updates. If the update has to change file structures and other utilities to work, you would run into problems. MDB would have issues as file names are added, changed or tweeked.
 
You could do it on a standalone basis by copying your *.B files over to your test machine. This would allow you to do it on somewhat real time data.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Pages: 1
Send Topic Print