Hello, I am working on Hotel Management Module. The tabs present inside are reservation, housekeeping services, restaurant, folio, reports and configuration. Now, I want to create customer invoice for final payment which will be generated in accounting.(customer invoices)
In existing module, customer invoice only includes charges for reservation and services consumed by customer. For restaurant, there is no any invoice generated. I wish to include restaurant charges in folio and should gets to customer invoice.
Can anyone help me with generating customer invoice which includes all the charges.( reservation, services and restaurant )
The code for hotel folio is,
class hotel_folio(osv.Model):
def copy(self, cr, uid, id, default=None, context=None):
return self.pool.get('sale.order').copy(cr, uid, id, default=None, context=None)
def _invoiced(self, cursor, user, ids, name, arg, context=None):
return self.pool.get('sale.order')._invoiced(cursor, user, ids, name, arg, context=None)
def _invoiced_search(self, cursor, user, obj, name, args):
return self.pool.get('sale.order')._invoiced_search(cursor, user, obj, name, args)
_name = 'hotel.folio'
_description = 'hotel folio new'
_inherits = {'sale.order': 'order_id'}
_rec_name = 'order_id'
_order = 'id desc'
_columns = {
'name': fields.char('Folio Number', size=24, readonly=True),
'order_id': fields.many2one('sale.order', 'Order', required=True, ondelete='cascade'),
'checkin_date': fields.datetime('Check In', required=True, readonly=True, states={'draft':[('readonly', False)]}),
'checkout_date': fields.datetime('Check Out', required=True, readonly=True, states={'draft':[('readonly', False)]}),
'room_lines': fields.one2many('hotel.folio.line', 'folio_id', readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}, help="Hotel room reservation detail."),
'service_lines': fields.one2many('hotel.service.line', 'folio_id', readonly=True, states={'draft': [('readonly', False)], 'sent': [('readonly', False)]}, help="Hotel services detail provide to customer and it will include in main Invoice."),
'hotel_policy': fields.selection([('prepaid', 'On Booking'), ('manual', 'On Check In'), ('picking', 'On Checkout')], 'Hotel Policy', help="Hotel policy for payment that either the guest has to payment at booking time or check-in check-ou time."),
'duration': fields.float('Duration in Days', readonly=True, help="Number of days which will automatically count from the check-in and check-out date. "),
}
_defaults = {
'name': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'hotel.folio'),
'hotel_policy':'manual'
}
_sql_constraints = [
('check_in_out', 'CHECK (checkin_date<=checkout_date)', 'Check in Date Should be less than the Check Out Date!'),
]
--------------------------------------------------------------------------------------------------------------------------------------------------------
The form view for folio is,
<form string="Folio" version="7.0">
<header>
<button name="order_confirm" string="Confirm Folio" states="draft" icon="gtk-apply" class="oe_highlight"/>
<button name="invoice_recreate" string="Recreate Invoice" states="invoice_except" icon="gtk-redo" class="oe_highlight"/>
<button name="invoice_corrected" string="Invoice Corrected" states="invoice_except" icon="gtk-paste-v" class="oe_highlight"/>
<button name="ship_recreate" string="Recreate Procurement" states="shipping_except" icon="gtk-redo" class="oe_highlight"/>
<button name="ship_corrected" string="Procurement Corrected" states="shipping_except" icon="gtk-paste-v" class="oe_highlight"/>
<button name="manual_invoice" states="manual" string="Create Invoice" icon="gtk-new" class="oe_highlight"/>
<button name="ship_cancel" string="Cancel Folio" states="shipping_except" icon="gtk-cancel" class="oe_highlight oe_highlight" />
<button name="action_cancel_draft" states="cancel" string="Set to Draft" type="object" icon="gtk-file" class="oe_highlight"/>
<button name="action_cancel" string="Cancel Folio" states="manual,progress" type="object" icon="gtk-cancel" class="oe_highlight"/>
<button name="cancel" string="Cancel Folio" states="draft" icon="gtk-cancel" class="oe_highlight"/>
<button name="invoice_cancel" string="Cancel Folio" states="invoice_except" icon="gtk-cancel" class="oe_highlight"/>
<field name="state" select="2" widget="statusbar" statusbar_visible="draft,sent,invoiced,done"/>
</header>
<notebook colspan="4">
<page string="Folio">
<group colspan="4" col="4">
<field name="partner_id" on_change="onchange_partner_id(partner_id)" required="1" string="Guest Name"/>
<field name="partner_invoice_id" domain="[('parent_id','=',partner_id)]"/>
<field name="pricelist_id" domain="[('type','=','sale')]" />
<field name="project_id"/>
<field name="partner_shipping_id" domain="[('parent_id','=',partner_id)]" invisible="1" />
</group>
<newline/>
<group colspan="4" col="6">
<field name="checkin_date" on_change="onchange_dates(checkin_date,checkout_date)" />
<field name="checkout_date" on_change="onchange_dates(checkin_date,checkout_date)"/>
<field name="duration" on_change="onchange_dates(checkin_date,False,duration)"/>
</group>
</group>
<separator string="Room Lines" colspan="4"/>
<field name="room_lines" colspan="4" string="Room Line" default_get="{'checkin_date': checkin_date,'checkout_date':checkout_date}" nolabel="1">
<form string="Room Line" version="7.0">
<notebook>
<page string="Folio Line">
<group>
<field name="checkin_date"/>
<field name="checkout_date" on_change="on_change_checkout(checkin_date,checkout_date)" />
<separator string="Automatic Declaration" colspan="4"/>
<field name="product_uom_qty" on_change="product_id_change(parent.pricelist_id,product_id,product_uom_qty,product_uom,product_uos_qty,product_uos,name,parent.partner_id, False, False, parent.date_order)" context="{'partner_id':parent.partner_id,'quantity':product_uom_qty,'pricelist':parent.pricelist_id,'uom':product_uom}" invisible="1"/>
<field name="product_uom" on_change="product_uom_change(parent.pricelist_id,product_id,product_uom_qty,product_uom,product_uos_qty,product_uos,name,parent.partner_id, False, False, parent.date_order)" string="Rent(UOM)"/>
<field name="product_id" on_change="product_id_change(parent.pricelist_id,product_id,product_uom_qty,product_uom,product_uos_qty,product_uos,name,parent.partner_id, False, True, parent.date_order)" context="{'partner_id':parent.partner_id,'quantity':product_uom_qty,'pricelist':parent.pricelist_id,'uom':product_uom}" colspan="4" select="1" domain="[('isroom','=',True)]" string="Room No"/>
</group>
<separator string="Manual Description" colspan="4" />
<field name="name" colspan="4" select="2" placeholder="---Description---"/>
<group>
<field name="price_unit" select="2" string="Rent"/>
<field name="discount"/>
<newline/>
<field name="tax_id" colspan="4" nolabel="1"/>
<separator string="States" colspan="4"/>
<field name="state" select="2"/>
<field name="invoiced" select="2"/>
</group>
</page>
<page string="Extra Info">
<group>
<field name="product_uos_qty"/>
<field name="product_uos" />
<field name="address_allotment_id" select="2"/>
</group>
</page>
<page string="History">
<separator string="Invoice Lines" colspan="4"/>
<field name="invoice_lines" colspan="4" nolabel="1"/>
</page>
</notebook>
</form>
<tree string = "Room Line">
<field name="name"/>
<field name="checkin_date"/>
<field name="checkout_date"/>
<field name="product_id" string="Room No"/>
<field name="product_uom" string="Rent(UOM)"/>
<field name="price_unit" string="Rent"/>
<field name="price_subtotal"/>
<field name="state"/>
</tree>
</field>
After confirmation of folio, generates invoice.
