svn commit: r1094131 - in /ofbiz/branches/release09.04: ./ applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml

Author: jleroux
Date: Sun Apr 17 11:29:54 2011
New Revision: 1094131

URL: http://svn.apache.org/viewvc?rev=1094131&view=rev
Log:
"Applied fix from trunk for revision: 1094126"
------------------------------------------------------------------------
r1094126 | jleroux | 2011-04-17 12:15:23 +0200 (dim., 17 avr. 2011) | 8 lines

A patch from Pierre Gaudin "Error in stock reception on same inventory item with same unit price" https://issues.apache.org/jira/browse/OFBIZ-4250

During the reception of stock, if the reception is made on a line of stock which already exists with the same unit price, an accounting transaction due to the stock price value change is created with an amount of debit and credit of 0.

This is not normal and generate an error in the service postAcctgTrans.

This aim of this patch is to avoid creation of accounting transaction linked to the stock price value change if the unit price does not change.

------------------------------------------------------------------------


Modified:
    ofbiz/branches/release09.04/   (props changed)
    ofbiz/branches/release09.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml

Propchange: ofbiz/branches/release09.04/
------------------------------------------------------------------------------
--- svn:mergeinfo (original)
+++ svn:mergeinfo Sun Apr 17 11:29:54 2011
@@ -1 +1 @@
-/ofbiz/trunk:765933,766011,766015,766293,766307,766316,766325,766462,766522,766800,767060,767072,767093,767098-767099,767102,767123,767125,767127,767279,767287,767671,767688,767694,767822,767845,768358,768490,768550,768675,768686,768705,768811,768815,768960,769030,769500,770272,770308,770997,771073,771477,772401,772464-772465,773076,773557,773628,773659,773697,774014,774632,774661,774995,775292,775667,776227,776594,776620,776922,777004,777020,777768,777792,777893,777947,778078,778094,778107,778273,778278,778280,778364,778374,778402,778576,778594,778628,779020,779477,779496,779639,779834,779856,779866,779873,780111,780138,780180,780199,780203,780906,780945,781201,781534,781549,781669,781680,781694,782663,783257,783266,783833,783913,783917,785123,785764,785967,786778,787126,787435-787436,787442,787520,788965,788983,788987,789329,789337,789506,789548,796769,799185,800461,800846,801023,802346,804364,805307,806127,806377,806914,808786-808787,808792,809141,810370,810438,810465,810
 807,810809,810814,810832,810836,810878,810917,811020,811280,811297,811419,811528,811708,811714,811716,811793,811838,811860,811865,811870,812159,812182,812192,812456,812540,812724,813126,813131,813283,813672,813702,814168,814205,814251,814349,814531,814576,814681,814731,815158,815165,815350,815687,815977,816255,816863,818030,818049,818150,818494,818500,818716,818976,819275-819276,819282,819337,821263,821270,822659,823877-823878,823883,823888,823892,824511,825181-825182,826253,827730,828971,829085,829376,829412,829416,829527,830091,830112,830366,830528,830677,830874,830880,831238,831801,832361,832698,832776,832880,832908,833324,833686,833703,834825,835161,835357,835585,836015,881194,881713,882072,882326,882918,883933,884023,884529,884546,884758,885122,885702,887916,888111,888559,888587,889666,890050,890107,890245,891378,891620,896649,899188,899833,900024,900026,900050,900217,900273,901628,907342-907343,910460,912587,915332,916252,916703,916925,917435,922042,923828,927870,92803
 7,928166,928171,928180,928470,928477,929582,931594-931595,933157,935494,936817,941047,941431,941440,942884,943168,944895,945118,948017,950866,950870,950893,951005,951062,951098,951367,951381,951672,953294,953671,954135,954956,958343,958514,958521,960997,964558,965470,965916,966785,967098,978893,980641-980642,980935,981051,981104,981123,981288,983920,985718,985856,985902,990339,995686,996069,996078-996079,996563,997419-997420,997440,1003434,1003450,1004139,1037567,1040044,1042009,1042034,1042038,1042132,1042188,1042317,1042348,1042411,1043996-1043998,1050602,1056305,1057519,1058488,1059180,1060261,1060368,1060933,1061167,1063273,1066048,1067097,1069597,1069965,1072017,1075205,1080959,1084572,1084671,1084689,1085697,1085774,1090952,1090961,1090964
+/ofbiz/trunk:765933,766011,766015,766293,766307,766316,766325,766462,766522,766800,767060,767072,767093,767098-767099,767102,767123,767125,767127,767279,767287,767671,767688,767694,767822,767845,768358,768490,768550,768675,768686,768705,768811,768815,768960,769030,769500,770272,770308,770997,771073,771477,772401,772464-772465,773076,773557,773628,773659,773697,774014,774632,774661,774995,775292,775667,776227,776594,776620,776922,777004,777020,777768,777792,777893,777947,778078,778094,778107,778273,778278,778280,778364,778374,778402,778576,778594,778628,779020,779477,779496,779639,779834,779856,779866,779873,780111,780138,780180,780199,780203,780906,780945,781201,781534,781549,781669,781680,781694,782663,783257,783266,783833,783913,783917,785123,785764,785967,786778,787126,787435-787436,787442,787520,788965,788983,788987,789329,789337,789506,789548,796769,799185,800461,800846,801023,802346,804364,805307,806127,806377,806914,808786-808787,808792,809141,810370,810438,810465,810
 807,810809,810814,810832,810836,810878,810917,811020,811280,811297,811419,811528,811708,811714,811716,811793,811838,811860,811865,811870,812159,812182,812192,812456,812540,812724,813126,813131,813283,813672,813702,814168,814205,814251,814349,814531,814576,814681,814731,815158,815165,815350,815687,815977,816255,816863,818030,818049,818150,818494,818500,818716,818976,819275-819276,819282,819337,821263,821270,822659,823877-823878,823883,823888,823892,824511,825181-825182,826253,827730,828971,829085,829376,829412,829416,829527,830091,830112,830366,830528,830677,830874,830880,831238,831801,832361,832698,832776,832880,832908,833324,833686,833703,834825,835161,835357,835585,836015,881194,881713,882072,882326,882918,883933,884023,884529,884546,884758,885122,885702,887916,888111,888559,888587,889666,890050,890107,890245,891378,891620,896649,899188,899833,900024,900026,900050,900217,900273,901628,907342-907343,910460,912587,915332,916252,916703,916925,917435,922042,923828,927870,92803
 7,928166,928171,928180,928470,928477,929582,931594-931595,933157,935494,936817,941047,941431,941440,942884,943168,944895,945118,948017,950866,950870,950893,951005,951062,951098,951367,951381,951672,953294,953671,954135,954956,958343,958514,958521,960997,964558,965470,965916,966785,967098,978893,980641-980642,980935,981051,981104,981123,981288,983920,985718,985856,985902,990339,995686,996069,996078-996079,996563,997419-997420,997440,1003434,1003450,1004139,1037567,1040044,1042009,1042034,1042038,1042132,1042188,1042317,1042348,1042411,1043996-1043998,1050602,1056305,1057519,1058488,1059180,1060261,1060368,1060933,1061167,1063273,1066048,1067097,1069597,1069965,1072017,1075205,1080959,1084572,1084671,1084689,1085697,1085774,1090952,1090961,1090964,1094126

Modified: ofbiz/branches/release09.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml
URL: http://svn.apache.org/viewvc/ofbiz/branches/release09.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml?rev=1094131&r1=1094130&r2=1094131&view=diff
==============================================================================
--- ofbiz/branches/release09.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml (original)
+++ ofbiz/branches/release09.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml Sun Apr 17 11:29:54 2011
@@ -1471,35 +1471,38 @@ under the License.
                     </calcop>
                 </calcop>
             </calculate>
-            <get-related-one value-field="newInventoryItemDetail" relation-name="InventoryItem" to-value-field="inventoryItem"/>
-            <!-- Credit -->
-            <make-value entity-name="AcctgTransEntry" value-field="creditEntry"/>
-            <set field="creditEntry.debitCreditFlag" value="C"/>
-            <set field="creditEntry.glAccountTypeId" value="INVENTORY_ACCOUNT"/>
-            <set field="creditEntry.organizationPartyId" from-field="inventoryItem.ownerPartyId"/>
-            <set field="creditEntry.productId" from-field="inventoryItem.productId"/>
-            <set field="creditEntry.origAmount" from-field="origAmount"/>
-            <set field="creditEntry.origCurrencyUomId" from-field="inventoryItem.currencyUomId"/>
-            <!-- Debit -->
-            <make-value entity-name="AcctgTransEntry" value-field="debitEntry"/>
-            <set field="debitEntry.debitCreditFlag" value="D"/>
-            <set field="debitEntry.glAccountTypeId" value="INV_ADJ_VAL"/>
-            <set field="debitEntry.organizationPartyId" from-field="inventoryItem.ownerPartyId"/>
-            <set field="debitEntry.productId" from-field="inventoryItem.productId"/>
-            <set field="debitEntry.origAmount" from-field="origAmount"/>
-            <set field="debitEntry.origCurrencyUomId" from-field="inventoryItem.currencyUomId"/>
-
-            <set field="acctgTransEntries[]" from-field="creditEntry" type="Object"/>
-            <set field="acctgTransEntries[]" from-field="debitEntry" type="Object"/>
-
-            <set field="createAcctgTransAndEntriesInMap.glFiscalTypeId" value="ACTUAL"/>
-            <set field="createAcctgTransAndEntriesInMap.acctgTransTypeId" value="INVENTORY"/>
-            <set field="createAcctgTransAndEntriesInMap.inventoryItemId" from-field="parameters.inventoryItemId"/>
-            <set field="createAcctgTransAndEntriesInMap.acctgTransEntries" from-field="acctgTransEntries"/>
-            <call-service service-name="createAcctgTransAndEntries" in-map-name="createAcctgTransAndEntriesInMap">
-                <result-to-field result-name="acctgTransId"/>
-            </call-service>
-            <field-to-result field="acctgTransId" result-name="acctgTransId"/>
+            <!-- if originAmount is equals to 0 do not create transaction, this is causing error in postAcctgTrans -->
+            <if-compare operator="not-equals" field="origAmount" value="0">
+                <get-related-one value-field="newInventoryItemDetail" relation-name="InventoryItem" to-value-field="inventoryItem"/>
+                <!-- Credit -->
+                <make-value entity-name="AcctgTransEntry" value-field="creditEntry"/>
+                <set field="creditEntry.debitCreditFlag" value="C"/>
+                <set field="creditEntry.glAccountTypeId" value="INVENTORY_ACCOUNT"/>
+                <set field="creditEntry.organizationPartyId" from-field="inventoryItem.ownerPartyId"/>
+                <set field="creditEntry.productId" from-field="inventoryItem.productId"/>
+                <set field="creditEntry.origAmount" from-field="origAmount"/>
+                <set field="creditEntry.origCurrencyUomId" from-field="inventoryItem.currencyUomId"/>
+                <!-- Debit -->
+                <make-value entity-name="AcctgTransEntry" value-field="debitEntry"/>
+                <set field="debitEntry.debitCreditFlag" value="D"/>
+                <set field="debitEntry.glAccountTypeId" value="INV_ADJ_VAL"/>
+                <set field="debitEntry.organizationPartyId" from-field="inventoryItem.ownerPartyId"/>
+                <set field="debitEntry.productId" from-field="inventoryItem.productId"/>
+                <set field="debitEntry.origAmount" from-field="origAmount"/>
+                <set field="debitEntry.origCurrencyUomId" from-field="inventoryItem.currencyUomId"/>
+    
+                <set field="acctgTransEntries[]" from-field="creditEntry" type="Object"/>
+                <set field="acctgTransEntries[]" from-field="debitEntry" type="Object"/>
+    
+                <set field="createAcctgTransAndEntriesInMap.glFiscalTypeId" value="ACTUAL"/>
+                <set field="createAcctgTransAndEntriesInMap.acctgTransTypeId" value="INVENTORY"/>
+                <set field="createAcctgTransAndEntriesInMap.inventoryItemId" from-field="parameters.inventoryItemId"/>
+                <set field="createAcctgTransAndEntriesInMap.acctgTransEntries" from-field="acctgTransEntries"/>
+                <call-service service-name="createAcctgTransAndEntries" in-map-name="createAcctgTransAndEntriesInMap">
+                    <result-to-field result-name="acctgTransId"/>
+                </call-service>
+                <field-to-result field="acctgTransId" result-name="acctgTransId"/>
+            </if-compare>
         </if-not-empty>
     </simple-method>