Re: Multi Tenancy Support

[Nicola Mazzoni]

Hi Mallah,
Thanks a lot of information, I didn't know about this possibility!
As far as intercompany management is concerned, you are certainly right, it
is not worth making such a big rework. In my experience, however, I had
that problem in the case of clients with different companies. I'm talking
about a single customer with many companies. They were accustomed with
other ERPs to a single table and all the management of consolidated
financial statements and business intelligence systems was based on
individual tables. Consider that having multicompany structures with the
same shared account plan managed on the same table has many advantages that
you can hardly achieve with different schemes. You just need the example of
the chart of accounts, which can be managed identical for all the companies
in the group (therefore without duplicating it in N schema), in this case
the id of the company is zero, so the same chart of accounts is valid for
all companies. I guarantee you that in certain environments accustomed to
SAP or JDE a multidatabase structure could be a serious constraint.
Regards
N

Il giorno gio 17 ott 2019 alle ore 08:25 Rajesh Mallah <
mallah.raj...@gmail.com> ha scritto:

> Hi Nicola ,
>
> Many advanced databases like postgresql and oracle  (possibly mysql)
> Allow the feature of "schemas" which are namespaces within same database.
>
> OFBiz already allows specification of  schema in entityengine.xml.
> interschema SQL queries are already allowed.
>
> Hence creating a DB for each tenant is also a matter of choice.
> The DB permission structure around schemas allows implementation
> of access control.
>
> >>  It would be an
> >> interesting feature to make ofbiz multicompany but it would imply a
> heavy
> >> revision of the data model.
>
> I think it is not worth , also it will make customers jittery to remain in
> shared tables.
>
> regds
> mallah.
>
>
>
>
> On Thu, Oct 17, 2019 at 11:16 AM Nicola Mazzoni  >
> wrote:
>
> > Hi,
> > The multitenant structure is ootb in ofbiz and is based on multiple db.
> In
> > practice, each tenant uses a different database.  Other ERPs have the
> > company id in the pk of all tables, so it is possible to use multiple
> > companies with a single database, this is very useful in intercompany
> > management.  However, having separate databases allows a clearer
> > segregation of data but greater management difficulties.  It would be an
> > interesting feature to make ofbiz multicompany but it would imply a heavy
> > revision of the data model.
> > Best regards
> > Nm
> >
> >
> > Il mer 2 ott 2019, 12:04 Suraj Khurana  ha
> > scritto:
> >
> > > Hello Sridharreddy,
> > >
> > > Yes, OFBiz support multi-tenancy. This document might help you:
> > >
> > > https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support
> > >
> > > --
> > > Kind Regards,
> > > Suraj Khurana
> > > Technical Consultant
> > > HotWax Systems
> > > Enterprise open source experts
> > > http://www.hotwaxsystems.com
> > >
> > >
> > >
> > >
> > >
> > >
> > > On Wed, Oct 2, 2019 at 3:29 PM sridharreddy u  >
> > > wrote:
> > >
> > > > Dear Support,
> > > >
> > > > We sell SAAS software to Financial Organisation. Each Organisation
> > needs
> > > > their own ERP for account management.  So, we are evaluating OFBIZ to
> > use
> > > > this purpose. We will integrate our application with OFBIZ (as
> plugin)
> > > and
> > > > each organisation will have their own view of accounting.
> > > >
> > > > Does OFBIZ support multi tenancy model where I deploy OFBIZ (with
> > single
> > > > instance in scalable mode) in CLOUD and each organisation will be
> able
> > to
> > > > access their own data.
> > > >
> > > > If not, do you have any suggestion on how to USE OFBIZ for multi
> > tenancy
> > > > purpose.
> > > >
> > > >
> > > > BR,
> > > > Sridhar Reddy U
> > > >
> > >
> >
>


-- 
Nicola Mazzoni


*Mp Styl**e Srl*
via Meucci, 37
41019 Limidi di Soliera (MO)
T 059/684916
M 347/9905529

www.mpstyle.it

RE: Invoice Item Type

[james]

So if the invoice is $100how can we clear the $15 with a commission
invoice?

 Original Message 
Subject: Re: Invoice Item Type
From: S K Pradeep Kumar 
Date: Tue, October 15, 2019 2:50 am
To: user@ofbiz.apache.org

Hi James,

Amazon $15 is a commission for product listing, so, you can use the
commission feature in the ofbiz.
Look at commission run :
https://demo-stable.ofbiz.apache.org/ap/control/CommissionRun

Remaining everything is going as its. Just link the commission invoice
with
actual order invoiceId as parent Id.

With regards,
S K Pradeep Kumar,
9035009495


On Mon, Oct 14, 2019 at 11:19 PM  wrote:

> Good Day. We are trying to determine if Invoice Item Type can be used
> for processing Amazon orders in Ofbiz.
> Here is the scenario
>
> Customer purchases product on amazon.com for a total of $100.
> We process the order from amazon but we have to account for amazon fees
> of $15
> So we want to show the order subtotal of $100 Amazon fees as new invoice
> item type of -$15 (similar to how discounts work)
> Total Order is $85.
>
> When Amazon sends us the payment it will be for $85 and we can process
> the $85 to close out the invoice.
>
> Question. How can we add an additional invoice item type called Amazon
> Fees? How can we trigger it to be added on the sales order?
>
> Thanks,
>
> James
>

Re: Multi Tenancy Support

[Michael Brohl]

Hi Rajesh,

I'm not sure if I understand correctly: are you offering to provide the 
fix under the condition that you are being paid for it?


Regards,

Michael


Am 16.10.19 um 17:47 schrieb Rajesh Mallah:

Hi

We are willing to sponsor the resolution of this issue.
https://issues.apache.org/jira/browse/OFBIZ-10284

Conditions are:

(1) We have a limited budget hence the effort analysis needs to be done and
a reasonable quote is to be presented.
(2) The fix should be good enough that it gets merged into the ofbiz trunk
( in other words we are willing to contribute the fix back to community).

I am open to discuss and explain the issue in depth.
Kindly contact privately to mal...@redgrape.tech

Regards
Director
Redgrape Technologies Pvt Ltd.
India.









On Thu, Oct 3, 2019 at 10:50 PM Rajesh Mallah 
wrote:


Hi

Multitenency is supported with OOTB interfaces . But when it comes to
integrating the ofbiz
framework with other systems the Webservices do not support it. For SAAS
operators
multi-tenancy is a game-changing feature, due to the issue above  i am
forced to
create separate installations.

An issue was filed and a patch was contributed, But i request senior and
experienced
contributors to look into it.

https://issues.apache.org/jira/browse/OFBIZ-10284

Thanks & Regards

mallah.


On Wed, Oct 2, 2019 at 3:34 PM Suraj Khurana 
wrote:


Hello Sridharreddy,

Yes, OFBiz support multi-tenancy. This document might help you:

https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support

--
Kind Regards,
Suraj Khurana
Technical Consultant
HotWax Systems
Enterprise open source experts
http://www.hotwaxsystems.com






On Wed, Oct 2, 2019 at 3:29 PM sridharreddy u 
wrote:


Dear Support,

We sell SAAS software to Financial Organisation. Each Organisation needs
their own ERP for account management.  So, we are evaluating OFBIZ to

use

this purpose. We will integrate our application with OFBIZ (as plugin)

and

each organisation will have their own view of accounting.

Does OFBIZ support multi tenancy model where I deploy OFBIZ (with single
instance in scalable mode) in CLOUD and each organisation will be able

to

access their own data.

If not, do you have any suggestion on how to USE OFBIZ for multi tenancy
purpose.


BR,
Sridhar Reddy U





smime.p7s
Description: S/MIME Cryptographic Signature

Re: Multi Tenancy Support

[mallah.rajesh]

Hi Michael, No i am requesting someone to fix it.My company would bear the cost 
of time and effort in doing so.Regds Mallah.Sent from my Samsung Galaxy 
smartphone.
 Original message From: Michael Brohl 
 Date: 18/10/2019  02:06  (GMT+05:30) To: 
user@ofbiz.apache.org Subject: Re: Multi Tenancy Support Hi Rajesh,I'm not sure 
if I understand correctly: are you offering to provide the fix under the 
condition that you are being paid for it?Regards,MichaelAm 16.10.19 um 17:47 
schrieb Rajesh Mallah:> Hi>> We are willing to sponsor the resolution of this 
issue.> https://issues.apache.org/jira/browse/OFBIZ-10284>> Conditions are:>> 
(1) We have a limited budget hence the effort analysis needs to be done and> a 
reasonable quote is to be presented.> (2) The fix should be good enough that it 
gets merged into the ofbiz trunk> ( in other words we are willing to contribute 
the fix back to community).>> I am open to discuss and explain the issue in 
depth.> Kindly contact privately to mal...@redgrape.tech>> Regards> Director> 
Redgrape Technologies Pvt Ltd.> India.>> On Thu, Oct 3, 2019 at 10:50 
PM Rajesh Mallah > wrote:>>> Hi Multitenency is 
supported with OOTB interfaces . But when it comes to>> integrating the ofbiz>> 
framework with other systems the Webservices do not support it. For SAAS>> 
operators>> multi-tenancy is a game-changing feature, due to the issue above  i 
am>> forced to>> create separate installations. An issue was filed and a 
patch was contributed, But i request senior and>> experienced>> contributors to 
look into it. https://issues.apache.org/jira/browse/OFBIZ-10284 Thanks 
& Regards mallah.>> On Wed, Oct 2, 2019 at 3:34 PM Suraj Khurana 
>> wrote:> Hello Sridharreddy,>> Yes, OFBiz 
support multi-tenancy. This document might help you:>> 
https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support>> 
-->>> Kind Regards,>>> Suraj Khurana>>> Technical Consultant>>> HotWax 
Systems>>> Enterprise open source experts>>> 
http://www.hotwaxsystems.com> On Wed, Oct 2, 2019 at 3:29 
PM sridharreddy u >>> wrote:>>> Dear 
Support, We sell SAAS software to Financial Organisation. Each 
Organisation needs their own ERP for account management.  So, we are 
evaluating OFBIZ to>>> use this purpose. We will integrate our application 
with OFBIZ (as plugin)>>> and each organisation will have their own view of 
accounting. Does OFBIZ support multi tenancy model where I deploy OFBIZ 
(with single instance in scalable mode) in CLOUD and each organisation will 
be able>>> to access their own data. If not, do you have any 
suggestion on how to USE OFBIZ for multi tenancy purpose. 
BR, Sridhar Reddy U

Re: OFBiz Sanity Test Automation

[Sanjay Yadav]

Team,

I didn't get chance to work on it due to some other priorities. Sorry about
that.

Thanks.
--
Sanjay Yadav
Manager, Enterprise Quality Assurance
*HotWax Systems*
*Enterprise open source experts*
cell: +91-787.918.8830
http://www.hotwaxsystems.com


On Fri, Sep 27, 2019 at 9:53 AM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Hi Sanjay, Paul,
>
> What is the situation?
>
> Thanks
>
> Jacques
>
> Le 29/08/2018 à 07:24, Sanjay Yadav a écrit :
> > Thank you for the reminder, Paul. I completely missed it due to the long
> > gap. will check it now.
> >
> > Best Regards,
> >
> > *Sanjay Yadav* | Manager, Enterprise Quality Assurance
> > HotWax Commerce  by HotWax Systems
> > 
> > 80, Scheme No. 78, Indore, M.P. 452010, India
> > Mobile Phone: 787 918 8830 | Linkedin: Sanjay-Yadav
> > 
> >
> >
> >
> > On Mon, Aug 27, 2018 at 11:08 AM Paul Foxworthy 
> wrote:
> >
> >> Hi Sanjay,
> >>
> >> When we discussed this last year (
> >>
> http://ofbiz.135035.n4.nabble.com/OFBiz-Sanity-Test-Document-td4707889.html
> >> )
> >> you said you would check out Geb and Spock.
> >>
> >> I really think there are major productivity gains in writing tests that
> use
> >> logical page components. Selenium is much more low-level, and the tests
> >> will be much more fragile and will need continuous maintenance. Is
> there a
> >> reason you decided to use Selenium?
> >>
> >> There's a discussion of one person's experience at
> >>
> https://allegro.tech/2015/05/automated-tests-with-geb-spock-and-groovy.html
> >> .
> >>
> >> Cheers
> >>
> >> Paul
> >>
> >> On Thu, 23 Aug 2018 at 22:42, girish...@gmail.com 
> >> wrote:
> >>
> >>>
> >>> On 2018/08/23 09:08:46, Taher Alkhateeb 
> >>> wrote:
>  Hello, is this going to be implemented in Selenium? If yes then
>  perhaps we should move this discussion to dev@ to make sure we get
>  this right. Functional tests might be very slow and so we might need
>  to decide whether to include these tests by default with the
>  "testIntegration" task for example.
>  On Thu, Aug 23, 2018 at 11:53 AM Rishi Solanki <
> >> rishisolan...@gmail.com>
> >>> wrote:
> > +1, and yes go for 17.12 + Trunk. And first pick the 17.12 as it
> >> would
> >>> be
> > stable compare to trunk,
> >
> >
> > --
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> >
> > On Thu, Aug 23, 2018 at 2:09 PM Sanjay Yadav <
> >>> sanjay.ya...@hotwaxsystems.com>
> > wrote:
> >
> >> Yes, Michael:).Thanks.
> >>
> >> Thanks, Jacques.
> >>
> >> Best Regards,
> >>
> >> *Sanjay Yadav* | Manager, Enterprise Quality Assurance
> >> HotWax Commerce  by HotWax Systems
> >> 
> >> 80, Scheme No. 78, Indore, M.P. 452010, India
> >> Mobile Phone: 787 918 8830 | Linkedin: Sanjay-Yadav
> >> 
> >>
> >> On Wed, Aug 22, 2018 at 12:55 PM Michael Brohl <
> >>> michael.br...@ecomify.de>
> >> wrote:
> >>
> >>> +1 Sanjay,
> >>>
> >>> as I mentioned in
> >>>
> >>>
> >>
> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Sanity+Test?focusedCommentId=71014351#comment-71014351
> >>> ;-)
> >>>
> >>> Regards,
> >>>
> >>> Michael Brohl
> >>> ecomify GmbH
> >>> www.ecomify.de
> >>>
> >>>
> >>> Am 22.08.18 um 08:22 schrieb Sanjay Yadav:
>  Hello All,
> 
>  I am planning to automate below sanity test script. Please feel
> >>> free to
>  share your thoughts.
> 
> >>> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Sanity+Test
>  Which OFBiz version I should target?
>  Do I need to create a JIRA ticket before starting on it?
> 
>  Best Regards,
> 
>  *Sanjay Yadav* | Manager, Enterprise Quality Assurance
>  HotWax Commerce  by HotWax Systems
>  
>  80, Scheme No. 78, Indore, M.P. 452010, India
>  Mobile Phone: 787 918 8830 | Linkedin: Sanjay-Yadav
>  
> 
> >>>
> >>>
> >>> +1 Sanjay - If you're planning to go with Selenium, you might as well
> >>> include Selenium Grid set-up. I would think its integration with Docker
> >> is
> >>> possible as well.
> >>>
> >>> Taher - Selenium test cases should not be part of build process. I
> would
> >>> agree on this.
> >>>
> >>>
> >> --
> >> Coherent Software Australia Pty Ltd
> >> PO Box 2773
> >> Cheltenham Vic 3192
> >> Australia
> >>
> >> Phone: +61 3 9585 6788
> >> Web: http://www.coherentsoftware.com.au/
> >> Email: i...@coherentsoftware.com.au
>