Author: hansbak
Date: Wed Feb 25 05:58:50 2009
New Revision: 747669
URL: http://svn.apache.org/viewvc?rev=747669&view=rev
Log:
add some more time periods, changed organizationPartyId on demo payment and
invoices to 'company'
Modified:
ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml
ofbiz/trunk/applications/accounting/data/PaymentsInvoices.xml
Modified: ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml?rev=747669&r1=747668&r2=747669&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml (original)
+++ ofbiz/trunk/applications/accounting/data/DemoGlSetupData.xml Wed Feb 25
05:58:50 2009
@@ -334,7 +334,17 @@
<CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6007"
periodTypeId="FISCAL_QUARTER" fromDate="2008-04-01" thruDate="2008-07-01"
isClosed="N" periodNum="2" periodName="2008/Q2" parentPeriodId="6005"/>
<CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6008"
periodTypeId="FISCAL_QUARTER" fromDate="2008-07-01" thruDate="2008-10-01"
isClosed="N" periodNum="3" periodName="2008/Q3" parentPeriodId="6005"/>
<CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6009"
periodTypeId="FISCAL_QUARTER" fromDate="2008-10-01" thruDate="2009-01-01"
isClosed="N" periodNum="4" periodName="2008/Q4" parentPeriodId="6005"/>
-
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6010"
periodTypeId="FISCAL_YEAR" fromDate="2009-01-01" thruDate="2010-01-01"
isClosed="N" periodNum="5" periodName="2009"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6011"
periodTypeId="FISCAL_QUARTER" fromDate="2009-01-01" thruDate="2009-04-01"
isClosed="N" periodNum="1" periodName="2009/Q1" parentPeriodId="6010"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6012"
periodTypeId="FISCAL_QUARTER" fromDate="2009-04-01" thruDate="2009-07-01"
isClosed="N" periodNum="2" periodName="2009/Q2" parentPeriodId="6010"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6013"
periodTypeId="FISCAL_QUARTER" fromDate="2009-07-01" thruDate="2009-10-01"
isClosed="N" periodNum="3" periodName="2009/Q3" parentPeriodId="6011"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6014"
periodTypeId="FISCAL_QUARTER" fromDate="2009-10-01" thruDate="2010-01-01"
isClosed="N" periodNum="4" periodName="2009/Q4" parentPeriodId="6012"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6015"
periodTypeId="FISCAL_YEAR" fromDate="2010-01-01" thruDate="2011-01-01"
isClosed="N" periodNum="5" periodName="2010"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6016"
periodTypeId="FISCAL_QUARTER" fromDate="2010-01-01" thruDate="2010-04-01"
isClosed="N" periodNum="1" periodName="2010/Q1" parentPeriodId="6015"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6017"
periodTypeId="FISCAL_QUARTER" fromDate="2010-04-01" thruDate="2010-07-01"
isClosed="N" periodNum="2" periodName="2010/Q2" parentPeriodId="6015"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6018"
periodTypeId="FISCAL_QUARTER" fromDate="2010-07-01" thruDate="2010-10-01"
isClosed="N" periodNum="3" periodName="2010/Q3" parentPeriodId="6015"/>
+ <CustomTimePeriod organizationPartyId="Company" customTimePeriodId="6019"
periodTypeId="FISCAL_QUARTER" fromDate="2010-10-01" thruDate="2011-01-01"
isClosed="N" periodNum="4" periodName="2010/Q4" parentPeriodId="6015"/>
+
<UomConversionDated uomId="USD" uomIdTo="EUR" fromDate="2001-01-01
00:00:00.0" conversionFactor="0.7"/><!-- to convert demo invoice -->
</entity-engine-xml>
Modified: ofbiz/trunk/applications/accounting/data/PaymentsInvoices.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/data/PaymentsInvoices.xml?rev=747669&r1=747668&r2=747669&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/data/PaymentsInvoices.xml (original)
+++ ofbiz/trunk/applications/accounting/data/PaymentsInvoices.xml Wed Feb 25
05:58:50 2009
@@ -28,17 +28,17 @@
<PartyGroup partyId="AcctBigSupplier" groupName="Acct Big Supplier"/>
<PartyRole partyId="AcctBigSupplier" roleTypeId="SUPPLIER"/>
- <Payment paymentId="demo10000" paymentTypeId="CUSTOMER_PAYMENT"
paymentMethodTypeId="EFT_ACCOUNT" partyIdFrom="AcctBuyer" partyIdTo="TESTING"
statusId="PMNT_NOT_PAID" effectiveDate="2006-04-25 12:56:54.292"
amount="190.97" currencyUomId="USD" lastUpdatedStamp="2006-04-25 13:13:27.746"
lastUpdatedTxStamp="2006-04-25 13:13:27.711" createdStamp="2006-04-25
12:56:54.292" createdTxStamp="2006-04-25 12:56:54.292"/>
- <Payment paymentId="demo10010" paymentTypeId="CUSTOMER_REFUND"
paymentMethodTypeId="EXT_BILLACT" partyIdFrom="TESTING" partyIdTo="AcctBuyer"
statusId="PMNT_SENT" effectiveDate="2006-04-25 13:11:05.94" amount="20.0"
currencyUomId="USD" lastUpdatedStamp="2006-04-25 13:12:57.445"
lastUpdatedTxStamp="2006-04-25 13:12:57.33" createdStamp="2006-04-25
13:11:05.941" createdTxStamp="2006-04-25 13:11:05.941"/>
+ <Payment paymentId="demo10000" paymentTypeId="CUSTOMER_PAYMENT"
paymentMethodTypeId="EFT_ACCOUNT" partyIdFrom="AcctBuyer" partyIdTo="Company"
statusId="PMNT_NOT_PAID" effectiveDate="2006-04-25 12:56:54.292"
amount="190.97" currencyUomId="USD" lastUpdatedStamp="2006-04-25 13:13:27.746"
lastUpdatedTxStamp="2006-04-25 13:13:27.711" createdStamp="2006-04-25
12:56:54.292" createdTxStamp="2006-04-25 12:56:54.292"/>
+ <Payment paymentId="demo10010" paymentTypeId="CUSTOMER_REFUND"
paymentMethodTypeId="EXT_BILLACT" partyIdFrom="Company" partyIdTo="AcctBuyer"
statusId="PMNT_SENT" effectiveDate="2006-04-25 13:11:05.94" amount="20.0"
currencyUomId="USD" lastUpdatedStamp="2006-04-25 13:12:57.445"
lastUpdatedTxStamp="2006-04-25 13:12:57.33" createdStamp="2006-04-25
13:11:05.941" createdTxStamp="2006-04-25 13:11:05.941"/>
- <Invoice invoiceId="demo10000" invoiceTypeId="SALES_INVOICE"
partyIdFrom="TESTING" partyId="AcctBuyer" statusId="INVOICE_IN_PROCESS"
invoiceDate="2006-04-25 12:46:27.122" description="This is the first invoice
number t AcctBuyer" currencyUomId="USD" lastUpdatedStamp="2006-04-25
12:46:27.426" lastUpdatedTxStamp="2006-04-25 12:46:27.426"
createdStamp="2006-04-25 12:46:27.426" createdTxStamp="2006-04-25
12:46:27.426"/>
+ <Invoice invoiceId="demo10000" invoiceTypeId="SALES_INVOICE"
partyIdFrom="Company" partyId="AcctBuyer" statusId="INVOICE_IN_PROCESS"
invoiceDate="2006-04-25 12:46:27.122" description="This is the first invoice
number t AcctBuyer" currencyUomId="USD" lastUpdatedStamp="2006-04-25
12:46:27.426" lastUpdatedTxStamp="2006-04-25 12:46:27.426"
createdStamp="2006-04-25 12:46:27.426" createdTxStamp="2006-04-25
12:46:27.426"/>
<InvoiceItem invoiceId="demo10000" invoiceItemSeqId="00001"
invoiceItemTypeId="INV_SPROD_ITEM" uomId="USD" taxableFlag="Y" amount="20.0"
description="this was e service for a product" lastUpdatedStamp="2006-04-25
12:47:16.599" lastUpdatedTxStamp="2006-04-25 12:47:16.48"
createdStamp="2006-04-25 12:47:16.599" createdTxStamp="2006-04-25 12:47:16.48"/>
<InvoiceItem invoiceId="demo10000" invoiceItemSeqId="00002"
invoiceItemTypeId="INV_PROD_ITEM" uomId="USD" taxableFlag="Y" amount="269.99"
description="Big Gizmo w/ Legs" lastUpdatedStamp="2006-04-25 12:48:07.529"
lastUpdatedTxStamp="2006-04-25 12:48:07.443" createdStamp="2006-04-25
12:47:49.766" createdTxStamp="2006-04-25 12:47:49.401"/>
<InvoiceItem invoiceId="demo10000" invoiceItemSeqId="00003"
invoiceItemTypeId="INV_SALES_TAX" uomId="USD" taxableFlag="Y" amount="33.55"
description="sales tax" lastUpdatedStamp="2006-04-25 12:49:06.04"
lastUpdatedTxStamp="2006-04-25 12:49:06.038" createdStamp="2006-04-25
12:49:06.04" createdTxStamp="2006-04-25 12:49:06.038"/>
- <Invoice invoiceId="demo10001" invoiceTypeId="PURCHASE_INVOICE"
partyIdFrom="AcctBigSupplier" partyId="TESTING" statusId="INVOICE_IN_PROCESS"
invoiceDate="2006-04-25 12:50:50.655" description="Another invoice"
currencyUomId="USD" lastUpdatedStamp="2006-04-25 12:50:50.665"
lastUpdatedTxStamp="2006-04-25 12:50:50.538" createdStamp="2006-04-25
12:50:50.665" createdTxStamp="2006-04-25 12:50:50.538"/>
+ <Invoice invoiceId="demo10001" invoiceTypeId="PURCHASE_INVOICE"
partyIdFrom="AcctBigSupplier" partyId="Company" statusId="INVOICE_IN_PROCESS"
invoiceDate="2006-04-25 12:50:50.655" description="Another invoice"
currencyUomId="USD" lastUpdatedStamp="2006-04-25 12:50:50.665"
lastUpdatedTxStamp="2006-04-25 12:50:50.538" createdStamp="2006-04-25
12:50:50.665" createdTxStamp="2006-04-25 12:50:50.538"/>
<InvoiceItem invoiceId="demo10001" invoiceItemSeqId="00001"
invoiceItemTypeId="PINV_WE_ITEM" uomId="USD" taxableFlag="Y" amount="33.99"
description="Service received" lastUpdatedStamp="2006-04-25 12:51:29.251"
lastUpdatedTxStamp="2006-04-25 12:51:29.197" createdStamp="2006-04-25
12:51:29.251" createdTxStamp="2006-04-25 12:51:29.197"/>
<InvoiceItem invoiceId="demo10001" invoiceItemSeqId="00002"
invoiceItemTypeId="PINV_SURCHARGE_ADJ" uomId="USD" taxableFlag="Y"
amount="2.44" description="Service received" lastUpdatedStamp="2006-04-25
12:52:19.907" lastUpdatedTxStamp="2006-04-25 12:52:19.826"
createdStamp="2006-04-25 12:52:19.907" createdTxStamp="2006-04-25
12:52:19.826"/>
- <Invoice invoiceId="demo10002" invoiceTypeId="SALES_INVOICE"
partyIdFrom="TESTING" partyId="AcctBuyer" statusId="INVOICE_SENT"
invoiceDate="2006-04-25 12:54:07.011" description="Another sales invoice"
currencyUomId="USD" lastUpdatedStamp="2006-04-25 12:55:44.189"
lastUpdatedTxStamp="2006-04-25 12:55:44.058" createdStamp="2006-04-25
12:54:07.018" createdTxStamp="2006-04-25 12:54:06.97"/>
+ <Invoice invoiceId="demo10002" invoiceTypeId="SALES_INVOICE"
partyIdFrom="Company" partyId="AcctBuyer" statusId="INVOICE_SENT"
invoiceDate="2006-04-25 12:54:07.011" description="Another sales invoice"
currencyUomId="USD" lastUpdatedStamp="2006-04-25 12:55:44.189"
lastUpdatedTxStamp="2006-04-25 12:55:44.058" createdStamp="2006-04-25
12:54:07.018" createdTxStamp="2006-04-25 12:54:06.97"/>
<InvoiceItem invoiceId="demo10002" invoiceItemSeqId="00001"
invoiceItemTypeId="INV_DPROD_ITEM" uomId="USD" taxableFlag="Y" amount="1.0"
description="Add more money to your card!" lastUpdatedStamp="2006-04-25
12:54:37.473" lastUpdatedTxStamp="2006-04-25 12:54:37.373"
createdStamp="2006-04-25 12:54:37.473" createdTxStamp="2006-04-25
12:54:37.373"/>
<InvoiceItem invoiceId="demo10002" invoiceItemSeqId="00002"
invoiceItemTypeId="INV_DPROD_ITEM" uomId="USD" taxableFlag="Y" amount="55.99"
description="A digital gizmo: can be downloaded immediately after purchase."
lastUpdatedStamp="2006-04-25 12:55:27.232" lastUpdatedTxStamp="2006-04-25
12:55:27.092" createdStamp="2006-04-25 12:55:27.232" createdTxStamp="2006-04-25
12:55:27.092"/>
<InvoiceStatus statusId="INVOICE_IN_PROCESS" invoiceId="demo10000"
statusDate="2006-04-25 12:46:27.122" lastUpdatedStamp="2006-04-25 12:46:27.492"
lastUpdatedTxStamp="2006-04-25 12:46:27.426" createdStamp="2006-04-25
12:46:27.492" createdTxStamp="2006-04-25 12:46:27.426"/>
@@ -47,15 +47,15 @@
<InvoiceStatus statusId="INVOICE_SENT" invoiceId="demo10002"
statusDate="2006-04-25 12:55:44.228" lastUpdatedStamp="2006-04-25 12:55:44.228"
lastUpdatedTxStamp="2006-04-25 12:55:44.058" createdStamp="2006-04-25
12:55:44.228" createdTxStamp="2006-04-25 12:55:44.058"/>
<Party partyId="EuroCustomer"/><!-- more data added in party component -->
- <Invoice invoiceId="demo11000" invoiceTypeId="SALES_INVOICE"
partyIdFrom="TESTING" partyId="EuroCustomer" statusId="INVOICE_APPROVED"
invoiceDate="2006-04-25 12:46:27.122" description="This is the first invoice
number to Eurocustomer with currency in euro" currencyUomId="EUR"
lastUpdatedStamp="2006-04-25 12:46:27.426" lastUpdatedTxStamp="2006-04-25
12:46:27.426" createdStamp="2006-04-25 12:46:27.426" createdTxStamp="2006-04-25
12:46:27.426"/>
+ <Invoice invoiceId="demo11000" invoiceTypeId="SALES_INVOICE"
partyIdFrom="Company" partyId="EuroCustomer" statusId="INVOICE_APPROVED"
invoiceDate="2006-04-25 12:46:27.122" description="This is the first invoice
number to Eurocustomer with currency in euro" currencyUomId="EUR"
lastUpdatedStamp="2006-04-25 12:46:27.426" lastUpdatedTxStamp="2006-04-25
12:46:27.426" createdStamp="2006-04-25 12:46:27.426" createdTxStamp="2006-04-25
12:46:27.426"/>
<InvoiceItem invoiceId="demo11000" invoiceItemSeqId="00001"
invoiceItemTypeId="INV_SPROD_ITEM" uomId="USD" taxableFlag="Y" amount="20.0"
description="this was e service for a product" lastUpdatedStamp="2006-04-25
12:47:16.599" lastUpdatedTxStamp="2006-04-25 12:47:16.48"
createdStamp="2006-04-25 12:47:16.599" createdTxStamp="2006-04-25 12:47:16.48"/>
<InvoiceStatus statusId="INVOICE_IN_PROCESS" invoiceId="demo11000"
statusDate="2006-04-25 12:46:27.122" lastUpdatedStamp="2006-04-25 12:46:27.492"
lastUpdatedTxStamp="2006-04-25 12:46:27.426" createdStamp="2006-04-25
12:46:27.492" createdTxStamp="2006-04-25 12:46:27.426"/>
<InvoiceStatus statusId="INVOICE_APPROVED" invoiceId="demo11000"
statusDate="2006-04-25 12:46:27.122" lastUpdatedStamp="2006-04-25 12:46:27.492"
lastUpdatedTxStamp="2006-04-25 12:46:27.426" createdStamp="2006-04-25
12:46:27.492" createdTxStamp="2006-04-25 12:46:27.426"/>
- <Invoice invoiceId="demo11001" invoiceTypeId="SALES_INVOICE"
partyIdFrom="TESTING" partyId="EuroCustomer" statusId="INVOICE_APPROVED"
invoiceDate="2006-04-25 12:46:27.122" description="This is the first invoice
number to Eurocustomer with currency in euro" currencyUomId="EUR"
lastUpdatedStamp="2006-04-25 12:46:27.426" lastUpdatedTxStamp="2006-04-25
12:46:27.426" createdStamp="2006-04-25 12:46:27.426" createdTxStamp="2006-04-25
12:46:27.426"/>
+ <Invoice invoiceId="demo11001" invoiceTypeId="SALES_INVOICE"
partyIdFrom="Company" partyId="EuroCustomer" statusId="INVOICE_APPROVED"
invoiceDate="2006-04-25 12:46:27.122" description="This is the first invoice
number to Eurocustomer with currency in euro" currencyUomId="EUR"
lastUpdatedStamp="2006-04-25 12:46:27.426" lastUpdatedTxStamp="2006-04-25
12:46:27.426" createdStamp="2006-04-25 12:46:27.426" createdTxStamp="2006-04-25
12:46:27.426"/>
<InvoiceItem invoiceId="demo11001" invoiceItemSeqId="00001"
invoiceItemTypeId="INV_SPROD_ITEM" uomId="USD" taxableFlag="Y" amount="543.23"
description="this was e service for a product" lastUpdatedStamp="2006-04-25
12:47:16.599" lastUpdatedTxStamp="2006-04-25 12:47:16.48"
createdStamp="2006-04-25 12:47:16.599" createdTxStamp="2006-04-25 12:47:16.48"/>
<InvoiceStatus statusId="INVOICE_IN_PROCESS" invoiceId="demo11001"
statusDate="2006-04-25 12:46:27.122" lastUpdatedStamp="2006-04-25 12:46:27.492"
lastUpdatedTxStamp="2006-04-25 12:46:27.426" createdStamp="2006-04-25
12:46:27.492" createdTxStamp="2006-04-25 12:46:27.426"/>
<InvoiceStatus statusId="INVOICE_APPROVED" invoiceId="demo11001"
statusDate="2006-04-25 12:46:27.122" lastUpdatedStamp="2006-04-25 12:46:27.492"
lastUpdatedTxStamp="2006-04-25 12:46:27.426" createdStamp="2006-04-25
12:46:27.492" createdTxStamp="2006-04-25 12:46:27.426"/>
- <Payment paymentId="demo10001" paymentTypeId="CUSTOMER_PAYMENT"
paymentMethodTypeId="EFT_ACCOUNT" partyIdFrom="EuroCustomer"
partyIdTo="TESTING" statusId="PMNT_RECEIVED" effectiveDate="2006-04-25
12:56:54.292" amount="820.97" currencyUomId="USD" actualCurrencyAmount="543.23"
actualCurrencyUomId="EUR"/>
+ <Payment paymentId="demo10001" paymentTypeId="CUSTOMER_PAYMENT"
paymentMethodTypeId="EFT_ACCOUNT" partyIdFrom="EuroCustomer"
partyIdTo="Company" statusId="PMNT_RECEIVED" effectiveDate="2006-04-25
12:56:54.292" amount="820.97" currencyUomId="USD" actualCurrencyAmount="543.23"
actualCurrencyUomId="EUR"/>
<PaymentApplication paymentApplicationId="demo11000" paymentId="demo10001"
invoiceId="demo11001" amountApplied="543.23"/>
