Implementing Chart of Accounts for Switzerland (Or any country for that matter)

[Adrian Stern]

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

[Adrian Stern]

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 <[hidden email]> 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
>
>

[Igor Gallingani]

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 <[hidden email]>:

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 <[hidden email]> 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
>
>

[Igor Gallingani]

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 <[hidden email]>:

> 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 <[hidden email]>:
>
> 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 <[hidden email]> 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
>> >
>> >
>>
>
>

[Adrian Stern]

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 <[hidden email]> 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 <[hidden email]>:
>
> > 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 <[hidden email]>:
> >
> > 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 <[hidden email]> 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
> >> >
> >> >
> >>
> >
> >
>

[Jacques Le Roux]

This might help http://markmail.org/message/uq7w4snax3w7gyrk

Jacques

On Tuesday, February 04, 2014 1:01 PM, [hidden email] 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 <[hidden email]> 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 <[hidden email]>:
>>
>>> 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 <[hidden email]>:
>>>
>>> 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 <[hidden email]> 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

[Adrian Stern]

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 <[hidden email]>wrote:

> This might help http://markmail.org/message/uq7w4snax3w7gyrk
>
> Jacques
>
> On Tuesday, February 04, 2014 1:01 PM, [hidden email] 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 <[hidden email]>
> 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 <[hidden email]>:
> >>
> >>> 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 <[hidden email]>:
> >>>
> >>> 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 <[hidden email]> 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
>

[Pierre Smits]

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 <[hidden email]> 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
>

[Pierre Smits]

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

[Adrian Stern]

For know im happy with the demo data. What i have been missing is an import
option for installing only my own CoA. Well i did not search that deeply
since it is not important for know. (Maybe ant load-file)

Would be happy for an answer to my previous email.


On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:

> Adrian,
>
> Other good point of reference are the books regarding the Universal Data
> Model by Len Silverston.
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://ORRTIZ.COM>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>

[Anil Patel-3]

Adrian,

Regarding questions in your first email.

You can safely ignore GL Account Class for automatic posting of business transactions to general ledger.

I see you got basic steps figured

Step 1) Define Chart of Account. For reference use DemoGeneralChartOfAccounts.xml
Step 2) Associate GLAccounts to Organization. For reference use DemoGlSetupData.xml
Step 3) Setup data for automatic GL posting of business transactions  e.g Invoice , Payment , Inventory issuances etc.

Looks like you have figured first two steps. I can help you setup data for automatic posting. Data setup between line # 294 to line #315 is good example. If you can read code, start with “getGlAccountFromAccountType” at line #446 in GeneralLedgerServices.xml.

I can give you specific help for real specific question, for e.g setup data for automatic posting of Sales Invoice to GL. I will need access to your CoA as well.

Thanks and Regards
Anil Patel
COO
Hotwax Media Inc
http://www.hotwaxmedia.com/
ApacheCon US 2013 Gold Sponsor
http://na.apachecon.com/sponsors/

On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:

> For know im happy with the demo data. What i have been missing is an import
> option for installing only my own CoA. Well i did not search that deeply
> since it is not important for know. (Maybe ant load-file)
>
> Would be happy for an answer to my previous email.
>
>
> On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
>
>> Adrian,
>>
>> Other good point of reference are the books regarding the Universal Data
>> Model by Len Silverston.
>>
>> Regards,
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://ORRTIZ.COM>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>

[Adrian Stern]

Hi Anil

Thanks for your response. Since English is not my mother tongue, it is hard
for me to read between the lines. So i have to come back to you from time
to time with some questions about your statements.

First: You say i can safely ignore GL Account Class. I assume this is
because it is not used for accounting but for reporting instead. True?
But do you also imply we will have to set GL Account Type properly?

Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
Item Types to Gl Account Ids mappings? I would have done it since
everything there uses the wrong codes.

I think for now we should focus on Step 1 and 2. But out of Couriosity,
where would i configure Step 3?

For our CoA we've created a Spreadsheet which we will exprot to a CSV and
then generate the GL Xml from it. I can share the generation script with
you if you'd like. You can find the Spreadsheet in the link below.

We've mainly focused on the GL Account Classes... Too bad we have to start
over on the Types.

https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing

Regards, Adrian


On 5 February 2014 04:33, Anil Patel <[hidden email]> wrote:

> Adrian,
>
> Regarding questions in your first email.
>
> You can safely ignore GL Account Class for automatic posting of business
> transactions to general ledger.
>
> I see you got basic steps figured
>
> Step 1) Define Chart of Account. For reference use
> DemoGeneralChartOfAccounts.xml
> Step 2) Associate GLAccounts to Organization. For reference use
> DemoGlSetupData.xml
> Step 3) Setup data for automatic GL posting of business transactions  e.g
> Invoice , Payment , Inventory issuances etc.
>
> Looks like you have figured first two steps. I can help you setup data for
> automatic posting. Data setup between line # 294 to line #315 is good
> example. If you can read code, start with "getGlAccountFromAccountType" at
> line #446 in GeneralLedgerServices.xml.
>
> I can give you specific help for real specific question, for e.g setup
> data for automatic posting of Sales Invoice to GL. I will need access to
> your CoA as well.
>
> Thanks and Regards
> Anil Patel
> COO
> Hotwax Media Inc
> http://www.hotwaxmedia.com/
> ApacheCon US 2013 Gold Sponsor
> http://na.apachecon.com/sponsors/
>
> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
>
> > For know im happy with the demo data. What i have been missing is an
> import
> > option for installing only my own CoA. Well i did not search that deeply
> > since it is not important for know. (Maybe ant load-file)
> >
> > Would be happy for an answer to my previous email.
> >
> >
> > On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
> >
> >> Adrian,
> >>
> >> Other good point of reference are the books regarding the Universal Data
> >> Model by Len Silverston.
> >>
> >> Regards,
> >>
> >> Pierre Smits
> >>
> >> *ORRTIZ.COM <http://ORRTIZ.COM>*
> >> Services & Solutions for Cloud-
> >> Based Manufacturing, Professional
> >> Services and Retail & Trade
> >> http://www.orrtiz.com
> >>
>
>

[Adrian Stern]

So. I discovered that there are many accounts in the CoA which do not
specify a GL Account Type. Why is this? Which rules will help me determine
wheter to set a type or not and which type to set?

On 5 February 2014 10:55, Adrian Stern <[hidden email]> wrote:

> Hi Anil
>
> Thanks for your response. Since English is not my mother tongue, it is
> hard for me to read between the lines. So i have to come back to you from
> time to time with some questions about your statements.
>
> First: You say i can safely ignore GL Account Class. I assume this is
> because it is not used for accounting but for reporting instead. True?
> But do you also imply we will have to set GL Account Type properly?
>
> Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
> Item Types to Gl Account Ids mappings? I would have done it since
> everything there uses the wrong codes.
>
> I think for now we should focus on Step 1 and 2. But out of Couriosity,
> where would i configure Step 3?
>
> For our CoA we've created a Spreadsheet which we will exprot to a CSV and
> then generate the GL Xml from it. I can share the generation script with
> you if you'd like. You can find the Spreadsheet in the link below.
>
> We've mainly focused on the GL Account Classes... Too bad we have to start
> over on the Types.
>
>
> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing
>
> Regards, Adrian
>
>
> On 5 February 2014 04:33, Anil Patel <[hidden email]> wrote:
>
>> Adrian,
>>
>> Regarding questions in your first email.
>>
>> You can safely ignore GL Account Class for automatic posting of business
>> transactions to general ledger.
>>
>> I see you got basic steps figured
>>
>> Step 1) Define Chart of Account. For reference use
>> DemoGeneralChartOfAccounts.xml
>> Step 2) Associate GLAccounts to Organization. For reference use
>> DemoGlSetupData.xml
>> Step 3) Setup data for automatic GL posting of business transactions  e.g
>> Invoice , Payment , Inventory issuances etc.
>>
>> Looks like you have figured first two steps. I can help you setup data
>> for automatic posting. Data setup between line # 294 to line #315 is good
>> example. If you can read code, start with "getGlAccountFromAccountType" at
>> line #446 in GeneralLedgerServices.xml.
>>
>> I can give you specific help for real specific question, for e.g setup
>> data for automatic posting of Sales Invoice to GL. I will need access to
>> your CoA as well.
>>
>> Thanks and Regards
>> Anil Patel
>> COO
>> Hotwax Media Inc
>> http://www.hotwaxmedia.com/
>> ApacheCon US 2013 Gold Sponsor
>> http://na.apachecon.com/sponsors/
>>
>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
>>
>> > For know im happy with the demo data. What i have been missing is an
>> import
>> > option for installing only my own CoA. Well i did not search that deeply
>> > since it is not important for know. (Maybe ant load-file)
>> >
>> > Would be happy for an answer to my previous email.
>> >
>> >
>> > On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
>> >
>> >> Adrian,
>> >>
>> >> Other good point of reference are the books regarding the Universal
>> Data
>> >> Model by Len Silverston.
>> >>
>> >> Regards,
>> >>
>> >> Pierre Smits
>> >>
>> >> *ORRTIZ.COM <http://ORRTIZ.COM>*
>> >> Services & Solutions for Cloud-
>> >> Based Manufacturing, Professional
>> >> Services and Retail & Trade
>> >> http://www.orrtiz.com
>> >>
>>
>>
>

[Anil Patel-3]

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 <[hidden email]> wrote:
>
> Hi Anil
>
> Thanks for your response. Since English is not my mother tongue, it is hard
> for me to read between the lines. So i have to come back to you from time
> to time with some questions about your statements.
>
> First: You say i can safely ignore GL Account Class. I assume this is
> because it is not used for accounting but for reporting instead. True?
> But do you also imply we will have to set GL Account Type properly?
>
> Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
> Item Types to Gl Account Ids mappings? I would have done it since
> everything there uses the wrong codes.
>
> I think for now we should focus on Step 1 and 2. But out of Couriosity,
> where would i configure Step 3?
>
> For our CoA we've created a Spreadsheet which we will exprot to a CSV and
> then generate the GL Xml from it. I can share the generation script with
> you if you'd like. You can find the Spreadsheet in the link below.
>
> We've mainly focused on the GL Account Classes... Too bad we have to start
> over on the Types.
>
> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing
>
> Regards, Adrian
>
>
>> On 5 February 2014 04:33, Anil Patel <[hidden email]> wrote:
>>
>> Adrian,
>>
>> Regarding questions in your first email.
>>
>> You can safely ignore GL Account Class for automatic posting of business
>> transactions to general ledger.
>>
>> I see you got basic steps figured
>>
>> Step 1) Define Chart of Account. For reference use
>> DemoGeneralChartOfAccounts.xml
>> Step 2) Associate GLAccounts to Organization. For reference use
>> DemoGlSetupData.xml
>> Step 3) Setup data for automatic GL posting of business transactions  e.g
>> Invoice , Payment , Inventory issuances etc.
>>
>> Looks like you have figured first two steps. I can help you setup data for
>> automatic posting. Data setup between line # 294 to line #315 is good
>> example. If you can read code, start with "getGlAccountFromAccountType" at
>> line #446 in GeneralLedgerServices.xml.
>>
>> I can give you specific help for real specific question, for e.g setup
>> data for automatic posting of Sales Invoice to GL. I will need access to
>> your CoA as well.
>>
>> Thanks and Regards
>> Anil Patel
>> COO
>> Hotwax Media Inc
>> http://www.hotwaxmedia.com/
>> ApacheCon US 2013 Gold Sponsor
>> http://na.apachecon.com/sponsors/
>>
>>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
>>>
>>> For know im happy with the demo data. What i have been missing is an
>> import
>>> option for installing only my own CoA. Well i did not search that deeply
>>> since it is not important for know. (Maybe ant load-file)
>>>
>>> Would be happy for an answer to my previous email.
>>>
>>>
>>>> On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
>>>>
>>>> Adrian,
>>>>
>>>> Other good point of reference are the books regarding the Universal Data
>>>> Model by Len Silverston.
>>>>
>>>> Regards,
>>>>
>>>> Pierre Smits
>>>>
>>>> *ORRTIZ.COM <http://ORRTIZ.COM>*
>>>> Services & Solutions for Cloud-
>>>> Based Manufacturing, Professional
>>>> Services and Retail & Trade
>>>> http://www.orrtiz.com
>>
>>

[Anil Patel-3]

It's recommended that all glAccounts have type.  It's safe to say with some level of confidence, that accounts with no glaccountType don't get automatic posting.

For now I say, ignore them :)

Anil K Patel
Sent from my iPad

> On Feb 5, 2014, at 7:46 AM, Adrian Stern <[hidden email]> wrote:
>
> So. I discovered that there are many accounts in the CoA which do not
> specify a GL Account Type. Why is this? Which rules will help me determine
> wheter to set a type or not and which type to set?
>
>> On 5 February 2014 10:55, Adrian Stern <[hidden email]> wrote:
>>
>> Hi Anil
>>
>> Thanks for your response. Since English is not my mother tongue, it is
>> hard for me to read between the lines. So i have to come back to you from
>> time to time with some questions about your statements.
>>
>> First: You say i can safely ignore GL Account Class. I assume this is
>> because it is not used for accounting but for reporting instead. True?
>> But do you also imply we will have to set GL Account Type properly?
>>
>> Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
>> Item Types to Gl Account Ids mappings? I would have done it since
>> everything there uses the wrong codes.
>>
>> I think for now we should focus on Step 1 and 2. But out of Couriosity,
>> where would i configure Step 3?
>>
>> For our CoA we've created a Spreadsheet which we will exprot to a CSV and
>> then generate the GL Xml from it. I can share the generation script with
>> you if you'd like. You can find the Spreadsheet in the link below.
>>
>> We've mainly focused on the GL Account Classes... Too bad we have to start
>> over on the Types.
>>
>>
>> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing
>>
>> Regards, Adrian
>>
>>
>>> On 5 February 2014 04:33, Anil Patel <[hidden email]> wrote:
>>>
>>> Adrian,
>>>
>>> Regarding questions in your first email.
>>>
>>> You can safely ignore GL Account Class for automatic posting of business
>>> transactions to general ledger.
>>>
>>> I see you got basic steps figured
>>>
>>> Step 1) Define Chart of Account. For reference use
>>> DemoGeneralChartOfAccounts.xml
>>> Step 2) Associate GLAccounts to Organization. For reference use
>>> DemoGlSetupData.xml
>>> Step 3) Setup data for automatic GL posting of business transactions  e.g
>>> Invoice , Payment , Inventory issuances etc.
>>>
>>> Looks like you have figured first two steps. I can help you setup data
>>> for automatic posting. Data setup between line # 294 to line #315 is good
>>> example. If you can read code, start with "getGlAccountFromAccountType" at
>>> line #446 in GeneralLedgerServices.xml.
>>>
>>> I can give you specific help for real specific question, for e.g setup
>>> data for automatic posting of Sales Invoice to GL. I will need access to
>>> your CoA as well.
>>>
>>> Thanks and Regards
>>> Anil Patel
>>> COO
>>> Hotwax Media Inc
>>> http://www.hotwaxmedia.com/
>>> ApacheCon US 2013 Gold Sponsor
>>> http://na.apachecon.com/sponsors/
>>>
>>>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
>>>>
>>>> For know im happy with the demo data. What i have been missing is an
>>> import
>>>> option for installing only my own CoA. Well i did not search that deeply
>>>> since it is not important for know. (Maybe ant load-file)
>>>>
>>>> Would be happy for an answer to my previous email.
>>>>
>>>>
>>>>> On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
>>>>>
>>>>> Adrian,
>>>>>
>>>>> Other good point of reference are the books regarding the Universal
>>> Data
>>>>> Model by Len Silverston.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Pierre Smits
>>>>>
>>>>> *ORRTIZ.COM <http://ORRTIZ.COM>*
>>>>> Services & Solutions for Cloud-
>>>>> Based Manufacturing, Professional
>>>>> Services and Retail & Trade
>>>>> http://www.orrtiz.com
>>

[Adrian Stern]

Thanks Anil

So i will try to build our needs within the GUI and inspect the output.
As for the CSV, we included a english translation (google translate) so its
easier for you to guess what a spesific account is used for.

Furthermore i will ignore the GL Account Classes for the time beeing and
try to set a GL Account Type on each account.


On 5 February 2014 14:45, Anil K Patel <[hidden email]> wrote:

> It's recommended that all glAccounts have type.  It's safe to say with
> some level of confidence, that accounts with no glaccountType don't get
> automatic posting.
>
> For now I say, ignore them :)
>
> Anil K Patel
> Sent from my iPad
>
> > On Feb 5, 2014, at 7:46 AM, Adrian Stern <[hidden email]> wrote:
> >
> > So. I discovered that there are many accounts in the CoA which do not
> > specify a GL Account Type. Why is this? Which rules will help me
> determine
> > wheter to set a type or not and which type to set?
> >
> >> On 5 February 2014 10:55, Adrian Stern <[hidden email]> wrote:
> >>
> >> Hi Anil
> >>
> >> Thanks for your response. Since English is not my mother tongue, it is
> >> hard for me to read between the lines. So i have to come back to you
> from
> >> time to time with some questions about your statements.
> >>
> >> First: You say i can safely ignore GL Account Class. I assume this is
> >> because it is not used for accounting but for reporting instead. True?
> >> But do you also imply we will have to set GL Account Type properly?
> >>
> >> Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
> >> Item Types to Gl Account Ids mappings? I would have done it since
> >> everything there uses the wrong codes.
> >>
> >> I think for now we should focus on Step 1 and 2. But out of Couriosity,
> >> where would i configure Step 3?
> >>
> >> For our CoA we've created a Spreadsheet which we will exprot to a CSV
> and
> >> then generate the GL Xml from it. I can share the generation script with
> >> you if you'd like. You can find the Spreadsheet in the link below.
> >>
> >> We've mainly focused on the GL Account Classes... Too bad we have to
> start
> >> over on the Types.
> >>
> >>
> >>
> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing
> >>
> >> Regards, Adrian
> >>
> >>
> >>> On 5 February 2014 04:33, Anil Patel <[hidden email]>
> wrote:
> >>>
> >>> Adrian,
> >>>
> >>> Regarding questions in your first email.
> >>>
> >>> You can safely ignore GL Account Class for automatic posting of
> business
> >>> transactions to general ledger.
> >>>
> >>> I see you got basic steps figured
> >>>
> >>> Step 1) Define Chart of Account. For reference use
> >>> DemoGeneralChartOfAccounts.xml
> >>> Step 2) Associate GLAccounts to Organization. For reference use
> >>> DemoGlSetupData.xml
> >>> Step 3) Setup data for automatic GL posting of business transactions
>  e.g
> >>> Invoice , Payment , Inventory issuances etc.
> >>>
> >>> Looks like you have figured first two steps. I can help you setup data
> >>> for automatic posting. Data setup between line # 294 to line #315 is
> good
> >>> example. If you can read code, start with
> "getGlAccountFromAccountType" at
> >>> line #446 in GeneralLedgerServices.xml.
> >>>
> >>> I can give you specific help for real specific question, for e.g setup
> >>> data for automatic posting of Sales Invoice to GL. I will need access
> to
> >>> your CoA as well.
> >>>
> >>> Thanks and Regards
> >>> Anil Patel
> >>> COO
> >>> Hotwax Media Inc
> >>> http://www.hotwaxmedia.com/
> >>> ApacheCon US 2013 Gold Sponsor
> >>> http://na.apachecon.com/sponsors/
> >>>
> >>>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
> >>>>
> >>>> For know im happy with the demo data. What i have been missing is an
> >>> import
> >>>> option for installing only my own CoA. Well i did not search that
> deeply
> >>>> since it is not important for know. (Maybe ant load-file)
> >>>>
> >>>> Would be happy for an answer to my previous email.
> >>>>
> >>>>
> >>>>> On 4 February 2014 15:05, Pierre Smits <[hidden email]>
> wrote:
> >>>>>
> >>>>> Adrian,
> >>>>>
> >>>>> Other good point of reference are the books regarding the Universal
> >>> Data
> >>>>> Model by Len Silverston.
> >>>>>
> >>>>> Regards,
> >>>>>
> >>>>> Pierre Smits
> >>>>>
> >>>>> *ORRTIZ.COM <http://ORRTIZ.COM>*
> >>>>> Services & Solutions for Cloud-
> >>>>> Based Manufacturing, Professional
> >>>>> Services and Retail & Trade
> >>>>> http://www.orrtiz.com
> >>
>

[Adrian Stern]

I played around with ofbiz a little and i am able to import our accounts
together with the ones already present in demo data. When disposing of the
demo ones i get some import errors because there are references to accounts
no longer present. Also we had to switch from a CSV to a TSV because our
account names actually contain commas.

This is just a status update.

Dependencies to these files:

DemoGlSetupData.xml
DemoFinAccountData.xml
DemoTaxAuthority.xml
DemoAcctgTransactionData.xml
DemoPaymentsInvoices.xml
DemoTaxAuthority.xml
DemoOrderPeopleData.xml
DemoOrderTestData.xml
DemoMarketing.xml

Next we will try to switch the old account codes with our own new ones.
This will hopefully get us started.
As of now we are unsure if we just do it inside the files mentioned above
or with excessive trial end error with use-cases.

Regards, Adrian

On 5 February 2014 15:30, Adrian Stern <[hidden email]> wrote:

> Thanks Anil
>
> So i will try to build our needs within the GUI and inspect the output.
> As for the CSV, we included a english translation (google translate) so
> its easier for you to guess what a spesific account is used for.
>
> Furthermore i will ignore the GL Account Classes for the time beeing and
> try to set a GL Account Type on each account.
>
>
> On 5 February 2014 14:45, Anil K Patel <[hidden email]> wrote:
>
>> It's recommended that all glAccounts have type.  It's safe to say with
>> some level of confidence, that accounts with no glaccountType don't get
>> automatic posting.
>>
>> For now I say, ignore them :)
>>
>> Anil K Patel
>> Sent from my iPad
>>
>> > On Feb 5, 2014, at 7:46 AM, Adrian Stern <[hidden email]> wrote:
>> >
>> > So. I discovered that there are many accounts in the CoA which do not
>> > specify a GL Account Type. Why is this? Which rules will help me
>> determine
>> > wheter to set a type or not and which type to set?
>> >
>> >> On 5 February 2014 10:55, Adrian Stern <[hidden email]> wrote:
>> >>
>> >> Hi Anil
>> >>
>> >> Thanks for your response. Since English is not my mother tongue, it is
>> >> hard for me to read between the lines. So i have to come back to you
>> from
>> >> time to time with some questions about your statements.
>> >>
>> >> First: You say i can safely ignore GL Account Class. I assume this is
>> >> because it is not used for accounting but for reporting instead. True?
>> >> But do you also imply we will have to set GL Account Type properly?
>> >>
>> >> Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
>> >> Item Types to Gl Account Ids mappings? I would have done it since
>> >> everything there uses the wrong codes.
>> >>
>> >> I think for now we should focus on Step 1 and 2. But out of Couriosity,
>> >> where would i configure Step 3?
>> >>
>> >> For our CoA we've created a Spreadsheet which we will exprot to a CSV
>> and
>> >> then generate the GL Xml from it. I can share the generation script
>> with
>> >> you if you'd like. You can find the Spreadsheet in the link below.
>> >>
>> >> We've mainly focused on the GL Account Classes... Too bad we have to
>> start
>> >> over on the Types.
>> >>
>> >>
>> >>
>> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing
>> >>
>> >> Regards, Adrian
>> >>
>> >>
>> >>> On 5 February 2014 04:33, Anil Patel <[hidden email]>
>> wrote:
>> >>>
>> >>> Adrian,
>> >>>
>> >>> Regarding questions in your first email.
>> >>>
>> >>> You can safely ignore GL Account Class for automatic posting of
>> business
>> >>> transactions to general ledger.
>> >>>
>> >>> I see you got basic steps figured
>> >>>
>> >>> Step 1) Define Chart of Account. For reference use
>> >>> DemoGeneralChartOfAccounts.xml
>> >>> Step 2) Associate GLAccounts to Organization. For reference use
>> >>> DemoGlSetupData.xml
>> >>> Step 3) Setup data for automatic GL posting of business transactions
>>  e.g
>> >>> Invoice , Payment , Inventory issuances etc.
>> >>>
>> >>> Looks like you have figured first two steps. I can help you setup data
>> >>> for automatic posting. Data setup between line # 294 to line #315 is
>> good
>> >>> example. If you can read code, start with
>> "getGlAccountFromAccountType" at
>> >>> line #446 in GeneralLedgerServices.xml.
>> >>>
>> >>> I can give you specific help for real specific question, for e.g setup
>> >>> data for automatic posting of Sales Invoice to GL. I will need access
>> to
>> >>> your CoA as well.
>> >>>
>> >>> Thanks and Regards
>> >>> Anil Patel
>> >>> COO
>> >>> Hotwax Media Inc
>> >>> http://www.hotwaxmedia.com/
>> >>> ApacheCon US 2013 Gold Sponsor
>> >>> http://na.apachecon.com/sponsors/
>> >>>
>> >>>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]>
>> wrote:
>> >>>>
>> >>>> For know im happy with the demo data. What i have been missing is an
>> >>> import
>> >>>> option for installing only my own CoA. Well i did not search that
>> deeply
>> >>>> since it is not important for know. (Maybe ant load-file)
>> >>>>
>> >>>> Would be happy for an answer to my previous email.
>> >>>>
>> >>>>
>> >>>>> On 4 February 2014 15:05, Pierre Smits <[hidden email]>
>> wrote:
>> >>>>>
>> >>>>> Adrian,
>> >>>>>
>> >>>>> Other good point of reference are the books regarding the Universal
>> >>> Data
>> >>>>> Model by Len Silverston.
>> >>>>>
>> >>>>> Regards,
>> >>>>>
>> >>>>> Pierre Smits
>> >>>>>
>> >>>>> *ORRTIZ.COM <http://ORRTIZ.COM>*
>> >>>>> Services & Solutions for Cloud-
>> >>>>> Based Manufacturing, Professional
>> >>>>> Services and Retail & Trade
>> >>>>> http://www.orrtiz.com
>> >>
>>
>
>

[Anil Patel-3]

Adrian,
This document is good resource,
https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide

There is lot of information on it.


Thanks and Regards
Anil Patel
COO
Hotwax Media Inc
http://www.hotwaxmedia.com/
ApacheCon US 2013 Gold Sponsor
http://na.apachecon.com/sponsors/




On Feb 5, 2014, at 12:17 PM, Adrian Stern <[hidden email]> wrote:

> I played around with ofbiz a little and i am able to import our accounts
> together with the ones already present in demo data. When disposing of the
> demo ones i get some import errors because there are references to accounts
> no longer present. Also we had to switch from a CSV to a TSV because our
> account names actually contain commas.
>
> This is just a status update.
>
> Dependencies to these files:
>
> DemoGlSetupData.xml
> DemoFinAccountData.xml
> DemoTaxAuthority.xml
> DemoAcctgTransactionData.xml
> DemoPaymentsInvoices.xml
> DemoTaxAuthority.xml
> DemoOrderPeopleData.xml
> DemoOrderTestData.xml
> DemoMarketing.xml
>
> Next we will try to switch the old account codes with our own new ones.
> This will hopefully get us started.
> As of now we are unsure if we just do it inside the files mentioned above
> or with excessive trial end error with use-cases.
>
> Regards, Adrian
>
> On 5 February 2014 15:30, Adrian Stern <[hidden email]> wrote:
>
>> Thanks Anil
>>
>> So i will try to build our needs within the GUI and inspect the output.
>> As for the CSV, we included a english translation (google translate) so
>> its easier for you to guess what a spesific account is used for.
>>
>> Furthermore i will ignore the GL Account Classes for the time beeing and
>> try to set a GL Account Type on each account.
>>
>>
>> On 5 February 2014 14:45, Anil K Patel <[hidden email]> wrote:
>>
>>> It's recommended that all glAccounts have type.  It's safe to say with
>>> some level of confidence, that accounts with no glaccountType don't get
>>> automatic posting.
>>>
>>> For now I say, ignore them :)
>>>
>>> Anil K Patel
>>> Sent from my iPad
>>>
>>>> On Feb 5, 2014, at 7:46 AM, Adrian Stern <[hidden email]> wrote:
>>>>
>>>> So. I discovered that there are many accounts in the CoA which do not
>>>> specify a GL Account Type. Why is this? Which rules will help me
>>> determine
>>>> wheter to set a type or not and which type to set?
>>>>
>>>>> On 5 February 2014 10:55, Adrian Stern <[hidden email]> wrote:
>>>>>
>>>>> Hi Anil
>>>>>
>>>>> Thanks for your response. Since English is not my mother tongue, it is
>>>>> hard for me to read between the lines. So i have to come back to you
>>> from
>>>>> time to time with some questions about your statements.
>>>>>
>>>>> First: You say i can safely ignore GL Account Class. I assume this is
>>>>> because it is not used for accounting but for reporting instead. True?
>>>>> But do you also imply we will have to set GL Account Type properly?
>>>>>
>>>>> Secondly: In DemoGlSetupData.xml, do we also need to do all the Invoice
>>>>> Item Types to Gl Account Ids mappings? I would have done it since
>>>>> everything there uses the wrong codes.
>>>>>
>>>>> I think for now we should focus on Step 1 and 2. But out of Couriosity,
>>>>> where would i configure Step 3?
>>>>>
>>>>> For our CoA we've created a Spreadsheet which we will exprot to a CSV
>>> and
>>>>> then generate the GL Xml from it. I can share the generation script
>>> with
>>>>> you if you'd like. You can find the Spreadsheet in the link below.
>>>>>
>>>>> We've mainly focused on the GL Account Classes... Too bad we have to
>>> start
>>>>> over on the Types.
>>>>>
>>>>>
>>>>>
>>> https://docs.google.com/spreadsheet/ccc?key=0AvK-ZZbQV8kqdEVvV2dQbC1CdnRlZ1U2bjVyMUtrOXc&usp=sharing
>>>>>
>>>>> Regards, Adrian
>>>>>
>>>>>
>>>>>> On 5 February 2014 04:33, Anil Patel <[hidden email]>
>>> wrote:
>>>>>>
>>>>>> Adrian,
>>>>>>
>>>>>> Regarding questions in your first email.
>>>>>>
>>>>>> You can safely ignore GL Account Class for automatic posting of
>>> business
>>>>>> transactions to general ledger.
>>>>>>
>>>>>> I see you got basic steps figured
>>>>>>
>>>>>> Step 1) Define Chart of Account. For reference use
>>>>>> DemoGeneralChartOfAccounts.xml
>>>>>> Step 2) Associate GLAccounts to Organization. For reference use
>>>>>> DemoGlSetupData.xml
>>>>>> Step 3) Setup data for automatic GL posting of business transactions
>>> e.g
>>>>>> Invoice , Payment , Inventory issuances etc.
>>>>>>
>>>>>> Looks like you have figured first two steps. I can help you setup data
>>>>>> for automatic posting. Data setup between line # 294 to line #315 is
>>> good
>>>>>> example. If you can read code, start with
>>> "getGlAccountFromAccountType" at
>>>>>> line #446 in GeneralLedgerServices.xml.
>>>>>>
>>>>>> I can give you specific help for real specific question, for e.g setup
>>>>>> data for automatic posting of Sales Invoice to GL. I will need access
>>> to
>>>>>> your CoA as well.
>>>>>>
>>>>>> Thanks and Regards
>>>>>> Anil Patel
>>>>>> COO
>>>>>> Hotwax Media Inc
>>>>>> http://www.hotwaxmedia.com/
>>>>>> ApacheCon US 2013 Gold Sponsor
>>>>>> http://na.apachecon.com/sponsors/
>>>>>>
>>>>>>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]>
>>> wrote:
>>>>>>>
>>>>>>> For know im happy with the demo data. What i have been missing is an
>>>>>> import
>>>>>>> option for installing only my own CoA. Well i did not search that
>>> deeply
>>>>>>> since it is not important for know. (Maybe ant load-file)
>>>>>>>
>>>>>>> Would be happy for an answer to my previous email.
>>>>>>>
>>>>>>>
>>>>>>>> On 4 February 2014 15:05, Pierre Smits <[hidden email]>
>>> wrote:
>>>>>>>>
>>>>>>>> Adrian,
>>>>>>>>
>>>>>>>> Other good point of reference are the books regarding the Universal
>>>>>> Data
>>>>>>>> Model by Len Silverston.
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>>
>>>>>>>> Pierre Smits
>>>>>>>>
>>>>>>>> *ORRTIZ.COM <http://ORRTIZ.COM>*
>>>>>>>> Services & Solutions for Cloud-
>>>>>>>> Based Manufacturing, Professional
>>>>>>>> Services and Retail & Trade
>>>>>>>> http://www.orrtiz.com
>>>>>
>>>
>>
>>

[Mike Z]

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 <[hidden email]>wrote:

> Adrian,
>
> Regarding questions in your first email.
>
> You can safely ignore GL Account Class for automatic posting of business
> transactions to general ledger.
>
> I see you got basic steps figured
>
> Step 1) Define Chart of Account. For reference use
> DemoGeneralChartOfAccounts.xml
> Step 2) Associate GLAccounts to Organization. For reference use
> DemoGlSetupData.xml
> Step 3) Setup data for automatic GL posting of business transactions  e.g
> Invoice , Payment , Inventory issuances etc.
>
> Looks like you have figured first two steps. I can help you setup data for
> automatic posting. Data setup between line # 294 to line #315 is good
> example. If you can read code, start with “getGlAccountFromAccountType” at
> line #446 in GeneralLedgerServices.xml.
>
> I can give you specific help for real specific question, for e.g setup
> data for automatic posting of Sales Invoice to GL. I will need access to
> your CoA as well.
>
> Thanks and Regards
> Anil Patel
> COO
> Hotwax Media Inc
> http://www.hotwaxmedia.com/
> ApacheCon US 2013 Gold Sponsor
> http://na.apachecon.com/sponsors/
>
> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
>
> > For know im happy with the demo data. What i have been missing is an
> import
> > option for installing only my own CoA. Well i did not search that deeply
> > since it is not important for know. (Maybe ant load-file)
> >
> > Would be happy for an answer to my previous email.
> >
> >
> > On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
> >
> >> Adrian,
> >>
> >> Other good point of reference are the books regarding the Universal Data
> >> Model by Len Silverston.
> >>
> >> Regards,
> >>
> >> Pierre Smits
> >>
> >> *ORRTIZ.COM <http://ORRTIZ.COM>*
> >> Services & Solutions for Cloud-
> >> Based Manufacturing, Professional
> >> Services and Retail & Trade
> >> http://www.orrtiz.com
> >>
>
>

[Anil Patel-3]

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 <[hidden email]> 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 <[hidden email]>wrote:
>
>> Adrian,
>>
>> Regarding questions in your first email.
>>
>> You can safely ignore GL Account Class for automatic posting of business
>> transactions to general ledger.
>>
>> I see you got basic steps figured
>>
>> Step 1) Define Chart of Account. For reference use
>> DemoGeneralChartOfAccounts.xml
>> Step 2) Associate GLAccounts to Organization. For reference use
>> DemoGlSetupData.xml
>> Step 3) Setup data for automatic GL posting of business transactions  e.g
>> Invoice , Payment , Inventory issuances etc.
>>
>> Looks like you have figured first two steps. I can help you setup data for
>> automatic posting. Data setup between line # 294 to line #315 is good
>> example. If you can read code, start with “getGlAccountFromAccountType” at
>> line #446 in GeneralLedgerServices.xml.
>>
>> I can give you specific help for real specific question, for e.g setup
>> data for automatic posting of Sales Invoice to GL. I will need access to
>> your CoA as well.
>>
>> Thanks and Regards
>> Anil Patel
>> COO
>> Hotwax Media Inc
>> http://www.hotwaxmedia.com/
>> ApacheCon US 2013 Gold Sponsor
>> http://na.apachecon.com/sponsors/
>>
>> On Feb 4, 2014, at 10:07 AM, Adrian Stern <[hidden email]> wrote:
>>
>>> For know im happy with the demo data. What i have been missing is an
>> import
>>> option for installing only my own CoA. Well i did not search that deeply
>>> since it is not important for know. (Maybe ant load-file)
>>>
>>> Would be happy for an answer to my previous email.
>>>
>>>
>>> On 4 February 2014 15:05, Pierre Smits <[hidden email]> wrote:
>>>
>>>> Adrian,
>>>>
>>>> Other good point of reference are the books regarding the Universal Data
>>>> Model by Len Silverston.
>>>>
>>>> Regards,
>>>>
>>>> Pierre Smits
>>>>
>>>> *ORRTIZ.COM <http://ORRTIZ.COM>*
>>>> Services & Solutions for Cloud-
>>>> Based Manufacturing, Professional
>>>> Services and Retail & Trade
>>>> http://www.orrtiz.com
>>>>
>>
>>