User Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:helpdesk [2014/09/17 11:54]
joebordes
en:helpdesk [2016/09/10 02:01] (current)
Line 1: Line 1:
 ====== Help Desk:: Trouble Tickets ====== ====== Help Desk:: Trouble Tickets ======
 +
 +~~QNA~~
  
  
Line 11: Line 13:
  
 This is a flat rate contract and can easily be accomplished with recurring sales orders. You create a sales order when the client contracts your service, you establish a recurring period depending on the duration of the contract, when the time is up a new invoice will be created, which is all you need to control. This is a flat rate contract and can easily be accomplished with recurring sales orders. You create a sales order when the client contracts your service, you establish a recurring period depending on the duration of the contract, when the time is up a new invoice will be created, which is all you need to control.
 +
 +You can see below an example setup for a **one year contract billed monthly**:
 +
 +{{ :​en:​corebos:​oneyearcontractbilledmonthly.png?​830 |}}
 +
 +This setup will create 11 invoices starting on 1st of November and ending on 1st of September. You have to create the first one manually.
 +
 +??? Is there a way that the block hours accepts decimal e.g like 1.7hours?​
 +
 +!!!I just did a test and all I had to do to get it working with decimals was change the typeofdata of the ticket field. It is set to integer so it won't accept decimal values.
 +
 +This is the query I used:
 +
 +<code sql>​UPDATE `vtiger_field`
 + SET `uitype` = '​7',​`typeofdata` = '​N~O'​
 + WHERE `vtiger_field`.`fieldname` = '​hours'​ and tabid=13;</​code>​
 +
 +It would be better to change the type of the hours field in tickets from varchar to decimal but it works the same.
 +
 +<WRAP center round info 60%>
 +This has been incorporated as default behavior in coreBOS
 +</​WRAP>​
 +