I played around with ofbiz a little and i am able to import our accounts together with the ones already present in demo data. When disposing of the demo ones i get some import errors because there are references to accounts no longer present. Also we had to switch from a CSV to a TSV because our account names actually contain commas.
This is just a status update. Dependencies to these files: DemoGlSetupData.xml DemoFinAccountData.xml DemoTaxAuthority.xml DemoAcctgTransactionData.xml DemoPaymentsInvoices.xml DemoTaxAuthority.xml DemoOrderPeopleData.xml DemoOrderTestData.xml DemoMarketing.xml Next we will try to switch the old account codes with our own new ones. This will hopefully get us started. As of now we are unsure if we just do it inside the files mentioned above or with excessive trial end error with use-cases. Regards, Adrian On 5 February 2014 15:30, Adrian Stern <[email protected]> wrote: > 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 >> >> >> > >
