Re: TrackingCode siteId

2022-02-09 Thread Pierre Smits
Guten Morgen Ingo,

The field definition appears in marketing-entitymodel.xml in the entity
definition "TrackingCodeOrder" and in entity definition
"TrackingCodeOrderReturn". In both as a long-varchar type.
In file TrackingCodeEvents.java, it appears at line 266 and line 554.

Please raise an issue in our JIRA if you feel it needs to be addressed.

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*

Anyone could have been you, whereas I've always been anyone.


On Wed, Feb 9, 2022 at 10:56 AM Ingo Wolfmayr 
wrote:

> Hi everybody,
>
>
>
> I am testing the "Tracking Code" part of the marketing module and was
> wondering where the "siteId" comes from. I get a null pointer exeption when
> calling a page with a tracking code.
>
>
>
> Caused by: java.lang.NullPointerException
>
> at java.net.URLEncoder.encode(URLEncoder.java:224) ~[?:?]
>
> at java.net.URLEncoder.encode(URLEncoder.java:196) ~[?:?]
>
> at
> org.apache.ofbiz.marketing.tracking.TrackingCodeEvents.processTrackingCode(TrackingCodeEvents.java:267)
> ~[main/:?]
>
> at
> org.apache.ofbiz.marketing.tracking.TrackingCodeEvents.checkPartnerTrackingCodeUrlParam(TrackingCodeEvents.java:175)
> ~[main/:?]
>
>
>
> I looked into the ofbiz code but could not find the place where it is set.
>
>
>
> Best regards,
>
> Ingo
>
>
>
> Mag. (FH) Ingo Wolfmayr
>
> *Wolfix Solutions*
>
> Gänsgasse 14
>
> A-5282 Ranshofen
>
>
>
> Tel.: +43 (0) 664 2549626
>
> Web: https://www.wolfix.at
>
> Xing: https://www.xing.com/profile/Ingo_Wolfmayr/
>
>
>
> [image: emailsignatur]
>
>
>
>
>


Re: Cycle Count/Inventory Counts

2022-02-01 Thread Pierre Smits
Hi James,

If you feel this is a feature dearly missed in the OFBiz package, feel free
to register an ticket in our JIRA (
https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ) and
hopefully one of the 50+ community members steps up to collaborate with you
and others to get it incorporated in the codebase.

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*

Anyone could have been you, whereas I've always been anyone.


On Fri, Jan 28, 2022 at 11:44 PM  wrote:

> Is there a way to record inventory counts in mass instead of entering an
> adjustment one by one?  For a company with thousands of products this
> could be very time consuming.
>
>
> Also anyone know how to set up sales tax by zip code?
>
> thanks,
>
> James
>


Re: Products included in Service

2022-01-29 Thread Pierre Smits
Hi Emad,

Which volume of Silverston's books are you refering to (there are multiple).

Anyway, the handling of products and their components (parts, ingredients,
etc) is covered by the Apache OFBiz project. Both in entity definitions and
services/functions.

In the entity definitions we cover this through the ProductAssoc entity,
that defines the rationship between a product (identified by the productId
field) and multiple other projects (identified by the productIdTo field).
Classifiaction of that relationship is further enhanced by the
productAssocTypeId field.

You can best experienc how this is done in OFBiz (with use of demo data)
via:

   - in the catalog application: e.g.
   
https://localhost:8443/catalog/control/ViewProductManufacturing?productId=MOTHER_BOARD_ASS
   - in the catalog application:e.g.
   
https://localhost:8443/catalog/control/EditProductAssoc?productId=MOTHER_BOARD_ASS
   - in the manufacturing application:
   https://localhost:8443/manufacturing/control/FindBom
   - in the manufacturing application: e.g.
   
https://localhost:8443/manufacturing/control/EditProductBom?productId=MOTHER_BOARD_ASS&productAssocTypeId=MANUF_COMPONENT


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*

Anyone could have been you, whereas I've always been anyone.


On Sat, Jan 29, 2022 at 1:24 PM Emad Radwan  wrote:

> Hello Community,
>
> Regarding this issue, I found in Silverston's book that he has a table
> called 'Product_Component' that handles such situations under 'Products and
> Parts' section in chapter 3 on page 100. I understand that we don't have
> such a table in Ofbiz data model so I'll appreciate it if someone can guide
> me on how this situation is handled.
>
> Regards,
>
> Emad
>
> On 2022/01/27 13:29:08 Emad Radwan wrote:
> > Hello Community,
> >
> > I have a scenario where I need to define a service but that one will
> include products also; think of a car maintenance shop where the service is
> the 5k maintenance and the included products are the spare parts.
> >
> > Where can I handle this in the GUI?
> >
> > Regards,
> >
> > Emad
>


Re: Support/Installation/Customization of OfBiz

2022-01-29 Thread Pierre Smits
Guten Tag, Herr Brandau,

An dem OFBiz-Project sind mehrere deutsche und europäischen Teilnehmer
beteiligt. Viele davon bieten Unterstützung für die OFBiz-Implementierung,
als unabhängiger Freiberufler order als Angestellter eines Unternehmens.

Teilnehmer aus dem deutschsprachigen Raum sind u.A.:

   - Sebastian Leitner (Diginea GmbH)
   - Carsten Schinzer (DCS Verkaufssysteme GmbH)
   - Georg Potthast
   - Ingo Könemann (Wolfix Solutions)

Als Europäische Unternehmen gibt es u.A.:

   - Dignea GmbH (Deutschland)
   - Ilscipio GmbH (Deutschland)
   - ISU GmbH (Deutschland)
   - Wolfix Solutions (Österreich)
   - Nowhow solutions AG (Schweiz)
   - Netdava (Rumänien)

Umfangreiche Teilnehmer- und Firmenübersichten finden Sie unter:

   -
   https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors
   -
   
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers

Ich vertraue darauf, dass das Obige Ihnen weiter helfen kann.

Aufrichtig,
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*

Anyone could have been you, whereas I've always been anyone.


Hello Thorsten,

Several Grman and European participants are involved in the OFBiz project. Many
of these offer support for OFBiz implementation, as an independent
freelancer or as an employee of a company.

Participants from the German-speaking area are: a.o.:

   - Sebastian Leitner (Diginea GmbH)
   - Carsten Schinzer (DCS Verkaufssysteme GmbH)
   - Georg Potthast
   - Ingo Könemann (Wolfix Solutions)
   - Christian Geisert (ISU GmbH)


Some European companies are.:

   - Dignea GmbH (Germany)
   - Ilscipio GmbH (Germany)
   - ISU GmbH (Germany)
   - Wolfix Solutions (Austria )
   - Nowhow solutions AG (Switzerland)
   - Netdava (Romania)

Extensive overviews of participants and companies can be found via:

   -
   https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors
   -
   
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers


I trust that the above can help you further

Sincerely
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*

Anyone could have been you, whereas I've always been anyone.


On Fri, Jan 28, 2022 at 9:44 PM Dr. Thorsten Brandau <
thorsten.bran...@brace.de> wrote:

> Hi
>
> We are looking for someone helping us to customize ofbiz for our in
> house use including data import from our old system.
>
> Are there any (commercial) service providers in Germany or Europe?
>
> Thank you.
>
> Mit freundlichen Grüßen/Best regards/よろしくお願いします
> BRACE GmbH
>
> Dr. Thorsten Brandau
>
> --
> + This Document is confidential + Dieses Dokument ist vertraulich +
>
> ->->-> Please register at https://www.brace.de for getting always the
> latest news and best informations! <-<-<-
> * WINNER OF THE EXPORT AWARD BAVARIA 2021 *
>  Please visit us at those events:
> * Food Ingredients Europe, Nov 30- Dec 2, 2021, Frankfurt am Main, Germany
> *
> * Anuga FoodTec, 26.-29. April 2022, Cologne, Germany *
> * 24th Microencapsulation Industrial Convention, May 2-5, 2022, Rotterdam,
> The Netherlands *
> * Bearer of the "High Commendation" at the FI Innovation Award 2019 *
> * Finalist of the FI Innovation Award 2019 - Instant Process *
> 
>
> BRACE GmbH
> Dr. Thorsten Brandau (thorsten.bran...@brace.de)
> President
> Am Mittelberg 5
> D-63791 Karlstein
> Germany
> Tel: +49 6188 991757
> Fax: +49 6188 991759
> https://www.brace.de
>
> HRB5004 (Amtsgericht Aschaffenburg), VAT DE151299833, Managing Directors:
> Dr. Thorsten Brandau, Gisela Brandau
>
> IMPORTANT NOTICE:
> This email may be confidential, may be legally privileged, and is for the
> intended recipient only.
> Access, disclosure, copying, distribution, or reliance on any of it by
> anyone else is prohibited
> and may be a criminal offence. Please delete if obtained in error and
> email confirmation to the sender.
>
>


Re: Vendor Credits

2022-01-11 Thread Pierre Smits
Hi James,
"Vendor" is an ambiguous term. I guess you're referring to Suppliers and
Credit Invoices that are used to balance out Purchase Invoices, correct?

If so, yes. Functionality in play for RMA (return and credit invoicing) for
customers should work similar for suppliers.

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, Jan 11, 2022 at 3:01 PM  wrote:

>
> Hi all.  Is there any OTB functionality for Vendor Credits to apply
> against account.  I know on the customer side we have Credit Memo that
> will cut a check and Billing Account that can apply against invoices.
> is there anything similar on the Vendor side where credits can be
> applied toward open Vendor Invoices
>
> thanks,
>
> James
>


Re: new user installation error.

2022-01-06 Thread Pierre Smits
Hans,

You're a contributor too.

There is no need to dictate what others should, must or have to do.

Op do 6 jan. 2022 13:37 schreef Hans Bakker :

> update the page:
> https://cwiki.apache.org/confluence/display/ofbiz/demo+and+test+setup+guide
>
> telling where to get the jar file and add it?
>
> On 1/6/22 6:24 PM, Nicolas Malin wrote:
> > Hello Hans,
> >
> > On the Reademe.adoc :
> >
> > 
> > == Quick start
> >
> > To quickly install and fire-up OFBiz, please follow the below
> > instructions from
> > the command line at the OFBiz top level directory (folder).
> >
> > [[download-the-gradle-wrapper]]
> > === Download the Gradle wrapper:
> >
> > MS Windows: `init-gradle-wrapper`
> >
> > Unix-like OS: `./gradle/init-gradle-wrapper.sh`
> > 
> >
> > This came from the need to delivery the release source code without
> > binary as the ASF recommand.
> >
> > Nicolas
> >
> >
> > On 06/01/2022 12:10, Hans Bakker wrote:
> >> Today i installed ofbiz from scratch
> >>
> >> i went to:
> >>
> https://cwiki.apache.org/confluence/display/ofbiz/demo+and+test+setup+guide
> >> which told be to install the latest version from
> >> http://ofbiz.apache.org/download.html
> >>
> >> i installed from
> >> https://www.apache.org/dyn/closer.lua/ofbiz/apache-ofbiz-18.12.05.zip
> >>
> >> unzipped the archive and
> >>
> >> started ofbiz with: ./gradlew ofbiz (i have linux)
> >>
> >> the result: Error: Could not find or load main class
> >> org.gradle.wrapper.GradleWrapperMain
> >>
> >> the reason is that the gradle-wrapper.jar is missing in the
> >> gradle/wrapper directory
> >>
> >> should this file not be included in the zip I downloaded?
> >>
> >> after installing this jar file it works
> >>
> >> Regards,
> >>
> >> Hans
> >>
> >
>


Drop-in replacement plugin for the 'BI' component

2021-12-22 Thread Pierre Smits
Dear OFBiz user,

It pleases me to be able to announce that as of today the first release of
the drop-in replacement plugin for the 'BI' component in the ofbiz-plugins
repository has become available via Github (see [1]). I have called this
drop-in replacement the '*odwh*' plugin.

About 2 years ago I recognised that the 'BI' plugin in the OFBIZ-plugins
repository has a huge potential for OFBiz users in that it could populate a
data warehouse on a regular basis with the latest data from the OFBiz
transaction database, and thus enabling key users to gain a better insight
in their business domains of the organisation (using OFBiz) without a
complex and arduous process to get the data from the OFBiz transactions
database into the data warehouse.

However, while working to get the improvements into the code base (see [2]
and [3]), and documenting it (see [4]) I noticed that, based on
comments/reactions provided by (some of) the privileged contributors in the
OFBiz community, it would be a long stretch before this would become
available in the codebase.
And that, I found, would be a pity.
Not only regarding the effort already spent on improving the original
component, or regarding creating another opportunity to collaborate on
improving OFBiz not coming to fruition.
But more importantly: because you would not get it anywhere soon to
leverage your investment in using OFBiz.

Thus I decided to make this effort directly available to you as a drop-in
and replacement  plugin for the BI component in the ofbiz-plugins
repository.

*Not a BI solution*
Though the *odwh* plugin has a rudimentary report builder to show that
there is data in the data warehouse (through the population of dimension
and fact tables), the *odwh* plugin is not intended to be a BI solution.
There are already enough (open-source) solutions out there that will cater
to any kind of preference a BI oriented user (data analyst, etc.) may have.
A good open-source solution you may want to consider if you're considering
making BI reports available to your C*X level of your organisation is
Apache Superset.

*What is in the package*
The package contains following dimension entities (tables in your database):


   - date and time dimensions
   - Account dimension
   - Carrier dimension
   - Country and Currency dimensions
   - Customer dimension (some could/would call this the 'vendor' dimension)
   - Employee dimension
   - Facility Dimension (some could/would call this the 'warehouse'
   dimension)
   - PosTerminal dimension
   - Organisation dimension (regarding internal organisations)
   - Product dimension
   - Project and ProjectTask dimensions
   - Store dimension
   - SalesChannel and SalesPromo dimensions
   - Supplier dimension (some could/would call this the 'vendor' dimension

The package also contains following fact entities (tables in your database):


   - InventoryItemFact
   - PurchaseInvoiceItemFact
   - PurchaseOrderItemFact
   - SalesInvoiceItemFact
   - SalesOrderItemFact

And following (rudimentary) star schema entities (view-entities) to work
with the integrated report builder:


   - InventoryItemFact
   - PurchaseInvoiceItemStarSchema
   - PurchaseOrderItemStarSchema
   - SalesInvoiceItemStarSchema
   - SalesOrderItemStarSchema

Plus all the services (and configurations) required to:


   1. initialise the data warehouse
   2. update (manually) the data warehouse (for testing purposes)
   3. On a regular/scheduled basis (through configuration setting(s))
   populate the data warehouse with the latest changes from the OFBiz
   transactions database.

By default the DWH population is executed through a scheduled job (to be
executed at 2 AM every day: see the dataset - SystemProperty with
systemPropertyValue="HOUR_02" ) leveraging off-business and off-maintenance
hours. This job will be visible in the Jobs overview in the admin
application.

I hope you will give this *odwh* plugin a try-out (fork it, or download the
latest release), and if you have any questions do not hesitate to contact
me.
Implementation instructions is available at [5].
If you experience any issues with the plugin, please register them at [6]

   1. https://github.com/ORRTIZ/odwh/releases/tag/g-1.0.0
   2.
   
https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20component%20%3D%20bi%20%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%20updatedDate%20DESC
   3. [3] https://github.com/apache/ofbiz-plugins/pull/11
   4. [4]
   https://cwiki.apache.org/confluence/display/OFBIZ/Business+Intelligence
   5. https://github.com/ORRTIZ/odwh/wiki/How-to-implement
   6. https://github.com/ORRTIZ/odwh/issues


PS The *odwh* plugin is intended for releases of OFBiz utilising the Gradle
build system. Are you working with a release utilising the Ant build system
and you would want to have something similar, please let me know.

Met vriendelijke groet,
Pierre Smits

*Proud* *con

Re: [ANNOUNCE] Apache OFBiz 18.12.04 released

2021-12-20 Thread Pierre Smits
Thanks Jacopo, and all involved in this.
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 20, 2021 at 1:27 PM Jacopo Cappellato 
wrote:

> The Apache OFBiz community is pleased to announce the new release "Apache
> OFBiz 18.12.04".
>
> Apache OFBiz® is an open source product for the automation of enterprise
> processes that includes framework components and business applications.
>
> http://ofbiz.apache.org/
>
> "Apache OFBiz 18.12.04" is the fourth release of the 18.12 series.
>
> For details of the changes introduced with this new version
> please refer to http://ofbiz.apache.org/release-notes-18.12.04.html
>
> The release file can be downloaded following the instructions in the OFBiz
> download page:
>
> http://ofbiz.apache.org/download.html
>


Re: Back Orders

2021-12-16 Thread Pierre Smits
Hi James,

I guess you attached something to your mail to the user ml. It happens to
be so that the configuration of this mailing list does not allow for
attachments to go through.

If you feel this is an error due to a flaw in the OFBiz code, please
register a ticket in our JIRA (see [1])
It may also be so that an ticket is registered for the same. Please check
our JIRA.

[1] https://issues.apache.org/jira/projects/OFBIZ/issues/

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 Thu, Dec 9, 2021 at 7:22 PM  wrote:

> Has anyone seen the attached error when creating a production run?  We
> have proper dates set for the BOM and Routings.
>
>  Original Message 
> Subject: RE: Back Orders
> From: 
> Date: Tue, November 16, 2021 9:55 am
> To: "user@ofbiz.apache.org" 
>
> anyone have any idea on how the system was designed to function?
>
>
>  Original Message 
> Subject: Back Orders
> From: 
> Date: Wed, November 10, 2021 12:33 pm
> To: "user@ofbiz.apache.org" 
>
> Can someone tell me how backorders are suppose to function out of the
> box. Here is what I am seeing
>
> 1. Order Placed with a total of 10 items with 1 item that is back
> ordered (Correct)
> 2. Pick List Created with 9 items (Correct)
> 3. When packing the system should only show 9 items but system is
> showing all 10 items (incorrect)
> 4. After Original Order is shipped and the backordered product is
> received then the backordered item is now available for picking but
> should have ship group 2 but currently it has ship group 1
>
> Am I missing something? Can anyone let me know how it is suppose to
> function?
>


Re: Make to Order Production Run

2021-12-11 Thread Pierre Smits
A ticket to enhance inventory (demo data) of pc components would certainly
help. Demo this

Op za 11 dec. 2021 10:59 schreef Jacques Le Roux <
jacques.le.r...@les7arts.com>:

> Yes indeed, else the products are backordered, you can see that in the
> order,
>
> eg:
> https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderview?orderId=WSCO10004
>
> <<[10 Backordered]>> (PCs there)
>
> HTH
>
> Jacques
>
> Le 11/12/2021 à 10:52, Pierre Smits a écrit :
> > Hi Serge,
> >
> > Jacques and I tested the process this morning with ordering 10 units of
> PC
> > config:
> >
> https://demo-trunk.ofbiz.apache.org/ecomseo/category/configurable-pcs-PC-100.html
> > .
> > When looking at the order generated in ordermgr, you'll find that there
> is
> > a production run referenced.
> >
> > After the production run is completed, and goods have moved into
> inventory
> > the order can be picked, packed, shipped and invoiced.
> >
> > 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 Sat, Dec 11, 2021 at 8:38 AM Jacques Le Roux <
> > jacques.le.r...@les7arts.com> wrote:
> >
> >> Hi Serge,
> >>
> >> This is what products like
> >>
> >> Configurables Foods:
> >>
> https://demo-trunk.ofbiz.apache.org/ecomseo/category/configurable-foods-FOOD-001.html
> >> and
> >> PC config:
> >>
> https://demo-trunk.ofbiz.apache.org/ecomseo/category/configurable-pcs-PC-100.html
> >> achieve.
> >>
> >> You should look in details at how this products are produced.
> >>
> >> Or are you looking for something else?
> >>
> >> Jacques
> >>
> >>
> >> Le 09/12/2021 à 10:04, Bs Serge a écrit :
> >>> 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 

Re: Make to Order Production Run

2021-12-11 Thread Pierre Smits
Hi Serge,

Jacques and I tested the process this morning with ordering 10 units of PC
config:
https://demo-trunk.ofbiz.apache.org/ecomseo/category/configurable-pcs-PC-100.html
.
When looking at the order generated in ordermgr, you'll find that there is
a production run referenced.

After the production run is completed, and goods have moved into inventory
the order can be picked, packed, shipped and invoiced.

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 Sat, Dec 11, 2021 at 8:38 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Serge,
>
> This is what products like
>
> Configurables Foods:
> https://demo-trunk.ofbiz.apache.org/ecomseo/category/configurable-foods-FOOD-001.html
> and
> PC config:
> https://demo-trunk.ofbiz.apache.org/ecomseo/category/configurable-pcs-PC-100.html
> achieve.
>
> You should look in details at how this products are produced.
>
> Or are you looking for something else?
>
> Jacques
>
>
> Le 09/12/2021 à 10:04, Bs Serge a écrit :
> > 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

2021-12-07 Thread Pierre Smits
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: Invoice - Discount

2021-12-03 Thread Pierre Smits
Correction:

And that performance bonus would be (approximately) equal to the total
FIN_PAYMENT_DISC discounts (and VAT amounts thereon) on invoices of that
period.

Should have been:

And that performance bonus would be (approximately) equal to the total
FIN_PAYMENT_DISC discounts (and VAT amounts thereon) that would have
otherwise be stated on invoices of that period.

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, Dec 3, 2021 at 12:43 PM Pierre Smits  wrote:

> This whole controversy regarding FIN_PAYMENT_DISC and VAT corrections led
> to (in B2B) to framework agreement conditions between supplier and customer
> about being credited for good payment performance over time, meaning that
> if and when during a period (quarter, half-year, year) the customer would
> pay on time, the supplier would send a credit invoice for a performance
> bonus, with VAT calculation. And that performance bonus would be
> (approximately) equal to the total FIN_PAYMENT_DISC discounts (and VAT
> amounts thereon) on invoices of that period.
>
> 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, Dec 3, 2021 at 12:30 PM Pierre Smits 
> wrote:
>
>> Hi Ingo,
>>
>> First of all, FIN_PAYMENT_DISC,  or Skonto rabat, as it is called in
>> Germany/Austria, is in essence a credit mechanism.
>> It is not a discount on price. Therefor subject to different fiscal rules
>> (regarding VAT) than just goods/services invoicing (I don't know how it is
>> in Germany/Austria and other EU countries), but here in the Netherlands
>> credit transactions are VAT exempt).
>>
>> If the organisation is following a different methodology (i.e.
>> considering  FIN_PAYMENT_DISC not treating as VAT exempt), then he must
>> ensure that on the invoice (which states the terms) VAT amounts are stated
>> for both FIN_PAYMENT_TERM  and FIN_PAYMENT_DISC. Corrections after the fact
>> (the invoice, a legal/fiscal document for both  supplier and customer)
>> vis-a-vis VAT declarations is a path towards increased risk (fiscal audits,
>> etc.).
>>
>> Way back when I was working in retail (with both German suppliers and
>> Customers) responsible for accounting, we had the same issues over and over
>> again. Customers would subtract the discount, even after the deadline for
>> the term had passed, and assistants would register purchase invoices not
>> for the total invoice amount, but for the discounted amount (with VAT for
>> the full net amount) and those invoices would be paid also after the
>> discount term. We were regularly bombarded with overviews of unpaid parts
>> of invoices, and send the same out to our customers. Not only taking up a
>> lot of resources' time to follow up and correct, but also stressing the
>> relationship with customers and/or suppliers.
>>
>> We came up with a solution that alleviated both (time needed to follow
>> up, and stress reduction). We would take the VAT amount (regardless of the
>>  FIN_PAYMENT_DISC) stated on the invoice and register that in GL (for
>> fiscal reporting), but would write off the remainder of the invoice (after
>> payment of invoice with the FIN_PAYMENT_DISC deducted) and to a specific
>> GL account.
>>
>> You can do the same in a custom function on the invoice: have a trigger
>> visible to the appropriate user constrained through:
>>
>>- Visible only when the  FIN_PAYMENT_DISC is associated with the
>>invoice, and
>>- the amount to write off is equal to the calculated FIN_PAYMENT_DISC
>>amount
>>
>> And then have the function generating GL transaction and GL transaction
>> enttries for the write-off of the remainder of the invoice (in essence
>> marking the invoice as paid in full, for overviews, etc.) to the
>> appropriate GL accounts.
>>
>> 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, Dec 3, 2021 at 11:13 AM Ingo Wolfmayr 
>> wrote:
>>
>>> Hi Pierre, Hi Nicolas,
>>>
>

Re: Invoice - Discount

2021-12-03 Thread Pierre Smits
This whole controversy regarding FIN_PAYMENT_DISC and VAT corrections led
to (in B2B) to framework agreement conditions between supplier and customer
about being credited for good payment performance over time, meaning that
if and when during a period (quarter, half-year, year) the customer would
pay on time, the supplier would send a credit invoice for a performance
bonus, with VAT calculation. And that performance bonus would be
(approximately) equal to the total FIN_PAYMENT_DISC discounts (and VAT
amounts thereon) on invoices of that period.

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, Dec 3, 2021 at 12:30 PM Pierre Smits  wrote:

> Hi Ingo,
>
> First of all, FIN_PAYMENT_DISC,  or Skonto rabat, as it is called in
> Germany/Austria, is in essence a credit mechanism.
> It is not a discount on price. Therefor subject to different fiscal rules
> (regarding VAT) than just goods/services invoicing (I don't know how it is
> in Germany/Austria and other EU countries), but here in the Netherlands
> credit transactions are VAT exempt).
>
> If the organisation is following a different methodology (i.e. considering
>  FIN_PAYMENT_DISC not treating as VAT exempt), then he must ensure that
> on the invoice (which states the terms) VAT amounts are stated for
> both FIN_PAYMENT_TERM  and FIN_PAYMENT_DISC. Corrections after the fact
> (the invoice, a legal/fiscal document for both  supplier and customer)
> vis-a-vis VAT declarations is a path towards increased risk (fiscal audits,
> etc.).
>
> Way back when I was working in retail (with both German suppliers and
> Customers) responsible for accounting, we had the same issues over and over
> again. Customers would subtract the discount, even after the deadline for
> the term had passed, and assistants would register purchase invoices not
> for the total invoice amount, but for the discounted amount (with VAT for
> the full net amount) and those invoices would be paid also after the
> discount term. We were regularly bombarded with overviews of unpaid parts
> of invoices, and send the same out to our customers. Not only taking up a
> lot of resources' time to follow up and correct, but also stressing the
> relationship with customers and/or suppliers.
>
> We came up with a solution that alleviated both (time needed to follow up,
> and stress reduction). We would take the VAT amount (regardless of the  
> FIN_PAYMENT_DISC)
> stated on the invoice and register that in GL (for fiscal reporting), but
> would write off the remainder of the invoice (after payment of invoice with
> the FIN_PAYMENT_DISC deducted) and to a specific GL account.
>
> You can do the same in a custom function on the invoice: have a trigger
> visible to the appropriate user constrained through:
>
>- Visible only when the  FIN_PAYMENT_DISC is associated with the
>invoice, and
>- the amount to write off is equal to the calculated FIN_PAYMENT_DISC
>amount
>
> And then have the function generating GL transaction and GL transaction
> enttries for the write-off of the remainder of the invoice (in essence
> marking the invoice as paid in full, for overviews, etc.) to the
> appropriate GL accounts.
>
> 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, Dec 3, 2021 at 11:13 AM Ingo Wolfmayr 
> wrote:
>
>> Hi Pierre, Hi Nicolas,
>>
>> just to be more precise:
>>
>> The order is completed and sent. The payment terms have been created via
>> customer agreements and are shown on the invoice. The invoice have been
>> sent.
>>
>> Not it's the customers turn. If he pays within the payment target, he can
>> subtract the discount on the payment.
>>
>> On the bank account it shows € 98,- instead of € 100,- which is fine.
>>
>> The invoice needs a payment of 100% to be completed. Building the
>> adjustment in vie manual accounting tansactions does solve the problem for
>> the accounting, but not for the office staff working on the invoices.
>>
>> I guess I have to add the following functionallity:
>> - adding this special invoice discount type after the invoice has been
>> approved: this would enable the system to make the correct accounting
>> transactions, add tax adjustments and the office staff will be able to
>> complete the invoice + 

Re: Invoice - Discount

2021-12-03 Thread Pierre Smits
Hi Ingo,

First of all, FIN_PAYMENT_DISC,  or Skonto rabat, as it is called in
Germany/Austria, is in essence a credit mechanism.
It is not a discount on price. Therefor subject to different fiscal rules
(regarding VAT) than just goods/services invoicing (I don't know how it is
in Germany/Austria and other EU countries), but here in the Netherlands
credit transactions are VAT exempt).

If the organisation is following a different methodology (i.e.
considering  FIN_PAYMENT_DISC
not treating as VAT exempt), then he must ensure that on the invoice (which
states the terms) VAT amounts are stated for both FIN_PAYMENT_TERM  and
FIN_PAYMENT_DISC. Corrections after the fact (the invoice, a legal/fiscal
document for both  supplier and customer) vis-a-vis VAT declarations is a
path towards increased risk (fiscal audits, etc.).

Way back when I was working in retail (with both German suppliers and
Customers) responsible for accounting, we had the same issues over and over
again. Customers would subtract the discount, even after the deadline for
the term had passed, and assistants would register purchase invoices not
for the total invoice amount, but for the discounted amount (with VAT for
the full net amount) and those invoices would be paid also after the
discount term. We were regularly bombarded with overviews of unpaid parts
of invoices, and send the same out to our customers. Not only taking up a
lot of resources' time to follow up and correct, but also stressing the
relationship with customers and/or suppliers.

We came up with a solution that alleviated both (time needed to follow up,
and stress reduction). We would take the VAT amount (regardless of the
 FIN_PAYMENT_DISC)
stated on the invoice and register that in GL (for fiscal reporting), but
would write off the remainder of the invoice (after payment of invoice with
the FIN_PAYMENT_DISC deducted) and to a specific GL account.

You can do the same in a custom function on the invoice: have a trigger
visible to the appropriate user constrained through:

   - Visible only when the  FIN_PAYMENT_DISC is associated with the
   invoice, and
   - the amount to write off is equal to the calculated FIN_PAYMENT_DISC
   amount

And then have the function generating GL transaction and GL transaction
enttries for the write-off of the remainder of the invoice (in essence
marking the invoice as paid in full, for overviews, etc.) to the
appropriate GL accounts.

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, Dec 3, 2021 at 11:13 AM Ingo Wolfmayr 
wrote:

> Hi Pierre, Hi Nicolas,
>
> just to be more precise:
>
> The order is completed and sent. The payment terms have been created via
> customer agreements and are shown on the invoice. The invoice have been
> sent.
>
> Not it's the customers turn. If he pays within the payment target, he can
> subtract the discount on the payment.
>
> On the bank account it shows € 98,- instead of € 100,- which is fine.
>
> The invoice needs a payment of 100% to be completed. Building the
> adjustment in vie manual accounting tansactions does solve the problem for
> the accounting, but not for the office staff working on the invoices.
>
> I guess I have to add the following functionallity:
> - adding this special invoice discount type after the invoice has been
> approved: this would enable the system to make the correct accounting
> transactions, add tax adjustments and the office staff will be able to
> complete the invoice + it can be easily used on reports.
>
> What do you think. Anything I missed?
>
> Best regards,
> Ingo
>
>
>
> -Ursprüngliche Nachricht-
> Von: Pierre Smits 
> Gesendet: Freitag, 3. Dezember 2021 09:55
> An: user@ofbiz.apache.org
> Betreff: Re: Invoice - Discount
>
> Nicolas,
> Thanks for sharing your comments.
>
> Would you not agree that getting a payment for an order that hasn't been
> approved/processed (and the subsequent delivery not having taken place) and
> thus no invoice would be a bit atypical? An order adjustment (after the
> approval of the order) would then also be atypical...
>
> 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, Dec 3, 2021 at 9:40 AM Pierre Smits 
> wrote:
>
> > Gutentag Ingo,
> >
> > This is one of the payment terms, and should be reflected in
> > agreement, and order before it winds up in an invoice.
> >
> > Relate

Re: Invoice - Discount

2021-12-03 Thread Pierre Smits
Nicolas,
Thanks for sharing your comments.

Would you not agree that getting a payment for an order that hasn't been
approved/processed (and the subsequent delivery not having taken place) and
thus no invoice would be a bit atypical? An order adjustment (after the
approval of the order) would then also be atypical...

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, Dec 3, 2021 at 9:40 AM Pierre Smits  wrote:

> Gutentag Ingo,
>
> This is one of the payment terms, and should be reflected in agreement,
> and order before it winds up in an invoice.
>
> Related term records can be found in data definitions for entity TermType,
> and most probably applied are:
>
>- FIN_PAYMENT_TERM - for the standard
>- FIN_PAYMENT_DISC - for the discount condition
>
> As for your use case (which is very common in German / Austrian business),
>
>1. the invoice can't be altered after it has been approved and
>processed for posting to GL,
>2. the payment can't be altered after it has been received (as it also
>needs to align with what is reported on bank statement, etc),and processed
>for posting to GL
>
> Remains the outstanding balance of the invoice. With current
> functionality, this needs to be manually adjusted in the GL transaction
> regarding the payment association with the invoice.
>
> 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, Dec 3, 2021 at 8:49 AM Ingo Wolfmayr 
> wrote:
>
>> Hi everybody,
>>
>>
>>
>> I have an accounting question regarding discount on early payment.
>>
>>
>>
>> For example a customer has a payment target of 10 days. If he pays within
>> those 10 days, he can subtract a discount of 2%.
>>
>> There is an invoice amount of € 100,- (the invoice is sent to the
>> customer and therefore editing the invoice is disabled)
>>
>>
>>
>> The customer pays € 98,- A payment is created and assigned to the
>> invoice. The invoice says € 2,- open.
>>
>>
>>
>> How do I get the discount into the system?
>>
>>
>>
>> Best regards,
>> Inog
>>
>>
>>
>> Mag. (FH) Ingo Wolfmayr
>>
>> *Wolfix Solutions*
>>
>> Gänsgasse 14
>>
>> A-5282 Ranshofen
>>
>>
>>
>> Tel.: +43 (0) 664 2549626
>>
>> Web: https://www.wolfix.at
>>
>> Xing: https://www.xing.com/profile/Ingo_Wolfmayr/
>>
>>
>>
>> [image: emailsignatur]
>>
>>
>>
>>
>>
>


Re: Invoice - Discount

2021-12-03 Thread Pierre Smits
Gutentag Ingo,

This is one of the payment terms, and should be reflected in agreement, and
order before it winds up in an invoice.

Related term records can be found in data definitions for entity TermType,
and most probably applied are:

   - FIN_PAYMENT_TERM - for the standard
   - FIN_PAYMENT_DISC - for the discount condition

As for your use case (which is very common in German / Austrian business),

   1. the invoice can't be altered after it has been approved and processed
   for posting to GL,
   2. the payment can't be altered after it has been received (as it also
   needs to align with what is reported on bank statement, etc),and processed
   for posting to GL

Remains the outstanding balance of the invoice. With current functionality,
this needs to be manually adjusted in the GL transaction regarding the
payment association with the invoice.

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, Dec 3, 2021 at 8:49 AM Ingo Wolfmayr 
wrote:

> Hi everybody,
>
>
>
> I have an accounting question regarding discount on early payment.
>
>
>
> For example a customer has a payment target of 10 days. If he pays within
> those 10 days, he can subtract a discount of 2%.
>
> There is an invoice amount of € 100,- (the invoice is sent to the customer
> and therefore editing the invoice is disabled)
>
>
>
> The customer pays € 98,- A payment is created and assigned to the invoice.
> The invoice says € 2,- open.
>
>
>
> How do I get the discount into the system?
>
>
>
> Best regards,
> Inog
>
>
>
> Mag. (FH) Ingo Wolfmayr
>
> *Wolfix Solutions*
>
> Gänsgasse 14
>
> A-5282 Ranshofen
>
>
>
> Tel.: +43 (0) 664 2549626
>
> Web: https://www.wolfix.at
>
> Xing: https://www.xing.com/profile/Ingo_Wolfmayr/
>
>
>
> [image: emailsignatur]
>
>
>
>
>


Re: Images not working

2021-12-02 Thread Pierre Smits
Good morning Steven,

Most often this is the result of a mismatch between actual path of the
image (in the folder structure from OFBiz root) and the calculated path for
the image. Can you verify that both are the same (pre and post migration)?


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 Wed, Dec 1, 2021 at 6:06 PM Steven Payne  wrote:

> Hi All,
>
> I've run into a problem where all the images stopped working.  I've
> upgraded from 17 to 18 and all the image links are broken.  I can still see
> the images on the server.
>
> Does anyone know where to start with this?
>
> 
> HTTP Status 404 - Not Found
> Type Status Report
>
> Message The requested resource
> [/images/products/0-10NL-25-RP/original.png] is not available
>
> Description The origin server did not find a current representation for
> the target resource or is not willing to disclose that one exists.
>
> Apache Tomcat/9.0.54
> --
>
> Regards,
> Steven Payne
> Inventory Control Coordinator
>
>


Re: Resources for customization

2021-11-30 Thread Pierre Smits
And this confluence page:
https://cwiki.apache.org/confluence/display/OFBIZ/EntityNameRole

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 30, 2021 at 10:02 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Raynhold,
>
> Speaking about PartyRole, you maybe interested by these thread:
>
> https://lists.apache.org/thread/0ow2y53l1w4jfv1gm8vhx00d9l0fck0b
> https://lists.apache.org/thread/mz3o2xwztlxkh5swpj10ywwsy8x32v4q
>
> HTH
>
> Jacques
>
> Le 29/11/2021 à 20:24, Raynhold Schapp a écrit :
> > Hi Jacques,
> >
> > thank you for the moderation and pardon for the circumstances, I tried
> to use an email forwarder to use my own domain.
> >
> > Yes, I'm aware of some of these books, I know the Packt books for
> development and also the first of the Volumes from Len Silverston about the
> data
> > model. It's great to get an insight into the model behind OFbiz. I'm
> also familiar with " The Big Book of Apache OFBiz Data Model"
> > https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams which
> is great to look up fast Entities by searching in the PDF-Version.
> >
> > I'm uncertain about how to approach business processes in OFBiz. Like
> which type for a party to use? What consequences will this PartyRole bring?
> In
> > which plugin is the role relevant? Are there gonna be side effects?
> > These are big questions, especially the last one ^^
> >
> > Am Mo., 29. Nov. 2021 um 18:58 Uhr schrieb Jacques Le Roux <
> jacques.le.r...@les7arts.com>:
> >
> > Hi Raynhold,
> >
> >
> > 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
> >
> > This said I guess you are aware of
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books ?
> >
> > Of course you may need more specific information from the community
> and I trust you will get.
> >
> > Jacques
> >
> > Le 29/11/2021 à 17:43, Raynhold Schapp a écrit :
> > > Hi,
> > > I'm since quite a time active in the development of plugins within
> Apache
> > > OFBiz. After attending a course on the general basics of enterprise
> > > resource planning systems I got some insights into the structure
> and use
> > > cases.
> > >
> > > Since I want to gather more know-how in the process of customizing
> and
> > > general usage of OFBiz, I wonder if there are any resources like
> books,
> > > guides, tutorials, or even case studies to practice and learn.
> > >
> > > I'm familiar with the work from Sharan Foga (Getting started with
> Apache
> > > OFBiz Manufacturing & MRP, Getting Started with Apache OFBiz
> Accounting).
> > > They are great for the beginning and the dive into OFBiz. The
> points I'm
> > > missing are the consequences, extensive effects, and implications
> when
> > > setting specific attributes. For example: using one type instead
> of the
> > > other.
> > >
> > > Regards
> > > Raynhold
> >
> >
> > Regards
> > Raynhold
>


Re: user login to particular module

2021-11-29 Thread Pierre Smits
Good morning
Each component has its own set of permissions. Have a look at the data sets.

Op di 30 nov. 2021 07:19 schreef Mahi maheshwari :

> Hi,
>
> I want to create multiple users by giving permissions to certain modules
> only not to all modules. user should be able to log in to the particular
> module to which he/she has access, by using their credentials. the user
> cannot log in to other modules except the modules they have access to.
>
> how can I achieve this?
>
> thanks,
> Maheshwari.
>


Re: how to import/export data from ofbiz to quickbooks and quickbooks to ofbiz

2021-11-29 Thread Pierre Smits
Good morning

Yes, you can do that with a scheduled custom service

Op di 30 nov. 2021 06:52 schreef Mahi maheshwari :

> Hi,
>
> I have a spreadsheet folder that contains xls files in my ofbiz root
> directory. I want to import these xls files into ofbiz. this import of
> files should be automated every 5 minutes. how can I use recurrence_info,
> job_sandbox, recurrence_rule entities for this?
>
> is there any way to import and export data automatically from Quickbooks to
> ofbiz and ofbiz to QuickBooks?
>
>
> Regards,
> Maheshwari.
>


Re: GlobalDecorator

2021-11-26 Thread Pierre Smits
शुभ दिन माहेश्वरी,

I tried to access the image (via the link you provided), but it requires me
to log into something I am unfamiliar with. I don't like to register for
something I don't expect to use  again.  I do want to help you get your
issue addressed and resolved (if not by me then by other contributors).

Could you therefor provide an alternative link to the image?

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 16, 2021 at 11:37 AM Mahi maheshwari 
wrote:

> Hi,
>
> I have created the custom visual theme for my side-bar requirement by
> following this doc
>
> https://github.com/apache/ofbiz-framework/blob/trunk/themes/docs/themes.adoc
>
> but I want Tomahawk theme styles, so I copied all the css, js, images into
> my custom theme called "xerus-theme" by following this doc
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=74685960
>
> the entire custom theme folder structure is here
> <https://www.canva.com/design/DAEug3mJSbE/lDQDNfQMpMeYdygo5Ri1Iw/edit>
> below are the changes I have done
> *themes/xerus-theme/ofbiz-component.xml*
>
>  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xsi:noNamespaceSchemaLocation="
> https://ofbiz.apache.org/dtds/ofbiz-component.xsd";>
> 
> 
>
> 
>  location="data/Xerus-themeThemeData.xml"/>
>
> 
>  title="xerus-theme"
> menu-name="secondary"
> server="default-server"
> location="webapp/xerus-theme"
> mount-point="/xerus-theme"
> app-bar-display="false"/>
> 
>
> *themes/xerus-theme/widget/Theme.xml  => here I have made an entry for
> sidebar as "VT_SIDEBAR_TMPLT_LOC". rest is same as tomahawk.*
>
>  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
>xmlns="http://ofbiz.apache.org/Widget-Theme"; xsi:schemaLocation="
> http://ofbiz.apache.org/Widget-Theme
> http://ofbiz.apache.org/dtds/widget-theme.xsd";>
> 
> 
> ${util:label('CommonEntityLabels',
> 'VisualTheme.description.TOMAHAWK', locale)}
> 
> 
> 
> 
> 
> 
> 
>  value="component://xerus-theme/template/Header.ftl"/>
>  value="component://xerus-theme/template/Footer.ftl"/>
>  value="component://xerus-theme/template/AppBarOpen.ftl"/>
>  value="component://xerus-theme/template/AppBarClose.ftl"/>
> * value="component://xerus-theme/template/SideBar.ftl"/>*
> 
> 
> 
> 
>  value="/xerus-theme/js/dropdown.js"/>
> 
>  value="/xerus-theme/css/style.css"/>
>  value="/xerus-theme/css/help.css"/>
>  value="/xerus-theme/webapp/xerus-theme/css/docbook.css"/>
> 
> 
>
> *themes/xerus-theme/data/Xerus-themeThemeData.xml*
> 
>  description="xerus theme: the evolution of the tomahawk theme"/>
>  resourceTypeEnumId="VT_STYLESHEET"
> resourceValue="component://xerus-theme/webapp/css/style.css"
> sequenceId="01"/>
>  resourceTypeEnumId="VT_HDR_TMPLT_LOC"
> resourceValue="component://xerus-theme/template/Header.ftl"
> sequenceId="08"/>
>  resourceTypeEnumId="VT_FTR_TMPLT_LOC"
> resourceValue="component://xerus-theme/template/Footer.ftl"
> sequenceId="10"/>
> * resourceTypeEnumId="VT_SIDEBAR_TMPLT_LOC"
> resourceValue="component://xerus-theme/template/SideBar.ftl"
> sequenceId="26"/>*
> 
>
> *themes/common-theme/widget/CommonScreens.xml => GlobalDecorator Screen*
>  form-field="layoutSettings.VT_SIDEBAR_TMPLT_LOC"/>
> *added this section for side-bar*
> 
> 
> 
> 
> 
> 
>  />
> 
> 
> 
> 
> 
> 
>  location="${SidebarTemplateLocation}" />
> 
> 

Re: Product Supplier & Store Agreement

2021-11-24 Thread Pierre Smits
Hei Serge, All,

Out of the box there is no field in the SupplierProduct entity (controlling
supplier prices for Purchase Orders) to control the maximum quantity for a
purchase order for a given product. You could consider extending the entity
with the field (look in the definitions regarding entities for
'extend-entity'), or (IMO, more my favourite) create a new entity like
SupplierProductAttributes, where you capture the maximum quantity. And work
with the value set there in the approval process of a Purchase Order.

But you have to keep in mind, that most often what is at the 3rd parties
side (the supplier) can be a black box. You may not have insights in their
capacities. And also: a supplier can fulfil any size order over time (given
enough lead time).
If you were to consider doing a custom 3rd party integration solution for
vendor platforms (Amazon, AliBaba, etc.) you could use that maximum
quantity field (for supplier products) as a pre-approval function for your
Purchase Order

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 3:29 PM Bs Serge  wrote:

> 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*
> > > >

Re: Product Supplier & Store Agreement

2021-11-23 Thread Pierre Smits
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: how to display tables with data without filling the form

2021-11-22 Thread Pierre Smits
Good morning Maheshwari,

So if I understand your query correctly, you want something like [1] to
happen in Manufacturing, instead of something like [2]

[1] https://demo-trunk.ofbiz.apache.org/catalog/control/FindCatalog
[2] https://demo-trunk.ofbiz.apache.org/catalog/control/FindCategory


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, Nov 22, 2021 at 10:27 AM Mahi maheshwari 
wrote:

> Hi Pierre Smits,
>
> I think I have to elaborate on my query. the thing is I don't even want to
> click on the Find button also but the table should show some data in it
> when I open the manufacturing module. It's just like a static table.
>
> Best Regards,
> Maheshwari.
>
>
> On Mon, Nov 22, 2021 at 2:23 PM Pierre Smits 
> wrote:
>
> > सुबह बख़ैर Maheshwari,
> >
> > Just clicking the find button without providing search criteria should
> work
> > too.
> >
> > 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, Nov 22, 2021 at 9:43 AM Mahi maheshwari 
> > wrote:
> >
> > > Hi,
> > >
> > > I want to display the tables with data(like a static table) but without
> > > filling the form.
> > > for better understanding, I'm explaining in Detail.
> > > In the manufacturing module after filling the form with necessary
> details
> > > and clicking on the Find button, It will display the data in the table.
> > but
> > > I don't want to fill the form but want a table with data without any
> > action
> > > performed on the form.
> > >
> > > how can I do so?
> > >
> > > Thanks and Regards,
> > > Maheshwari.
> > >
> >
>


Re: how to display tables with data without filling the form

2021-11-22 Thread Pierre Smits
सुबह बख़ैर Maheshwari,

Just clicking the find button without providing search criteria should work
too.

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, Nov 22, 2021 at 9:43 AM Mahi maheshwari 
wrote:

> Hi,
>
> I want to display the tables with data(like a static table) but without
> filling the form.
> for better understanding, I'm explaining in Detail.
> In the manufacturing module after filling the form with necessary details
> and clicking on the Find button, It will display the data in the table. but
> I don't want to fill the form but want a table with data without any action
> performed on the form.
>
> how can I do so?
>
> Thanks and Regards,
> Maheshwari.
>


Re: Product Supplier & Store Agreement

2021-11-18 Thread Pierre Smits
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: CSS not loading

2021-11-07 Thread Pierre Smits
Goeiemoarn Justine,

If the backend database of your OFBiz implementation is professional grade
(meaning anything else than the default integrated Apache Derby), cleanAll
won't delete your data.



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 Sun, Nov 7, 2021 at 7:42 AM Jacques Le Roux 
wrote:

> Hi Justine,
>
> It will "only" replace the current DB content by the demo data. So if you
> have important data there you need to keep a dump and then meticulously
> replace it again. If you don't want all the demo date load only the seed.
> checkhttps://
> ci.apache.org/projects/ofbiz/site/trunk/readme/html5/README.html#data-loading-tasks
> out
>
> With something like|< readers=seed,seed-initial,ext,ext-demo">> you don't have to fear for you
> own templates. Only data will be affected. Jacques |
>
> Le 06/11/2021 à 22:32, Justine Nowak a écrit :
> > Thank you for this information Jacques,
> >
> > gradlew cleanData loadAll - If we do this will it remove our database
> > content, or will it just load the ofbiz files. And if we have customized
> > template files can we just save them and reupload them after?
> >
> >
> > On Sat, Nov 6, 2021 at 2:58 PM Jacques Le Roux<
> jacques.le.r...@les7arts.com>
> > wrote:
> >
> >> Hi Justine,
> >>
> >> Inline...
> >>
> >> Le 06/11/2021 à 20:46, Justine Nowak a écrit :
> >>> maybe mixing trunk data with 18 design perhaps??
> >>>
> >>> I believe that is the issue, how would we go with resolving this?
> >> I believe a simple "gradlew cleanData loadAll" should work if you have
> not
> >> mixed code between R18 and trunk. If you mixed code then you must start
> >> from scratch being sure that you keep the your own modified code.
> >>> Also,version 18.12 doesn't include the Helveticus themes.
> >> If you want Helveticus then you must use trunk
> >>
> >> HTH
> >>
> >> Jacques
> >>
> >>> -Justine
> >>>
> >>> On Sat, Nov 6, 2021 at 7:35 AM Pierre Smits
> >> wrote:
> >>>> Bonjour Justine,
> >>>>
> >>>> As the 18 branch has come available as a demo site, we can now - in a
> >> handy
> >>>> kind of way - compare local implementations against what is in the
> repo.
> >>>> See e.ghttps://demo-stable.ofbiz.apache.org/accounting
> >>>>
> >>>> As it shows nothing wrong there, it seems that a mixup of events at
> your
> >>>> side (maybe mixing trunk data with 18 design perhaps??) led to the
> issue
> >>>> you reported here.
> >>>>
> >>>> I trust everything is ok now.
> >>>>
> >>>> 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 Sat, Nov 6, 2021 at 1:10 AM Justine Nowak
> >>>> wrote:
> >>>>
> >>>>> Are you confident that data sets were loaded correctly?
> >>>>>
> >>>>> I'm not sure they were, we did try to upgrade Ofbiz last week to
> 18.12
> >>>> but
> >>>>> that was unsuccessful so we reverted back to the Trunk version.
> >>>>>
> >>>>>
> >>>>> On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits
> >>>>> wrote:
> >>>>>
> >>>>>> Bore Da Justine,
> >>>>>>
> >>>>>> Weird. I tried it using the various applications with the themes
> >>>>> available
> >>>>>> in trunk  this morning, and could not detect anything wrong on first
> >>>>> sight
> >>>>>> (visual inspection in browser and in log).
> >>>>>>
> >>>>>> Are you confident that data sets were loaded correctly?
> >>>>>>
> >>>>>> Met vriendelijke groet,
> >>>>>>
> >>>

Re: CSS not loading

2021-11-06 Thread Pierre Smits
Bonjour Justine,

As the 18 branch has come available as a demo site, we can now - in a handy
kind of way - compare local implementations against what is in the repo.
See e.g https://demo-stable.ofbiz.apache.org/accounting

As it shows nothing wrong there, it seems that a mixup of events at your
side (maybe mixing trunk data with 18 design perhaps??) led to the issue
you reported here.

I trust everything is ok now.

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 Sat, Nov 6, 2021 at 1:10 AM Justine Nowak  wrote:

> Are you confident that data sets were loaded correctly?
>
> I'm not sure they were, we did try to upgrade Ofbiz last week to 18.12 but
> that was unsuccessful so we reverted back to the Trunk version.
>
>
> On Fri, Nov 5, 2021 at 2:40 AM Pierre Smits 
> wrote:
>
> > Bore Da Justine,
> >
> > Weird. I tried it using the various applications with the themes
> available
> > in trunk  this morning, and could not detect anything wrong on first
> sight
> > (visual inspection in browser and in log).
> >
> > Are you confident that data sets were loaded correctly?
> >
> > 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 Thu, Nov 4, 2021 at 6:43 PM Justine Nowak 
> > wrote:
> >
> > > Hi Pierre,
> > >
> > > We are using the Trunk version and there are no custom CSS / themes.
> > >
> > >
> > > On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits 
> > > wrote:
> > >
> > > > Bonjour Justine,
> > > >
> > > > Unfortunately, settings regarding this mailing list doesn't allow
> > > > attachments to come through.
> > > >
> > > > Can you tell which OFBiz version you are using, and whether the
> > theme/css
> > > > is custom?
> > > >
> > > >
> > > >
> > > > 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 Wed, Nov 3, 2021 at 9:49 PM Justine Nowak 
> > > > wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > The past few days our css in our backend applications (catalog,
> > > partymgr,
> > > > > webtools) has not been loading.
> > > > > [image: Screen Shot 2021-11-03 at 3.47.51 PM.png]
> > > > >
> > > > > The HTML code shows the CSS link connected but it doesn't render
> it.
> > > Even
> > > > > after refreshing and clearing all cookies, and on multiple devices.
> > > > >
> > > > > How do we fix this?
> > > > >
> > > > > -Justine
> > > > >
> > > >
> > >
> >
>


Re: CSS not loading

2021-11-05 Thread Pierre Smits
Bore Da Justine,

Weird. I tried it using the various applications with the themes available
in trunk  this morning, and could not detect anything wrong on first sight
(visual inspection in browser and in log).

Are you confident that data sets were loaded correctly?

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 Thu, Nov 4, 2021 at 6:43 PM Justine Nowak  wrote:

> Hi Pierre,
>
> We are using the Trunk version and there are no custom CSS / themes.
>
>
> On Thu, Nov 4, 2021 at 4:09 AM Pierre Smits 
> wrote:
>
> > Bonjour Justine,
> >
> > Unfortunately, settings regarding this mailing list doesn't allow
> > attachments to come through.
> >
> > Can you tell which OFBiz version you are using, and whether the theme/css
> > is custom?
> >
> >
> >
> > 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 Wed, Nov 3, 2021 at 9:49 PM Justine Nowak 
> > wrote:
> >
> > > Hello,
> > >
> > > The past few days our css in our backend applications (catalog,
> partymgr,
> > > webtools) has not been loading.
> > > [image: Screen Shot 2021-11-03 at 3.47.51 PM.png]
> > >
> > > The HTML code shows the CSS link connected but it doesn't render it.
> Even
> > > after refreshing and clearing all cookies, and on multiple devices.
> > >
> > > How do we fix this?
> > >
> > > -Justine
> > >
> >
>


Re: CSS not loading

2021-11-04 Thread Pierre Smits
Bonjour Justine,

Unfortunately, settings regarding this mailing list doesn't allow
attachments to come through.

Can you tell which OFBiz version you are using, and whether the theme/css
is custom?



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 Wed, Nov 3, 2021 at 9:49 PM Justine Nowak  wrote:

> Hello,
>
> The past few days our css in our backend applications (catalog, partymgr,
> webtools) has not been loading.
> [image: Screen Shot 2021-11-03 at 3.47.51 PM.png]
>
> The HTML code shows the CSS link connected but it doesn't render it. Even
> after refreshing and clearing all cookies, and on multiple devices.
>
> How do we fix this?
>
> -Justine
>


Re: Quote Quantity field

2021-10-31 Thread Pierre Smits
Hi Justine,

I have simulated your issue on demo-trunk (
https://demo-trunk.ofbiz.apache.org/ordermgr ) and there I also could not
add a quantity to a quote item.
Please register a ticket for this bug in our jira.

You can add a shipping estimate to a quote by adding a shipping service
(product) as an item to the quote.

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 Sun, Oct 31, 2021 at 7:08 AM Justine Nowak  wrote:

> Hello,
>
> I am trying to create a quote item but run into the issue with the
> "Quantity" field. The quote is successfully created but when I go to add a
> quote item the "Quantity" field is empty, there is no text field to add the
> quantity for that item.
>
> Also,
>
> How do we add shipping estimates to a quote?
>
> Thanks, Justine
>


Re: [ANNOUNCE] Apache OFBiz 18.12.01 released

2021-10-30 Thread Pierre Smits
Maybe the ticket should mention that it affects this release?

Op za 30 okt. 2021 17:41 schreef Jacques Le Roux <
jacques.le.r...@les7arts.com>:

> Hi Larry,
>
> Yes we have a very recent issue with Gradle changes. Please see
> https://issues.apache.org/jira/browse/OFBIZ-12351 for a temporary
> solution...
>
> Jacques
>
> Le 30/10/2021 à 17:29, Larry Piet a écrit :
> > On Fri, 29 Oct 2021 17:37:16 +0200
> > Jacopo Cappellato  wrote:
> >
> >> The Apache OFBiz community is pleased to announce the new release
> >> "Apache OFBiz 18.12.01".
> >>
> > Hello,
> >
> > I tried to install 18.12.01 but get a build failure:
> >
> >> Could not resolve
> com.sun.syndication:com.springsource.com.sun.syndication:1.0.0.
> >> Could not get resource '
> https://repo.spring.io/plugins-release/com/sun/syndication/com.springsource.com.sun.syndication/1.0.0/com.springsource.com.sun.syndication-1.0.0.pom
> > It seems to be related to permissions changes as described here:
> >
> >
> https://www.mail-archive.com/notifications@ofbiz.apache.org/msg44671.html
> >
>


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

2021-10-28 Thread Pierre Smits
Hi Giulio,

Is this issue somehow solved with your solution to ticket OFBIZ-12264 ?

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 Sat, Oct 23, 2021 at 1:04 PM Giulio Speri - MpStyle Srl <
giulio.sp...@mpstyle.it> wrote:

> Hi James,
>
> You could try to disassociate that particular facility from the store the
> order comes from.
>
> Giulio
>
> On Fri, Oct 22, 2021, 21:50  wrote:
>
> > Every time there is an order the system goes through a Re-Reserve
> > process.  There are some circumstances where a user we need to EXCLUDE a
> > warehouse/facility from this re-reserve process.  Is there something OTB
> > for this?
> >
> >
> >  Original Message 
> > Subject: Re: Urgent - Ofbiz Inventory Reservation Going Crazy - Please
> > Help
> > From: Giulio Speri - MpStyle Srl 
> > Date: Wed, October 20, 2021 1:54 pm
> > To: user@ofbiz.apache.org
> >
> > 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

2021-10-21 Thread Pierre Smits
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 <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 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 <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 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 <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 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

Re: Party ID is null in HumanRes

2021-10-21 Thread Pierre Smits
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 <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 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 <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 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(j

Re: Party ID is null in HumanRes

2021-10-21 Thread Pierre Smits
Indeed. And as it is set in stone it can't be changed.


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 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 <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 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

Re: Party ID is null in HumanRes

2021-10-21 Thread Pierre Smits
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 <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 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 <https://ofbiz.apache.org/>
> since
> > 2008 (without privileges)
> >
> > *Apache Directory <https://directory.apache.org>, PMC Member

Re: Inventory - Receive - Stock transfer and results

2021-10-21 Thread Pierre Smits
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: Order Approval

2021-10-21 Thread Pierre Smits
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,
> > >
> >
>


Re: Attach original accounting documents to invoices

2021-10-21 Thread Pierre Smits
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 <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 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: Party ID is null in HumanRes

2021-10-21 Thread Pierre Smits
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 <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 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: Product Detail - Extra Information

2021-10-21 Thread Pierre Smits
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 <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 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: Internationalization Issue

2021-10-21 Thread Pierre Smits
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 <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 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: Order Approval

2021-10-08 Thread Pierre Smits
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,
>


Re: Expenses tracking

2021-08-23 Thread Pierre Smits
Hi Woyce,

My apologies for the late reaction. $work kept me a bit tied up...

So your talking about travel expenses and the like... Out of the box there
are a lot of functionalities that can help you with such. In accounting, of
course, you can register the expenses from petty cash (as gl transactions),
and in assetmaint you can track mileage of cars (and other metered data of
other equipment).

But there is not a (single) solution/application where you could do
something like recording travel expenses for a given period on a project or
campaign. That is why I built a plugin back in 2017 for myself when I had
to do a lot of traveling for a customer who wantedf detailed reporting
regarding my expenses.

What I built allows me to start an expense report relating to either a
project, a marketing campaign or miscellaneous) and subsequently register
the expenses for such. And generate a pdf for that report.

For your convenience I am adding some screenshot of how it looks like.
[image: Screenshot 2021-08-24 at 08.29.32.png]
[image: Screenshot 2021-08-24 at 08.30.05.png]
[image: Screenshot 2021-08-24 at 08.30.31.png]
[image: Screenshot 2021-08-24 at 08.30.59.png]
[image: Screenshot 2021-08-24 at 08.35.14.png]
Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OEM - The OFBiz Extensions Marketplace1
http://oem.ofbizci.net/oci-2/
1 not affiliated to (and not endorsed by) the OFBiz project


On Fri, Aug 13, 2021 at 1:31 PM Woyce Batkins 
wrote:

> Hi Pierre,
> I am looking for ways to track things like:
> - mileage and gas
> - meals
> - and other little expenses from day to day operations
>
> Thanks,
> Regards
>
> On Tue, Aug 10, 2021 at 8:41 AM Pierre Smits 
> wrote:
>
> > Hi Woyce,
> >
> >
> > Expenses can be tracked and handled in the accounting application of
> OFBiz.
> >
> > What kind of expenses are you thinking of?
> >
> > Best regards,
> >
> > Pierre Smits
> >
> >
> > On Sun, Aug 8, 2021 at 10:39 PM Woyce Batkins 
> > wrote:
> >
> > > Hello,
> > > how do I track and handle various expenses in ofbiz?
> > > Thanks.
> > >
> >
>


Re: Expenses tracking

2021-08-09 Thread Pierre Smits
Hi Woyce,


Expenses can be tracked and handled in the accounting application of OFBiz.

What kind of expenses are you thinking of?

Best regards,

Pierre Smits


On Sun, Aug 8, 2021 at 10:39 PM Woyce Batkins 
wrote:

> Hello,
> how do I track and handle various expenses in ofbiz?
> Thanks.
>


Re: "official" web service standard

2021-07-29 Thread Pierre Smits
See https://issues.apache.org/jira/browse/OFBIZ-12212

Best regards,
Pierre Smits

On Thu, Jul 29, 2021 at 2:08 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> There is also RMI. Like SOAP it's deactivated by default for security
> reason
>
> See
> https://github.com/apache/ofbiz-framework/blob/trunk/framework/webtools/webapp/webtools/WEB-INF/controller.xml#L88-L100
> (same for R18 and R17,
> it's about security)
>
> HTH
>
> Jacques
>
> Le 29/07/2021 à 10:44, Pierre Smits a écrit :
> > Hi Parminder,
> >
> > OFBiz also utilises SOAP to open up its services for integration in other
> > solutions. Recently the project has undertaken to open up its services
> > through REST as well.
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > On Wed, Jul 28, 2021 at 6:27 PM Parminder S. Lehal 
> wrote:
> >
> >> What is the "official" web service  standard/procedure now for ofbiz as
> old
> >> method ( xmlrpc ) services are obsolete and it is almost impossible
> even
> >> to find jar files for them.  Can someone  provide a link to official
> docs
> >> in this regard?
> >> --
> >>
> >> Regards,
> >>
> >> Parminder S. Lehal
> >>
> >>
> >>
>


Re: "official" web service standard

2021-07-29 Thread Pierre Smits
Hi Parminder,

OFBiz also utilises SOAP to open up its services for integration in other
solutions. Recently the project has undertaken to open up its services
through REST as well.

Best regards,

Pierre Smits

On Wed, Jul 28, 2021 at 6:27 PM Parminder S. Lehal  wrote:

> What is the "official" web service  standard/procedure now for ofbiz as old
> method ( xmlrpc ) services are obsolete and it is almost impossible  even
> to find jar files for them.  Can someone  provide a link to official  docs
> in this regard?
> --
>
> Regards,
>
> Parminder S. Lehal
>
>
>


Re: Lookup fields doesn't work in modals

2021-07-29 Thread Pierre Smits
Hi Daors,

If you feel this is a bug, please fill out an Issue form in our JIRA (
https://issues.apache.org/jira/secure/CreateIssue.jspa).

Best regards,
Pierre Smits

On Wed, Jul 28, 2021 at 2:46 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Daors,
>
> Which version are you using?
>
> Jacques
>
> Le 27/07/2021 à 10:13, Daors a écrit :
> > Hello OFBiz Community, hope you're all doing good.
> >
> > I'm trying to use lookup fields in a layered-modal but lookup doesn't
> show it just shows an empty input field with no lookup attached, do I have
> to modify the screen in order the modal to support lookup fields, or how it
> is, is there any solution on how to make lookup fields work in modals.
> >
> > Thank you,
> > Daors
> >
>


Re: Remove control/main from url

2021-07-04 Thread Pierre Smits
See https://issues.apache.org/jira/browse/OFBIZ-11791
Best regards,

Pierre Smits


On Mon, Jul 5, 2021 at 1:50 AM Ivan Drinks Sr <
ivan...@reality-technology.com> wrote:

> After much effort we are able to get our standard web app to run under
> Ofbiz.  However if I select it from the Ofbiz menu a control/main is added
> and not our app pathing.  If I access it using its mount point it runs
> fine.  How do I remove the control/main stuff?
>
> Thanks for your help.
>
>
> Warm regards,
> Ivan Sr


Re: serialized inventory

2021-06-15 Thread Pierre Smits
Hi Woice,

Maybe that (the lack of a scheme to generate serial no's automatically) is
because what each individual implementer (having the need to use serial
no's) defines as an algorithm for the serial number can be as diverse as
the preference regarding style and theme in a website/application.

Best regards,

Pierre Smits

On Tue, Jun 15, 2021 at 5:41 PM Woyce Batkins 
wrote:

> Hello pierre,
> I was afraid of having to manually enter a serial number for any single
> received inventory item.from a PO with 10 000 items. There seems to be no
> scheme to have ofbiz generate them automatically..
> Thank you for the link, it cleared any doubt that I had.
> Kind Regards.
> .
>
>
> On Mon, Jun 14, 2021 at 8:53 AM Pierre Smits 
> wrote:
>
> > Hi Woice,
> >
> > Google is your Friend: have a look at
> > https://www.ecomdash.com/what-is-serialized-inventory
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > On Mon, Jun 14, 2021 at 12:45 AM Woyce Batkins 
> > wrote:
> >
> > > Hello,
> > > I am facing an issue while trying to receive inventory. When the order
> > item
> > > is serialized, I get the following error message:
> > > *Error while converting "27 000" to a number: For input string: "27
> 000"
> > > Method = receiveInventoryProduc*t*. File =
> > >
> > >
> >
> file:/home/apps/ofbiz-framework/applications/product/minilang/shipment/receipt/ShipmentReceiptServices.xml,
> > > Element = , Line 147null *
> > >
> > > Can someone explain to me what a *serialized inventory* is? I selected
> it
> > > by mistake while configuring the product.
> > > In the receival form, there is a field for *serial number.* What number
> > > should I enter there?
> > > How can I fix the issue above?
> > > Thank you for your help.
> > >
> >
>


Re: serialized inventory

2021-06-13 Thread Pierre Smits
Hi Woice,

Google is your Friend: have a look at
https://www.ecomdash.com/what-is-serialized-inventory

Best regards,

Pierre Smits

On Mon, Jun 14, 2021 at 12:45 AM Woyce Batkins 
wrote:

> Hello,
> I am facing an issue while trying to receive inventory. When the order item
> is serialized, I get the following error message:
> *Error while converting "27 000" to a number: For input string: "27 000"
> Method = receiveInventoryProduc*t*. File =
>
> file:/home/apps/ofbiz-framework/applications/product/minilang/shipment/receipt/ShipmentReceiptServices.xml,
> Element = , Line 147null *
>
> Can someone explain to me what a *serialized inventory* is? I selected it
> by mistake while configuring the product.
> In the receival form, there is a field for *serial number.* What number
> should I enter there?
> How can I fix the issue above?
> Thank you for your help.
>


Re: OFBiz REST session

2020-09-30 Thread Pierre Smits
Would it not have been better to announce it a few day in advance to the
meeting than just on the actual day?

So that people can plan for this, and that more people can attend and
participate?

Mvg

Pierre

Op wo 30 sep. 2020 11:05 schreef Girish Vasmatkar <
girish.vasmat...@hotwaxsystems.com>:

> Hello Pierre
>
> Apparently I missed the most important part, I thought I had mentioned
> "today", but unfortunately I didn't. Apologies for that. Please do join, if
> you can, today @ 4 PM IST, 10:30 AM GMT.
>
> Future sessions will be sent notifications for well in advance.
>
> Best Regards,
> Girish
>
>
> On Wed, Sep 30, 2020 at 2:26 PM Pierre Smits 
> wrote:
>
> > Hi Girish,
> >
> > Which date will this be?
> >
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Wed, Sep 30, 2020 at 10:13 AM Girish Vasmatkar <
> > girish.vasmat...@hotwaxsystems.com> wrote:
> >
> > > Hi All
> > >
> > > We will be holding an introductory session on *ofbiz-rest-impl* plugin
> @
> > 4
> > > PM IST, 10:30 AM GMT. Agenda for the same is as follows -
> > >
> > > 1. Introduction to ofbiz-rest-impl 2. Technology stack used 3. Q&A
> > session
> > >
> > > Here's the meet URL for everybody's reference :
> > > https://meet.google.com/mjt-rich-suo . Please do join.
> > >
> > > Best Regards,
> > > Girish
> > >
> >
>


Re: OFBiz REST session

2020-09-30 Thread Pierre Smits
Hi Girish,

Which date will this be?


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Wed, Sep 30, 2020 at 10:13 AM Girish Vasmatkar <
girish.vasmat...@hotwaxsystems.com> wrote:

> Hi All
>
> We will be holding an introductory session on *ofbiz-rest-impl* plugin @ 4
> PM IST, 10:30 AM GMT. Agenda for the same is as follows -
>
> 1. Introduction to ofbiz-rest-impl 2. Technology stack used 3. Q&A session
>
> Here's the meet URL for everybody's reference :
> https://meet.google.com/mjt-rich-suo . Please do join.
>
> Best Regards,
> Girish
>


Re: Need help/direction getting started with OFBIZ ERP

2020-06-30 Thread Pierre Smits
Hi Joe François,

Welcome to the project.

We have (some) implementation pages in our wiki.

Feel free to browse through them and improve where necessary.

Your help (contributions) will surely be appreciated.

Mvg

Pierre

Op di 30 jun. 2020 17:55 schreef joefrancois :

> Hello,
>
> So far my notes are just on my computer, however, I could clean it up and
> post what  I did to make it work on Ubuntu if you are interested.
>
> Regards,
> Joseph
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>


Re: OFBiz configuration on production site

2020-06-27 Thread Pierre Smits
The only other one caring, Jacques?

Op za 27 jun. 2020 10:24 schreef Jacques Le Roux <
jacques.le.r...@les7arts.com>:

> Thanks Pierre for the help!
>
> Jacques
>
> Le 27/06/2020 à 09:32, Pierre Smits a écrit :
> > HI Katie,
> > My apologies for you having to restate your issues several times.
> >
> > That you have the basics in play (Your OFBiz implementation set up,
> running
> > and accessible via 8443) is a good thing, and now you're nearly there.
> >
> > Please see inline for further comments.
> > I trust the information below helps.
> >
> > However, should you still experience issues, please feel free to reach
> out.
> >
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Fri, Jun 26, 2020 at 9:30 AM Katie Qiu 
> > wrote:
> >
> >> Hi,
> >>
> >> I'm new to OFBiz, Please check the steps I have taken and pointed out
> what
> >> I
> >> miss because it's not working on production site
> >>
> >>
> >>
> >> 1. I was able to make it work on localhost. I'm also able to access data
> >> that came with the project (ex:
> >> <https://localhost:8443/webtools/control/entitymaint>
> >> https://localhost:8443/webtools/control/entitymaint)
> >>
> >>
> >> This is the easy part. Kudos
> >
> >> 2. I installed SSL Certificate in Microsoft IIS for the project on
> >> production site my Windows Server 2012 (I was able to access
> >> <https://www.mywebsitedomain.com/> https://www.mywebsitedomain.com now)
> >>
> >>
> >>
> >> a.  I use virtual private server from IONOS and it provides me a free
> SSL.
> >> I
> >> imported .PFX file provided from IONOS, then the domain can be accessed
> as
> >> https
> >>
> >>
> >>
> >> b. As you suggested, I looked into  <https://letsencrypt.org/>
> >> https://letsencrypt.org/, but I didn't see any .PFX file neither other
> >> certificate files that IONOS provided me (on the OFBiz Product Setup
> page,
> >> it shows .cer files (which I also got from IONOS) is used to enter
> >> Keystore.
> >> Maybe I missed something. For now, I use SSL from IONOS, but if you
> think I
> >> should use Let's encrypt, then please let me know if have to have the
> .PFX
> >> and cer files
> >>
> >>
> >> Using ssl certificates from Letsencrypt for the web server is, when
> using
> > web servers like Apache HTTPD and NGINX straight forward. However, I
> don't
> > know how that works for IIIS. Maybe their documentation will tell.
> >
> >
> >
> >> 3. I installed Apache 24 on Windows server as well. I was able to access
> >> localhost and see the index page showing "it works"
> >>
> >> Great, the second step of the combination Apache HTTPD - Apache OFBiz is
> > now concluded.
> >
> > As said earlier, setting up Letsencrypt for Apache HTTPD is straight
> > forward. Please look at the documentation there. If set up properly, you
> > will get:
> >
> > - the Apache HTTPD starter page accessible via: https://
> /
> > or e.g. https://localhost/
> >
> > If done correctly you'll see in (one of) your HTTPD config files (some
> of)
> > following lines appear:
> >
> >  SSLEngine on
> >
> >  Include /etc/letsencrypt/options-ssl-apache.conf
> >
> >  SSLCertificateFile
> /etc/letsencrypt/live/TheFQDOfYourDomain>/cert.pem
> >
> >  SSLCertificateKeyFile /etc/letsencrypt/live/TheFQDOfYourDomain>
> > /privkey.pem
> >
> >  SSLCertificateChainFile /etc/letsencrypt/live/TheFQDOfYourDomain>
> > /chain.pem
> >
> >
> > The only thing now to do is to tie your Apache HTTPD implementation to
> your
> > Apache OFBiz implementation.
> >
> > Please have a look at following setup in my Apache HTTP configuration for
> > the oem.ofbizci.net site:
> >
> > 
> >
> >  ServerName oem.ofbizci.net
&

Re: OFBiz configuration on production site

2020-06-27 Thread Pierre Smits
HI Katie,
My apologies for you having to restate your issues several times.

That you have the basics in play (Your OFBiz implementation set up, running
and accessible via 8443) is a good thing, and now you're nearly there.

Please see inline for further comments.
I trust the information below helps.

However, should you still experience issues, please feel free to reach out.


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Fri, Jun 26, 2020 at 9:30 AM Katie Qiu 
wrote:

> Hi,
>
> I'm new to OFBiz, Please check the steps I have taken and pointed out what
> I
> miss because it's not working on production site
>
>
>
> 1. I was able to make it work on localhost. I'm also able to access data
> that came with the project (ex:
> <https://localhost:8443/webtools/control/entitymaint>
> https://localhost:8443/webtools/control/entitymaint)
>
>
> This is the easy part. Kudos


>
> 2. I installed SSL Certificate in Microsoft IIS for the project on
> production site my Windows Server 2012 (I was able to access
> <https://www.mywebsitedomain.com/> https://www.mywebsitedomain.com now)
>
>
>
> a.  I use virtual private server from IONOS and it provides me a free SSL.
> I
> imported .PFX file provided from IONOS, then the domain can be accessed as
> https
>
>
>
> b. As you suggested, I looked into  <https://letsencrypt.org/>
> https://letsencrypt.org/, but I didn't see any .PFX file neither other
> certificate files that IONOS provided me (on the OFBiz Product Setup page,
> it shows .cer files (which I also got from IONOS) is used to enter
> Keystore.
> Maybe I missed something. For now, I use SSL from IONOS, but if you think I
> should use Let's encrypt, then please let me know if have to have the .PFX
> and cer files
>
>
> Using ssl certificates from Letsencrypt for the web server is, when using
web servers like Apache HTTPD and NGINX straight forward. However, I don't
know how that works for IIIS. Maybe their documentation will tell.



>
> 3. I installed Apache 24 on Windows server as well. I was able to access
> localhost and see the index page showing "it works"
>
> Great, the second step of the combination Apache HTTPD - Apache OFBiz is
now concluded.

As said earlier, setting up Letsencrypt for Apache HTTPD is straight
forward. Please look at the documentation there. If set up properly, you
will get:

   - the Apache HTTPD starter page accessible via: https:///
   or e.g. https://localhost/

If done correctly you'll see in (one of) your HTTPD config files (some of)
following lines appear:

SSLEngine on

Include /etc/letsencrypt/options-ssl-apache.conf

SSLCertificateFile /etc/letsencrypt/live/TheFQDOfYourDomain>/cert.pem

SSLCertificateKeyFile /etc/letsencrypt/live/TheFQDOfYourDomain>
/privkey.pem

SSLCertificateChainFile /etc/letsencrypt/live/TheFQDOfYourDomain>
/chain.pem


The only thing now to do is to tie your Apache HTTPD implementation to your
Apache OFBiz implementation.

Please have a look at following setup in my Apache HTTP configuration for
the oem.ofbizci.net site:



ServerName oem.ofbizci.net

DocumentRoot /var/www/html

Redirect permanent / https://www.ofbizci.net/


ErrorLog /proglog/ofbizci/error.log

CustomLog /proglog/ofbizci/access.log combined






ServerName oem.ofbizci.net


SSLEngine on

Include /etc/letsencrypt/options-ssl-apache.conf

SSLCertificateFile /etc/letsencrypt/live/ofbizci.net/cert.pem

SSLCertificateKeyFile /etc/letsencrypt/live/ofbizci.net/privkey.pem

SSLCertificateChainFile /etc/letsencrypt/live/ofbizci.net/chain.pem

ProxyRequests Off

ProxyPreserveHost On


proxyPass / ajp://10.0.0.22:8009/

ProxyPassReverse / ajp://10.0.0.22:8009/


ErrorLog /proglog/ofbizci/oem-ofbizci-net-ssl-error.log

CustomLog /proglog/ofbizci/oem-ofbizci-net-ssl-access.log combined




In the configuration abovy, you'll see that the following:

proxyPass / ajp://10.0.0.22:8009/

ProxyPassReverse / ajp://10.0.0.22:8009/

The internal IpAddress 10.0.0.22 is where the OFBiz implementation
resides/runs. (my HTTPD web server and and my OFBiz application serverfor
oem.ofbizci.net run on different virtual machines). In your case, e.g. when
having both on 1 (virtual) machine this could b:

proxyPass / ajp://localhost:8009/

ProxyPassReverse / ajp://localhost:8009/

>From the lines you also get

Re: Record keeping with OFBiz - contracts

2020-06-19 Thread Pierre Smits
Hi Eugen,

Please see inline

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Sat, Jun 20, 2020 at 3:59 AM Eugen Stan  wrote:

> Hello,
>
> I'm slowly working my way up to using OFBiz as an ERP.
>
> One of the first things I would like to use is to maintain a record of
> all my contracts and contract history.
>

Contracts can be found here:

https://demo-stable.ofbiz.apache.org/accounting/control/FindAgreement



>
> Related to this is : quotes, invoices, etc.
>

Quotes can be found here:

https://demo-stable.ofbiz.apache.org/ordermgr/control/FindQuote


Invoice can be found here:

https://demo-stable.ofbiz.apache.org/accounting/control/findInvoices





>
> Some things that I want to know:
>
> - how many contracts are in total / active
> - when did they start, when do they end
>

This can be found by applying filter parameters


> - links to the actual contracts uploaded as PDFs
>

PDF files related to a contract can be uploaded to a contract, see
https://demo-stable.ofbiz.apache.org/accounting/control/EditAgreementContents?agreementId=AGR_SALES


>
> - the parties involved ?
>

Parties involved can be registered on a contract with their roles, see
https://demo-stable.ofbiz.apache.org/accounting/control/EditAgreementRoles?agreementId=AGR_SALES


>
>
> Where can I find documentation in OFBiz related to the above?
>

Have a look at the OFBiz wiki, or at the help page associated to the screen
in the OFBiz implementation


>
>
> Thanks,
>
> --
> Eugen Stan
> +40720 898 747 / netdava.com
>
>


Re: Price tier

2020-06-05 Thread Pierre Smits
James,

Correction: that is not what I suggested earlier. IMO, new price types are
not needed. As it means that you still have to define the associating
prices individually for each product. Better is it to work with (new)
product categories, associated products with those and set price rules for
those categories. As per earlier provided url.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Fri, Jun 5, 2020 at 3:34 PM Pierre Smits  wrote:

> That is what I suggested earlier. See latest addition to pr #117 as an
> example.
>
>
> https://github.com/apache/ofbiz-framework/commit/299ebe3a99ca1cfa8b484360d916a445f7a78bf2
>
> Op vr 5 jun. 2020 15:26 schreef :
>
>> Ok Great so we can add a new Product Price Type.  Let's Say we add 3 new
>> Product Price Types.  Tier 1, Tier 2, Tier 3.  Can price rules be set up
>> to utilize a percentage of these new Product Price Types?
>>
>>  Original Message 
>> Subject: Re: Price tier
>> From: Pierre Smits 
>> Date: Fri, June 05, 2020 4:18 am
>> To: user@ofbiz.apache.org
>>
>> Hi James,
>>
>> That is a way to do it, but I suspect it will add a lot to manage prices
>> for each product. A simpler way would be to define the discounts as
>> percentages of one of standard price definitions of the product (based
>> on
>> the ProductPriceType, see [1]). That way you only have to maintain 1
>> price
>> per product, instead of 1 per tier per product.
>>
>> Another way is to have a fixed discount amount per tier, again being the
>> selected standard price.
>>
>> As always, OFBiz offers a lot of flexibility to have it dealing with
>> such
>> price variations as you like...
>>
>> [1]
>>
>> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductPriceType
>>
>> Met vriendelijke groet,
>>
>> Pierre Smits
>> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
>> since
>> 2008 (without privileges)
>>
>> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
>> *Apache Directory <https://directory.apache.org>, PMC Member*
>> Apache Incubator <https://incubator.apache.org>, committer
>> Apache Steve <https://steve.apache.org>, committer
>>
>>
>> On Fri, Jun 5, 2020 at 12:52 PM  wrote:
>>
>> > Since each product as a unique price in each tier would i need to create
>> > a rule for each product for each tier?
>> >
>> >  Original Message 
>> > Subject: Re: Price tier
>> > From: Pierre Smits 
>> > Date: Thu, June 04, 2020 11:18 pm
>> > To: user@ofbiz.apache.org
>> >
>> > Hi James,
>> >
>> > Price maintenance can be the most laborious task of PIM. Ofbiz offers
>> > both
>> > extensive capabilities through price rules (see [1]) as well as the
>> > echnical flexibility to help you with this. Have a look at the demo data
>> > provided codebase. If you have suggestions how to improve the demo data
>> > regarding this, please let us know.
>> >
>> > Without having the complete picture you have, defining price rules per
>> > product category could help you here.
>> >
>> > [1]
>> >
>> >
>> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
>> >
>> > Met vriendelijke groet,
>> >
>> > Pierre Smits
>> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
>> > since
>> > 2008 (without privileges)
>> >
>> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
>> > *Apache Directory <https://directory.apache.org>, PMC Member*
>> > Apache Incubator <https://incubator.apache.org>, committer
>> > Apache Steve <https://steve.apache.org>, committer
>> >
>> >
>> > On Fri, Jun 5, 2020 at 12:32 AM  wrote:
>> >
>> > > What is the best way to handle the below tiered pricing by product
>> with
>> > > quantity breaks in Ofbiz? If we have to set this up by product by tier
>> > > this will be a nightmare
>> > >
>> > >
>> > >
>> > > Item Sales 1 (0-6) (6-35) 36-71 72+
>> > > ISB79963 3.65 3.1 2.55 2.3
>> > > ISB79965 1.85 1.6 1.3 1.17
>> > > ISB79970 13.99 11.95 9.85 8.87
>> > > ISB79971 11.99 10.25 8.45 7.61
>> > > ISB79972 5.75 4.95 3.99 3.59
>> > > ISB79973 3.85 3.3 2.7 2.43
>> > > ISB79975 1.55 1.35 1.1 0.99
>> > > ISB79980 12.99 10.99 9.25 8.33
>> > > ISB79981 10.99 9.5 7.85 7.07
>> > > ISB79982 5.75 4.85 3.99 3.59
>> > > ISB79983 3.85 3.25 2.7 2.43
>> > > ISB79985 2.05 1.75 1.5 1.35
>> > > ISB79988 2.55 2.2 1.8 1.62
>> > >
>> >
>>
>


Re: Price tier

2020-06-05 Thread Pierre Smits
That is what I suggested earlier. See latest addition to pr #117 as an
example.

https://github.com/apache/ofbiz-framework/commit/299ebe3a99ca1cfa8b484360d916a445f7a78bf2

Op vr 5 jun. 2020 15:26 schreef :

> Ok Great so we can add a new Product Price Type.  Let's Say we add 3 new
> Product Price Types.  Tier 1, Tier 2, Tier 3.  Can price rules be set up
> to utilize a percentage of these new Product Price Types?
>
>  Original Message 
> Subject: Re: Price tier
> From: Pierre Smits 
> Date: Fri, June 05, 2020 4:18 am
> To: user@ofbiz.apache.org
>
> Hi James,
>
> That is a way to do it, but I suspect it will add a lot to manage prices
> for each product. A simpler way would be to define the discounts as
> percentages of one of standard price definitions of the product (based
> on
> the ProductPriceType, see [1]). That way you only have to maintain 1
> price
> per product, instead of 1 per tier per product.
>
> Another way is to have a fixed discount amount per tier, again being the
> selected standard price.
>
> As always, OFBiz offers a lot of flexibility to have it dealing with
> such
> price variations as you like...
>
> [1]
>
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductPriceType
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Jun 5, 2020 at 12:52 PM  wrote:
>
> > Since each product as a unique price in each tier would i need to create
> > a rule for each product for each tier?
> >
> >  Original Message 
> > Subject: Re: Price tier
> > From: Pierre Smits 
> > Date: Thu, June 04, 2020 11:18 pm
> > To: user@ofbiz.apache.org
> >
> > Hi James,
> >
> > Price maintenance can be the most laborious task of PIM. Ofbiz offers
> > both
> > extensive capabilities through price rules (see [1]) as well as the
> > echnical flexibility to help you with this. Have a look at the demo data
> > provided codebase. If you have suggestions how to improve the demo data
> > regarding this, please let us know.
> >
> > Without having the complete picture you have, defining price rules per
> > product category could help you here.
> >
> > [1]
> >
> >
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> > since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Fri, Jun 5, 2020 at 12:32 AM  wrote:
> >
> > > What is the best way to handle the below tiered pricing by product with
> > > quantity breaks in Ofbiz? If we have to set this up by product by tier
> > > this will be a nightmare
> > >
> > >
> > >
> > > Item Sales 1 (0-6) (6-35) 36-71 72+
> > > ISB79963 3.65 3.1 2.55 2.3
> > > ISB79965 1.85 1.6 1.3 1.17
> > > ISB79970 13.99 11.95 9.85 8.87
> > > ISB79971 11.99 10.25 8.45 7.61
> > > ISB79972 5.75 4.95 3.99 3.59
> > > ISB79973 3.85 3.3 2.7 2.43
> > > ISB79975 1.55 1.35 1.1 0.99
> > > ISB79980 12.99 10.99 9.25 8.33
> > > ISB79981 10.99 9.5 7.85 7.07
> > > ISB79982 5.75 4.85 3.99 3.59
> > > ISB79983 3.85 3.25 2.7 2.43
> > > ISB79985 2.05 1.75 1.5 1.35
> > > ISB79988 2.55 2.2 1.8 1.62
> > >
> >
>


Re: Price tier

2020-06-05 Thread Pierre Smits
Hi James,

That is a way to do it, but I suspect it will add a lot to manage prices
for each product. A simpler way would be to define the discounts as
percentages of one of standard price definitions of the product (based on
the ProductPriceType, see [1]). That way you only have to maintain 1 price
per product, instead of 1 per tier per product.

Another way is to have a fixed discount amount per tier, again being the
selected standard price.

As always, OFBiz offers a lot of flexibility to have it dealing with such
price variations as you like...

[1]
https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductPriceType

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Fri, Jun 5, 2020 at 12:52 PM  wrote:

> Since each product as a unique price in each tier would i need to create
> a rule for each product for each tier?
>
>  Original Message ----
> Subject: Re: Price tier
> From: Pierre Smits 
> Date: Thu, June 04, 2020 11:18 pm
> To: user@ofbiz.apache.org
>
> Hi James,
>
> Price maintenance can be the most laborious task of PIM. Ofbiz offers
> both
> extensive capabilities through price rules (see [1]) as well as the
> echnical flexibility to help you with this. Have a look at the demo data
> provided codebase. If you have suggestions how to improve the demo data
> regarding this, please let us know.
>
> Without having the complete picture you have, defining price rules per
> product category could help you here.
>
> [1]
>
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Jun 5, 2020 at 12:32 AM  wrote:
>
> > What is the best way to handle the below tiered pricing by product with
> > quantity breaks in Ofbiz? If we have to set this up by product by tier
> > this will be a nightmare
> >
> >
> >
> > Item Sales 1 (0-6) (6-35) 36-71 72+
> > ISB79963 3.65 3.1 2.55 2.3
> > ISB79965 1.85 1.6 1.3 1.17
> > ISB79970 13.99 11.95 9.85 8.87
> > ISB79971 11.99 10.25 8.45 7.61
> > ISB79972 5.75 4.95 3.99 3.59
> > ISB79973 3.85 3.3 2.7 2.43
> > ISB79975 1.55 1.35 1.1 0.99
> > ISB79980 12.99 10.99 9.25 8.33
> > ISB79981 10.99 9.5 7.85 7.07
> > ISB79982 5.75 4.85 3.99 3.59
> > ISB79983 3.85 3.25 2.7 2.43
> > ISB79985 2.05 1.75 1.5 1.35
> > ISB79988 2.55 2.2 1.8 1.62
> >
>


Re: Price tier

2020-06-05 Thread Pierre Smits
To assist you in evaluation how this works (and to help you define your own
price rules) I have defined some new demo data regarding this. Currently
this is not in the code base, but you can evaluate/test this merging PR
#!17 into your development implementation. See
https://github.com/apache/ofbiz-framework/pull/117

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Fri, Jun 5, 2020 at 8:18 AM Pierre Smits  wrote:

> Hi James,
>
> Price maintenance can be the most laborious task of PIM. Ofbiz offers both
> extensive capabilities through price rules (see [1]) as well as the
> echnical flexibility to help you with this. Have a look at the demo data
> provided codebase. If you have suggestions how to improve the demo data
> regarding this, please let us know.
>
> Without having the complete picture you have, defining price rules per
> product category could help you here.
>
> [1]
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Jun 5, 2020 at 12:32 AM  wrote:
>
>> What is the best way to handle the below tiered pricing by product with
>> quantity breaks in Ofbiz?  If we have to set this up by product by tier
>> this will be a nightmare
>>
>>
>>
>> ItemSales 1 (0-6)  (6-35)   36-71   72+
>> ISB799633.653.1 2.552.3
>> ISB799651.851.6 1.3 1.17
>> ISB7997013.99   11.95   9.858.87
>> ISB7997111.99   10.25   8.457.61
>> ISB799725.754.953.993.59
>> ISB799733.853.3 2.7 2.43
>> ISB799751.551.351.1 0.99
>> ISB7998012.99   10.99   9.258.33
>> ISB7998110.99   9.5 7.857.07
>> ISB799825.754.853.993.59
>> ISB799833.853.252.7 2.43
>> ISB799852.051.751.5 1.35
>> ISB799882.552.2 1.8 1.62
>>
>


Re: Price tier

2020-06-04 Thread Pierre Smits
Hi James,

Price maintenance can be the most laborious task of PIM. Ofbiz offers both
extensive capabilities through price rules (see [1]) as well as the
echnical flexibility to help you with this. Have a look at the demo data
provided codebase. If you have suggestions how to improve the demo data
regarding this, please let us know.

Without having the complete picture you have, defining price rules per
product category could help you here.

[1]
https://demo-stable.ofbiz.apache.org/catalog/control/EditProductPriceRules?productPriceRuleId=9000

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Fri, Jun 5, 2020 at 12:32 AM  wrote:

> What is the best way to handle the below tiered pricing by product with
> quantity breaks in Ofbiz?  If we have to set this up by product by tier
> this will be a nightmare
>
>
>
> ItemSales 1 (0-6)  (6-35)   36-71   72+
> ISB799633.653.1 2.552.3
> ISB799651.851.6 1.3 1.17
> ISB7997013.99   11.95   9.858.87
> ISB7997111.99   10.25   8.457.61
> ISB799725.754.953.993.59
> ISB799733.853.3 2.7 2.43
> ISB799751.551.351.1 0.99
> ISB7998012.99   10.99   9.258.33
> ISB7998110.99   9.5 7.857.07
> ISB799825.754.853.993.59
> ISB799833.853.252.7 2.43
> ISB799852.051.751.5 1.35
> ISB799882.552.2 1.8 1.62
>


Re: OfBiz Installation Issue

2020-05-25 Thread Pierre Smits
Welcome,

As there is no default implementation of OFBiz, there is also no load
default.

But there is a load all. As mentioned in documentation.

Maybe you could try that.

Mvg

Pierre



Op ma 25 mei 2020 20:41 schreef Morph Zan :

> Good Day All
>
> I am hoping for a small amount of assistance
>
> I have tried installing OfBiz for the first time, using Version 17.12.03
> I am running Ubuntu Server 20.04
>
> When I run the following command:
>
> sudo ./gradlew cleanAll loadDefault
>
> I get the following error:
>
> Task ‘loadDefault’not found in root project ófbiz”.
>
> Can anyone point me in the right direction at all to solve this
>
> I apologise in advance for being very new to all of this
>


Re: OFBiz Community Days – May 2020

2020-05-23 Thread Pierre Smits
Thanks Carsten, for bringing this to the attention of the Community. I will
take care of it.
Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Sat, May 23, 2020 at 4:32 PM Carsten Schinzer 
wrote:

> Hello,
>
>
> I would like to contribute, yet alignment is a bit difficult w/o access to
> slack.
> The link here
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days to
> join slack appears to be outdated as the slack setup seems to have changed
> from https://s.apache.org/ to https://the-asf.slack.com/.
>
> Can anyone help here?
> Best would be the change of the link on Community Days page I guess :)
>
> Thanks & warm regards
>
>
> Carsten
>
>
> Am Do., 21. Mai 2020 um 10:13 Uhr schrieb Pierre Smits <
> pierresm...@apache.org>:
>
> > Let's try to get some of the open Pull Requests in our repos merged:
> >
> >1. https://github.com/apache/ofbiz-framework/pulls
> >2. https://github.com/apache/ofbiz-plugins/pulls
> >    3. https://github.com/apache/ofbiz-site/pulls
> >4. https://github.com/apache/ofbiz-tools/pulls
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Thu, May 21, 2020 at 8:52 AM Devanshu Vyas  >
> > wrote:
> >
> > > Hello all,
> > >
> > > We have created a Jira sprint *OFBiz Community Day (May 2020)* [1] for
> > our
> > > May community days.
> > > Please add any Jira tasks you are working on, to it. This Jira Sprint
> > helps
> > > us track and report on the work done during the Community Days so
> please
> > > try to make sure your work is included.
> > >
> > > We should add the Sprint in cases like:
> > > 1. When we create a ticket
> > > 2. When we start working on an existing ticket (adding patch or closing
> > > it after a commit).
> > >
> > > To set the sprint on an existing issue, simply click on the "Edit"
> option
> > > on the issue and select the Sprint field.
> > > For a new issue, please select the Sprint field at the time of Jira
> > ticket
> > > creation.
> > >
> > > Basically adding Sprint will make sure your contribution will be
> counted
> > in
> > > OFBiz community days event, which is from *22nd-26th May*.
> > >
> > > Let's work together to improve OFBiz, have fun and enjoy working
> > together.
> > >
> > > [1] -
> > https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=318
> > >
> > > Thanks & Regards,
> > > Devanshu Vyas.
> > >
> > >
> > > On Tue, May 12, 2020 at 11:48 AM Devanshu Vyas <
> > vyas.devansh...@gmail.com>
> > > wrote:
> > >
> > > > Thanks, Jacques, Pierre for your thoughts.
> > > >
> > > > In the last OFBiz community days, we shared information regarding the
> > > > theme/focus of the days which was working on to converting
> > mini-lang(XML)
> > > > services to groovy.
> > > > I think moving ahead to this community day, we could also ask and
> share
> > > > the ideas on this. And both your ideas are good and we can definitely
> > > work
> > > > on them.
> > > > I will be initiating the same thought on the same email thread "Theme
> > for
> > > > upcoming OFBiz community days?" over the dev list.
> > > >
> > > > Sharing thoughts to determine the focus of the OFBiz community day
> for
> > > the
> > > > participants is a good idea. We can move at our own pace for doing
> > tasks,
> > > > and like Taher said, not do anything hasty. :)
> > > >
> > > > Thanks & Regards,
> > > > Devanshu Vyas.
> > > >
> > > >
> > > > On Mon, May 11, 2020 at 11:23 PM Pierre Smits <
> pierresm...@apache.org>
> > > > wrote:
> > > >
> > > >> Maybe we should ask INFRA whether there are maintenance activities
> > > >> planned,
> > > >> that could put a damper on the event.
> > > >>
> > > >> Met vriendelijke groet,
> > > >>
> > > >> Pierre Smits
> > > >> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> > > since
> > > >> 2008 (without privileges)
> > > >>
> > > >> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > > >> *Apache Directory <https://directory.apache.org>, PMC Member*
> > > >> Apache Incubator <https://incubator.apache.org>, committer
> > > >> Apache Steve <https://steve.apache.org>, committer
> > > >>
> > > >
> > >
> >
>


OFBiz Community Collaboration Day

2020-05-22 Thread Pierre Smits
Hi Team,

I wish all a happy OFBiz Community Collaboration Day

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


Re: OFBiz Community Days – May 2020

2020-05-21 Thread Pierre Smits
Let's try to get some of the open Pull Requests in our repos merged:

   1. https://github.com/apache/ofbiz-framework/pulls
   2. https://github.com/apache/ofbiz-plugins/pulls
   3. https://github.com/apache/ofbiz-site/pulls
   4. https://github.com/apache/ofbiz-tools/pulls

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Thu, May 21, 2020 at 8:52 AM Devanshu Vyas 
wrote:

> Hello all,
>
> We have created a Jira sprint *OFBiz Community Day (May 2020)* [1] for our
> May community days.
> Please add any Jira tasks you are working on, to it. This Jira Sprint helps
> us track and report on the work done during the Community Days so please
> try to make sure your work is included.
>
> We should add the Sprint in cases like:
> 1. When we create a ticket
> 2. When we start working on an existing ticket (adding patch or closing
> it after a commit).
>
> To set the sprint on an existing issue, simply click on the "Edit" option
> on the issue and select the Sprint field.
> For a new issue, please select the Sprint field at the time of Jira ticket
> creation.
>
> Basically adding Sprint will make sure your contribution will be counted in
> OFBiz community days event, which is from *22nd-26th May*.
>
> Let's work together to improve OFBiz, have fun and enjoy working together.
>
> [1] - https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=318
>
> Thanks & Regards,
> Devanshu Vyas.
>
>
> On Tue, May 12, 2020 at 11:48 AM Devanshu Vyas 
> wrote:
>
> > Thanks, Jacques, Pierre for your thoughts.
> >
> > In the last OFBiz community days, we shared information regarding the
> > theme/focus of the days which was working on to converting mini-lang(XML)
> > services to groovy.
> > I think moving ahead to this community day, we could also ask and share
> > the ideas on this. And both your ideas are good and we can definitely
> work
> > on them.
> > I will be initiating the same thought on the same email thread "Theme for
> > upcoming OFBiz community days?" over the dev list.
> >
> > Sharing thoughts to determine the focus of the OFBiz community day for
> the
> > participants is a good idea. We can move at our own pace for doing tasks,
> > and like Taher said, not do anything hasty. :)
> >
> > Thanks & Regards,
> > Devanshu Vyas.
> >
> >
> > On Mon, May 11, 2020 at 11:23 PM Pierre Smits 
> > wrote:
> >
> >> Maybe we should ask INFRA whether there are maintenance activities
> >> planned,
> >> that could put a damper on the event.
> >>
> >> Met vriendelijke groet,
> >>
> >> Pierre Smits
> >> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> >> 2008 (without privileges)
> >>
> >> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> >> *Apache Directory <https://directory.apache.org>, PMC Member*
> >> Apache Incubator <https://incubator.apache.org>, committer
> >> Apache Steve <https://steve.apache.org>, committer
> >>
> >
>


Re: Rental

2020-05-20 Thread Pierre Smits
Hello James,

While in OFBiz there is functionality regarding ordering and delivery (and
invoicing) regarding 'rental services' the functionality regarding monthly
invoicing is under developed. This issue appeared only once before (back in
2011).

In order to enable the community to not forget about this feature (and
follow it up with growing insights etc.), I suggest you raise a ticket in
our Jira. This way the project can keep everything related in one
environment and track progress.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Thu, May 21, 2020 at 7:47 AM Pritam Kute 
wrote:

> Hello James,
>
> AFAIK, there is no direct support available in OFBiz which will help you
> set up the exact requirement you mentioned.
>
> You can refer to the Rental Store in OFBiz[1]. This is an example of a
> hotel reservation system that is not exactly as per your requirement but it
> can help you get basic idea.
>
> [1]
>
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductStore?productStoreId=RentalStore
>
> HTH!
>
> Regards,
> --
> Pritam Kute
>
>
> On Wed, May 20, 2020 at 9:19 PM  wrote:
>
> > Paul - How does the process work?  How does the monthly invoicing work?
> > How do you track the ins and outs of the assetwhat if there are
> > multiple of the same asset that is rented?
> >
> >  Original Message 
> > Subject: Re: Rental
> > From: Paul Mandeltort 
> > Date: Tue, May 19, 2020 2:47 pm
> > To: user@ofbiz.apache.org
> >
> > Haven’t used it but this might be a place to look, looks like you can
> > configure products/rentals against an asset.
> >
> >
> >
> >
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=RoomStd
> > <
> >
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=RoomStd
> > >
> >
> >
> >
> https://demo-trunk.ofbiz.apache.org/accounting/control/ListFixedAssetProducts?fixedAssetId=RentalShip
> > <
> >
> https://demo-trunk.ofbiz.apache.org/accounting/control/ListFixedAssetProducts?fixedAssetId=RentalShip
> > >
> >
> >
> > --Paul
> >
> > > On May 19, 2020, at 3:23 PM, ja...@productive1.com wrote:
> > >
> > > Is there a OTB function in ofbiz to handle rentals of propane tanks?
> > > How do the monthly invoice occur? Is it automated? How do you stop
> > > rental charges when cylinder is returned?
> > >
> > > Thanks,
> > >
> > > James
> >
>


Re: OFBiz Community Days – May 2020

2020-05-11 Thread Pierre Smits
Maybe we should ask INFRA whether there are maintenance activities planned,
that could put a damper on the event.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


Re: OFBiz Community Days – May 2020

2020-05-11 Thread Pierre Smits
Taher,

Well... Every member of this community can determine for him /or herself
where his/her contribution benefits the project best. So, looking forward
to your contributions during the Community Days. Wherever they may appear.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Mon, May 11, 2020 at 6:54 PM Taher Alkhateeb 
wrote:

>
> The health of the project from my perspective is not necessarily in how
> many patches / pull requests are approved. In fact, there is nothing easier
> than simply going through all patches and applying them one by one. For me
> quality wins over quantity and 10 clean lines of code are better than 100
> hasty ones. There is in fact a term for hasty and low quality code. It's
> called technical debt.
>
> One place where cleanup is needed in fact are the tickets themselves.
> Perhaps in the community days we can focus on that part. Some of tickets
> are better off closed instead of keeping them as dead weight.
>
> On Monday, May 11, 2020 14:23 +03, Pierre Smits 
> wrote:
>  While I agree that improving the content in the wiki is important and
> should be a theme of upcoming OFBiz Community Days, collaborating to get as
> much patches (currently more than 300 tickets listed, see [1]) as possible
> reviewed and/or implemented into the code base is equally important.
>
> Not only does it shorten the list of open tickets (currently more than
> 1500), but it also sends a strong signal to (adopters) and contributors:
> that the community works as fast as possible to get the (valuable)
> contributions of members implemented.
>
> [1]
>
> https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20%3D%20%22Patch%20Available%22%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC
>
> Met vriendelijke groet,
>
> Pierre Smits
> *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
> 2008 (without privileges)
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Mon, May 11, 2020 at 11:20 AM Jacques Le Roux <
> jacques.le.r...@les7arts.com> wrote:
>
> > Thanks Devanshu,
> >
> > After our move to Git we have finally cleaned our site from information
> > referring to Svn, and that's good.
> >
> > But there is still much such info in the wiki and it can be confusing.
> >
> > I suggest that we concentrate much of our efforts during this Community
> > Day to clean the wiki.
> >
> > We can adapt to Git and keep in wiki when needed, or move in Attic under
> a
> > specific "Subversion" page when really too deprecated.
> >
> > I know, for most of us, it's not as easy as coding with Git and GitHub.
> > But Confluence now also easily allows to share tasks and merge when
> needed.
> >
> > We should not hesitate to prune much, nothing worse than obsolete and
> > confusing documentation
> >
> > I hope everyone will help, it's really long due :)
> >
> > Thanks
> >
> > Jacques
> >
> >
> > Le 11/05/2020 à 06:40, Devanshu Vyas a écrit :
> > > Hello all,
> > >
> > > We are back with OFBiz Community Days, hope you are excited too! :-)
> > > The community days are organized once per quarter so a total of four
> (4)
> > > events throughout the year.
> > >
> > > We are having a sequence of 5 days that form the Community Days. This
> > > extends the time frame and gives people more flexibility to contribute.
> > > So, this month our Community Days will be from *22nd – 26th May 2020*.
> > >
> > > If you are new to the concept of Community Days then please take a look
> > at
> > > the following wiki pages:
> > > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days
> > >
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days+Dates
> > >
> > > This is such an event where anyone can participate (and we would like
> to
> > > encourage as many people as possible to do so)
> > >
> > > If there is an OF

Re: OFBiz Community Days – May 2020

2020-05-11 Thread Pierre Smits
While I agree that improving the content in the wiki is important and
should be a theme of upcoming OFBiz Community Days, collaborating to get as
much patches (currently more than 300 tickets listed, see [1]) as possible
reviewed and/or implemented into the code base is equally important.

Not only does it shorten the list of open tickets (currently more than
1500), but it also sends a strong signal to (adopters) and contributors:
that the community works as fast as possible to get the (valuable)
contributions of members implemented.

[1]
https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20%3D%20%22Patch%20Available%22%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Mon, May 11, 2020 at 11:20 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Thanks Devanshu,
>
> After our move to Git we have finally cleaned our site from information
> referring to Svn, and that's good.
>
> But there is still much such info in the wiki and it can be confusing.
>
> I suggest that we concentrate much of our efforts during this Community
> Day to clean the wiki.
>
> We can adapt to Git and keep in wiki when needed, or move in Attic under a
> specific "Subversion" page when really too deprecated.
>
> I know, for most of us, it's not as easy as coding with Git and GitHub.
> But Confluence now also easily allows to share tasks and merge when needed.
>
> We should not hesitate to prune much, nothing worse than obsolete and
> confusing documentation
>
> I hope everyone will help, it's really long due :)
>
> Thanks
>
> Jacques
>
>
> Le 11/05/2020 à 06:40, Devanshu Vyas a écrit :
> > Hello all,
> >
> > We are back with OFBiz Community Days, hope you are excited too! :-)
> > The community days are organized once per quarter so a total of four (4)
> > events throughout the year.
> >
> > We are having a sequence of 5 days that form the Community Days. This
> > extends the time frame and gives people more flexibility to contribute.
> > So, this month our Community Days will be from *22nd – 26th May 2020*.
> >
> > If you are new to the concept of Community Days then please take a look
> at
> > the following wiki pages:
> > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days+Dates
> >
> > This is such an event where anyone can participate (and we would like to
> > encourage as many people as possible to do so)
> >
> > If there is an OFBiz task or particular area that you would like to work
> on
> > then please see if you can set aside some time over the next few days to
> do
> > it. (Even an hour will help!)
> >
> > Remember that you do not have to work on it alone, our Community Days are
> > also a chance to collaborate with others in the community.
> >
> > Our Community Days are not only coding related, but we would also like to
> > do some tidy up of our wiki and our project documentation.
> >
> > *Testing, Review and Committing Patches*
> > Testing and applying patches is always an important area. Many
> contributors
> > from the community have provided patches for bugs and improvements but
> > before committing them we need to test to them.
> >
> > Patches can become out of date very quickly meaning that if they are not
> > tested early enough then they can miss out on being included. We have a
> > large number of patches available so this could be a good opportunity for
> > test, review and commit.
> >
> > *Documentation*
> > We know that our current documentation could be a whole lot better so any
> > contribution that helps us improve it is welcome.
> >
> > *Jira Sprint*
> > I will create a Jira sprint "OFBiz Community Day (May 2020)" so please
> add
> > any Jira tasks when you are working on it.
> > This Jira Sprint helps us track and report on the work done during the
> > Community Days so please try to make sure your work is included.
> > To set the sprint on an existing issue, simply click on the "Edit" option
> > on the issue and select the sprint field.
> >
> > We should add the Sprint in all t

Re: Open Source Enterprise Job Scheduler with Ofbiz in Production

2020-05-07 Thread Pierre Smits
Hi Sakthivel,

If you're looking for a JobScheduler that can work with implementations
(services) that are running on its own and other (virtual) instances, and
are looking for an Open Source solution, you may consider taking a look at
Apache Airflow (https://airflow.apache.org).

The community over there is doing a good job and appear (AFAICT) a
production grade solution.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Thu, May 7, 2020 at 12:36 PM Sakthivel Vellingiri <
info.integ...@gmail.com> wrote:

> Thanks Eugen for the response, i'm looking for recommendations in Open
> Source Enterprise Jobscheduler for Windows & Unix in the likes of Tidal
> Workload Automation > https://www.tidalsoftware.com/, Autosys Workload
> Automation etc, Appreciate any pointers.
>
>
>
>
> On Thu, May 7, 2020 at 6:14 AM Eugen Stan  wrote:
>
> > Hi,
> >
> > It seems to me that you are looking for tooling on how to do operations.
> > I think those are environment specific.
> >
> > For example I deploy my apps using Docker and Kubernetes so most of that
> > tooling is specific to these environments.
> >
> > if you refine your question and are more specific you might get a better
> > answer.
> >
> > Regards,
> >
> > Eugen
> >
> > La 07.05.2020 12:49, Sakthivel Vellingiri a scris:
> > > Thanks Michael for the response, i understood OFBIZ comes with its own
> > > scheduler that could schedule individual services in OFBIZ, however i'm
> > > looking for an enterprise scheduler that could be used for controlling
> > > things like restarting ofbiz in a particular schedule, running database
> > > backup outside of ofbiz etc. Any insights would be greatly appreciated
> > >
> > > regards
> > >
> > > On Thu, May 7, 2020 at 4:04 AM Michael Brohl  >
> > > wrote:
> > >
> > >> Hi Sakthivel,
> > >>
> > >> OFBiz already comes with a job scheduler, see
> > >> https://demo-trunk.ofbiz.apache.org/webtools/control/scheduleJob
> > >>
> > >> Best regards,
> > >>
> > >> Michael Brohl
> > >>
> > >> ecomify GmbH - www.ecomify.de
> > >>
> > >>
> > >> Am 07.05.20 um 05:32 schrieb Sakthivel Vellingiri:
> > >>> Hi All, Wanted to reach out to see if you have any recommendation for
> > >> Open
> > >>> Source Enterprise Job Scheduler, that works well for you with Ofbiz
> (or
> > >> any
> > >>> other java based or other) in Production; Appreciate your insights
> > >>>
> > >>> regards
> > >>> Sakthivel Vellingiri
> > >>>
> > >>
> > --
> > Eugen Stan
> > +40720 898 747 / netdava.com
> >
> >
>


Re: Re-add me to contributors group

2020-05-05 Thread Pierre Smits
Hi Sebastian,

First of all: welcome back.
Secondly: no worries regarding the mail footer.

Last year INFRA switched from in-tool authentication (for Confluence and
Jira) to LDAP-based authentication. it may be so that there is some
misalignment there. I will reach to INFRA to sea what needs to get done to
get you up and running again.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Wed, May 6, 2020 at 12:23 AM Sebastian Leitner <
sebastian.leit...@diginea.de> wrote:

> Hi all,
>
> I just tried to update my contact info at
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Contributors
> but it seems my permissions have been revoked.
> Could you please re-add me to the group? My wiki username is “sleitner”.
>
> Many thanks in advance!
>
> Regards
> Sebastian
>
> (please excuse my html signature – I cannot get rid of it)
>
>
>
>
> Sebastian Leitner
> Geschäftsführender Gesellschafter
>
> diginea GmbH
> Detmolder Straße 30
> 33604 Bielefeld
>
> Mail: sebastian.leit...@diginea.de
> Mobil: +49 (0) 151 / 42 509 616
>
>
> Sitz der Gesellschaft: Bielefeld
> Registergericht: Amtsgericht Bielefeld, HRB 42863
> Geschäftsführer: Dr. Christian Holsing, Sebastian Leitner
>
> Der Inhalt dieser Nachricht ist vertraulich und nur für den angegebenen
> Empfänger bestimmt. Jede Form der Kenntnisnahme oder Weitergabe durch
> Dritte ist unzulässig. Sollte diese Nachricht nicht für Sie bestimmt sein,
> so bitten wir Sie, sich mit uns per E-Mail oder telefonisch in Verbindung
> zu setzen. Vielen Dank.
>


Re: Offline data management in OFBiz web POS

2020-05-05 Thread Pierre Smits
Hi Deepak,

A search in the OFBiz wiki will go a long way. Here is the uri:
https://cwiki.apache.org/confluence/display/OFBIZ

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Tue, May 5, 2020 at 10:18 AM Deepak Nigam 
wrote:

> Hello all,
>
> Is there any document for enabling RMI in OFBiz?  As per OFBIZ-6942
> <https://issues.apache.org/jira/browse/OFBIZ-6942>, RMI was disabled due
> to
> Java serialization issues. I also tried to revert the changes on local by
> referring to https://markmail.org/message/dukv5glk3elilo5z, but it seems
> that the file/code structure has been changed now.
>
> I can trigger the RMI service host on the same machine (localhost:1099)
> successfully, but it is giving connection error for OFBiz another server
> deployed in the same LAN. I have confirmed that another server is
> accessible for my machine.
>
> Thanks in advance.
>
> Regards
> --
> Deepak Nigam
>
>
> On Mon, May 4, 2020 at 4:23 PM Deepak Nigam 
> wrote:
>
> > Thanks, Pierre and Deepak.
> >
> > Thanks & Regards
> > --
> > Deepak Nigam
> >
> > On Mon, May 4, 2020 at 12:32 PM Deepak Dixit 
> > wrote:
> >
> >> Hi Deepak,
> >>
> >> You can refer following document
> >>
> >>
> https://cwiki.apache.org/confluence/display/OFBIZ/Sync+Setup+Notes+and+Example
> >>
> >> >>Is there any support for managing the data offline in OFBiz web POS?
> >>
> >> I think we don't have any support for offline order taking, if you want
> to
> >> use offline for the web, you can use serviceworker.
> >>
> >>
> >> Kind Regards,
> >> Deepak Dixit
> >> DIRECTOR OF PRODUCT ENGINEERING
> >> mobile: +91 9826754548
> >> email: deepak.di...@hotwax.co
> >> *www.hotwax.co <http://www.hotwax.co/>*
> >>
> >>
> >> On Mon, May 4, 2020 at 12:01 PM Deepak Nigam <
> deepak.nigam1...@gmail.com>
> >> wrote:
> >>
> >> > Hello all,
> >> >
> >> > I hope everyone is doing well in this tough time of the global
> pandemic.
> >> >
> >> > Is there any support for managing the data offline in OFBiz web POS?
> >> > Suppose the scenario wherein the internet connectivity got dropped
> for a
> >> > few minutes, still, the business wants to use the POS system and
> >> continue
> >> > its operations. Any possibility of achieving this requirement?
> >> >
> >> > Thanks & Regards
> >> > --
> >> > Deepak Nigam
> >> >
> >>
> >
> >
> >
> >
>


Re: Updating OFBiz from 16.11.07 to 17.12.03

2020-05-05 Thread Pierre Smits
Hi Jukka,

Yes, you are correct in understanding that the project has moved from svn
to git. There may still be pages in the wiki and elsewhere that are not
reflecting that.

That being said, using a release is the way to go for doing an
implementation for 'production' purposes. The project advises not to use
code directly from the repositories for production purposes.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Tue, May 5, 2020 at 9:07 AM Jukka Palko  wrote:

> Thank you Pierre.
>
> Yes, the setup was directly with MariaDB as the backend as there was not
> much interest in
> using the embedded DB in the future in comparison to the rich features of
> an external
> RDBMS and the person going to maintain the database does understand
> MySQL/MariaDB
> from previous experience.
>
> I can see that the page you referred me to shows as the first command to
> run subversion
> update. I have done the install using a tarball.
>
> Would it be recommendable to do the install initially rather with getting
> the sources using
> subversion/git than downloading the tarball for future ease of upgrading?
> Have I
> understood correctly that the project has been changing toward git with
> the newer code
> branches?
>
> I also just noticed actually that I had not found this page, or just
> missed the bit earlier, that
> actually does refer to svn commands:
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide[1]
> <https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide%5B1%5D>
>
>
> Best regards,
> Jukka
>
> On Tuesday, 5 May 2020 09.40.22 EEST Pierre Smits wrote:
> > Hi Jukka,
> >
> > First of all: welcome!
> >
> > If you're still evaluating OFBiz in a non-production setup (e.g. with the
> > embedded Apache Derby RDBMS as the data store) you can just replace the
> > 16.11.07 code by the 17.12.03 code in the folder of your choice.
> >
> > However, if you already setup your OFBiz implementation with an external
> > (production-grade) RDBMS - like MySQL/PostgreSQL/etc. - and have
> production
> > data in play, you need to do more.
> > Not only do you need have backups of your data and the various
> > configuration files, but you also need to assess whether replacement of
> the
> > 16.11.07 code with the new version has an impact on customisation you may
> > have. There may be data (entity) model changes in play:
> > https://cwiki.apache.org/confluence/display/OFBIZ/
> Revisions+Requiring+Data+Migration+-+upgrade+ofbiz
> >
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Tue, May 5, 2020 at 8:26 AM Jukka Palko  wrote:
> >
> > > Hello,
> > >
> > > I tried to ask this question with my protonmail email earlier on
> upgrading
> > > to 17.12.01 but I think protonmail is a bit troubled with mailing
> lists.
> > > So, a retry with my GMail subscribed to the list.
> > >
> > > I'm basically completely new to OFBiz but not new to system
> administration
> > > in
> > > general with more than 20 years of Linux and Unix experience.
> > >
> > > My question is what are the upgrade procedures for an OFBiz
> installation. I
> > > have done a MariaDB database on Debian 10 and configured OFBiz to use
> that
> > > as
> > > the backend.
> > >
> > > I can write up a wiki page of the install should that be found useful.
> I
> > > basically did the documentation in a text file of the procedures used
> as
> > > I'm trying to help a local small business in starting to use the
> software.
> > >
> > > The installation was built using command
> > > ./gradlew --parallel-threads=8 cleanAll loadDefault
> > >
> > > I configured a systemd service file for the installation as follows:
&g

Re: Updating OFBiz from 16.11.07 to 17.12.03

2020-05-04 Thread Pierre Smits
Hi Jukka,

First of all: welcome!

If you're still evaluating OFBiz in a non-production setup (e.g. with the
embedded Apache Derby RDBMS as the data store) you can just replace the
16.11.07 code by the 17.12.03 code in the folder of your choice.

However, if you already setup your OFBiz implementation with an external
(production-grade) RDBMS - like MySQL/PostgreSQL/etc. - and have production
data in play, you need to do more.
Not only do you need have backups of your data and the various
configuration files, but you also need to assess whether replacement of the
16.11.07 code with the new version has an impact on customisation you may
have. There may be data (entity) model changes in play:
https://cwiki.apache.org/confluence/display/OFBIZ/Revisions+Requiring+Data+Migration+-+upgrade+ofbiz


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Tue, May 5, 2020 at 8:26 AM Jukka Palko  wrote:

> Hello,
>
> I tried to ask this question with my protonmail email earlier on upgrading
> to 17.12.01 but I think protonmail is a bit troubled with mailing lists.
> So, a retry with my GMail subscribed to the list.
>
> I'm basically completely new to OFBiz but not new to system administration
> in
> general with more than 20 years of Linux and Unix experience.
>
> My question is what are the upgrade procedures for an OFBiz installation. I
> have done a MariaDB database on Debian 10 and configured OFBiz to use that
> as
> the backend.
>
> I can write up a wiki page of the install should that be found useful. I
> basically did the documentation in a text file of the procedures used as
> I'm trying to help a local small business in starting to use the software.
>
> The installation was built using command
> ./gradlew --parallel-threads=8 cleanAll loadDefault
>
> I configured a systemd service file for the installation as follows:
> --
> [Unit]
> Description=OFBiz Service Daemon
> After=network.target auditd.service
> After=network-online.target
> Wants=network-online.target
>
> [Service]
> User=ofbiz
> WorkingDirectory=/srv/ofbiz/apache-ofbiz
> ExecStart=/srv/ofbiz/apache-ofbiz/gradlew ofbiz
> ExecStop=/srv/ofbiz/apache-ofbiz/gradlew 'ofbiz --shutdown'
>
> [Install]
> WantedBy=multi-user.target
> --
>
> The installation is running fine I guess which is to say that it does not
> seem
> to complain on any web page I've browsed on it thus far.
>
> However, I did the install while 16.11.07 was the newest version and now
> there
> is the version 17.12.03 available. What are the update/upgrade steps to
> move
> my install from the previous version to the new one?
>
>
> Best regards,
> Jukka Palko
>
>


Re: Offline data management in OFBiz web POS

2020-05-03 Thread Pierre Smits
Hi Deepak,

One solution could be to run the OFBiz instance that is used to host the
WebPOS component in a LAN.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Mon, May 4, 2020 at 8:31 AM Deepak Nigam 
wrote:

> Hello all,
>
> I hope everyone is doing well in this tough time of the global pandemic.
>
> Is there any support for managing the data offline in OFBiz web POS?
> Suppose the scenario wherein the internet connectivity got dropped for a
> few minutes, still, the business wants to use the POS system and continue
> its operations. Any possibility of achieving this requirement?
>
> Thanks & Regards
> --
> Deepak Nigam
>


Re: Handle different tax percentage (by product) - Gl Accounts

2020-05-01 Thread Pierre Smits
Hi Ingo,

Thank you for bringing this to the attention of the community. IIRC, this
issue has popped up before and tickets may already exist in JIRA, see
either:

   -
   
https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened%2C%20%22Patch%20Available%22)%20AND%20component%20%3D%20accounting%20AND%20text%20~%20%22tax%22
   -
   
https://issues.apache.org/jira/issues/?jql=project%20%3D%20OFBIZ%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened%2C%20%22Patch%20Available%22)%20AND%20component%20%3D%20accounting%20AND%20text%20~%20%22vat%22

AFAICT, this issue (of having spare GL accounts for the various tax/VAT
variants hasn't had the traction yet to get this resolved.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Fri, May 1, 2020 at 10:47 AM Ingo Wolfmayr 
wrote:

> Hi everybody,
>
> I have the following (country specific) case: different products - with
> different specific tax percentage
>
> product1 20%
> product2 10%
> product3 13%
>
> I have setup product categories assigned to the TaxAuthorityRateProduct
> and the products. Tax is calulated as expected - invoice is fine. When it
> comes to glAccount posting I need the different taxtypes booked on
> different glAccounts - 10% on glAccount for 10% tax a.s.o.
>
> I have updated the TaxAuthorityGlAccounts (adding
> TaxAuthorityRateProductId) and the corresponding parts in the
> GeneralLederService.
>
> I was wondering if someone else had the same task and would share a rough
> insight on how it was solved?
>
> Best regards,
> Ingo
>


Re: OFBiz Community Days – February 2020

2020-04-28 Thread Pierre Smits
Hi Devanshu,

Thanks. Looking forward to seeing the results of the survey soon.


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Tue, Apr 28, 2020 at 10:43 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Thanks Devanshu
>
> Always interesting
>
> Jacques
>
> Le 28/04/2020 à 08:35, Devanshu Vyas a écrit :
> > Hello All,
> >
> > I hope everyone is doing well in these tough times of the global pandemic
> > COVID-19.
> >
> > First, a big thank you to all who participated in the previous OFBiz
> > Community days.
> > We had another good community days, and the community worked on around 28
> > issues, more details can be found here [1].
> >
> > Please refer to this document [2] for the responses of the survey.
> > Our next community day is planned on 22nd to 26th May 2020, and for more
> > details please refer to this document [3], stay tuned!
> >
> > Be Safe, Be Healthy, Keep contributing!!
> >
> > Thanks again Sharan Foga for building the assets and documentation
> related
> > to OFBiz Community Days.
> >
> > [1]
> >
> https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=318&projectKey=OFBIZ&view=reporting&chart=sprintRetrospective&sprint=601
> > [2]
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/February+2020+-+Community+Day+Survey
> > [3]
> >
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Community+Days+Dates
> >
> > Thanks & Regards,
> > Devanshu Vyas.
> >
> >
> > On Mon, Mar 9, 2020 at 6:07 PM Swapnil M Mane 
> > wrote:
> >
> >> Please excuse me for the typo.
> >>
> >> On Mon, Mar 9, 2020 at 6:01 PM Swapnil M Mane 
> >> wrote:
> >>
> >>> Hello all,
> >>> A gentle reminder to feel this short survey (as today is the last day)
> >>> https://www.surveymonkey.com/r/XCHQQ6Z
> >>>
> >> * feel --> fill
> >> Although it's a great feeling to work in OFBiz Community day! ;-)
> >>
> >>
> >>> *IMPORTANT NOTE*: Please only complete the survey if you participated
> in
> >>> February Community Day.
> >>>
> >>> Best regards,
> >>> Swapnil M Mane,
> >>> ofbiz.apache.org
> >>>
> >>>
> >>>
> >>> On Mon, Mar 2, 2020 at 5:50 PM Devanshu Vyas <
> vyas.devansh...@gmail.com>
> >>> wrote:
> >>>
> >>>> Hello all,
> >>>>
> >>>> A big thank so much to everyone who participated in the OFBiz
> community
> >>>> day. Every contribution matters!
> >>>>
> >>>> We'd also like anyone who participated to complete a brief survey.
> This
> >>>> will help us gather some feedback and information about how we can
> >> improve
> >>>> future Community Days.
> >>>>
> >>>> *IMPORTANT NOTE*: Please only complete the survey if you
> >>>> actually participated in Community Day.
> >>>>
> >>>> Please feel this short survey, (There are only 9 questions so it
> really
> >>>> won't take much time)
> >>>> https://www.surveymonkey.com/r/XCHQQ6Z
> >>>>
> >>>> The survey will be open until *March 9th, 2020.* and I will document
> the
> >>>> results on the Wiki and publish it on the mailing list.
> >>>>
> >>>> P.S. We have closed the "OFBiz Community Day (Feb 2020)" Jira sprint.
> >>>>
> >>>> Thanks & Regards,
> >>>> Devanshu Vyas.
> >>>>
> >>>>
> >>>> On Fri, Feb 21, 2020 at 10:50 AM Devanshu Vyas <
> >> vyas.devansh...@gmail.com
> >>>> wrote:
> >>>>
> >>>>> Thank you Nicolas for taking care of creating some sub-tickets and
> the
> >>>>> request of Dan. :)
> >>>>> I will create some more sub-tickets today.
> >>>>>
> >>>>>
> >>>>> Thanks & Regards,
> >>>>> Devanshu Vyas.
> >>>>>
> >&

Re: [Updates] Demo instance for OFBiz 17.12

2020-04-14 Thread Pierre Smits
Thanks Swapnil

Op wo 15 apr. 2020 07:37 schreef Pawan Verma :

> Awesome, Great Job Swapnil :)
> --
> Thanks & Regards
> Pawan Verma
> ofbiz.apache.org
>
>
> On Tue, Apr 14, 2020 at 9:27 PM Jacques Le Roux <
> jacques.le.r...@les7arts.com> wrote:
>
> > +1 :)
> >
> > Jacques
> >
> > Le 14/04/2020 à 17:08, Suraj Khurana a écrit :
> > > Thanks for the update, Swapnil.
> > > Much appreciated.
> > >
> > > --
> > > Best Regards,
> > > Suraj Khurana
> > > Senior Technical Consultant
> > >
> > > On Tue, Apr 14, 2020 at 6:50 PM Swapnil M Mane <
> swapnilmm...@apache.org>
> > > wrote:
> > >
> > >> Dear OFBiz Users,
> > >> As you are aware, we have recently released the newer version of
> > >> OFBiz, 17.12.01.
> > >>
> > >> Now, the 17.12 release is also available on our demo instance for
> quick
> > >> access,
> > >>-- Backend Management (ERP) Applications at [1]
> > >>-- Front End E-Commerce Webstore at [2]
> > >>
> > >> More details can be found at
> https://ofbiz.apache.org/ofbiz-demos.html
> > >>
> > >> If you need any further assistance, please feel free to contact us.
> > >>
> > >> [1]
> > >>
> >
> https://demo-stable.ofbiz.apache.org/ordermgr/control/main?USERNAME=admin&PASSWORD=ofbiz&JavaScriptEnabled=Y
> > >> [2] https://demo-stable.ofbiz.apache.org/ecommerce/control/main
> > >>
> > >> P.S. With these updates, we have removed the demo instance for old
> > >> OFBiz release, 13.07.
> > >>
> > >> - Best regards,
> > >> Swapnil M Mane,
> > >> ofbiz.apache.org
> > >>
> >
>


Re: Right align table column

2020-03-18 Thread Pierre Smits
Jacques,

I would say that PR48 is more generic.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Wed, Mar 18, 2020 at 8:46 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Pierre,
>
> Do these changes include Daniel's?
>
> Also I have this link for a while and I think it's interesting, for the
> backend at least: https://jrl.ninja/etc/1/
>
> Jacques
>
> Le 18/03/2020 à 08:26, Pierre Smits a écrit :
> > Hi James, Daniel,
> >
> > With https://github.com/apache/ofbiz-framework/pull/48 I have brought
> > forward some changes to the styles in the available themes to align these
> > to some conventions.
> >
> > Met vriendelijke groet,
> >
> > Pierre Smits
> > *Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/>
> since
> > 2008 (without privileges)
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Wed, Mar 18, 2020 at 5:52 AM James Yong  wrote:
> >
> >> Hi Daniel,
> >>
> >> Thanks for the solution.
> >> Surprised that the css style isn't available out of the box.
> >>
> >> Regards,
> >> James
> >>
> >> On 2020/03/14 16:55:18, Daniel Watford  wrote:
> >>> Hi James,
> >>>
> >>> Please take a look at this test plugin for a demonstration -
> >>> https://github.com/danwatford/ofbizGridTest
> >>>
> >>> Place the plugin contents in folder $ofbiz/plugins/gridTest and then
> >>> clean/build/run according to the README.md file.
> >>>
> >>> This plugin displays GlAccounts on its main page.
> >>>
> >>> In the GridTestForms.xml file note use of the title-style and
> >> widget-style
> >>> attributes for the Field elements..
> >>>
> >>> Columns can be right-aligned using CSS - see GridTest.css.
> >>>
> >>> GridTest.css is included in the main screen by:
> >>>
> >>>  >>> value="/gridTest/css/GridTest.css" global="true"/>
> >>>
> >>> Try applying different styles to get different effects. I've included a
> >> few.
> >>> Hope that helps,
> >>>
> >>> Dan.
> >>>
> >>>
> >>> On Sat, 14 Mar 2020 at 09:44, James Yong  wrote:
> >>>
> >>>> Hi all,
> >>>>
> >>>> How can I right-align certain columns in grid widget?
> >>>>
> >>>> Regards,
> >>>> James
> >>>>
> >>>
> >>> --
> >>> Daniel Watford
> >>>
>


Re: Right align table column

2020-03-18 Thread Pierre Smits
Hi James, Daniel,

With https://github.com/apache/ofbiz-framework/pull/48 I have brought
forward some changes to the styles in the available themes to align these
to some conventions.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor** of* Apache OFBiz <https://ofbiz.apache.org/> since
2008 (without privileges)

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Wed, Mar 18, 2020 at 5:52 AM James Yong  wrote:

> Hi Daniel,
>
> Thanks for the solution.
> Surprised that the css style isn't available out of the box.
>
> Regards,
> James
>
> On 2020/03/14 16:55:18, Daniel Watford  wrote:
> > Hi James,
> >
> > Please take a look at this test plugin for a demonstration -
> > https://github.com/danwatford/ofbizGridTest
> >
> > Place the plugin contents in folder $ofbiz/plugins/gridTest and then
> > clean/build/run according to the README.md file.
> >
> > This plugin displays GlAccounts on its main page.
> >
> > In the GridTestForms.xml file note use of the title-style and
> widget-style
> > attributes for the Field elements..
> >
> > Columns can be right-aligned using CSS - see GridTest.css.
> >
> > GridTest.css is included in the main screen by:
> >
> >  > value="/gridTest/css/GridTest.css" global="true"/>
> >
> > Try applying different styles to get different effects. I've included a
> few.
> >
> > Hope that helps,
> >
> > Dan.
> >
> >
> > On Sat, 14 Mar 2020 at 09:44, James Yong  wrote:
> >
> > > Hi all,
> > >
> > > How can I right-align certain columns in grid widget?
> > >
> > > Regards,
> > > James
> > >
> >
> >
> > --
> > Daniel Watford
> >
>


Re: Ofbiz as back end for POS

2020-02-23 Thread Pierre Smits
The limitation of one OFBiz implentation handling multiple tenants depends
on:

   - memory available for OFBiz on the machine hosting the implementation
   - settings regarding the pool-size of the used (underlying) RDBMS

If you want to host  a solution for dozens, 100s or 1000s of
clients/customers you need to High Availabilit/FailOver aspects. Clustering
on various levels comes to mind.

Met vriendelijke groet,

Pierre Smits
*Proud* *contributor* (but unfortunately without privileges)* of* Apache
OFBiz <https://ofbiz.apache.org/>, since 2008

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Sun, Feb 23, 2020 at 9:10 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Le 22/02/2020 à 18:51, Alaa Murad a écrit :
> > Thanks a lot for all replies, one important feature that we need is to
> be able to run unlimited companies  (with Chinese Walls between them) , do
> we
> > really need to have a new DB for each company ?
>
> According to
> https://www.experts-exchange.com/articles/6539/Multi-tenant-Database-Shared-Database-Separate-Schema-in-SQL-Server.html
>
> There are mostly 3 ways to implement multitenant Separate Databases Shared
> Database, Separate Schemas Shared Database, Shared Schema
>
> OFBiz uses the 1st. So with this way you will have as much as *tenant* DBs
> as you introduce *tenants*. Pro and cons are explained in the document
> above.
>
>
> > how that will even work, one risk that caching (from JDBC driver, or
> Ofbiz itself)  maybe a problem , i.e. this is not PHP were each call is
> 100%
> > hitting the db, in Java we cache many stuff in JVM memory ! unless this
> will result in a new ofbiz instance (in JVM) in this case running ofbiz as
> > SaaS will be very expensive.
> >
> >
> > Our POS system is a SaaS and we may have 100s or 1000s of
> clients/companies and we don't want to spin a new ofbiz instance for each
> one !
>
> There should not be worries with caching. Because with "multitenant
> Separate Databases" you run only one OFBiz instance with a DB per tenant
> but,
> thanks to the delegator concept, OFBiz knows what data belong to what
> tenant.
>
> This said currently there is no mechanism to automatically create tenants
> DBs on fly in OFBiz. So you would need to implement that. For 100s to 1000s
> client it's at the limit of reasonable. I worked for a client who hoped
> for much more (up to millions). Then OFBIz is hardly suitable and a
> solution
> based on OFBiz in this case demands a lot of code change.
>
> >
> > I'm confused a bit about "2 tenants"  and that we need to have 2
> databases for each !
>
> I hope the article above helps.
>
> HTH
>
> Jacques
>
> >
> >
> > Thanks in advance !
> >
> >
> > On 2/20/20 2:09 PM, Jacques Le Roux wrote:
> >> Hi,
> >>
> >> Inline completing Pierre's answer as much as possible
> >>
> >> Le 20/02/2020 à 08:37, Pierre Smits a écrit :
> >>> On Thu, Feb 20, 2020 at 2:15 AM Alaa Murad 
> wrote:
> >>>   2. We are planning to use ofbiz for few different companies, they all
> >>>  100% independent, can we have one ofbiz instance for all of them
> ?how ?
> >>>
> >>> In this scenario I would advice to set up 2 tenants to ensure having
> >>> Chinese Walls between the 2 companies. Each tenant would have its own
> >>> database, and can have different plugins in play.
> >>
> >> BTW, you may have as most as tenants you need
> >>
> >>
> >>>
> >>>>   3. How easy to sync/push products, invoices , payments , etc. from
> our
> >>>>  POS --> ofbiz (i.e. can we insert invoice via APIs)
> >>
> >> You may follow one of the suggested ways here:
> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
> >>
> >> Be sure to compare with the other different possible ways documented in
> the children pages of this page and pick the one (or several) which best
> >> fit/s your needs.
> >>
> >>
> >>>
> >>>>   5. I do see Arabic support implemented to some degree, but is it
> full
> >>>>  support, for example currency format, RTL (both web and PDF)
> >>
> >> RTL is supported in Web, I don't think it is in PDF. Currency is
> supported in both. Since we are using NotoSans font by default you can use
> a very
> >> large set of characters in PDF.
> >>
> >> You may have a look at
> https://demo-trunk.ofbiz.apache.org/example/control/fonts.pdf
> >>
> >>>>   6. Finally, how stable/active is ofbiz ? I see 30-40 emails per
> month
> >>>>  only in the mailing list, this make me very worry !
> >>
> >> OFBiz was born in 2001, became a Top Level Project (TLP) in Apache
> Software Foundation (ASF) in 2006 and was mature around 2010.
> >>
> >> So yes it's pretty stable and safe (security). Since OFBiz is mature
> the activity as decreased with a pick around 2016 as you can see here:
> >>
> >> https://ofbiz.markmail.org/
> >>
> >> HTH
> >>
> >> Jacques
> >>
>


Re: Ofbiz as back end for POS

2020-02-19 Thread Pierre Smits
Hi Alaa Murad,

First of all, welcome to the community.

Please see inline for some of the answers (I cannot answer regarding Odoo).
Hopefully some other community members can provide you with
additional answers


Met vriendelijke groet,

Pierre Smits
*Proud* *contributor* (but unfortunately without privileges)* of* Apache
OFBiz <https://ofbiz.apache.org/>, since 2008

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Thu, Feb 20, 2020 at 2:15 AM Alaa Murad  wrote:

> I'm a long follower of ofbiz , but I have some questions before I do use
> it in a big project, we have our own custom POS / App and we are looking
> to have ERP integrated with it.
>
>  1. I do see the Accounting section, but I can't see the basic and must
> have reports like Balance sheet, P/L statement, cash flow statement
> ! am I looking at the wrong place ? !
>

Yes. These functions are available in the accounting component, but are a
bit difficult to find The way to find them are:

   1. in the main menu of the accounting component go to 'Organisation GL
   Setup. In demo you'll see:
   https://demo-trunk.ofbiz.apache.org/accounting/control/ListCompanies
   2. click the 'Accounting' button. In demo you'll see:
   https://demo-trunk.ofbiz.apache.org/accounting/control/PartyAccountsSummary
   3. click the reports buttons. In demo you'll see
   
https://demo-trunk.ofbiz.apache.org/accounting/control/TrialBalance?organizationPartyId=Company

Then you'll see the various statements to generate



>  2. We are planning to use ofbiz for few different companies, they all
> 100% independent, can we have one ofbiz instance for all of them ?how ?
>

In this scenario I would advice to set up 2 tenants to ensure having
Chinese Walls between the 2 companies. Each tenant would have its own
database, and can have different plugins in play.



>  3. How easy to sync/push products, invoices , payments , etc. from our
> POS --> ofbiz (i.e. can we insert invoice via APIs)

 4. How far behind ofbiz is from odoo (mainly accounting / sales)?
>  5. I do see Arabic support implemented to some degree, but is it full
> support, for example currency format, RTL (both web and PDF)
>  6. Finally, how stable/active is ofbiz ? I see 30-40 emails per month
> only in the mailing list, this make me very worry !
>
>
> Thanks
>
>


Re: Apache ofbiz features info needed

2020-02-17 Thread Pierre Smits
Hi Alexander,

First of all: welcome to the community, and thanks for your contribution.

Please see inline


Best regards,

Pierre Smits
*Proud* *contributor* (but without privileges)* of* Apache OFBiz
<https://ofbiz.apache.org/>, since 2008

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Mon, Feb 17, 2020 at 4:54 PM Szalonnas Alexander <
alexander.szalon...@datapac.sk> wrote:

> Hi,
>
> I would like to ask you to answer with YES or NO that the following
> features are covered or not in Apaches Ofbiz's ERP system (somehow I
> haven't found any answer for this in docs/ wiki/ mail lists, etc.):
>

Tja The project can definitely use some contributions in those areas.


> Status (operational, closed, under reconstruction,...) - YES or NO
>
It is unclear which entity/object this relates to. But various entities
capture status values.


> Store attributes- YES or NO
>
No. Currently there is no ProductStoreAttr entity to capture store
attributes.


> Area/size- YES or NO
>
Yes & No. There are currently in the ProductStore entities no fields to
capture that. However, given that a store is associated with a warehouse,
the values can be set there.


> Opening hours- YES or NO
>
NO. A calendar feature to  associate the opening hours with a ProductStore
is not available.


> Service offering- YES or NO
>
Unclear what you mean with that. Can you elaborate?


> Stuff count- YES or NO
>
NO. A calendar feature to  associate the opening hours with a ProductStore
is not available.


> Custom defineable attributes- YES or NO
>
Yes & No.  Various entities allow both predefined attribute definitions and
custom definable ones.
It is unclear for what you need 'custom definable attributes'

Stock types- YES or NO
>
Unclear what you mean with that. Can you elaborate?


> Regular stock- YES or NO
>
Yes, if you mean QoH or AtP


> Reserved stock- YES or NO
>
Yes. Inventory can be reserved.


> Consignment stock- YES or NO
>
Yes. But


> Other types- YES or NO
>
Unclear what you mean with that. Can you elaborate?


>
>
>
>
> Thank you!
>
>
> Best Regards,
>
> Alexander Szalonnas
>
>


Re: OFBiz Tutorial ofbizDemo Error Message Hello? World?

2020-02-12 Thread Pierre Smits
Hi Steve,

Welcome to the community.

I suggest you forget about the ofbizDemo. If you had no problems getting
your OFBiz implementation to start with both seed and demo data loaded,
then you should be able to connect to one of the other components included
via the browser (e.g. https://localhost:8443/catalog ).

For the rest see inline.

Best regards,

Pierre Smits
*Proud* *contributor* (but without privileges)* of* Apache OFBiz
<https://ofbiz.apache.org/>, since 2008

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Wed, Feb 12, 2020 at 8:25 PM Steve Carroll  wrote:

> I have JDK1.8.0_241 and apache-ofbiz-16.11.07 installed on a 64 bit
> Windows 10 machine. I can log in and interact with ofbiz, but when I try to
> visit ofbizDemo I get taken to
> https://localhost:8443/ofbizDemo/control/main which displays the
> following Error Message:
>
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> screen [component://ofbizDemo/widget/OfbizDemoScreens.xml#main]:
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> screen
> [component://ofbizDemo/widget/CommonScreens.xml#OfbizDemoCommonDecorator]:
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> screen [component://ofbizDemo/widget/CommonScreens.xml#main-decorator]:
> java.lang.IllegalArgumentException: Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US] (Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US]) (Error rendering screen
> [component://ofbizDemo/widget/CommonScreens.xml#main-decorator]:
> java.lang.IllegalArgumentException: Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US] (Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US])) (Error rendering screen
> [component://ofbizDemo/widget/CommonScreens.xml#OfbizDemoCommonDecorator]:
> org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering
> screen [component://ofbizDemo/widget/CommonScreens.xml#main-decorator]:
> java.lang.IllegalArgumentException: Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US] (Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US]) (Error rendering screen
> [component://ofbizDemo/widget/CommonScreens.xml#main-decorator]:
> java.lang.IllegalArgumentException: Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US] (Could not find resource bundle
> [OfbizDemoUiLabels] in the locale [en_US])))
>
> I am not a programmer or a developer. I am a single user business owner
> who wants to have an erp system in place by the time I'm ready to expand. I
> would like to get setup with a usable install of ofbiz. I was not prepared
> to go down this rabbit hole.
>
> So, in addition to helping me with the error message above, I'm hoping
> that the community can guide me (tell me) how to accomplish the following:
>
> Write a program or script that starts ofbiz with the correct databases and
> options set so that the end user never faces a command prompt.


Correct database set up is defined in the entityengine.xml file. The
database definitions (when downloaded, and not adjusted) point to a
embedded and not-production grade database (Apache Derby).



> I assume this is a really easy, but super secret trick that programmers
> keep to themselves. Please tell me how to do it.
>

When you have your local implementation in good working order, there is no
need to have end users to deal with a command prompt. Every end user would
be accessing your implementation via the browser. Only maintenance (system
admin) issues are expected to partly be handled via the command line
interface.



> How to add and remove packages.
>

Which packages (components in OFBiz) are you considering to remove? Many
components in the framework and applications folders are highly
interlinked/integratoed Everything in themes can be removed, except one
(this could be your favourite or default).

Adding 3rd party components (and others) can be installed in the hot-deploy
folder. You have three options there:

   1. Get hold of the zip file of a 3rd party component and copy/paste and
   unpack there, or
   2. Fork a 3rd party plugin in Github, and clone that into the hot-deploy
   folder.
   3. Create your own. There is a cli command to set up a blank component,
   with the correct file structure and basic files and data-sets.




> How to load my own instance of ofbiz without example data.
>

Ensure that your implementation is clean data-wise. Then only load seed,
seed-ext and ext data-sets, but not the demo data

Re: Ofbiz on Ubuntu 19.10

2020-02-12 Thread Pierre Smits
In order for the community to able to help you with this issue, please
provide some additional details like:

   - which OFBiz revision/version (branch or release) did you use, and
   where did you get it from;
   - what is the JAVA version that was implemented with your Ubuntu version?

Typically, the first issue adopters have to resolve is the misalignment of
the implemented JAVA version and the OFBiz requirement therefore.

Best regards,

Pierre Smits
*Proud* *contributor* (but without privileges)* of* Apache OFBiz
<https://ofbiz.apache.org/>, since 2008

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Wed, Feb 12, 2020 at 12:00 PM Banking.my
 wrote:

> I have been trying to install Ofbiz on Ubuntu Stdio 19.10; but, it fails
> to install for unmet dependencies. Ubuntu Studio uses the low-latency XFCE
> DE, which must lack many of the more refined features of DEs like Mate,
> Cinammon & Gnome.
>
> For OTB functionality, which linux distros and DEs do you recommend?
> Should I be trying this with a Red Hat distro?
>
> Sent with [ProtonMail](https://protonmail.com) Secure Email.


Re: Does "product Image" can refer to a standard URL?

2020-02-10 Thread Pierre Smits
Hi Jean-Ives,

Please raise a ticket in our JIRA.

Best regards,

Pierre Smits
*Proud* *contributor* (but without privileges)* of* Apache OFBiz
<https://ofbiz.apache.org/>, since 2008

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
Apache Steve <https://steve.apache.org>, committer


On Mon, Feb 10, 2020 at 5:55 AM Jean-Yves Landry  wrote:

> hi,
>
> If my product picture exist on an external server, referencing them in
> catalogue seems to work but not in "econseo" or "ecommerce".
>
> Instead of accessing http://192.168.202.246/bibb.png...
>
> it does the following URL:
> https://192.168.202.246:8443/ecomseo/product/http%3A%2F%2F192.168.202.246%2Fbibb.png
>
>


Re: Unsubscribe from Mailing List

2020-02-04 Thread Pierre Smits
HI Garima,

You can unsubscribe yourself. Your Hotwac co-workers should be able to tell
you how to achieve this.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Tue, Feb 4, 2020 at 1:12 PM Garima Jain  wrote:

> I request you to unsubscribe me from your mailing list.
>
> --
>
>
> *Kind Regards*
> Garima Jain
> Sr. Software Engineer
> Indore
>


Re: Solr Demo

2020-02-03 Thread Pierre Smits
The solr component (and all adopters) would surely benefit if it were to be
enhanced with such screens.
Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Mon, Feb 3, 2020 at 12:56 PM Ravi Lodhi  wrote:

> Hi James,
>
> I think there is no screen available which is driven by Solr as of now
> where you can test directly but there are backend services to index and
> search products which is using default product schema. So you can test the
> Solr Integration by calling these services from webtools application.
>
> Follow below steps to test keyword search -
> *1. rebuildSolrIndex* - Run this service to build Solr Index. This will
> indexed available product data.
> *Note:* You can run this service from OFBiz webtools. Login to webtools
> application and go to this page
> https://demo-trunk.ofbiz.apache.org/webtools/control/runService. Enter the
> service name *rebuildSolrIndex *and run that service without passing any
> parameters for testing purpose (It will use default indexName which is
> solrDefault).
>
> *2. solrKeywordSearch* - Run this service to search products based on
> keywords. To run this service navigate to above mentioned page
> <https://demo-trunk.ofbiz.apache.org/webtools/control/runService> in
> webtools application. Enter the service name *solrKeywordSearch *and run
> that service.  You will see following input/output parameters of this
> service- facetQuery,indexName(Default
> solrdefault),query,queryFilter,returnFields,sortBy,sortByReverse,viewIndex
> and viewSize. The *query *parameter is mandatory and indexName is default
> to solrDefault.
>
> Prepare your query string and pass it to query parameter. e.g.
> *internalName:Giant
> Widget *. This will bring all the products where internalName
> contains Giant or Widget or both the keyword.
>
> For your custom need it might possible that you need to enhance or redesign
> Solr Schema.
>
> HTH!
>
> Thanks,
> Ravi Lodhi
>
> On Mon, Jan 27, 2020 at 7:12 PM  wrote:
>
> > Michael we are looking to be able to look for a product in ofbiz like a
> > google search and the system will look in all indexes, including
> > keywords, features, variants, etc
> >
> > So if i searched for something like "500 watt lightbulb 100v 5000K"
> >
> > it will return all products that have those keywords, features or
> > combination thereof.  Is that a part of the standard demo?
> >
> > Thanks,
> >
> > Quincy
> >  Original Message 
> > Subject: Re: Solr Demo
> > From: Michael Brohl 
> > Date: Sun, January 26, 2020 11:24 pm
> > To: user@ofbiz.apache.org
> >
> > Hi James,
> >
> > the official demos include the Solr integration. I'm not sure what you
> > are missing, can you specify more detailed what you like to see?
> >
> > Thanks,
> >
> > Michael Brohl
> >
> > ecomify GmbH - www.ecomify.de
> >
> >
> > Am 27.01.20 um 02:15 schrieb ja...@productive1.com:
> > > Is there a demo of the Solr integration with Ofbiz?
> > >
> > > Thanks,
> > >
> > > James
> >
>


Re: Over ship

2020-01-29 Thread Pierre Smits
Hi James,

I would say that the technical implementation of such a feature should not
be that difficult.

The question is more related to the use-case. Where do you envision that
this is controlled to allow over-shipping
? Meaning, should this be:

   1. a generic setting for the internal organisation allowing this, or
   2. a setting in an agreement between the internal organisation and the
   opposite party to allow this for all orders under the agreement, or
   3. a setting on the order allowing it for the specific order?

I can imagine that flexibility dictates that #3 overrides #2, and #2
overrides #1

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Wed, Jan 29, 2020 at 2:32 PM  wrote:

> Team - There are several instances where a business will need to over
> ship a sales order.  Products like Netsuite and SAP allow for this.
> What is the best way to accomplish this in Ofbiz
>
> Example:
>
> Customer Orders 100LBs of GZ-1000
> In the warehouse they pack and ship 105LBS
> Invoice should be for 105LBS
>
> Today Ofbiz does not allow this, but what are the related
> tables/entities that need to be modified to make this work?
>
> Thanks,
>
> James
>
>


Re: Error Invoking Service

2020-01-23 Thread Pierre Smits
HI James,

Your log excerpt shows 'org.opentaps.foundation.service'. Are you confident
that you're using the product of this project?

Your excerpt shows that the user does not have permissions for the service
'createSupplierProduct' in the Product component. Please check your
permissions.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Thu, Jan 23, 2020 at 2:58 PM  wrote:

>
> We are getting the following error when adding a product on a Purchase
> Order:
>
> The Following Errors Occurred:
> Failed to add item due to internal error:
> org.opentaps.foundation.service.ServiceException:
> org.ofbiz.service.ServiceAuthException: You do not have permission to
> invoke the service [createSupplierProduct] (You do not have permission
> to invoke the service [createSupplierProduct])
> (org.ofbiz.service.ServiceAuthException: You do not have permission to
> invoke the service [createSupplierProduct] (You do not have permission
> to invoke the service [createSupplierProduct])).
>
> I looked and my user is the admin user.  Anyone know where to look to
> resolve this?
>
> Thanks,
>
> James
>


Re: Installation trouble

2020-01-23 Thread Pierre Smits
I would be happy to tackle that one, but I am still waiting on somebody
willing to help me get some other contributions in.

Op do 23 jan. 2020 13:08 schreef Michael Brohl :

> Feel free to improve them if you see room for optimization, Pierre.
>
> Thanks,
>
> Michael Brohl
>
> ecomify GmbH - www.ecomify.de
>
>
> Am 23.01.20 um 13:00 schrieb Pierre Smits:
> > Perhaps the instructions are not as clesr as they could be...
> >
> > Op do 23 jan. 2020 12:38 schreef L :
> >
> >> ./gradlew loadAll doesn't do anything and supplies no output.  It just
> >> returns to the CLI instantly:
> >>
> >> [root@localhost ofbiz]# ./gradlew loadAll
> >> [root@localhost ofbiz]#
> >>
> >> On 1/22/20 9:08 AM, Parminder S. Lehal wrote:
> >>> The problem lies with the download files. Some of the zip files *even
> >>> the latest 16.11 zip) does not have gradlew file included in them. It
> >>> is pathetic that the final package file served  from the mirrors is
> >>> incomplete(May be someone will pay some attention to this decline
> >>> in quality). I also found this after wasting some time.  Easier
> >>> solution may be to use svn for downloading whatever version you are
> >>> looking for.
> >>> On Wed, 2020-01-22 at 10:32 +0100, Gil Portenseigne wrote:
> >>>> On Wed, Jan 22, 2020 at 10:30:14AM +0100, Gil Portenseigne wrote:
> >>>>> Hello,
> >>>>>
> >>>> Typo :And you should be able to : $ ./gradlew loadAll
> >>
> >>
>
>


Re: Installation trouble

2020-01-23 Thread Pierre Smits
Perhaps the instructions are not as clesr as they could be...

Op do 23 jan. 2020 12:38 schreef L :

> ./gradlew loadAll doesn't do anything and supplies no output.  It just
> returns to the CLI instantly:
>
> [root@localhost ofbiz]# ./gradlew loadAll
> [root@localhost ofbiz]#
>
> On 1/22/20 9:08 AM, Parminder S. Lehal wrote:
> > The problem lies with the download files. Some of the zip files *even
> > the latest 16.11 zip) does not have gradlew file included in them. It
> > is pathetic that the final package file served  from the mirrors is
> > incomplete(May be someone will pay some attention to this decline
> > in quality). I also found this after wasting some time.  Easier
> > solution may be to use svn for downloading whatever version you are
> > looking for.
> > On Wed, 2020-01-22 at 10:32 +0100, Gil Portenseigne wrote:
> >> On Wed, Jan 22, 2020 at 10:30:14AM +0100, Gil Portenseigne wrote:
> >>> Hello,
> >>>
> >> Typo :And you should be able to : $ ./gradlew loadAll
>
>
>


Re: Please add me to the list

2020-01-13 Thread Pierre Smits
Welcome Bajarang

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Mon, Jan 13, 2020 at 2:30 PM Bajarang 
wrote:

> Hi,
>
>
>
> Can you please add me to Ofbiz Contributor list, we are doing development
> services on Ofbiz and want to get added on the list.
>
>
>
> My user id is: bajarang
>
>
>
> Thank you and Best Regards,
>
> Bajarang
>
>


OFBiz and E-commerce Payment Gateways

2020-01-08 Thread Pierre Smits
Hi all,

First of all allows me to wish you all a happy and prosperous new year.

In the past I have created some E-Commerce Payment Gateway (EPG) plugins
like for MultiSafepay and Adyen (see [1] and [2]). And I am looking forward
to continue that kind of contribution to the OFBiz community by adding more
relevant EPGs.

What would you like to see taken on? State your implemented OFBiz version
and preference

[1] https://github.com/ORRTIZ/omultisafepay
[2] https://github.com/ORRTIZ/oadyen

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


Re: Fixed Asset: Disposal

2020-01-03 Thread Pierre Smits
Hi Bagas,

The short answer is: use the form as shown in [1], and fill the appropriate
fields as per your accounting rules and guidelines and add the appropriate
line items.

[1]
https://demo-trunk.ofbiz.apache.org/accounting/control/FindAcctgTrans?organizationPartyId=Company

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Tue, Dec 24, 2019 at 4:47 AM Bagas Sanjaya  wrote:

> So how can I create corresponding accounting transaction for EOL'ed asset?
>
> On 23/12/19 17.51, Pierre Smits wrote:
> > Hi Max,
> >
> > Per [1] you can set the end of life date of an asset. However, the does
> not
> > automatically lead to an accounting transaction. You'll have to add the
> > associated accounting transaction via [2] by creating a new one.
> >
> > [1]
> >
> https://demo-trunk.ofbiz.apache.org/assetmaint/control/EditFixedAsset?fixedAssetId=DEMO_PROJECTOR
> > [2]
> >
> https://demo-trunk.ofbiz.apache.org/accounting/control/FindAcctgTrans?organizationPartyId=Company
> >
> > I trust the above gives you an indication how to do this. Should you,
> > however, have any other questions and/or remarks, please let us know.
> > Best regards,
> >
> > Pierre Smits
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
> privileges)
> > since 2008*
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Fri, Dec 20, 2019 at 6:56 PM Max Peak  wrote:
> >
> >> Hi all,
> >>
> >> In accounting application, how does one dispose (sell, dumpsterize) a
> >> fixed asset? I have not found a way to remove an item from fixed assets.
> >>
> >> Thanks
> >>
> >>
> >
>
> --
> An old man doll... just what I always wanted! - Clara
>


Re: Global GL chart of accounts

2019-12-23 Thread Pierre Smits
Instead of putting GlSetupDemoData into a custom component, you can as well
copy the content into a new xml file and adjust that to your
liking/requirements and after you have it validated as sufficient copy-past
that content into the appreciate field of [1] and process it from there


[1] https://demo-trunk.ofbiz.apache.org/webtools/control/EntityImport

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Mon, Dec 23, 2019 at 12:30 PM Suraj Khurana 
wrote:

> Hello Max,
>
> For that, you can copy GlSetupDemoData into custom component with 'ext' or
> different reader and load data without demo reader.
>
> HTH.
> --
> Best Regards,
> Suraj Khurana
> TECHNICAL CONSULTANT
> mobile: +91 9669750002
>
> On Fri, Dec 20, 2019 at 11:23 PM Max Peak  wrote:
>
> > Hi all,
> >
> > I would like to set up new company from scratch. How can I load just the
> > global chart of accounts but not the demo data?
> >
> > Thanks
> >
> >
>


Re: Global GL chart of accounts

2019-12-23 Thread Pierre Smits
Hi Max,

You cn start by importing the seed and seed-ext data in your OFBiz
instance, and subsequently your Chart of Account data through the
WebTools-import functions.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Fri, Dec 20, 2019 at 6:53 PM Max Peak  wrote:

> Hi all,
>
> I would like to set up new company from scratch. How can I load just the
> global chart of accounts but not the demo data?
>
> Thanks
>
>


  1   2   3   4   5   6   7   8   9   10   >