Leaderboard

Hello Again we have found i think the cause . all this two clients has no invoice method set ... setting invoice method to email and created service solved the problem . it should normally create invoice even if no invoice method is not set or empty . because the invoice method is the way the client get the invoice delivered . and the invoice should imperatively created . EDIT : we have found in database , inv_method set to paper , and we have removed the paper option from the invoice method . so the invoice method is set to a option that is not available now . normally it should the system make a verification in client settings before disabling any invoice method ? if the invoice method is set by a client do not accept disabling it . or the invoice should be created even if the invoice set by client is not available in the system . is a trivial option , because this concern INVOICES , and INVOICES are money . this query is safe to update all clients inv_method to email ? UPDATE `client_settings` SET `value`="email" WHERE `key`="inv_method"

Are you familiar with selecting service information? I'll assume so and let you work out that part. To narrow it down to a specific company, you will want to join with client groups, i.e. SELECT `client_groups`.`company_id`, contacts.first_name, contacts.last_name, contacts.email, contacts.country FROM contacts INNER JOIN `clients` ON `clients`.`id` = `contacts`.`client_id` INNER JOIN `client_groups` ON `client_groups`.`id` = `clients`.`client_group_id` ORDER BY `client_groups`.`company_id` ASC, contacts.country ASC;

I haven't heard of that happening before. Do you have any custom changes that might interfere with that behavior? Are you positive you had the "Create Invoice" radio option selected? A mis-click could select a different radio option to either append it to an existing invoice, or not invoice it at all. Can you duplicate this behavior consistently?