- In order to test the invoices based on sale order lines of sales module in OpenERP I create a Sale Order for two products LG Viewty Smart and Slider mobile for qty 100 having order_policy manual. - !record {model: sale.order, id: sale_order_so3}: date_order: !eval time.strftime('%Y-%m-%d') invoice_quantity: order name: Test_SO003 order_line: - name: Slider Mobile sequence: 1 price_unit: 200.0 product_uom: product.product_uom_unit product_uom_qty: 100.0 state: draft delay: 7.0 product_id: sale.product_product_slidermobile0 product_uos_qty: 100.0 type: make_to_order - name: LG Viewty Smart price_unit: 170.0 sequence: 2 product_uom: product.product_uom_unit product_uom_qty: 100.0 state: draft delay: 7.0 product_id: sale.product_product_lgviewtysmart0 product_uos_qty: 100.0 th_weight: 0.0 type: make_to_order order_policy: manual partner_id: sale.res_partner_cleartrail0 partner_invoice_id: sale.res_partner_address_2 partner_order_id: sale.res_partner_address_1 partner_shipping_id: sale.res_partner_address_3 picking_policy: direct pricelist_id: product.list0 shop_id: sale.shop - I confirm the Sale Order. - !workflow {model: sale.order, action: order_confirm, ref: sale_order_so3} - I click on the "Make Invoice" button of sale order line - !record {model: sale.order.line.make.invoice, id: sale_order_line_make_invoice_0}: {} - I click on the "Create Invoice" button of wizard - !python {model: sale.order.line.make.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) sol = so.order_line[0] self.make_invoices(cr, uid, [ref("sale_order_line_make_invoice_0")], {"lang": "en_US", "tz": False, "active_model": "sale.order.line", "active_ids": [sol.id], "search_default_uninvoiced": 1, "active_id": sol.id, }) - I verify that "Invoiced" has been set to True. - !python {model: sale.order}: | sale_id=self.browse(cr, uid, ref("sale_order_so3")) sol = sale_id.order_line[0] assert(sol.invoiced == True), "Invoiced has not been set to true" - I verify that an invoice for sale order line has been created. - !python {model: sale.order}: | so = self.browse(cr, uid, ref("sale_order_so3")) assert so.invoice_ids, "Invoices has not been generated for sale_order_so3" - I click on the Create button of invoice - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) import netsvc wf_service = netsvc.LocalService("workflow") invoice_ids = so.invoice_ids for invoice in invoice_ids: wf_service.trg_validate(uid, 'account.invoice',invoice.id,'invoice_open', cr) - I verify that an invoice state has transit from draft to open state - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) invoice_id = self.search(cr, uid, [('origin','=',so.name),('state','=','open')]) assert invoice_id, "Invoice is not in the open state" - I assign an analytic journal to the bank journal - !record {model: account.journal, id: sale.account_journal_bankjournal0}: analytic_journal_id: account.cose_journal_sale - I pay the invoice - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) invoice_id = self.search(cr, uid, [('origin','=',so.name),('state','=','open')]) self.pay_and_reconcile(cr, uid, invoice_id, 20000.0, ref('account.cash'), ref('account.period_8'), ref('sale.account_journal_bankjournal0'), ref('account.cash'), ref('account.period_8'), ref('sale.account_journal_bankjournal0'), name='test') - I verify that an invoice is in done state. - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) invoice_id = self.search(cr, uid, [('origin','=',so.name),('state','=','paid')]) assert invoice_id, "Invoice for SO is not in done state." - I verify that Paid has been set to true. - !python {model: sale.order}: | sale_id=self.browse(cr, uid, ref("sale_order_so3")) assert(sale_id.invoiced == True), "Paid has not been set to true" - I create an invoice for another sale order line. I click on the "Make Invoice" button of sale order line - !record {model: sale.order.line.make.invoice, id: sale_order_line_make_invoice_1}: {} - I click on the "Create Invoice" button of wizard - !python {model: sale.order.line.make.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) sol = so.order_line[1] self.make_invoices(cr, uid, [ref("sale_order_line_make_invoice_1")], {"lang": "en_US", "tz": False, "active_model": "sale.order.line", "active_ids": [sol.id], "search_default_uninvoiced": 1, "active_id": sol.id, }) - I verify that invoice for sale order line has been created. - !python {model: sale.order}: | so = self.browse(cr, uid, ref("sale_order_so3")) assert so.invoice_ids[1], "Invoices has not been generated for sale_order_so3" - I verify that "Invoiced" has been set to True. - !python {model: sale.order}: | sale_id=self.browse(cr, uid, ref("sale_order_so3")) sol = sale_id.order_line[1] assert(sol.invoiced == True), "Invoiced has not been set to true" - I verify that "Paid" has been set to False. - !python {model: sale.order}: | sale_id=self.browse(cr, uid, ref("sale_order_so3")) assert(sale_id.invoiced == False), "Paid has not been set to true" - I open the Invoice for the SO. - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) import netsvc wf_service = netsvc.LocalService("workflow") invoice_ids = so.invoice_ids for invoice in invoice_ids: wf_service.trg_validate(uid, 'account.invoice',invoice.id,'invoice_open', cr) - I verify that an invoice state has transit from draft to open state - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) invoice_id = self.search(cr, uid, [('origin','=',so.name),('state','=','open')]) assert invoice_id, "Invoice is not in the open state" - Assign analytic journal into bank journal - !record {model: account.journal, id: sale.account_journal_bankjournal0}: analytic_journal_id: account.cose_journal_sale - I pay the invoice - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) invoice_id = self.search(cr, uid, [('origin','=',so.name),('state','=','open')]) self.pay_and_reconcile(cr, uid, invoice_id, 17000.0, ref('account.cash'), ref('account.period_8'), ref('sale.account_journal_bankjournal0'), ref('account.cash'), ref('account.period_8'), ref('sale.account_journal_bankjournal0'), name='test') - I verify the invoice is in done state. - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so3")) invoice_id = self.search(cr, uid, [('origin','=',so.name),('state','=','paid')]) assert invoice_id, "Invoice for SO is not in done state." - I verify that Paid has been set to true. - !python {model: sale.order}: | sale_id=self.browse(cr, uid, ref("sale_order_so3")) assert(sale_id.invoiced == True), "Paid has not been set to true"