Adrian, I don't mind, please ask as many questions :) You are right glaccount class is used lot more in reporting. For automatic posting glaccounttype is your best friend.
The data setup process is good amount of work, if you are doing it for first time. Depending on how much time and help you got, you can adjust your speed. To learn basics, I suggest you start with some thing very simple e.g Sales Invoice. Your accountant can give you sample invoice and gl transactions that should be created for the invoice. Go create your sample invoice in OOTB accounting application. For each invoice line item, set glaccountid. When invoice is posted you will see that accounting transactions are created in gl. Now review the invoice item type on each item in invoice you just created in ofbiz, you now have invoiceitemtype to glaccountId mapping for select invoiceItemTypes. I am sure you know that OFBiz is superset of all you will ever need, skill is how to safely not use what you don't need :) Similarly get all possible sample invoices from your accountant, follow the same exercise. Soon you will have list of invoiceItemTypes your business uses. You can then follow same process for all invoice types and payments and shipments. To enjoy the process I recommend you should get comfortable with editing XML file in text editor. Learn to steps to upload data into Ofbiz using webtools application. Please know that I have not yet looked at the csv you shared. I will see it later today. Anil K Patel Sent from my iPad > On Feb 5, 2014, at 4:56 AM, 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 >> >>
