addons/sale/test/edi_sale_order.yml

   1 -
   2   I create a draft Sale Order
   3 -
   4   !record {model: sale.order, id: sale_order_edi_1}:
   5     partner_id: base.res_partner_2
   6     partner_invoice_id: base.res_partner_address_3
   7     partner_shipping_id: base.res_partner_address_3
   8     pricelist_id: 1
   9     order_line:
  10       - product_id: product.product_product_3
  11         product_uom_qty: 1.0
  12         product_uom: 1
  13         price_unit: 150.0
  14         name: 'PC Assemble SC234'
  15     order_line:
  16       - product_id: product.product_product_5
  17         product_uom_qty: 10.0
  18         product_uom: 1
  19         price_unit: 200.0
  20         name: 'PC Assemble + Custom (PC on Demand)'
  21 -
  22   I confirm the sale order
  23 -
  24   !workflow {model: sale.order, ref: sale_order_edi_1, action: order_confirm}
  25 -
  26   Then I export the sale order via EDI
  27 -
  28   !python {model: edi.edi}: |
  29     import json
  30     sale_order = self.pool.get('sale.order')
  31     so = sale_order.browse(cr, uid, ref("sale_order_edi_1"))
  32     edi_doc = self.generate_edi(cr, uid, [so])
  33     assert isinstance(json.loads(edi_doc)[0], dict), 'EDI doc should be a JSON dict'
  34 -
  35   "Then I import a sample EDI document of a purchase order (v7.0)"
  36 -
  37   !python {model: edi.edi}: |
  38     sale_order_pool = self.pool.get('sale.order')
  39     edi_document = {
  40         "__id": "purchase:5af12v70-dv70-1v70-bv70-701a04e25v70.purchase_order_test",
  41         "__module": "purchase",
  42         "__model": "purchase.order",
  43         "__import_module": "sale",
  44         "__import_model": "sale.order",
  45         "__version": [7,0,0],
  46         "name": "PO00011",
  47         "date_order": "2011-09-12",
  48         "currency": {
  49                 "__id": "base:5af12v70-dv70-1v70-bv70-701a04e25v70.EUR",
  50                 "__module": "base",
  51                 "__model": "res.currency",
  52                 "code": "EUR",
  53                 "symbol": "€",
  54         },
  55         "company_id": ["base:5af12v70-dv70-1v70-bv70-701a04e25v70.main_company", "Client S.A."],
  56         "company_address": {
  57                 "__id": "base:5af12v70-dv70-1v70-bv70-701a04e25v70.some_address",
  58                 "__module": "base",
  59                 "__model": "res.partner",
  60                 "phone": "(+32).81.81.37.00",
  61                 "street": "Chaussee de Namur 40",
  62                 "city": "Gerompont",
  63                 "zip": "1367",
  64                 "country_id": ["base:5af12v70-dv70-1v70-bv70-701a04e25v70.be", "Belgium"],
  65                 "bank_ids": [
  66                     ["base:5af12v70-dv70-1v70-bv70-701a04e25v70.res_partner_bank-adaWadsadasdDJzGbp","Another bank: 032465700-156700"]
  67                 ],
  68         },
  69         "partner_id": ["purchase:5af12v70-dv70-1v70-bv70-701a04e25v70.res_partner_test20", "jones white"],
  70         "order_line": [{
  71                 "__id": "purchase:5af12v70-dv70-1v70-bv70-701a04e25v70.purchase_order_line-AlhsVDZGoKvJ",
  72                 "__module": "purchase",
  73                 "__model": "purchase.order.line",
  74                 "__import_module": "sale",
  75                 "__import_model": "sale.order.line",
  76                 "name": "PC Assemble SC234",
  77                 "price_unit": 150.0,
  78                 "product_id": ["product:5af12v70-dv70-1v70-bv70-701a04e25v70.product_product_3", "[PCSC234] PC Assemble SC234"],
  79                 "product_qty": 1.0,
  80                 "product_uom": ["product:5af12v70-dv70-1v70-bv70-701a04e25v70.product_uom_unit", "Unit"],
  81         },
  82         {
  83                 "__id": "purchase:5af12v70-dv70-1v70-bv70-701a04e25v70.purchase_order_line-Alsads33e",
  84                 "__module": "purchase",
  85                 "__model": "purchase.order.line",
  86                 "__import_module": "sale",
  87                 "__import_model": "sale.order.line",
  88                 "name": "PC on Demand",
  89                 "price_unit": 100.0,
  90                 "product_id": ["product:5af12v70-dv70-1v70-bv70-701a04e25v70.product_product_5", "[PC-DEM] PC on Demand"],
  91                 "product_qty": 2.0,
  92                 "product_uom": ["product:5af12v70-dv70-1v70-bv70-701a04e25v70.product_uom_unit", "Unit"],
  93         }],
  94     }
  95     new_sale_order_id = sale_order_pool.edi_import(cr, uid, edi_document, context=context)
  96     assert new_sale_order_id,  'Sale order import failed'
  97     order_new = sale_order_pool.browse(cr, uid, new_sale_order_id)
  98
  99     # check bank info on partner
 100     assert order_new.partner_id.customer, "Imported partner should be a customer, as we just imported the document as a sale order"
 101     assert len(order_new.partner_id.bank_ids) == 1, "Expected 1 bank entry related to partner"
 102     bank_info = order_new.partner_id.bank_ids[0]
 103     assert bank_info.acc_number == "Another bank: 032465700-156700", 'Expected "Another bank: 032465700-156700", got %s' % bank_info.acc_number
 104
 105     assert order_new.pricelist_id.name == 'Public Pricelist' , "Public Price list was not automatically assigned"
 106     assert order_new.amount_total == 350, "Amount total is wrong"
 107     assert order_new.amount_untaxed == 350, "Untaxed amount is wrong"
 108     assert len(order_new.order_line) == 2, "Sale order lines mismatch"
 109     for sale_line in order_new.order_line:
 110         if sale_line.name == 'PC Assemble SC234':
 111             assert sale_line.product_uom.name == "Unit" , "uom is not same"
 112             assert sale_line.price_unit == 150 , "unit price is not same, got %s, expected 150"%(sale_line.price_unit,)
 113             assert sale_line.product_uom_qty == 1 , "product qty is not same"
 114         elif sale_line.name == 'PC on Demand':
 115             assert sale_line.product_uom.name == "Unit" , "uom is not same"
 116             assert sale_line.price_unit == 100 , "unit price is not same, got %s, expected 100"%(sale_line.price_unit,)
 117             assert sale_line.product_uom_qty == 2 , "product qty is not same"
 118         else:
 119             raise AssertionError('unknown order line: %s' % sale_line)
 120 -
 121   "Then I import a sample EDI document of a purchase order (v6.1 - to test backwards compatibility)"
 122 -
 123   !python {model: edi.edi}: |
 124     sale_order_pool = self.pool.get('sale.order')
 125     edi_document = {
 126         "__id": "purchase:5af1272e-dd26-11e0-b65e-701a04e25543.purchase_order_test",
 127         "__module": "purchase",
 128         "__model": "purchase.order",
 129         "__import_module": "sale",
 130         "__import_model": "sale.order",
 131         "__version": [6,1,0],
 132         "name": "PO00011-v61",
 133         "date_order": "2011-09-12",
 134         "currency": {
 135                 "__id": "base:5af1272e-dd26-11e0-b65e-701a04e25543.EUR",
 136                 "__module": "base",
 137                 "__model": "res.currency",
 138                 "code": "EUR",
 139                 "symbol": "€",
 140         },
 141         "company_id": ["base:5af1272e-dd26-11e0-b65e-701a04e25543.main_company", "Client S.A."],
 142         "company_address": {
 143                 "__id": "base:5af1272e-dd26-11e0-b65e-701a04e25543.some_address",
 144                 "__module": "base",
 145                 "__model": "res.partner.address",
 146                 "phone": "(+32).81.81.37.00",
 147                 "street": "Chaussee de Namur 40",
 148                 "city": "Gerompont",
 149                 "zip": "1367",
 150                 "country_id": ["base:5af1272e-dd26-11e0-b65e-701a04e25543.be", "Belgium"],
 151                 "bank_ids": [
 152                     ["base:5af1272e-dd26-11e0-b65e-701a04e25543.res_partner_bank-adaWadsadasdDJzGbp","Ladies bank: 032465789-156113"]
 153                 ],
 154         },
 155         "partner_id": ["purchase:5af1272e-dd26-11e0-b65e-701a04e25543.res_partner_test20", "jones white"],
 156         "partner_address": {
 157                 "__id": "base:5af1272e-dd26-11e0-b65e-701a04e25543.res_partner_address_7wdsjasdjh",
 158                 "__module": "base",
 159                 "__model": "res.partner.address",
 160                 "phone": "(+32).81.81.37.00",
 161                 "street": "Chaussee de Namur 40",
 162                 "city": "Gerompont",
 163                 "zip": "1367",
 164                 "country_id": ["base:5af1272e-dd26-11e0-b65e-701a04e25543.be", "Belgium"],
 165         },
 166         "order_line": [{
 167                 "__id": "purchase:5af1272e-dd26-11e0-b65e-701a04e25543.purchase_order_line-AlhsVDZGoKvJ",
 168                 "__module": "purchase",
 169                 "__model": "purchase.order.line",
 170                 "__import_module": "sale",
 171                 "__import_model": "sale.order.line",
 172                 "name": "Basic PC",
 173                 "date_planned": "2011-09-30",
 174                 "price_unit": 150.0,
 175                 "product_id": ["product:5af1272e-dd26-11e0-b65e-701a04e25543.product_product_pc1", "[PC1] Basic PC"],
 176                 "product_qty": 1.0,
 177                 "product_uom": ["product:5af1272e-dd26-11e0-b65e-701a04e25543.product_uom_unit", "PCE"],
 178         },
 179         {
 180                 "__id": "purchase:5af1272e-dd26-11e0-b65e-701a04e25543.purchase_order_line-Alsads33e",
 181                 "__module": "purchase",
 182                 "__model": "purchase.order.line",
 183                 "__import_module": "sale",
 184                 "__import_model": "sale.order.line",
 185                 "name": "Medium PC",
 186                 "date_planned": "2011-09-15",
 187                 "price_unit": 100.0,
 188                 "product_id": ["product:5af1272e-dd26-11e0-b65e-701a04e25543.product_product_pc3", "[PC3] Medium PC"],
 189                 "product_qty": 2.0,
 190                 "product_uom": ["product:5af1272e-dd26-11e0-b65e-701a04e25543.product_uom_unit", "PCE"],
 191         }],
 192     }
 193     new_sale_order_id = sale_order_pool.edi_import(cr, uid, edi_document, context=context)
 194     assert new_sale_order_id,  'Sale order import failed'
 195     order_new = sale_order_pool.browse(cr, uid, new_sale_order_id)
 196
 197     # check bank info on partner
 198     assert order_new.partner_id.customer, "Imported partner should be a customer, as we just imported the document as a sale order"
 199     assert len(order_new.partner_id.bank_ids) == 1, "Expected 1 bank entry related to partner"
 200     bank_info = order_new.partner_id.bank_ids[0]
 201     assert bank_info.acc_number == "Ladies bank: 032465789-156113", 'Expected "Ladies bank: 032465789-156113", got %s' % bank_info.acc_number
 202
 203     assert order_new.pricelist_id.name == 'Public Pricelist' , "Public Price list was not automatically assigned"
 204     assert order_new.amount_total == 350, "Amount total is wrong"
 205     assert order_new.amount_untaxed == 350, "Untaxed amount is wrong"
 206     assert len(order_new.order_line) == 2, "Sale order lines mismatch"
 207     for sale_line in order_new.order_line:
 208         if sale_line.name == 'Basic PC':
 209             assert sale_line.product_uom.name == "PCE" , "uom is not same"
 210             assert sale_line.price_unit == 150 , "unit price is not same, got %s, expected 150"%(sale_line.price_unit,)
 211             assert sale_line.product_uom_qty == 1 , "product qty is not same"
 212         elif sale_line.name == 'Medium PC':
 213             assert sale_line.product_uom.name == "PCE" , "uom is not same"
 214             assert sale_line.price_unit == 100 , "unit price is not same, got %s, expected 100"%(sale_line.price_unit,)
 215             assert sale_line.product_uom_qty == 2 , "product qty is not same"
 216         else:
 217             raise AssertionError('unknown order line: %s' % sale_line)