Author: jacopoc
Date: Wed Jan 13 13:55:29 2010
New Revision: 898754
URL: http://svn.apache.org/viewvc?rev=898754&view=rev
Log:
Demo data for a depreciation transaction.
Modified:
ofbiz/trunk/applications/accounting/data/DemoAcctgTransactionData.xml
ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml
Modified: ofbiz/trunk/applications/accounting/data/DemoAcctgTransactionData.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/data/DemoAcctgTransactionData.xml?rev=898754&r1=898753&r2=898754&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/data/DemoAcctgTransactionData.xml
(original)
+++ ofbiz/trunk/applications/accounting/data/DemoAcctgTransactionData.xml Wed
Jan 13 13:55:29 2010
@@ -40,21 +40,14 @@
<AcctgTransEntry acctgTransId="6004" acctgTransEntrySeqId="00001"
acctgTransEntryTypeId="_NA_" description="Initial raw materials inventory
purchase" glAccountId="111100" organizationPartyId="Company" amount="320.00"
currencyUomId="USD" origAmount="320.00" origCurrencyUomId="USD"
debitCreditFlag="C" reconcileStatusId="AES_NOT_RECONCILED"/>
<AcctgTransEntry acctgTransId="6004" acctgTransEntrySeqId="00002"
acctgTransEntryTypeId="_NA_" description="Initial raw materials inventory
value" glAccountId="141000" organizationPartyId="Company" amount="320.00"
currencyUomId="USD" origAmount="320.00" origCurrencyUomId="USD"
debitCreditFlag="D" reconcileStatusId="AES_NOT_RECONCILED"/>
+ <AcctgTrans acctgTransId="6005" acctgTransTypeId="DEPRECIATION"
description="Depreciation of vehicles after the first quarter"
transactionDate="2009-03-31 00:00:00.0" isPosted="Y" postedDate="2009-03-31
00:00:00.0" glFiscalTypeId="ACTUAL"/>
+ <AcctgTransEntry acctgTransId="6005" acctgTransEntrySeqId="00001"
acctgTransEntryTypeId="_NA_" description="Depreciation of vehicles after the
first quarter" glAccountId="188000" organizationPartyId="Company"
amount="2500.00" currencyUomId="USD" origAmount="2500.00"
origCurrencyUomId="USD" debitCreditFlag="C"
reconcileStatusId="AES_NOT_RECONCILED"/>
+ <AcctgTransEntry acctgTransId="6005" acctgTransEntrySeqId="00002"
acctgTransEntryTypeId="_NA_" description="Depreciation of vehicles after the
first quarter" glAccountId="675400" organizationPartyId="Company"
amount="2500.00" currencyUomId="USD" origAmount="2500.00"
origCurrencyUomId="USD" debitCreditFlag="D"
reconcileStatusId="AES_NOT_RECONCILED"/>
<!--
- <AcctgTrans acctgTransId="6005" acctgTransTypeId="AMORTIZATION"
description="Posted accounting transaction" transactionDate="2009-06-19
00:00:00.0" isPosted="Y" postedDate="2009-06-19 00:00:00.0"
glFiscalTypeId="ACTUAL" voucherRef="Z000"/>
- <AcctgTransEntry acctgTransId="6005" acctgTransEntrySeqId="00001"
acctgTransEntryTypeId="_NA_" description="Posted accounting transaction
entries" voucherRef="Z000" glAccountId="100000" organizationPartyId="Company"
amount="1786.43" currencyUomId="USD" origAmount="1786.43"
origCurrencyUomId="USD" debitCreditFlag="D"
reconcileStatusId="AES_NOT_RECONCILED"/>
- <AcctgTransEntry acctgTransId="6005" acctgTransEntrySeqId="00002"
acctgTransEntryTypeId="_NA_" description="Posted accounting transaction
entries" voucherRef="Z000" glAccountId="210000" organizationPartyId="Company"
amount="1786.43" currencyUomId="USD" origAmount="1786.43"
origCurrencyUomId="USD" debitCreditFlag="C"
reconcileStatusId="AES_NOT_RECONCILED"/>
-
<AcctgTrans acctgTransId="6006" acctgTransTypeId="AMORTIZATION"
description="Unposted accounting transaction" transactionDate="2009-06-19
00:00:00.0" isPosted="N" glFiscalTypeId="ACTUAL" voucherRef="Z0001"/>
<AcctgTransEntry acctgTransId="6006" acctgTransEntrySeqId="00001"
acctgTransEntryTypeId="_NA_" description="Unposted accounting transaction
entries" voucherRef="Z0001" glAccountId="120000" organizationPartyId="Company"
amount="500.00" currencyUomId="USD" origAmount="500.00" origCurrencyUomId="USD"
debitCreditFlag="D" reconcileStatusId="AES_NOT_RECONCILED"/>
<AcctgTransEntry acctgTransId="6006" acctgTransEntrySeqId="00002"
acctgTransEntryTypeId="_NA_" description="Unposted transaction entries"
voucherRef="Z0001" glAccountId="400000" organizationPartyId="Company"
amount="500.00" currencyUomId="USD" origAmount="500.00" origCurrencyUomId="USD"
debitCreditFlag="C" reconcileStatusId="AES_NOT_RECONCILED"/>
-->
- <GlAccountOrganization glAccountId="111100" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="51380.07"/>
- <GlAccountOrganization glAccountId="310000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="200000.00"/> <!-- Negative -->
- <GlAccountOrganization glAccountId="140000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="1799.93"/>
- <GlAccountOrganization glAccountId="141000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="320.00"/>
- <GlAccountOrganization glAccountId="171000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="76500.00"/>
- <GlAccountOrganization glAccountId="174000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="70000.00"/>
<GlAccountOrganization glAccountId="111100" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="51263.22"/>
<GlAccountOrganization glAccountId="112000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="20.00"/>
@@ -64,6 +57,7 @@
<GlAccountOrganization glAccountId="141000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="320.00"/>
<GlAccountOrganization glAccountId="171000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="76500.00"/>
<GlAccountOrganization glAccountId="174000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="70000.00"/>
+ <GlAccountOrganization glAccountId="188000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="2500.00"/>
<GlAccountOrganization glAccountId="210000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="348.00"/> <!-- Negative -->
<GlAccountOrganization glAccountId="213000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="70.00"/> <!-- Negative -->
<GlAccountOrganization glAccountId="214000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="0.00"/>
@@ -73,9 +67,10 @@
<GlAccountOrganization glAccountId="400000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="299.95"/> <!-- Negative -->
<GlAccountOrganization glAccountId="409000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="12.10"/> <!-- Negative -->
<GlAccountOrganization glAccountId="410000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="12.00"/>
- <GlAccountOrganization glAccountId="649000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="360.00"/>
<GlAccountOrganization glAccountId="500000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="13.50"/>
<GlAccountOrganization glAccountId="516100" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="24.88"/>
+ <GlAccountOrganization glAccountId="649000" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="360.00"/>
+ <GlAccountOrganization glAccountId="675400" organizationPartyId="Company"
fromDate="2001-01-01 00:00:00.0" postedBalance="2500.00"/>
<GlAccountHistory glAccountId="111100" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="51263.22" postedCredits="0.00"/>
<GlAccountHistory glAccountId="112000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="20.00" postedCredits="0.00"/>
@@ -85,6 +80,7 @@
<GlAccountHistory glAccountId="141000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="320.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="171000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="76500.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="174000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="70000.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="188000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="0.00" postedCredits="2500.00"/>
<GlAccountHistory glAccountId="210000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="0.00" postedCredits="348.00"/>
<GlAccountHistory glAccountId="213000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="0.00" postedCredits="70.00"/>
<GlAccountHistory glAccountId="214000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="0.00" postedCredits="0.00"/>
@@ -94,9 +90,10 @@
<GlAccountHistory glAccountId="400000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="0.00" postedCredits="299.95"/>
<GlAccountHistory glAccountId="409000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="0.00" postedCredits="12.10"/>
<GlAccountHistory glAccountId="410000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="12.00" postedCredits="0.00"/>
- <GlAccountHistory glAccountId="649000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="360.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="500000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="13.50" postedCredits="0.00"/>
<GlAccountHistory glAccountId="516100" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="24.88" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="649000" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="360.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="675400" organizationPartyId="Company"
customTimePeriodId="6010" postedDebits="2500.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="111100" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="51380.07" postedCredits="0.00"/>
<GlAccountHistory glAccountId="112000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
@@ -106,6 +103,7 @@
<GlAccountHistory glAccountId="141000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="320.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="171000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="76500.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="174000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="70000.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="188000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="2500.00"/>
<GlAccountHistory glAccountId="210000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="213000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="214000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
@@ -115,9 +113,10 @@
<GlAccountHistory glAccountId="400000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="409000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="410000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
- <GlAccountHistory glAccountId="649000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="500000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="516100" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="649000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="675400" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="2500.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="111100" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="116.85"/>
<GlAccountHistory glAccountId="112000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="20.00" postedCredits="0.00"/>
@@ -127,6 +126,7 @@
<GlAccountHistory glAccountId="141000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="171000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="174000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="188000" organizationPartyId="Company"
customTimePeriodId="6011" postedDebits="0.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="210000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="348.00"/>
<GlAccountHistory glAccountId="213000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="70.00"/>
<GlAccountHistory glAccountId="214000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="0.00"/>
@@ -136,8 +136,9 @@
<GlAccountHistory glAccountId="400000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="299.95"/>
<GlAccountHistory glAccountId="409000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="12.10"/>
<GlAccountHistory glAccountId="410000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="12.00" postedCredits="0.00"/>
- <GlAccountHistory glAccountId="649000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="360.00" postedCredits="0.00"/>
<GlAccountHistory glAccountId="500000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="13.50" postedCredits="0.00"/>
<GlAccountHistory glAccountId="516100" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="24.88" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="649000" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="360.00" postedCredits="0.00"/>
+ <GlAccountHistory glAccountId="675400" organizationPartyId="Company"
customTimePeriodId="6013" postedDebits="0.00" postedCredits="0.00"/>
</entity-engine-xml>
\ No newline at end of file
Modified: ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml?rev=898754&r1=898753&r2=898754&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml (original)
+++ ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml Wed Jan 13
13:55:29 2010
@@ -235,6 +235,7 @@
<GlAccountOrganization organizationPartyId="Company" glAccountId="150000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="171000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="174000"
fromDate="2001-01-01 00:00:00.0"/>
+ <GlAccountOrganization organizationPartyId="Company" glAccountId="188000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="210000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="213000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="213200"
fromDate="2001-01-01 00:00:00.0"/>
@@ -282,6 +283,7 @@
<GlAccountOrganization organizationPartyId="Company" glAccountId="625000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="649000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="650000"
fromDate="2001-01-01 00:00:00.0"/>
+ <GlAccountOrganization organizationPartyId="Company" glAccountId="675400"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="804000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="810000"
fromDate="2001-01-01 00:00:00.0"/>
<GlAccountOrganization organizationPartyId="Company" glAccountId="850000"
fromDate="2001-01-01 00:00:00.0"/>
