- In order to test the Sale module in OpenERP, I create a Sale Order for Slider Mobile for 200 quantity having Shipping Policy 'Invoice from Picking' and Invoice on 'Shipped quantities' - !record {model: sale.order, id: sale_order_so6}: date_order: !eval time.strftime('%Y-%m-%d') invoice_quantity: order name: Test_SO006BIS order_line: - name: Slider Mobile price_unit: 200 product_uom: product.product_uom_unit product_uom_qty: 200.0 state: draft delay: 7.0 product_id: sale.product_product_slidermobile0 product_uos_qty: 200.0 type: make_to_order order_policy: picking invoice_quantity: procurement 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_so6} - I verify that the picking has been generated for the sale order and I process it - !python {model: sale.order}: | so = self.browse(cr, uid, ref("sale_order_so6")) assert so.picking_ids,"Picking has not been generated for sale_order_so6" picking, = so.picking_ids stock_partial_picking = self.pool.get('stock.partial.picking') partial_id = stock_partial_picking.create(cr, uid, {}, context={'active_model': 'stock.picking', 'active_ids': [picking.id]}) # I change the qty to 100 for a partial delivery partial = stock_partial_picking.browse(cr,uid,partial_id) line_id = partial.move_ids[0].id partial.write({'move_ids': [(1,line_id,{'quantity':100})]}) partial.do_partial() - Then I click on 'Create Invoices' button - !python {model: stock.invoice.onshipping}: | import time sale_obj = self.pool.get('sale.order') sale_id = sale_obj.browse(cr, uid, ref("sale_order_so6")) ids = [x.id for x in sale_id.picking_ids if x.state == 'done'] wiz_id = self.create(cr, uid, {'invoice_date': time.strftime('%Y-%m-%d'), 'journal_id': ref('account.sales_journal')}, {'active_ids': ids, 'active_model': 'stock.picking'}) self.create_invoice(cr, uid, [wiz_id], {"active_ids": ids, "active_id": ids[0]}) - I verify whether the invoice has been generated for SO - !python {model: sale.order}: | so = self.browse(cr, uid, ref("sale_order_so6")) assert so.invoice_ids, "Invoices has not been generated for sale_order_so6" - I verify that an invoice is created on the basis of shipped quantities 100 not ordered quantities 200 - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so6")) picking_obj = self.pool.get('stock.picking') ids = picking_obj.search(cr, uid, [('origin', '=', so.name),('type','=','out'),('state','=','done')]) qty = qty1 = 0.0 for pick_brw in picking_obj.browse(cr,uid, ids): for lines in pick_brw.move_lines: qty=lines.product_qty inv_id = self.search(cr, uid, [('origin', 'like', so.name)]) inv_brw = self.browse(cr,uid,inv_id)[0] for inv_lines in inv_brw.invoice_line: qty1=inv_lines.quantity assert (qty1 == qty), "Quantities are not the same: invoiced: %s, shipped: %s" % (qty1,qty) - 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_so6")) 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) - 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_so6")) invoice_id = self.search(cr, uid, [('origin','like',so.name),('state','=','open')]) self.pay_and_reconcile(cr, uid, invoice_id, 40000.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 are in paid state or not. - !python {model: account.invoice}: | sale_order_obj = self.pool.get('sale.order') so = sale_order_obj.browse(cr, uid, ref("sale_order_so6")) invoice_ids = so.invoice_ids for invoice in invoice_ids: assert invoice.state=='paid', "Invoice for SO is not in done state." - I check that Paid has been set to true. - !python {model: sale.order}: | sale_id=self.browse(cr, uid, ref("sale_order_so6")) assert sale_id.invoiced == True, "Paid has not been set to true"