Others please chime in if I am wrong, but... Pretty sure if you omit BILL_TO_CUSTOMER -or- BILL_FROM_VENDOR things will not work. There are at least 25 references in the java code that use these roles.
ofbiz.1104# find . -type f -name \*\.java | xargs egrep '(BILL_TO_CUSTOMER|BILL_FROM_VENDOR)' | wc -l 25 On Thu, Feb 6, 2014 at 8:33 AM, Adrian Stern <[email protected]> wrote: > Hi Anil > > I think i've made some progress today. But it seems i'm far from done. > > I've created two more files with import data. One with a basic > organization and one based on GlSetupData.xml which so far only links my > organization to Accounting and adds every available account to this > organization. The export function was kinda useful. > > I want to end this day with some questions, but fist a status update on > what works now: > 1. Import of Global General ledger (GL still incomplete when it comes to > gl account type) > 2. Import of basic organization (xml file attached) > 3. Import of gl setup data with combany and accounts > > So to the questions: > 1. Which parts of gl setup data xml are really necessary for me to > configure? > - Invoice Item Types to Gl Account Ids mappings? What are they used for? > - PaymentMethodType mappings? I actually guess those are basically the > same as InvoiceItemType > - Default mapping between account types and account ids? What are those > used for? > - Are the mappings for payments not to be changed? All of them? > - What does GL Reconciliation mean in this context. I can't make much > sense out of the translations. > > 2. In Organization Data: > - As you can see i deleted the roles BILL_FROM_VENDOR & > BILL_TO_CUSTOMER from my company. It seems only Internal Organization is > needed for accounting. Where can i the roles available and what they do? > - I also deleted Sub Organizations, Devisions, Departments, Teams and > Members. Will they be necessary for accounting at some point? > > I know these are a lot of questions and i don't expect you to answer each > one of them. I hope you can push me in a direction where i will soon be > able to try out some invoices like: > - Make a bill > - Pay a bill > - Get billed > - Get payed > > I believe this will be a good point for expanding to more functionalities. > Also as the configuration goes, everything is inside the import files. So > what you see is what i got. > What should be my next steps? > > Regards, Adrian > > > > > On 6 February 2014 10:29, Adrian Stern <[email protected]> wrote: > >> Got it. Its just that "Webtools" can't be selected from the menu and so i >> did not find it. Import was a success as it seems. >> >> >> On 6 February 2014 10:19, Adrian Stern <[email protected]> wrote: >> >>> 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 >>>> >>>>> >>>> >>> >>>> >> >>>> >> >>>> >>>> >>> >> >
