Thanks Anil So i will try to build our needs within the GUI and inspect the output. As for the CSV, we included a english translation (google translate) so its easier for you to guess what a spesific account is used for.
Furthermore i will ignore the GL Account Classes for the time beeing and try to set a GL Account Type on each account. On 5 February 2014 14:45, Anil K Patel <[email protected]> wrote: > It's recommended that all glAccounts have type. It's safe to say with > some level of confidence, that accounts with no glaccountType don't get > automatic posting. > > For now I say, ignore them :) > > Anil K Patel > Sent from my iPad > > > On Feb 5, 2014, at 7:46 AM, Adrian Stern <[email protected]> wrote: > > > > 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 > >> >
