date:20211021

Hello,
you have the wrong line. In my file on line 60 contains this here: 

"core" : { "initially_open" : [ "${partyId}" ] },

I have created a Jira ticket: https://issues.apache.org/jira/browse/OFBIZ-12343

we have attached the full log stack to the ticket.

regards,
Rodrigo Baptista
On 2021/10/20 17:23:57, Jacques Le Roux  wrote: 
> 
> Le 20/10/2021 à 14:19, Rodrigo Baptista a écrit :
> > Hello,
> >
> > i have a problem with ofbiz. I installed the version 17.12 and 18.12 and i 
> > have the same issue with both versions.
> >
> > What I do:
> >
> > 1. Installed Ofbiz with initial seed data. (./gradlew "ofbiz --load-data 
> > readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin)
> > 2. Start ofbiz (./gradlew ofbiz)
> > 3. open HR View (/humanres/control/main)
> >
> > Now i have always a exception in my logs cause by the partyId is null:
> >
> > logs:
> >
> > Start Log-
> >
> > freemarker.core.InvalidReferenceException: The following has evaluated to 
> > null or missing:
> > ==> partyId  [in template 
> > "component://humanres/template/category/CategoryTree.ftl" at line 60, 
> > column 44]
> > 
> > Tip: If the failing expression is known to legally refer to something 
> > that's sometimes null or missing, either specify a default value like 
> > myOptionalVar!myDefault, or use <#if 
> > myOptionalVar??>when-present<#else>when-missing. (These only cover 
> > the last step of the expression; to cover the whole expression, use 
> > parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
> > 
> > FTL stack trace ("~" means nesting-related):
> > - Failed at: ${partyId}  [in template 
> > "component://humanres/template/category/CategoryTree.ftl" at line 60, 
> > column 42]
> > ——
> > End Log
> >
> > What i need is to create a company to manage the company.
> >
> > I created also a company with the documentation 
> > (https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company) 
> > and it not fixed the issue.
> >
> > Does anybody have a solution for me?
> >
> >
> > regards Rodrigo Baptista
> 
> This error is pretty weird. Here is the line (60) concerned (including 
> leading spaces). At position 40+~ we have null. It makes no sense. You need 
> to 
> create a Jira* and copy more of error stack, TIA
> 
>      $.cookie('jstree_select', null);
> 
> * https://s.apache.org/dsj2p
> 
>

Re: create company

2021-10-21 Thread Yashwant Dhakad

I checked the Human Resource screen and see that If company party
has GROUP_ROLLUP type relationship with other parties then company party
will show on that screen.

On Thu, Oct 21, 2021 at 12:22 PM Rodrigo Baptista <
rodrigo.bapti...@binaroo.com> wrote:

> Hello,
> yes I know. I have run this command. But now I can´t create a company. I
> followed the instructions from the wiki how to create a company. The
> company was created but I can´t find it in the Humanres view.
> Have I forgot a configuration?
>
> Can you explain me how to create a new custom company that is correctly
> configured so it is displayed in the Humanres view?
>
> On 2021/10/21 06:38:18, Yashwant Dhakad 
> wrote:
> > Hi Rodrigo,
> > You can load the seed and seed-initial data by the following command:
> > gradlew "ofbiz --load-data readers=seed,seed-initial"
> >
> > For other custom data, you can define other readers and can load them by
> > the above command with your custom data reader.
> >
> > On Wed, Oct 20, 2021 at 7:51 PM Rodrigo Baptista <
> > rodrigo.bapti...@binaroo.com> wrote:
> >
> > > Hello Jacques,
> > >
> > > yes its right. When i load all data, then i can´t reproduce this issue.
> > > But then i have all demo datas in my system. I need a empty system
> without
> > > all that demo datas and then create my own datas(company,
> employees...).
> > > Have you a solution for this?
> > >
> > > On 2021/10/20 14:06:00, Jacques Le Roux 
> > > wrote:
> > > > Hi Rodrigo,
> > > >
> > > > Your message has been moderated, else it would not have reached this
> > > Mailing List.
> > > >
> > > > Please subscribe to the user ML for such questions and then use your
> > > email client.
> > > > See why here http://ofbiz.apache.org/mailing-lists.html.
> > > >
> > > > You will get a better support, people can answer you on the ML.
> > > > The wider the audience the better the answers you might get.
> > > >
> > > > Also it's more work for moderators who have to accept your messages
> as
> > > long as you have not subscribed.
> > > > I'll personally no longer accept them (other moderators still could).
> > > >
> > > > Also you sent 3 other messages that need moderation. Please resend
> them
> > > after having subscribed
> > > >
> > > > Thanks
> > > >
> > > > This said, can you test again after loading all data? I guess you
> can't
> > > reproduce this issue on stable demo, right?
> > > >
> > > > Jacques
> > > >
> > > > Le 20/10/2021 à 13:29, Rodrigo Baptista a écrit :
> > > > > Hello,
> > > > >
> > > > > I have the same issue with the Version 17.12 and 18.12. Have you
> fixed
> > > your Problem and have a Solution for me?
> > > > >
> > > > > I analyzed the issue and I found in the logs a exception, when I
> open
> > > the HR view. The exception is:
> > > > >
> > > > > --
> > > > >
> > > > > freemarker.core.InvalidReferenceException: The following has
> evaluated
> > > to null or missing:
> > > > > ==> partyId  [in template
> > > "component://humanres/template/category/CategoryTree.ftl" at line 60,
> > > column 44]
> > > > >
> > > > > 
> > > > > Tip: If the failing expression is known to legally refer to
> something
> > > that's sometimes null or missing, either specify a default value like
> > > myOptionalVar!myDefault, or use <#if
> > > myOptionalVar??>when-present<#else>when-missing. (These only
> cover
> > > the last step of the expression; to cover the whole expression, use
> > > parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
> > > > > 
> > > > >
> > > > > 
> > > > > FTL stack trace ("~" means nesting-related):
> > > > >  - Failed at: ${partyId}  [in template
> > > "component://humanres/template/category/CategoryTree.ftl" at line 60,
> > > column 42]
> > > > > ——
> > > > >
> > > > > 
> > > > >
> > > > >
> > > > > What I do:
> > > > >
> > > > > 1. Installed Ofbiz with initial seed data.
> > > > > 2. Start ofbiz
> > > > > 3. open HR View
> > > > >
> > > > >
> > > > > Does anyone have a solution for this problem?
> > > > >
> > > > > Regards Rodrigo
> > > > >
> > > > >
> > > > > On 2017/01/24 14:45:06, Moatasim Al Masri  wrote:
> > > > >> Hi friend>
> > > > >>
> > > > >> I have issue in ofbiz 16.11.01 when I create new party group
> which is
> > > company not displayed in main hr page and also I granted role Internal
> > > Organization !!>
> > > > >>
> > > > >>
> > > > >>
> > > > >> Could anybody have answer please?>
> > > > >>
> > > > >>
> > > >
> > > >
> > >
> >
> >
> > --
> > Kind Regards,
> > Yashwant Dhakad
> > Sr. Technical Consultant
> >
> > *HotWax Systems*
> > *Enterprise open source experts*
> > cell: +91-9098240513
> > office: 0731-409-3684
> > http://www.hotwaxsystems.com
> >
>


-- 
Kind Regards,
Yashwant Dhakad
Sr. Technical Consultant

*HotWax Systems*
*Enterprise open source experts*
cell: +91-9098240513
office: 0731-409-3684
http://www.hotwaxsystems.com

Re: Product Detail - Extra Information

2021-10-21 Thread Nicolas Malin

Hello Justine,

You want display these information on the product summary or product
detail ?

You have all template here
https://github.com/apache/ofbiz-plugins/tree/trunk/ecommerce/template/catalog

Nicolas
On 21/10/2021 05:07, Justine Nowak wrote:
> Hello,
>
> We are trying to display extra information for our products on the
> eCommerce website.
>
> For instance, How do we display Good Identifications, Brand Name, Product
> dimensions, and Weight?
>
> What type of code do we have to create in the Template file to display this
> information?
>
> Thank you, Justine.
>

Re: Internationalization Issue

Hi Emad,

Enumerations (like product type) and other data records are subject for
internationalisation. The translations for these can be found in the
various components in the config folder and EntityLabels.xml in the
filename.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer

On Wed, Oct 20, 2021 at 9:26 PM Emad Radwan  wrote:

> Hello Community,
>
> Why the description field in list of value tables - e.g. Product_Type -
> isn't also subject to translation in different languages? What are the best
> practices here?
>
> Regards,
>
> Emad
>

Re: Kotlin integration

2021-10-21 Thread Nicolas Malin

Not at this time, we never confronted to the necessary to use Kotlin.
If you have the possibility to add a new engine on the service engine,
all contribution are welcome :)

Nicolas

On 17/10/2021 09:55, Marius Schmidt wrote:
> Has someone tried to use Kotlin for services and events yet with
> success and maybe wrote about it somewhere?
>
>

Re: create company

Hello,
how many relationships do I need? And which?

regards,
Rodrigo Baptista

On 2021/10/21 07:38:40, Yashwant Dhakad  
wrote: 
> I checked the Human Resource screen and see that If company party
> has GROUP_ROLLUP type relationship with other parties then company party
> will show on that screen.
> 
> On Thu, Oct 21, 2021 at 12:22 PM Rodrigo Baptista <
> rodrigo.bapti...@binaroo.com> wrote:
> 
> > Hello,
> > yes I know. I have run this command. But now I can´t create a company. I
> > followed the instructions from the wiki how to create a company. The
> > company was created but I can´t find it in the Humanres view.
> > Have I forgot a configuration?
> >
> > Can you explain me how to create a new custom company that is correctly
> > configured so it is displayed in the Humanres view?
> >
> > On 2021/10/21 06:38:18, Yashwant Dhakad 
> > wrote:
> > > Hi Rodrigo,
> > > You can load the seed and seed-initial data by the following command:
> > > gradlew "ofbiz --load-data readers=seed,seed-initial"
> > >
> > > For other custom data, you can define other readers and can load them by
> > > the above command with your custom data reader.
> > >
> > > On Wed, Oct 20, 2021 at 7:51 PM Rodrigo Baptista <
> > > rodrigo.bapti...@binaroo.com> wrote:
> > >
> > > > Hello Jacques,
> > > >
> > > > yes its right. When i load all data, then i can´t reproduce this issue.
> > > > But then i have all demo datas in my system. I need a empty system
> > without
> > > > all that demo datas and then create my own datas(company,
> > employees...).
> > > > Have you a solution for this?
> > > >
> > > > On 2021/10/20 14:06:00, Jacques Le Roux 
> > > > wrote:
> > > > > Hi Rodrigo,
> > > > >
> > > > > Your message has been moderated, else it would not have reached this
> > > > Mailing List.
> > > > >
> > > > > Please subscribe to the user ML for such questions and then use your
> > > > email client.
> > > > > See why here http://ofbiz.apache.org/mailing-lists.html.
> > > > >
> > > > > You will get a better support, people can answer you on the ML.
> > > > > The wider the audience the better the answers you might get.
> > > > >
> > > > > Also it's more work for moderators who have to accept your messages
> > as
> > > > long as you have not subscribed.
> > > > > I'll personally no longer accept them (other moderators still could).
> > > > >
> > > > > Also you sent 3 other messages that need moderation. Please resend
> > them
> > > > after having subscribed
> > > > >
> > > > > Thanks
> > > > >
> > > > > This said, can you test again after loading all data? I guess you
> > can't
> > > > reproduce this issue on stable demo, right?
> > > > >
> > > > > Jacques
> > > > >
> > > > > Le 20/10/2021 à 13:29, Rodrigo Baptista a écrit :
> > > > > > Hello,
> > > > > >
> > > > > > I have the same issue with the Version 17.12 and 18.12. Have you
> > fixed
> > > > your Problem and have a Solution for me?
> > > > > >
> > > > > > I analyzed the issue and I found in the logs a exception, when I
> > open
> > > > the HR view. The exception is:
> > > > > >
> > > > > > --
> > > > > >
> > > > > > freemarker.core.InvalidReferenceException: The following has
> > evaluated
> > > > to null or missing:
> > > > > > ==> partyId  [in template
> > > > "component://humanres/template/category/CategoryTree.ftl" at line 60,
> > > > column 44]
> > > > > >
> > > > > > 
> > > > > > Tip: If the failing expression is known to legally refer to
> > something
> > > > that's sometimes null or missing, either specify a default value like
> > > > myOptionalVar!myDefault, or use <#if
> > > > myOptionalVar??>when-present<#else>when-missing. (These only
> > cover
> > > > the last step of the expression; to cover the whole expression, use
> > > > parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
> > > > > > 
> > > > > >
> > > > > > 
> > > > > > FTL stack trace ("~" means nesting-related):
> > > > > >  - Failed at: ${partyId}  [in template
> > > > "component://humanres/template/category/CategoryTree.ftl" at line 60,
> > > > column 42]
> > > > > > ——
> > > > > >
> > > > > > 
> > > > > >
> > > > > >
> > > > > > What I do:
> > > > > >
> > > > > > 1. Installed Ofbiz with initial seed data.
> > > > > > 2. Start ofbiz
> > > > > > 3. open HR View
> > > > > >
> > > > > >
> > > > > > Does anyone have a solution for this problem?
> > > > > >
> > > > > > Regards Rodrigo
> > > > > >
> > > > > >
> > > > > > On 2017/01/24 14:45:06, Moatasim Al Masri  wrote:
> > > > > >> Hi friend>
> > > > > >>
> > > > > >> I have issue in ofbiz 16.11.01 when I create new party group
> > which is
> > > > company not displayed in main hr page and also I granted role Internal
> > > > Organization !!>
> > > > > >>
> > > > > >>
> > > > > >>
> > > > > >> Could anybody have answer please?>
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > >
> > >
> > >
> > > --
> > > Kind Regards,
> > > Yashwant Dhakad
> > > Sr. Technical Consultant
> > >
> > > *HotWax Systems*
> > > *Enter

Re: Product Detail - Extra Information

Hi Justine,

Details of a product to be shown in the ecommerce application can be made
visible by adding the desired fields to the appropriate template (e.g.
product details.ftl)

Met vriendelijke groet,
Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer

On Thu, Oct 21, 2021 at 5:07 AM Justine Nowak  wrote:

> Hello,
>
> We are trying to display extra information for our products on the
> eCommerce website.
>
> For instance, How do we display Good Identifications, Brand Name, Product
> dimensions, and Weight?
>
> What type of code do we have to create in the Template file to display this
> information?
>
> Thank you, Justine.
>

Re: Party ID is null in HumanRes

Hi Rodrigo,

Do you have the primary company in your data set? This needs to exist. Have
a look at the demo data set, see the data regarding ' and related.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Wed, Oct 20, 2021 at 4:19 PM Rodrigo Baptista <
rodrigo.bapti...@binaroo.com> wrote:

> Hello,
>
> i have a problem with ofbiz. I installed the version 17.12 and 18.12 and i
> have the same issue with both versions.
>
> What I do:
>
> 1. Installed Ofbiz with initial seed data. (./gradlew "ofbiz --load-data
> readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin)
> 2. Start ofbiz (./gradlew ofbiz)
> 3. open HR View (/humanres/control/main)
>
> Now i have always a exception in my logs cause by the partyId is null:
>
> logs:
>
> Start Log-
>
> freemarker.core.InvalidReferenceException: The following has evaluated to
> null or missing:
> ==> partyId  [in template
> "component://humanres/template/category/CategoryTree.ftl" at line 60,
> column 44]
> 
> Tip: If the failing expression is known to legally refer to something
> that's sometimes null or missing, either specify a default value like
> myOptionalVar!myDefault, or use <#if
> myOptionalVar??>when-present<#else>when-missing. (These only cover
> the last step of the expression; to cover the whole expression, use
> parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
> 
> FTL stack trace ("~" means nesting-related):
>- Failed at: ${partyId}  [in template
> "component://humanres/template/category/CategoryTree.ftl" at line 60,
> column 42]
> ——
> End Log
>
> What i need is to create a company to manage the company.
>
> I created also a company with the documentation (
> https://cwiki.apache.org/confluence/display/OFBIZ/How+to+Setup+a+Company)
> and it not fixed the issue.
>
> Does anybody have a solution for me?
>
>
> regards Rodrigo Baptista
>

Re: Attach original accounting documents to invoices

2021-10-21 Thread Nicolas Malin

You have the entity InvoiceContent [1] that manage your case.
At this time there is no native interface on the OFBiz standard to
manage it.

The idea is :
 * you define different invoice content type to identify the purpose of
a document for the invoice
 * you load your document as content
 * you link it with the good invoice content type.

You have many example on the framework like CustRequest, Party, Product
or CommunicationEvent

Have fun,
Nicolas

[1]
https://demo-trunk.ofbiz.apache.org/webtools/control/entity/find/InvoiceContent
On 17/10/2021 10:44, Marius Schmidt wrote:
> Is it possible to attach the original accounting documents to
> invoices? The ones, we got mailed or scanned ourselves?
>
> In the accounting software I used so far, we have some process like that:
>
>  * Bank account transactions enter the system via API
>  * Invoices arriving on the billing mail address are added as new
>    entries to an "accounting document list", stating they are to-do
>  * Other invoices and scans we upload to that list manually, also
>    making them new entries
>  * The accountant does his accounting stuff and relates bank account
>    transaction and accounting documents to a  certain ledger transaction
>
> That way I can easily review everything that happened based on a
> certain invoice document. How could the process look like in OfBiz?
>
> Best regards, have a nice weekend,
>
> Marius
>

Re: Attach original accounting documents to invoices

Hi Marius,

If you feel that this is a feature that would benefit all OFBiz adopters,
please raise a ticket in our JIRA.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 10:21 AM Nicolas Malin 
wrote:

> You have the entity InvoiceContent [1] that manage your case.
> At this time there is no native interface on the OFBiz standard to
> manage it.
>
> The idea is :
>  * you define different invoice content type to identify the purpose of
> a document for the invoice
>  * you load your document as content
>  * you link it with the good invoice content type.
>
> You have many example on the framework like CustRequest, Party, Product
> or CommunicationEvent
>
> Have fun,
> Nicolas
>
> [1]
>
> https://demo-trunk.ofbiz.apache.org/webtools/control/entity/find/InvoiceContent
> On 17/10/2021 10:44, Marius Schmidt wrote:
> > Is it possible to attach the original accounting documents to
> > invoices? The ones, we got mailed or scanned ourselves?
> >
> > In the accounting software I used so far, we have some process like that:
> >
> >  * Bank account transactions enter the system via API
> >  * Invoices arriving on the billing mail address are added as new
> >entries to an "accounting document list", stating they are to-do
> >  * Other invoices and scans we upload to that list manually, also
> >making them new entries
> >  * The accountant does his accounting stuff and relates bank account
> >transaction and accounting documents to a  certain ledger transaction
> >
> > That way I can easily review everything that happened based on a
> > certain invoice document. How could the process look like in OfBiz?
> >
> > Best regards, have a nice weekend,
> >
> > Marius
> >
>
>

Re: Internationalization Issue


Hi Emad,

Best practices:
https://cwiki.apache.org/confluence/display/OFBIZ/Text+Translation
https://cwiki.apache.org/confluence/display/OFBIZ/Tips+for+UI+labels+translation

HTH

Jacques

Le 21/10/2021 à 09:58, Pierre Smits a écrit :

Hi Emad,

Enumerations (like product type) and other data records are subject for
internationalisation. The translations for these can be found in the
various components in the config folder and EntityLabels.xml in the
filename.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Wed, Oct 20, 2021 at 9:26 PM Emad Radwan  wrote:


Hello Community,

Why the description field in list of value tables - e.g. Product_Type -
isn't also subject to translation in different languages? What are the best
practices here?

Regards,

Emad

Re: Attach original accounting documents to invoices


Hi Marius,

To raise a Jira you may follow: https://s.apache.org/dsj2p

HTH

Jacques


Le 21/10/2021 à 10:30, Pierre Smits a écrit :

Hi Marius,

If you feel that this is a feature that would benefit all OFBiz adopters,
please raise a ticket in our JIRA.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 10:21 AM Nicolas Malin 
wrote:


You have the entity InvoiceContent [1] that manage your case.
At this time there is no native interface on the OFBiz standard to
manage it.

The idea is :
  * you define different invoice content type to identify the purpose of
a document for the invoice
  * you load your document as content
  * you link it with the good invoice content type.

You have many example on the framework like CustRequest, Party, Product
or CommunicationEvent

Have fun,
Nicolas

[1]

https://demo-trunk.ofbiz.apache.org/webtools/control/entity/find/InvoiceContent
On 17/10/2021 10:44, Marius Schmidt wrote:

Is it possible to attach the original accounting documents to
invoices? The ones, we got mailed or scanned ourselves?

In the accounting software I used so far, we have some process like that:

  * Bank account transactions enter the system via API
  * Invoices arriving on the billing mail address are added as new
entries to an "accounting document list", stating they are to-do
  * Other invoices and scans we upload to that list manually, also
making them new entries
  * The accountant does his accounting stuff and relates bank account
transaction and accounting documents to a  certain ledger transaction

That way I can easily review everything that happened based on a
certain invoice document. How could the process look like in OfBiz?

Best regards, have a nice weekend,

Marius

Re: Order Approval

Hi Serge,

My apologies for the late reply.

Currently OFBiz doesn't have an integration for BPEL, allowing for complex
business rules to be invoked/executed on state changes of orders (given
particular attributes)  or on the classification of the customer within the
store.

However, as shown in [1] you can set the base order state in the orders
section.

[1]
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductStore?productStoreId=9000


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 14, 2021 at 12:17 PM Bs Serge  wrote:

> Hi Pierre,
>
> Sorry for the late reply, and thank you for your thorough reply
>
> Maybe this is configured in the Catalog module, but does it mean that in
> OFBiz those business policies and rules regarding order approval can be
> defined and enforced? Or does it require some custom development?
>
> Like saying: orders of this particular store or sales channel must be paid
> before delivery like it is on many e-commerce sites.
>
> Regarding the withdrawal, I don't think there is an issue, because, in my
> case, it's a credit card financial account and when I authorize and capture
> the payment for the order, the amount gets withdrawn automatically, but I
> can do that even after the order was approved.
>
> Best Regards,
>
> On Fri, Oct 8, 2021 at 2:04 PM Pierre Smits 
> wrote:
>
> > Hi Serge,
> >
> > I don't believe this is related to lacking accounting skills ;-)
> >
> > The (functional) reasoning why an order (I presume you're talking about a
> > sales order) can get approved while not having been paid for lies in
> > application of business policies and rules. These can dictate, for
> > instance, that an order can be paid on deliver of the goods ordered, or a
> > credit is granted by allowing to pay the invoice of the order after 30
> days
> > (payment term = 30 days net).
> >
> > Regarding the second aspect in your mail, the issue seems two-fold:
> >
> >1. order is created with payment through a financial account, and the
> >balance of the financial account is enough to pay for the order. This
> is
> >holding enough merit to approve the order.
> >2. order is created with payment through a financial account, but the
> >balance is not enough to pay for the order. In this case it should not
> > be
> >possible to approve the order (automatically). But there could still
> be
> >merit in approving the order given the size of it compared to overall
> >business done with the customer (the trust aspect).
> >
> > That the amount not being withdrawn from the financial account may be a
> > technical issue. If you feel this is the case with ootb functionality of
> > OFBiz, please register a ticket in our JIRA.
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > ORRTIZ.COM 
> > OFBiz based solutions & services
> >
> > On Fri, Oct 8, 2021 at 10:51 AM Bs Serge  wrote:
> >
> > > Hi,
> > >
> > > Maybe I lack some accounting skills,
> > >
> > > But why can an order get approved when it has not been paid for?
> > >
> > > I create an order to be paid by a party's financial account, the
> balance
> > is
> > > enough, but their order can be approved and the amount will not be
> > > withdrawn from the account automatically.
> > >
> > > Best Regards,
> > >
> >
>

Re: Inventory - Receive - Stock transfer and results

2021-10-21 Thread Wei Zhang

Regarding you 2nd Question, please read
https://www.moqui.org/m/docs/mantle/Mantle+Structure+and+UDM/Product#asset---receipt-mantleproductreceipt.
It can help you to understand how asset entities are designed.

On 2021/10/21, 3:14 AM, "pratyush Giri" wrote:

Hi Inventory Experts,

1st Question
===
I am trying to move a serialized product from one location in a facility to
another location in the same facility. What I observe is that the process
creates another inventory item with the same data where the location has been
changed from A to B. What surprises me is that the status on both the rows
shows up as INV_AVAILABLE and also the ATP and QOH both show 1. Looking at
this Entity it seems like I have 2 of the same items where I have only 1.

What am I reading wrong here and how this should be read?

2nd Question
===
I received the same product (say Prod-1) with the same lot (LOT-1)
twice., once with 100 and again with 50 quantities. So I received them twice
to the same location (bin/rack etc all same). I see that it creates 2 inventory
items with different quantities 1 row with 100 and another with 50). Now if I
receive them together, then it creates one inventory_item_id with quantity as
150. Why is this? Should it not be one inventory item id with quantity 150 and
it should not matter how I am receiving them. The way I am looking at inventory
item entity is that given a facility, location, and product, and a lot(if
exists), it should tell me how many of these items are available.

3rd Question
===
I want to have a 360-degree view of my products, i.e., how they came into
my facility, what has been done with them including stock and inventory
transfer, and finally where did they go (customer when s/he bought it). I do
not see an OOTB functionality for this (unless I am missing something). If
there is none, I can build this myself and so I am trying to understand the
data underneath.

Best,
Pratyush

Re: Urgent - Ofbiz Inventory Reservation Going Crazy - Please Help

2021-10-21 Thread Wei Zhang

Check which store your orders come from and then link your main 
warehouse/facility to that store.

On 2021/10/21, 4:55 AM, "Giulio Speri - MpStyle Srl"  
wrote:

Hello James,

Could you please share some more details on the context of usage of the
facilities?
Are you using them for an e-commerce site (facilities associated to a
Product storie) or you use them in totally different context?

Thanks,
Giulio

On Wed, Oct 20, 2021, 20:52  wrote:

>
> Good Afternoon.  We have one main warehouse and 5 virtual warehouse
> (i.e. damaged, In Transit, Repairs, etc).  Ofbiz seems to re - reserve
> after every order creation and it is constantly reserving product to
> these Virtual Warehouses.  How can I stop this from happening.  How can
> we simply have First Come First Serve unless we want to reprioritze a
> single order at a time.  This is causing a HUGE headache.  Any help is
> greatly appreciatedmy boss is ALL OVER ME with this issue
>
> Thanks,
>
> James
>

Re: Inventory - Receive - Stock transfer and results

Wei,

Please don't promote 3rd party products that have nothing to do with this
project.


Op do 21 okt. 2021 11:39 schreef Wei Zhang
:

> Regarding you 2nd Question, please read
> https://www.moqui.org/m/docs/mantle/Mantle+Structure+and+UDM/Product#asset---receipt-mantleproductreceipt.
> It can help you to understand how asset entities are designed.
>
>
> On 2021/10/21, 3:14 AM, "pratyush Giri" 
> wrote:
>
> Hi Inventory Experts,
>
>
> 1st Question
> ===
> I am trying to move a serialized product from one location in a
> facility to another location in the same facility. What I observe is that
> the process creates another inventory item with the same data where the
> location has been changed from A to B. What surprises me is that the status
> on both the rows shows up as  INV_AVAILABLE and also the ATP and QOH both
> show 1. Looking at this Entity it seems like I have 2 of the same items
> where I have only 1.
>
> What am I reading wrong here and how this should be read?
>
> 2nd Question
> ===
> I received the same product (say Prod-1)  with the same lot (LOT-1)
> twice., once with 100 and again with 50 quantities.  So I received them
> twice to the same location (bin/rack etc all same). I see that it creates 2
> inventory items with different quantities 1 row with 100 and another with
> 50). Now if I  receive them together, then it creates one inventory_item_id
> with quantity as 150. Why is this? Should it not be one inventory item id
> with quantity 150 and it should not matter how I am receiving them. The way
> I am looking at inventory item entity is that given a facility, location,
> and product, and a lot(if exists), it should tell me how many of these
> items are available.
>
>
> 3rd Question
> ===
> I want to have a 360-degree view of my products, i.e., how they came
> into my facility, what has been done with them including stock and
> inventory transfer, and finally where did they go (customer when s/he
> bought it). I do not see an OOTB functionality for this (unless I am
> missing something). If there is none, I can build this myself and so I am
> trying to understand the data underneath.
>
> Best,
> Pratyush
>
>
>
>
>
>
>
>

Re: Inventory - Receive - Stock transfer and results

Hi,

Your message has been moderated, else it would not have reached this Mailing
List.

Please subscribe to the user ML for such questions and then use your email
client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Also it's more work for moderators who have to accept your messages as long as
you have not subscribed.
I'll personally no longer accept them (other moderators still could).

Thanks

Jacques

Le 21/10/2021 à 03:11, Wei Zhang a écrit :

On 2021/10/21, 3:14 AM, "pratyush Giri" wrote:

Hi Inventory Experts,

1st Question
===
I am trying to move a serialized product from one location in a facility
to another location in the same facility. What I observe is that the process
creates another inventory item with the same data where the location has been
changed from A to B. What surprises me is that the status on both the rows
shows up as INV_AVAILABLE and also the ATP and QOH both show 1. Looking at
this Entity it seems like I have 2 of the same items where I have only 1.

What am I reading wrong here and how this should be read?

Best,
Pratyush

Re: Urgent - Ofbiz Inventory Reservation Going Crazy - Please Help

Hi,

Your message has been moderated, else it would not have reached this Mailing 
List.

Please subscribe to the user ML for such questions and then use your email 
client.
See why here http://ofbiz.apache.org/mailing-lists.html.

You will get a better support, people can answer you on the ML.
The wider the audience the better the answers you might get.

Also it's more work for moderators who have to accept your messages as long as 
you have not subscribed.
I'll personally no longer accept them (other moderators still could).

Thanks

Jacques

Le 21/10/2021 à 03:14, Wei Zhang a écrit :

Check which store your orders come from and then link your main 
warehouse/facility to that store.

On 2021/10/21, 4:55 AM, "Giulio Speri - MpStyle Srl"  
wrote:

 Hello James,

 Could you please share some more details on the context of usage of the
 facilities?
 Are you using them for an e-commerce site (facilities associated to a
 Product storie) or you use them in totally different context?

 Thanks,
 Giulio

 On Wed, Oct 20, 2021, 20:52  wrote:

 >
 > Good Afternoon.  We have one main warehouse and 5 virtual warehouse
 > (i.e. damaged, In Transit, Repairs, etc).  Ofbiz seems to re - reserve
 > after every order creation and it is constantly reserving product to
 > these Virtual Warehouses.  How can I stop this from happening.  How can
 > we simply have First Come First Serve unless we want to reprioritze a
 > single order at a time.  This is causing a HUGE headache.  Any help is
 > greatly appreciatedmy boss is ALL OVER ME with this issue
 >
 > Thanks,
 >
 > James
 >

Re: Party ID is null in HumanRes

Hello,
No i don´t have. When I create ofbiz without demo data I have nothing created. 

At the moment, i try to add the relationships to the entities. But i have a 
exception when i try to link the "LeadOwner(Personal Information)" and the 
"Group of Lead Owners(Party Group Information). But i get the following error: 

--Start Error--
The Following Errors Occurred:

Exception thrown while creating the "newEntity" GenericValue: 
org.apache.ofbiz.entity.GenericEntityException: Error while inserting: 
[GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21 
13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21 
13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21 
13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21 
13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21 
13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
 (SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP 
(PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, 
THRU_DATE, STATUS_ID, RELATION
 SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, 
PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, 
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a 
foreign key constraint fails (`ofbiz`.`party_relationship`, CONSTRAINT 
`PARTY_REL_FPROLE` FOREIGN KEY (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) 
REFERENCES `PARTY_ROLE` (`PARTY_ID`, `ROLE_TYPE_ID` (Error while inserting: 
[GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21 
13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21 
13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21 
13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21 
13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21 
13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
 
MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
 (SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP 
(PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE, 
THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID, 
PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS, 
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or 
update a child row: a foreign key constraint fails 
(`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN KEY 
(`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE` (`PARTY_ID`, 
`ROLE_TYPE_ID`)




-END Error ---

On 2021/10/21 08:11:31, Pierre Smits  wrote: 
> Hi Rodrigo,
> 
> Do you have the primary company in your data set? This needs to exist. Have
> a look at the demo data set, see the data regarding ' partyId="Company"/> and related.
> 
> Met vriendelijke groet,
> 
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz  since
> 2008 (without privileges)
> 
> *Apache Directory , PMC Member*
> Apache Incubator , committer
> Apache Steve , committer
> 
> 
> On Wed, Oct 20, 2021 at 4:19 PM Rodrigo Baptista <
> rodrigo.bapti...@binaroo.com> wrote:
> 
> > Hello,
> >
> > i have a problem with ofbiz. I installed the version 17.12 and 18.12 and i
> > have the same issue with both versions.
> >
> > What I do:
> >
> > 1. Installed Ofbiz with initial seed data. (./gradlew "ofbiz --load-data
> > readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin)
> > 2. Start ofbiz (./gradlew ofbiz)
> > 3. open HR View (/humanres/control/main)
> >
> > Now i have always a exception in my logs cause by the partyId is null:
> >
> > logs:
> >
> > Start Log-
> >
> > freemarker.core.InvalidReferenceException: The following has evaluated to
> > null or missing:
> > ==> partyId  [in template
> > "component://humanres/template/category/CategoryTree.ftl" at line 60,
> > column 44]
> > 
> > Tip: If the failing expression is known to legally refer to something
> > that's sometimes null or missing, either specify a default value like
> > myOptionalVar!myDefault, or use <#if
> > myOptionalVar??>when-present<#else>when-missing. (These only cover
> > the last

Re: Party ID is null in HumanRes

HI Rodrigo,
The error indicates that there is a mismatch between the partyIdFrom and
the roleTypeIdFrom. Please check the roles assigned to the party.

Also be aware, that the roleTypeId of the partyIdFrom (DemoLeadOwnersGroup)
seems incorrect. A group is - in directory parlance - an element below that
of the primary company (which in OFBiz should the roleTypeId
'INTERNAL_ORGANIZATIO').


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
rodrigo.bapti...@binaroo.com> wrote:

> Hello,
> No i don´t have. When I create ofbiz without demo data I have nothing
> created.
>
> At the moment, i try to add the relationships to the entities. But i have
> a exception when i try to link the "LeadOwner(Personal Information)" and
> the "Group of Lead Owners(Party Group Information). But i get the following
> error:
>
> --Start Error--
> The Following Errors Occurred:
>
> Exception thrown while creating the "newEntity" GenericValue:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> (SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
> (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
> THRU_DATE, STATUS_ID, RELATION
>  SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
> PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
> or update a child row: a foreign key constraint fails
> (`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN KEY
> (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE` (`PARTY_ID`,
> `ROLE_TYPE_ID` (Error while inserting:
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
>  
> MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> (SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
> (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
> THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SECURITY_GROUP_ID,
> PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID,
> POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz`.`party_relationship`, CONSTRAINT
> `PARTY_REL_FPROLE` FOREIGN KEY (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`)
> REFERENCES `PARTY_ROLE` (`PARTY_ID`, `ROLE_TYPE_ID`)
>
>
>
>
> -END Error ---
>
> On 2021/10/21 08:11:31, Pierre Smits  wrote:
> > Hi Rodrigo,
> >
> > Do you have the primary company in your data set? This needs to exist.
> Have
> > a look at the demo data set, see the data regarding ' > partyId="Company"/> and related.
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz 
> since
> > 2008 (without privileges)
> >
> > *Apache Directory , PMC Member*
> > Apache Incubator , committer
> > Apache Steve , committer
> >
> >
> > On Wed, Oct 20, 2021 at 4:19 PM Rodrigo Baptista <
> > rodrigo.bapti...@binaroo.com> wrote:
> >
> > > Hello,
> > >
> > > i have a problem with ofbiz. I installed the version 17.12 and 18.12
> and i
> > > have the

Re: Party ID is null in HumanRes


And note that it's 'INTERNAL_ORGANIZATIO' not 'INTERNAL_ORGANIZATION' for the 
sake of length in the DB (I got troubled by that when I started with OFBiz)

Le 21/10/2021 à 14:38, Pierre Smits a écrit :

HI Rodrigo,
The error indicates that there is a mismatch between the partyIdFrom and
the roleTypeIdFrom. Please check the roles assigned to the party.

Also be aware, that the roleTypeId of the partyIdFrom (DemoLeadOwnersGroup)
seems incorrect. A group is - in directory parlance - an element below that
of the primary company (which in OFBiz should the roleTypeId
'INTERNAL_ORGANIZATIO').


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
rodrigo.bapti...@binaroo.com> wrote:


Hello,
No i don´t have. When I create ofbiz without demo data I have nothing
created.

At the moment, i try to add the relationships to the entities. But i have
a exception when i try to link the "LeadOwner(Personal Information)" and
the "Group of Lead Owners(Party Group Information). But i get the following
error:

--Start Error--
The Following Errors Occurred:

Exception thrown while creating the "newEntity" GenericValue:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
(SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
(PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
THRU_DATE, STATUS_ID, RELATION
  SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
or update a child row: a foreign key constraint fails
(`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN KEY
(`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE` (`PARTY_ID`,
`ROLE_TYPE_ID` (Error while inserting:
[GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
  
MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
(SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
(PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SECURITY_GROUP_ID,
PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID,
POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
constraint fails (`ofbiz`.`party_relationship`, CONSTRAINT
`PARTY_REL_FPROLE` FOREIGN KEY (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`)
REFERENCES `PARTY_ROLE` (`PARTY_ID`, `ROLE_TYPE_ID`)




-END Error ---

On 2021/10/21 08:11:31, Pierre Smits  wrote:

Hi Rodrigo,

Do you have the primary company in your data set? This needs to exist.

Have

a look at the demo data set, see the data regarding ' and related.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz 

since

2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Wed, Oct 20, 2021 at 4:19 PM Rodrigo Baptista <
rodrigo.bapti...@binaroo.com> wrote:


Hello,

i have a problem with ofbiz. I installed the version 17.12 and 18.12

and i

have the same issu

Re: Party ID is null in HumanRes

Indeed. And as it is set in stone it can't be changed.


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 2:53 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> And note that it's 'INTERNAL_ORGANIZATIO' not 'INTERNAL_ORGANIZATION' for
> the sake of length in the DB (I got troubled by that when I started with
> OFBiz)
>
> Le 21/10/2021 à 14:38, Pierre Smits a écrit :
> > HI Rodrigo,
> > The error indicates that there is a mismatch between the partyIdFrom and
> > the roleTypeIdFrom. Please check the roles assigned to the party.
> >
> > Also be aware, that the roleTypeId of the partyIdFrom
> (DemoLeadOwnersGroup)
> > seems incorrect. A group is - in directory parlance - an element below
> that
> > of the primary company (which in OFBiz should the roleTypeId
> > 'INTERNAL_ORGANIZATIO').
> >
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz 
> since
> > 2008 (without privileges)
> >
> > *Apache Directory , PMC Member*
> > Apache Incubator , committer
> > Apache Steve , committer
> >
> >
> > On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
> > rodrigo.bapti...@binaroo.com> wrote:
> >
> >> Hello,
> >> No i don´t have. When I create ofbiz without demo data I have nothing
> >> created.
> >>
> >> At the moment, i try to add the relationships to the entities. But i
> have
> >> a exception when i try to link the "LeadOwner(Personal Information)" and
> >> the "Group of Lead Owners(Party Group Information). But i get the
> following
> >> error:
> >>
> >> --Start Error--
> >> The Following Errors Occurred:
> >>
> >> Exception thrown while creating the "newEntity" GenericValue:
> >> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> >>
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> >> 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> >> 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> >> 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> >> 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> >>
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> >> (SQL Exception while executing the following:INSERT INTO
> PARTY_RELATIONSHIP
> >> (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO,
> FROM_DATE,
> >> THRU_DATE, STATUS_ID, RELATION
> >>   SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
> >> PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE,
> COMMENTS,
> >> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP)
> >> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot
> add
> >> or update a child row: a foreign key constraint fails
> >> (`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN KEY
> >> (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE`
> (`PARTY_ID`,
> >> `ROLE_TYPE_ID` (Error while inserting:
> >>
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> >> 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> >> 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> >> 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> >> 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> >>
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
> >>
>  
> MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> >> (SQL Exception while executing the following:INSERT INTO
> PARTY_RELATIONSHIP
> >> (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO,
> FROM_DATE,
> >> THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SECURITY_GROUP_ID,
> >> PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID,
> >> POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> >> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?,
> >> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> >> constraint fails (`ofbiz`.`party_relationship`, CONSTRAINT
> >> `PARTY_REL_FPROLE` FOREIGN KEY (`PARTY_ID_FROM

Re: Party ID is null in HumanRes

Hey Pierre,

thanks for your help. The role in DemoLeadOwnersGroups was missing. I could 
create the relationship and this fixed the SQL exception but my main problem is 
still there.
I can´t see my company in the HR view. Do you have a documentation how to setup 
the system that I can see the Company in the HR view?

best regards,

Rodrigo Baptista

On 2021/10/21 12:38:23, Pierre Smits  wrote: 
> HI Rodrigo,
> The error indicates that there is a mismatch between the partyIdFrom and
> the roleTypeIdFrom. Please check the roles assigned to the party.
> 
> Also be aware, that the roleTypeId of the partyIdFrom (DemoLeadOwnersGroup)
> seems incorrect. A group is - in directory parlance - an element below that
> of the primary company (which in OFBiz should the roleTypeId
> 'INTERNAL_ORGANIZATIO').
> 
> 
> Met vriendelijke groet,
> 
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz  since
> 2008 (without privileges)
> 
> *Apache Directory , PMC Member*
> Apache Incubator , committer
> Apache Steve , committer
> 
> 
> On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
> rodrigo.bapti...@binaroo.com> wrote:
> 
> > Hello,
> > No i don´t have. When I create ofbiz without demo data I have nothing
> > created.
> >
> > At the moment, i try to add the relationships to the entities. But i have
> > a exception when i try to link the "LeadOwner(Personal Information)" and
> > the "Group of Lead Owners(Party Group Information). But i get the following
> > error:
> >
> > --Start Error--
> > The Following Errors Occurred:
> >
> > Exception thrown while creating the "newEntity" GenericValue:
> > org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> > [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> > 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> > (SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
> > (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
> > THRU_DATE, STATUS_ID, RELATION
> >  SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
> > PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE, COMMENTS,
> > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add
> > or update a child row: a foreign key constraint fails
> > (`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN KEY
> > (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE` (`PARTY_ID`,
> > `ROLE_TYPE_ID` (Error while inserting:
> > [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> > 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
> >  
> > MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> > (SQL Exception while executing the following:INSERT INTO PARTY_RELATIONSHIP
> > (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, FROM_DATE,
> > THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SECURITY_GROUP_ID,
> > PRIORITY_TYPE_ID, PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID,
> > POSITION_TITLE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> > CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> > ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> > constraint fails (`ofbiz`.`party_relationship`, CONSTRAINT
> > `PARTY_REL_FPROLE` FOREIGN KEY (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`)
> > REFERENCES `PARTY_ROLE` (`PARTY_ID`, `ROLE_TYPE_ID`)
> >
> >
> >
> >
> > -END Error ---
> >
> > On 2021/10/21 08:11:31, Pierre Smits  wrote:
> > > Hi Rodrigo,
> > >
> > > Do you have the primary company in your data set? This needs to exist.
> > Have
> > > a look at the demo data set, see the data regarding ' > > partyId="Company"/> and related.
> > >

Re: Party ID is null in HumanRes

HI Rodrigo,

Please have a look at one of the demo sites and the demo data included in
the code base regarding party relationships.

Not long ago I tried to improve the demo data set for the project, but
unfortunately that hit a brick wall.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 3:24 PM Rodrigo Baptista <
rodrigo.bapti...@binaroo.com> wrote:

> Hey Pierre,
>
> thanks for your help. The role in DemoLeadOwnersGroups was missing. I
> could create the relationship and this fixed the SQL exception but my main
> problem is still there.
> I can´t see my company in the HR view. Do you have a documentation how to
> setup the system that I can see the Company in the HR view?
>
> best regards,
>
> Rodrigo Baptista
>
> On 2021/10/21 12:38:23, Pierre Smits  wrote:
> > HI Rodrigo,
> > The error indicates that there is a mismatch between the partyIdFrom and
> > the roleTypeIdFrom. Please check the roles assigned to the party.
> >
> > Also be aware, that the roleTypeId of the partyIdFrom
> (DemoLeadOwnersGroup)
> > seems incorrect. A group is - in directory parlance - an element below
> that
> > of the primary company (which in OFBiz should the roleTypeId
> > 'INTERNAL_ORGANIZATIO').
> >
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz 
> since
> > 2008 (without privileges)
> >
> > *Apache Directory , PMC Member*
> > Apache Incubator , committer
> > Apache Steve , committer
> >
> >
> > On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
> > rodrigo.bapti...@binaroo.com> wrote:
> >
> > > Hello,
> > > No i don´t have. When I create ofbiz without demo data I have nothing
> > > created.
> > >
> > > At the moment, i try to add the relationships to the entities. But i
> have
> > > a exception when i try to link the "LeadOwner(Personal Information)"
> and
> > > the "Group of Lead Owners(Party Group Information). But i get the
> following
> > > error:
> > >
> > > --Start Error--
> > > The Following Errors Occurred:
> > >
> > > Exception thrown while creating the "newEntity" GenericValue:
> > > org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> > >
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> > >
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> > > (SQL Exception while executing the following:INSERT INTO
> PARTY_RELATIONSHIP
> > > (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO,
> FROM_DATE,
> > > THRU_DATE, STATUS_ID, RELATION
> > >  SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
> > > PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE,
> COMMENTS,
> > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP)
> > > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot
> add
> > > or update a child row: a foreign key constraint fails
> > > (`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN
> KEY
> > > (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE`
> (`PARTY_ID`,
> > > `ROLE_TYPE_ID` (Error while inserting:
> > >
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> > >
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_
> > >
> MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> > > (SQL Exception while executing the following:INSERT INTO
> PARTY_RELATIONSHIP
> > > (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO,
> FROM_DATE,
> > > THRU_DATE, STATUS_ID, RELATIONSHIP_NAME, SEC

Re: Party ID is null in HumanRes

2021-10-21 Thread Yashwant Dhakad

Hi Rodrigo,
In Human Resource screen, the partyId field is set from
defaultOrganizationPartyId and the defaultOrganizationPartyId is set from
userPreferences.ORGANIZATION_PARTY, can you please check your
UserPreference record for the logged-in user? The PartyRelationship record
gets for this default organization party id.

On Thu, Oct 21, 2021 at 7:04 PM Pierre Smits  wrote:

> HI Rodrigo,
>
> Please have a look at one of the demo sites and the demo data included in
> the code base regarding party relationships.
>
> Not long ago I tried to improve the demo data set for the project, but
> unfortunately that hit a brick wall.
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz  since
> 2008 (without privileges)
>
> *Apache Directory , PMC Member*
> Apache Incubator , committer
> Apache Steve , committer
>
>
> On Thu, Oct 21, 2021 at 3:24 PM Rodrigo Baptista <
> rodrigo.bapti...@binaroo.com> wrote:
>
> > Hey Pierre,
> >
> > thanks for your help. The role in DemoLeadOwnersGroups was missing. I
> > could create the relationship and this fixed the SQL exception but my
> main
> > problem is still there.
> > I can´t see my company in the HR view. Do you have a documentation how to
> > setup the system that I can see the Company in the HR view?
> >
> > best regards,
> >
> > Rodrigo Baptista
> >
> > On 2021/10/21 12:38:23, Pierre Smits  wrote:
> > > HI Rodrigo,
> > > The error indicates that there is a mismatch between the partyIdFrom
> and
> > > the roleTypeIdFrom. Please check the roles assigned to the party.
> > >
> > > Also be aware, that the roleTypeId of the partyIdFrom
> > (DemoLeadOwnersGroup)
> > > seems incorrect. A group is - in directory parlance - an element below
> > that
> > > of the primary company (which in OFBiz should the roleTypeId
> > > 'INTERNAL_ORGANIZATIO').
> > >
> > >
> > > Met vriendelijke groet,
> > >
> > > Pierre Smits
> > > *Proud* *contributor** of* Apache OFBiz 
> > since
> > > 2008 (without privileges)
> > >
> > > *Apache Directory , PMC Member*
> > > Apache Incubator , committer
> > > Apache Steve , committer
> > >
> > >
> > > On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
> > > rodrigo.bapti...@binaroo.com> wrote:
> > >
> > > > Hello,
> > > > No i don´t have. When I create ofbiz without demo data I have nothing
> > > > created.
> > > >
> > > > At the moment, i try to add the relationships to the entities. But i
> > have
> > > > a exception when i try to link the "LeadOwner(Personal Information)"
> > and
> > > > the "Group of Lead Owners(Party Group Information). But i get the
> > following
> > > > error:
> > > >
> > > > --Start Error--
> > > > The Following Errors Occurred:
> > > >
> > > > Exception thrown while creating the "newEntity" GenericValue:
> > > > org.apache.ofbiz.entity.GenericEntityException: Error while
> inserting:
> > > >
> >
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > > > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > > > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > > > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > > > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> > > >
> >
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> > > > (SQL Exception while executing the following:INSERT INTO
> > PARTY_RELATIONSHIP
> > > > (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO,
> > FROM_DATE,
> > > > THRU_DATE, STATUS_ID, RELATION
> > > >  SHIP_NAME, SECURITY_GROUP_ID, PRIORITY_TYPE_ID,
> > > > PARTY_RELATIONSHIP_TYPE_ID, PERMISSIONS_ENUM_ID, POSITION_TITLE,
> > COMMENTS,
> > > > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> > CREATED_TX_STAMP)
> > > > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot
> > add
> > > > or update a child row: a foreign key constraint fails
> > > > (`ofbiz`.`party_relationship`, CONSTRAINT `PARTY_REL_FPROLE` FOREIGN
> > KEY
> > > > (`PARTY_ID_FROM`, `ROLE_TYPE_ID_FROM`) REFERENCES `PARTY_ROLE`
> > (`PARTY_ID`,
> > > > `ROLE_TYPE_ID` (Error while inserting:
> > > >
> >
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > > > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > > > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > > > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > > > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21

Re: Party ID is null in HumanRes

Hi Yashwant,

IMO, that requirement seems to be a design flaw. It should not be so that
for each user working with OFBiz must have that set. If an HR official is
doing its work for multiple parties with the roleTypeId= 'INTERNAL_ORGANIZATIO'
(which is totally possible), then he/she needs to switch the user
preferences frequently.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz  since
2008 (without privileges)

*Apache Directory , PMC Member*
Apache Incubator , committer
Apache Steve , committer


On Thu, Oct 21, 2021 at 4:04 PM Yashwant Dhakad <
yashwant.dha...@hotwaxsystems.com> wrote:

> Hi Rodrigo,
> In Human Resource screen, the partyId field is set from
> defaultOrganizationPartyId and the defaultOrganizationPartyId is set from
> userPreferences.ORGANIZATION_PARTY, can you please check your
> UserPreference record for the logged-in user? The PartyRelationship record
> gets for this default organization party id.
>
> On Thu, Oct 21, 2021 at 7:04 PM Pierre Smits 
> wrote:
>
> > HI Rodrigo,
> >
> > Please have a look at one of the demo sites and the demo data included in
> > the code base regarding party relationships.
> >
> > Not long ago I tried to improve the demo data set for the project, but
> > unfortunately that hit a brick wall.
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz 
> since
> > 2008 (without privileges)
> >
> > *Apache Directory , PMC Member*
> > Apache Incubator , committer
> > Apache Steve , committer
> >
> >
> > On Thu, Oct 21, 2021 at 3:24 PM Rodrigo Baptista <
> > rodrigo.bapti...@binaroo.com> wrote:
> >
> > > Hey Pierre,
> > >
> > > thanks for your help. The role in DemoLeadOwnersGroups was missing. I
> > > could create the relationship and this fixed the SQL exception but my
> > main
> > > problem is still there.
> > > I can´t see my company in the HR view. Do you have a documentation how
> to
> > > setup the system that I can see the Company in the HR view?
> > >
> > > best regards,
> > >
> > > Rodrigo Baptista
> > >
> > > On 2021/10/21 12:38:23, Pierre Smits  wrote:
> > > > HI Rodrigo,
> > > > The error indicates that there is a mismatch between the partyIdFrom
> > and
> > > > the roleTypeIdFrom. Please check the roles assigned to the party.
> > > >
> > > > Also be aware, that the roleTypeId of the partyIdFrom
> > > (DemoLeadOwnersGroup)
> > > > seems incorrect. A group is - in directory parlance - an element
> below
> > > that
> > > > of the primary company (which in OFBiz should the roleTypeId
> > > > 'INTERNAL_ORGANIZATIO').
> > > >
> > > >
> > > > Met vriendelijke groet,
> > > >
> > > > Pierre Smits
> > > > *Proud* *contributor** of* Apache OFBiz 
> > > since
> > > > 2008 (without privileges)
> > > >
> > > > *Apache Directory , PMC Member*
> > > > Apache Incubator , committer
> > > > Apache Steve , committer
> > > >
> > > >
> > > > On Thu, Oct 21, 2021 at 1:56 PM Rodrigo Baptista <
> > > > rodrigo.bapti...@binaroo.com> wrote:
> > > >
> > > > > Hello,
> > > > > No i don´t have. When I create ofbiz without demo data I have
> nothing
> > > > > created.
> > > > >
> > > > > At the moment, i try to add the relationships to the entities. But
> i
> > > have
> > > > > a exception when i try to link the "LeadOwner(Personal
> Information)"
> > > and
> > > > > the "Group of Lead Owners(Party Group Information). But i get the
> > > following
> > > > > error:
> > > > >
> > > > > --Start Error--
> > > > > The Following Errors Occurred:
> > > > >
> > > > > Exception thrown while creating the "newEntity" GenericValue:
> > > > > org.apache.ofbiz.entity.GenericEntityException: Error while
> > inserting:
> > > > >
> > >
> >
> [GenericEntity:PartyRelationship][comments,null()][createdStamp,2021-10-21
> > > > > 13:34:43.291(java.sql.Timestamp)][createdTxStamp,2021-10-21
> > > > > 13:34:43.258(java.sql.Timestamp)][fromDate,2021-10-21
> > > > > 13:34:13.0(java.sql.Timestamp)][lastUpdatedStamp,2021-10-21
> > > > > 13:34:43.291(java.sql.Timestamp)][lastUpdatedTxStamp,2021-10-21
> > > > >
> > >
> >
> 13:34:43.258(java.sql.Timestamp)][partyIdFrom,DemoLeadOwnersGroup(java.lang.String)][partyIdTo,DemoLeadOwner(java.lang.String)][partyRelationshipTypeId,LEAD_OWN_GRP_MEMBER(java.lang.String)][roleTypeIdFrom,INTERNAL_ORGANIZATIO(java.lang.String)][roleTypeIdTo,OWNER(java.lang.String)][securityGroupId,null()][statusId,PARTYREL_CREATED(java.lang.String)][thruDate,null()]
> > > > > (SQL Exception while executing the following:INSERT INTO
> > > PARTY_RELATIONSHIP
> > > > > (PARTY_ID_FROM, PARTY_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO,
> > > FROM_DATE,
> > > > > THRU_DATE, STATUS_ID, RELAT

Detailed OFBiz Accounting Tutorial Available

2021-10-21 Thread Sharan Foga

Hi All

A while ago I put together a detailed accounting tutorial as an appendix for my 
Getting Started with Apache OFBiz Accounting book. Someone asked me about it 
recently and I have decided to give the tutorial to the project as part of the 
overall documentation. It was written in 2014 so the screenshots will look a 
bit different and some things may have changed but taking a quick look through 
I still think it could be useful to the community. 

I have loaded it onto the wiki here https://s.apache.org/a3szr

Happy reading and I hope it helps give people a bit more understanding of the 
accounting setup.

Thanks
Sharan

Re: Detailed OFBiz Accounting Tutorial Available

2021-10-21 Thread Emad Radwan

Hello Sharan,

Many thanks for sharing the detailed tutorial with the community.

Much appreciated,


Regards,
Emad.

> On 21 Oct 2021, at 7:10 PM, Sharan Foga  wrote:
> 
> Hi All
> 
> A while ago I put together a detailed accounting tutorial as an appendix for 
> my Getting Started with Apache OFBiz Accounting book. Someone asked me about 
> it recently and I have decided to give the tutorial to the project as part of 
> the overall documentation. It was written in 2014 so the screenshots will 
> look a bit different and some things may have changed but taking a quick look 
> through I still think it could be useful to the community. 
> 
> I have loaded it onto the wiki here https://s.apache.org/a3szr
> 
> Happy reading and I hope it helps give people a bit more understanding of the 
> accounting setup.
> 
> Thanks
> Sharan

Re: Detailed OFBiz Accounting Tutorial Available