SF.net SVN: ledger-smb:[6716] trunk/sql/modules/Invoice.sql

[..hidden..]

Revision: 6716
          http://sourceforge.net/p/ledger-smb/code/6716
Author:   tshvr
Date:     2014-01-30 21:42:39 +0000 (Thu, 30 Jan 2014)
Log Message:
-----------
typing error ar/ap

Modified Paths:
--------------
    trunk/sql/modules/Invoice.sql

Modified: trunk/sql/modules/Invoice.sql
===================================================================
--- trunk/sql/modules/Invoice.sql	2014-01-30 12:01:18 UTC (rev 6715)
+++ trunk/sql/modules/Invoice.sql	2014-01-30 21:42:39 UTC (rev 6716)
@@ -153,9 +153,9 @@
    SELECT in_id, p.income_accno_id, a.transdate, i.qty * i.sellprice * -1, true, i.id
      FROM parts p
      JOIN invoice i ON i.parts_id = p.id
-     JOIN ar a ON i.trans_id = a.id AND a.id = in_id;
+     JOIN ap a ON i.trans_id = a.id AND a.id = in_id;
 
-   -- transaction should now be balanced if this was done with invoice__begin_ar
+   -- transaction should now be balanced if this was done with invoice__begin_ap
    -- add cogs
    PERFORM cogs__add_for_ap(parts_id, qty, sellprice)
       FROM invoice WHERE trans_id = in_id;

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


------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits