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 <vic...@megawebsiteservices.com> wrote: > 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 > vic...@megawebsiteservices.com > http://megawebsiteservices.com > > On Wed, 27 Jul 2011 12:44:28 -0400, Victor Ientilucci wrote: >> 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 > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > -- The CitrusDB Project | www.citrusdb.org Open Source Customer Service & Billing ------------------------------------------------------------------------------ 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 Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
