[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[6275] addons/1.3/wxPOS/setup/invoices.sql



Revision: 6275
          http://sourceforge.net/p/ledger-smb/code/6275
Author:   einhverfr
Date:     2013-11-09 15:28:50 +0000 (Sat, 09 Nov 2013)
Log Message:
-----------
A sql fix that was interfering with posting.  Now to solve the accounts and invoice number issues.

Modified Paths:
--------------
    addons/1.3/wxPOS/setup/invoices.sql

Modified: addons/1.3/wxPOS/setup/invoices.sql
===================================================================
--- addons/1.3/wxPOS/setup/invoices.sql	2013-11-09 09:47:09 UTC (rev 6274)
+++ addons/1.3/wxPOS/setup/invoices.sql	2013-11-09 15:28:50 UTC (rev 6275)
@@ -15,7 +15,9 @@
          till, department_id, approved, entity_credit_account)
  VALUES ($1, $2, coalesce($3, 'f'),
          $4,$5, $6, coalesce($7, 'today'),
-         coalesce($8, 'today'), $9, coalesce($10, defaults_get_defaultcurrency()), 
+         coalesce($8, 'today'), $9, coalesce($10, 
+         (select defaults_get_defaultcurrency from 
+          defaults_get_defaultcurrency())), 
          coalesce($11, person__get_my_entity_id()), 
          $12, $13, coalesce($14, true), $15);
 

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


------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most 
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits