SELECT *
FROM PlansBillState
WHERE PlanID IN (
SELECT PlanID FROM Plans WHERE CustomerID = (
SELECT CustomerID FROM Customers WHERE RegNumber = ????? ))You would obviously replace the ????? with their RegNumber
The plan in question will have at least two entries with different UnitTypes. The UnitType specifies which type of charge. In our database UnitTypeID 2 is ongoing fee while 91 is a discount. You can run the following Query to see if yours is the same.
SELECT * FROM UnitTypes
Once you pinpoint the proper date on the proper plan that needs to be changed, use the following:
UPDATE PlansBillState SET NextBillDate = NULL WHERE PlanID = ???? AND UnitTypeID = ????
This will stop any further discounts on this particular plan. If it is still supposed to receive additional discounts next month, you can try adjusting the date accordingly, but I've always just set it to NULL to stop the discounts completely.
Hope that helps.
----- Original Message ----- From: "Melvin C. etheridge" <[email protected]>
To: <[email protected]>
Sent: Friday, March 18, 2005 1:17 PM
Subject: [Rodopi] Rodopi Screwed Discount plans since Feb 28th
OK thanks...now how do you find the next bill date for that paticular customer?
And when can you change it back so that the customer can get billed correctly again?
Thanks,
Mel
----- Original Message ----- From: "Scott Collins" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, March 17, 2005 3:40 PM
Subject: [Rodopi] Rodopi Screwed Discount plans since Feb 28th
Have seen this many times in 5.2sp3. In our experience, this happens when
Rodopi was scheduled to give a discount on the 30th of the month (for
example) and February rolls along and there is no 30th. When it tries to
pull that discount back to the 28th, this happens.... Also can happen
throughout the year with months that have no 31st.
To stop the discounts I've had to manually change the NextBillDate in the PlansBillState table to NULL.
Scott Collins ISDN-Net
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Melvin C. etheridge Sent: Thursday, March 17, 2005 1:13 PM To: [email protected] Cc: [EMAIL PROTECTED] Subject: [Rodopi] Rodopi Screwed Discount plans since Feb 28th
Rodopi KEEPS giving about a dozen customers WEIRD ass credits over and over
even after I go in debit the account.
All dated on the 28th of Feb!! I'll do the debit to fix it and rodopi goes
back and gives another credit...but they are all dated 28 Feb!!!
They should just get a $4 discount for their 1st 6 months of service.
Anyone else seen this?
Mel
...see below:
Feb 01, 2005 Check Payment -- CK#2182/mce -- Thank You 18.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Ongoing fee from Feb 28, 2005 to Mar 27, 2005 18.95
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Basic 14.95 Dial-up (1 Login, 5 Emails) -- User name:
kbennett -- Discount from Feb 28, 2005 22.95 CR
Feb 28, 2005 Check Payment -- MCE - CK#2229 -- Thank You 14.95 CR
Mar 07, 2005 Debit Adjustment -- Correct Software Billing Error/MCE
68.85
Mar 07, 2005 Credit Adjustment -- Discount/mce -- Thank You 4.00 CR
Mar 08, 2005 Debit Adjustment -- Correct Software Billing Error - MCE
22.95
Mar 12, 2005 Debit Adjustment -- Correct Software Billing Error - MCE
45.90
Mar 15, 2005 Debit Adjustment -- 22.95
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 3/15/2005
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body.
Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
