svn commit: r472343 - in /incubator/ofbiz/trunk/applica
Locked
 
|
Author: sichen
Date: Tue Nov 7 16:05:16 2006 New Revision: 472343 URL: http://svn.apache.org/viewvc?view=rev&rev=472343 Log: new gl account types for f/x gain loss and for writeoffs. also fixed a bug in classifying uninvoiced item receipts which might cause it to show up on cash flow statements Modified: incubator/ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml incubator/ofbiz/trunk/applications/accounting/data/DemoGeneralChartOfAccounts.xml Modified: incubator/ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml URL: http://svn.apache.org/viewvc/incubator/ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml?view=diff&rev=472343&r1=472342&r2=472343 ============================================================================== --- incubator/ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml (original) +++ incubator/ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml Tue Nov 7 16:05:16 2006 @@ -190,11 +190,24 @@ <GlAccountType description="Uninvoiced Shipment Receipts" glAccountTypeId="UNINVOICED_SHIP_RCPT" hasTable="N" parentTypeId="CURRENT_LIABILITY"/> <GlAccountType description="Purchase Price Variance" glAccountTypeId="PURCHASE_PRICE_VAR" hasTable="N" parentTypeId="EXPENSE"/> <GlAccountType description="Prepaid Expenses" glAccountTypeId="PREPAID_EXPENSES" hasTable="N" parentTypeId="CURRENT_ASSET"/> + + <GlAccountType description="Interest Income Receivables" glAccountTypeId="INTRSTINC_RECEIVABLE" hasTable="N" parentTypeId="ACCOUNTS_RECEIVABLE"/> + <GlAccountType description="Prepaid Expenses" glAccountTypeId="PREPAID_EXPENSES" hasTable="N" parentTypeId="CURRENT_ASSET"/> <GlAccountType description="Receivable from Inventory Transferred Out" glAccountTypeId="INVENTORY_XFER_OUT" hasTable="N" parentTypeId="CURRENT_ASSET"/> <GlAccountType description="Payable from Inventory Transferred In" glAccountTypeId="INVENTORY_XFER_IN" hasTable="N" parentTypeId="CURRENT_LIABILITY"/> + <GlAccountType description="Commissions Payables" glAccountTypeId="COMMISSIONS_PAYABLE" hasTable="N" parentTypeId="CURRENT_LIABILITY"/> + <GlAccountType description="Write Off" glAccountTypeId="WRITEOFF" hasTable="N" parentTypeId="OTHER_EXPENSE"/> + <GlAccountType description="Accounts Receivables Write Off" glAccountTypeId="ACCTRECV_WRITEOFF" hasTable="N" parentTypeId="WRITEOFF"/> + <GlAccountType description="Accounts Payables Write Off" glAccountTypeId="ACCTPAY_WRITEOFF" hasTable="N" parentTypeId="WRITEOFF"/> + <GlAccountType description="Commissions Payables Write Off" glAccountTypeId="COMMISSIONS_WRITEOFF" hasTable="N" parentTypeId="WRITEOFF"/> + <GlAccountType description="Interest Income Write Off" glAccountTypeId="INTRSTINC_WRITEOFF" hasTable="N" parentTypeId="WRITEOFF"/> + <GlAccountType description="Foreign Exchange Gain/Loss" glAccountTypeId="FX_GAIN_LOSS_ACCT" hasTable="N" parentTypeId="OTHER_EXPENSE"/> + <GlAccountType description="Foreign Exchange Gain" glAccountTypeId="FX_GAIN_ACCOUNT" hasTable="N" parentTypeId="FX_GAIN_LOSS_ACCT"/> + <GlAccountType description="Foreign Exchange Loss" glAccountTypeId="FX_LOSS_ACCOUNT" hasTable="N" parentTypeId="FX_GAIN_LOSS_ACCT"/> + <GlResourceType description="Money" glResourceTypeId="MONEY"/> <GlResourceType description="Raw Materials" glResourceTypeId="RAW_MATERIALS"/> <GlResourceType description="Labor" glResourceTypeId="LABOR"/> Modified: incubator/ofbiz/trunk/applications/accounting/data/DemoGeneralChartOfAccounts.xml URL: http://svn.apache.org/viewvc/incubator/ofbiz/trunk/applications/accounting/data/DemoGeneralChartOfAccounts.xml?view=diff&rev=472343&r1=472342&r2=472343 ============================================================================== --- incubator/ofbiz/trunk/applications/accounting/data/DemoGeneralChartOfAccounts.xml (original) +++ incubator/ofbiz/trunk/applications/accounting/data/DemoGeneralChartOfAccounts.xml Tue Nov 7 16:05:16 2006 @@ -77,6 +77,9 @@ <GlAccount parentGlAccountId="121000" glAccountId="121200" accountCode="121200" glAccountClassId="CURRENT_ASSET" glAccountTypeId="ACCOUNTS_RECEIVABLE" glResourceTypeId="MONEY" accountName="ACCOUNTS RECEIVABLE - NON-SUFFICIENT FUNDS RETURNED CHECKS" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="121000" glAccountId="121800" accountCode="121800" + glAccountClassId="CURRENT_ASSET" glAccountTypeId="INTRSTINC_RECEIVABLE" glResourceTypeId="MONEY" + accountName="ACCOUNTS RECEIVABLE TRADE - INTEREST RECEIVABLE" description="" postedBalance="0.0"/> <GlAccount parentGlAccountId="121000" glAccountId="121900" accountCode="121900" glAccountClassId="CURRENT_ASSET" glAccountTypeId="ACCOUNTS_RECEIVABLE" glResourceTypeId="MONEY" accountName="ACCOUNTS RECEIVABLE TRADE - ALLOWANCE FOR BAD DEBT" description="" postedBalance="0.0"/> @@ -306,8 +309,9 @@ <GlAccount parentGlAccountId="213000" glAccountId="213400" accountCode="213400" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="CURRENT_LIABILITY" glResourceTypeId="MONEY" accountName="MAIL ORDER DEPOSITS" description="" postedBalance="0.0"/> + <!-- this must not be a current liability or it will show up in cashflow statement incorrectly --> <GlAccount parentGlAccountId="210000" glAccountId="214000" accountCode="214000" - glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="CURRENT_LIABILITY" glResourceTypeId="MONEY" + glAccountClassId="LIABILITY" glAccountTypeId="" glResourceTypeId="MONEY" accountName="UNINVOICED ITEM RECEIPTS" description="" postedBalance="0.0"/> <GlAccount parentGlAccountId="210000" glAccountId="215000" accountCode="215000" @@ -320,6 +324,9 @@ <GlAccount parentGlAccountId="220000" glAccountId="221000" accountCode="221000" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="CURRENT_LIABILITY" glResourceTypeId="MONEY" accountName="ACCRUED PAYROLL" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="220000" glAccountId="222000" accountCode="222000" + glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="COMMISSIONS_PAYABLE" glResourceTypeId="MONEY" + accountName="ACCRUED COMMISSIONS DUE" description="" postedBalance="0.0"/> <GlAccount parentGlAccountId="220000" glAccountId="222000" accountCode="222000" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="CURRENT_LIABILITY" glResourceTypeId="MONEY" @@ -774,7 +781,36 @@ <GlAccount parentGlAccountId="516000" glAccountId="516100" accountCode="516100" glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="" glResourceTypeId="MONEY" accountName="PURCHASE ORDER ADJUSTMENTS" description="" postedBalance="0.0"/> - + +<!-- Non-cash expenses involved in write offs. Writeoffs of accounts payable and commissions invoices are not expenses, +but they are grouped here for convenience purposes --> + <GlAccount parentGlAccountId="510000" glAccountId="517000" accountCode="517000" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="WRITEOFF" glResourceTypeId="MONEY" + accountName="NON CASH WRITE OFF" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="517000" glAccountId="517100" accountCode="517100" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="ACCTRECV_WRITEOFF" glResourceTypeId="MONEY" + accountName="ACCOUNTS RECEIVABLE WRITE OFF" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="517000" glAccountId="517200" accountCode="517200" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="ACCTPAY_WRITEOFF" glResourceTypeId="MONEY" + accountName="ACCOUNTS PAYABLE WRITE OFF" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="517000" glAccountId="517300" accountCode="517300" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="COMMISSIONS_WRITEOFF" glResourceTypeId="MONEY" + accountName="COMMISSIONS PAYABLE WRITE OFF" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="517000" glAccountId="517400" accountCode="517400" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="INTRSTINC_WRITEOFF" glResourceTypeId="MONEY" + accountName="INTEREST INCOME WRITE OFF" description="" postedBalance="0.0"/> + +<!-- foreign exchange gain and loss expenses --> + <GlAccount parentGlAccountId="510000" glAccountId="518000" accountCode="518000" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="FX_GAIN_LOSS_ACCT" glResourceTypeId="MONEY" + accountName="FOREIGN EXCHANGE GAIN/LOSS" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="518000" glAccountId="518100" accountCode="518100" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="FX_GAIN_ACCOUNT" glResourceTypeId="MONEY" + accountName="FOREIGN EXCHANGE GAIN" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="518000" glAccountId="518200" accountCode="518200" + glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="FX_LOSS_ACCOUNT" glResourceTypeId="MONEY" + accountName="FOREIGN EXCHANGE LOSS" description="" postedBalance="0.0"/> + <GlAccount parentGlAccountId="510000" glAccountId="519000" accountCode="519000" glAccountClassId="NON_CASH_EXPENSE" glAccountTypeId="" glResourceTypeId="MONEY" accountName="INVENTORY ADJUSTMENT" description="" postedBalance="0.0"/> |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |