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

SF.net SVN: ledger-smb:[6875] trunk



Revision: 6875
          http://sourceforge.net/p/ledger-smb/code/6875
Author:   pongracz
Date:     2014-02-19 08:59:17 +0000 (Wed, 19 Feb 2014)
Log Message:
-----------
Merged from 1.3.x Include customer's/vendor's tax id in the AR/AP transaction and sales invoice forms. This is necessary (pull this tax id from the DB) to be able to include it in the printed invoice. There are rules, where the tax id must be on the invoice. Now, if one needs this info in the invoice, it is easy to include, like this: <?lsmb tax_id ?>  that's all. Note: it seems the sales/purchase invoice form a little bit different from AR/AP transactions, where customer/vendor details displayed, need some polish, maybe later.

Modified Paths:
--------------
    trunk/LedgerSMB/AA.pm
    trunk/bin/aa.pl
    trunk/bin/ir.pl
    trunk/bin/is.pl

Property Changed:
----------------
    trunk/LedgerSMB/
    trunk/LedgerSMB/AA.pm
    trunk/bin/
    trunk/bin/aa.pl
    trunk/bin/ir.pl
    trunk/bin/is.pl

Index: trunk/LedgerSMB
===================================================================
--- trunk/LedgerSMB	2014-02-19 08:43:48 UTC (rev 6874)
+++ trunk/LedgerSMB	2014-02-19 08:59:17 UTC (rev 6875)

Property changes on: trunk/LedgerSMB
___________________________________________________________________
Added: svn:text-time
## -0,0 +1 ##
+2014-02-19T08:57:07.559585Z
\ No newline at end of property
Added: svn:unix-mode
## -0,0 +1 ##
+0700
\ No newline at end of property
Added: svn:owner
## -0,0 +1 ##
+0 root
\ No newline at end of property
Added: svn:group
## -0,0 +1 ##
+0 root
\ No newline at end of property
Modified: trunk/LedgerSMB/AA.pm
===================================================================
--- trunk/LedgerSMB/AA.pm	2014-02-19 08:43:48 UTC (rev 6874)
+++ trunk/LedgerSMB/AA.pm	2014-02-19 08:59:17 UTC (rev 6875)
@@ -850,7 +850,8 @@
 		          c.language_code, $duedate AS duedate, 
 			  b.discount AS tradediscount, 
 		          b.description AS business, 
-			  entity.control_code as entity_control_code,
+			  entity.control_code AS entity_control_code,
+                          co.tax_id AS tax_id,
 			  c.meta_number, ecl.*, ctf.default_reportable,
                           c.cash_account_id, ca.accno as cash_accno
 		     FROM entity_credit_account c
@@ -858,6 +859,7 @@
                 LEFT JOIN account ca ON c.cash_account_id = ca.id
 		LEFT JOIN business b ON (b.id = c.business_id)
                 LEFT JOIN country_tax_form ctf ON ctf.id = c.taxform_id
+                LEFT JOIN company co ON co.entity_id = c.entity_id
                 LEFT JOIN (SELECT coalesce(line_one, '')
                                || ' ' || coalesce(line_two, '') as address,
                                l.city, etl.credit_id


Property changes on: trunk/LedgerSMB/AA.pm
___________________________________________________________________
Modified: svn:text-time
## -1 +1 ##
-2013-09-20T13:22:45.000000Z
+2014-02-19T08:57:07.469592Z
\ No newline at end of property
Modified: svn:owner
## -1 +1 ##
-33 www-data
+0 root
\ No newline at end of property
Modified: svn:group
## -1 +1 ##
-33 www-data
+0 root
\ No newline at end of property
Index: trunk/bin
===================================================================
--- trunk/bin	2014-02-19 08:43:48 UTC (rev 6874)
+++ trunk/bin	2014-02-19 08:59:17 UTC (rev 6875)

Property changes on: trunk/bin
___________________________________________________________________
Added: svn:text-time
## -0,0 +1 ##
+2014-02-19T08:53:39.359271Z
\ No newline at end of property
Added: svn:unix-mode
## -0,0 +1 ##
+0700
\ No newline at end of property
Added: svn:owner
## -0,0 +1 ##
+0 root
\ No newline at end of property
Added: svn:group
## -0,0 +1 ##
+0 root
\ No newline at end of property
Modified: trunk/bin/aa.pl
===================================================================
--- trunk/bin/aa.pl	2014-02-19 08:43:48 UTC (rev 6874)
+++ trunk/bin/aa.pl	2014-02-19 08:59:17 UTC (rev 6875)
@@ -565,7 +565,7 @@
     $form->hide_form(
         qw(batch_id approved id printed emailed sort closedto locked 
            oldtransdate audittrail recurring checktax reverse batch_id subtype
-           entity_control_code meta_number default_reportable address city)
+           entity_control_code tax_id meta_number default_reportable address city)
     );
 
     if ( $form->{vc} eq 'customer' ) {
@@ -652,6 +652,11 @@
 	      </tr>
 	        <tr>
 		<th align="right" nowrap>| . 
+			$locale->text('Tax ID') . qq|</th>
+		<td colspan=3>$form->{tax_id}</td>
+	      </tr>
+	        <tr>
+		<th align="right" nowrap>| . 
 			$locale->text('Account') . qq|</th>
 		<td colspan=3>$form->{meta_number}</td>
 	      </tr>


Property changes on: trunk/bin/aa.pl
___________________________________________________________________
Modified: svn:text-time
## -1 +1 ##
-2014-02-07T23:57:37.525077Z
+2014-02-19T08:53:39.220282Z
\ No newline at end of property
Modified: trunk/bin/ir.pl
===================================================================
--- trunk/bin/ir.pl	2014-02-19 08:43:48 UTC (rev 6874)
+++ trunk/bin/ir.pl	2014-02-19 08:59:17 UTC (rev 6875)
@@ -514,11 +514,16 @@
 	        <tr>
 		<th align="right" nowrap>| . 
 			$locale->text('Entity Code') . qq|</th>
-		<td colspan="2">$form->{entity_control_code}</td>
+		<td colspan="2" nowrap>$form->{entity_control_code}</td>
 		<th align="right" nowrap>| . 
 			$locale->text('Account') . qq|</th>
 		<td colspan=3>$form->{meta_number}</td>
 	      </tr>
+              <tr>
+                <th align="right" nowrap>| .
+                        $locale->text('Tax ID'). qq|</th>
+                <td colspan=3>$form->{tax_id}</td>
+              </tr>
               <tr class="address_row">
                 <th align="right" nowrap>| .
                         $locale->text('Address'). qq|</th>


Property changes on: trunk/bin/ir.pl
___________________________________________________________________
Modified: svn:text-time
## -1 +1 ##
-2013-08-30T14:22:08.364598Z
+2014-02-19T08:51:36.512526Z
\ No newline at end of property
Modified: trunk/bin/is.pl
===================================================================
--- trunk/bin/is.pl	2014-02-19 08:43:48 UTC (rev 6874)
+++ trunk/bin/is.pl	2014-02-19 08:59:17 UTC (rev 6875)
@@ -476,7 +476,7 @@
     $form->hide_form(
         qw(form_id id type printed emailed queued title vc terms discount 
            creditlimit creditremaining tradediscount business closedto locked 
-           shipped oldtransdate recurring reverse batch_id subtype 
+           shipped oldtransdate recurring reverse batch_id subtype tax_id 
            meta_number separate_duties lock_description nextsub default_reportable address city)
     );
 
@@ -542,11 +542,16 @@
 	        <tr>
 		<th align="right" nowrap>| . 
 			$locale->text('Entity Code') . qq|</th>
-		<td colspan="2">$form->{entity_control_code}</td>
+		<td colspan="2" nowrap>$form->{entity_control_code}</td>
 		<th align="right" nowrap>| . 
 			$locale->text('Account') . qq|</th>
 		<td colspan=3>$form->{meta_number}</td>
 	      </tr>
+              <tr>
+                <th align="right" nowrap>| .
+                        $locale->text('Tax ID'). qq|</th>
+                <td colspan=3>$form->{tax_id}</td>
+              </tr>
               <tr class="address_row">
                 <th align="right" nowrap>| .
                         $locale->text('Address'). qq|</th>


Property changes on: trunk/bin/is.pl
___________________________________________________________________
Modified: svn:text-time
## -1 +1 ##
-2013-09-20T14:40:14.000000Z
+2014-02-19T08:49:52.477365Z
\ No newline at end of property
Modified: svn:owner
## -1 +1 ##
-33 www-data
+0 root
\ No newline at end of property
Modified: svn:group
## -1 +1 ##
-33 www-data
+0 root
\ No newline at end of property
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits