KaneAI - World’s First E2E Software Testing Agent.Book a Demo Join TestMu Conference

How to use _test method in wpt

Best JavaScript code snippet using wpt

test_sales_order.py

Source:test_sales_order.py

1# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors2# License: GNU General Public License v3. See license.txt3from __future__ import unicode_literals4import frappe5from frappe.utils import flt, add_days6import frappe.permissions7import unittest8from erpnext.selling.doctype.sales_order.sales_order \9	import make_material_request, make_delivery_note, make_sales_invoice, WarehouseRequired10from erpnext.stock.doctype.stock_entry.stock_entry_utils import make_stock_entry11from frappe.tests.test_permissions import set_user_permission_doctypes12from erpnext.selling.doctype.sales_order.sales_order import make_production_orders13import json14class TestSalesOrder(unittest.TestCase):15	def tearDown(self):16		frappe.set_user("Administrator")17		for role in ("Stock User", "Sales User"):18			set_user_permission_doctypes(doctypes="Sales Order", role=role,19				apply_user_permissions=0, user_permission_doctypes=None)20	def test_make_material_request(self):21		so = make_sales_order(do_not_submit=True)22		self.assertRaises(frappe.ValidationError, make_material_request, so.name)23		so.submit()24		mr = make_material_request(so.name)25		self.assertEquals(mr.material_request_type, "Purchase")26		self.assertEquals(len(mr.get("items")), len(so.get("items")))27	def test_make_delivery_note(self):28		so = make_sales_order(do_not_submit=True)29		self.assertRaises(frappe.ValidationError, make_delivery_note, so.name)30		so.submit()31		dn = make_delivery_note(so.name)32		self.assertEquals(dn.doctype, "Delivery Note")33		self.assertEquals(len(dn.get("items")), len(so.get("items")))34	def test_make_sales_invoice(self):35		so = make_sales_order(do_not_submit=True)36		self.assertRaises(frappe.ValidationError, make_sales_invoice, so.name)37		so.submit()38		si = make_sales_invoice(so.name)39		self.assertEquals(len(si.get("items")), len(so.get("items")))40		self.assertEquals(len(si.get("items")), 1)41		si.insert()42		si.submit()43		si1 = make_sales_invoice(so.name)44		self.assertEquals(len(si1.get("items")), 0)45	def test_make_sales_invoice_with_terms(self):46		so = make_sales_order(do_not_submit=True)47		self.assertRaises(frappe.ValidationError, make_sales_invoice, so.name)48		so.update({"payment_terms_template": "_Test Payment Term Template"})49		so.save()50		so.submit()51		si = make_sales_invoice(so.name)52		self.assertEquals(len(si.get("items")), len(so.get("items")))53		self.assertEquals(len(si.get("items")), 1)54		si.insert()55		self.assertEqual(si.payment_schedule[0].payment_amount, 500.0)56		self.assertEqual(si.payment_schedule[0].due_date, so.transaction_date)57		self.assertEqual(si.payment_schedule[1].payment_amount, 500.0)58		self.assertEqual(si.payment_schedule[1].due_date, add_days(so.transaction_date, 30))59		si.submit()60		si1 = make_sales_invoice(so.name)61		self.assertEquals(len(si1.get("items")), 0)62	def test_update_qty(self):63		so = make_sales_order()64		create_dn_against_so(so.name, 6)65		so.load_from_db()66		self.assertEquals(so.get("items")[0].delivered_qty, 6)67		# Check delivered_qty after make_sales_invoice without update_stock checked68		si1 = make_sales_invoice(so.name)69		si1.get("items")[0].qty = 670		si1.insert()71		si1.submit()72		so.load_from_db()73		self.assertEquals(so.get("items")[0].delivered_qty, 6)74		# Check delivered_qty after make_sales_invoice with update_stock checked75		si2 = make_sales_invoice(so.name)76		si2.set("update_stock", 1)77		si2.get("items")[0].qty = 378		si2.insert()79		si2.submit()80		so.load_from_db()81		self.assertEquals(so.get("items")[0].delivered_qty, 9)82	def test_reserved_qty_for_partial_delivery(self):83		make_stock_entry(target="_Test Warehouse - _TC", qty=10, rate=100)84		existing_reserved_qty = get_reserved_qty()85		so = make_sales_order()86		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 10)87		dn = create_dn_against_so(so.name)88		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 5)89		# close so90		so.load_from_db()91		so.update_status("Closed")92		self.assertEqual(get_reserved_qty(), existing_reserved_qty)93		# unclose so94		so.load_from_db()95		so.update_status('Draft')96		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 5)97		dn.cancel()98		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 10)99		# cancel100		so.load_from_db()101		so.cancel()102		self.assertEqual(get_reserved_qty(), existing_reserved_qty)103	def test_reserved_qty_for_over_delivery(self):104		make_stock_entry(target="_Test Warehouse - _TC", qty=10, rate=100)105		# set over-delivery tolerance106		frappe.db.set_value('Item', "_Test Item", 'tolerance', 50)107		existing_reserved_qty = get_reserved_qty()108		so = make_sales_order()109		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 10)110		dn = create_dn_against_so(so.name, 15)111		self.assertEqual(get_reserved_qty(), existing_reserved_qty)112		dn.cancel()113		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 10)114	def test_reserved_qty_for_over_delivery_via_sales_invoice(self):115		make_stock_entry(target="_Test Warehouse - _TC", qty=10, rate=100)116		# set over-delivery tolerance117		frappe.db.set_value('Item', "_Test Item", 'tolerance', 50)118		existing_reserved_qty = get_reserved_qty()119		so = make_sales_order()120		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 10)121		si = make_sales_invoice(so.name)122		si.update_stock = 1123		si.get("items")[0].qty = 12124		si.insert()125		si.submit()126		self.assertEqual(get_reserved_qty(), existing_reserved_qty)127		so.load_from_db()128		self.assertEqual(so.get("items")[0].delivered_qty, 12)129		self.assertEqual(so.per_delivered, 100)130		si.cancel()131		self.assertEqual(get_reserved_qty(), existing_reserved_qty + 10)132		so.load_from_db()133		self.assertEqual(so.get("items")[0].delivered_qty, 0)134		self.assertEqual(so.per_delivered, 0)135	def test_reserved_qty_for_partial_delivery_with_packing_list(self):136		make_stock_entry(target="_Test Warehouse - _TC", qty=10, rate=100)137		make_stock_entry(item="_Test Item Home Desktop 100", target="_Test Warehouse - _TC", qty=10, rate=100)138		existing_reserved_qty_item1 = get_reserved_qty("_Test Item")139		existing_reserved_qty_item2 = get_reserved_qty("_Test Item Home Desktop 100")140		so = make_sales_order(item_code="_Test Product Bundle Item")141		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1 + 50)142		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),143			existing_reserved_qty_item2 + 20)144		dn = create_dn_against_so(so.name)145		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1 + 25)146		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),147			existing_reserved_qty_item2 + 10)148		# close so149		so.load_from_db()150		so.update_status("Closed")151		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1)152		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"), existing_reserved_qty_item2)153		# unclose so154		so.load_from_db()155		so.update_status('Draft')156		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1 + 25)157		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),158			existing_reserved_qty_item2 + 10)159		dn.cancel()160		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1 + 50)161		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),162			existing_reserved_qty_item2 + 20)163		so.load_from_db()164		so.cancel()165		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1)166		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"), existing_reserved_qty_item2)167	def test_reserved_qty_for_over_delivery_with_packing_list(self):168		make_stock_entry(target="_Test Warehouse - _TC", qty=10, rate=100)169		make_stock_entry(item="_Test Item Home Desktop 100", target="_Test Warehouse - _TC", qty=10, rate=100)170		# set over-delivery tolerance171		frappe.db.set_value('Item', "_Test Product Bundle Item", 'tolerance', 50)172		existing_reserved_qty_item1 = get_reserved_qty("_Test Item")173		existing_reserved_qty_item2 = get_reserved_qty("_Test Item Home Desktop 100")174		so = make_sales_order(item_code="_Test Product Bundle Item")175		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1 + 50)176		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),177			existing_reserved_qty_item2 + 20)178		dn = create_dn_against_so(so.name, 15)179		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1)180		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),181			existing_reserved_qty_item2)182		dn.cancel()183		self.assertEqual(get_reserved_qty("_Test Item"), existing_reserved_qty_item1 + 50)184		self.assertEqual(get_reserved_qty("_Test Item Home Desktop 100"),185			existing_reserved_qty_item2 + 20)186	def test_warehouse_user(self):187		for role in ("Stock User", "Sales User"):188			set_user_permission_doctypes(doctypes="Sales Order", role=role,189				apply_user_permissions=1, user_permission_doctypes=["Warehouse"])190		frappe.permissions.add_user_permission("Warehouse", "_Test Warehouse 1 - _TC", "test@example.com")191		frappe.permissions.add_user_permission("Warehouse", "_Test Warehouse 2 - _TC1", "test2@example.com")192		frappe.permissions.add_user_permission("Company", "_Test Company 1", "test2@example.com")193		test_user = frappe.get_doc("User", "test@example.com")194		test_user.add_roles("Sales User", "Stock User")195		test_user.remove_roles("Sales Manager")196		test_user_2 = frappe.get_doc("User", "test2@example.com")197		test_user_2.add_roles("Sales User", "Stock User")198		test_user_2.remove_roles("Sales Manager")199		frappe.set_user("test@example.com")200		so = make_sales_order(company="_Test Company 1",201			warehouse="_Test Warehouse 2 - _TC1", do_not_save=True)202		so.conversion_rate = 0.02203		so.plc_conversion_rate = 0.02204		self.assertRaises(frappe.PermissionError, so.insert)205		frappe.set_user("test2@example.com")206		so.insert()207		frappe.set_user("Administrator")208		frappe.permissions.remove_user_permission("Warehouse", "_Test Warehouse 1 - _TC", "test@example.com")209		frappe.permissions.remove_user_permission("Warehouse", "_Test Warehouse 2 - _TC1", "test2@example.com")210		frappe.permissions.remove_user_permission("Company", "_Test Company 1", "test2@example.com")211	def test_block_delivery_note_against_cancelled_sales_order(self):212		so = make_sales_order()213		dn = make_delivery_note(so.name)214		dn.insert()215		so.cancel()216		self.assertRaises(frappe.CancelledLinkError, dn.submit)217	def test_service_type_product_bundle(self):218		from erpnext.stock.doctype.item.test_item import make_item219		from erpnext.selling.doctype.product_bundle.test_product_bundle import make_product_bundle220		make_item("_Test Service Product Bundle", {"is_stock_item": 0})221		make_item("_Test Service Product Bundle Item 1", {"is_stock_item": 0})222		make_item("_Test Service Product Bundle Item 2", {"is_stock_item": 0})223		make_product_bundle("_Test Service Product Bundle",224			["_Test Service Product Bundle Item 1", "_Test Service Product Bundle Item 2"])225		so = make_sales_order(item_code = "_Test Service Product Bundle", warehouse=None)226		self.assertTrue("_Test Service Product Bundle Item 1" in [d.item_code for d in so.packed_items])227		self.assertTrue("_Test Service Product Bundle Item 2" in [d.item_code for d in so.packed_items])228	def test_mix_type_product_bundle(self):229		from erpnext.stock.doctype.item.test_item import make_item230		from erpnext.selling.doctype.product_bundle.test_product_bundle import make_product_bundle231		make_item("_Test Mix Product Bundle", {"is_stock_item": 0})232		make_item("_Test Mix Product Bundle Item 1", {"is_stock_item": 1})233		make_item("_Test Mix Product Bundle Item 2", {"is_stock_item": 0})234		make_product_bundle("_Test Mix Product Bundle",235			["_Test Mix Product Bundle Item 1", "_Test Mix Product Bundle Item 2"])236		self.assertRaises(WarehouseRequired, make_sales_order, item_code = "_Test Mix Product Bundle", warehouse="")237	def test_auto_insert_price(self):238		from erpnext.stock.doctype.item.test_item import make_item239		make_item("_Test Item for Auto Price List", {"is_stock_item": 0})240		frappe.db.set_value("Stock Settings", None, "auto_insert_price_list_rate_if_missing", 1)241		item_price = frappe.db.get_value("Item Price", {"price_list": "_Test Price List",242			"item_code": "_Test Item for Auto Price List"})243		if item_price:244			frappe.delete_doc("Item Price", item_price)245		make_sales_order(item_code = "_Test Item for Auto Price List", selling_price_list="_Test Price List", rate=100)246		self.assertEquals(frappe.db.get_value("Item Price",247			{"price_list": "_Test Price List", "item_code": "_Test Item for Auto Price List"}, "price_list_rate"), 100)248		# do not update price list249		frappe.db.set_value("Stock Settings", None, "auto_insert_price_list_rate_if_missing", 0)250		item_price = frappe.db.get_value("Item Price", {"price_list": "_Test Price List",251			"item_code": "_Test Item for Auto Price List"})252		if item_price:253			frappe.delete_doc("Item Price", item_price)254		make_sales_order(item_code = "_Test Item for Auto Price List", selling_price_list="_Test Price List", rate=100)255		self.assertEquals(frappe.db.get_value("Item Price",256			{"price_list": "_Test Price List", "item_code": "_Test Item for Auto Price List"}, "price_list_rate"), None)257		frappe.db.set_value("Stock Settings", None, "auto_insert_price_list_rate_if_missing", 1)258	def test_drop_shipping(self):259		from erpnext.selling.doctype.sales_order.sales_order import make_purchase_order_for_drop_shipment260		from erpnext.stock.doctype.item.test_item import make_item261		from erpnext.buying.doctype.purchase_order.purchase_order import update_status262		make_stock_entry(target="_Test Warehouse - _TC", qty=10, rate=100)263		po_item = make_item("_Test Item for Drop Shipping", {"is_stock_item": 1, "delivered_by_supplier": 1,264        'default_supplier': '_Test Supplier',265		    "expense_account": "_Test Account Cost for Goods Sold - _TC",266		    "cost_center": "_Test Cost Center - _TC"267			})268		dn_item = make_item("_Test Regular Item", {"is_stock_item": 1, "expense_account": "_Test Account Cost for Goods Sold - _TC",269  		  	"cost_center": "_Test Cost Center - _TC"})270		so_items = [271			{272				"item_code": po_item.item_code,273				"warehouse": "",274				"qty": 2,275				"rate": 400,276				"delivered_by_supplier": 1,277				"supplier": '_Test Supplier'278			},279			{280				"item_code": dn_item.item_code,281				"warehouse": "_Test Warehouse - _TC",282				"qty": 2,283				"rate": 300,284				"conversion_factor": 1.0285			}286		]287		if frappe.db.get_value("Item", "_Test Regular Item", "is_stock_item")==1:288			make_stock_entry(item="_Test Regular Item", target="_Test Warehouse - _TC", qty=10, rate=100)289		#setuo existing qty from bin290		bin = frappe.get_all("Bin", filters={"item_code": po_item.item_code, "warehouse": "_Test Warehouse - _TC"},291			fields=["ordered_qty", "reserved_qty"])292		existing_ordered_qty = bin[0].ordered_qty if bin else 0.0293		existing_reserved_qty = bin[0].reserved_qty if bin else 0.0294		bin = frappe.get_all("Bin", filters={"item_code": dn_item.item_code,295			"warehouse": "_Test Warehouse - _TC"}, fields=["reserved_qty"])296		existing_reserved_qty_for_dn_item = bin[0].reserved_qty if bin else 0.0297		#create so, po and partial dn298		so = make_sales_order(item_list=so_items, do_not_submit=True)299		so.submit()300		po = make_purchase_order_for_drop_shipment(so.name, '_Test Supplier')301		po.submit()302		dn = create_dn_against_so(so.name, delivered_qty=1)303		self.assertEquals(so.customer, po.customer)304		self.assertEquals(po.items[0].sales_order, so.name)305		self.assertEquals(po.items[0].item_code, po_item.item_code)306		self.assertEquals(dn.items[0].item_code, dn_item.item_code)307		#test ordered_qty and reserved_qty308		bin = frappe.get_all("Bin", filters={"item_code": po_item.item_code, "warehouse": "_Test Warehouse - _TC"},309			fields=["ordered_qty", "reserved_qty"])310		ordered_qty = bin[0].ordered_qty if bin else 0.0311		reserved_qty = bin[0].reserved_qty if bin else 0.0312		self.assertEquals(abs(flt(ordered_qty)), existing_ordered_qty)313		self.assertEquals(abs(flt(reserved_qty)), existing_reserved_qty)314		reserved_qty = frappe.db.get_value("Bin",315					{"item_code": dn_item.item_code, "warehouse": "_Test Warehouse - _TC"}, "reserved_qty")316		self.assertEquals(abs(flt(reserved_qty)), existing_reserved_qty_for_dn_item + 1)317		#test po_item length318		self.assertEquals(len(po.items), 1)319		#test per_delivered status320		update_status("Delivered", po.name)321		self.assertEquals(flt(frappe.db.get_value("Sales Order", so.name, "per_delivered"), 2), 75.00)322		#test reserved qty after complete delivery323		dn = create_dn_against_so(so.name, delivered_qty=1)324		reserved_qty = frappe.db.get_value("Bin",325			{"item_code": dn_item.item_code, "warehouse": "_Test Warehouse - _TC"}, "reserved_qty")326		self.assertEquals(abs(flt(reserved_qty)), existing_reserved_qty_for_dn_item)327		#test after closing so328		so.db_set('status', "Closed")329		so.update_reserved_qty()330		bin = frappe.get_all("Bin", filters={"item_code": po_item.item_code, "warehouse": "_Test Warehouse - _TC"},331			fields=["ordered_qty", "reserved_qty"])332		ordered_qty = bin[0].ordered_qty if bin else 0.0333		reserved_qty = bin[0].reserved_qty if bin else 0.0334		self.assertEquals(abs(flt(ordered_qty)), existing_ordered_qty)335		self.assertEquals(abs(flt(reserved_qty)), existing_reserved_qty)336		reserved_qty = frappe.db.get_value("Bin",337			{"item_code": dn_item.item_code, "warehouse": "_Test Warehouse - _TC"}, "reserved_qty")338		self.assertEquals(abs(flt(reserved_qty)), existing_reserved_qty_for_dn_item)339	def test_reserved_qty_for_closing_so(self):340		bin = frappe.get_all("Bin", filters={"item_code": "_Test Item", "warehouse": "_Test Warehouse - _TC"},341			fields=["reserved_qty"])342		existing_reserved_qty = bin[0].reserved_qty if bin else 0.0343		so = make_sales_order(item_code="_Test Item", qty=1)344		self.assertEquals(get_reserved_qty(item_code="_Test Item", warehouse="_Test Warehouse - _TC"), existing_reserved_qty+1)345		so.update_status("Closed")346		self.assertEquals(get_reserved_qty(item_code="_Test Item", warehouse="_Test Warehouse - _TC"), existing_reserved_qty)347	def test_create_so_with_margin(self):348		so = make_sales_order(item_code="_Test Item", qty=1, do_not_submit=True)349		so.items[0].price_list_rate = price_list_rate = 100350		so.items[0].margin_type = 'Percentage'351		so.items[0].margin_rate_or_amount = 25352		so.save()353		new_so = frappe.copy_doc(so)354		new_so.save(ignore_permissions=True)355		self.assertEquals(new_so.get("items")[0].rate, flt((price_list_rate*25)/100 + price_list_rate))356		new_so.items[0].margin_rate_or_amount = 25357		new_so.payment_schedule = []358		new_so.save()359		new_so.submit()360		self.assertEquals(new_so.get("items")[0].rate, flt((price_list_rate*25)/100 + price_list_rate))361	def test_terms_auto_added(self):362		so = make_sales_order(do_not_save=1)363		self.assertFalse(so.get('payment_schedule'))364		so.insert()365		self.assertTrue(so.get('payment_schedule'))366	def test_terms_not_copied(self):367		so = make_sales_order()368		self.assertTrue(so.get('payment_schedule'))369		si = make_sales_invoice(so.name)370		self.assertFalse(si.get('payment_schedule'))371	def test_terms_copied(self):372		so = make_sales_order(do_not_copy=1, do_not_save=1)373		so.payment_terms_template = '_Test Payment Term Template'374		so.insert()375		so.submit()376		self.assertTrue(so.get('payment_schedule'))377		si = make_sales_invoice(so.name)378		si.insert()379		self.assertTrue(si.get('payment_schedule'))380	def test_make_production_order(self):381		# Make a new Sales Order382		so = make_sales_order(**{383			"item_list": [{384				"item_code": "_Test FG Item",385				"qty": 10,386				"rate":100387			},388			{389				"item_code": "_Test FG Item",390				"qty": 20,391				"rate":200392			}]393		})394		# Raise Production Orders395		po_items= []396		so_item_name= {}397		for item in so.get_production_order_items():398			po_items.append({399				"warehouse": item.get("warehouse"),400				"item_code": item.get("item_code"),401				"pending_qty": item.get("pending_qty"),402				"sales_order_item": item.get("sales_order_item"),403				"bom": item.get("bom")404			})405			so_item_name[item.get("sales_order_item")]= item.get("pending_qty")406		make_production_orders(json.dumps({"items":po_items}), so.name, so.company)407		# Check if Production Orders were raised408		for item in so_item_name:409			po_qty = frappe.db.sql("select sum(qty) from `tabProduction Order` where sales_order=%s and sales_order_item=%s", (so.name, item))410			self.assertEquals(po_qty[0][0], so_item_name.get(item))411def make_sales_order(**args):412	so = frappe.new_doc("Sales Order")413	args = frappe._dict(args)414	if args.transaction_date:415		so.transaction_date = args.transaction_date416	so.company = args.company or "_Test Company"417	so.customer = args.customer or "_Test Customer"418	so.currency = args.currency or "INR"419	if args.selling_price_list:420		so.selling_price_list = args.selling_price_list421	if "warehouse" not in args:422		args.warehouse = "_Test Warehouse - _TC"423	if args.item_list:424		for item in args.item_list:425			so.append("items", item)426	else:427		so.append("items", {428			"item_code": args.item or args.item_code or "_Test Item",429			"warehouse": args.warehouse,430			"qty": args.qty or 10,431			"uom": args.uom or None,432			"rate": args.rate or 100433		})434	so.delivery_date = add_days(so.transaction_date, 10)435	if not args.do_not_save:436		so.insert()437		if not args.do_not_submit:438			so.submit()439		else:440			so.payment_schedule = []441	else:442		so.payment_schedule = []443	return so444def create_dn_against_so(so, delivered_qty=0):445	frappe.db.set_value("Stock Settings", None, "allow_negative_stock", 1)446	dn = make_delivery_note(so)447	dn.get("items")[0].qty = delivered_qty or 5448	dn.insert()449	dn.submit()450	return dn451def get_reserved_qty(item_code="_Test Item", warehouse="_Test Warehouse - _TC"):452	return flt(frappe.db.get_value("Bin", {"item_code": item_code, "warehouse": warehouse},453		"reserved_qty"))...

test_production_planning_tool.py

Source:test_production_planning_tool.py

1# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors2# MIT License. See license.txt3import frappe4import frappe.defaults5import unittest6from frappe.test_runner import make_test_records7from erpnext.manufacturing.doctype.production_planning_tool.production_planning_tool import ProductionPlanningTool8# load test records and dependencies9test_records = frappe.get_test_records('Production Planning Tool')10test_dependencies = ["Item","BOM"]11class TestEvent(unittest.TestCase):12	def test_materials_requests_all_raw_multi_level(self):13		items = ["_Test PPT Item Raw A","_Test PPT Item Raw B","_Test PPT Item Raw C","_Test PPT Item Raw D",14			"_Test PPT Item Sub A","_Test PPT Item Sub B","_Test PPT Item Sub C","_Test PPT Item SC A",15			"_Test PPT Item SC B","_Test PPT Item Master"]16		quantities = [14,9,36,1,0,0,0,0,0,0]17		types = ["Purchase","Purchase","Purchase","Purchase","Manufacture","Manufacture","Manufacture","Purchase",18			"Purchase","Manufacture"]19		self.runtest_materials_requests(items, quantities, types, use_multi_level_bom=1, only_raw_materials=1, \20			include_subcontracted=1)21	def test_materials_requests_multi_no_subcontracted(self):22		items = ["_Test PPT Item Raw A","_Test PPT Item Raw B","_Test PPT Item Raw C","_Test PPT Item Raw D",23			"_Test PPT Item Sub A","_Test PPT Item Sub B","_Test PPT Item Sub C","_Test PPT Item SC A",24			"_Test PPT Item SC B","_Test PPT Item Master"]25		quantities = [14,5,20,0,0,0,0,0,0,0]26		types = ["Purchase","Purchase","Purchase","Purchase","Manufacture","Manufacture","Manufacture","Purchase",27			"Purchase","Manufacture"]28		# This one should fail for now29		self.runtest_materials_requests(items, quantities, types, use_multi_level_bom=1, only_raw_materials=1, \30			include_subcontracted=0)31	def test_materials_requests_manufacture_and_sub_multi_level(self):32		items = ["_Test PPT Item Raw A","_Test PPT Item Raw B","_Test PPT Item Raw C","_Test PPT Item Raw D",33			"_Test PPT Item Sub A","_Test PPT Item Sub B","_Test PPT Item Sub C","_Test PPT Item SC A",34			"_Test PPT Item SC B","_Test PPT Item Master"]35		quantities = [14,9,36,1,2,5,2,1,4,0]36		types = ["Purchase","Purchase","Purchase","Purchase","Manufacture","Manufacture","Manufacture","Purchase",37			"Purchase","Manufacture"]38		self.runtest_materials_requests(items, quantities, types, use_multi_level_bom=1, only_raw_materials=0, \39			include_subcontracted=1)40	def test_materials_requests_manufacture_multi_level(self):41		items = ["_Test PPT Item Raw A","_Test PPT Item Raw B","_Test PPT Item Raw C","_Test PPT Item Raw D",42			"_Test PPT Item Sub A","_Test PPT Item Sub B","_Test PPT Item Sub C","_Test PPT Item SC A",43			"_Test PPT Item SC B","_Test PPT Item Master"]44		quantities = [14,5,20,0,2,5,2,1,4,0]45		types = ["Purchase","Purchase","Purchase","Purchase","Manufacture","Manufacture","Manufacture","Purchase",46			"Purchase","Manufacture"]47		self.runtest_materials_requests(items, quantities, types, use_multi_level_bom=1, only_raw_materials=0, \48			include_subcontracted=0)49	def test_materials_requests_single_level_purch_only(self):50		items = ["_Test PPT Item Raw A","_Test PPT Item Raw B","_Test PPT Item Raw C","_Test PPT Item Raw D",51			"_Test PPT Item Sub A","_Test PPT Item Sub B","_Test PPT Item Sub C","_Test PPT Item SC A",52			"_Test PPT Item SC B","_Test PPT Item Master"]53		quantities = [2,0,0,0,0,0,0,1,0,0]54		types = ["Purchase","Purchase","Purchase","Purchase","Manufacture","Manufacture","Manufacture","Purchase",55			"Purchase","Manufacture"]56		self.runtest_materials_requests(items, quantities, types, use_multi_level_bom=0, only_raw_materials=1, \57			include_subcontracted=0)58	def test_materials_requests_single_level(self):59		items = ["_Test PPT Item Raw A","_Test PPT Item Raw B","_Test PPT Item Raw C","_Test PPT Item Raw D",60			"_Test PPT Item Sub A","_Test PPT Item Sub B","_Test PPT Item Sub C","_Test PPT Item SC A",61			"_Test PPT Item SC B","_Test PPT Item Master"]62		quantities = [2,0,0,0,2,1,0,1,0,0]63		types = ["Purchase","Purchase","Purchase","Purchase","Manufacture","Manufacture","Manufacture","Purchase",64			"Purchase","Manufacture"]65		self.runtest_materials_requests(items, quantities, types, use_multi_level_bom=0, only_raw_materials=0, \66			include_subcontracted=0)67	def runtest_materials_requests(self, items, quantities, types,use_multi_level_bom, only_raw_materials, \68		include_subcontracted):69		clear_material_requests()70		create_test_records()71		ppt = run_production_planning_tool(use_multi_level_bom=use_multi_level_bom,72			only_raw_materials=only_raw_materials, include_subcontracted=include_subcontracted,73			item_code = "_Test PPT Item Master", bom_no = "BOM-_Test PPT Item Master-001",74			planned_qty = 1, planned_start_date = "5/5/2029",75			warehouse = "_Test Warehouse - _TC", company = "_Test Company")76		create_material_requests(ppt)77		for item, qty, type in zip(items, quantities, types):78			self.assertEqual(qty, get_requested_qty(item))79			for mat_req_type in get_requested_types(item):80				self.assertEqual(type, mat_req_type)81def create_test_records():82	from erpnext.stock.doctype.item.test_item import make_item83	subA = make_item("_Test PPT Item Sub A",{84		"item_code": "_Test PPT Item Sub A",85		"item_name": "_Test PPT Item Sub A",86		"description": "A manufactured _Test PPT Item Sub Assembly",87		"default_material_request_type": "Manufacture",88		"is_sub_contracted_item": 0,89		"is_stock_item": 1,90		"stock_uom": "_Test UOM",91		"item_group": "_Test Item Group",92		"default_warehouse": "_Test Warehouse - _TC"})93	subB = make_item("_Test PPT Item Sub B",{94		"item_code": "_Test PPT Item Sub B",95		"item_name": "_Test PPT Item Sub B",96		"description": "A manufactured _Test PPT Item Sub Assembly",97		"default_material_request_type": "Manufacture",98		"is_sub_contracted_item": 0,99		"is_stock_item": 1,100		"stock_uom": "_Test UOM",101		"item_group": "_Test Item Group",102		"default_warehouse": "_Test Warehouse - _TC"})103	subC = make_item("_Test PPT Item Sub C",{104		"item_code": "_Test PPT Item Sub C",105		"item_name": "_Test PPT Item Sub C",106		"description": "A manufactured _Test PPT Item Sub Assembly",107		"default_material_request_type": "Manufacture",108		"is_sub_contracted_item": 0,109		"is_stock_item": 1,110		"stock_uom": "_Test UOM",111		"item_group": "_Test Item Group",112		"default_warehouse": "_Test Warehouse - _TC"})113	sCA = make_item("_Test PPT Item SC A",{114		"item_code": "_Test PPT Item SC A",115		"item_name": "_Test PPT Item SC A",116		"description": "A subcontracted part with raw materials",117		"default_material_request_type": "Purchase",118		"is_sub_contracted_item": 1,119		"is_stock_item": 1,120		"stock_uom": "_Test UOM",121		"item_group": "_Test Item Group",122		"default_warehouse": "_Test Warehouse - _TC"})123	subA = make_item("_Test PPT Item Sub A",{124		"item_code": "_Test PPT Item Sub A",125		"item_name": "_Test PPT Item Sub A",126		"description": "A manufactured _Test PPT Item Sub Assembly",127		"default_material_request_type": "Manufacture",128		"is_sub_contracted_item": 0,129		"is_stock_item": 1,130		"stock_uom": "_Test UOM",131		"item_group": "_Test Item Group",132		"default_warehouse": "_Test Warehouse - _TC"})133	sCB = make_item("_Test PPT Item SC B",{134		"item_code": "_Test PPT Item SC B",135		"item_name": "_Test PPT Item SC B",136		"description": "A subcontracted part with raw materials",137		"default_material_request_type": "Purchase",138		"is_sub_contracted_item": 1,139		"is_stock_item": 1,140		"stock_uom": "_Test UOM",141		"item_group": "_Test Item Group",142		"default_warehouse": "_Test Warehouse - _TC"})143	rawA = make_item("_Test PPT Item Raw A",{144		"item_code": "_Test PPT Item Raw A",145		"item_name": "_Test PPT Item Raw A",146		"description": "A raw material",147		"default_material_request_type": "Purchase",148		"is_sub_contracted_item": 0,149		"is_stock_item": 1,150		"stock_uom": "_Test UOM",151		"item_group": "_Test Item Group",152		"default_warehouse": "_Test Warehouse - _TC"})153	rawB = make_item("_Test PPT Item Raw B",{154		"item_code": "_Test PPT Item Raw B",155		"item_name": "_Test PPT Item Raw B",156		"description": "A raw material",157		"default_material_request_type": "Purchase",158		"is_sub_contracted_item": 0,159		"is_stock_item": 1,160		"stock_uom": "_Test UOM",161		"item_group": "_Test Item Group",162		"default_warehouse": "_Test Warehouse - _TC"})163	rawC = make_item("_Test PPT Item Raw C",{164		"item_code": "_Test PPT Item Raw C",165		"item_name": "_Test PPT Item Raw C",166		"description": "A raw material",167		"default_material_request_type": "Purchase",168		"is_sub_contracted_item": 0,169		"is_stock_item": 1,170		"stock_uom": "_Test UOM",171		"item_group": "_Test Item Group",172		"default_warehouse": "_Test Warehouse - _TC"})173	rawD = make_item("_Test PPT Item Raw D",{174		"item_code": "_Test PPT Item Raw D",175		"item_name": "_Test PPT Item Raw D",176		"description": "A raw material",177		"default_material_request_type": "Purchase",178		"is_sub_contracted_item": 0,179		"is_stock_item": 1,180		"stock_uom": "_Test UOM",181		"item_group": "_Test Item Group",182		"default_warehouse": "_Test Warehouse - _TC"})183	master = make_item("_Test PPT Item Master",{184		"item_code": "_Test PPT Item Master",185		"item_name": "_Test PPT Item Master",186		"description": "The final assembly",187		"default_material_request_type": "Manufacture",188		"is_sub_contracted_item": 0,189		"is_stock_item": 1,190		"stock_uom": "_Test UOM",191		"item_group": "_Test Item Group",192		"default_warehouse": "_Test Warehouse - _TC"})193	bom_subB = make_bom("BOM-_Test PPT Item Sub B-001",{"quantity":1.0,194		"item": "_Test PPT Item Sub B",195		"is_active": 1,196		"is_default": 1,197		"docstatus": 1,198		"with_operations": 0}, [{"item_code": "_Test PPT Item Raw B", "doctype":"BOM Item", "stock_qty":1,199				"rate":100, "amount": 100, "stock_uom": "_Test UOM"},200			{"item_code": "_Test PPT Item Raw C", "doctype":"BOM Item", "stock_qty":4, "rate":100,201				"amount": 400,"stock_uom": "_Test UOM"}])202	bom_subC = make_bom("BOM-_Test PPT Item Sub C-001",{"quantity":1,203		"item": "_Test PPT Item Sub C",204		"is_active": 1,205		"is_default": 1,206		"docstatus": 1,207		"with_operations": 0}, [208			{"item_code": "_Test PPT Item Raw A","item_name": "_Test PPT Item Raw A",209				"doctype":"BOM Item", "stock_qty":6, "rate":100, "amount": 600},210			{"item_code": "_Test PPT Item Sub B","item_name": "_Test PPT Item Sub B",211				"bom_no":"BOM-_Test PPT Item Sub B-001", "doctype":"BOM Item", "stock_qty":2,212				"rate":100, "amount": 200}])213	bom_sCA = make_bom("BOM-_Test PPT Item SC A-001",{"quantity":1,214		"item": "_Test PPT Item SC A",215		"is_active": 1,216		"is_default": 1,217		"docstatus": 1,218		"with_operations": 0}, [219			{"item_code": "_Test PPT Item Raw D","item_name": "_Test PPT Item Raw D",220				"doctype":"BOM Item", "stock_qty":1, "rate":100, "amount": 100}])221	bom_sCB = make_bom("BOM-_Test PPT Item SC B-001",{"quantity":1,222		"item": "_Test PPT Item SC B",223		"is_active": 1,224		"is_default": 1,225		"docstatus": 1,226		"with_operations": 0}, [227			{"item_code": "_Test PPT Item Raw B","item_name": "_Test PPT Item Raw B",228				"doctype":"BOM Item", "stock_qty":1, "rate":100, "amount": 100},229			{"item_code": "_Test PPT Item Raw C","item_name": "_Test PPT Item Raw C",230				"doctype":"BOM Item", "stock_qty":4, "rate":100, "amount": 400}])231	bom_subA = make_bom("BOM-_Test PPT Item Sub A-001",{"quantity":1,232		"item": "_Test PPT Item Sub A",233		"is_active": 1,234		"is_default": 1,235		"docstatus": 1,236		"with_operations": 0}, [237			{"item_code": "_Test PPT Item Sub C","item_name": "_Test PPT Item Sub C",238				"bom_no":"BOM-_Test PPT Item Sub C-001", "doctype":"BOM Item",239				"stock_qty":1, "rate":100, "amount": 100},240			{"item_code": "_Test PPT Item SC B","item_name": "_Test PPT Item SC B",241				"bom_no":"BOM-_Test PPT Item SC B-001", "doctype":"BOM Item", "stock_qty":2,242				"rate":100, "amount": 200}])243	bom_master = make_bom("BOM-_Test PPT Item Master-001",{"quantity":1,244		"item": "_Test PPT Item Master",245		"is_active": 1,246		"is_default": 1,247		"docstatus": 1,248		"with_operations": 0}, [249			{"item_code": "_Test PPT Item Sub A","item_name": "_Test PPT Item Sub A",250				"bom_no":"BOM-_Test PPT Item Sub A-001",251				"doctype":"BOM Item", "stock_qty":2, "rate":100, "amount": 200},252			{"item_code": "_Test PPT Item Sub B","item_name": "_Test PPT Item Sub B",253				"bom_no":"BOM-_Test PPT Item Sub B-001",254				"doctype":"BOM Item", "stock_qty":1, "rate":100, "amount": 100},255			{"item_code": "_Test PPT Item Raw A","item_name": "_Test PPT Item Raw A",256				"doctype":"BOM Item", "stock_qty":2, "rate":100,257				"amount": 200},258			{"item_code": "_Test PPT Item SC A","item_name": "_Test PPT Item SC A",259				"bom_no":"BOM-_Test PPT Item SC A-001",260				"doctype":"BOM Item", "stock_qty":1, "rate":100, "amount": 100}261			])262def make_bom(name, properties=None, items=None):263	if frappe.db.exists("BOM", name):264		return frappe.get_doc("BOM", name)265	bom = frappe.new_doc("BOM")266	item = frappe.get_doc({267		"doctype": "BOM",268		"name": name,269		"quantity": "1",270		"with_operations": 0271	})272	if properties:273		bom.update(properties)274	if items:275		for item in items:276			bom.append("items", item)277	bom.insert()278	bom.submit()279	return bom280def clear_material_requests():281	frappe.db.sql("delete from `tabMaterial Request Item`")282	frappe.db.sql("delete from `tabMaterial Request`")283def run_production_planning_tool(**args):284	ppt = frappe.new_doc("Production Planning Tool")285	args = frappe._dict(args)286	if args.use_multi_level_bom:287		ppt.use_multi_level_bom = args.use_multi_level_bom288	else:289		ppt.use_multi_level_bom = 0290	if args.only_raw_materials:291		ppt.only_raw_materials = args.only_raw_materials292	else:293		ppt.only_raw_materials = 0294	if args.include_subcontracted:295		ppt.include_subcontracted = args.include_subcontracted296	else:297		ppt.include_subcontracted = 0298	if args.warehouse:299		ppt.purchase_request_for_warehouse = args.warehouse300	if args.company:301		ppt.company = args.company302	ppt.create_material_requests_for_all_required_qty = 1303	ppt.append("items",{"item_code": args.item_code, "bom_no": args.bom_no, "planned_qty": args.planned_qty,304		"planned_start_date": args.planned_start_date, "warehouse": args.warehouse})305	return ppt306def create_material_requests(ppt):307	ppt.raise_material_requests()308def get_requested_qty(item_code):309	total_qty = 0310	for d in frappe.db.sql("""select item.qty as qty311		from `tabMaterial Request` mat_req, `tabMaterial Request Item` item312		where item.item_code = %(item_code)s and item.parent = mat_req.name""", {"item_code":item_code}, as_dict=1):313		total_qty += d.qty314	return total_qty315def get_requested_types(item_code):316	types = []317	for d in frappe.db.sql("""select mat_req.material_request_type as type318		from `tabMaterial Request` mat_req, `tabMaterial Request Item` item319		where item.item_code = %(item_code)s and item.parent = mat_req.name""", {"item_code":item_code}, as_dict=1):320		types.append(d.type)...

test_pricing_rule.py

Source:test_pricing_rule.py

1# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors2# License: GNU General Public License v3. See license.txt3from __future__ import unicode_literals4import unittest5import frappe6from erpnext.selling.doctype.sales_order.test_sales_order import make_sales_order7from erpnext.accounts.doctype.sales_invoice.test_sales_invoice import create_sales_invoice8from erpnext.stock.get_item_details import get_item_details9from frappe import MandatoryError10class TestPricingRule(unittest.TestCase):11	def test_pricing_rule_for_discount(self):12		from erpnext.stock.get_item_details import get_item_details13		from frappe import MandatoryError14		frappe.db.sql("delete from `tabPricing Rule`")15		test_record = {16			"doctype": "Pricing Rule",17			"title": "_Test Pricing Rule",18			"apply_on": "Item Code",19			"item_code": "_Test Item",20			"selling": 1,21			"price_or_discount": "Discount Percentage",22			"price": 0,23			"discount_percentage": 10,24			"company": "_Test Company"25		}26		frappe.get_doc(test_record.copy()).insert()27		args = frappe._dict({28			"item_code": "_Test Item",29			"company": "_Test Company",30			"price_list": "_Test Price List",31			"currency": "_Test Currency",32			"doctype": "Sales Order",33			"conversion_rate": 1,34			"price_list_currency": "_Test Currency",35			"plc_conversion_rate": 1,36			"order_type": "Sales",37			"customer": "_Test Customer",38			"name": None39		})40		details = get_item_details(args)41		self.assertEquals(details.get("discount_percentage"), 10)42		prule = frappe.get_doc(test_record.copy())43		prule.applicable_for = "Customer"44		prule.title = "_Test Pricing Rule for Customer"45		self.assertRaises(MandatoryError, prule.insert)46		prule.customer = "_Test Customer"47		prule.discount_percentage = 2048		prule.insert()49		details = get_item_details(args)50		self.assertEquals(details.get("discount_percentage"), 20)51		prule = frappe.get_doc(test_record.copy())52		prule.apply_on = "Item Group"53		prule.item_group = "All Item Groups"54		prule.title = "_Test Pricing Rule for Item Group"55		prule.discount_percentage = 1556		prule.insert()57		args.customer = "_Test Customer 1"58		details = get_item_details(args)59		self.assertEquals(details.get("discount_percentage"), 10)60		prule = frappe.get_doc(test_record.copy())61		prule.applicable_for = "Campaign"62		prule.campaign = "_Test Campaign"63		prule.title = "_Test Pricing Rule for Campaign"64		prule.discount_percentage = 565		prule.priority = 866		prule.insert()67		args.campaign = "_Test Campaign"68		details = get_item_details(args)69		self.assertEquals(details.get("discount_percentage"), 5)70		frappe.db.sql("update `tabPricing Rule` set priority=NULL where campaign='_Test Campaign'")71		from erpnext.accounts.doctype.pricing_rule.pricing_rule	import MultiplePricingRuleConflict72		self.assertRaises(MultiplePricingRuleConflict, get_item_details, args)73		args.item_code = "_Test Item 2"74		details = get_item_details(args)75		self.assertEquals(details.get("discount_percentage"), 15)76		frappe.db.sql("delete from `tabPricing Rule`")77	def test_pricing_rule_for_margin(self):78		from erpnext.stock.get_item_details import get_item_details79		from frappe import MandatoryError80		frappe.db.sql("delete from `tabPricing Rule`")81		test_record = {82			"doctype": "Pricing Rule",83			"title": "_Test Pricing Rule",84			"apply_on": "Item Code",85			"item_code": "_Test FG Item 2",86			"selling": 1,87			"price_or_discount": "Discount Percentage",88			"price": 0,89			"margin_type": "Percentage",90			"margin_rate_or_amount": 10,91			"company": "_Test Company"92		}93		frappe.get_doc(test_record.copy()).insert()94		95		item_price = frappe.get_doc({96			"doctype": "Item Price",97			"price_list": "_Test Price List 2",98			"item_code": "_Test FG Item 2",99			"price_list_rate": 100100		})101		102		item_price.insert(ignore_permissions=True)103		args = frappe._dict({104			"item_code": "_Test FG Item 2",105			"company": "_Test Company",106			"price_list": "_Test Price List",107			"currency": "_Test Currency",108			"doctype": "Sales Order",109			"conversion_rate": 1,110			"price_list_currency": "_Test Currency",111			"plc_conversion_rate": 1,112			"order_type": "Sales",113			"customer": "_Test Customer",114			"name": None115		})116		details = get_item_details(args)117		self.assertEquals(details.get("margin_type"), "Percentage")118		self.assertEquals(details.get("margin_rate_or_amount"), 10)119		frappe.db.sql("delete from `tabPricing Rule`")120	def test_pricing_rule_for_variants(self):121		from erpnext.stock.get_item_details import get_item_details122		from frappe import MandatoryError123		frappe.db.sql("delete from `tabPricing Rule`")124		if not frappe.db.exists("Item", "Test Variant PRT"):125			frappe.get_doc({126				"doctype": "Item",127				"item_code": "Test Variant PRT",128				"item_name": "Test Variant PRT",129				"description": "Test Variant PRT",130				"item_group": "_Test Item Group",131				"is_stock_item": 1,132				"variant_of": "_Test Variant Item",133				"default_warehouse": "_Test Warehouse - _TC",134				"stock_uom": "_Test UOM",135				"attributes": [136					{137					  "attribute": "Test Size",138					  "attribute_value": "Medium"139					}140				],141			}).insert()142		frappe.get_doc({143			"doctype": "Pricing Rule",144			"title": "_Test Pricing Rule 1",145			"apply_on": "Item Code",146			"item_code": "_Test Variant Item",147			"selling": 1,148			"price_or_discount": "Discount Percentage",149			"price": 0,150			"discount_percentage": 7.5,151			"company": "_Test Company"152		}).insert()153		args = frappe._dict({154			"item_code": "Test Variant PRT",155			"company": "_Test Company",156			"price_list": "_Test Price List",157			"currency": "_Test Currency",158			"doctype": "Sales Order",159			"conversion_rate": 1,160			"price_list_currency": "_Test Currency",161			"plc_conversion_rate": 1,162			"order_type": "Sales",163			"customer": "_Test Customer",164			"name": None165		})166		details = get_item_details(args)167		self.assertEquals(details.get("discount_percentage"), 7.5)168		# add a new pricing rule for that item code, it should take priority169		frappe.get_doc({170			"doctype": "Pricing Rule",171			"title": "_Test Pricing Rule 2",172			"apply_on": "Item Code",173			"item_code": "Test Variant PRT",174			"selling": 1,175			"price_or_discount": "Discount Percentage",176			"price": 0,177			"discount_percentage": 17.5,178			"company": "_Test Company"179		}).insert()180		details = get_item_details(args)181		self.assertEquals(details.get("discount_percentage"), 17.5)182	def test_pricing_rule_for_stock_qty(self):183		frappe.db.sql("delete from `tabPricing Rule`")184		test_record = {185			"doctype": "Pricing Rule",186			"title": "_Test Pricing Rule",187			"apply_on": "Item Code",188			"item_code": "_Test Item",189			"selling": 1,190			"price_or_discount": "Discount Percentage",191			"price": 0,192			"min_qty": 5,193			"max_qty": 7,194			"discount_percentage": 17.5,195			"company": "_Test Company"196		}197		frappe.get_doc(test_record.copy()).insert()198		if not frappe.db.get_value('UOM Conversion Detail',199			{'parent': '_Test Item', 'uom': 'box'}):200			item = frappe.get_doc('Item', '_Test Item')201			item.append('uoms', {202				'uom': 'Box',203				'conversion_factor': 5204			})205			item.save(ignore_permissions=True)206		# With pricing rule207		so = make_sales_order(item_code="_Test Item", qty=1, uom="Box", do_not_submit=True)208		so.items[0].price_list_rate = 100209		so.submit()210		so = frappe.get_doc('Sales Order', so.name)211		self.assertEquals(so.items[0].discount_percentage, 17.5)212		self.assertEquals(so.items[0].rate, 82.5)213		# Without pricing rule214		so = make_sales_order(item_code="_Test Item", qty=2, uom="Box", do_not_submit=True)215		so.items[0].price_list_rate = 100216		so.submit()217		so = frappe.get_doc('Sales Order', so.name)218		self.assertEquals(so.items[0].discount_percentage, 0)219		self.assertEquals(so.items[0].rate, 100)220	def test_pricing_rule_with_margin_and_discount(self):221		frappe.delete_doc_if_exists('Pricing Rule', '_Test Pricing Rule')222		make_pricing_rule(selling=1, margin_type="Percentage", margin_rate_or_amount=10)223		si = create_sales_invoice(do_not_save=True)224		si.items[0].price_list_rate = 1000225		si.payment_schedule = []226		si.insert(ignore_permissions=True)227		item = si.items[0]228		self.assertEquals(item.rate, 1100)229		self.assertEquals(item.margin_rate_or_amount, 10)230		# With discount231		item.discount_percentage = 10232		si.payment_schedule = []233		si.save()234		item = si.items[0]235		self.assertEquals(item.rate, 990)236		self.assertEquals(item.discount_percentage, 10)237		frappe.db.sql("delete from `tabPricing Rule`")238def make_pricing_rule(**args):239	args = frappe._dict(args)240	doc = frappe.get_doc({241		"doctype": "Pricing Rule",242		"title": args.title or "_Test Pricing Rule",243		"company": args.company or "_Test Company",244		"apply_on": args.apply_on or "Item Code",245		"item_code": args.item_code or "_Test Item",246		"applicable_for": args.applicable_for,247		"selling": args.selling or 0,248		"buying": args.buying or 0,249		"min_qty": args.min_qty or 0.0,250		"max_qty": args.max_qty or 0.0,251		"price_or_discount": args.price_or_discount or "Discount Percentage",252		"discount_percentage": args.discount_percentage or 0.0,253		"price": args.price or 0.0,254		"margin_type": args.margin_type,255		"margin_rate_or_amount": args.margin_rate_or_amount or 0.0256	}).insert(ignore_permissions=True)257	apply_on = doc.apply_on.replace(' ', '_').lower()258	if args.get(apply_on) and apply_on != "item_code":259		doc.db_set(apply_on, args.get(apply_on))260	applicable_for = doc.applicable_for.replace(' ', '_').lower()261	if args.get(applicable_for):...

test_customer.py

Source:test_customer.py

1# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors2# License: GNU General Public License v3. See license.txt3from __future__ import unicode_literals4import frappe5import unittest6from erpnext.accounts.party import get_due_date7from frappe.test_runner import make_test_records8from erpnext.exceptions import PartyFrozen, PartyDisabled9from frappe.utils import flt10from erpnext.selling.doctype.customer.customer import get_credit_limit, get_customer_outstanding11from erpnext.tests.utils import create_test_contact_and_address12test_ignore = ["Price List"]13test_dependencies = ['Payment Term', 'Payment Terms Template']14test_records = frappe.get_test_records('Customer')15class TestCustomer(unittest.TestCase):16	def setUp(self):17		if not frappe.get_value('Item', '_Test Item'):18			make_test_records('Item')19	def tearDown(self):20		frappe.db.set_value("Customer", '_Test Customer', 'credit_limit', 0.0)21	def test_party_details(self):22		from erpnext.accounts.party import get_party_details23		to_check = {24			'selling_price_list': None,25			'customer_group': '_Test Customer Group',26			'contact_designation': None,27			'customer_address': '_Test Address for Customer-Office',28			'contact_department': None,29			'contact_email': 'test_contact_customer@example.com',30			'contact_mobile': None,31			'sales_team': [],32			'contact_display': '_Test Contact for _Test Customer',33			'contact_person': '_Test Contact for _Test Customer-_Test Customer',34			'territory': u'_Test Territory',35			'contact_phone': '+91 0000000000',36			'customer_name': '_Test Customer'37		}38		create_test_contact_and_address()39		frappe.db.set_value("Contact", "_Test Contact for _Test Customer-_Test Customer",40			"is_primary_contact", 1)41		details = get_party_details("_Test Customer")42		for key, value in to_check.iteritems():43			self.assertEquals(value, details.get(key))44	def test_rename(self):45		# delete communication linked to these 2 customers46		for name in ("_Test Customer 1", "_Test Customer 1 Renamed"):47			frappe.db.sql("""delete from `tabCommunication`48				where communication_type='Comment' and reference_doctype=%s and reference_name=%s""",49				("Customer", name))50		# add comments51		comment = frappe.get_doc("Customer", "_Test Customer 1").add_comment("Comment", "Test Comment for Rename")52		# rename53		frappe.rename_doc("Customer", "_Test Customer 1", "_Test Customer 1 Renamed")54		# check if customer renamed55		self.assertTrue(frappe.db.exists("Customer", "_Test Customer 1 Renamed"))56		self.assertFalse(frappe.db.exists("Customer", "_Test Customer 1"))57		# test that comment gets linked to renamed doc58		self.assertEquals(frappe.db.get_value("Communication", {59			"communication_type": "Comment",60			"reference_doctype": "Customer",61			"reference_name": "_Test Customer 1 Renamed"62		}), comment.name)63		# rename back to original64		frappe.rename_doc("Customer", "_Test Customer 1 Renamed", "_Test Customer 1")65	def test_freezed_customer(self):66		make_test_records("Item")67		frappe.db.set_value("Customer", "_Test Customer", "is_frozen", 1)68		from erpnext.selling.doctype.sales_order.test_sales_order import make_sales_order69		so = make_sales_order(do_not_save= True)70		self.assertRaises(PartyFrozen, so.save)71		frappe.db.set_value("Customer", "_Test Customer", "is_frozen", 0)72		so.save()73	def test_disabled_customer(self):74		make_test_records("Item")75		frappe.db.set_value("Customer", "_Test Customer", "disabled", 1)76		from erpnext.selling.doctype.sales_order.test_sales_order import make_sales_order77		so = make_sales_order(do_not_save=True)78		self.assertRaises(PartyDisabled, so.save)79		frappe.db.set_value("Customer", "_Test Customer", "disabled", 0)80		so.save()81	def test_duplicate_customer(self):82		frappe.db.sql("delete from `tabCustomer` where customer_name='_Test Customer 1'")83		if not frappe.db.get_value("Customer", "_Test Customer 1"):84			test_customer_1 = frappe.get_doc(85				get_customer_dict('_Test Customer 1')).insert(ignore_permissions=True)86		else:87			test_customer_1 = frappe.get_doc("Customer", "_Test Customer 1")88		duplicate_customer = frappe.get_doc(89			get_customer_dict('_Test Customer 1')).insert(ignore_permissions=True)90		self.assertEquals("_Test Customer 1", test_customer_1.name)91		self.assertEquals("_Test Customer 1 - 1", duplicate_customer.name)92		self.assertEquals(test_customer_1.customer_name, duplicate_customer.customer_name)93	def get_customer_outstanding_amount(self):94		from erpnext.selling.doctype.sales_order.test_sales_order import make_sales_order95		outstanding_amt = get_customer_outstanding('_Test Customer', '_Test Company')96		# If outstanding is negative make a transaction to get positive outstanding amount97		if outstanding_amt > 0.0:98			return outstanding_amt99		item_qty = int((abs(outstanding_amt) + 200)/100)100		make_sales_order(qty=item_qty)101		return get_customer_outstanding('_Test Customer', '_Test Company')102	def test_customer_credit_limit(self):103		from erpnext.stock.doctype.delivery_note.test_delivery_note import create_delivery_note104		from erpnext.accounts.doctype.sales_invoice.test_sales_invoice import create_sales_invoice105		from erpnext.selling.doctype.sales_order.test_sales_order import make_sales_order106		from erpnext.selling.doctype.sales_order.sales_order import make_sales_invoice107		outstanding_amt = self.get_customer_outstanding_amount()108		credit_limit = get_credit_limit('_Test Customer', '_Test Company')109		if outstanding_amt <= 0.0:110			item_qty = int((abs(outstanding_amt) + 200)/100)111			make_sales_order(qty=item_qty)112		if credit_limit == 0.0:113			frappe.db.set_value("Customer", '_Test Customer', 'credit_limit', outstanding_amt - 50.0)114		# Sales Order115		so = make_sales_order(do_not_submit=True)116		self.assertRaises(frappe.ValidationError, so.submit)117		# Delivery Note118		dn = create_delivery_note(do_not_submit=True)119		self.assertRaises(frappe.ValidationError, dn.submit)120		# Sales Invoice121		si = create_sales_invoice(do_not_submit=True)122		self.assertRaises(frappe.ValidationError, si.submit)123		if credit_limit > outstanding_amt:124			frappe.db.set_value("Customer", '_Test Customer', 'credit_limit', credit_limit)125		# Makes Sales invoice from Sales Order126		so.save(ignore_permissions=True)127		si = make_sales_invoice(so.name)128		si.save(ignore_permissions=True)129		self.assertRaises(frappe.ValidationError, make_sales_order)130	def test_customer_credit_limit_on_change(self):131		outstanding_amt = self.get_customer_outstanding_amount()132		customer = frappe.get_doc("Customer", '_Test Customer')133		customer.credit_limit = flt(outstanding_amt - 100)134		self.assertRaises(frappe.ValidationError, customer.save)135	def test_customer_payment_terms(self):136		frappe.db.set_value(137			"Customer", "_Test Customer With Template", "payment_terms", "_Test Payment Term Template 3")138		due_date = get_due_date("2016-01-22", "Customer", "_Test Customer With Template")139		self.assertEqual(due_date, "2016-02-21")140		due_date = get_due_date("2017-01-22", "Customer", "_Test Customer With Template")141		self.assertEqual(due_date, "2017-02-21")142		frappe.db.set_value(143			"Customer", "_Test Customer With Template", "payment_terms", "_Test Payment Term Template 1")144		due_date = get_due_date("2016-01-22", "Customer", "_Test Customer With Template")145		self.assertEqual(due_date, "2016-02-29")146		due_date = get_due_date("2017-01-22", "Customer", "_Test Customer With Template")147		self.assertEqual(due_date, "2017-02-28")148		frappe.db.set_value("Customer", "_Test Customer With Template", "payment_terms", "")149		# No default payment term template attached150		due_date = get_due_date("2016-01-22", "Customer", "_Test Customer")151		self.assertEqual(due_date, "2016-01-22")152		due_date = get_due_date("2017-01-22", "Customer", "_Test Customer")153		self.assertEqual(due_date, "2017-01-22")154def get_customer_dict(customer_name):155	return {156		 "customer_group": "_Test Customer Group",157		 "customer_name": customer_name,158		 "customer_type": "Individual",159		 "doctype": "Customer",160		 "territory": "_Test Territory"...

test_budget.py

Source:test_budget.py

1# -*- coding: utf-8 -*-2# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors3# See license.txt4from __future__ import unicode_literals5import frappe6import unittest7from erpnext.accounts.doctype.budget.budget import get_actual_expense, BudgetError8from erpnext.accounts.doctype.journal_entry.test_journal_entry import make_journal_entry9class TestBudget(unittest.TestCase):		10	def test_monthly_budget_crossed_ignore(self):11		set_total_expense_zero("2013-02-28", "Cost Center")12		budget = make_budget("Cost Center")13		14		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",15			"_Test Bank - _TC", 40000, "_Test Cost Center - _TC", submit=True)16		self.assertTrue(frappe.db.get_value("GL Entry",17			{"voucher_type": "Journal Entry", "voucher_no": jv.name}))18			19		budget.cancel()20	def test_monthly_budget_crossed_stop1(self):21		set_total_expense_zero("2013-02-28", "Cost Center")22		budget = make_budget("Cost Center")23		24		frappe.db.set_value("Budget", budget.name, "action_if_accumulated_monthly_budget_exceeded", "Stop")25		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",26			"_Test Bank - _TC", 40000, "_Test Cost Center - _TC")27		self.assertRaises(BudgetError, jv.submit)28		29		budget.load_from_db()30		budget.cancel()31	def test_monthly_budget_crossed_stop2(self):32		set_total_expense_zero("2013-02-28", "Project")33		budget = make_budget("Project")34		35		frappe.db.set_value("Budget", budget.name, "action_if_accumulated_monthly_budget_exceeded", "Stop")36		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",37			"_Test Bank - _TC", 40000, "_Test Cost Center - _TC", project="_Test Project")38		self.assertRaises(BudgetError, jv.submit)39		40		budget.load_from_db()41		budget.cancel()42	def test_yearly_budget_crossed_stop1(self):43		set_total_expense_zero("2013-02-28", "Cost Center")44		budget = make_budget("Cost Center")45		46		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",47			"_Test Bank - _TC", 150000, "_Test Cost Center - _TC")48		self.assertRaises(BudgetError, jv.submit)49		50		budget.cancel()51	def test_yearly_budget_crossed_stop2(self):52		set_total_expense_zero("2013-02-28", "Project")53		budget = make_budget("Project")54		55		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",56			"_Test Bank - _TC", 150000, "_Test Cost Center - _TC", project="_Test Project")57		self.assertRaises(BudgetError, jv.submit)58		59		budget.cancel()60	def test_monthly_budget_on_cancellation1(self):61		set_total_expense_zero("2013-02-28", "Cost Center")62		budget = make_budget("Cost Center")63				64		jv1 = make_journal_entry("_Test Account Cost for Goods Sold - _TC",65			"_Test Bank - _TC", 20000, "_Test Cost Center - _TC", submit=True)66		self.assertTrue(frappe.db.get_value("GL Entry",67			{"voucher_type": "Journal Entry", "voucher_no": jv1.name}))68		jv2 = make_journal_entry("_Test Account Cost for Goods Sold - _TC",69			"_Test Bank - _TC", 20000, "_Test Cost Center - _TC", submit=True)70		self.assertTrue(frappe.db.get_value("GL Entry",71			{"voucher_type": "Journal Entry", "voucher_no": jv2.name}))72		frappe.db.set_value("Budget", budget.name, "action_if_accumulated_monthly_budget_exceeded", "Stop")73		74		self.assertRaises(BudgetError, jv1.cancel)75		76		budget.load_from_db()77		budget.cancel()78	def test_monthly_budget_on_cancellation2(self):79		set_total_expense_zero("2013-02-28", "Project")80		budget = make_budget("Project")81				82		jv1 = make_journal_entry("_Test Account Cost for Goods Sold - _TC",83			"_Test Bank - _TC", 20000, "_Test Cost Center - _TC", submit=True, project="_Test Project")84		self.assertTrue(frappe.db.get_value("GL Entry",85			{"voucher_type": "Journal Entry", "voucher_no": jv1.name}))86		jv2 = make_journal_entry("_Test Account Cost for Goods Sold - _TC",87			"_Test Bank - _TC", 20000, "_Test Cost Center - _TC", submit=True, project="_Test Project")88		self.assertTrue(frappe.db.get_value("GL Entry",89			{"voucher_type": "Journal Entry", "voucher_no": jv2.name}))90		frappe.db.set_value("Budget", budget.name, "action_if_accumulated_monthly_budget_exceeded", "Stop")91		92		self.assertRaises(BudgetError, jv1.cancel)93		94		budget.load_from_db()95		budget.cancel()96		97	def test_monthly_budget_against_group_cost_center(self):98		set_total_expense_zero("2013-02-28", "Cost Center")99		set_total_expense_zero("2013-02-28", "Cost Center", "_Test Cost Center 2 - _TC")100		101		budget = make_budget("Cost Center", "_Test Company - _TC")102		frappe.db.set_value("Budget", budget.name, "action_if_accumulated_monthly_budget_exceeded", "Stop")103		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",104			"_Test Bank - _TC", 40000, "_Test Cost Center 2 - _TC")105		self.assertRaises(BudgetError, jv.submit)106		107		budget.load_from_db()108		budget.cancel()109	def test_monthly_budget_against_parent_group_cost_center(self):110		cost_center = "_Test Cost Center 3 - _TC"111		if not frappe.db.exists("Cost Center", cost_center):112			frappe.get_doc({113				'doctype': 'Cost Center',114				'cost_center_name': '_Test Cost Center 3',115				'parent_cost_center': "_Test Company - _TC",116				'company': '_Test Company',117				'is_group': 0118			}).insert(ignore_permissions=True)119		budget = make_budget("Cost Center", cost_center)120		frappe.db.set_value("Budget", budget.name, "action_if_accumulated_monthly_budget_exceeded", "Stop")121		jv = make_journal_entry("_Test Account Cost for Goods Sold - _TC",122			"_Test Bank - _TC", 40000, cost_center)123		self.assertRaises(BudgetError, jv.submit)124		budget.load_from_db()125		budget.cancel()126		jv.cancel()127		frappe.delete_doc('Journal Entry', jv.name)128		frappe.delete_doc('Cost Center', cost_center)129def set_total_expense_zero(posting_date, budget_against_field=None, budget_against_CC=None):130	if budget_against_field == "Project":131		budget_against = "_Test Project"132	else:133		budget_against = budget_against_CC or "_Test Cost Center - _TC"134	existing_expense = get_actual_expense(frappe._dict({135		"account": "_Test Account Cost for Goods Sold - _TC",136		"cost_center": "_Test Cost Center - _TC",137		"monthly_end_date": posting_date,138		"company": "_Test Company",139		"fiscal_year": "_Test Fiscal Year 2013",140		"budget_against_field": budget_against_field,141		"budget_against": budget_against142	}))143	144	if existing_expense:145		if budget_against_field == "Cost Center":146			make_journal_entry("_Test Account Cost for Goods Sold - _TC",147			"_Test Bank - _TC", -existing_expense, "_Test Cost Center - _TC", submit=True)148		elif budget_against_field == "Project":149			make_journal_entry("_Test Account Cost for Goods Sold - _TC",150			"_Test Bank - _TC", -existing_expense, "_Test Cost Center - _TC", submit=True, project="_Test Project")151		152def make_budget(budget_against=None, cost_center=None):153	if budget_against == "Project":154		budget_list = frappe.get_all("Budget", fields=["name"], filters = {"name": ("like", "_Test Project/_Test Fiscal Year 2013%")})155	else:156		cost_center_name = "{0}%".format(cost_center or "_Test Cost Center - _TC/_Test Fiscal Year 2013")157		budget_list = frappe.get_all("Budget", fields=["name"], filters = {"name": ("like", cost_center_name)})158	for d in budget_list:159		frappe.db.sql("delete from `tabBudget` where name = %(name)s", d)160		frappe.db.sql("delete from `tabBudget Account` where parent = %(name)s", d)161	budget = frappe.new_doc("Budget")162	163	if budget_against == "Project":164		budget.project = "_Test Project"165	else:166		budget.cost_center =cost_center or "_Test Cost Center - _TC"167	168	169	budget.fiscal_year = "_Test Fiscal Year 2013"170	budget.monthly_distribution = "_Test Distribution"171	budget.company = "_Test Company"172	budget.action_if_annual_budget_exceeded = "Stop"173	budget.action_if_accumulated_monthly_budget_exceeded = "Ignore"174	budget.budget_against = budget_against175	budget.append("accounts", {176		"account": "_Test Account Cost for Goods Sold - _TC",177		"budget_amount": 100000178	})179	180	budget.insert()181	budget.submit()...

test_item.py

Source:test_item.py

1# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors2# License: GNU General Public License v3. See license.txt3from __future__ import unicode_literals4import unittest5import webnotes6test_ignore = ["BOM"]7test_dependencies = ["Warehouse"]8class TestItem(unittest.TestCase):9	def test_default_warehouse(self):10		from stock.doctype.item.item import WarehouseNotSet11		item = webnotes.bean(copy=test_records[0])12		item.doc.is_stock_item = "Yes"13		item.doc.default_warehouse = None14		self.assertRaises(WarehouseNotSet, item.insert)15test_records = [16	[{17		"doctype": "Item",18		"item_code": "_Test Item",19		"item_name": "_Test Item",20		"description": "_Test Item",21		"item_group": "_Test Item Group",22		"is_stock_item": "Yes",23		"is_asset_item": "No",24		"has_batch_no": "No",25		"has_serial_no": "No",26		"is_purchase_item": "Yes",27		"is_sales_item": "Yes",28		"is_service_item": "No",29		"inspection_required": "No",30		"is_pro_applicable": "Yes",31		"is_sub_contracted_item": "No",32		"stock_uom": "_Test UOM",33		"default_income_account": "Sales - _TC",34		"default_warehouse": "_Test Warehouse - _TC",35		"purchase_account": "_Test Account Cost for Goods Sold - _TC"36	}, {37		"doctype": "Item Reorder",38		"parentfield": "item_reorder",39		"warehouse": "_Test Warehouse - _TC",40		"warehouse_reorder_level": 20,41		"warehouse_reorder_qty": 20,42		"material_request_type": "Purchase"43	},44	],45	[{46		"doctype": "Item",47		"item_code": "_Test Item 2",48		"item_name": "_Test Item 2",49		"description": "_Test Item 2",50		"item_group": "_Test Item Group",51		"is_stock_item": "Yes",52		"is_asset_item": "No",53		"has_batch_no": "No",54		"has_serial_no": "No",55		"is_purchase_item": "Yes",56		"is_sales_item": "Yes",57		"is_service_item": "No",58		"inspection_required": "No",59		"is_pro_applicable": "Yes",60		"is_sub_contracted_item": "No",61		"stock_uom": "_Test UOM",62		"default_income_account": "Sales - _TC",63		"default_warehouse": "_Test Warehouse - _TC",64		"purchase_account": "_Test Account Cost for Goods Sold - _TC"65	}],	66	[{67		"doctype": "Item",68		"item_code": "_Test Item Home Desktop 100",69		"item_name": "_Test Item Home Desktop 100",70		"description": "_Test Item Home Desktop 100",71		"item_group": "_Test Item Group Desktops",72		"default_warehouse": "_Test Warehouse - _TC",73		"default_income_account": "Sales - _TC",74		"purchase_account": "_Test Account Cost for Goods Sold - _TC",75		"is_stock_item": "Yes",76		"is_asset_item": "No",77		"has_batch_no": "No",78		"has_serial_no": "No",79		"is_purchase_item": "Yes",80		"is_sales_item": "Yes",81		"is_service_item": "No",82		"inspection_required": "No",83		"is_pro_applicable": "No",84		"is_sub_contracted_item": "No",85		"is_manufactured_item": "No",86		"stock_uom": "_Test UOM"87	},88	{89		"doctype": "Item Tax",90		"tax_type": "_Test Account Excise Duty - _TC",91		"tax_rate": 1092	}],93	[{94		"doctype": "Item",95		"item_code": "_Test Item Home Desktop 200",96		"item_name": "_Test Item Home Desktop 200",97		"description": "_Test Item Home Desktop 200",98		"item_group": "_Test Item Group Desktops",99		"default_warehouse": "_Test Warehouse - _TC",100		"default_income_account": "Sales - _TC",101		"purchase_account": "_Test Account Cost for Goods Sold - _TC",102		"is_stock_item": "Yes",103		"is_asset_item": "No",104		"has_batch_no": "No",105		"has_serial_no": "No",106		"is_purchase_item": "Yes",107		"is_sales_item": "Yes",108		"is_service_item": "No",109		"inspection_required": "No",110		"is_pro_applicable": "No",111		"is_sub_contracted_item": "No",112		"is_manufactured_item": "No",113		"stock_uom": "_Test UOM"114	}],115	[{116		"doctype": "Item",117		"item_code": "_Test Sales BOM Item",118		"item_name": "_Test Sales BOM Item",119		"description": "_Test Sales BOM Item",120		"item_group": "_Test Item Group Desktops",121		"default_income_account": "Sales - _TC",122		"purchase_account": "_Test Account Cost for Goods Sold - _TC",123		"is_stock_item": "No",124		"is_asset_item": "No",125		"has_batch_no": "No",126		"has_serial_no": "No",127		"is_purchase_item": "Yes",128		"is_sales_item": "Yes",129		"is_service_item": "No",130		"inspection_required": "No",131		"is_pro_applicable": "No",132		"is_sub_contracted_item": "No",133		"stock_uom": "_Test UOM"134	}],135	[{136		"doctype": "Item",137		"item_code": "_Test FG Item",138		"item_name": "_Test FG Item",139		"description": "_Test FG Item",140		"item_group": "_Test Item Group Desktops",141		"is_stock_item": "Yes",142		"default_warehouse": "_Test Warehouse - _TC",143		"default_income_account": "Sales - _TC",144		"purchase_account": "_Test Account Cost for Goods Sold - _TC",145		"is_asset_item": "No",146		"has_batch_no": "No",147		"has_serial_no": "No",148		"is_purchase_item": "Yes",149		"is_sales_item": "Yes",150		"is_service_item": "No",151		"inspection_required": "No",152		"is_pro_applicable": "Yes",153		"is_sub_contracted_item": "Yes",154		"stock_uom": "_Test UOM"155	}],156	[{157		"doctype": "Item",158		"item_code": "_Test Non Stock Item",159		"item_name": "_Test Non Stock Item",160		"description": "_Test Non Stock Item",161		"item_group": "_Test Item Group Desktops",162		"is_stock_item": "No",163		"is_asset_item": "No",164		"has_batch_no": "No",165		"has_serial_no": "No",166		"is_purchase_item": "Yes",167		"is_sales_item": "Yes",168		"is_service_item": "No",169		"inspection_required": "No",170		"is_pro_applicable": "No",171		"is_sub_contracted_item": "No",172		"stock_uom": "_Test UOM"173	}],174	[{175		"doctype": "Item",176		"item_code": "_Test Serialized Item",177		"item_name": "_Test Serialized Item",178		"description": "_Test Serialized Item",179		"item_group": "_Test Item Group Desktops",180		"is_stock_item": "Yes",181		"default_warehouse": "_Test Warehouse - _TC",182		"is_asset_item": "No",183		"has_batch_no": "No",184		"has_serial_no": "Yes",185		"is_purchase_item": "Yes",186		"is_sales_item": "Yes",187		"is_service_item": "No",188		"inspection_required": "No",189		"is_pro_applicable": "No",190		"is_sub_contracted_item": "No",191		"stock_uom": "_Test UOM"192	}],193	[{194		"doctype": "Item",195		"item_code": "_Test Serialized Item With Series",196		"item_name": "_Test Serialized Item With Series",197		"description": "_Test Serialized Item",198		"item_group": "_Test Item Group Desktops",199		"is_stock_item": "Yes",200		"default_warehouse": "_Test Warehouse - _TC",201		"is_asset_item": "No",202		"has_batch_no": "No",203		"has_serial_no": "Yes",204		"serial_no_series": "ABCD.#####",205		"is_purchase_item": "Yes",206		"is_sales_item": "Yes",207		"is_service_item": "No",208		"inspection_required": "No",209		"is_pro_applicable": "Yes",210		"is_sub_contracted_item": "No",211		"stock_uom": "_Test UOM"212	}],213	[{214		"doctype": "Item",215		"item_code": "_Test Item Home Desktop Manufactured",216		"item_name": "_Test Item Home Desktop Manufactured",217		"description": "_Test Item Home Desktop Manufactured",218		"item_group": "_Test Item Group Desktops",219		"default_warehouse": "_Test Warehouse - _TC",220		"default_income_account": "Sales - _TC",221		"purchase_account": "_Test Account Cost for Goods Sold - _TC",222		"is_stock_item": "Yes",223		"is_asset_item": "No",224		"has_batch_no": "No",225		"has_serial_no": "No",226		"is_purchase_item": "Yes",227		"is_sales_item": "Yes",228		"is_service_item": "No",229		"inspection_required": "No",230		"is_pro_applicable": "Yes",231		"is_sub_contracted_item": "No",232		"is_manufactured_item": "Yes",233		"stock_uom": "_Test UOM"234	}],235	[{236		"doctype": "Item",237		"item_code": "_Test FG Item 2",238		"item_name": "_Test FG Item 2",239		"description": "_Test FG Item 2",240		"item_group": "_Test Item Group Desktops",241		"is_stock_item": "Yes",242		"default_warehouse": "_Test Warehouse - _TC",243		"default_income_account": "Sales - _TC",244		"purchase_account": "_Test Account Cost for Goods Sold - _TC",245		"is_asset_item": "No",246		"has_batch_no": "No",247		"has_serial_no": "No",248		"is_purchase_item": "Yes",249		"is_sales_item": "Yes",250		"is_service_item": "No",251		"inspection_required": "No",252		"is_pro_applicable": "Yes",253		"is_sub_contracted_item": "Yes",254		"stock_uom": "_Test UOM"255	}],...

test_tax_rule.py

Source:test_tax_rule.py

1# -*- coding: utf-8 -*-2# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors3# See license.txt4from __future__ import unicode_literals5import frappe6import unittest7from erpnext.accounts.doctype.tax_rule.tax_rule import IncorrectCustomerGroup, IncorrectSupplierType, ConflictingTaxRule, get_tax_template8test_records = frappe.get_test_records('Tax Rule')9class TestTaxRule(unittest.TestCase):10	def setUp(self):11		frappe.db.sql("delete from `tabTax Rule`")12	def tearDown(self):13		frappe.db.sql("delete from `tabTax Rule`")14	def test_conflict(self):15		tax_rule1 = make_tax_rule(customer= "_Test Customer",16			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1)17		tax_rule1.save()18		tax_rule2 = make_tax_rule(customer= "_Test Customer",19			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1)20		self.assertRaises(ConflictingTaxRule, tax_rule2.save)21	def test_conflict_with_non_overlapping_dates(self):22		tax_rule1 = make_tax_rule(customer= "_Test Customer",23			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1, from_date = "2015-01-01")24		tax_rule1.save()25		tax_rule2 = make_tax_rule(customer= "_Test Customer",26			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1, to_date = "2013-01-01")27		tax_rule2.save()28		self.assertTrue(tax_rule2.name)29	def test_for_parent_customer_group(self):30		tax_rule1 = make_tax_rule(customer_group= "All Customer Groups",31			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1, from_date = "2015-01-01")32		tax_rule1.save()33		self.assertEquals(get_tax_template("2015-01-01", {"customer_group" : "Commercial", "use_for_shopping_cart":0}),34			"_Test Sales Taxes and Charges Template - _TC")35	def test_conflict_with_overlapping_dates(self):36		tax_rule1 = make_tax_rule(customer= "_Test Customer",37			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1, from_date = "2015-01-01", to_date = "2015-01-05")38		tax_rule1.save()39		tax_rule2 = make_tax_rule(customer= "_Test Customer",40			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority = 1, from_date = "2015-01-03", to_date = "2015-01-09")41		self.assertRaises(ConflictingTaxRule, tax_rule2.save)42	def test_tax_template(self):43		tax_rule = make_tax_rule()44		self.assertEquals(tax_rule.purchase_tax_template, None)45	def test_select_tax_rule_based_on_customer(self):46		make_tax_rule(customer= "_Test Customer",47			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", save=1)48		make_tax_rule(customer= "_Test Customer 1",49			sales_tax_template = "_Test Sales Taxes and Charges Template 1 - _TC", save=1)50		make_tax_rule(customer= "_Test Customer 2",51			sales_tax_template = "_Test Sales Taxes and Charges Template 2 - _TC", save=1)52		self.assertEquals(get_tax_template("2015-01-01", {"customer":"_Test Customer 2"}),53			"_Test Sales Taxes and Charges Template 2 - _TC")54	def test_select_tax_rule_based_on_better_match(self):55		make_tax_rule(customer= "_Test Customer", billing_city = "Test City", billing_state = "Test State",56			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", save=1)57		make_tax_rule(customer= "_Test Customer",  billing_city = "Test City1", billing_state = "Test State",58			sales_tax_template = "_Test Sales Taxes and Charges Template 1 - _TC", save=1)59		self.assertEquals(get_tax_template("2015-01-01", {"customer":"_Test Customer", "billing_city": "Test City", "billing_state": "Test State"}),60			"_Test Sales Taxes and Charges Template - _TC")61	def test_select_tax_rule_based_on_state_match(self):62		make_tax_rule(customer= "_Test Customer", shipping_state = "Test State",63			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", save=1)64		make_tax_rule(customer= "_Test Customer", shipping_state = "Test State12",65			sales_tax_template = "_Test Sales Taxes and Charges Template 1 - _TC", priority=2, save=1)66		self.assertEquals(get_tax_template("2015-01-01", {"customer":"_Test Customer", "shipping_state": "Test State"}),67			"_Test Sales Taxes and Charges Template - _TC")68	def test_select_tax_rule_based_on_better_priority(self):69		make_tax_rule(customer= "_Test Customer", billing_city = "Test City",70			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", priority=1, save=1)71		make_tax_rule(customer= "_Test Customer", billing_city = "Test City",72			sales_tax_template = "_Test Sales Taxes and Charges Template 1 - _TC", priority=2, save=1)73		self.assertEquals(get_tax_template("2015-01-01", {"customer":"_Test Customer", "billing_city": "Test City"}),74			"_Test Sales Taxes and Charges Template 1 - _TC")75	def test_select_tax_rule_based_cross_matching_keys(self):76		make_tax_rule(customer= "_Test Customer", billing_city = "Test City",77			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", save=1)78		make_tax_rule(customer= "_Test Customer 1", billing_city = "Test City 1",79			sales_tax_template = "_Test Sales Taxes and Charges Template 1 - _TC", save=1)80		self.assertEquals(get_tax_template("2015-01-01", {"customer":"_Test Customer", "billing_city": "Test City 1"}),81			None)82	def test_select_tax_rule_based_cross_partially_keys(self):83		make_tax_rule(customer= "_Test Customer", billing_city = "Test City",84			sales_tax_template = "_Test Sales Taxes and Charges Template - _TC", save=1)85		make_tax_rule(billing_city = "Test City 1",86			sales_tax_template = "_Test Sales Taxes and Charges Template 1 - _TC", save=1)87		self.assertEquals(get_tax_template("2015-01-01", {"customer":"_Test Customer", "billing_city": "Test City 1"}),88			"_Test Sales Taxes and Charges Template 1 - _TC")89def make_tax_rule(**args):90	args = frappe._dict(args)91	tax_rule = frappe.new_doc("Tax Rule")92	for key, val in args.iteritems():93		if key != "save":94			tax_rule.set(key, val)95	tax_rule.company = args.company or "_Test Company"96	if args.save:97		tax_rule.insert()...

test_account.py

Source:test_account.py

1# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors2# License: GNU General Public License v3. See license.txt3from __future__ import unicode_literals4import unittest5import frappe6from erpnext.stock import get_warehouse_account, get_company_default_inventory_account7class TestAccount(unittest.TestCase):8	def test_rename_account(self):9		if not frappe.db.exists("Account", "1210 - Debtors - _TC"):10			acc = frappe.new_doc("Account")11			acc.account_name = "Debtors"12			acc.parent_account = "Accounts Receivable - _TC"13			acc.account_number = "1210"14			acc.company = "_Test Company"15			acc.insert()16		account_number, account_name = frappe.db.get_value("Account", "1210 - Debtors - _TC",17			["account_number", "account_name"])18		self.assertEqual(account_number, "1210")19		self.assertEqual(account_name, "Debtors")20		frappe.rename_doc("Account", "1210 - Debtors - _TC", "1211 - Debtors 1 - _TC")21		new_acc = frappe.db.get_value("Account", "1211 - Debtors 1 - _TC",22			["account_name", "account_number"], as_dict=1)23		self.assertEqual(new_acc.account_name, "Debtors 1")24		self.assertEqual(new_acc.account_number, "1211")25		frappe.rename_doc("Account", "1211 - Debtors 1 - _TC", "Debtors 2")26		new_acc = frappe.db.get_value("Account", "1211 - Debtors 2 - _TC",27			["account_name", "account_number"], as_dict=1)28		self.assertEqual(new_acc.account_name, "Debtors 2")29		self.assertEqual(new_acc.account_number, "1211")30		frappe.delete_doc("Account", "1211 - Debtors 2 - _TC")31def _make_test_records(verbose):32	from frappe.test_runner import make_test_objects33	accounts = [34		# [account_name, parent_account, is_group]35		["_Test Bank", "Bank Accounts", 0, "Bank", None],36		["_Test Bank USD", "Bank Accounts", 0, "Bank", "USD"],37		["_Test Bank EUR", "Bank Accounts", 0, "Bank", "EUR"],38		["_Test Cash", "Cash In Hand", 0, "Cash", None],39		["_Test Account Stock Expenses", "Direct Expenses", 1, None, None],40		["_Test Account Shipping Charges", "_Test Account Stock Expenses", 0, "Chargeable", None],41		["_Test Account Customs Duty", "_Test Account Stock Expenses", 0, "Tax", None],42		["_Test Account Insurance Charges", "_Test Account Stock Expenses", 0, "Chargeable", None],43		["_Test Account Stock Adjustment", "_Test Account Stock Expenses", 0, "Stock Adjustment", None],44		["_Test Employee Advance", "Current Liabilities", 0, None, None],45		["_Test Account Tax Assets", "Current Assets", 1, None, None],46		["_Test Account VAT", "_Test Account Tax Assets", 0, "Tax", None],47		["_Test Account Service Tax", "_Test Account Tax Assets", 0, "Tax", None],48		["_Test Account Reserves and Surplus", "Current Liabilities", 0, None, None],49		["_Test Account Cost for Goods Sold", "Expenses", 0, None, None],50		["_Test Account Excise Duty", "_Test Account Tax Assets", 0, "Tax", None],51		["_Test Account Education Cess", "_Test Account Tax Assets", 0, "Tax", None],52		["_Test Account S&H Education Cess", "_Test Account Tax Assets", 0, "Tax", None],53		["_Test Account CST", "Direct Expenses", 0, "Tax", None],54		["_Test Account Discount", "Direct Expenses", 0, None, None],55		["_Test Write Off", "Indirect Expenses", 0, None, None],56		["_Test Exchange Gain/Loss", "Indirect Expenses", 0, None, None],57		# related to Account Inventory Integration58		["_Test Account Stock In Hand", "Current Assets", 0, None, None],59		60		# fixed asset depreciation61		["_Test Fixed Asset", "Current Assets", 0, "Fixed Asset", None],62		["_Test Accumulated Depreciations", "Current Assets", 0, None, None],63		["_Test Depreciations", "Expenses", 0, None, None],64		["_Test Gain/Loss on Asset Disposal", "Expenses", 0, None, None],65		# Receivable / Payable Account66		["_Test Receivable", "Current Assets", 0, "Receivable", None],67		["_Test Payable", "Current Liabilities", 0, "Payable", None],68		["_Test Receivable USD", "Current Assets", 0, "Receivable", "USD"],69		["_Test Payable USD", "Current Liabilities", 0, "Payable", "USD"]70	]71	for company, abbr in [["_Test Company", "_TC"], ["_Test Company 1", "_TC1"]]:72		test_objects = make_test_objects("Account", [{73				"doctype": "Account",74				"account_name": account_name,75				"parent_account": parent_account + " - " + abbr,76				"company": company,77				"is_group": is_group,78				"account_type": account_type,79				"account_currency": currency80			} for account_name, parent_account, is_group, account_type, currency in accounts])81	return test_objects82def get_inventory_account(company, warehouse=None):83	account = None84	if warehouse:85		account = get_warehouse_account(warehouse, company)86	else:87		account = get_company_default_inventory_account(company)88	return account89def create_account(**kwargs):90	account = frappe.get_doc(dict(91		doctype = "Account",92		account_name = kwargs.get('account_name'),93		account_type = kwargs.get('account_type'),94		parent_account = kwargs.get('parent_account'),95		company = kwargs.get('company')96	))97	98	account.save()...

Using AI Code Generation

1var wpt = require('webpagetest');2var util = require('util');3var wpt = new WebPageTest('www.webpagetest.org');4    if (err) return console.error(err);5    console.log(util.inspect(data));6});

Using AI Code Generation

1var wpt = require('./wpt.js');2var wpt_test = new wpt('_test');3    console.log(data);4});5var wpt = require('./wpt.js');6var wpt_test = new wpt('_test');7    console.log(data);8}, 'Dulles:Chrome');9var wpt = require('./wpt.js');10var wpt_test = new wpt('_test');11var options = {12};13    console.log(data);14}, 'Dulles:Chrome', options);15var wpt = require('./wpt.js');16var wpt_test = new wpt('_test');17wpt_test.getTestResults('140417_9X_6c4d6b4b6c8b6f4b6d4b6e4b6f4b6d4b', function(data){18    console.log(data);19});20var wpt = require('./wpt.js');21var wpt_test = new wpt('_test');22wpt_test.getTestResults('140417_9X_6c4d6b4b6c8b6f4b6d4b6e4b6f4b6d4b', function(data){23    console.log(data);24}, 'Dulles:Chrome');25var wpt = require('./wpt.js');26var wpt_test = new wpt('_test');27var options = {

Using AI Code Generation

1var wpt = require('webpagetest');2var wpt = new WebPageTest('www.webpagetest.org');3wpt._test(url, function(err, data) {4  if (err) return console.error(err);5  console.log('Test id: %s', data.data.testId);6  console.log('Owner Key: %s', data.data.ownerKey);7});

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.