The depedencies i mentioned above are quite troubeling. Right now nothing works and getting it to work is very complicated because of the mentioned dependencies.
I tried to only Import DemoGeneralChartOfAccounts.xml by deleteng one by one the other Files causing errors on ant load-demo. Problem is: Once the accounting module stopped trhowing errors, the HR and E-Commerce module started. My conclusion is that this demo data is way too US-Specific and too extensive for adjusting it to this region and law. I get that for the CoA to work i have to change the mappings in DemoGlSetupData.xml. What i don't get is why all the Tax information, HR stuff, Ecommerce and so on have to be present as well. What i'm trying to do now is building up from the minimal configuration i get when using "ant load-extseed && ant create-admin-account...". BUT: How / Where can i import the CoA i've created for demo data? ant load-file wont let me do it. (does not exist in project "OFBiz Main Build") The Question is how do in Import a CoA in the same Format as the Demo one but not with load-demo On 5 February 2014 18:26, Anil Patel <[email protected]> wrote: > 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 > >>>>> > >>> > >> > >> > >
