i agree with Jacopo. All the accountants I know use numbering systems. what is really needed to speed up integration is a cross reference table from the numbers they use to the ones in ofbiz. I know the argument is that you should set up the GL with the accountant before, however what if you change accountants and there inhouse system has different numbers. Using this cross reference table lets ofbiz export to a myriad of other systems formats.
just my two sense(intentional mispelling) :D Jacopo Cappellato sent the following on 6/28/2009 7:51 AM: > Are we sure that this is the best way to go? Usually chart of accounts > are prepared using special conventions for account id (i.e. > "accountCode"); see for example how the demo data is organized. > I think it is important to keep that order; also, most of the time, > accountants already know the account codes and use them instead of the > descriptions. > > Thoughts? > > Jacopo > > On Jun 28, 2009, at 2:37 AM, [email protected] wrote: > >> Author: ashish >> Date: Sun Jun 28 08:37:58 2009 >> New Revision: 789074 >> >> URL: http://svn.apache.org/viewvc?rev=789074&view=rev >> Log: >> Trying to make Accountant life easy. >> Its easy to find general ledger from alphabet instead of number. >> >> Modified: >> ofbiz/trunk/applications/accounting/widget/GlobalGlAccountsForms.xml >> >> Modified: >> ofbiz/trunk/applications/accounting/widget/GlobalGlAccountsForms.xml >> URL: >> http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/widget/GlobalGlAccountsForms.xml?rev=789074&r1=789073&r2=789074&view=diff >> >> ============================================================================== >> >> --- >> ofbiz/trunk/applications/accounting/widget/GlobalGlAccountsForms.xml >> (original) >> +++ >> ofbiz/trunk/applications/accounting/widget/GlobalGlAccountsForms.xml >> Sun Jun 28 08:37:58 2009 >> @@ -132,7 +132,8 @@ >> </field> >> <field name="parentGlAccountId"> >> <drop-down allow-empty="true"> >> - <entity-options key-field-name="glAccountId" >> entity-name="GlAccount" description="[${glAccountId}] >> ${accountName}-${accountCode}"> >> + <entity-options key-field-name="glAccountId" >> entity-name="GlAccount" description="${accountName} >> [${glAccountId}]-${accountCode}"> >> + <entity-order-by field-name="accountName"/> >> <entity-order-by field-name="glAccountId"/> >> </entity-options> >> </drop-down> >> >> > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
