[Rodopi] Rodopi AR Question

[Dessa B. Hix]

Title: Rodopi AR Question

I have been told that The sum of the open AR and closed AR does not always equal the AR report that includes all accounts.  I never print them separately, so I can't say for sure.  We do not use Accrual Accounting (under Configuration>Billing Configuration>Billing policies).  I can always balance AR, unless a customer has been upgraded to a plan that includes a discount, which causes Rodopi to change history!  (When this happens, Rodopi gives the customer a discount with an effective date in the past.  My senior systems administrator was always able to find the transaction with an entry date in the current month but an effective date sometime in the past, and he would delete the entry, which restored AR to its correct balance.)   Compare the two AR figures you have printed with the AR that shows all accounts.  That number, plus Non-recurring and Recurring sales for the month, less Total Payments for the month, will equal current AR in my experience.  If you run an AR report today for any date in the past and it is different from the report you printed in the past, discounts may be your problem.   Dessa Hix ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 6:08 PM Subject: [Rodopi] Rodopi AR Question Hi all!  It's been a long time since I posted to the list but I have recently had a difficult time figuring something out and I know there are some experts here that might send me in the right direction.  This may seem pretty basic, but I just can't get the numbers to add up. On the first of each month, we print both opened and closed accounts receivable reports.  We also print recurring and non-recurring sales reports for the prior month, as well as the payments report.  When I take the prior month's two AR report totals, add the two sales reports totals for the prior month, and subtract the total payments for the prior month, why does this total not equal the balances on a beginning of the next month's AR reports?  Similarly, if I take the AR balance on the beginning of a month, add all of the DebitMovements for the month and subtract all the CreditMovements for the month, shouldn't the result equal the end of month AR balance?  Taking the Rodopi reports or the data straight from the database gives me the same result which doesn't match the Rodopi AR balance as I think it should.  Am I missing something here?  I have been working on tweaking our company's accounting processes and discovered that our bookkeeper was just putting an adjusting entry to a clearing account to balance the AR in Quickbooks to the AR in Rodopi but since we are already putting all of the sales and payment transactions from Rodopi into Quickbooks, I would think this should always match but now I see it doesn't even add up within Rodopi.  Any help would be greatly appreciated.  TIA! John Prather, CEO Brand X Networks, Inc. "The standard against which all others are measured" Quality VISP and Outsourced Support Services 559.420.5210 voice 559.490.8630 fax