ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AR Statements do add up
http://www.istechforum.com/YaBB.pl?num=1167593961

Message started by Theran on 12/31/06 at 11:39:21

Title: AR Statements do add up
Post by Theran on 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?

Title: Re: AR Statements do add up
Post by Lynn_Pantic on 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.

Title: Re: AR Statements do add up
Post by Theran on 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.

Title: Re: AR Statements do add up
Post by Lynn_Pantic on 01/09/07 at 20:07:38

Email it to me - lynn@istechsupport.com

Title: Re: AR Statements do add up
Post by 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) (http://spectronics.com/dba/statement%20Problem.pdf) (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).

Title: Re: AR Statements do add up
Post by kevind on 03/05/07 at 13:48:31

kevind wrote:

The Patch file (214GEN1.ZIP) Installed today corrects the Balance column so that it is a running balance of the Remaining Amount. [smiley=vrolijk_26.gif]

kevind wrote:

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. :'(

Title: Re: AR Statements do add up
Post by Lynn_Pantic on 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.

Title: Re: AR Statements do add up
Post by kevind on 03/06/07 at 06:36:18

I am committed to testing anything that you email to me to test ;)

Title: Re: AR Statements do add up
Post by 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?

Title: Re: AR Statements do add up
Post by Lynn_Pantic on 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.

Title: Re: AR Statements do add up
Post by JNAPIER on 03/06/07 at 08:49:46

cathyh wrote:

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