I'm evaluating CitrusDB for a telecoms-like application, having
abandoned an evaluation of jBilling.

CitrusDB seems more limited, but at least I got it working quickly
with a simple initial demo setup of my own - which is more than I 
can
say for jBilling, after spending around a week on it.

These are the points I'd like to share. Thanks to anyone who can
confirm or correct or make suggestions.

Limitation to a single currency: as I'm not evaluating on my own
behalf, I'm not sure yet if this is a showstopper. There doesn't 
seem
to be an obvious workaround, though I noticed that no currency unit
appeared on the sample invoice I generated. Perhaps the simplest 
way
would be to run a separate installation of CitrusDB for each
currency (which might be acceptable if they could be limited to, 
say,
three, but which is obviously not an appealing solution)?

Volume discounts, discount for advance payment, etc. I didn't see a
section dealing with this subject in the manual. My understanding 
is
that this would have to be implemented by whatever code is 
importing
the usage data into the Citrus database. So if the user has paid 
for
100 units in advance for the month, getting a fixed discounted 
price,
then a separate PHP script that finds the usage is 90 does nothing,
but if it finds the usage is 110 then it adds another service with
a quantity of 10 to be billed at the usual rate. Correct?
(The equivalent logic in jBilling would be in Drools rules.)

Only one piece of ancillary data in the invoice: if an options 
table
is defined to store extra information associated with a service 
then
only the first column from this appears in the invoice.
Workaround: store all the data that should be printed in the first
column, duplicating parts of it in other columns if it is necessary
or convenient to access them as separate numbers or codes, etc.

(Ideally, I think one of those numbers might be a rate so that the
same service could be billed at different rates, rather than
creating a different service for each rate. The rate might be the
outcome of some complex function of durations, ratios or the like,
so that the number of services needed could otherwise be large
due to the many different possible outcomes of the rate 
calculation.
However, that's probably expecting too much.)


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

Reply via email to