Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to generate customer invoice in hotel management?

By
Kapil More
on 7/28/15, 2:43 AM 570 views

     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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/28/15, 2:43 AM
Seen: 570 times
Last updated: 7/28/15, 2:45 AM