not work. There are at least 25 references in the java code that use these
ofbiz.1104# find . -type f -name \*\.java | xargs egrep
> 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 <
[hidden email]> 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 <
[hidden email]> 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 <
[hidden email]> 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 <
[hidden email]> 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 <
[hidden email]> 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 <
[hidden email]>
>>>> 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 <
[hidden email]>
>>>> 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 <
[hidden email]>
>>>> 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 <
[hidden email]
>>>> >
>>>> >>> 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 <
[hidden email]>
>>>> >>> 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 <
[hidden email]
>>>> >
>>>> >>> 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>>>> >>>>>
>>>> >>>
>>>> >>
>>>> >>
>>>>
>>>>
>>>
>>
>
Locked
gl_setup_data.xml (31K) Download Attachment