ECA Custom Service
Hi all, Kindly help, I have the following ECA customization, I have simple questions just to clarify: : 1. Does it mean that the customized service will overtake the standard service, and the results of the customized service will be considered instead of standard service’s results. Yes or No? 2. Does it mean that the standard service is replaced by the customized service in all OFBiz operations? Yes or No? 3. In that ECA case, what if I want the standard service to run based on a parameter that is not in the service context in order to make a condition? I can add the parameter but I have to also make sure the parameter is present everywhere the service is called. So it becomes hierarchical. Is there another way to do it? Regards,
Sales Order Invoice Due in the future
Hi all, How to create a sales invoice to a customer for a placed order that has a due date of a certain specific date in the future? I can create an order separately and then create a sales invoice separately with the item, but I want that sales invoice to be related to the created order. There is a way to relate invoice items to an order as I can see in the invoice items table but I can't figure how to relate them even while adding invoice items. Best regards,
Re: Apache Shiro Error Message
Hi Jacopo, Yeah I finally figured that that’s whats happening and it was related to demo financial accounts created by default owned by the “Company” party group. And Yes there is a data migration which was done but it was a while back and I still have the original database. I also found an entity called “EntityKeyStore” with some keys in the table, all keys were migrated also. Best Regards,
Re: Apache Shiro Error Message
I found this line the stack trace, Caused by: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption. Full Stack Trace : https://paste.0xfc.de/?855ddf22ba0fbef4#Ef5Fom4VnGfb2XGvNEfK22A8AP5jt5KRMkuhSs4KuCeX Best regards, On Mon, Feb 7, 2022 at 10:45 PM Bs Serge wrote: > Hi all, > > Ofbiz 17.12, > Postgres Database, > > I'm getting this error when I try to find financial accounts in the UI and > I'm not familiar with Apache Shiro. So I'm wondering what could be the > reason for this? > > Any thoughts or comments would be appreciated! > > java.lang.IllegalArgumentException: Error running script at location > [component://webtools/groovyScripts/entity/FindGeneric.groovy]: > org.apache.ofbiz.base.util.GeneralRuntimeException: Error creating > GenericValue (org.apache.shiro.crypto.CryptoException: Unable to execute > 'doFinal' with cipher instance [javax.crypto.Cipher@205e8e3d]. (Unable to > execute 'doFinal' with cipher instance [javax.crypto.Cipher@205e8e3d].)) > > Best Regards, >
Apache Shiro Error Message
Hi all, Ofbiz 17.12, Postgres Database, I'm getting this error when I try to find financial accounts in the UI and I'm not familiar with Apache Shiro. So I'm wondering what could be the reason for this? Any thoughts or comments would be appreciated! java.lang.IllegalArgumentException: Error running script at location [component://webtools/groovyScripts/entity/FindGeneric.groovy]: org.apache.ofbiz.base.util.GeneralRuntimeException: Error creating GenericValue (org.apache.shiro.crypto.CryptoException: Unable to execute 'doFinal' with cipher instance [javax.crypto.Cipher@205e8e3d]. (Unable to execute 'doFinal' with cipher instance [javax.crypto.Cipher@205e8e3d].)) Best Regards,
Re: Creation of SecureRandom taking long time
Hi Jacques, Thanks for quick reply, the suggested JVM option solved my issue. Best regards, > On 10 Jan 2022, at 19:11, Jacques Le Roux > wrote: > > Notably using: | > | > > |-Djava.security.egd=/dev/./urandom| > > |if you are on *nix OS| > > Le 10/01/2022 à 18:08, Jacques Le Roux a écrit : >> Hi Serge, >> >> Did you try to follow advices at >> >> https://www.google.com/search?q=*WARNING%3A+Creation+of+SecureRandom+instance+for+session+ID+generation+using+%5BSHA1PRNG%5D+took&ie=UTF-8 >> >> ? >> >> HTH >> >> Jacques >> >> >> Le 10/01/2022 à 16:29, Bs Serge a écrit : >>> Hi all, >>> >>> While starting OFBiz, why does this step take a long time? up to 3 minutes >>> regardless of all the available memory, coz I'm running OFBiz with -Xmx11g >>> and Gradle daemon with -Xmx6g. >>> >>> 2022-01-10 15:15:23,641 |OFBiz-batch-3|ServiceContainer >>> |I| Created new dispatcher: entity-default >>> >>> >>> *Jan 10, 2022 3:18:10 PM org.apache.catalina.util.SessionIdGeneratorBase >>> createSecureRandom* >>> *WARNING: Creation of SecureRandom instance for session ID generation using >>> [SHA1PRNG] took [167,147] milliseconds.* >>> >>> 2022-01-10 15:18:10,553 |main |ServiceDispatcher >>>|I| Registering dispatcher: ebay >>> >>> >>> Kindly let me know if there is a way to mitigate this and make it faster. >>> >>> Best regards,
Re: Pass JVM options in ofbizBackground
For now, I had to edit JVM args in the build.gradle file but I don't know if thats the recommended way. regards,
Pass JVM options in ofbizBackground
Hi all, I'm starting OFBIZ in the background but I'm failing to add memory JVM options using below commands : ./gradlew ofbizBackground -PjvmArgs="-Xms1024m -Xmx11g" ./gradlew -Porg.gradle.jvmargs=-Xmx11g ofbizBackground Below is the command that ends up getting executed with Xms128M -Xmx1024M instead of specified -Xms1024m -Xmx11g in the command java -Xms128M -Xmx1024M -Dfile.encoding=UTF-8 -Duser.country -Duser.language=en -Duser.variant -cp /var/www/build/libs/ofbiz.jar org.apache.ofbiz.base.start.Start I found the above command in htop. Kindly let me know how to start OFBIZ in the background with JVM options. Best regards,
Creation of SecureRandom taking long time
Hi all, While starting OFBiz, why does this step take a long time? up to 3 minutes regardless of all the available memory, coz I'm running OFBiz with -Xmx11g and Gradle daemon with -Xmx6g. 2022-01-10 15:15:23,641 |OFBiz-batch-3|ServiceContainer |I| Created new dispatcher: entity-default *Jan 10, 2022 3:18:10 PM org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom* *WARNING: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [167,147] milliseconds.* 2022-01-10 15:18:10,553 |main |ServiceDispatcher |I| Registering dispatcher: ebay Kindly let me know if there is a way to mitigate this and make it faster. Best regards,
Log4j in OFBiz
Hi all, I’m sure all of you are aware of what’s going with the Log4j security vulnerability, If not then : - https://www.wired.com/story/log4j-flaw-hacking-internet/ - https://logging-apache-org.translate.goog/log4j/2.x/security.html?_x_tr_sl=de&_x_tr_tl=en&_x_tr_hl=en-US So some of us are wondering : Does this affect at least some versions of OFBiz? and What can one do to make sure that they are safe from this vulnerability? Best Regards,
Re: Make to Order Production Run
Thank you very much, Jacques, Zhang and Pierre The configurable PC order successfully generate a production run for the ordered product which is exactly what I was looking for. It's good to hear that after the production run is completed, and goods have moved into inventory, the order can be packed, shipped and invoiced all out-of-the-box. Thank you all again, Best Regards, On Sat, Dec 11, 2021 at 5:00 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Le 11/12/2021 à 15:03, Jacques Le Roux a écrit : > > > > https://www.youtube.com/watch?v=kGu8xI21VTg > Totally unrelated, sorry (but very good real ambient music from Hiroshi > Yoshimura) > > Jacques > >
Re: Make to Order Production Run
Hi, Any ideas on how this can be achieved would be appreciated! Basically it is to have a sales order linked with the manufacture of ordered products by the buyer/customer. Best Regards, On Wed, Dec 8, 2021 at 1:06 PM Bs Serge wrote: > Hi Pierre, > > I looked into the demo data, and I could see the pizza preparation routing > (Stock Out and Preparation routing tasks), as shown below, but that did not > answer my question except if i'm missing something. > > workEffortPurposeTypeId="ROU_ASSEMBLING" currentStatusId="ROU_ACTIVE" > workEffortName="Stock out" description="Components" revisionNumber="1" > fixedAssetId="DEMO_FOOD_GROUP" estimatedMilliSeconds="60" > estimatedSetupMillis="0"/> > workEffortPurposeTypeId="ROU_ASSEMBLING" currentStatusId="ROU_ACTIVE" > workEffortName="Preparation" description="Preparation" revisionNumber="1" > fixedAssetId="DEMO_FOOD_GROUP" estimatedMilliSeconds="90" > estimatedSetupMillis="0"/> > currentStatusId="ROU_ACTIVE" workEffortName="Pizza preparation" > description="Pizza preparation" revisionNumber="1" quantityToProduce="0"/> > workEffortGoodStdTypeId="ROU_PROD_TEMPLATE" statusId="WEGS_CREATED" > fromDate="2004-09-24 15:10:14.227"/> > workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="10" > fromDate="2004-09-24 15:09:38.736"/> > workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="20" > fromDate="2004-09-24 15:09:47.338"/> > > So I'm still wondering how can one have a sales order trigger a > manufacturing production run specifically for the buyer/customer. > > Best Regards, > > On Tue, Dec 7, 2021 at 10:57 AM Pierre Smits > wrote: > >> Good morning Serge, >> >> You can take a look at how (in demo) OFBiz provides functionalities for >> this. In the demo (datasets), this is done via the pizza examples. >> >> >> Met vriendelijke groet, >> >> Pierre Smits >> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since >> 2008 (without privileges) >> Proud contributor to the ASF since 2006 >> >> *Apache Directory <https://directory.apache.org>, PMC Member* >> >> >> On Mon, Dec 6, 2021 at 9:40 AM Bs Serge wrote: >> >> > Hi, >> > >> > Referring to the Manufacturing & MRP Tutorial (from Sharan Foga) It is >> > mentioned that OFBiz supports a Make to Order (MTO) process where the >> > manufacturing process is triggered by an order from a customer. The >> product >> > is manufactured specifically for that customer. >> > >> > In OFBiz I can start & complete production runs with routing tasks but >> I’m >> > having trouble connecting a product sales order with a production run. >> > >> > So I’m wondering how does that happen? How does a product sales order >> > trigger the manufacturing production run of a certain ordered product? >> > >> > Best Regards, >> > >> >
Re: Make to Order Production Run
Hi Pierre, I looked into the demo data, and I could see the pizza preparation routing (Stock Out and Preparation routing tasks), as shown below, but that did not answer my question except if i'm missing something. So I'm still wondering how can one have a sales order trigger a manufacturing production run specifically for the buyer/customer. Best Regards, On Tue, Dec 7, 2021 at 10:57 AM Pierre Smits wrote: > Good morning Serge, > > You can take a look at how (in demo) OFBiz provides functionalities for > this. In the demo (datasets), this is done via the pizza examples. > > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > On Mon, Dec 6, 2021 at 9:40 AM Bs Serge wrote: > > > Hi, > > > > Referring to the Manufacturing & MRP Tutorial (from Sharan Foga) It is > > mentioned that OFBiz supports a Make to Order (MTO) process where the > > manufacturing process is triggered by an order from a customer. The > product > > is manufactured specifically for that customer. > > > > In OFBiz I can start & complete production runs with routing tasks but > I’m > > having trouble connecting a product sales order with a production run. > > > > So I’m wondering how does that happen? How does a product sales order > > trigger the manufacturing production run of a certain ordered product? > > > > Best Regards, > > >
Make to Order Production Run
Hi, Referring to the Manufacturing & MRP Tutorial (from Sharan Foga) It is mentioned that OFBiz supports a Make to Order (MTO) process where the manufacturing process is triggered by an order from a customer. The product is manufactured specifically for that customer. In OFBiz I can start & complete production runs with routing tasks but I’m having trouble connecting a product sales order with a production run. So I’m wondering how does that happen? How does a product sales order trigger the manufacturing production run of a certain ordered product? Best Regards,
Re: Product Supplier & Store Agreement
That's kind of you Pierre, I can see the supplier for a product has a "minimum order quantity" which is the minimum number of units required for one purchase order, Is it possible to set the maximum order quantity also, so that the ordered quantity can not exceed the supplier's inventory? or does ofbiz assume the supplier to have any number of units quantity in their stock? Best Regards, On Tue, Nov 23, 2021 at 12:10 PM Pierre Smits wrote: > Miremengjes Serge, > > Good to see that the initial issue has been resolved. > > Please consider to elaborate on the accounting stuff your experiencing > (favourably in a new thread). A(other) contributor could provide some > insights on that. > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > On Tue, Nov 23, 2021 at 11:02 AM Bs Serge wrote: > > > Thank you Yashwant and Pierre. > > > > In the end, the model I was looking for is drop-shipping where a supplier > > can drop-ship a sales order from a buyer. Which I found ofbiz handles > > really well, by automatically creating a purchase order to the supplier, > > and the supplier ships the order to the original buyer. > > > > But I'm having trouble trying to grasp all the accounting stuff ... > > > > Best Regards, > > > > On Fri, Nov 19, 2021 at 9:45 AM Pierre Smits > > wrote: > > > > > Good morning Serge, > > > > > > I was thinking along the same lines as Yashwant did. With a commission > > > contract you should be able to generate a commission invoice for every > > sale > > > invoice including a line item that includes the product applicable. > > > > > > Please be aware, that the example data provided by Yashwant for > > > demonstrating this is not included in the standard demo data set of > > OFBiz. > > > You'll need to add that manually. > > > > > > If you have done so, you should be able to test this, by following > steps: > > > > > >1. create an sales invoice with a line item having the example > > product, > > >and have it with reach it - happy flow - status (Ready for Posting) > > >2. execute a commission run > > > > > > if that runs successfully, you should see a credit invoice for the > > > supplier, which can then, together with other invoices to be paid, go > > > normal payment processes > > > > > > Met vriendelijke groet, > > > > > > Pierre Smits > > > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> > > since > > > 2008 (without privileges) > > > Proud contributor to the ASF since 2006 > > > > > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > > > > > > > On Fri, Nov 19, 2021 at 7:02 AM Yashwant Dhakad < > > > yashwant.dha...@hotwaxsystems.com> wrote: > > > > > > > Hi Serge, > > > > We have Purchase and Commission agreement data model so that can be > > > helpful > > > > for your need. > > > > Here are the demo data you can explore: > > > > > > > > > > > agreementTypeId="PURCHASE_AGREEMENT" description="Agreement with > > > > DemoSupplier" partyIdFrom="Company" partyIdTo="DemoSupplier" > > > > fromDate="2011-08-02 12:00:00.0"/> > > > > > > > agreementItemTypeId="AGREEMENT_PRICING_PR" currencyUomId="USD"/> > > > > > > > agreementItemSeqId="1" price="8" productId="DS-1000"/> > > > > > > > > > > > description="Commission Agreement" partyIdFrom="DEMO_COMPANY" > > > > partyIdTo="DEMO_COMPANY1" roleTypeIdFrom="SUPPLIER" > > > > roleTypeIdTo="DISTRIBUTOR" fromDate="2016-09-29 00:00:00"/> > > > > > > > currencyUomId="USD" agreementItemTypeId="AGREEMENT_COMMISSION" > > > > agreementText="Commission in USD"/> > > > > > > > productId="TestProduct2"/> > > > > > > > agreementId="1010" agreementItemSeqId="0001" productId="TestProduct2" > > > > invoiceItemTypeId="COMM_INV_ITEM" fromDate="2016-09-29 00:00:00" > > > > thruDate="2017-09-29 00:00:00" termValue="10" termDays="30" > > > > minQuantity="1" maxQuantity="100" description="Agreement Term for > Test > > > > Product 2 Commission"/> > > > > > > > > > > > > On Fri, Nov 19, 2021 at 1:48 AM Bs Serge > wrote: > > > > > > > > > Hi, > > > > > > > > > > I wanted to ask is there an OFBiz way that a product supplier can > > have > > > an > > > > > agreement with a store over a certain product, so that, that > > supplier's > > > > > financial accounts should receive a certain percentage every time > > that > > > > > product is sold, or the whole amount can also go to the supplier? > > > > > > > > > > Any help on how this can be achieved would be appreciated! > > > > > > > > > > Best Regards, > > > > > > > > > > > > > > > > > -- > > > > 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 Supplier & Store Agreement
Thank you Yashwant and Pierre. In the end, the model I was looking for is drop-shipping where a supplier can drop-ship a sales order from a buyer. Which I found ofbiz handles really well, by automatically creating a purchase order to the supplier, and the supplier ships the order to the original buyer. But I'm having trouble trying to grasp all the accounting stuff ... Best Regards, On Fri, Nov 19, 2021 at 9:45 AM Pierre Smits wrote: > Good morning Serge, > > I was thinking along the same lines as Yashwant did. With a commission > contract you should be able to generate a commission invoice for every sale > invoice including a line item that includes the product applicable. > > Please be aware, that the example data provided by Yashwant for > demonstrating this is not included in the standard demo data set of OFBiz. > You'll need to add that manually. > > If you have done so, you should be able to test this, by following steps: > >1. create an sales invoice with a line item having the example product, >and have it with reach it - happy flow - status (Ready for Posting) >2. execute a commission run > > if that runs successfully, you should see a credit invoice for the > supplier, which can then, together with other invoices to be paid, go > normal payment processes > > Met vriendelijke groet, > > Pierre Smits > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since > 2008 (without privileges) > Proud contributor to the ASF since 2006 > > *Apache Directory <https://directory.apache.org>, PMC Member* > > > On Fri, Nov 19, 2021 at 7:02 AM Yashwant Dhakad < > yashwant.dha...@hotwaxsystems.com> wrote: > > > Hi Serge, > > We have Purchase and Commission agreement data model so that can be > helpful > > for your need. > > Here are the demo data you can explore: > > > > > agreementTypeId="PURCHASE_AGREEMENT" description="Agreement with > > DemoSupplier" partyIdFrom="Company" partyIdTo="DemoSupplier" > > fromDate="2011-08-02 12:00:00.0"/> > > > agreementItemTypeId="AGREEMENT_PRICING_PR" currencyUomId="USD"/> > > > agreementItemSeqId="1" price="8" productId="DS-1000"/> > > > > > description="Commission Agreement" partyIdFrom="DEMO_COMPANY" > > partyIdTo="DEMO_COMPANY1" roleTypeIdFrom="SUPPLIER" > > roleTypeIdTo="DISTRIBUTOR" fromDate="2016-09-29 00:00:00"/> > > > currencyUomId="USD" agreementItemTypeId="AGREEMENT_COMMISSION" > > agreementText="Commission in USD"/> > > > productId="TestProduct2"/> > > > agreementId="1010" agreementItemSeqId="0001" productId="TestProduct2" > > invoiceItemTypeId="COMM_INV_ITEM" fromDate="2016-09-29 00:00:00" > > thruDate="2017-09-29 00:00:00" termValue="10" termDays="30" > > minQuantity="1" maxQuantity="100" description="Agreement Term for Test > > Product 2 Commission"/> > > > > > > On Fri, Nov 19, 2021 at 1:48 AM Bs Serge wrote: > > > > > Hi, > > > > > > I wanted to ask is there an OFBiz way that a product supplier can have > an > > > agreement with a store over a certain product, so that, that supplier's > > > financial accounts should receive a certain percentage every time that > > > product is sold, or the whole amount can also go to the supplier? > > > > > > Any help on how this can be achieved would be appreciated! > > > > > > Best Regards, > > > > > > > > > -- > > Kind Regards, > > Yashwant Dhakad > > Sr. Technical Consultant > > > > *HotWax Systems* > > *Enterprise open source experts* > > cell: +91-9098240513 > > office: 0731-409-3684 > > http://www.hotwaxsystems.com > > >
Product Supplier & Store Agreement
Hi, I wanted to ask is there an OFBiz way that a product supplier can have an agreement with a store over a certain product, so that, that supplier's financial accounts should receive a certain percentage every time that product is sold, or the whole amount can also go to the supplier? Any help on how this can be achieved would be appreciated! Best Regards,
Re: cleanAll loadAll
don't bother. solved. it was my issue. Best Regards, On Wed, Nov 10, 2021 at 12:57 PM Bs Serge wrote: > The version is: Ofbiz 17.12 > Database : MySQL 8 > > > On Wed, Nov 10, 2021 at 12:56 PM Bs Serge wrote: > >> Hi >> >> What do you think could be the cause of this exception after running: >> ./gradlew cleanAll loadAll? >> >> The system is looking for a table obviously which have not been created >> yet? >> >> Kindly any help would be appreciated! >> >> Best regards, >> >> 2021-11-10 12:53:0Caused by: >> org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while >> executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM >> SECURITY_PERMISSION WHERE PERMISSION_ID=? (Table >> 'ofbiz.security_permis0,593 |main |TransactionUtil >> |I| Transaction rolled back >> sion' doesn't exist) >> at >> org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) >> at >> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:490) >> at >> org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466) >> at >> org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81) >> at >> org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1317) >> ... 13 more >> Caused by: java.sql.SQLSyntaxErrorException: Table >> 'ofbiz.security_permission' doesn't exist >> at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) >> at >> com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) >> at >> com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) >> at >> com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009) >> at >> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) >> at >> org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) >> at >> org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) >> ... 17 more >> :ofbiz --load-data FAILED >> >
Re: cleanAll loadAll
The version is: Ofbiz 17.12 Database : MySQL 8 On Wed, Nov 10, 2021 at 12:56 PM Bs Serge wrote: > Hi > > What do you think could be the cause of this exception after running: > ./gradlew cleanAll loadAll? > > The system is looking for a table obviously which have not been created > yet? > > Kindly any help would be appreciated! > > Best regards, > > 2021-11-10 12:53:0Caused by: > org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while > executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM > SECURITY_PERMISSION WHERE PERMISSION_ID=? (Table > 'ofbiz.security_permis0,593 |main |TransactionUtil > |I| Transaction rolled back > sion' doesn't exist) > at > org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) > at > org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:490) > at > org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466) > at > org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81) > at > org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1317) > ... 13 more > Caused by: java.sql.SQLSyntaxErrorException: Table > 'ofbiz.security_permission' doesn't exist > at > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) > at > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) > at > com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) > at > com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) > at > org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) > at > org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) > ... 17 more > :ofbiz --load-data FAILED >
cleanAll loadAll
Hi What do you think could be the cause of this exception after running: ./gradlew cleanAll loadAll? The system is looking for a table obviously which have not been created yet? Kindly any help would be appreciated! Best regards, 2021-11-10 12:53:0Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_PERMISSION WHERE PERMISSION_ID=? (Table 'ofbiz.security_permis0,593 |main |TransactionUtil |I| Transaction rolled back sion' doesn't exist) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) at org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:490) at org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81) at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1317) ... 13 more Caused by: java.sql.SQLSyntaxErrorException: Table 'ofbiz.security_permission' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ... 17 more :ofbiz --load-data FAILED
Re: Product and Store Relationship
Hi Giulio, Thank you soo much, the PHYSICAL INVENTORY makes it so easy I didn't know it, but also after ordering the product, I went to the created order page at the right sidebar "Actions" and clicked "Quick Ship Order" and then a shipment was created with a "shipped" status and the inventory *QOH* was changed also with *AQT.* I can not thank you enough guys, I owe you a beer or something :)) Best Regards, On Wed, Oct 27, 2021 at 6:56 PM Giulio Speri - MpStyle Srl < giulio.sp...@mpstyle.it> wrote: > Hello Serge, > > stock availability of products are defined by InventoryItem entity. > An InventoryItem object can be created for a product from the INVENTORY tab > of the target product and click on "Create new Inventory Item for this > product" button in the lower panel of the screen (the one named "Inventory > Items for "). > > Stock is handled by two fields of this InventoryItem object: > availableToPromiseTotal (also referred as ATP) and quantityOnHandTotal > (QOH). > The value of quantityOnHandTotal is the number of products you > physically have in your warehouse regardless of how many of them are > effectively available to customers for orders. > The value of availableToPromiseTotal is, in short, the quantityOnHandTotal > minus product reserved in other sales orders. > > For example: > I have a product A with initial ATP/QOH of 2. > A customer places a sales order of 1 quantity: the moment the order is > created, the ATP value of the product is lowered by 1 (the quantity of the > order) and that means that another 1 piece is available for a sales order. > Until the order is "open" (created/approved) state the QOH is not changed: > it will be updated in the moment you complete/ship the order. > > This is in short and in a very simple way an explanation of how stock is > managed for sales orders in OFBiz. > > An InventoryItem is related to a Facility through a specific field > *facilityId* : that is used to indicate that a specific product is > available in a certain facility. > > To put stock in an InventoryItem, you can use the OOTB functionality > provided in the PHYSICAL INVENTORY tab of Facility Manager, where you > search for a specific product and then commit a plus or minus movement for > ATP/QOH on an inventory item object. > > A Facility then is associated with a ProductStore and with this relation, > orders placed on that store will reserve inventory from that facility > (still here I simplified the thing). > > InventoryItem handling could be quite tricky, but I hope I gave you a good > sight on how they work. > As Micheal suggested, in the DataModel resource book you can find more > details on how this entity was thinked. > > Regards, > Giulio > > Il giorno mer 27 ott 2021 alle ore 18:13 Bs Serge ha > scritto: > > > Hi Michael, > > > > These data models are amazing! You are a lifesaver! and I think I got my > > answer! > > > > I hope this is my last question : How do you define how many products are > > available in stock? > > > > Thank you again! > > > > Best Regards, > > > > On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl > > wrote: > > > > > Hi, > > > > > > in addition to the other recommendations, I strongly recommend to have > a > > > look at the OFBiz data model book which shows the data model in-depth. > > > > > > See > > https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams > > > > > > There you will see that the products are mapped to the ProductCategory > > > through the ProductCategoryMember entity. The category structure is > > > build by the productCategoryRollup entities and the top-most category > is > > > mapped to the ProdCatalog through ProdCatalogCategory and finally the > > > ProdCatalog ist mapped to the productStore through ProductStoreCatalog. > > > > > > While you can reuse categories with different roll-ups, you cannot have > > > the SAME category containing other products when used with another > > > ProductStore. > > > > > > You surely can build up a SIMILAR category structure twice and map this > > > to the catalog/store to achieve your goal. > > > > > > Best regards, > > > > > > Michael Brohl > > > > > > ecomify GmbH - www.ecomify.de > > > > > > > > > Am 26.10.21 um 18:56 schrieb Bs Serge: > > > > Thank you Jacques for the link, > > > > > > > > Kindly, can different stores use the same category structure with > > > diff
Re: Product and Store Relationship
Never mind, I see it is done in the facility/inventory module. On Wed, Oct 27, 2021 at 6:12 PM Bs Serge wrote: > Hi Michael, > > These data models are amazing! You are a lifesaver! and I think I got my > answer! > > I hope this is my last question : How do you define how many products are > available in stock? > > Thank you again! > > Best Regards, > > On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl > wrote: > >> Hi, >> >> in addition to the other recommendations, I strongly recommend to have a >> look at the OFBiz data model book which shows the data model in-depth. >> >> See https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams >> >> There you will see that the products are mapped to the ProductCategory >> through the ProductCategoryMember entity. The category structure is >> build by the productCategoryRollup entities and the top-most category is >> mapped to the ProdCatalog through ProdCatalogCategory and finally the >> ProdCatalog ist mapped to the productStore through ProductStoreCatalog. >> >> While you can reuse categories with different roll-ups, you cannot have >> the SAME category containing other products when used with another >> ProductStore. >> >> You surely can build up a SIMILAR category structure twice and map this >> to the catalog/store to achieve your goal. >> >> Best regards, >> >> Michael Brohl >> >> ecomify GmbH - www.ecomify.de >> >> >> Am 26.10.21 um 18:56 schrieb Bs Serge: >> > Thank you Jacques for the link, >> > >> > Kindly, can different stores use the same category structure with >> different >> > products, Or do categories have to be created for each store? >> > >> > Thanks again >> > >> > Best Regards, >> > >> > >> > On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux < >> > jacques.le.r...@les7arts.com> wrote: >> > >> >> Hi Serge, >> >> >> >> This is old and in French, but I think it can still help >> >> >> >> >> >> >> http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190 >> >> >> >> Jacques >> >> >> >> Le 26/10/2021 à 11:48, Bs Serge a écrit : >> >>> Lastly and most importantly I'd like to ask, >> >>> >> >>> Can different stores have the same category structure but with >> different >> >>> products? >> >>> >> >>> Best Regards, >> >>> >> >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge >> wrote: >> >>> >> >>>> Hi Giulio, >> >>>> >> >>>> You have been more than helpful to help me understand this, >> >>>> >> >>>> Regarding the “Browser Root”, it seems like there are different >> Product >> >>>> Category Types (Best Selling, Catalog, Search, …) which I see >> defines >> >> the >> >>>> categories that are directly linked to catalogs in different Product >> >>>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default >> >> Search) >> >>>> For Example in the “Demo Catalog”, in its Categories, there is a >> >> category >> >>>> called “CATALOG1” of Browser Root, and that category is of Product >> >> Category >> >>>> Type “Catalog”, and I see it act as a parent of two other categories >> of >> >> Ids >> >>>> 100 and 200 which both are also of Category Type “Catalog”, which >> goes >> >> on >> >>>> to create a Tree of categories >> >>>> >> >>>> Does it mean that the Product Category Type of Catalog is also like a >> >>>> group of categories per se ,.. ? >> >>>> >> >>>> If so, one would directly wonder what is the role of other Product >> >>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base, >> >>>> Industry, Internal, ... )? >> >>>> >> >>>> Thank you again, >> >>>> >> >>>> Best Regards, >> >>>> >> >>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl < >> >>>> giulio.sp...@mpstyle.it> wrote: >> >>>> >> >>>>> Hello Serge, >> >>>
Re: Product and Store Relationship
Hi Michael, These data models are amazing! You are a lifesaver! and I think I got my answer! I hope this is my last question : How do you define how many products are available in stock? Thank you again! Best Regards, On Tue, Oct 26, 2021 at 9:01 PM Michael Brohl wrote: > Hi, > > in addition to the other recommendations, I strongly recommend to have a > look at the OFBiz data model book which shows the data model in-depth. > > See https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams > > There you will see that the products are mapped to the ProductCategory > through the ProductCategoryMember entity. The category structure is > build by the productCategoryRollup entities and the top-most category is > mapped to the ProdCatalog through ProdCatalogCategory and finally the > ProdCatalog ist mapped to the productStore through ProductStoreCatalog. > > While you can reuse categories with different roll-ups, you cannot have > the SAME category containing other products when used with another > ProductStore. > > You surely can build up a SIMILAR category structure twice and map this > to the catalog/store to achieve your goal. > > Best regards, > > Michael Brohl > > ecomify GmbH - www.ecomify.de > > > Am 26.10.21 um 18:56 schrieb Bs Serge: > > Thank you Jacques for the link, > > > > Kindly, can different stores use the same category structure with > different > > products, Or do categories have to be created for each store? > > > > Thanks again > > > > Best Regards, > > > > > > On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > >> Hi Serge, > >> > >> This is old and in French, but I think it can still help > >> > >> > >> > http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190 > >> > >> Jacques > >> > >> Le 26/10/2021 à 11:48, Bs Serge a écrit : > >>> Lastly and most importantly I'd like to ask, > >>> > >>> Can different stores have the same category structure but with > different > >>> products? > >>> > >>> Best Regards, > >>> > >>> On Tue, Oct 26, 2021 at 11:04 AM Bs Serge wrote: > >>> > >>>> Hi Giulio, > >>>> > >>>> You have been more than helpful to help me understand this, > >>>> > >>>> Regarding the “Browser Root”, it seems like there are different > Product > >>>> Category Types (Best Selling, Catalog, Search, …) which I see defines > >> the > >>>> categories that are directly linked to catalogs in different Product > >>>> Catalog Category Types (Browser Root, Promotion, Quick Add, Default > >> Search) > >>>> For Example in the “Demo Catalog”, in its Categories, there is a > >> category > >>>> called “CATALOG1” of Browser Root, and that category is of Product > >> Category > >>>> Type “Catalog”, and I see it act as a parent of two other categories > of > >> Ids > >>>> 100 and 200 which both are also of Category Type “Catalog”, which goes > >> on > >>>> to create a Tree of categories > >>>> > >>>> Does it mean that the Product Category Type of Catalog is also like a > >>>> group of categories per se ,.. ? > >>>> > >>>> If so, one would directly wonder what is the role of other Product > >>>> Category Types (Best Selling, Search, Tax, Quick Add, Google Base, > >>>> Industry, Internal, ... )? > >>>> > >>>> Thank you again, > >>>> > >>>> Best Regards, > >>>> > >>>> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl < > >>>> giulio.sp...@mpstyle.it> wrote: > >>>> > >>>>> Hello Serge, > >>>>> > >>>>> in OFBiz there is not a direct association between a ProductStore and > >>>>> products, instead ProdCatalog, ProdCatalogCategory, > >> ProductStoreCatalog, > >>>>> ProductCategory and ProductCategoryMember entities are used to > achieve > >>>>> this > >>>>> goal. > >>>>> > >>>>> You can see the ProdCatalog as a collector of categories: the one > that > >> is > >>>>> physically associated with a product store is the ProdCatalog through > >
Re: Product and Store Relationship
Thank you Jacques for the link, Kindly, can different stores use the same category structure with different products, Or do categories have to be created for each store? Thanks again Best Regards, On Tue, Oct 26, 2021 at 1:36 PM Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Serge, > > This is old and in French, but I think it can still help > > > http://www.les7arts.com/assist/OFBiz/Creation%20Catalogue%20de%20produits.htm#_bookmark_551a190 > > Jacques > > Le 26/10/2021 à 11:48, Bs Serge a écrit : > > Lastly and most importantly I'd like to ask, > > > > Can different stores have the same category structure but with different > > products? > > > > Best Regards, > > > > On Tue, Oct 26, 2021 at 11:04 AM Bs Serge wrote: > > > >> Hi Giulio, > >> > >> You have been more than helpful to help me understand this, > >> > >> Regarding the “Browser Root”, it seems like there are different Product > >> Category Types (Best Selling, Catalog, Search, …) which I see defines > the > >> categories that are directly linked to catalogs in different Product > >> Catalog Category Types (Browser Root, Promotion, Quick Add, Default > Search) > >> > >> For Example in the “Demo Catalog”, in its Categories, there is a > category > >> called “CATALOG1” of Browser Root, and that category is of Product > Category > >> Type “Catalog”, and I see it act as a parent of two other categories of > Ids > >> 100 and 200 which both are also of Category Type “Catalog”, which goes > on > >> to create a Tree of categories > >> > >> Does it mean that the Product Category Type of Catalog is also like a > >> group of categories per se ,.. ? > >> > >> If so, one would directly wonder what is the role of other Product > >> Category Types (Best Selling, Search, Tax, Quick Add, Google Base, > >> Industry, Internal, ... )? > >> > >> Thank you again, > >> > >> Best Regards, > >> > >> On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl < > >> giulio.sp...@mpstyle.it> wrote: > >> > >>> Hello Serge, > >>> > >>> in OFBiz there is not a direct association between a ProductStore and > >>> products, instead ProdCatalog, ProdCatalogCategory, > ProductStoreCatalog, > >>> ProductCategory and ProductCategoryMember entities are used to achieve > >>> this > >>> goal. > >>> > >>> You can see the ProdCatalog as a collector of categories: the one that > is > >>> physically associated with a product store is the ProdCatalog through > the > >>> entity ProductStoreCatalog. > >>> A product catalog is composed by a hierarchy of categories where the > first > >>> (root category) always has to be of type "Browse Root" > (PCCT_BROWSE_ROOT). > >>> This is managed by the entity ProdCatalogCategory. > >>> Under the "Browse Root" category you can then build your own custom > >>> hierarchy of product categories and associate the product to each one > of > >>> it; ProductCategory is the entity used to define a category and a > product > >>> is associated to a specific category through the entity > >>> ProductCategoryMember. > >>> > >>> *In short*: > >>> > >>> ProductStore/Catalog assoc : ProductStore -> ProdCatalog -> > >>> ProductCatalogCategory (Browse Root) > >>> > >>> Browse Root Category/Product categories: > >>> - ProductCategory (Browse Root) > >>> -- productCategory_1 -> Products (through ProductCategoryMember); > >>> -- productCategory_2 -> Products; > >>> ---productSubCategory_2_1 -> Products; > >>> ---productSubCategory_2_2 -> Products; > >>> -- productCategory_3 -> Products; > >>> > >>> In the online backend demo of OFBiz you can start following this > structure > >>> from the Catalog Manager -> Stores, pick up a store and then open the > tab > >>> "CATALOGS". > >>> You will find different examples of stores and catalogs with different > >>> categories associated, that can give you a good starting point on the > >>> store/catalog/category/product OOTB mechanism. > >>> > >>> I hope I have been helpful. > >>> > >>> Kind Regards, > >>> Giulio > >>> > >>> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge > > >>> ha > >>> scritto: > >>> > >>>> Hi, > >>>> > >>>> I was browsing through the catalog module and I could not find any > >>> product > >>>> and store relationship. > >>>> > >>>> I would assume products are supposed to belong in a certain store! > >>>> > >>>> Kindly enlighten me on how OFBiz handles products and stores > >>> relationships, > >>>> or point me to a link that explains it. > >>>> > >>>> Thanks, > >>>> > >>>> Best Regards, > >>>> > >>> > >>> -- > >>> Giulio Speri > >>> > >>> > >>> *Mp Styl**e Srl* > >>> via Antonio Meucci, 37 > >>> 41019 Limidi di Soliera (MO) > >>> T 059/684916 > >>> M 347/0965506 > >>> > >>> www.mpstyle.it > >>> >
Re: Product and Store Relationship
Lastly and most importantly I'd like to ask, Can different stores have the same category structure but with different products? Best Regards, On Tue, Oct 26, 2021 at 11:04 AM Bs Serge wrote: > Hi Giulio, > > You have been more than helpful to help me understand this, > > Regarding the “Browser Root”, it seems like there are different Product > Category Types (Best Selling, Catalog, Search, …) which I see defines the > categories that are directly linked to catalogs in different Product > Catalog Category Types (Browser Root, Promotion, Quick Add, Default Search) > > For Example in the “Demo Catalog”, in its Categories, there is a category > called “CATALOG1” of Browser Root, and that category is of Product Category > Type “Catalog”, and I see it act as a parent of two other categories of Ids > 100 and 200 which both are also of Category Type “Catalog”, which goes on > to create a Tree of categories > > Does it mean that the Product Category Type of Catalog is also like a > group of categories per se ,.. ? > > If so, one would directly wonder what is the role of other Product > Category Types (Best Selling, Search, Tax, Quick Add, Google Base, > Industry, Internal, ... )? > > Thank you again, > > Best Regards, > > On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl < > giulio.sp...@mpstyle.it> wrote: > >> Hello Serge, >> >> in OFBiz there is not a direct association between a ProductStore and >> products, instead ProdCatalog, ProdCatalogCategory, ProductStoreCatalog, >> ProductCategory and ProductCategoryMember entities are used to achieve >> this >> goal. >> >> You can see the ProdCatalog as a collector of categories: the one that is >> physically associated with a product store is the ProdCatalog through the >> entity ProductStoreCatalog. >> A product catalog is composed by a hierarchy of categories where the first >> (root category) always has to be of type "Browse Root" (PCCT_BROWSE_ROOT). >> This is managed by the entity ProdCatalogCategory. >> Under the "Browse Root" category you can then build your own custom >> hierarchy of product categories and associate the product to each one of >> it; ProductCategory is the entity used to define a category and a product >> is associated to a specific category through the entity >> ProductCategoryMember. >> >> *In short*: >> >> ProductStore/Catalog assoc : ProductStore -> ProdCatalog -> >> ProductCatalogCategory (Browse Root) >> >> Browse Root Category/Product categories: >> - ProductCategory (Browse Root) >> -- productCategory_1 -> Products (through ProductCategoryMember); >> -- productCategory_2 -> Products; >> ---productSubCategory_2_1 -> Products; >> ---productSubCategory_2_2 -> Products; >> -- productCategory_3 -> Products; >> >> In the online backend demo of OFBiz you can start following this structure >> from the Catalog Manager -> Stores, pick up a store and then open the tab >> "CATALOGS". >> You will find different examples of stores and catalogs with different >> categories associated, that can give you a good starting point on the >> store/catalog/category/product OOTB mechanism. >> >> I hope I have been helpful. >> >> Kind Regards, >> Giulio >> >> Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge >> ha >> scritto: >> >> > Hi, >> > >> > I was browsing through the catalog module and I could not find any >> product >> > and store relationship. >> > >> > I would assume products are supposed to belong in a certain store! >> > >> > Kindly enlighten me on how OFBiz handles products and stores >> relationships, >> > or point me to a link that explains it. >> > >> > Thanks, >> > >> > Best Regards, >> > >> >> >> -- >> Giulio Speri >> >> >> *Mp Styl**e Srl* >> via Antonio Meucci, 37 >> 41019 Limidi di Soliera (MO) >> T 059/684916 >> M 347/0965506 >> >> www.mpstyle.it >> >
Re: Product and Store Relationship
Hi Giulio, You have been more than helpful to help me understand this, Regarding the “Browser Root”, it seems like there are different Product Category Types (Best Selling, Catalog, Search, …) which I see defines the categories that are directly linked to catalogs in different Product Catalog Category Types (Browser Root, Promotion, Quick Add, Default Search) For Example in the “Demo Catalog”, in its Categories, there is a category called “CATALOG1” of Browser Root, and that category is of Product Category Type “Catalog”, and I see it act as a parent of two other categories of Ids 100 and 200 which both are also of Category Type “Catalog”, which goes on to create a Tree of categories Does it mean that the Product Category Type of Catalog is also like a group of categories per se ,.. ? If so, one would directly wonder what is the role of other Product Category Types (Best Selling, Search, Tax, Quick Add, Google Base, Industry, Internal, ... )? Thank you again, Best Regards, On Mon, Oct 25, 2021 at 7:20 PM Giulio Speri - MpStyle Srl < giulio.sp...@mpstyle.it> wrote: > Hello Serge, > > in OFBiz there is not a direct association between a ProductStore and > products, instead ProdCatalog, ProdCatalogCategory, ProductStoreCatalog, > ProductCategory and ProductCategoryMember entities are used to achieve this > goal. > > You can see the ProdCatalog as a collector of categories: the one that is > physically associated with a product store is the ProdCatalog through the > entity ProductStoreCatalog. > A product catalog is composed by a hierarchy of categories where the first > (root category) always has to be of type "Browse Root" (PCCT_BROWSE_ROOT). > This is managed by the entity ProdCatalogCategory. > Under the "Browse Root" category you can then build your own custom > hierarchy of product categories and associate the product to each one of > it; ProductCategory is the entity used to define a category and a product > is associated to a specific category through the entity > ProductCategoryMember. > > *In short*: > > ProductStore/Catalog assoc : ProductStore -> ProdCatalog -> > ProductCatalogCategory (Browse Root) > > Browse Root Category/Product categories: > - ProductCategory (Browse Root) > -- productCategory_1 -> Products (through ProductCategoryMember); > -- productCategory_2 -> Products; > ---productSubCategory_2_1 -> Products; > ---productSubCategory_2_2 -> Products; > -- productCategory_3 -> Products; > > In the online backend demo of OFBiz you can start following this structure > from the Catalog Manager -> Stores, pick up a store and then open the tab > "CATALOGS". > You will find different examples of stores and catalogs with different > categories associated, that can give you a good starting point on the > store/catalog/category/product OOTB mechanism. > > I hope I have been helpful. > > Kind Regards, > Giulio > > Il giorno lun 25 ott 2021 alle ore 16:30 Bs Serge ha > scritto: > > > Hi, > > > > I was browsing through the catalog module and I could not find any > product > > and store relationship. > > > > I would assume products are supposed to belong in a certain store! > > > > Kindly enlighten me on how OFBiz handles products and stores > relationships, > > or point me to a link that explains it. > > > > Thanks, > > > > Best Regards, > > > > > -- > Giulio Speri > > > *Mp Styl**e Srl* > via Antonio Meucci, 37 > 41019 Limidi di Soliera (MO) > T 059/684916 > M 347/0965506 > > www.mpstyle.it >
Re: Detailed OFBiz Accounting Tutorial Available
Thank you Sharan, I soo much needed this, its like you read my email :))) Best Regards, On Fri, Oct 22, 2021 at 3:13 PM Michael Brohl wrote: > Hi Sharan, > > that's great, thanks for sharing your valuable work with the community! > > Best regards, > > Michael Brohl > > ecomify GmbH - www.ecomify.de > > > Am 21.10.21 um 19:10 schrieb 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: Order Approval
Thank you again, Mr Pierre Smits, Much Appreciated! Best Regards, On Thu, Oct 21, 2021 at 10:42 AM Pierre Smits wrote: > 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 <https://ofbiz.apache.org/> since > 2008 (without privileges) > > *Apache Directory <https://directory.apache.org>, PMC Member* > Apache Incubator <https://incubator.apache.org>, committer > Apache Steve <https://steve.apache.org>, 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 <http://www.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, > > > > > > > > > >
Product and Store Relationship
Hi, I was browsing through the catalog module and I could not find any product and store relationship. I would assume products are supposed to belong in a certain store! Kindly enlighten me on how OFBiz handles products and stores relationships, or point me to a link that explains it. Thanks, Best Regards,
Re: Order Approval
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 <http://www.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, > > >
Order Approval
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: Currency Conversion Service Name
Never mind, I found the service, it is called "convertUom" Thanks, On Fri, Oct 1, 2021 at 11:18 AM Bs Serge wrote: > Hello Ofbiz Community! > > I see the foreign exchange rate page in GL settings, > > But I would like to know which service is used to convert funds from one > currency to another currency. > > Best Regards, >
Currency Conversion Service Name
Hello Ofbiz Community! I see the foreign exchange rate page in GL settings, But I would like to know which service is used to convert funds from one currency to another currency. Best Regards,
Re: OFBiz 17 vs 18
May I ask : Why 17 is considered the “stable” release? Thanks, On Fri, Jul 30, 2021 at 10:56 Carlos Navarro wrote: > Hello Nicolas, > > Many thanks for your valuable reply. > > Carlos > > El vie, 30 jul 2021 a las 4:20, Nicolas Malin () > escribió: > > > We use the 18.12 branch in production since 2 two years without issues. > > > > For the migration just take care about the theme if you have your own > > theme that need to migrate on common-theme support. > > > > Nicolas > > > > On 29/07/2021 20:01, Carlos Navarro wrote: > > > Hi all, > > > > > > Hoping you are all doing well. > > > > > > Is it OFBiz 18 enough stable to put in production or not yet? In case > > not, if not complex modifications are made to OFBiz 17: is it hard to > > migrate from OFBiz 17 to OFBiz 18? > > > > > > Many thanks. > > > > > > Carlos Navarro > > >
Re: Subscription Extension
Thank you Jacques, going to check this out, Oops looks like someone needs help, Hi Yuresh, Kindly check a reply Nicolas Malin made in a new email, Best Regards, On Mon, Jul 26, 2021 at 10:43 AM Yuresh Akila wrote: > Hi somebody here can help me with installing ofbiz on ubuntu 20.04, will be > greatly appreciated. > > I have been trying to read the ofbiz threads, and all the current manuals > and asking people to help me with, but none of it worked. > > I am trying to install this software on my ubuntu, since April. > > If anyone who would willing to help please Respond, and appreciate with all > Greatfulness. > > Thank You, > Yuresh. > > On Fri, 23 Jul 2021, 16:34 Jacques Le Roux, > wrote: > > > Hi Serge, > > > > This should help: > > https://cwiki.apache.org/confluence/display/OFBIZ/Subscription > > > > HTH > > > > Jacques > > > > Le 21/07/2021 à 20:18, Bs Serge a écrit : > > > Hello Ofbiz Team, > > > > > > Is there a way to make a subscription extend it's thru date on > expiration > > > instead of creating a new subscription ID each time the subscription > > > expires? > > > > > > Any thoughts would be appreciated, > > > > > > Best Regards, > > > > >
Subscription Extension
Hello Ofbiz Team, Is there a way to make a subscription extend it's thru date on expiration instead of creating a new subscription ID each time the subscription expires? Any thoughts would be appreciated, Best Regards,
Re: Sales Order Paid With Financial Account
I finally figured it out, I had to give the order party the ownership role to the financial account. Best, On Tue, Jul 13, 2021 at 6:50 PM Bs Serge wrote: > Hii OFBiz community, hope you are doing great! > > OFBiz Version : 17.12 > > Is it possible to create a sales order for a party that is going to be > paid using the party's financial account? > > the party is called "YLAmbassadorGroup" in the below screenshots, > > I have already set up the party's financial account as seen here : > https://ibb.co/375zZ0C > > This is the "Quick Finalize Order" page for the order, on the right side > on the payment methods it's not showing the financial account option : > > https://ibb.co/jLZm21X > > This is the store's payment methods which includes the "Financial Account" > as an External Payment Service : > > https://ibb.co/80dqCLD > > Thank you in advance, > > >
Sales Order Paid With Financial Account
Hii OFBiz community, hope you are doing great! OFBiz Version : 17.12 Is it possible to create a sales order for a party that is going to be paid using the party's financial account? the party is called "YLAmbassadorGroup" in the below screenshots, I have already set up the party's financial account as seen here : https://ibb.co/375zZ0C This is the "Quick Finalize Order" page for the order, on the right side on the payment methods it's not showing the financial account option : https://ibb.co/jLZm21X This is the store's payment methods which includes the "Financial Account" as an External Payment Service : https://ibb.co/80dqCLD Thank you in advance,
