[OFBiz] Dev - Modified GeneralChartOfAccounts.xml file

[Adrian Crum]

Thanks - that looks like a chart of accounts for a specific industry.

Try looking at this:

http://www.oasis-open.org/cover/xbrl.html


David Jones wrote:

> 
> This was the result of a few Google searches to find some sort of  
> standard chart of accounts, and it is from the American Booksellers  
> Association. You can see more at:
> 
> http://www.bookweb.org/misc/member/scoa.html
> 
> -David
> 
> 
> On Aug 6, 2004, at 4:25 PM, Adrian Crum wrote:
> 
>> Our accountant is familiar with AICPA. What does ABA stand for?
>>
>> David Jones wrote:
>>
>>> Adrian,
>>> That would be great. I guess what we need is a high level review of  
>>> the  chart of accounts as we have it now, but there are some  
>>> particular  things to look at. For example, there are a number of  
>>> areas where  contra-asset type accounts exist and I'm not sure if 
>>> the   glAccountClassId is appropriately set for these. For example 
>>> the   following accounts: 191900, 249000, 311000, 321000 (and  
>>> sub-accounts),  334000 & 335000, certain other DISTRIBUTION 
>>> accounts,  all of the 500000  series (COGS) accounts, 607900, etc.
>>> So, in general it would be nice to have a good review of the whole 
>>> to   see how much everything makes sense, but if you have a limited 
>>> time  to  look at it (which I'm sure you do) then the items listed 
>>> above  are the  best to look at.
>>> Thanks for your help.
>>> -David
>>> On Aug 6, 2004, at 1:45 PM, Adrian Crum wrote:
>>>
>>>> I can help. What are the things you're not sure about?
>>>>
>>>>
>>>> David Jones wrote:
>>>>
>>>>> Adrian,
>>>>> Of course we don't do it that way, that's not what I was 
>>>>> referring   to.  For verification, you should take a look at the 
>>>>> entity   definitions or  even this seed data file that we are 
>>>>> referring to.   Certain accounts  were originally put in that way 
>>>>> by our tech  writer  who did all of the  data entry for these 354 
>>>>> accounts  because he  wasn't sure what to do  with them, and I was 
>>>>> in another  country.
>>>>> I anyone has any feedback on the chart of accounts, or access to 
>>>>> an    accountant who could spend some time reviewing it that would 
>>>>> be   great.  It is based on the ABA standard chart of accounts, 
>>>>> but  there  are still  some issues or things that we aren't totally 
>>>>> sure  about.
>>>>> -David
>>>>> On Aug 6, 2004, at 9:52 AM, Adrian Crum wrote:
>>>>>
>>>>>> David,
>>>>>>
>>>>>> GL account numbers should NOT be formatted specifically for 
>>>>>> Income   or  Expense. GL account 12345-123 could be Income, 
>>>>>> Expense, Fixed   Asset,  etc - depending upon the accountant. A 
>>>>>> field in the  account  determines  what type of account it is.
>>>>>>
>>>>>> -Adrian
>>>>>>
>>>>>>
>>>>>> David Jones wrote:
>>>>>>
>>>>>>> Brett,
>>>>>>> The account numbers in the "-XXXXXX-" form are accounts that 
>>>>>>> are     reversed, ie INCOME instead of EXPENSE, etc. I started 
>>>>>>> over  with  the   file and went through and fixed all of these 
>>>>>>> (though  we still  need an   accountant to review this at some 
>>>>>>> point), and  I did the   search/replace  for all of the invalid  
>>>>>>> glAccountTypeIds and added  the  missing  glAccountClassId, etc  
>>>>>>> after looking at the changes  you made  to get a  head start...
>>>>>>> Anyway, it's all cleaned up now and imports fine. The changes 
>>>>>>> are   in   CVS.
>>>>>>> -David
>>>>>>> On Aug 6, 2004, at 6:58 AM, Brett wrote:
>>>>>>>
>>>>>>>> David,
>>>>>>>>
>>>>>>>> I had to modify the GeneralChartOfAccounts.xml to import the  
>>>>>>>> data   into  the
>>>>>>>> accounting module.  There were some incorrect account types.  
>>>>>>>> I   also   found
>>>>>>>> some accound IDs formatted as "-XXXXXX-".  This format didn't  seem
>>>>>>>> consistent with the other IDs so I removed the "-" characters.
>>>>>>>>
>>>>>>>> Also, there were some accounts at the end of the file that I    
>>>>>>>> commented  out
>>>>>>>> because of missing glAccountClassId or glResourceTypeId.
>>>>>>>>
>>>>>>>> Let me know if I missed something.
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>>
>>>>>>>>
>>>>>>>> Brett
>>>>>>>> <GeneralChartOfAccounts.xml>------------------------------------- 
>>>>>>>> -- -- -- --------------------------
>>>>>>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
>>>>>>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------- 
>>>>>> -- 
>>>>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
>>>>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
>>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
For additional commands, e-mail: dev-help at ofbiz.dev.java.net