You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Emad Radwan <er...@gmail.com> on 2022/10/16 14:33:26 UTC
Default Accounting Company
Hello Community,
Assuming more than one accounting company is defined, how Ofbiz will
determine which one to use?
I see there is a configuration for the 'Store' to tell the
'Pay_to_partyId', and the store is linked to Facility,
but again what if more than two stores are defined, which
facility/product/inventory mix will be used while for example creating a
sales order?
Appreciate it if you shed some light on this.
Regards,
Emad
Re: Default Accounting Company
Posted by Ashish Vijaywargiya <as...@hotwaxsystems.com>.
Correct, Giulio was saying the same thing.
You can perform the same operations from here as well:
https://demo-stable.ofbiz.apache.org/catalog/control/FindProductStoreRoles?productStoreId=9100
Please refer to the following link to understand the existing Security
Permission model in OFBiz.
https://cwiki.apache.org/confluence/x/NIBr
--
Kind Regards,
Ashish Vijaywargiya
Vice President of Operations
*HotWax Systems*
*Enterprise open source experts*
http://www.hotwaxsystems.com
On Tue, Oct 18, 2022 at 4:56 PM Emad Radwan <er...@gmail.com> wrote:
> Hi Giulio,
>
> Thanks. For # 1, if product store roles mean that I configure a store and
> add certain employees - Parties - to it with named roles like the
> following, then yes, this is what I want.
>
> Regards,
> Emad
>
> <ProductStoreRole partyId="admin" roleTypeId="SALES_REP" productStoreId="
> 9000" fromDate="2001-05-13 12:00:00.0"/>
>
> On Mon, Oct 17, 2022 at 7:09 PM Giulio Speri - MpStyle Srl <
> giulio.speri@mpstyle.it> wrote:
>
> > Hi Emad,
> >
> > I answer below.
> >
> > 1) I am not sure I fully understood your question here, but I think that
> > backoffice UI customization, alongside with Product Store Roles are
> needed
> > to achieve your goal.
> >
> > 2) ProductStoreFacility entity relates 1 or more ProductFacility to a
> > Store; the Facilities (for a Store) are basically the Warehouses where
> > products are taken/reserved from.
> > IE: if a ProductStore is setup with two Facilities A and B and a
> SalesOrder
> > for the product PRD001 comes in, then the system (if configured to check
> > and/or reserve inventory) checks in the facility A if there is enough
> > quantity for the product and, if not, checks in the Facility B.
> > You can configure each facility with a specific Sequence Number in
> > ProductStoreFacility so that you can choose the right order of
> inspection.
> >
> > 3) The ProductStorePaymentSetting controls which Payment Methods are
> shown
> > to the users for a specific ProductStore; then each PaymentMethod has its
> > own logic implemented behind.
> >
> > I hope it helps.
> >
> > Kind regards,
> > Giulio
> >
> > Il giorno lun 17 ott 2022 alle ore 14:53 Emad Radwan <
> > eradwan1967@gmail.com>
> > ha scritto:
> >
> > > Thanks Giulio and Ashish for the valuable input.
> > >
> > > Few more clarifications, please.
> > >
> > > 1 - If ofbiz is being used locally - no e-commerce - and two stores are
> > > defined, how to restrict employees - users - taking the order to be
> > limited
> > > only to one of these stores?
> > >
> > > 2 - What is the role of ProductStoreFacility? Since in demo data only a
> > few
> > > records are configured but even though much more products are available
> > > while creating orders?
> > >
> > > 3 - What exactly controls the Payment Methods presented to the user
> while
> > > creating a sales order, we have configurations in
> > > ProductStorePaymentSetting and PaymentMethod; are both used or there is
> > > extra logic here?
> > >
> > > Regards,
> > > Emad
> > >
> > > On Mon, Oct 17, 2022 at 1:26 PM Ashish Vijaywargiya <
> > > ashish.vijaywargiya@hotwaxsystems.com> wrote:
> > >
> > > > Hello Emad,
> > > >
> > > > Please refer two more entities which will help you to better
> visualise
> > > > setup of stores, facilities, products and inventories:
> > > >
> > > > - ProductFacility -
> > > >
> > > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility
> > > >
> > > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644
> > > >
> > > > - InventoryItem(There is a field facilityId in this entity) -
> > > >
> > > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem
> > > >
> > > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse
> > > >
> > > > Please also refer to sample demo data from OrderDemoData.xml to get
> > more
> > > > details about the other important entities.
> > > >
> > > >
> > >
> >
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml
> > > >
> > > > Hope this helps.
> > > >
> > > > --
> > > > Kind Regards,
> > > > Ashish Vijaywargiya
> > > > Vice President of Operations
> > > > *HotWax Systems*
> > > > *Enterprise open source experts*
> > > > http://www.hotwaxsystems.com
> > > >
> > > >
> > > >
> > > > On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl <
> > > > giulio.speri@mpstyle.it> wrote:
> > > >
> > > > > Hi Emad,
> > > > >
> > > > > You can configure each store to be served by different facilities
> > > > > (ProductStoreFacility entity), setting to N the flag
> > > oneInventoryFacility
> > > > > and then going in the Facility tab of the Product Store and add the
> > > > > facilities you need.
> > > > >
> > > > > Giulio
> > > > >
> > > > > On Sun, Oct 16, 2022, 16:33 Emad Radwan <er...@gmail.com>
> > wrote:
> > > > >
> > > > > > Hello Community,
> > > > > >
> > > > > > Assuming more than one accounting company is defined, how Ofbiz
> > will
> > > > > > determine which one to use?
> > > > > >
> > > > > > I see there is a configuration for the 'Store' to tell the
> > > > > > 'Pay_to_partyId', and the store is linked to Facility,
> > > > > > but again what if more than two stores are defined, which
> > > > > > facility/product/inventory mix will be used while for example
> > > creating
> > > > a
> > > > > > sales order?
> > > > > >
> > > > > > Appreciate it if you shed some light on this.
> > > > > >
> > > > > > Regards,
> > > > > > Emad
> > > > > >
> > > > >
> > > >
> > >
> >
> >
> > --
> > Giulio Speri
> >
> >
> > *Mp Styl**e Srl*
> > via Antonio Meucci, 37
> > 41019 Limidi di Soliera (MO)
> > T 059/684916
> > M 347/0965506
> >
> > www.mpstyle.it
> >
>
Re: Default Accounting Company
Posted by Emad Radwan <er...@gmail.com>.
Hi Giulio,
Thanks. For # 1, if product store roles mean that I configure a store and
add certain employees - Parties - to it with named roles like the
following, then yes, this is what I want.
Regards,
Emad
<ProductStoreRole partyId="admin" roleTypeId="SALES_REP" productStoreId="
9000" fromDate="2001-05-13 12:00:00.0"/>
On Mon, Oct 17, 2022 at 7:09 PM Giulio Speri - MpStyle Srl <
giulio.speri@mpstyle.it> wrote:
> Hi Emad,
>
> I answer below.
>
> 1) I am not sure I fully understood your question here, but I think that
> backoffice UI customization, alongside with Product Store Roles are needed
> to achieve your goal.
>
> 2) ProductStoreFacility entity relates 1 or more ProductFacility to a
> Store; the Facilities (for a Store) are basically the Warehouses where
> products are taken/reserved from.
> IE: if a ProductStore is setup with two Facilities A and B and a SalesOrder
> for the product PRD001 comes in, then the system (if configured to check
> and/or reserve inventory) checks in the facility A if there is enough
> quantity for the product and, if not, checks in the Facility B.
> You can configure each facility with a specific Sequence Number in
> ProductStoreFacility so that you can choose the right order of inspection.
>
> 3) The ProductStorePaymentSetting controls which Payment Methods are shown
> to the users for a specific ProductStore; then each PaymentMethod has its
> own logic implemented behind.
>
> I hope it helps.
>
> Kind regards,
> Giulio
>
> Il giorno lun 17 ott 2022 alle ore 14:53 Emad Radwan <
> eradwan1967@gmail.com>
> ha scritto:
>
> > Thanks Giulio and Ashish for the valuable input.
> >
> > Few more clarifications, please.
> >
> > 1 - If ofbiz is being used locally - no e-commerce - and two stores are
> > defined, how to restrict employees - users - taking the order to be
> limited
> > only to one of these stores?
> >
> > 2 - What is the role of ProductStoreFacility? Since in demo data only a
> few
> > records are configured but even though much more products are available
> > while creating orders?
> >
> > 3 - What exactly controls the Payment Methods presented to the user while
> > creating a sales order, we have configurations in
> > ProductStorePaymentSetting and PaymentMethod; are both used or there is
> > extra logic here?
> >
> > Regards,
> > Emad
> >
> > On Mon, Oct 17, 2022 at 1:26 PM Ashish Vijaywargiya <
> > ashish.vijaywargiya@hotwaxsystems.com> wrote:
> >
> > > Hello Emad,
> > >
> > > Please refer two more entities which will help you to better visualise
> > > setup of stores, facilities, products and inventories:
> > >
> > > - ProductFacility -
> > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility
> > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644
> > >
> > > - InventoryItem(There is a field facilityId in this entity) -
> > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem
> > >
> > >
> >
> https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse
> > >
> > > Please also refer to sample demo data from OrderDemoData.xml to get
> more
> > > details about the other important entities.
> > >
> > >
> >
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml
> > >
> > > Hope this helps.
> > >
> > > --
> > > Kind Regards,
> > > Ashish Vijaywargiya
> > > Vice President of Operations
> > > *HotWax Systems*
> > > *Enterprise open source experts*
> > > http://www.hotwaxsystems.com
> > >
> > >
> > >
> > > On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl <
> > > giulio.speri@mpstyle.it> wrote:
> > >
> > > > Hi Emad,
> > > >
> > > > You can configure each store to be served by different facilities
> > > > (ProductStoreFacility entity), setting to N the flag
> > oneInventoryFacility
> > > > and then going in the Facility tab of the Product Store and add the
> > > > facilities you need.
> > > >
> > > > Giulio
> > > >
> > > > On Sun, Oct 16, 2022, 16:33 Emad Radwan <er...@gmail.com>
> wrote:
> > > >
> > > > > Hello Community,
> > > > >
> > > > > Assuming more than one accounting company is defined, how Ofbiz
> will
> > > > > determine which one to use?
> > > > >
> > > > > I see there is a configuration for the 'Store' to tell the
> > > > > 'Pay_to_partyId', and the store is linked to Facility,
> > > > > but again what if more than two stores are defined, which
> > > > > facility/product/inventory mix will be used while for example
> > creating
> > > a
> > > > > sales order?
> > > > >
> > > > > Appreciate it if you shed some light on this.
> > > > >
> > > > > Regards,
> > > > > Emad
> > > > >
> > > >
> > >
> >
>
>
> --
> Giulio Speri
>
>
> *Mp Styl**e Srl*
> via Antonio Meucci, 37
> 41019 Limidi di Soliera (MO)
> T 059/684916
> M 347/0965506
>
> www.mpstyle.it
>
Re: Default Accounting Company
Posted by Giulio Speri - MpStyle Srl <gi...@mpstyle.it>.
Hi Emad,
I answer below.
1) I am not sure I fully understood your question here, but I think that
backoffice UI customization, alongside with Product Store Roles are needed
to achieve your goal.
2) ProductStoreFacility entity relates 1 or more ProductFacility to a
Store; the Facilities (for a Store) are basically the Warehouses where
products are taken/reserved from.
IE: if a ProductStore is setup with two Facilities A and B and a SalesOrder
for the product PRD001 comes in, then the system (if configured to check
and/or reserve inventory) checks in the facility A if there is enough
quantity for the product and, if not, checks in the Facility B.
You can configure each facility with a specific Sequence Number in
ProductStoreFacility so that you can choose the right order of inspection.
3) The ProductStorePaymentSetting controls which Payment Methods are shown
to the users for a specific ProductStore; then each PaymentMethod has its
own logic implemented behind.
I hope it helps.
Kind regards,
Giulio
Il giorno lun 17 ott 2022 alle ore 14:53 Emad Radwan <er...@gmail.com>
ha scritto:
> Thanks Giulio and Ashish for the valuable input.
>
> Few more clarifications, please.
>
> 1 - If ofbiz is being used locally - no e-commerce - and two stores are
> defined, how to restrict employees - users - taking the order to be limited
> only to one of these stores?
>
> 2 - What is the role of ProductStoreFacility? Since in demo data only a few
> records are configured but even though much more products are available
> while creating orders?
>
> 3 - What exactly controls the Payment Methods presented to the user while
> creating a sales order, we have configurations in
> ProductStorePaymentSetting and PaymentMethod; are both used or there is
> extra logic here?
>
> Regards,
> Emad
>
> On Mon, Oct 17, 2022 at 1:26 PM Ashish Vijaywargiya <
> ashish.vijaywargiya@hotwaxsystems.com> wrote:
>
> > Hello Emad,
> >
> > Please refer two more entities which will help you to better visualise
> > setup of stores, facilities, products and inventories:
> >
> > - ProductFacility -
> >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility
> >
> >
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644
> >
> > - InventoryItem(There is a field facilityId in this entity) -
> >
> >
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem
> >
> >
> https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse
> >
> > Please also refer to sample demo data from OrderDemoData.xml to get more
> > details about the other important entities.
> >
> >
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml
> >
> > Hope this helps.
> >
> > --
> > Kind Regards,
> > Ashish Vijaywargiya
> > Vice President of Operations
> > *HotWax Systems*
> > *Enterprise open source experts*
> > http://www.hotwaxsystems.com
> >
> >
> >
> > On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl <
> > giulio.speri@mpstyle.it> wrote:
> >
> > > Hi Emad,
> > >
> > > You can configure each store to be served by different facilities
> > > (ProductStoreFacility entity), setting to N the flag
> oneInventoryFacility
> > > and then going in the Facility tab of the Product Store and add the
> > > facilities you need.
> > >
> > > Giulio
> > >
> > > On Sun, Oct 16, 2022, 16:33 Emad Radwan <er...@gmail.com> wrote:
> > >
> > > > Hello Community,
> > > >
> > > > Assuming more than one accounting company is defined, how Ofbiz will
> > > > determine which one to use?
> > > >
> > > > I see there is a configuration for the 'Store' to tell the
> > > > 'Pay_to_partyId', and the store is linked to Facility,
> > > > but again what if more than two stores are defined, which
> > > > facility/product/inventory mix will be used while for example
> creating
> > a
> > > > sales order?
> > > >
> > > > Appreciate it if you shed some light on this.
> > > >
> > > > Regards,
> > > > Emad
> > > >
> > >
> >
>
--
Giulio Speri
*Mp Styl**e Srl*
via Antonio Meucci, 37
41019 Limidi di Soliera (MO)
T 059/684916
M 347/0965506
www.mpstyle.it
Re: Default Accounting Company
Posted by Emad Radwan <er...@gmail.com>.
Thanks Giulio and Ashish for the valuable input.
Few more clarifications, please.
1 - If ofbiz is being used locally - no e-commerce - and two stores are
defined, how to restrict employees - users - taking the order to be limited
only to one of these stores?
2 - What is the role of ProductStoreFacility? Since in demo data only a few
records are configured but even though much more products are available
while creating orders?
3 - What exactly controls the Payment Methods presented to the user while
creating a sales order, we have configurations in
ProductStorePaymentSetting and PaymentMethod; are both used or there is
extra logic here?
Regards,
Emad
On Mon, Oct 17, 2022 at 1:26 PM Ashish Vijaywargiya <
ashish.vijaywargiya@hotwaxsystems.com> wrote:
> Hello Emad,
>
> Please refer two more entities which will help you to better visualise
> setup of stores, facilities, products and inventories:
>
> - ProductFacility -
>
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility
>
> https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644
>
> - InventoryItem(There is a field facilityId in this entity) -
>
> https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem
>
> https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse
>
> Please also refer to sample demo data from OrderDemoData.xml to get more
> details about the other important entities.
>
> https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml
>
> Hope this helps.
>
> --
> Kind Regards,
> Ashish Vijaywargiya
> Vice President of Operations
> *HotWax Systems*
> *Enterprise open source experts*
> http://www.hotwaxsystems.com
>
>
>
> On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl <
> giulio.speri@mpstyle.it> wrote:
>
> > Hi Emad,
> >
> > You can configure each store to be served by different facilities
> > (ProductStoreFacility entity), setting to N the flag oneInventoryFacility
> > and then going in the Facility tab of the Product Store and add the
> > facilities you need.
> >
> > Giulio
> >
> > On Sun, Oct 16, 2022, 16:33 Emad Radwan <er...@gmail.com> wrote:
> >
> > > Hello Community,
> > >
> > > Assuming more than one accounting company is defined, how Ofbiz will
> > > determine which one to use?
> > >
> > > I see there is a configuration for the 'Store' to tell the
> > > 'Pay_to_partyId', and the store is linked to Facility,
> > > but again what if more than two stores are defined, which
> > > facility/product/inventory mix will be used while for example creating
> a
> > > sales order?
> > >
> > > Appreciate it if you shed some light on this.
> > >
> > > Regards,
> > > Emad
> > >
> >
>
Re: Default Accounting Company
Posted by Ashish Vijaywargiya <as...@hotwaxsystems.com>.
Hello Emad,
Please refer two more entities which will help you to better visualise
setup of stores, facilities, products and inventories:
- ProductFacility -
https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=ProductFacility
https://demo-stable.ofbiz.apache.org/catalog/control/EditProductFacilities?productId=GZ-2644
- InventoryItem(There is a field facilityId in this entity) -
https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItem
https://demo-stable.ofbiz.apache.org/facility/control/EditFacilityInventoryItems?facilityId=WebStoreWarehouse
Please also refer to sample demo data from OrderDemoData.xml to get more
details about the other important entities.
https://github.com/apache/ofbiz-framework/blob/trunk/applications/datamodel/data/demo/OrderDemoData.xml
Hope this helps.
--
Kind Regards,
Ashish Vijaywargiya
Vice President of Operations
*HotWax Systems*
*Enterprise open source experts*
http://www.hotwaxsystems.com
On Mon, Oct 17, 2022 at 12:01 AM Giulio Speri - MpStyle Srl <
giulio.speri@mpstyle.it> wrote:
> Hi Emad,
>
> You can configure each store to be served by different facilities
> (ProductStoreFacility entity), setting to N the flag oneInventoryFacility
> and then going in the Facility tab of the Product Store and add the
> facilities you need.
>
> Giulio
>
> On Sun, Oct 16, 2022, 16:33 Emad Radwan <er...@gmail.com> wrote:
>
> > Hello Community,
> >
> > Assuming more than one accounting company is defined, how Ofbiz will
> > determine which one to use?
> >
> > I see there is a configuration for the 'Store' to tell the
> > 'Pay_to_partyId', and the store is linked to Facility,
> > but again what if more than two stores are defined, which
> > facility/product/inventory mix will be used while for example creating a
> > sales order?
> >
> > Appreciate it if you shed some light on this.
> >
> > Regards,
> > Emad
> >
>
Re: Default Accounting Company
Posted by Giulio Speri - MpStyle Srl <gi...@mpstyle.it>.
Hi Emad,
You can configure each store to be served by different facilities
(ProductStoreFacility entity), setting to N the flag oneInventoryFacility
and then going in the Facility tab of the Product Store and add the
facilities you need.
Giulio
On Sun, Oct 16, 2022, 16:33 Emad Radwan <er...@gmail.com> wrote:
> Hello Community,
>
> Assuming more than one accounting company is defined, how Ofbiz will
> determine which one to use?
>
> I see there is a configuration for the 'Store' to tell the
> 'Pay_to_partyId', and the store is linked to Facility,
> but again what if more than two stores are defined, which
> facility/product/inventory mix will be used while for example creating a
> sales order?
>
> Appreciate it if you shed some light on this.
>
> Regards,
> Emad
>