diff --git a/erpnext/regional/report/irs_1099/irs_1099.py b/erpnext/regional/report/irs_1099/irs_1099.py
index cef8950..0cb4a3a 100644
--- a/erpnext/regional/report/irs_1099/irs_1099.py
+++ b/erpnext/regional/report/irs_1099/irs_1099.py
@@ -26,7 +26,7 @@
 			s.supplier_group as "supplier_group",
 			gl.party AS "supplier",
 			s.tax_id as "tax_id",
-			SUM(gl.debit) AS "payments"
+			SUM(gl.debit_in_account_currency) AS "payments"
 		FROM
 			`tabGL Entry` gl INNER JOIN `tabSupplier` s
 		WHERE
diff --git a/erpnext/regional/united_states/test_united_states.py b/erpnext/regional/united_states/test_united_states.py
index df6cb39..7634843 100644
--- a/erpnext/regional/united_states/test_united_states.py
+++ b/erpnext/regional/united_states/test_united_states.py
@@ -8,28 +8,34 @@
 
 class TestUnitedStates(unittest.TestCase):
     def test_irs_1099_custom_field(self):
-        doc = frappe.new_doc("Supplier")
-        doc.supplier_name = "_US 1099 Test Supplier"
-        doc.supplier_group = "Services"
-        doc.supplier_type = "Company"
-        doc.country = "United States"
-        doc.tax_id = "04-1234567"
-        doc.irs_1099 = 1
-        doc.save()
-        frappe.db.commit()
-        supplier = frappe.get_doc('Supplier', "_US 1099 Test Supplier")
-        self.assertEqual(supplier.irs_1099, 1)
+
+        frappe.db.sql("delete from `tabGL Entry` where party='_US 1099 Test Supplier'")
+        frappe.db.sql("delete from `tabGL Entry` where against='_US 1099 Test Supplier'")
+        frappe.db.sql("delete from `tabPayment Entry` where party='_US 1099 Test Supplier'")
+
+        if not frappe.db.exists("Supplier", "_US 1099 Test Supplier"):
+            doc = frappe.new_doc("Supplier")
+            doc.supplier_name = "_US 1099 Test Supplier"
+            doc.supplier_group = "Services"
+            doc.supplier_type = "Company"
+            doc.country = "United States"
+            doc.tax_id = "04-1234567"
+            doc.irs_1099 = 1
+            doc.save()
+            frappe.db.commit()
+            supplier = frappe.get_doc('Supplier', "_US 1099 Test Supplier")
+            self.assertEqual(supplier.irs_1099, 1)
 
     def test_irs_1099_report(self):
         make_payment_entry_to_irs_1099_supplier()
-        filters = frappe._dict({"fiscal_year": "2016", "company": "_Test Company"})
+        filters = frappe._dict({"fiscal_year": "_Test Fiscal Year 2016", "company": "_Test Company"})
         columns, data = execute_1099_report(filters)
         print(columns, data)
         expected_row = {'supplier': '_US 1099 Test Supplier',
                         'supplier_group': 'Services',
                         'payments': 100.0,
                         'tax_id': '04-1234567'}
-        self.assertEqual(data, expected_row)
+        self.assertEqual(data[0], expected_row)
 
 
 def make_payment_entry_to_irs_1099_supplier():
@@ -45,4 +51,5 @@
     pe.reference_date = "2016-01-10"
     pe.party_type = "Supplier"
     pe.party = "_US 1099 Test Supplier"
-    pe.save()
+    pe.insert()
+    pe.submit()