ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.assign_role
Goal: Assign role profile Manufacturing to user Post Malone
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabHas Role` WHERE parent="Manufacturing" AND role NOT IN (SELECT role FROM `tabUser` INNER JOIN `tabHas Role` ON `tabUser`.email=`tabHas Role`.parent WHERE `tabUser`.full_name="Post Malone")
count: 0
Task: erpnext.assign_role
Goal: Assign role profile Sales to user Jessica
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabHas Role` WHERE parent="Sales" AND role NOT IN (SELECT role FROM `tabUser` INNER JOIN `tabHas Role` ON `tabUser`.email=`tabHas Role`.parent WHERE `tabUser`.full_name="Jessica")
count: 0
Task: erpnext.create_user_email_first_last
Goal: create user with email jacob.smith@servicenow.com and name Jacob Smith
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE email="jacob.smith@servicenow.com" AND first_name="Jacob" AND last_name="Smith"
count: 1
Task: erpnext.create_user_email_first_last
Goal: create user with email jill.valentino@servicenow.com and name Jill Valentino
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE email="jill.valentino@servicenow.com" AND first_name="Jill" AND last_name="Valentino"
count: 1
Task: erpnext.create_user_email_first_last_username_phone
Goal: create user with Elodie as first name, Green as last name, EloGee as username, elo@service.com as email, and 281-000-0000 as phone number
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE username="EloGee" AND first_name="Elodie" AND last_name="Green" AND phone="281-000-0000" AND email="elo@service.com"
count: 1
Task: erpnext.create_user_email_first_last_username_phone
Goal: create user with Orlando as first name, Mar as last name, OrLMar as username, orl@service.com as email, and 713-000-0000 as phone number
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE username="OrLMar" AND first_name="Orlando" AND last_name="Mar" AND phone="713-000-0000" AND email="orl@service.com"
count: 1
Task: erpnext.create_user_email_first_last_username_phone
Goal: create user with Aaron as first name, Lieb as last name, AaronL as username, aaron@service.com as email, and 812-000-0000 as phone number
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE username="AaronL" AND first_name="Aaron" AND last_name="Lieb" AND phone="812-000-0000" AND email="aaron@service.com"
count: 1
Task: erpnext.create_user_group_with_new_users_HARD
Goal: Create a user named Blossom Utonium whose email address is blossom.utonium@ppg.com and birthday is 1998-12-12. In their bio, enter the details "Protects the citizens of Townsville against villains like Mojo Jojo, HIM, and the Gangreen Gang alongside her two sisters". Once that user is created, create two more users named Bubbles Utonium and Buttercup Utonium. Their email addresses should be bubbles.utonium@ppg.com and buttercup.utonium@ppg.com, respectively. For their birthdays and bios, put the same information that appears on Blossom Utonium's record. Once the three users are created, create a user group that includes all three of them named The Powerpuff Girls.
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="The Powerpuff Girls" AND u.first_name="Blossom" AND u.last_name="Utonium" AND u.email="blossom.utonium@ppg.com" AND u.bio="Protects the citizens of Townsville against villains like Mojo Jojo, HIM, and the Gangreen Gang alongside her two sisters" AND u.birth_date="1998-12-12" UNION ALL SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="The Powerpuff Girls" AND u.first_name="Bubbles" AND u.last_name="Utonium" AND u.email="bubbles.utonium@ppg.com" AND u.bio="Protects the citizens of Townsville against villains like Mojo Jojo, HIM, and the Gangreen Gang alongside her two sisters" AND u.birth_date="1998-12-12" UNION ALL SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="The Powerpuff Girls" AND u.first_name="Buttercup" AND u.last_name="Utonium" AND u.email="buttercup.utonium@ppg.com" AND u.bio="Protects the citizens of Townsville against villains like Mojo Jojo, HIM, and the Gangreen Gang alongside her two sisters" AND u.birth_date="1998-12-12") AS counts_sum
count: 3
Task: erpnext.create_user_group_with_new_users_HARD
Goal: Create a user named Brick JoJo whose email address is brick.jojo@ppg.com and birthday is 1999-12-19. In their bio, enter the details "Created by Mojo JoJo and also used by HIM, direct villain counterparts to the PPG". Once that user is created, create two more users named Boomer JoJo and Butch JoJo. Their email addresses should be boomer.jojo@ppg.com and butch.jojo@ppg.com, respectively. For their birthdays and bios, put the same information that appears on Brick JoJo's record. Once the three users are created, create a user group that includes all three of them named The Rowdyruff Boys.
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="The Rowdyruff Boys" AND u.first_name="Brick" AND u.last_name="JoJo" AND u.email="brick.jojo@ppg.com" AND u.bio="Created by Mojo JoJo and also used by HIM, direct villain counterparts to the PPG" AND u.birth_date="1999-12-19" UNION ALL SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="The Rowdyruff Boys" AND u.first_name="Boomer" AND u.last_name="JoJo" AND u.email="boomer.jojo@ppg.com" AND u.bio="Created by Mojo JoJo and also used by HIM, direct villain counterparts to the PPG" AND u.birth_date="1999-12-19" UNION ALL SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="The Rowdyruff Boys" AND u.first_name="Butch" AND u.last_name="JoJo" AND u.email="butch.jojo@ppg.com" AND u.bio="Created by Mojo JoJo and also used by HIM, direct villain counterparts to the PPG" AND u.birth_date="1999-12-19") AS counts_sum
count: 3
Task: erpnext.create_user_group_with_new_users_HARD
Goal: Create a user named Mojo JoJo whose email address is mojo.jojo@ppg.com and birthday is 1998-12-15. In their bio, enter the details "Always causing trouble around Townsville". Once that user is created, create two more users named HIM HIM and Princess Morbucks. Their email addresses should be him.him@ppg.com and princess.morbucks@ppg.com, respectively. For their birthdays and bios, put the same information that appears on Mojo JoJo's record. Once the three users are created, create a user group that includes all three of them named PPG Villains.
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="PPG Villains" AND u.first_name="Mojo" AND u.last_name="JoJo" AND u.email="mojo.jojo@ppg.com" AND u.bio="Always causing trouble around Townsville" AND u.birth_date="1998-12-15" UNION ALL SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="PPG Villains" AND u.first_name="HIM" AND u.last_name="HIM" AND u.email="him.him@ppg.com" AND u.bio="Always causing trouble around Townsville" AND u.birth_date="1998-12-15" UNION ALL SELECT COUNT(*) AS count FROM `tabUser Group Member` AS ugm INNER JOIN `tabUser` AS u ON ugm.user=u.email WHERE ugm.parent="PPG Villains" AND u.first_name="Princess" AND u.last_name="Morbucks" AND u.email="princess.morbucks@ppg.com" AND u.bio="Always causing trouble around Townsville" AND u.birth_date="1998-12-15") AS counts_sum
count: 3
Task: erpnext.create_user_with_email_account_dependency_HARD
Goal: Create a user named Walter White whose email is ww@gmail.com and username is heisenberg. Add their phone number 713-207-3984 to the record and set their desk theme to Light and document follow frequency to Hourly. Finally, set up their email account so it has ww@gmail.com as the email address, GMail as the service provider, a signature 'Best regards, Walter White', an auto reply 'Thanks for reaching out, I will get back to you as soon as possible.', and a footer 'Walter, Manufacturer'.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabUser` AS u INNER JOIN `tabEmail Account` AS a ON u.email=a.email_id WHERE u.first_name="Walter" AND u.last_name="White" AND u.email="ww@gmail.com" AND u.username="heisenberg" AND u.phone="713-207-3984" AND u.desk_theme="Light" AND document_follow_notify="1" AND u.document_follow_frequency="Hourly" AND a.service="GMail" AND a.awaiting_password="1" AND a.add_signature="1" AND a.signature LIKE "%\Best regards, Walter White%" AND a.enable_auto_reply="1" AND a.auto_reply_message LIKE "%\Thanks for reaching out, I will get back to you as soon as possible.%" AND a.footer LIKE "%\Walter, Manufacturer%"
count: 1
Task: erpnext.create_user_with_email_account_dependency_HARD
Goal: Create a user named Brandon Mayhew whose email is badger@yahoo.com and username is badger. Add their phone number 713-000-1111 to the record and set their desk theme to Dark and document follow frequency to Daily. Finally, set up their email account so it has badger@yahoo.com as the email address, Yahoo Mail as the service provider, a signature 'Best regards, Brandon', an auto reply 'I will get back to you as soon as possible.', and a footer 'Brandon, Dealer'.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabUser` AS u INNER JOIN `tabEmail Account` AS a ON u.email=a.email_id WHERE u.first_name="Brandon" AND u.last_name="Mayhew" AND u.email="badger@yahoo.com" AND u.username="badger" AND u.phone="713-000-1111" AND u.desk_theme="Dark" AND document_follow_notify="1" AND u.document_follow_frequency="Daily" AND a.service="Yahoo Mail" AND a.awaiting_password="1" AND a.add_signature="1" AND a.signature LIKE "%\Best regards, Brandon%" AND a.enable_auto_reply="1" AND a.auto_reply_message LIKE "%\I will get back to you as soon as possible.%" AND a.footer LIKE "%\Brandon, Dealer%"
count: 1
Task: erpnext.create_user_with_email_account_dependency_HARD
Goal: Create a user named Peter Baker whose email is sp@yandex.com and username is skinny_pete. Add their phone number 812-111-0000 to the record and set their desk theme to Automatic and document follow frequency to Weekly. Finally, set up their email account so it has sp@yandex.com as the email address, Yandex.Mail as the service provider, a signature 'Best regards, Pete', an auto reply 'Out on vacation, will get back to you as soon as possible.', and a footer 'Pete, Not a Dealer'.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabUser` AS u INNER JOIN `tabEmail Account` AS a ON u.email=a.email_id WHERE u.first_name="Peter" AND u.last_name="Baker" AND u.email="sp@yandex.com" AND u.username="skinny_pete" AND u.phone="812-111-0000" AND u.desk_theme="Automatic" AND document_follow_notify="1" AND u.document_follow_frequency="Weekly" AND a.service="Yandex.Mail" AND a.awaiting_password="1" AND a.add_signature="1" AND a.signature LIKE "%\Best regards, Pete%" AND a.enable_auto_reply="1" AND a.auto_reply_message LIKE "%\Out on vacation, will get back to you as soon as possible.%" AND a.footer LIKE "%\Pete, Not a Dealer%"
count: 1
Task: erpnext.disable_user_account
Goal: Disable account for username Mingi
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE username="Mingi" and enabled=0
count: 1
Task: erpnext.disable_user_account
Goal: Disable account for username orlando
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabUser WHERE username="orlando" and enabled=0
count: 1
Task: erpnext.assign_journal_entry_then_update_task_status
Goal: Assign the journal entry titled ACC-JV-2025-00005 to the user Eugene Krabs and update the "Rescind employee paychecks" task to Pending Review status
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) as count FROM `tabJournal Entry` WHERE title="ACC-JV-2025-00005" and _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Eugene Krabs"), "%") UNION ALL SELECT COUNT(*) as count FROM `tabTask` WHERE subject="Rescind employee paychecks" and status="Pending Review") as counts_sum
count: 2
Task: erpnext.assign_journal_entry_then_update_task_status
Goal: Assign the journal entry titled Office Equipments - SN to the user Milton Waddams and update the "Protect stapler at all costs" task to Cancelled status
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) as count FROM `tabJournal Entry` WHERE title="Office Equipments - SN" and _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Milton Waddams"), "%") UNION ALL SELECT COUNT(*) as count FROM `tabTask` WHERE subject="Protect stapler at all costs" and status="Cancelled") as counts_sum
count: 2
Task: erpnext.create_customer_then_create_sales_invoice
Goal: Create a record for the customer named Holmes and Watson with type Partnership. Save their address as 221B Baker Street, London, United Kingdom, then create a sales invoice for Holmes and Watson for 1 unit(s) of the SKU0015 item at a rate of $20.0 per unit.
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS 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="Holmes and Watson" AND cu.customer_type="Partnership" AND a.address_line1="221B Baker Street" AND a.city="London" AND a.country="United Kingdom" UNION ALL SELECT COUNT(*) AS count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="Holmes and Watson" AND ii.item_name="SKU0015" AND ii.qty="1" AND ii.rate="20.0" AND ii.parenttype="Sales Invoice") as counts_sum
count: 2
Task: erpnext.create_customer_then_create_sales_invoice
Goal: Create a record for the customer named Umbrella Corporation with type Company. Save their address as 1 Paraguas Street, Raccoon City, Canada, then create a sales invoice for Umbrella Corporation for 2 unit(s) of the SKU0015 item at a rate of $45.5 per unit.
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS 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="Umbrella Corporation" AND cu.customer_type="Company" AND a.address_line1="1 Paraguas Street" AND a.city="Raccoon City" AND a.country="Canada" UNION ALL SELECT COUNT(*) AS count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="Umbrella Corporation" AND ii.item_name="SKU0015" AND ii.qty="2" AND ii.rate="45.5" AND ii.parenttype="Sales Invoice") as counts_sum
count: 2
Task: erpnext.create_customer_then_create_sales_invoice
Goal: Create a record for the customer named Gringotts Wizarding Bank with type Company. Save their address as 99 Diagon Alley, London, United Kingdom, then create a sales invoice for Gringotts Wizarding Bank for 10 unit(s) of the SKU0016 item at a rate of $3.0 per unit.
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS 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="Gringotts Wizarding Bank" AND cu.customer_type="Company" AND a.address_line1="99 Diagon Alley" AND a.city="London" AND a.country="United Kingdom" UNION ALL SELECT COUNT(*) AS count FROM `tabSales Invoice` AS i INNER JOIN `tabSales Invoice Item` AS ii ON i.name=ii.parent WHERE i.customer="Gringotts Wizarding Bank" AND ii.item_name="SKU0016" AND ii.qty="10" AND ii.rate="3.0" AND ii.parenttype="Sales Invoice") as counts_sum
count: 2
Task: erpnext.create_customer_then_create_sales_order
Goal: Create a customer record for the customer Lumon Industries. Set their customer type to Company and address to 101 Crawfords Corner Road, Kier, Canada. Then create a sales order for them that orders 1.0 units of the item SKU0015 at a rate of $20.0 per unit. Items should be shipped from the Payback - SN warehouse and delivered on 2029-11-11.
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS 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="Lumon Industries" AND cu.customer_type="Company" AND a.address_line1="101 Crawfords Corner Road" AND a.city="Kier" AND a.country="Canada" UNION ALL SELECT COUNT(*) AS count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="Lumon Industries" AND soi.item_code="SKU0015" AND soi.qty="1.0" AND soi.rate="20.0" AND so.delivery_date="2029-11-11" AND so.set_warehouse="Payback - SN") as counts_sum
count: 2
Task: erpnext.create_customer_then_create_sales_order
Goal: Create a customer record for the customer Ollivander's Wand Shop. Set their customer type to Individual and address to 42 Diagon Alley, London, United Kingdom. Then create a sales order for them that orders 2.0 units of the item SKU0016 at a rate of $45.5 per unit. Items should be shipped from the Teen Kick - SN warehouse and delivered on 2031-09-13.
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS 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="Ollivander's Wand Shop" AND cu.customer_type="Individual" AND a.address_line1="42 Diagon Alley" AND a.city="London" AND a.country="United Kingdom" UNION ALL SELECT COUNT(*) AS count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="Ollivander's Wand Shop" AND soi.item_code="SKU0016" AND soi.qty="2.0" AND soi.rate="45.5" AND so.delivery_date="2031-09-13" AND so.set_warehouse="Teen Kick - SN") as counts_sum
count: 2
Task: erpnext.create_customer_then_create_sales_order
Goal: Create a customer record for the customer United Liberty Paper. Set their customer type to Partnership and address to 37 Columbus Avenue, Liberty City, Canada. Then create a sales order for them that orders 10.0 units of the item SKU0017 at a rate of $3.0 per unit. Items should be shipped from the Guardians - SN warehouse and delivered on 2066-06-16.
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS 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="United Liberty Paper" AND cu.customer_type="Partnership" AND a.address_line1="37 Columbus Avenue" AND a.city="Liberty City" AND a.country="Canada" UNION ALL SELECT COUNT(*) AS count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="United Liberty Paper" AND soi.item_code="SKU0017" AND soi.qty="10.0" AND soi.rate="3.0" AND so.delivery_date="2066-06-16" AND so.set_warehouse="Guardians - SN") as counts_sum
count: 2
Task: erpnext.create_project_then_cancel_payment_entry
Goal: create a new project with Pasta for project name, and ServiceNow for company, then cancel payment entry named Luigi's Pizza and Pasta
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS count FROM `tabProject` WHERE project_name="Pasta" AND company="ServiceNow" UNION ALL  SELECT COUNT(*) as count FROM `tabPayment Entry` WHERE title="Luigi's Pizza and Pasta" AND status="Cancelled") as counts_sum
count: 2
Task: erpnext.create_project_then_cancel_payment_entry
Goal: create a new project with SmashBurger for project name, and ServiceNow for company, then cancel payment entry named Smashburger
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS count FROM `tabProject` WHERE project_name="SmashBurger" AND company="ServiceNow" UNION ALL  SELECT COUNT(*) as count FROM `tabPayment Entry` WHERE title="Smashburger" AND status="Cancelled") as counts_sum
count: 2
Task: erpnext.create_project_then_cancel_payment_entry
Goal: create a new project with Fresas con Crema for project name, and ServiceNow for company, then cancel payment entry named Bueno Nacho
Validation config:
sql: SELECT SUM(count) as results_count FROM (SELECT COUNT(*) AS count FROM `tabProject` WHERE project_name="Fresas con Crema" AND company="ServiceNow" UNION ALL  SELECT COUNT(*) as count FROM `tabPayment Entry` WHERE title="Bueno Nacho" AND status="Cancelled") as counts_sum
count: 2
Task: erpnext.create_purchase_order_then_manage_supplier
Goal: Create a purchase order to send to supplier Teen Titans. Order 1 Unit of the item SKU0013 required by 2070-10-21 with an additional 10.0% discount. Send goods to the X-Men - SN warehouse and favorite this supplier
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM tabSupplier WHERE supplier_name="Teen Titans" AND LOCATE("Administrator", _liked_by) > 0 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="Teen Titans" AND i.qty="1" AND i.item_code="SKU0013" AND o.schedule_date="2070-10-21" AND o.set_warehouse="X-Men - SN" AND additional_discount_percentage="10.0" AND uom="Unit") AS counts_sum
count: 2
Task: erpnext.create_purchase_order_then_manage_supplier
Goal: Create a purchase order to send to supplier The Seven. Order 5 Box of the item SKU0014 required by 2070-01-01 with an additional 15.0% discount. Send goods to the Thunderbolts - SN warehouse and favorite this supplier
Validation config:
sql: SELECT SUM(count) AS results_count FROM (SELECT COUNT(*) AS count FROM tabSupplier WHERE supplier_name="The Seven" AND LOCATE("Administrator", _liked_by) > 0 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="The Seven" AND i.qty="5" AND i.item_code="SKU0014" AND o.schedule_date="2070-01-01" AND o.set_warehouse="Thunderbolts - SN" AND additional_discount_percentage="15.0" AND uom="Box") AS counts_sum
count: 2
Task: erpnext.create_sales_invoice_then_assign_task
Goal: create a sales invoice for the customer Grant Stella Ltd. for the item SKU0015. The invoice should reflect 1.0 for quantity, and $20.0 for rate, then assign the 'discuss Gordon project' task to the user Dorothy Gale
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="Grant Stella Ltd." AND item_code="SKU0015" AND qty="1.0" AND rate="20.0" UNION ALL SELECT COUNT(*) AS count FROM  tabTask WHERE subject="discuss Gordon project" AND _assign LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Dorothy Gale"), "%")) as counts_sum
count: 2
Task: erpnext.create_sales_invoice_then_assign_task
Goal: create a sales invoice for the customer DailyDose for the item SKU0015. The invoice should reflect 2.0 for quantity, and $45.5 for rate, then assign the 'clean up codebase' task to the user Billie
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="DailyDose" AND item_code="SKU0015" AND qty="2.0" AND rate="45.5" UNION ALL SELECT COUNT(*) AS count FROM  tabTask WHERE subject="clean up codebase" AND _assign LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Billie"), "%")) as counts_sum
count: 2