[OFBiz] Dev - Modified GeneralChartOfAccounts.xml file

[Adrian Crum]

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