ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.create_customer_with_account_manager_role_profile_group_tax_dependencies_HARD
Goal: Create a customer record using 'Bobert' for the customer name, 'Breadman' for the account manager, 'Teen Wolf' for the customer group, and 'A big tax' for the tax category. Allow the customer to create sales invoices without sales orders and add a comment that says 'This is a good tv show' on the record. - If there is no account manager named 'Breadman', create the account manager using 'Breadman' for their first name, 'breadman@servicenow.com' for their email, and select 'Auditor' for their role profile. If that profile does not exist, create it using 'Auditor' for the profile name and 'Auditor' for the role. - If there is no customer group named 'Teen Wolf', create the customer group using 'Teen Wolf' for the group name, 'Standard Selling' for the default price list, and add a credit limit that has 'ServiceNow' for the company and $1040 for the credit limit. - If there is no tax category named 'A big tax', create the tax category using 'A big 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 `tabHas Role` AS r ON u.role_profile_name=r.parent 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="Bobert" AND c.account_manager="breadman@servicenow.com" AND u.first_name="Breadman" AND u.role_profile_name="Auditor" AND r.role="Auditor" AND c.customer_group="Teen Wolf" AND cg.default_price_list="Standard Selling" AND ccl.company="ServiceNow" AND ccl.credit_limit="1040" AND c.tax_category="A big tax" AND so_required=1 AND c._comments LIKE "%This is a good tv show%"
count: 1
Task: erpnext.create_customer_with_account_manager_role_profile_group_tax_dependencies_HARD
Goal: Create a customer record using 'Robert' for the customer name, 'Rollman' for the account manager, 'H2O' for the customer group, and 'Lots of taxes' for the tax category. Allow the customer to create sales invoices without sales orders and add a comment that says 'I should order food' on the record. - If there is no account manager named 'Rollman', create the account manager using 'Rollman' for their first name, 'rollman@servicenow.com' for their email, and select 'Inbox User' for their role profile. If that profile does not exist, create it using 'Inbox User' for the profile name and 'Inbox User' for the role. - If there is no customer group named 'H2O', create the customer group using 'H2O' for the group name, 'Standard Selling' for the default price list, and add a credit limit that has 'ServiceNow' for the company and $2400 for the credit limit. - If there is no tax category named 'Lots of taxes', create the tax category using 'Lots of taxes' 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 `tabHas Role` AS r ON u.role_profile_name=r.parent 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="Robert" AND c.account_manager="rollman@servicenow.com" AND u.first_name="Rollman" AND u.role_profile_name="Inbox User" AND r.role="Inbox User" AND c.customer_group="H2O" AND cg.default_price_list="Standard Selling" AND ccl.company="ServiceNow" AND ccl.credit_limit="2400" AND c.tax_category="Lots of taxes" AND so_required=1 AND c._comments LIKE "%I should order food%"
count: 1
Task: erpnext.create_customer_with_account_manager_role_profile_group_tax_dependencies_HARD
Goal: Create a customer record using 'Lobert' for the customer name, 'Biscuitman' for the account manager, 'Arrow' for the customer group, and 'A ton of taxes' for the tax category. Allow the customer to create sales invoices without sales orders and add a comment that says 'What do we watch next?' on the record. - If there is no account manager named 'Biscuitman', create the account manager using 'Biscuitman' for their first name, 'biscuitman@servicenow.com' for their email, and select 'Newsletter Manager' for their role profile. If that profile does not exist, create it using 'Newsletter Manager' for the profile name and 'Newsletter Manager' for the role. - If there is no customer group named 'Arrow', create the customer group using 'Arrow' for the group name, 'Standard Selling' for the default price list, and add a credit limit that has 'ServiceNow' for the company and $5000 for the credit limit. - If there is no tax category named 'A ton of taxes', create the tax category using 'A ton of taxes' 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 `tabHas Role` AS r ON u.role_profile_name=r.parent 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="Lobert" AND c.account_manager="biscuitman@servicenow.com" AND u.first_name="Biscuitman" AND u.role_profile_name="Newsletter Manager" AND r.role="Newsletter Manager" AND c.customer_group="Arrow" AND cg.default_price_list="Standard Selling" AND ccl.company="ServiceNow" AND ccl.credit_limit="5000" AND c.tax_category="A ton of taxes" AND so_required=1 AND c._comments LIKE "%What do we watch next?%"
count: 1
Task: erpnext.create_sales_invoice
Goal: create a sales invoice with Grant Stella Ltd. for customer, including SKU0014 for item, 1.0 for quantity, and 20.0 for rate
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="Grant Stella Ltd." AND ii.item_name="SKU0014" AND ii.qty="1.0" AND ii.rate="20.0" AND ii.parenttype="Sales Invoice"
count: 1
Task: erpnext.create_sales_invoice
Goal: create a sales invoice with DailyDose for customer, including SKU0015 for item, 50.0 for quantity, and 45.5 for rate
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="DailyDose" AND ii.item_name="SKU0015" AND ii.qty="50.0" AND ii.rate="45.5" AND ii.parenttype="Sales Invoice"
count: 1
Task: erpnext.create_sales_invoice
Goal: create a sales invoice with Palm Beach for customer, including SKU0016 for item, 11.0 for quantity, and 3.0 for rate
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="Palm Beach" AND ii.item_name="SKU0016" AND ii.qty="11.0" AND ii.rate="3.0" AND ii.parenttype="Sales Invoice"
count: 1
Task: erpnext.create_sales_invoice_with_custom_tax_rate
Goal: create a sales invoice for the customer Malphite Ltd. with SKU0014 for item, 1.0 for quantity, 20.0 for rate, 2026-10-19 for date, delete current sales tax or charges, add new sales tax or charge with On Net Total for type, Marketing Expenses - SN for account head, and 6 for tax rate
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent INNER JOIN `tabSales Taxes and Charges` AS stc ON i.name=stc.parent WHERE i.customer="Malphite Ltd." AND ii.item_name="SKU0014" AND ii.qty=1.0 AND ii.rate=20.0 AND i.posting_date="2026-10-19" AND stc.charge_type="On Net Total" AND stc.account_head="Marketing Expenses - SN" AND stc.rate="6"
count: 1
Task: erpnext.create_sales_invoice_with_custom_tax_rate
Goal: create a sales invoice for the customer Versace Ltd. with SKU0013 for item, 2.0 for quantity, 45.5 for rate, 2026-11-14 for date, delete current sales tax or charges, add new sales tax or charge with Actual for type, ST 6% - SN for account head, and 7 for tax rate
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent INNER JOIN `tabSales Taxes and Charges` AS stc ON i.name=stc.parent WHERE i.customer="Versace Ltd." AND ii.item_name="SKU0013" AND ii.qty=2.0 AND ii.rate=45.5 AND i.posting_date="2026-11-14" AND stc.charge_type="Actual" AND stc.account_head="ST 6% - SN" AND stc.rate="7"
count: 1
Task: erpnext.create_sales_invoice_with_custom_tax_rate
Goal: create a sales invoice for the customer Dysync Productions Ltd. with SKU0017 for item, 10.0 for quantity, 3.0 for rate, 2026-11-11 for date, delete current sales tax or charges, add new sales tax or charge with On Item Quantity for type, Freight and Forwarding Charges - SN for account head, and 8 for tax rate
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent INNER JOIN `tabSales Taxes and Charges` AS stc ON i.name=stc.parent WHERE i.customer="Dysync Productions Ltd." AND ii.item_name="SKU0017" AND ii.qty=10.0 AND ii.rate=3.0 AND i.posting_date="2026-11-11" AND stc.charge_type="On Item Quantity" AND stc.account_head="Freight and Forwarding Charges - SN" AND stc.rate="8"
count: 1
Task: erpnext.create_sales_invoice_with_customer_item_account_dependencies_HARD
Goal: Create a sales invoice for the customer Scott Summers for 10 Nos of the item 'Ruby-Quartz Visor' at a rate of 295 EUR per Nos. Debit it to the account 'Macaroni - SN'.
If the customer Scott Summers does not exist, create the customer record with 'Scott Summers' for customer name, 'Company' for customer type, 'EUR' for billing currency, 'www.cyclops.com' for website, and 'Customer wears red visors' for customer details.
If the stock item 'Ruby-Quartz Visor' does not exist, create the item with 'Ruby-Quartz Visor' for item name, 'VIS-RBY-QRTZ' for item code, 'Products' for item group, and 'Nos' for default unit of measure.
If the account 'Macaroni - SN' does not exist, create the account with 'Macaroni' for account name, 'Receivable' for account type, 'Bank Accounts - SN' for parent account and 'EUR' for currency.
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Invoice` AS si INNER JOIN `tabCustomer` AS c ON si.customer_name=c.customer_name INNER JOIN `tabSales Invoice Item` AS sii ON si.name=sii.parent INNER JOIN `tabAccount` AS a ON si.debit_to=a.name WHERE si.customer_name="Scott Summers" AND c.customer_type="Company" AND c.default_currency="EUR" AND c.website="www.cyclops.com" AND c.customer_details="Customer wears red visors" AND sii.item_name="Ruby-Quartz Visor" AND sii.item_code="VIS-RBY-QRTZ" AND sii.item_group="Products" AND sii.uom="Nos" AND sii.qty="10" AND sii.rate="295" AND si.debit_to="Macaroni - SN" AND a.account_type="Receivable" AND a.parent_account="Bank Accounts - SN" AND a.account_currency="EUR" AND si.title="Sales Invoice for Scott Summers"
count: 1
Task: erpnext.create_sales_invoice_with_customer_item_account_dependencies_HARD
Goal: Create a sales invoice for the customer Kitty Pryde for 7 Pairs of the item 'Yellow Boots' at a rate of 120 USD per Pairs. Debit it to the account 'Penne - SN'.
If the customer Kitty Pryde does not exist, create the customer record with 'Kitty Pryde' for customer name, 'Individual' for customer type, 'USD' for billing currency, 'www.shadowcat.com' for website, and 'Customer sometimes wears her hair in pigtails' for customer details.
If the stock item 'Yellow Boots' does not exist, create the item with 'Yellow Boots' for item name, 'BOOTS-YLW-US7-EU37' for item code, 'Products' for item group, and 'Pairs' for default unit of measure.
If the account 'Penne - SN' does not exist, create the account with 'Penne' for account name, 'Receivable' for account type, 'Fixed Assets - SN' for parent account and 'USD' for currency.
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Invoice` AS si INNER JOIN `tabCustomer` AS c ON si.customer_name=c.customer_name INNER JOIN `tabSales Invoice Item` AS sii ON si.name=sii.parent INNER JOIN `tabAccount` AS a ON si.debit_to=a.name WHERE si.customer_name="Kitty Pryde" AND c.customer_type="Individual" AND c.default_currency="USD" AND c.website="www.shadowcat.com" AND c.customer_details="Customer sometimes wears her hair in pigtails" AND sii.item_name="Yellow Boots" AND sii.item_code="BOOTS-YLW-US7-EU37" AND sii.item_group="Products" AND sii.uom="Pairs" AND sii.qty="7" AND sii.rate="120" AND si.debit_to="Penne - SN" AND a.account_type="Receivable" AND a.parent_account="Fixed Assets - SN" AND a.account_currency="USD" AND si.title="Sales Invoice for Kitty Pryde"
count: 1
Task: erpnext.create_sales_invoice_with_customer_item_account_dependencies_HARD
Goal: Create a sales invoice for the customer Charles Xavier for 1 Nos of the item 'Wheelchair' at a rate of 500000 JPY per Nos. Debit it to the account 'Linguine - SN'.
If the customer Charles Xavier does not exist, create the customer record with 'Charles Xavier' for customer name, 'Partnership' for customer type, 'JPY' for billing currency, 'www.professorx.com' for website, and 'Customer is bald' for customer details.
If the stock item 'Wheelchair' does not exist, create the item with 'Wheelchair' for item name, 'WCHR-SHIAR-HOV-YLW' for item code, 'Products' for item group, and 'Nos' for default unit of measure.
If the account 'Linguine - SN' does not exist, create the account with 'Linguine' for account name, 'Receivable' for account type, 'Stock Assets - SN' for parent account and 'JPY' for currency.
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Invoice` AS si INNER JOIN `tabCustomer` AS c ON si.customer_name=c.customer_name INNER JOIN `tabSales Invoice Item` AS sii ON si.name=sii.parent INNER JOIN `tabAccount` AS a ON si.debit_to=a.name WHERE si.customer_name="Charles Xavier" AND c.customer_type="Partnership" AND c.default_currency="JPY" AND c.website="www.professorx.com" AND c.customer_details="Customer is bald" AND sii.item_name="Wheelchair" AND sii.item_code="WCHR-SHIAR-HOV-YLW" AND sii.item_group="Products" AND sii.uom="Nos" AND sii.qty="1" AND sii.rate="500000" AND si.debit_to="Linguine - SN" AND a.account_type="Receivable" AND a.parent_account="Stock Assets - SN" AND a.account_currency="JPY" AND si.title="Sales Invoice for Charles Xavier"
count: 1
Task: erpnext.create_sales_invoice_with_customer_item_territory_pricelist_account_dependencies_HARD
Goal: Create a sales invoice for the customer Hank McCoy. The invoice is for 10 Unit of the item Spandex Shorts at a rate of 20 CHF per Unit. The sales territory should be set to Planet X and the account to debit to is the Peach - SN account.
If Hank McCoy is not yet a customer, add them, using 'Hank McCoy' as their name, 'Company' as their type, 'CHF' as their default currency, 'Canes' as their default price list. Also add their website, 'www.beast.com' and their customer details, 'Customer is blue'. (Create the default price list as needed, using 'Canes' as the name, 'CHF' as the currency, and check the box for 'Buying')
If Spandex Shorts is not yet listed as a stock item, add it, using 'SPNDX-SHORTS-XXXL' as the item code, 'Spandex Shorts' as the item name, 'Products' as the item group, and 'Unit' as the default unit of measure.
If Planet X is not yet listed as a sales territory, add it, using 'Planet X' as the name.
If Peach - SN is not yet listed as an account, add it, using 'Peach' as the name, 'Receivable' as the type, 'Fixed Assets - SN' as the parent account, and 'CHF' as the currency.
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Invoice` AS si INNER JOIN `tabCustomer` AS c ON si.customer_name=c.customer_name INNER JOIN `tabSales Invoice Item` AS sii ON si.name=sii.parent INNER JOIN `tabAccount` AS a ON si.debit_to=a.name WHERE si.customer_name="Hank McCoy" AND c.customer_type="Company" AND c.default_currency="CHF" AND c.default_price_list="Canes" AND c.website="www.beast.com" AND c.customer_details="Customer is blue" AND sii.item_name="Spandex Shorts" AND sii.item_code="SPNDX-SHORTS-XXXL" AND sii.item_group="Products" AND sii.uom="Unit" AND sii.qty="10" AND sii.rate="20" AND si.debit_to="Peach - SN" AND si.territory="Planet X" AND a.account_type="Receivable" AND a.parent_account="Fixed Assets - SN" AND a.account_currency="CHF" AND si.title="Sales Invoice - Hank McCoy"
count: 1
Task: erpnext.create_sales_invoice_with_customer_item_territory_pricelist_account_dependencies_HARD
Goal: Create a sales invoice for the customer James Logan. The invoice is for 1 Meter of the item Adamantium at a rate of 10000 EUR per Meter. The sales territory should be set to Planet Z and the account to debit to is the Apple - SN account.
If James Logan is not yet a customer, add them, using 'James Logan' as their name, 'Partnership' as their type, 'EUR' as their default currency, 'Papas' as their default price list. Also add their website, 'www.logan.com' and their customer details, 'Customer has two first names'. (Create the default price list as needed, using 'Papas' as the name, 'EUR' as the currency, and check the box for 'Buying')
If Adamantium is not yet listed as a stock item, add it, using 'MTL-ALLOY-ADMNTM' as the item code, 'Adamantium' as the item name, 'Raw Material' as the item group, and 'Meter' as the default unit of measure.
If Planet Z is not yet listed as a sales territory, add it, using 'Planet Z' as the name.
If Apple - SN is not yet listed as an account, add it, using 'Apple' as the name, 'Receivable' as the type, 'Current Assets - SN' as the parent account, and 'EUR' as the currency.
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Invoice` AS si INNER JOIN `tabCustomer` AS c ON si.customer_name=c.customer_name INNER JOIN `tabSales Invoice Item` AS sii ON si.name=sii.parent INNER JOIN `tabAccount` AS a ON si.debit_to=a.name WHERE si.customer_name="James Logan" AND c.customer_type="Partnership" AND c.default_currency="EUR" AND c.default_price_list="Papas" AND c.website="www.logan.com" AND c.customer_details="Customer has two first names" AND sii.item_name="Adamantium" AND sii.item_code="MTL-ALLOY-ADMNTM" AND sii.item_group="Raw Material" AND sii.uom="Meter" AND sii.qty="1" AND sii.rate="10000" AND si.debit_to="Apple - SN" AND si.territory="Planet Z" AND a.account_type="Receivable" AND a.parent_account="Current Assets - SN" AND a.account_currency="EUR" AND si.title="Sales Invoice - James Logan"
count: 1
Task: erpnext.create_sales_invoice_with_customer_item_territory_pricelist_account_dependencies_HARD
Goal: Create a sales invoice for the customer Meep. The invoice is for 100 Nos of the item Pink Meep Hat at a rate of 5 INR per Nos. The sales territory should be set to Planet J and the account to debit to is the Lime - SN account.
If Meep is not yet a customer, add them, using 'Meep' as their name, 'Individual' as their type, 'INR' as their default currency, 'Olive Garden' as their default price list. Also add their website, 'www.meep.com' and their customer details, 'Meep is here'. (Create the default price list as needed, using 'Olive Garden' as the name, 'INR' as the currency, and check the box for 'Buying')
If Pink Meep Hat is not yet listed as a stock item, add it, using 'HAT-PNK-XXS' as the item code, 'Pink Meep Hat' as the item name, 'Products' as the item group, and 'Nos' as the default unit of measure.
If Planet J is not yet listed as a sales territory, add it, using 'Planet J' as the name.
If Lime - SN is not yet listed as an account, add it, using 'Lime' as the name, 'Receivable' as the type, 'Tax Assets - SN' as the parent account, and 'INR' as the currency.
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Invoice` AS si INNER JOIN `tabCustomer` AS c ON si.customer_name=c.customer_name INNER JOIN `tabSales Invoice Item` AS sii ON si.name=sii.parent INNER JOIN `tabAccount` AS a ON si.debit_to=a.name WHERE si.customer_name="Meep" AND c.customer_type="Individual" AND c.default_currency="INR" AND c.default_price_list="Olive Garden" AND c.website="www.meep.com" AND c.customer_details="Meep is here" AND sii.item_name="Pink Meep Hat" AND sii.item_code="HAT-PNK-XXS" AND sii.item_group="Products" AND sii.uom="Nos" AND sii.qty="100" AND sii.rate="5" AND si.debit_to="Lime - SN" AND si.territory="Planet J" AND a.account_type="Receivable" AND a.parent_account="Tax Assets - SN" AND a.account_currency="INR" AND si.title="Sales Invoice - Meep"
count: 1
Task: erpnext.create_sales_invoice_with_date_cost_center
Goal: create a sales invoice for the customer playful Ltd. with SKU0014 for item, 1.0 for quantity, 20.0 for rate, 2050-09-18 for date, and Main - SN for cost center
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="playful Ltd." AND ii.item_name="SKU0014" AND ii.qty=1.0 AND ii.rate=20.0 AND i.posting_date="2050-09-18" AND i.cost_center="Main - SN"
count: 1
Task: erpnext.create_sales_invoice_with_date_cost_center
Goal: create a sales invoice for the customer independent ltd. with SKU0013 for item, 2.0 for quantity, 45.5 for rate, 2060-01-14 for date, and Main - SN for cost center
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="independent ltd." AND ii.item_name="SKU0013" AND ii.qty=2.0 AND ii.rate=45.5 AND i.posting_date="2060-01-14" AND i.cost_center="Main - SN"
count: 1
Task: erpnext.create_sales_invoice_with_date_cost_center
Goal: create a sales invoice for the customer Sivir ltd. with SKU0017 for item, 10.0 for quantity, 3.0 for rate, 2070-11-11 for date, and Main - SN for cost center
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="Sivir ltd." AND ii.item_name="SKU0017" AND ii.qty=10.0 AND ii.rate=3.0 AND i.posting_date="2070-11-11" AND i.cost_center="Main - SN"
count: 1
Task: erpnext.create_sales_order
Goal: create a sales order for the customer James Canon Ltd. with SKU0015 for item code, 2026-01-31 for delivery date, 1.0 for quantity, 20.0 for rate, and set source warehouse to Goods In Transit - SN
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="James Canon Ltd." AND soi.item_code="SKU0015" AND soi.qty="1.0" AND soi.rate="20.0" AND so.delivery_date="2026-01-31" AND so.set_warehouse="Goods In Transit - SN"
count: 1
Task: erpnext.create_sales_order
Goal: create a sales order for the customer RE Ltd. with SKU0016 for item code, 2029-02-14 for delivery date, 2.0 for quantity, 45.5 for rate, and set source warehouse to Stores - SN
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="RE Ltd." AND soi.item_code="SKU0016" AND soi.qty="2.0" AND soi.rate="45.5" AND so.delivery_date="2029-02-14" AND so.set_warehouse="Stores - SN"
count: 1
Task: erpnext.create_sales_order
Goal: create a sales order for the customer Payne Productions Ltd. with SKU0017 for item code, 2036-03-14 for delivery date, 10.0 for quantity, 3.0 for rate, and set source warehouse to Work In Progress - SN
Validation config:
sql: SELECT COUNT(*) as results_count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="Payne Productions Ltd." AND soi.item_code="SKU0017" AND soi.qty="10.0" AND soi.rate="3.0" AND so.delivery_date="2036-03-14" AND so.set_warehouse="Work In Progress - SN"
count: 1