[Citrusdb-users] adding credit to an account

[Victor Ientilucci]

I am testing the system. When I say that an account has received a
over payment, I want to credit the account. It seems to fail because it
cannot get a master_service_id.

$query = "SELECT id,options_table FROM master_services ".
"WHERE category = 'credit' ".
"AND organization_id = '$organization_id' LIMIT 1";


This returns nothing. Should I create a service that has a category of
type "credit"?
What other attributes/values, should it have?

Also, how can I tell how much is currently owing on an account?

Thanks.

[Victor Ientilucci]

I got the credit part. It seems my installation of the system, did not
come with the example service as mentioned in the doc. thanks.

---
Victor Ientilucci
President
Mega Website Services
416-779-6969
***@megawebsiteservices.com
http://megawebsiteservices.com

Post by Victor Ientilucci
I am testing the system. When I say that an account has received a
over payment, I want to credit the account. It seems to fail because
it cannot get a master_service_id.
$query = "SELECT id,options_table FROM master_services ".
"WHERE category = 'credit' ".
"AND organization_id = '$organization_id' LIMIT 1";
This returns nothing. Should I create a service that has a category
of type "credit"?
What other attributes/values, should it have?
Also, how can I tell how much is currently owing on an account?
Thanks.

[Victor Ientilucci]

When I added a credit to the account, the next billing cycle tried to
bill the account for the same amount of the credit. DOes the credit
service need a special attribute ?

---
Victor Ientilucci
President
Mega Website Services
416-779-6969
***@megawebsiteservices.com
http://megawebsiteservices.com

Post by Victor Ientilucci
I am testing the system. When I say that an account has received a
over payment, I want to credit the account. It seems to fail because
it cannot get a master_service_id.
$query = "SELECT id,options_table FROM master_services ".
"WHERE category = 'credit' ".
"AND organization_id = '$organization_id' LIMIT 1";
This returns nothing. Should I create a service that has a category
of type "credit"?
What other attributes/values, should it have?
Also, how can I tell how much is currently owing on an account?
Thanks.

[Paul Yasi]

You should certainly have had the Example Service and credit entries,
not sure why those would not be there. That sounds like the initial
installation of the citrus.sql file did not complete correctly.

Regarding the credits, they are added to the customer's services
listing, and are applied when the next bill is created. So if a
customer has an upcoming bill for $20, but has a credit for $5 on
their account, the next bill will total $15.

In the dollar amount for the credit you need to put a positive amount,
eg, 5 not -5, it will do the subtraction for you.

Paul

On Wed, Jul 27, 2011 at 2:42 PM, Victor Ientilucci

Post by Victor Ientilucci
When I added a credit to the account, the next billing cycle tried to
bill the account for the same amount of the credit. DOes the credit
service need a special attribute ?
---
Victor Ientilucci
President
Mega Website Services
416-779-6969
http://megawebsiteservices.com

I am testing the system.  When I say that an account has received a
over payment, I want to credit the account. It seems to fail because
it cannot get a master_service_id.
$query = "SELECT id,options_table FROM master_services ".
    "WHERE category = 'credit' ".
    "AND organization_id = '$organization_id' LIMIT 1";
This returns nothing.  Should I create a service that has a category
of type "credit"?
What other attributes/values, should it have?
Also, how can I tell how much is currently owing on an account?
Thanks.

------------------------------------------------------------------------------
Got Input?   Slashdot Needs You.
Take our quick survey online.  Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users