So. I discovered that there are many accounts in the CoA which do not specify a GL Account Type. Why is this? Which rules will help me determine wheter to set a type or not and which type to set?
On 5 February 2014 10:55, Adrian Stern <[email protected]> wrote: > Hi Anil > > Thanks for your response. Since English is not my mother tongue, it is > hard for me to read between the lines. So i have to come back to you from > time to time with some questions about your statements. > > First: You say i can safely ignore GL Account Class. I assume this is > because it is not used for accounting but for reporting instead. True? > But do you also imply we will have to set GL Account Type properly? > > Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice > Item Types to Gl Account Ids mappings? I would have done it since > everything there uses the wrong codes. > > I think for now we should focus on Step 1 and 2. But out of Couriosity, > where would i configure Step 3? > > For our CoA we've created a Spreadsheet which we will exprot to a CSV and > then generate the GL Xml from it. I can share the generation script with > you if you'd like. You can find the Spreadsheet in the link below. > > We've mainly focused on the GL Account Classes... Too bad we have to start > over on the Types. > > > https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing > > Regards, Adrian > > > On 5 February 2014 04:33, Anil Patel <[email protected]> wrote: > >> Adrian, >> >> Regarding questions in your first email. >> >> You can safely ignore GL Account Class for automatic posting of business >> transactions to general ledger. >> >> I see you got basic steps figured >> >> Step 1) Define Chart of Account. For reference use >> DemoGeneralChartOfAccounts.xml >> Step 2) Associate GLAccounts to Organization. For reference use >> DemoGlSetupData.xml >> Step 3) Setup data for automatic GL posting of business transactions e.g >> Invoice , Payment , Inventory issuances etc. >> >> Looks like you have figured first two steps. I can help you setup data >> for automatic posting. Data setup between line # 294 to line #315 is good >> example. If you can read code, start with "getGlAccountFromAccountType" at >> line #446 in GeneralLedgerServices.xml. >> >> I can give you specific help for real specific question, for e.g setup >> data for automatic posting of Sales Invoice to GL. I will need access to >> your CoA as well. >> >> Thanks and Regards >> Anil Patel >> COO >> Hotwax Media Inc >> http://www.hotwaxmedia.com/ >> ApacheCon US 2013 Gold Sponsor >> http://na.apachecon.com/sponsors/ >> >> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[email protected]> wrote: >> >> > For know im happy with the demo data. What i have been missing is an >> import >> > option for installing only my own CoA. Well i did not search that deeply >> > since it is not important for know. (Maybe ant load-file) >> > >> > Would be happy for an answer to my previous email. >> > >> > >> > On 4 February 2014 15:05, Pierre Smits <[email protected]> wrote: >> > >> >> Adrian, >> >> >> >> Other good point of reference are the books regarding the Universal >> Data >> >> Model by Len Silverston. >> >> >> >> Regards, >> >> >> >> Pierre Smits >> >> >> >> *ORRTIZ.COM <http://ORRTIZ.COM>* >> >> Services & Solutions for Cloud- >> >> Based Manufacturing, Professional >> >> Services and Retail & Trade >> >> http://www.orrtiz.com >> >> >> >> >
