[Rodopi] Rodopi AR Question

[Dessa B. Hix]

Title: Rodopi AR Question

<snip>Why does an AR report created on the same day as the Towards Date differ from a AR report for the same Towards Date created a week later?    It should show the same answer if you include all payment types, both debit and credit balances, and all statuses (stati?).  In my experience (v5.2, sp3) I can view an AR with any Towards Date and the answer will match the answer I recorded the first time I took that total.  Again, if a customer is upgraded to a plan that includes a discount, history will change until the erroneous discount is deleted from the database.  Perhaps you are not including all payment types, both debit and credit balances, and all statuses?   Dessa Hix     ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 14, 2004 12:39 PM Subject: [Rodopi] Rodopi AR Question Thanks for the thoughts so far.  I'm still trying to figure this out.  We have numerous Rodopi realms and in one month I found an inconsistent AR balance that I ultimately determined to be an account that was deleted during the period throwing off the the balance (name changed to test test and the delete test users script run).  The only way I found this was by looking closely at beginning balance and all the transactions on a user by user basis and finding a user no longer existed that was in the beginning AR report, but this realm only has a hundred users.  The one that almost never has consistent AR balances has more than 4,000 users in it and would be very time consuming to analyze this way.  I have confirmed with everyone that has access that they have not deleted any accounts in this realm in more than a year.   We are not using the Accrual Accounting option.  From what I can tell looking at the stored procedure for the AR report, it sums all transactions from the beginning of time to the Towards Date (DebitMovements & CreditMovements) and the balances from the original import of users to Rodopi .  This is what I would expect it to do, but the answer to the following question may lead to me understanding why the AR balances are inconsistent.  Why does an AR report created on the same day as the Towards Date differ from a AR report for the same Towards Date created a week later?    I think I am losing my mind....   John From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dessa B. Hix Sent: Friday, May 14, 2004 9:18 AM To: [EMAIL PROTECTED] Subject: [Rodopi] Rodopi AR Question When I use the phrase Total Payments, I'm referring to the Rodopi P&A report called Payments Total.  Every transaction in Rodopi (including any debit or credit adjustments) will appear on either Payments Total, Recurring Sales Total, or Non-Recurring Sales Total.  The sum of those for a given period added to the AR total at the beginning of the period will give you AR for the end of the period, in my experience.  If you use customized reports that don't include every transaction type, be sure that the total of your individual reports equals the three Rodopi Total reports.  If that doesn't equal, AR can't equal.   I chose not to use the Accrual Accounting option because I wasn't sure what Rodopi would do with it--I just didn't trust non-accountants to write software that sophisticated.  It could certainly be the problem.   Dessa Hix ----- Original Message ----- From: Penny McLaughlin To: [EMAIL PROTECTED] Sent: Friday, May 14, 2004 10:36 AM Subject: [Rodopi] Rodopi AR Question Dessa:   How about debit or credit adjustments�should they be taken into consideration?  I am having the same problem as the gentleman and have yet to figure it out.  I wonder if it is because we are both using accrual accounting?   Penny   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dessa B. Hix Sent: Friday, May 14, 2004 7:49 AM To: [EMAIL PROTECTED] Subject: [Rodopi] 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