Fixed Demo
diff --git a/erpnext/demo/setup/__init__.py b/erpnext/demo/setup/__init__.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/erpnext/demo/setup/__init__.py
diff --git a/erpnext/demo/setup/education.py b/erpnext/demo/setup/education.py
new file mode 100644
index 0000000..b164057
--- /dev/null
+++ b/erpnext/demo/setup/education.py
@@ -0,0 +1,140 @@
+# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
+# License: GNU General Public License v3. See license.txt
+
+import frappe, json
+from frappe.utils.make_random import get_random
+from datetime import datetime
+from erpnext.demo.setup.setup_data import import_json
+import random
+
+def setup_data():
+ frappe.flags.mute_emails = True
+ make_masters()
+ setup_item()
+ make_student_applicants()
+ make_student_group()
+ make_fees_category()
+ make_fees_structure()
+ frappe.db.commit()
+ frappe.clear_cache()
+
+def make_masters():
+ import_json("Room")
+ import_json("Department")
+ import_json("Instructor")
+ import_json("Course")
+ import_json("Program")
+ frappe.db.commit()
+
+def setup_item():
+ items = json.loads(open(frappe.get_app_path('erpnext', 'demo', 'data', 'item_schools.json')).read())
+ for i in items:
+ item = frappe.new_doc('Item')
+ item.update(i)
+ item.min_order_qty = random.randint(10, 30)
+ item.default_warehouse = frappe.get_all('Warehouse', filters={'warehouse_name': item.default_warehouse}, limit=1)[0].name
+ item.insert()
+
+def make_student_applicants():
+ blood_group = ["A+", "A-", "B+", "B-", "AB+", "AB-", "O+", "O-"]
+ male_names = []
+ female_names = []
+
+ file_path = get_json_path("Random Student Data")
+ with open(file_path, "r") as open_file:
+ random_student_data = json.loads(open_file.read())
+ count = 1
+
+ for d in random_student_data:
+ if d.get('gender') == "Male":
+ male_names.append(d.get('first_name').title())
+
+ if d.get('gender') == "Female":
+ female_names.append(d.get('first_name').title())
+
+ for idx, d in enumerate(random_student_data):
+ student_applicant = frappe.new_doc("Student Applicant")
+ student_applicant.first_name = d.get('first_name').title()
+ student_applicant.last_name = d.get('last_name').title()
+ student_applicant.image = d.get('image')
+ student_applicant.gender = d.get('gender')
+ student_applicant.program = get_random("Program")
+ student_applicant.blood_group = random.choice(blood_group)
+ year = random.randint(1990, 1998)
+ month = random.randint(1, 12)
+ day = random.randint(1, 28)
+ student_applicant.date_of_birth = datetime(year, month, day)
+ student_applicant.mother_name = random.choice(female_names) + " " + d.get('last_name').title()
+ student_applicant.father_name = random.choice(male_names) + " " + d.get('last_name').title()
+ if student_applicant.gender == "Male":
+ student_applicant.middle_name = random.choice(male_names)
+ else:
+ student_applicant.middle_name = random.choice(female_names)
+ student_applicant.student_email_id = d.get('first_name') + "_" + \
+ student_applicant.middle_name + "_" + d.get('last_name') + "@example.com"
+ if count <5:
+ student_applicant.insert()
+ frappe.db.commit()
+ else:
+ student_applicant.submit()
+ frappe.db.commit()
+ count+=1
+
+def make_student_group():
+ for d in frappe.db.get_list("Academic Term"):
+ sg_tool = frappe.new_doc("Student Group Creation Tool")
+ sg_tool.academic_year = "2016-17"
+ sg_tool.academic_term = d.name
+ sg_tool.courses = sg_tool.get_courses()
+ sg_tool.create_student_groups()
+ frappe.db.commit()
+
+def make_fees_category():
+ fee_type = ["Tuition Fee", "Hostel Fee", "Logistics Fee",
+ "Medical Fee", "Mess Fee", "Security Deposit"]
+
+ fee_desc = {"Tuition Fee" : "Curricular activities which includes books, notebooks and faculty charges" ,
+ "Hostel Fee" : "Stay of students in institute premises",
+ "Logistics Fee" : "Lodging boarding of the students" ,
+ "Medical Fee" : "Medical welfare of the students",
+ "Mess Fee" : "Food and beverages for your ward",
+ "Security Deposit" : "In case your child is found to have damaged institutes property"
+ }
+
+ for i in fee_type:
+ fee_category = frappe.new_doc("Fee Category")
+ fee_category.category_name = i
+ fee_category.description = fee_desc[i]
+ fee_category.insert()
+ frappe.db.commit()
+
+def make_fees_structure():
+ for d in frappe.db.get_list("Program"):
+ program = frappe.get_doc("Program", d.name)
+ for academic_term in ["Semester 1", "Semester 2", "Semester 3"]:
+ fee_structure = frappe.new_doc("Fee Structure")
+ fee_structure.program = d.name
+ fee_structure.academic_term = random.choice(frappe.db.get_list("Academic Term")).name
+ for j in range(1,4):
+ temp = {"fees_category": random.choice(frappe.db.get_list("Fee Category")).name , "amount" : random.randint(500,1000)}
+ fee_structure.append("components", temp)
+ fee_structure.insert()
+ program.append("fees", {"academic_term": academic_term, "fee_structure": fee_structure.name, "amount": fee_structure.total_amount})
+ program.save()
+ frappe.db.commit()
+
+def get_json_path(doctype):
+ return frappe.get_app_path('erpnext', 'demo', 'data', frappe.scrub(doctype) + '.json')
+
+def weighted_choice(weights):
+ totals = []
+ running_total = 0
+
+ for w in weights:
+ running_total += w
+ totals.append(running_total)
+
+ rnd = random.random() * running_total
+ for i, total in enumerate(totals):
+ if rnd < total:
+ return i
diff --git a/erpnext/demo/setup/manufacture.py b/erpnext/demo/setup/manufacture.py
new file mode 100644
index 0000000..8ac2039
--- /dev/null
+++ b/erpnext/demo/setup/manufacture.py
@@ -0,0 +1,131 @@
+from __future__ import unicode_literals
+
+import random, json
+import frappe
+from frappe.utils import nowdate, add_days
+from erpnext.demo.setup.setup_data import import_json
+
+def setup_data():
+ import_json("Asset Category")
+ setup_item()
+ setup_workstation()
+ setup_asset()
+ import_json('Operation')
+ setup_item_price()
+ show_item_groups_in_website()
+ import_json('BOM', submit=True)
+ frappe.db.commit()
+ frappe.clear_cache()
+
+def setup_workstation():
+ workstations = [u'Drilling Machine 1', u'Lathe 1', u'Assembly Station 1', u'Assembly Station 2', u'Packing and Testing Station']
+ for w in workstations:
+ frappe.get_doc({
+ "doctype": "Workstation",
+ "workstation_name": w,
+ "holiday_list": frappe.get_all("Holiday List")[0].name,
+ "hour_rate_consumable": int(random.random() * 20),
+ "hour_rate_electricity": int(random.random() * 10),
+ "hour_rate_labour": int(random.random() * 40),
+ "hour_rate_rent": int(random.random() * 10),
+ "working_hours": [
+ {
+ "enabled": 1,
+ "start_time": "8:00:00",
+ "end_time": "15:00:00"
+ }
+ ]
+ }).insert()
+
+def show_item_groups_in_website():
+ """set show_in_website=1 for Item Groups"""
+ products = frappe.get_doc("Item Group", "Products")
+ products.show_in_website = 1
+ products.route = 'products'
+ products.save()
+
+def setup_asset():
+ assets = json.loads(open(frappe.get_app_path('erpnext', 'demo', 'data', 'asset.json')).read())
+ for d in assets:
+ asset = frappe.new_doc('Asset')
+ asset.update(d)
+ asset.purchase_date = add_days(nowdate(), -random.randint(20, 1500))
+ asset.next_depreciation_date = add_days(asset.purchase_date, 30)
+ asset.warehouse = "Stores - WPL"
+ asset.set_missing_values()
+ asset.make_depreciation_schedule()
+ asset.flags.ignore_validate = True
+ asset.save()
+ asset.submit()
+
+def setup_item():
+ items = json.loads(open(frappe.get_app_path('erpnext', 'demo', 'data', 'item.json')).read())
+ for i in items:
+ item = frappe.new_doc('Item')
+ item.update(i)
+ item.default_warehouse = frappe.get_all('Warehouse', filters={'warehouse_name': item.default_warehouse}, limit=1)[0].name
+ item.insert()
+
+def setup_product_bundle():
+ frappe.get_doc({
+ 'doctype': 'Product Bundle',
+ 'new_item_code': 'Wind Mill A Series with Spare Bearing',
+ 'items': [
+ {'item_code': 'Wind Mill A Series', 'qty': 1},
+ {'item_code': 'Bearing Collar', 'qty': 1},
+ {'item_code': 'Bearing Assembly', 'qty': 1},
+ ]
+ }).insert()
+
+def setup_item_price():
+ frappe.db.sql("delete from `tabItem Price`")
+
+ standard_selling = {
+ "Base Bearing Plate": 28,
+ "Base Plate": 21,
+ "Bearing Assembly": 300,
+ "Bearing Block": 14,
+ "Bearing Collar": 103.6,
+ "Bearing Pipe": 63,
+ "Blade Rib": 46.2,
+ "Disc Collars": 42,
+ "External Disc": 56,
+ "Internal Disc": 70,
+ "Shaft": 340,
+ "Stand": 400,
+ "Upper Bearing Plate": 300,
+ "Wind Mill A Series": 320,
+ "Wind Mill A Series with Spare Bearing": 750,
+ "Wind MIll C Series": 400,
+ "Wind Turbine": 400,
+ "Wing Sheet": 30.8
+ }
+
+ standard_buying = {
+ "Base Bearing Plate": 20,
+ "Base Plate": 28,
+ "Base Plate Un Painted": 16,
+ "Bearing Block": 13,
+ "Bearing Collar": 96.4,
+ "Bearing Pipe": 55,
+ "Blade Rib": 38,
+ "Disc Collars": 34,
+ "External Disc": 50,
+ "Internal Disc": 60,
+ "Shaft": 250,
+ "Stand": 300,
+ "Upper Bearing Plate": 200,
+ "Wing Sheet": 25
+ }
+
+ for price_list in ("standard_buying", "standard_selling"):
+ for item, rate in locals().get(price_list).iteritems():
+ frappe.get_doc({
+ "doctype": "Item Price",
+ "price_list": price_list.replace("_", " ").title(),
+ "item_code": item,
+ "selling": 1 if price_list=="standard_selling" else 0,
+ "buying": 1 if price_list=="standard_buying" else 0,
+ "price_list_rate": rate,
+ "currency": "USD"
+ }).insert()
diff --git a/erpnext/demo/setup/setup_data.py b/erpnext/demo/setup/setup_data.py
new file mode 100644
index 0000000..d279a64
--- /dev/null
+++ b/erpnext/demo/setup/setup_data.py
@@ -0,0 +1,362 @@
+from __future__ import unicode_literals
+
+import random, json
+import frappe, erpnext
+from frappe.utils import flt, now_datetime, cstr
+from frappe.utils.make_random import add_random_children, get_random
+from erpnext.demo.domains import data
+from frappe import _
+
+def setup(domain):
+ complete_setup(domain)
+ setup_demo_page()
+ setup_fiscal_year()
+ setup_holiday_list()
+ setup_user()
+ setup_employee()
+ setup_salary_structure()
+ setup_salary_structure_for_timesheet()
+ setup_leave_allocation()
+ setup_user_roles()
+ setup_customer()
+ setup_supplier()
+ setup_warehouse()
+ import_json('Address')
+ import_json('Contact')
+ import_json('Lead')
+ setup_currency_exchange()
+ setup_mode_of_payment()
+ setup_account_to_expense_type()
+ setup_budget()
+ setup_pos_profile()
+
+ frappe.db.commit()
+ frappe.clear_cache()
+
+def complete_setup(domain='Manufacturing'):
+ print "Complete Setup..."
+ from frappe.desk.page.setup_wizard.setup_wizard import setup_complete
+
+ if not frappe.get_all('Company', limit=1):
+ setup_complete({
+ "first_name": "Test",
+ "last_name": "User",
+ "email": "test_demo@erpnext.com",
+ "company_tagline": 'Awesome Products and Services',
+ "password": "test",
+ "fy_start_date": "2015-01-01",
+ "fy_end_date": "2015-12-31",
+ "bank_account": "National Bank",
+ "domain": domain,
+ "company_name": data.get(domain).get('company_name'),
+ "chart_of_accounts": "Standard",
+ "company_abbr": ''.join([d[0] for d in data.get(domain).get('company_name').split()]).upper(),
+ "currency": 'USD',
+ "timezone": 'America/New_York',
+ "country": 'United States',
+ "language": "english"
+ })
+
+def setup_demo_page():
+ # home page should always be "start"
+ website_settings = frappe.get_doc("Website Settings", "Website Settings")
+ website_settings.home_page = "demo"
+ website_settings.save()
+
+def setup_fiscal_year():
+ fiscal_year = None
+ for year in xrange(2010, now_datetime().year + 1, 1):
+ try:
+ fiscal_year = frappe.get_doc({
+ "doctype": "Fiscal Year",
+ "year": cstr(year),
+ "year_start_date": "{0}-01-01".format(year),
+ "year_end_date": "{0}-12-31".format(year)
+ }).insert()
+ except frappe.DuplicateEntryError:
+ pass
+
+ # set the last fiscal year (current year) as default
+ fiscal_year.set_as_default()
+
+def setup_holiday_list():
+ """Setup Holiday List for the current year"""
+ year = now_datetime().year
+ holiday_list = frappe.get_doc({
+ "doctype": "Holiday List",
+ "holiday_list_name": str(year),
+ "from_date": "{0}-01-01".format(year),
+ "to_date": "{0}-12-31".format(year),
+ })
+ holiday_list.insert()
+ holiday_list.weekly_off = "Saturday"
+ holiday_list.get_weekly_off_dates()
+ holiday_list.weekly_off = "Sunday"
+ holiday_list.get_weekly_off_dates()
+ holiday_list.save()
+
+ frappe.set_value("Company", erpnext.get_default_company(), "default_holiday_list", holiday_list.name)
+
+
+def setup_user():
+ frappe.db.sql('delete from tabUser where name not in ("Guest", "Administrator")')
+ for u in json.loads(open(frappe.get_app_path('erpnext', 'demo', 'data', 'user.json')).read()):
+ user = frappe.new_doc("User")
+ user.update(u)
+ user.flags.no_welcome_mail
+ user.new_password = 'demo'
+ user.insert()
+
+def setup_employee():
+ frappe.db.set_value("HR Settings", None, "emp_created_by", "Naming Series")
+ frappe.db.commit()
+
+ import_json('Employee')
+
+def setup_salary_structure():
+ f = frappe.get_doc('Fiscal Year', frappe.defaults.get_global_default('fiscal_year'))
+
+ ss = frappe.new_doc('Salary Structure')
+ ss.name = "Sample Salary Structure - " + str(f.year_start_date)
+ for e in frappe.get_all('Employee', fields=['name', 'date_of_joining']):
+ ss.append('employees', {
+ 'employee': e.name,
+ 'base': random.random() * 10000
+ })
+
+ if not e.date_of_joining:
+ continue
+
+ ss.from_date = e.date_of_joining if (e.date_of_joining
+ and e.date_of_joining > f.year_start_date) else f.year_start_date
+ ss.to_date = f.year_end_date
+
+ ss.append('earnings', {
+ 'salary_component': 'Basic',
+ "abbr":'B',
+ 'condition': 'base > 5000',
+ 'formula': 'base*.2',
+ 'amount_based_on_formula': 1,
+ "idx": 1
+ })
+ ss.append('deductions', {
+ 'salary_component': 'Income Tax',
+ "abbr":'IT',
+ 'condition': 'base > 5000',
+ 'amount': random.random() * 1000,
+ "idx": 1
+ })
+
+ ss.insert()
+
+def setup_salary_structure_for_timesheet():
+ for e in frappe.get_all('Salary Structure', fields=['name'], filters={'is_active': 'Yes'}, limit=2):
+ ss_doc = frappe.get_doc("Salary Structure", e.name)
+ ss_doc.salary_slip_based_on_timesheet = 1
+ ss_doc.salary_component = 'Basic'
+ ss_doc.hour_rate = flt(random.random() * 10, 2)
+ ss_doc.save(ignore_permissions=True)
+
+def setup_user_roles():
+ user = frappe.get_doc('User', 'demo@erpnext.com')
+ user.add_roles('HR User', 'HR Manager', 'Accounts User', 'Accounts Manager',
+ 'Stock User', 'Stock Manager', 'Sales User', 'Sales Manager', 'Purchase User',
+ 'Purchase Manager', 'Projects User', 'Manufacturing User', 'Manufacturing Manager',
+ 'Support Team', 'Academics User')
+
+ if not frappe.db.get_global('demo_hr_user'):
+ user = frappe.get_doc('User', 'CharmaineGaudreau@example.com')
+ user.add_roles('HR User', 'HR Manager', 'Accounts User')
+ frappe.db.set_global('demo_hr_user', user.name)
+
+ if not frappe.db.get_global('demo_sales_user_1'):
+ user = frappe.get_doc('User', 'VakhitaRyzaev@example.com')
+ user.add_roles('Sales User')
+ frappe.db.set_global('demo_sales_user_1', user.name)
+
+ if not frappe.db.get_global('demo_sales_user_2'):
+ user = frappe.get_doc('User', 'GabrielleLoftus@example.com')
+ user.add_roles('Sales User', 'Sales Manager', 'Accounts User')
+ frappe.db.set_global('demo_sales_user_2', user.name)
+
+ if not frappe.db.get_global('demo_purchase_user'):
+ user = frappe.get_doc('User', 'MichalSobczak@example.com')
+ user.add_roles('Purchase User', 'Purchase Manager', 'Accounts User', 'Stock User')
+ frappe.db.set_global('demo_purchase_user', user.name)
+
+ if not frappe.db.get_global('demo_manufacturing_user'):
+ user = frappe.get_doc('User', 'NuranVerkleij@example.com')
+ user.add_roles('Manufacturing User', 'Stock User', 'Purchase User', 'Accounts User')
+ frappe.db.set_global('demo_manufacturing_user', user.name)
+
+ if not frappe.db.get_global('demo_stock_user'):
+ user = frappe.get_doc('User', 'HatsueKashiwagi@example.com')
+ user.add_roles('Manufacturing User', 'Stock User', 'Purchase User', 'Accounts User')
+ frappe.db.set_global('demo_stock_user', user.name)
+
+ if not frappe.db.get_global('demo_accounts_user'):
+ user = frappe.get_doc('User', 'LeonAbdulov@example.com')
+ user.add_roles('Accounts User', 'Accounts Manager', 'Sales User', 'Purchase User')
+ frappe.db.set_global('demo_accounts_user', user.name)
+
+ if not frappe.db.get_global('demo_projects_user'):
+ user = frappe.get_doc('User', 'panca@example.com')
+ user.add_roles('HR User', 'Projects User')
+ frappe.db.set_global('demo_projects_user', user.name)
+
+ if not frappe.db.get_global('demo_schools_user'):
+ user = frappe.get_doc('User', 'aromn@example.com')
+ user.add_roles('Academics User')
+ frappe.db.set_global('demo_schools_user', user.name)
+
+ #Add Expense Approver
+ user = frappe.get_doc('User', 'WanMai@example.com')
+ user.add_roles('Expense Approver')
+
+def setup_leave_allocation():
+ year = now_datetime().year
+ for employee in frappe.get_all('Employee', fields=['name']):
+ leave_types = frappe.get_all("Leave Type", fields=['name', 'max_days_allowed'])
+ for leave_type in leave_types:
+ if not leave_type.max_days_allowed:
+ leave_type.max_days_allowed = 10
+
+ leave_allocation = frappe.get_doc({
+ "doctype": "Leave Allocation",
+ "employee": employee.name,
+ "from_date": "{0}-01-01".format(year),
+ "to_date": "{0}-12-31".format(year),
+ "leave_type": leave_type.name,
+ "new_leaves_allocated": random.randint(1, int(leave_type.max_days_allowed))
+ })
+ leave_allocation.insert()
+ leave_allocation.submit()
+ frappe.db.commit()
+
+def setup_customer():
+ customers = [u'Asian Junction', u'Life Plan Counselling', u'Two Pesos', u'Mr Fables', u'Intelacard', u'Big D Supermarkets', u'Adaptas', u'Nelson Brothers', u'Landskip Yard Care', u'Buttrey Food & Drug', u'Fayva', u'Asian Fusion', u'Crafts Canada', u'Consumers and Consumers Express', u'Netobill', u'Choices', u'Chi-Chis', u'Red Food', u'Endicott Shoes', u'Hind Enterprises']
+ for c in customers:
+ frappe.get_doc({
+ "doctype": "Customer",
+ "customer_name": c,
+ "customer_group": "Commercial",
+ "customer_type": random.choice(["Company", "Individual"]),
+ "territory": "Rest Of The World"
+ }).insert()
+
+def setup_supplier():
+ suppliers = [u'Helios Air', u'Ks Merchandise', u'HomeBase', u'Scott Ties', u'Reliable Investments', u'Nan Duskin', u'Rainbow Records', u'New World Realty', u'Asiatic Solutions', u'Eagle Hardware', u'Modern Electricals']
+ for s in suppliers:
+ frappe.get_doc({
+ "doctype": "Supplier",
+ "supplier_name": s,
+ "supplier_type": random.choice(["Services", "Raw Material"]),
+ }).insert()
+
+def setup_warehouse():
+ w = frappe.new_doc('Warehouse')
+ w.warehouse_name = 'Supplier'
+ w.insert()
+
+def setup_currency_exchange():
+ frappe.get_doc({
+ 'doctype': 'Currency Exchange',
+ 'from_currency': 'EUR',
+ 'to_currency': 'USD',
+ 'exchange_rate': 1.13
+ }).insert()
+
+ frappe.get_doc({
+ 'doctype': 'Currency Exchange',
+ 'from_currency': 'CNY',
+ 'to_currency': 'USD',
+ 'exchange_rate': 0.16
+ }).insert()
+
+def setup_mode_of_payment():
+ company_abbr = frappe.db.get_value("Company", erpnext.get_default_company(), "abbr")
+ account_dict = {'Cash': 'Cash - '+ company_abbr , 'Bank': 'National Bank - '+ company_abbr}
+ for payment_mode in frappe.get_all('Mode of Payment', fields = ["name", "type"]):
+ if payment_mode.type:
+ mop = frappe.get_doc('Mode of Payment', payment_mode.name)
+ mop.append('accounts', {
+ 'company': erpnext.get_default_company(),
+ 'default_account': account_dict.get(payment_mode.type)
+ })
+ mop.save(ignore_permissions=True)
+
+def setup_account():
+ frappe.flags.in_import = True
+ data = json.loads(open(frappe.get_app_path('erpnext', 'demo', 'data',
+ 'account.json')).read())
+ for d in data:
+ doc = frappe.new_doc('Account')
+ doc.update(d)
+ doc.parent_account = frappe.db.get_value('Account', {'account_name': doc.parent_account})
+ doc.insert()
+
+def setup_account_to_expense_type():
+ company_abbr = frappe.db.get_value("Company", erpnext.get_default_company(), "abbr")
+ expense_types = [{'name': _('Calls'), "account": "Sales Expenses - "+ company_abbr},
+ {'name': _('Food'), "account": "Entertainment Expenses - "+ company_abbr},
+ {'name': _('Medical'), "account": "Utility Expenses - "+ company_abbr},
+ {'name': _('Others'), "account": "Miscellaneous Expenses - "+ company_abbr},
+ {'name': _('Travel'), "account": "Travel Expenses - "+ company_abbr}]
+
+ for expense_type in expense_types:
+ doc = frappe.get_doc("Expense Claim Type", expense_type["name"])
+ doc.append("accounts", {
+ "company" : erpnext.get_default_company(),
+ "default_account" : expense_type["account"]
+ })
+ doc.save(ignore_permissions=True)
+
+def setup_budget():
+ fiscal_years = frappe.get_all("Fiscal Year", order_by="year_start_date")[-2:]
+
+ for fy in fiscal_years:
+ budget = frappe.new_doc("Budget")
+ budget.cost_center = get_random("Cost Center")
+ budget.fiscal_year = fy.name
+ budget.action_if_annual_budget_exceeded = "Warn"
+ expense_ledger_count = frappe.db.count("Account", {"is_group": "0", "root_type": "Expense"})
+
+ add_random_children(budget, "accounts", rows=random.randint(10, expense_ledger_count), randomize = { "account": ("Account", {"is_group": "0", "root_type": "Expense"})
+ }, unique="account")
+
+ for d in budget.accounts:
+ d.budget_amount = random.randint(5, 100) * 10000
+
+ budget.save()
+ budget.submit()
+
+def setup_pos_profile():
+ company_abbr = frappe.db.get_value("Company", erpnext.get_default_company(), "abbr")
+ pos = frappe.new_doc('POS Profile')
+ pos.user = frappe.db.get_global('demo_accounts_user')
+ pos.naming_series = 'SINV-'
+ pos.update_stock = 0
+ pos.write_off_account = 'Cost of Goods Sold - '+ company_abbr
+ pos.write_off_cost_center = 'Main - '+ company_abbr
+
+ pos.append('payments', {
+ 'mode_of_payment': frappe.db.get_value('Mode of Payment', {'type': 'Cash'}, 'name'),
+ 'amount': 0.0
+ })
+
+ pos.insert()
+
+def import_json(doctype, submit=False, values=None):
+ frappe.flags.in_import = True
+ data = json.loads(open(frappe.get_app_path('erpnext', 'demo', 'data',
+ frappe.scrub(doctype) + '.json')).read())
+ for d in data:
+ doc = frappe.new_doc(doctype)
+ doc.update(d)
+ doc.insert()
+ if submit:
+ doc.submit()
+
+ frappe.db.commit()
+
+