ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.create_sales_invoice_then_assign_task
Goal: create a sales invoice for the customer Palm Beach for the item SKU0016. The invoice should reflect 10.0 for quantity, and $3.0 for rate, then assign the 'remove PII' task to the user Thomas Anderson
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM `tabSales Invoice` AS s INNER JOIN `tabSales Invoice Item` AS si ON s.name=si.parent WHERE customer="Palm Beach" AND item_code="SKU0016" AND qty="10.0" AND rate="3.0" UNION ALL SELECT COUNT(*) AS count FROM  tabTask WHERE subject="remove PII" AND _assign LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Thomas Anderson"), "%")) as counts_sum
count: 2
Task: erpnext.create_stock_item_with_name_description_then_create_purchase_order
Goal: create stock item with SKU0027 for item code, Sweater for item name, Products for item group, New Size Sweaters for description, and check 'Delivered By Supplier', then create a purchase order for 100 Nos of the stock item SKU0027 to be fulfilled by the supplier Aperture Science. Fulfillment is required by 2036-01-23 and stock goes to the Think Inside the Box - SN warehouse
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM tabItem WHERE item_code="SKU0027" AND item_group="Products" AND item_name="Sweater" AND description LIKE "%New Size Sweaters%" AND delivered_by_supplier=1 UNION ALL SELECT COUNT(*) as count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Aperture Science" AND i.qty="100" AND i.item_code="SKU0027" AND uom="Nos" AND o.schedule_date="2036-01-23" AND o.set_warehouse="Think Inside the Box - SN") AS counts_sum
count: 2
Task: erpnext.create_stock_item_with_name_description_then_create_purchase_order
Goal: create stock item with SKU0028 for item code, Remote Control for item name, Consumable for item group, battery-powered remote controls for description, and check 'Delivered By Supplier', then create a purchase order for 5000 Set of the stock item SKU0028 to be fulfilled by the supplier Wayne Enterprises. Fulfillment is required by 2026-09-17 and stock goes to the The Dream Vault - SN warehouse
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM tabItem WHERE item_code="SKU0028" AND item_group="Consumable" AND item_name="Remote Control" AND description LIKE "%battery-powered remote controls%" AND delivered_by_supplier=1 UNION ALL SELECT COUNT(*) as count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Wayne Enterprises" AND i.qty="5000" AND i.item_code="SKU0028" AND uom="Set" AND o.schedule_date="2026-09-17" AND o.set_warehouse="The Dream Vault - SN") AS counts_sum
count: 2
Task: erpnext.create_stock_item_without_name_description_then_create_purchase_order
Goal: Create a stock item with SKU0190 for item code, Products for item group, Nos for unit of measure. Then create a purchase order to send to supplier Aperture Science for 100 Nos of stock item SKU0190. Order is required by 2036-01-23 and stock should be sent to Hall of Justice - SN warehouse
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM tabItem WHERE item_code="SKU0190" AND item_group="Products" AND stock_uom="Nos" UNION ALL SELECT COUNT(*) as count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Aperture Science" AND i.qty="100" AND i.item_code="SKU0190" AND o.schedule_date="2036-01-23" AND o.set_warehouse="Hall of Justice - SN") AS counts_sum
count: 2
Task: erpnext.create_stock_item_without_name_description_then_create_purchase_order
Goal: Create a stock item with SKU0500 for item code, Consumable for item group, Set for unit of measure. Then create a purchase order to send to supplier Wayne Enterprises for 5000 Set of stock item SKU0500. Order is required by 2026-09-17 and stock should be sent to Metro Tower - SN warehouse
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM tabItem WHERE item_code="SKU0500" AND item_group="Consumable" AND stock_uom="Set" UNION ALL SELECT COUNT(*) as count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Wayne Enterprises" AND i.qty="5000" AND i.item_code="SKU0500" AND o.schedule_date="2026-09-17" AND o.set_warehouse="Metro Tower - SN") AS counts_sum
count: 2
Task: erpnext.create_task_then_assign_payment_entry
Goal: Create a new task for the project Marvin with the subject "start new project", then assign a payment entry named Grant Stella Ltd. - 1 to the user Hughie
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="start new project" AND p.project_name="Marvin" UNION ALL SELECT COUNT(*) FROM `tabPayment Entry` WHERE title="Grant Stella Ltd. - 1" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Hughie"), "%")) as counts_sum
count: 2
Task: erpnext.create_task_then_assign_payment_entry
Goal: Create a new task for the project Monique with the subject "discuss deadline", then assign a payment entry named Mesmer to the user Ashleigh
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="discuss deadline" AND p.project_name="Monique" UNION ALL SELECT COUNT(*) FROM `tabPayment Entry` WHERE title="Mesmer" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Ashleigh"), "%")) as counts_sum
count: 2
Task: erpnext.create_user_then_cancel_journal_entry
Goal: create user with email mark.s@lumonindustries.com and name Mark S, then cancel journal entry named Queen Maeve - SN
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) as count FROM `tabUser` WHERE email="mark.s@lumonindustries.com" AND first_name="Mark" AND last_name="S" UNION ALL SELECT COUNT(*) as count FROM `tabJournal Entry` WHERE title="Queen Maeve - SN" AND docstatus=2) as counts_sum
count: 2
Task: erpnext.create_user_then_cancel_journal_entry
Goal: create user with email dylan.g@lumonindustries.com and name Dylan G, then cancel journal entry named Homelander - SN
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) as count FROM `tabUser` WHERE email="dylan.g@lumonindustries.com" AND first_name="Dylan" AND last_name="G" UNION ALL SELECT COUNT(*) as count FROM `tabJournal Entry` WHERE title="Homelander - SN" AND docstatus=2) as counts_sum
count: 2
Task: erpnext.create_user_then_cancel_journal_entry
Goal: create user with email helly.r@lumonindustries.com and name Helly R, then cancel journal entry named Starlight - SN
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) as count FROM `tabUser` WHERE email="helly.r@lumonindustries.com" AND first_name="Helly" AND last_name="R" UNION ALL SELECT COUNT(*) as count FROM `tabJournal Entry` WHERE title="Starlight - SN" AND docstatus=2) as counts_sum
count: 2
Task: erpnext.create_purchase_order_with_discount
Goal: Create purchase order to supplier MA Inc. for 1 Unit of the item SKU0013 required by 2070-10-21 with 10.0% discount. Send items to the Stores - SN warehouse
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="MA Inc." AND i.qty="1" AND i.item_code="SKU0013" AND i.uom="Unit" AND o.schedule_date="2070-10-21" AND o.additional_discount_percentage="10.0" AND i.warehouse="Stores - SN"
count: 1
Task: erpnext.create_purchase_order_with_discount
Goal: Create purchase order to supplier Zuckerman Security Ltd. for 5 Box of the item SKU0014 required by 2070-01-01 with 15.0% discount. Send items to the Work In Progress - SN warehouse
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Zuckerman Security Ltd." AND i.qty="5" AND i.item_code="SKU0014" AND i.uom="Box" AND o.schedule_date="2070-01-01" AND o.additional_discount_percentage="15.0" AND i.warehouse="Work In Progress - SN"
count: 1
Task: erpnext.create_purchase_order_without_discount
Goal: Create purchase order for supplier Aperture Science for 100 Nos of the item SKU0015 required by 2060-01-23. Send items to the Think Inside the Box - SN warehouse
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Aperture Science" AND i.qty="100" AND i.item_code="SKU0015" AND i.uom="Nos" AND o.schedule_date="2060-01-23" AND i.warehouse="Think Inside the Box - SN"
count: 1
Task: erpnext.create_purchase_order_without_discount
Goal: Create purchase order for supplier Wayne Enterprises for 5000 Set of the item SKU0018 required by 2060-09-17. Send items to the The Dream Vault - SN warehouse
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` AS o INNER JOIN `tabPurchase Order Item` AS i ON o.name=i.parent AND o.supplier_name="Wayne Enterprises" AND i.qty="5000" AND i.item_code="SKU0018" AND i.uom="Set" AND o.schedule_date="2060-09-17" AND i.warehouse="The Dream Vault - SN"
count: 1
Task: erpnext.create_supplier_name_email_phone
Goal: create supplier record for supplier plant Ltd with email orlando1@servicenow.com and number 000-000-0000
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabSupplier AS s INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=s.name AND dl.link_doctype="Supplier" INNER JOIN tabContact AS c ON c.name=dl.parent WHERE s.supplier_name="plant Ltd" AND c.email_id="orlando1@servicenow.com" AND c.mobile_no="000-000-0000"
count: 1
Task: erpnext.create_supplier_name_email_phone
Goal: create supplier record for supplier brick Ltd with email jordan1@servicenow.com and number 111-111-1111
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabSupplier AS s INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=s.name AND dl.link_doctype="Supplier" INNER JOIN tabContact AS c ON c.name=dl.parent WHERE s.supplier_name="brick Ltd" AND c.email_id="jordan1@servicenow.com" AND c.mobile_no="111-111-1111"
count: 1
Task: erpnext.create_supplier_name_group_currency_tax_id
Goal: Create a supplier named Cup Ltd and set its group to Distributor, billing currency to EUR, and tax id to 33-3333333. Allow the supplier to create purchase invoices without purchase orders or purchase receipts
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier` WHERE supplier_name="Cup Ltd" AND supplier_group="Distributor" AND default_currency="EUR" AND tax_id="33-3333333" AND allow_purchase_invoice_creation_without_purchase_order=1 AND allow_purchase_invoice_creation_without_purchase_receipt=1
count: 1
Task: erpnext.create_supplier_name_group_currency_tax_id
Goal: Create a supplier named Flower Ltd and set its group to Raw Material, billing currency to GBP, and tax id to 44-4444444. Allow the supplier to create purchase invoices without purchase orders or purchase receipts
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier` WHERE supplier_name="Flower Ltd" AND supplier_group="Raw Material" AND default_currency="GBP" AND tax_id="44-4444444" AND allow_purchase_invoice_creation_without_purchase_order=1 AND allow_purchase_invoice_creation_without_purchase_receipt=1
count: 1
Task: erpnext.assign_purchase_order
Goal: find purchase order PUR-ORD-2025-00003 and assign it to the users Milton Waddams and Dorothy Gale
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE name="PUR-ORD-2025-00003" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Milton Waddams"), "%", (SELECT email FROM `tabUser` WHERE full_name="Dorothy Gale"), "%")
count: 1
Task: erpnext.assign_purchase_order
Goal: find purchase order PUR-ORD-2025-00004 and assign it to the users Gus Fring and Thomas Anderson
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE name="PUR-ORD-2025-00004" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Gus Fring"), "%", (SELECT email FROM `tabUser` WHERE full_name="Thomas Anderson"), "%")
count: 1
Task: erpnext.cancel_purchase_order
Goal: cancel purchase order PUR-ORD-2025-00007
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE name="PUR-ORD-2025-00007" AND docstatus=2
count: 1
Task: erpnext.cancel_purchase_order
Goal: cancel purchase order PUR-ORD-2025-00008
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE name="PUR-ORD-2025-00008" AND docstatus=2
count: 1
Task: erpnext.delete_supplier
Goal: delete supplier Punisher
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier` WHERE supplier_name="Punisher"
count: 0
Task: erpnext.delete_supplier
Goal: delete supplier Spiderman
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier` WHERE supplier_name="Spiderman"
count: 0
Task: erpnext.delete_supplier
Goal: delete supplier Captain America
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier` WHERE supplier_name="Captain America"
count: 0
Task: erpnext.tag_supplier
Goal: add tag priority to supplier group Trout
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier Group` WHERE name="Trout" AND _user_tags LIKE "%,priority%"
count: 1
Task: erpnext.tag_supplier
Goal: add tag quarterly check to supplier group Piranha
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier Group` WHERE name="Piranha" AND _user_tags LIKE "%,quarterly check%"
count: 1
Task: erpnext.tag_supplier
Goal: add tag urgent to supplier group Snakehead
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSupplier Group` WHERE name="Snakehead" AND _user_tags LIKE "%,urgent%"
count: 1
Task: erpnext.add_comment_to_draft_purchase_orders
Goal: Update draft purchase orders to include the comment "need to make this priority"
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE status="Draft" AND (_comments IS NULL OR _comments NOT LIKE "%need to make this priority%")
count: 0
Task: erpnext.add_date_confirmation_number_to_purchase_order
Goal: update required by date to 2026-01-30 and add an order confirmation number 12345 to purchase order PUR-ORD-2025-00001
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE name="PUR-ORD-2025-00001" AND schedule_date="2026-01-30" AND order_confirmation_no="12345"
count: 1
Task: erpnext.add_date_confirmation_number_to_purchase_order
Goal: update required by date to 2026-02-15 and add an order confirmation number 54321 to purchase order PUR-ORD-2025-00002
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE name="PUR-ORD-2025-00002" AND schedule_date="2026-02-15" AND order_confirmation_no="54321"
count: 1
Task: erpnext.update_target_warehouse_on_suppliers_purchase_orders
Goal: update the target warehouse on all purchase orders for supplier Monsters, Inc. to the warehouse Goods In Transit - SN
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE supplier_name="Monsters, Inc." AND set_warehouse="Goods In Transit - SN"
count: 2
Task: erpnext.update_target_warehouse_on_suppliers_purchase_orders
Goal: update the target warehouse on all purchase orders for supplier Buy N Large to the warehouse All Warehouses - SN
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPurchase Order` WHERE supplier_name="Buy N Large" AND set_warehouse="All Warehouses - SN"
count: 2
Task: erpnext.create_customer_name_account_manager_group
Goal: create customer record with Los Pollos Hermanos for name, Gus Fring for account manager, Commercial for customer group, and "need to assign sales group here" for comments
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabCustomer AS cu INNER JOIN tabComment AS co ON co.reference_doctype="Customer" INNER JOIN tabUser AS u ON cu.account_manager=u.email WHERE cu.customer_name="Los Pollos Hermanos" AND cu.customer_group="Commercial" AND u.full_name="Gus Fring" AND co.content LIKE "%need to assign sales group here%"
count: 1
Task: erpnext.create_customer_name_account_manager_group
Goal: create customer record with Cyberdyne Systems for name, Skynet for account manager, Government for customer group, and "need to discuss during meeting" for comments
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabCustomer AS cu INNER JOIN tabComment AS co ON co.reference_doctype="Customer" INNER JOIN tabUser AS u ON cu.account_manager=u.email WHERE cu.customer_name="Cyberdyne Systems" AND cu.customer_group="Government" AND u.full_name="Skynet" AND co.content LIKE "%need to discuss during meeting%"
count: 1
Task: erpnext.create_customer_name_account_manager_group
Goal: create customer record with Wonka Industries for name, Willy Wonka for account manager, Non Profit for customer group, and "has anyone had any updates on this?" for comments
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabCustomer AS cu INNER JOIN tabComment AS co ON co.reference_doctype="Customer" INNER JOIN tabUser AS u ON cu.account_manager=u.email WHERE cu.customer_name="Wonka Industries" AND cu.customer_group="Non Profit" AND u.full_name="Willy Wonka" AND co.content LIKE "%has anyone had any updates on this?%"
count: 1
Task: erpnext.create_customer_name_type_address
Goal: create customer record with the name Weasley's Wizard Wheezes, Company for type, 93 Diagon Alley, London, and United Kingdom for address
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabCustomer AS cu INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=cu.name AND dl.link_doctype="Customer" INNER JOIN tabAddress AS a ON a.name=dl.parent WHERE cu.customer_name="Weasley's Wizard Wheezes" AND cu.customer_type="Company" AND a.address_line1="93 Diagon Alley" AND a.city="London" AND a.country="United Kingdom"
count: 1
Task: erpnext.create_customer_name_type_address
Goal: create customer record with the name Al's Toy Barn, Individual for type, 1111 Haddonfield, Queensland, and Australia for address
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabCustomer AS cu INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=cu.name AND dl.link_doctype="Customer" INNER JOIN tabAddress AS a ON a.name=dl.parent WHERE cu.customer_name="Al's Toy Barn" AND cu.customer_type="Individual" AND a.address_line1="1111 Haddonfield" AND a.city="Queensland" AND a.country="Australia"
count: 1
Task: erpnext.create_customer_name_type_address
Goal: create customer record with the name Goldmine, Partnership for type, 3567 St-Urbain, Montreal, and Canada for address
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabCustomer AS cu INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=cu.name AND dl.link_doctype="Customer" INNER JOIN tabAddress AS a ON a.name=dl.parent WHERE cu.customer_name="Goldmine" AND cu.customer_type="Partnership" AND a.address_line1="3567 St-Urbain" AND a.city="Montreal" AND a.country="Canada"
count: 1
Task: erpnext.create_customer_with_account_manager_group_tax_dependencies_HARD
Goal: Create a customer named Chicken Place and add Billy as their account manager. Set the customer group to Sopranos, add them to the Maybe Sales tax category, and allow them to create sales invoices without sales orders. Lastly, add a comment on their record, 'This is a good tv show'. - If there is no account manager named Billy, create a new account manager with 'Billy' for their first name, 'billyl@servicenow.com' for their email, and 'Accounts' for their role profile. - If there is no customer group named Sopranos, create a new customer group with 'Sopranos' for the group name and 'Standard Selling' for the default price list. Add a credit limit entry with 'ServiceNow' for the company and $1000 for the credit limit. - If there is no tax category named Maybe Sales, create a new tax category with 'Maybe Sales' for the title.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabCustomer` AS c INNER JOIN `tabUser` AS u ON c.account_manager=u.name INNER JOIN `tabCustomer Group` AS cg ON c.customer_group=cg.customer_group_name INNER JOIN `tabCustomer Credit Limit` AS ccl ON cg.customer_group_name=ccl.parent WHERE c.customer_name="Chicken Place" AND c.account_manager="billyl@servicenow.com" AND u.first_name="Billy" AND u.role_profile_name="Accounts" AND c.customer_group="Sopranos" AND cg.default_price_list="Standard Selling" AND ccl.company="ServiceNow" AND ccl.credit_limit="1000" AND c.tax_category="Maybe Sales" AND so_required=1 AND c._comments LIKE "%This is a good tv show%"
count: 1
Task: erpnext.create_customer_with_account_manager_group_tax_dependencies_HARD
Goal: Create a customer named Duck Place and add Adiris as their account manager. Set the customer group to Game of Thrones, add them to the Maybe Buying tax category, and allow them to create sales invoices without sales orders. Lastly, add a comment on their record, 'I should order food'. - If there is no account manager named Adiris, create a new account manager with 'Adiris' for their first name, 'adiris@servicenow.com' for their email, and 'HR' for their role profile. - If there is no customer group named Game of Thrones, create a new customer group with 'Game of Thrones' for the group name and 'Standard Selling' for the default price list. Add a credit limit entry with 'ServiceNow' for the company and $2000 for the credit limit. - If there is no tax category named Maybe Buying, create a new tax category with 'Maybe Buying' for the title.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabCustomer` AS c INNER JOIN `tabUser` AS u ON c.account_manager=u.name INNER JOIN `tabCustomer Group` AS cg ON c.customer_group=cg.customer_group_name INNER JOIN `tabCustomer Credit Limit` AS ccl ON cg.customer_group_name=ccl.parent WHERE c.customer_name="Duck Place" AND c.account_manager="adiris@servicenow.com" AND u.first_name="Adiris" AND u.role_profile_name="HR" AND c.customer_group="Game of Thrones" AND cg.default_price_list="Standard Selling" AND ccl.company="ServiceNow" AND ccl.credit_limit="2000" AND c.tax_category="Maybe Buying" AND so_required=1 AND c._comments LIKE "%I should order food%"
count: 1
Task: erpnext.create_customer_with_account_manager_group_tax_dependencies_HARD
Goal: Create a customer named Turkey Place and add Jason as their account manager. Set the customer group to Mad Men, add them to the Maybe Tax tax category, and allow them to create sales invoices without sales orders. Lastly, add a comment on their record, 'What do we watch next?'. - If there is no account manager named Jason, create a new account manager with 'Jason' for their first name, 'jvoorhees@servicenow.com' for their email, and 'Sales' for their role profile. - If there is no customer group named Mad Men, create a new customer group with 'Mad Men' for the group name and 'Standard Selling' for the default price list. Add a credit limit entry with 'ServiceNow' for the company and $3000 for the credit limit. - If there is no tax category named Maybe Tax, create a new tax category with 'Maybe Tax' for the title.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabCustomer` AS c INNER JOIN `tabUser` AS u ON c.account_manager=u.name INNER JOIN `tabCustomer Group` AS cg ON c.customer_group=cg.customer_group_name INNER JOIN `tabCustomer Credit Limit` AS ccl ON cg.customer_group_name=ccl.parent WHERE c.customer_name="Turkey Place" AND c.account_manager="jvoorhees@servicenow.com" AND u.first_name="Jason" AND u.role_profile_name="Sales" AND c.customer_group="Mad Men" AND cg.default_price_list="Standard Selling" AND ccl.company="ServiceNow" AND ccl.credit_limit="3000" AND c.tax_category="Maybe Tax" AND so_required=1 AND c._comments LIKE "%What do we watch next?%"
count: 1