Hi Paul/whoever, We expect our database to be updated constantly (e.g., daily), but invoices may not be generated until a few days into the month. Thus user_services may contain some services in the current month.
Unfortunately, a quick test (using 'Create Invoice') indicates that CitrusDB ignores the 'From Date' set on a Customer's Billing page, and so it includes the services started in the current month in the invoice for the previous month. I also had a look at the PHP and saw that, e.g., billing.inc.php's total_serviceitems() searches only for items for which the 'removed' attribute is 'n', so it includes anything that hasn't previously been invoiced, whether it's in date range for the invoice or not. We expect invoices for April to contain only items from April, those for May to contain only items from May, etc., so I consider this a bug. At a minimum, isn't it misleading to have 'From Date' and 'To Date' on the billing page if, as seems to be the case, they have no effect on the generated invoice? Regards, Michael ------------------------------------------------------------------------------ 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
