[OFBiz] Dev - Modified GeneralChartOfAccounts.xml file
David Jones
jonesde at ofbiz.org
Fri Aug 6 18:46:58 EDT 2004
I'm familiar with XBRL, but I didn't know they had any sort of a
recommended chart of accounts. I spent a minute looking at that page
and I still don't see anything like a chart of account there. Do you
have a more specific link?
You are correct that the ABA chart of accounts is industry specific. We
would like to have a good generic chart of accounts in OFBiz, so this
is just a starting point. In general we also want to have some sample
organizations that represent smaller businesses in specific industries
and that can be copied for their current organization, or divisions or
whatever in the organization. So, the general or global chart of
accounts will be a large superset of what most companies will use, but
can hopefully make it easier for each company to get their chart setup
initially.
-David
On Aug 6, 2004, at 4:35 PM, Adrian Crum wrote:
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/dev/attachments/20040806/5d618f17/smime.bin
More information about the Dev
mailing list