Adrian, This document is good resource, https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
There is lot of information on it. 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 5, 2014, at 12:17 PM, Adrian Stern <[email protected]> wrote: > 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 >>>>> >>> >> >>
