You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Adrian Stern <ar...@gmail.com> on 2014/01/28 20:57:13 UTC
Implementing Chart of Accounts for Switzerland (Or any country for
that matter)
Hello
I'm looking for Information about implementing a completely new chart of
accounts. I think i actually found everything important, but i still want
to ask about some random input and a share of your experiences.
So. As i understand the first Step is to create the global chart (tree) as
the example "data/DemoGeneralChartOfAccounts.xml" states. This will result
in the entries in
Accounting -> Global GL Settings
And with that, i can configure the Organization GL Settings which are
specific to my needs.
1. Could there be any dependencies one has to take care of when using a
different chart of accounts?
2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part of
ofbiz, should i keep it in the hot-deploy folder? How do you organize?
3. How do i tell ofbiz to use not the Demo tree but my own, after creating
it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml but
i bet there is a Global setting somewhere. Well. Probably just
ofbiz-component.xml and SetupEvents.xml...
Regards, Adrian
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Pierre Smits <pi...@gmail.com>.
Hi Adrian,
If you don't want to use the demo data in your set up you have to ensure
that it not loaded when you are initiating your setup.
When you do an ./ant load it will by default load the demo data as well.
Look with ./ant -p what options are available.
Regards,
Pierre Smits
*ORRTIZ.COM <http://ORRTIZ.COM>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com
On Tue, Jan 28, 2014 at 8:57 PM, Adrian Stern <ar...@gmail.com> wrote:
> Hello
>
> I'm looking for Information about implementing a completely new chart of
> accounts. I think i actually found everything important, but i still want
> to ask about some random input and a share of your experiences.
>
> So. As i understand the first Step is to create the global chart (tree) as
> the example "data/DemoGeneralChartOfAccounts.xml" states. This will result
> in the entries in
>
> Accounting -> Global GL Settings
>
> And with that, i can configure the Organization GL Settings which are
> specific to my needs.
>
> 1. Could there be any dependencies one has to take care of when using a
> different chart of accounts?
>
> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part of
> ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>
> 3. How do i tell ofbiz to use not the Demo tree but my own, after creating
> it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml but
> i bet there is a Global setting somewhere. Well. Probably just
> ofbiz-component.xml and SetupEvents.xml...
>
> Regards, Adrian
>
Re: Implementing Chart of Accounts for Switzerland (Or any country for that matter)
Posted by Anil Patel <an...@hotwaxmedia.com>.
I have not run any tests lately, from what I know, Demo data for CoA should work fine with Demo store data used in eCommerce store.
Depending on the business size, you may or may not need the big CoA comes with demo data.
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:36 PM, Mike <mz...@gmail.com> wrote:
> Hey Anil. Regarding DemoGeneralChartOfAccounts.xml, how GOOD is this CoA
> from a deployment perspective (in the US). It seemed to be pretty
> comprehensive, so I used it almost in it's entirety (stripped out some
> stuff).
>
> Also, does the demo currently properly post (via the default
> GeneralLedgerServices.xml),
> or are there issues with the handling of a demo ecommerce transaction?
>
>
> On Tue, Feb 4, 2014 at 7:33 PM, Anil Patel <an...@hotwaxmedia.com>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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
>>>>
>>
>>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Mike <mz...@gmail.com>.
Hey Anil. Regarding DemoGeneralChartOfAccounts.xml, how GOOD is this CoA
from a deployment perspective (in the US). It seemed to be pretty
comprehensive, so I used it almost in it's entirety (stripped out some
stuff).
Also, does the demo currently properly post (via the default
GeneralLedgerServices.xml),
or are there issues with the handling of a demo ecommerce transaction?
On Tue, Feb 4, 2014 at 7:33 PM, Anil Patel <an...@hotwaxmedia.com>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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
> >>
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country for that matter)
Posted by Anil K Patel <an...@hotwaxmedia.com>.
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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
>>
>>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Mike <mz...@gmail.com>.
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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>>>> 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 <ar...@gmail.com>
>>>> 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 <ar...@gmail.com>
>>>> 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 <anil.patel@hotwaxmedia.com
>>>> >
>>>> >>> 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 <ar...@gmail.com>
>>>> >>> 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 <pierre.smits@gmail.com
>>>> >
>>>> >>> 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
>>>> >>>>>
>>>> >>>
>>>> >>
>>>> >>
>>>>
>>>>
>>>
>>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>>> 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 <ar...@gmail.com>
>>> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>>> >>> 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 <ar...@gmail.com>
>>> >>> 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 <pi...@gmail.com>
>>> >>> 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
>>> >>>>>
>>> >>>
>>> >>
>>> >>
>>>
>>>
>>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>> >>> 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 <ar...@gmail.com>
>> >>> 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 <pi...@gmail.com>
>> >>> 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
>> >>>>>
>> >>>
>> >>
>> >>
>>
>>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
> >>> 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 <ar...@gmail.com>
> >>> 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 <pi...@gmail.com>
> >>> 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
> >>>>>
> >>>
> >>
> >>
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country for that matter)
Posted by Anil Patel <an...@hotwaxmedia.com>.
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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>>> 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 <ar...@gmail.com>
>>> 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 <pi...@gmail.com>
>>> 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
>>>>>
>>>
>>
>>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
>> 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 <ar...@gmail.com>
>> 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 <pi...@gmail.com>
>> 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
>> >>
>>
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com>
> 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 <ar...@gmail.com> 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 <pi...@gmail.com>
> 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
> >>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country for that matter)
Posted by Anil K Patel <an...@hotwaxmedia.com>.
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 <ar...@gmail.com> 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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
>>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <ar...@gmail.com> 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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
>> >>
>>
>>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <an...@hotwaxmedia.com> 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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
> >>
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country for that matter)
Posted by Anil Patel <an...@hotwaxmedia.com>.
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 <ar...@gmail.com> 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 <pi...@gmail.com> 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
>>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
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 <pi...@gmail.com> 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
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Pierre Smits <pi...@gmail.com>.
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
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
Hi Jacques
We're currently working with this tree. But as it seems the paths are not
absolute.
glAccountId=300000 -> Equity (Equity)is
glAccountId=310000 -> OwnersEquity (Equity - OwnersEquity)
glAccountId=311000 -> ReturnOfCapital (Distribution - ReturnOfCapital)
While the first two are in the same branch, ReturnOfCapital is in the
Branch of Distribution.
This tells us that it is not important to stay in one branch but instead it
is sometimes necessary to switch branches like in the example above.
Is there some policy for the usage of this classes? And also ist there a
similiar list for the glAccountTypeId's?
On 4 February 2014 13:31, Jacques Le Roux <ja...@les7arts.com>wrote:
> This might help http://markmail.org/message/uq7w4snax3w7gyrk
>
> Jacques
>
> On Tuesday, February 04, 2014 1:01 PM, archdove@gmail.com wrote
> > Hi Igor
> >
> > Thanks for your links. The italian chart did not help much. It differs
> too
> > much and i'm not able to find clear matches (because of the langage
> barrier
> > probably). I could find a relevant download from XBRL-CH.ch however this
> > one is from 2011 and there was a revision in 2013.
> > I would say we can solve about 1/4 to 1/3 with the files available so far
> > whith matching it against the demo chart.
> >
> > What i'm looking for know is an explanation about what glAccountType and
> > glAccountClass actually do -> what they are used for.
> > Also there are some other types which are not glAccountType or Class
> which
> > would match by description. Like:
> GlResourceType.description.RAW_MATERIALS
> > which would be what we're looking for but it is not an account type but a
> > Resource Type.
> >
> > Looks like we have to build our own from scratch...
> >
> >
> >
> > On 4 February 2014 11:16, Igor Gallingani <ig...@gmail.com>
> wrote:
> >
> >> I forgot
> >>
> >> glAccountType in italian is translated as "causale contabile" ==
> >> "???kausalen Konten??? or ???Buchhalter ????" (google )
> >> glAccountClass = the class of the account
> >>
> >>
> >> 2014-02-04 Igor Gallingani <ig...@gmail.com>:
> >>
> >>> I hope it can be useful. This chart of accounts is based on
> >>> http://www2.xbrl.org//it/.
> >>> You can compare it with http://www.xbrl.de/.
> >>>
> >>>
> >>> 2014-02-04 Adrian Stern <ar...@gmail.com>:
> >>>
> >>> I've not come much further on this topic. I started creating my own CoA
> >> but
> >>>> having problems filling out the fields glAccountClassId and
> >>>> glAccountTypeId.
> >>>> I did find some explanation about those fields in
> >>>> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on
> the
> >>>> right track.
> >>>>
> >>>> Are there any German speaking people in this mailing list? Or someone
> who
> >>>> has done this before?
> >>>> This is my very first task in ofbiz... so i'm kind of lost.
> >>>>
> >>>> I've found the translations of this classes and types
> >>>> in config/AccountingEntityLabels.xml but i lack some explaining...
> >>>>
> >>>> Are there any accounts that absolutley have to be used or are all of
> them
> >>>> more or less optional and ofbiz knows of its own what to do whith the
> one
> >>>> available?
> >>>>
> >>>> Regards,
> >>>> Adrian
> >>>>
> >>>>
> >>>> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
> >>>>
> >>>>> Hello
> >>>>>
> >>>>> I'm looking for Information about implementing a completely new
> chart of
> >>>>> accounts. I think i actually found everything important, but i still
> want
> >>>>> to ask about some random input and a share of your experiences.
> >>>>>
> >>>>> So. As i understand the first Step is to create the global chart
> (tree) as
> >>>>> the example "data/DemoGeneralChartOfAccounts.xml" states. This will
> result
> >>>>> in the entries in
> >>>>>
> >>>>> Accounting -> Global GL Settings
> >>>>>
> >>>>> And with that, i can configure the Organization GL Settings which are
> >>>>> specific to my needs.
> >>>>>
> >>>>> 1. Could there be any dependencies one has to take care of when
> using a
> >>>>> different chart of accounts?
> >>>>>
> >>>>> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not
> part of
> >>>>> ofbiz, should i keep it in the hot-deploy folder? How do you
> organize?
> >>>>>
> >>>>> 3. How do i tell ofbiz to use not the Demo tree but my own, after
> creating
> >>>>> it? Grep reveals a number of files using
> DemoGeneralChartOfAccounts.xml but
> >>>>> i bet there is a Global setting somewhere. Well. Probably just
> >>>>> ofbiz-component.xml and SetupEvents.xml...
> >>>>>
> >>>>> Regards, Adrian
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Jacques Le Roux <ja...@les7arts.com>.
This might help http://markmail.org/message/uq7w4snax3w7gyrk
Jacques
On Tuesday, February 04, 2014 1:01 PM, archdove@gmail.com wrote
> Hi Igor
>
> Thanks for your links. The italian chart did not help much. It differs too
> much and i'm not able to find clear matches (because of the langage barrier
> probably). I could find a relevant download from XBRL-CH.ch however this
> one is from 2011 and there was a revision in 2013.
> I would say we can solve about 1/4 to 1/3 with the files available so far
> whith matching it against the demo chart.
>
> What i'm looking for know is an explanation about what glAccountType and
> glAccountClass actually do -> what they are used for.
> Also there are some other types which are not glAccountType or Class which
> would match by description. Like: GlResourceType.description.RAW_MATERIALS
> which would be what we're looking for but it is not an account type but a
> Resource Type.
>
> Looks like we have to build our own from scratch...
>
>
>
> On 4 February 2014 11:16, Igor Gallingani <ig...@gmail.com> wrote:
>
>> I forgot
>>
>> glAccountType in italian is translated as "causale contabile" ==
>> "???kausalen Konten??? or ???Buchhalter ????" (google )
>> glAccountClass = the class of the account
>>
>>
>> 2014-02-04 Igor Gallingani <ig...@gmail.com>:
>>
>>> I hope it can be useful. This chart of accounts is based on
>>> http://www2.xbrl.org//it/.
>>> You can compare it with http://www.xbrl.de/.
>>>
>>>
>>> 2014-02-04 Adrian Stern <ar...@gmail.com>:
>>>
>>> I've not come much further on this topic. I started creating my own CoA
>> but
>>>> having problems filling out the fields glAccountClassId and
>>>> glAccountTypeId.
>>>> I did find some explanation about those fields in
>>>> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
>>>> right track.
>>>>
>>>> Are there any German speaking people in this mailing list? Or someone who
>>>> has done this before?
>>>> This is my very first task in ofbiz... so i'm kind of lost.
>>>>
>>>> I've found the translations of this classes and types
>>>> in config/AccountingEntityLabels.xml but i lack some explaining...
>>>>
>>>> Are there any accounts that absolutley have to be used or are all of them
>>>> more or less optional and ofbiz knows of its own what to do whith the one
>>>> available?
>>>>
>>>> Regards,
>>>> Adrian
>>>>
>>>>
>>>> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
>>>>
>>>>> Hello
>>>>>
>>>>> I'm looking for Information about implementing a completely new chart of
>>>>> accounts. I think i actually found everything important, but i still want
>>>>> to ask about some random input and a share of your experiences.
>>>>>
>>>>> So. As i understand the first Step is to create the global chart (tree) as
>>>>> the example "data/DemoGeneralChartOfAccounts.xml" states. This will result
>>>>> in the entries in
>>>>>
>>>>> Accounting -> Global GL Settings
>>>>>
>>>>> And with that, i can configure the Organization GL Settings which are
>>>>> specific to my needs.
>>>>>
>>>>> 1. Could there be any dependencies one has to take care of when using a
>>>>> different chart of accounts?
>>>>>
>>>>> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part of
>>>>> ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>>>>>
>>>>> 3. How do i tell ofbiz to use not the Demo tree but my own, after creating
>>>>> it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml but
>>>>> i bet there is a Global setting somewhere. Well. Probably just
>>>>> ofbiz-component.xml and SetupEvents.xml...
>>>>>
>>>>> Regards, Adrian
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
Hi Igor
Thanks for your links. The italian chart did not help much. It differs too
much and i'm not able to find clear matches (because of the langage barrier
probably). I could find a relevant download from XBRL-CH.ch however this
one is from 2011 and there was a revision in 2013.
I would say we can solve about 1/4 to 1/3 with the files available so far
whith matching it against the demo chart.
What i'm looking for know is an explanation about what glAccountType and
glAccountClass actually do -> what they are used for.
Also there are some other types which are not glAccountType or Class which
would match by description. Like: GlResourceType.description.RAW_MATERIALS
which would be what we're looking for but it is not an account type but a
Resource Type.
Looks like we have to build our own from scratch...
On 4 February 2014 11:16, Igor Gallingani <ig...@gmail.com> wrote:
> I forgot
>
> glAccountType in italian is translated as "causale contabile" ==
> "???kausalen Konten??? or ???Buchhalter ????" (google )
> glAccountClass = the class of the account
>
>
> 2014-02-04 Igor Gallingani <ig...@gmail.com>:
>
> > I hope it can be useful. This chart of accounts is based on
> > http://www2.xbrl.org//it/.
> > You can compare it with http://www.xbrl.de/.
> >
> >
> > 2014-02-04 Adrian Stern <ar...@gmail.com>:
> >
> > I've not come much further on this topic. I started creating my own CoA
> but
> >> having problems filling out the fields glAccountClassId and
> >> glAccountTypeId.
> >> I did find some explanation about those fields in
> >> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
> >> right track.
> >>
> >> Are there any German speaking people in this mailing list? Or someone
> who
> >> has done this before?
> >> This is my very first task in ofbiz... so i'm kind of lost.
> >>
> >> I've found the translations of this classes and types
> >> in config/AccountingEntityLabels.xml but i lack some explaining...
> >>
> >> Are there any accounts that absolutley have to be used or are all of
> them
> >> more or less optional and ofbiz knows of its own what to do whith the
> one
> >> available?
> >>
> >> Regards,
> >> Adrian
> >>
> >>
> >> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
> >>
> >> > Hello
> >> >
> >> > I'm looking for Information about implementing a completely new chart
> of
> >> > accounts. I think i actually found everything important, but i still
> >> want
> >> > to ask about some random input and a share of your experiences.
> >> >
> >> > So. As i understand the first Step is to create the global chart
> (tree)
> >> as
> >> > the example "data/DemoGeneralChartOfAccounts.xml" states. This will
> >> result
> >> > in the entries in
> >> >
> >> > Accounting -> Global GL Settings
> >> >
> >> > And with that, i can configure the Organization GL Settings which are
> >> > specific to my needs.
> >> >
> >> > 1. Could there be any dependencies one has to take care of when using
> a
> >> > different chart of accounts?
> >> >
> >> > 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not
> part
> >> of
> >> > ofbiz, should i keep it in the hot-deploy folder? How do you organize?
> >> >
> >> > 3. How do i tell ofbiz to use not the Demo tree but my own, after
> >> creating
> >> > it? Grep reveals a number of files using
> DemoGeneralChartOfAccounts.xml
> >> but
> >> > i bet there is a Global setting somewhere. Well. Probably just
> >> > ofbiz-component.xml and SetupEvents.xml...
> >> >
> >> > Regards, Adrian
> >> >
> >> >
> >>
> >
> >
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Igor Gallingani <ig...@gmail.com>.
I forgot
glAccountType in italian is translated as "causale contabile" ==
"???kausalen Konten??? or ???Buchhalter ????" (google )
glAccountClass = the class of the account
2014-02-04 Igor Gallingani <ig...@gmail.com>:
> I hope it can be useful. This chart of accounts is based on
> http://www2.xbrl.org//it/.
> You can compare it with http://www.xbrl.de/.
>
>
> 2014-02-04 Adrian Stern <ar...@gmail.com>:
>
> I've not come much further on this topic. I started creating my own CoA but
>> having problems filling out the fields glAccountClassId and
>> glAccountTypeId.
>> I did find some explanation about those fields in
>> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
>> right track.
>>
>> Are there any German speaking people in this mailing list? Or someone who
>> has done this before?
>> This is my very first task in ofbiz... so i'm kind of lost.
>>
>> I've found the translations of this classes and types
>> in config/AccountingEntityLabels.xml but i lack some explaining...
>>
>> Are there any accounts that absolutley have to be used or are all of them
>> more or less optional and ofbiz knows of its own what to do whith the one
>> available?
>>
>> Regards,
>> Adrian
>>
>>
>> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
>>
>> > Hello
>> >
>> > I'm looking for Information about implementing a completely new chart of
>> > accounts. I think i actually found everything important, but i still
>> want
>> > to ask about some random input and a share of your experiences.
>> >
>> > So. As i understand the first Step is to create the global chart (tree)
>> as
>> > the example "data/DemoGeneralChartOfAccounts.xml" states. This will
>> result
>> > in the entries in
>> >
>> > Accounting -> Global GL Settings
>> >
>> > And with that, i can configure the Organization GL Settings which are
>> > specific to my needs.
>> >
>> > 1. Could there be any dependencies one has to take care of when using a
>> > different chart of accounts?
>> >
>> > 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part
>> of
>> > ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>> >
>> > 3. How do i tell ofbiz to use not the Demo tree but my own, after
>> creating
>> > it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml
>> but
>> > i bet there is a Global setting somewhere. Well. Probably just
>> > ofbiz-component.xml and SetupEvents.xml...
>> >
>> > Regards, Adrian
>> >
>> >
>>
>
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Igor Gallingani <ig...@gmail.com>.
I hope it can be useful. This chart of accounts is based on
http://www2.xbrl.org//it/.
You can compare it with http://www.xbrl.de/.
2014-02-04 Adrian Stern <ar...@gmail.com>:
> I've not come much further on this topic. I started creating my own CoA but
> having problems filling out the fields glAccountClassId and
> glAccountTypeId.
> I did find some explanation about those fields in
> the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
> right track.
>
> Are there any German speaking people in this mailing list? Or someone who
> has done this before?
> This is my very first task in ofbiz... so i'm kind of lost.
>
> I've found the translations of this classes and types
> in config/AccountingEntityLabels.xml but i lack some explaining...
>
> Are there any accounts that absolutley have to be used or are all of them
> more or less optional and ofbiz knows of its own what to do whith the one
> available?
>
> Regards,
> Adrian
>
>
> On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
>
> > Hello
> >
> > I'm looking for Information about implementing a completely new chart of
> > accounts. I think i actually found everything important, but i still want
> > to ask about some random input and a share of your experiences.
> >
> > So. As i understand the first Step is to create the global chart (tree)
> as
> > the example "data/DemoGeneralChartOfAccounts.xml" states. This will
> result
> > in the entries in
> >
> > Accounting -> Global GL Settings
> >
> > And with that, i can configure the Organization GL Settings which are
> > specific to my needs.
> >
> > 1. Could there be any dependencies one has to take care of when using a
> > different chart of accounts?
> >
> > 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part
> of
> > ofbiz, should i keep it in the hot-deploy folder? How do you organize?
> >
> > 3. How do i tell ofbiz to use not the Demo tree but my own, after
> creating
> > it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml
> but
> > i bet there is a Global setting somewhere. Well. Probably just
> > ofbiz-component.xml and SetupEvents.xml...
> >
> > Regards, Adrian
> >
> >
>
Re: Implementing Chart of Accounts for Switzerland (Or any country
for that matter)
Posted by Adrian Stern <ar...@gmail.com>.
I've not come much further on this topic. I started creating my own CoA but
having problems filling out the fields glAccountClassId and
glAccountTypeId.
I did find some explanation about those fields in
the ManagerReferenceAccounting.pdf, but i am still unsure if i'm on the
right track.
Are there any German speaking people in this mailing list? Or someone who
has done this before?
This is my very first task in ofbiz... so i'm kind of lost.
I've found the translations of this classes and types
in config/AccountingEntityLabels.xml but i lack some explaining...
Are there any accounts that absolutley have to be used or are all of them
more or less optional and ofbiz knows of its own what to do whith the one
available?
Regards,
Adrian
On 28 January 2014 20:57, Adrian Stern <ar...@gmail.com> wrote:
> Hello
>
> I'm looking for Information about implementing a completely new chart of
> accounts. I think i actually found everything important, but i still want
> to ask about some random input and a share of your experiences.
>
> So. As i understand the first Step is to create the global chart (tree) as
> the example "data/DemoGeneralChartOfAccounts.xml" states. This will result
> in the entries in
>
> Accounting -> Global GL Settings
>
> And with that, i can configure the Organization GL Settings which are
> specific to my needs.
>
> 1. Could there be any dependencies one has to take care of when using a
> different chart of accounts?
>
> 2. Is there an "OFBiz"-Way for doing that? Since this Chart is not part of
> ofbiz, should i keep it in the hot-deploy folder? How do you organize?
>
> 3. How do i tell ofbiz to use not the Demo tree but my own, after creating
> it? Grep reveals a number of files using DemoGeneralChartOfAccounts.xml but
> i bet there is a Global setting somewhere. Well. Probably just
> ofbiz-component.xml and SetupEvents.xml...
>
> Regards, Adrian
>
>