SF.net SVN: ledger-smb:[3390] trunk/sql/modules/test/Taxform.sql

[..hidden..]

Revision: 3390
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3390&view=rev
Author:   einhverfr
Date:     2011-06-30 16:12:44 +0000 (Thu, 30 Jun 2011)

Log Message:
-----------
data verified to be accurate in test cases, so now working on the discrepancies

Modified Paths:
--------------
    trunk/sql/modules/test/Taxform.sql

Modified: trunk/sql/modules/test/Taxform.sql
===================================================================
--- trunk/sql/modules/test/Taxform.sql	2011-06-30 15:40:22 UTC (rev 3389)
+++ trunk/sql/modules/test/Taxform.sql	2011-06-30 16:12:44 UTC (rev 3390)
@@ -209,7 +209,7 @@
      VALUES (-1034, -1000, date1(), -1010, true, -215);
 
 insert into invoice(trans_id, id, parts_id, description, qty, sellprice)
-     VALUES (-1034, -201, -255, 'test 1', 1, 1000);
+     VALUES (-1034, -201, -255, 'test 1', -1, 1000);
 
 INSERT INTO invoice_tax_form(invoice_id, reportable)
      VALUES (-201, true);
@@ -242,7 +242,7 @@
      VALUES (-1035, -1000, date1(), -505, true, -225);
 
 insert into invoice(trans_id, id, parts_id, description, qty, sellprice)
-     VALUES (-1035, -211, -255, 'test 1', 1, 1000);
+     VALUES (-1035, -211, -255, 'test 1', -1, 1000);
 
 INSERT INTO invoice_tax_form(invoice_id, reportable)
      VALUES (-211, true);
@@ -279,7 +279,7 @@
      VALUES (-1036, -1000, date2(), -505, true, -237);
 
 insert into invoice(trans_id, id, parts_id, description, qty, sellprice)
-     VALUES (-1036, -221, -255, 'test 1', 1, 1000);
+     VALUES (-1036, -221, -255, 'test 1', -1, 1000);
 
 INSERT INTO invoice_tax_form(invoice_id, reportable)
      VALUES (-221, true);
@@ -305,13 +305,13 @@
      VALUES (-1037, -1001, date1(), -10, true, -243);
 
 INSERT INTO acc_trans(trans_id, chart_id, transdate, amount, approved, entry_id)
-     VALUES (-1037, -1002, date1(), 505, true, -244);
+     VALUES (-1037, -1002, date1(), 1010, true, -244);
 
 INSERT INTO acc_trans(trans_id, chart_id, transdate, amount, approved, entry_id)
-     VALUES (-1037, -1000, date1(), -505, true, -245);
+     VALUES (-1037, -1000, date1(), -1010, true, -245);
 
 insert into invoice(trans_id, id, parts_id, description, qty, sellprice)
-     VALUES (-1037, -231, -255, 'test 1', 1, 1000);
+     VALUES (-1037, -231, -255, 'test 1', -1, 1000);
 
 INSERT INTO invoice_tax_form(invoice_id, reportable)
      VALUES (-231, true);
@@ -606,8 +606,7 @@
 SELECT *
     FROM tax_form_details_report(-511, (date1() - '1 day'::interval)::date, 
                                   (date1() + '1 day'::interval)::date, 
-                                'Test account 2')
-    WHERE invoice_id = -1034;
+                                'Test account 2');
 SELECT *
   FROM tax_form_summary_report(-511, (date1() - '1 day'::interval)::date, 
                                   (date1() + '1 day'::interval)::date);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.