Re: Help needed learning and launching OFBiz

2021-08-12 Thread Suraj Khurana
Hello Bryan,

You can also explore and learn more about OFBiz by our Apache OFBiz youtube
channel [1]. It will help you to have more understanding about the
framework.

For production, you can surely go with MySQL database, it works really well
in our case.
To change DB, you need to change the datasource name for all the delgators
present in the entityengine [2] file and provide corresponding db name and
creds in the datasource [3].

HTH.

[1] : https://www.youtube.com/channel/UCxt1NtEaaeIRhMLHjALRe9w
[2] :
https://github.com/apache/ofbiz-framework/blob/2525377569e97d370b06aef00706a6c652a57d82/framework/entity/config/entityengine.xml#L55
[3] :
https://github.com/apache/ofbiz-framework/blob/2525377569e97d370b06aef00706a6c652a57d82/framework/entity/config/entityengine.xml#L361

--

Best Regards,
Suraj Khurana
Technical Consultant


On Thu, Aug 12, 2021 at 1:47 AM Bryan Boone  wrote:

> Hello everyone.  I am new to OFBiz.  I have some questions that I need in
> order to get started.
>
> First, I need to learn about OFBiz.  What are some good resources for me
> to learn about it?  I see some books on Amazon.  I see some videos on
> Youtube.  And I see some documentation online.  Are the books on Amazon any
> good?  If so which one?  I see several.
>
> I am moderate developer charged with building OFBiz and building/modifying
> it for our company needs.  Here are some things that my project requires.
>
>
> Databases must be encrypted.
> Application will need to support thousands of users and potentially
> hundreds of concurrent users.
> Run on AWS EC2 instances.
> Need to support multiple discrete companies who have their own separate
> databases.  I believe “tenants” accomplishes this.
> Support backing up individual databases on a per tenant basis.
>
>
>
> I see that OFBiz comes by default with Derby, but I read that this is not
> a good database for a production environment.  Which database should I go
> with?  PostgreSQL or MySQL?  Or something else?
>
> I am currently trying to setup PostgreSQL, but the documentation is not
> very clear.  When I try to build, it fails.  What/where are the best
> directions for changing the database for OFBiz?
>
> Thanks for any help in advance.


Re: Free Shipping for specific Classification of Customers

2021-07-31 Thread Suraj Khurana
Hi James,

You can use QuantityBreak entity available with type as 'SHIP_PRICE'

HTH.
--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Thu, Jul 29, 2021 at 8:09 PM  wrote:

> For some reason free shipping in promotions doesn't work.
>
> If want to set up free shipping based on the total of the order in
> "Shipping Estimate" I do not have any Price Break ID.  How and where is
> the Price Break ID created?
>
>  Original Message 
> Subject: Re: Free Shipping for specific Classification of Customers
> From: Nicolas Malin 
> Date: Sat, July 24, 2021 11:58 am
> To: user@ofbiz.apache.org
>
> Hello James,
>
> I suggest you to check with product promo rule.
>
> I think you can't use ShipmentCostEstimate due to the present of Party
> classification
>
> Nicolas
>
> On 24/07/2021 12:43, ja...@productive1.com wrote:
> > What is the best way to set up free shipping based on total amount of
> > order and only for specific classifications of customers?
> >
> > Thanks,
> >
> > James
>


Re: Receiving Inventory strange issue

2021-06-22 Thread Suraj Khurana
Hello Woyce,

In that case, please create a Jira ticket for this error you are facing.
TIA.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Fri, Jun 18, 2021 at 5:45 PM Woyce Batkins 
wrote:

> Hello,
> *"Powered by Apache OFBiz. <http://ofbiz.apache.org> Release 17.12"* is
> the
> version that I am using. The value is already entered with the comma, as it
> is automatically populated. I even tried it by removing the value and
> re-entering it manually, but its the same error.
> I have been suspecting a hidden character being inserted somewhere in the
> processing chain, so I switched the language to french, because I also
> happen to speak french and this is the error message that I am receiving:
> Erreur pendant la simple-method: Error while converting *"54Â 000"* to a
> number: For input string: *"54Â 000"* .
> It looks like an encoding issue somewhere may be? Not sure..
>
> On Fri, Jun 18, 2021 at 7:22 AM Suraj Khurana 
> wrote:
>
> > Hi Woyce,
> >
> > Please confirm which OFBiz version you are currently using, so that it
> can
> > be checked.
> > On a cursory review, it seems that if you use 54000 (without comma)
> instead
> > of 54,000 it should work.
> >
> > --
> > Best Regards,
> > Suraj Khurana
> > Senior Technical Consultant
> >
> >
> > On Fri, Jun 18, 2021 at 6:21 AM Woyce Batkins 
> > wrote:
> >
> > > Hello,
> > > I have been trying to receive inventory from a purchase order, but I am
> > > getting a conversion error like the following:
> > > *java.lang.Exception: Error:Error running the simple-method: Error
> while
> > > converting "54,000" to a number: For input string: "54,000" Method =
> > > receiveInventoryProduct File =
> > >
> > >
> >
> file:/apps/ofbiz-framework/applications/product/minilang/shipment/receipt/ShipmentReceiptServices.xml,
> > > Element = , Line 147null*
> > >
> > > I am at a lost here
> > >
> >
>


Re: Receiving Inventory strange issue

2021-06-17 Thread Suraj Khurana
Hi Woyce,

Please confirm which OFBiz version you are currently using, so that it can
be checked.
On a cursory review, it seems that if you use 54000 (without comma) instead
of 54,000 it should work.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Fri, Jun 18, 2021 at 6:21 AM Woyce Batkins 
wrote:

> Hello,
> I have been trying to receive inventory from a purchase order, but I am
> getting a conversion error like the following:
> *java.lang.Exception: Error:Error running the simple-method: Error while
> converting "54,000" to a number: For input string: "54,000" Method =
> receiveInventoryProduct File =
>
> file:/apps/ofbiz-framework/applications/product/minilang/shipment/receipt/ShipmentReceiptServices.xml,
> Element = , Line 147null*
>
> I am at a lost here
>


Re: Apache OFBiz Blog Updates - March 2021

2021-05-01 Thread Suraj Khurana
Thanks Aditya.

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Thu, Apr 29, 2021 at 5:58 PM Aditya Sharma 
wrote:

> Hi Everyone,
>
> Hope you all are well and safe!
>
> A brief summary of our project news for March month can be found in our
> monthly blog update at the link below:
> https://s.apache.org/ofbiz-news-march-2021
>
> This month we have news about the new release, and new committers along
> with our usual list of features, improvements, and Statistics.
>
> Thanks to Jacques Le Roux, Michael Brohl, Mridul Pathak, Pranay Pandey,
> Sharan Foga, Suraj Khurana, and Swapnil M Mane for their continued support.
>
> We are also actively sharing our regular updates on social media platforms.
> If you haven't followed us yet, here are the quick links:
> LinkedIn: https://s.apache.org/a181s
> Twitter: https://s.apache.org/12w5t
> Facebook: https://s.apache.org/la83r
>
> --
> Thanks & Regards,
> Aditya Sharma
>


Re: Invoice Total and Outstanding Amount rounding

2021-03-11 Thread Suraj Khurana
Hello Andrei,

There is a configuration file available
(accounting/config/arithmetic.properties:29). Here you can configure
invoice.decimals and other related configurations.
HTH.

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Thu, Mar 11, 2021 at 11:55 PM Andrei Stan 
wrote:

> Hello,
>
> When trying to import some of my PAID invoices in OFBiz, i expect to have
> Outstanding Amout "0" (paid), but i see that is "-0.04".
>
> It can be tested by import the following into OFBIZ:
>
> 
>  partyIdFrom="Company" partyId="DemoCustCompany" statusId="INVOICE_PAID"
> invoiceDate="2020-11-06 15:26:25.000" dueDate="2020-11-13"
> currencyUomId="RON"/>
>quantity="74.45" amount="121.8675" description="Consultancy services"/>
>partyIdFrom="DemoCustCompany" actualCurrencyAmount="44228.3489"
> currencyUomId="RON" paymentId="TestInvoice" actualCurrencyUomId="RON"
> partyIdTo="Company" paymentTypeId="CUSTOMER_PAYMENT"/>
>paymentId="TestInvoice" invoiceId="TestInvoice" amountApplied="9073.04"/>
> 
>
> The problem here i think is this:
>
> - Invoice Total = quantity * amount (same as Unit Price from the
> InvoiceItem entity) = 74.45 * 121.8675
>
> - the above operation, in the "Invoices List" page is calculated (not as
> expected):
>
> - 74.45 * 121.*867 *(only three decimals - can be seen in the
> "Invoice Overview" page) = to 9,072.99815, wich is rounded to 9,073.00
>
> - the expected result is 74.45 * 121.*8675* (with four
> decimals)=9,073.035375 wich rounded = 9,073.04
>
> - Invoice Total - Payment Applied = 9,073.00 - 9,073.04 = -0.04 ( the
> issue that i got)
>
> How can i set OFBiz to use more that 3 decimals in calculations?
>
> Thanks.
>


Re: Can't have same invoiceID for invoices created in different years

2021-02-22 Thread Suraj Khurana
Hi Andrie,

You can also use prefix in invoice id's to always make them unique, if you
want to generate the sequence every year then the current year can be made
as InvoiceIdPrefix in PartyAcctgPreference entity.

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Mon, Feb 22, 2021 at 11:16 AM Aditya Sharma 
wrote:

> Hi Andrie,
>
> Though accounting is not forte, I think you could use the reference number
> field to store the external invoice id and let the invoiceId be the
> system's auto-generated value.
>
> HTH
> Thanks and regards,
> Aditya Sharma
>
> On Sun, Feb 21, 2021 at 4:38 PM Andrei Stan 
> wrote:
>
> > Hello Michael,
> > Thank you for reply.
> > Can you suggest any best practices when having multiple invoices and at
> > the end of the (fiscal) year one wishes to reset the invoice counter?
> > Is there an option in ofbiz to do that?
> > Thanks,
> > A.
> >
> > On 21.02.2021 00:28, Michael Brohl wrote:
> > > Hi Andrei,
> > >
> > > if you load data through XML files, there is no application logic in
> > > play. It's a plain import to the database.
> > >
> > > So if you load invoices with the same invoice id (which is the primary
> > > key for the invoice table), the second dataset will overwrite the
> first.
> > >
> > > The mentioned setting will not help with the problem during import.
> > > Because of the primary key, you cannot have the same invoice id twice
> > > so *I guess* the setting will generate an invoice id with the year and
> > > id (like 2021-1 or similar). But I'm not sure though...
> > >
> > > Regards,
> > >
> > > Michael Brohl
> > >
> > > ecomify GmbH - www.ecomify.de
> > >
> > >
> > > Am 20.02.21 um 09:48 schrieb Andrei Stan:
> > >> Hello everyone,
> > >>
> > >> I want to import some of my old invoices into ofbiz, and some of
> > >> those invoices have
> > >>
> > >> the same id, but were created in different time periods, different
> > >> years.
> > >>
> > >> So, for example, i have *EU-1 *created in 2019**and *EU-1 *created in
> > >> 2020.
> > >>
> > >> When importing the xml file with data for company, invoices etc.,
> > >> only one of those two duplicates is imported, without erros from
> > >> ofbiz's side.
> > >>
> > >> Have anybody tried this in the Accounting Preferences by set the *Old
> > >> Invoice Sequence Enum ID *to *Restart on Fiscal Year (no gaps, per
> > >> org, reset to one each year) *??
> > >>
> > >> Thank you,
> > >>
> > >> A.
> > >>
> > >>
> >
>


Re: Possible currency display bug in "Find Invoices"

2021-02-14 Thread Suraj Khurana
Hello Andrei,

This seems potentially a demo data related issue, could you please log a
Jira for this.
Thanks for reporting.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Sun, Feb 14, 2021 at 11:55 PM Andrei Stan 
wrote:

> Hello everyone,
>
> In the demo-trunk examples, i see that invoice "demo11001" has the Total
> of EUR 820.2773.
>
> If we look at payments, we can see that a payment of EUR 543.23 was made
> and applied.
>
>
> https://demo-trunk.ofbiz.apache.org/accounting/control/invoiceOverview?invoiceId=demo11001
>
> I think the bug is this:
>
> - in the page with the "Invoices List", the numbers are wrong for
> "Total" of "demo11001".
>
> https://demo-trunk.ofbiz.apache.org/accounting/control/findInvoices
>
> - it should display USD 820.2773 or EUR 543.23 ?!?
>
>
>
> Sales Invoice   4/25/06 ApprovedThis is the first invoice
> number to
> Eurocustomer with currency in euro  Your Company Name Here [Company]
> <
> https://demo-trunk.ofbiz.apache.org/partymgr/control/PartyFinancialHistory?partyId=Company=ELbe789c66-795e-45e5-a9f9-26e71a4097b8>
>
> Customer, Euro [EuroCustomer]
> <
> https://demo-trunk.ofbiz.apache.org/partymgr/control/PartyFinancialHistory?partyId=EuroCustomer=ELbe789c66-795e-45e5-a9f9-26e71a4097b8>
>
> €820.2773   €0.00
>
>
> What do you guys think ?
>
> Thanks, A.
>
>


Re: Videos on Apache mailing lists and how to subscribe/unsubscribe

2020-12-28 Thread Suraj Khurana
Thanks Swapnil for sharing these videos.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Mon, Dec 28, 2020 at 8:19 PM Swapnil M Mane 
wrote:

> Dear all,
> Hope you are doing well.
>
> As we got various queries on how to subscribe or unsubscribe mailing list,
> I created videos on these two topics.
>
> 1. How to Subscribe / Unsubscribe ASF Mailing List
> https://youtu.be/3pKJ25v6Ywc
>
> 2. Mailing list in Apache Software Foundation
> https://youtu.be/oj9iiVMVu_g
>
> I am also working on a video featuring Apache OFBiz, stay tuned!
>
> Also, please provide your kind support by subscribing to my YouTube
> channel, "Open Source Wave", it is dedicated Open Source and Apache
> stuff,
> https://s.apache.org/OpenSourceWave
>
>
> Best Regards,
> Swapnil M Mane
>


Re: Please unsubscribe

2020-12-08 Thread Suraj Khurana
Hi Aayush,

Please help yourself: https://ofbiz.apache.org/mailing-lists.html (at
the bottom).


--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Wed, Dec 9, 2020 at 11:01 AM Aayush Gupta 
wrote:

> Please unsubscribe from this email
>


Re: OFBiz as OMS Session: Pre-Orders and its Management

2020-10-27 Thread Suraj Khurana
Thanks for the update Devanshu.

Looking forward to it.

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Mon, Oct 26, 2020 at 5:03 PM Devanshu Vyas 
wrote:

> Hello,
>
> In continuation of our ongoing discussion on OFBiz as an open-source OMS,
> we are organizing a series of videos sessions where we will discuss the
> feasibility of it.
> *Tomorrow, 27th October 2020 at 4 PM IST,* we will start a new topic in the
> series, i.e. Pre-Orders and its management.
>
> Here is the link to the meeting:
>
> https://us04web.zoom.us/j/73082376558?pwd=ODRTbXU1RWZtbzkycnVhT2RISFZjZz09
>
>
> We hope to see you there.
>
> Thanks & Regards,
> Devanshu Vyas.
>


Re: Complete set of Demo Data

2020-10-21 Thread Suraj Khurana
Hello Emad,

Please see my comments below:

On Wed, Oct 21, 2020 at 4:06 PM Emad Radwan  wrote:

> Hi Suraj,
>
> Thanks for replying. As a start, having some data for the following tables
> would really help:
>
> PartyAttribute
>

It is basically used to save any attributes related to Party, not defined
in its PartyType table, exactly like a key value pair having attrName and
attrValue. attrRDesciption is optionally used in case we need to add some
additional information.


> PartyTypeAttr
>

We have a PartyType entity, I am sure you have checked available types
there, widely used types are PERSON and PARTY_GROUP, so data model provides
us flexibility here to define attributes specific to Party types, so that
they can be further drilled down and used as per custom needs.


> PartyClassification
>

It is used to classify Parties, one e-commerce example use case for quick
understanding is, if we can have promotions running for some special
customers, they all can be added into certain party classification and
promotion rules can be defined for that classification.


> PartyClassificationGroup
>

If in any case we have 'n' number of classifications available for parties
and we want to group them based on certain characteristics / user defined
rules, we have this entity to accommodate the purpose. Promotion engine
also supports classification groups, so the same e-comm example fits here
as well.


>
> I went thru the Silverston's volume 2 book on the data patterns and was
> expecting that should be a pattern on 'dynamic attributes' that are
> utilized in many places in Ofbiz or in volume 1 while discussing Products
> but couldn't find, and sadly to say that almost all similar table demo data
> are empty.
>
>
This confluence page might also be helpful to you, while you explore OFBiz
data model.
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams

HTH
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


> On 2020/10/19 05:38:57, Suraj Khurana  wrote:
> > Hello Emad,
> >
> > Welcome to the OFBiz community. I hope you have tested it by loading demo
> > data as well. Sometimes, it also helps in clarifying doubts and
> > understanding seed data requirements.
> > Also, if required, you can share exact tables that you are looking for
> > details, so that ML can answer you with respect to the requirements.
> >
> > HTH.
> > --
> > Best Regards,
> > Suraj Khurana
> > Senior Technical Consultant
> >
> >
> > On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan 
> wrote:
> >
> > > Hi There,
> > >
> > > I'm new to OfBiz and hope you help me. For better understanding of the
> > > system I need a more completed set of data that coverts all tables as
> the
> > > one provided with the seed data leaves a lot of tables blank. I
> understand
> > > that the model is based on Silverston's books and I really enjoy
> reading it
> > > but still many tables and their purpose are not mentioned there.
> Thanks in
> > > advance. All ideas are welcome.
> > >
> > > Regards,
> > >
> > > Emsd
> > >
> >
>


Re: Complete set of Demo Data

2020-10-18 Thread Suraj Khurana
Hello Emad,

Welcome to the OFBiz community. I hope you have tested it by loading demo
data as well. Sometimes, it also helps in clarifying doubts and
understanding seed data requirements.
Also, if required, you can share exact tables that you are looking for
details, so that ML can answer you with respect to the requirements.

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Sun, Oct 18, 2020 at 3:06 PM Emad Radwan  wrote:

> Hi There,
>
> I'm new to OfBiz and hope you help me. For better understanding of the
> system I need a more completed set of data that coverts all tables as the
> one provided with the seed data leaves a lot of tables blank. I understand
> that the model is based on Silverston's books and I really enjoy reading it
> but still many tables and their purpose are not mentioned there. Thanks in
> advance. All ideas are welcome.
>
> Regards,
>
> Emsd
>


Re: OFBiz Definition

2020-10-06 Thread Suraj Khurana
Hello,

The best links to begin are

Learning
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Documentation+Index
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+Beginners+Development+Guide
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo

Setting
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Documentation+Index#OFBizDocumentationIndex-ConfigurationDocuments

HTH.
--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Tue, Oct 6, 2020 at 8:02 PM vinuthomas2008 
wrote:

> Hi All,
>
> What exactly is OfBiz?
> Is it an Order Management system like Sterling Commerce? or a specialized
> ecommerce system?
>
> It does not seem to have full features of an ERP nor of a CRM?
>
> Can you point out a similar open source or commercial system so i can
> identify what exactly OfBiz is??
>
> Thanks
> Vinu
>


Re: Edit Order

2020-08-19 Thread Suraj Khurana
Hi Shrilesh,

Adding to all provided infos, there are some services available OOTB, which
might be useful to your needs:
loadCartFromOrder, loadCartForUpdateWithReqInvRes, loadCartForUpdate etc.

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Wed, Aug 19, 2020 at 6:55 PM Shrilesh Korgaonkar <
shrilesh.korgaon...@udyogmandir.in> wrote:

> Hi Guys,
>
> I'm not talking about OFBIZ as a whole framework or Order Plugin providing
> edit order but only eCommerce plugin
> E.G.--
> if a user creates an order using this eCommerce - ShoppingCart process
>
> submit -> select address -> select shipment method -> select payment method
> -> final review page -> gateway with total value
>
> and after a few hours, he wants to edit order using same shoppingCart
> process
>
> edit items AND / OR new items submit to order -> edit address -> edit
> shipment method -> select payment method -> final review page ->
> gateway with edited total value
>
>
>
> Regards,
> Shrilesh K.
>
> On Wed, Aug 19, 2020 at 1:40 PM Jacques Le Roux <
> jacques.le.r...@les7arts.com> wrote:
>
> > Hi Shrilesh,
> >
> > As said Pradeep, as long as you have not shipped, all that is available.
> > You can also make a refund, etc.
> >
> > Jacques
> >
> > Le 19/08/2020 à 07:22, S K Pradeep Kumar a écrit :
> > > Hi Sameer,
> > >
> > > Yes, OFBiz provides
> > > Order Edit  : - Add or Remove the items from the order. Also, update
> > > adjustments.
> > > Cancel Order : Is already there.
> > >
> > > With regards,
> > > S K Pradeep Kumar,
> > > 9035009495
> > >
> > >
> > > On Tue, Aug 18, 2020 at 3:54 PM Shrilesh Korgaonkar <
> > > shrilesh.korgaon...@udyogmandir.in> wrote:
> > >
> > >> Dear friends,
> > >>
> > >> I wish to know if Ofbiz eCommerce shop offers the order edit and order
> > >> cancel functionality after the order is successfully paid and
> submitted
> > by
> > >> the customer.
> > >>
> > >> Example: customer successfully places the order and subsequently
> wishes
> > to
> > >> edit the ordered items / cancel the order.
> > >>
> > >> Regards,
> > >> Shrilesh K.
> > >>
> >
>


Re: How to shorten the order fulfillment processs

2020-08-14 Thread Suraj Khurana
Hello Georg,

Adding to this, I hope from the data model end you are pretty clear that
these requirements can be easily fit into the existing model, like, the
content data model empowers you to create any number of supporting
documents related to an order.

Also, OFBiz works on service based architecture which are easy to configure
and on top of it, you can have event based triggering. For example, if by
default an invoice is generated when shipment is packed, you can make it
generated after it is delivered, if your business demands it.

You can easily create your separate plugin and add required rules on the
same.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Thu, Aug 6, 2020 at 2:23 PM Georg Potthast 2 
wrote:

> We are planning to replace our old ERP system with an OFBiz based system.
> However, we currently have a different process than the one described in
> the wiki:
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Order+Fulfillment+Process+Overview
>
> We take the orders by phone and generate a delivery note from that. Our
> driver picks the goods from our storage and delivers them to the customer.
> When he returns with a signed delivery note from the customer, we enter the
> delivery note into the ERP system. The ERP system takes a look at the
> agreement details for the customer including his price and generates an
> invoice which is sent in the mail.
>
> This does not seem to fit the process described in the wiki page. How can
> we use OFBiz to fit our existing process?
>


Re: Business case: Use explodeOrderItems OOTB utility

2020-08-06 Thread Suraj Khurana
Hello Pritam,

Thanks for your reply. Yes, you are right, as I mentioned before,
currently, OOTB OFBiz has this explode functionality on shopping cart
level, that is using the same ProductStore.explodeOrderItems flag.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Thu, Aug 6, 2020 at 10:54 AM Pritam Kute 
wrote:

> Hello Suraj,
>
> This will be surely a good architecture for the businesses who route
> shipments from different locations and allow partial returns etc. As far as
> I remember, there is one flag at the product store level with the name
> "explodeOrderItems". When we set this flag to "Y", the system explodes
> order items and create a separate order item data for multi-quantity items
> in the order. I haven't tested it thoroughly but it works quite well on the
> trunk code.
>
> Let's have others to comment on this. Also, let me know if you have
> already tested this flow.
>
> Kind Regards,
> --
> Pritam Kute
>
>
> On Wed, Aug 5, 2020 at 9:02 PM Suraj Khurana 
> wrote:
>
>> Hello everyone,
>>
>> Hope everyone is safe and doing well.
>>
>> For any business which is supporting partial quantity cancellations or
>> partial quantity fulfillments, then it can use exploding the order item
>> OOTB utility.
>>
>> - In case business is entertaining partial cancellations of items, then
>> all
>> adjustments need to be re-calculated and prorated accordingly. This
>> computation overhead can be avoided using an explode item while creating
>> an
>> order.
>> -- While doing this we also need to make sure that rounding is handled and
>> the amount is adjusted properly between all order items.
>>
>> - In case of partial fulfillments, again business demands to prorate item
>> adjustments (tax, shipping etc) to create a invoice, or if there is a
>> third
>> party accounting system in place, we need to provide respective data to
>> it,
>> so again if you have already exploded the item while importing/creating
>> order into the system, you could have reduced this calculations overhead
>> and improve system performance in production environment.
>>
>> Currently, OOTB has this explode functionality on shopping cart level.
>> IMO, we need to have the same capabilities in the createSalesOrder service
>> (can be used as API call) as well.
>>
>> Please share your thoughts on this. Is there any other better approach to
>> handle these business use cases?
>>
>> --
>> Best Regards,
>> Suraj Khurana
>> Senior Technical Consultant
>>
>


Business case: Use explodeOrderItems OOTB utility

2020-08-05 Thread Suraj Khurana
Hello everyone,

Hope everyone is safe and doing well.

For any business which is supporting partial quantity cancellations or
partial quantity fulfillments, then it can use exploding the order item
OOTB utility.

- In case business is entertaining partial cancellations of items, then all
adjustments need to be re-calculated and prorated accordingly. This
computation overhead can be avoided using an explode item while creating an
order.
-- While doing this we also need to make sure that rounding is handled and
the amount is adjusted properly between all order items.

- In case of partial fulfillments, again business demands to prorate item
adjustments (tax, shipping etc) to create a invoice, or if there is a third
party accounting system in place, we need to provide respective data to it,
so again if you have already exploded the item while importing/creating
order into the system, you could have reduced this calculations overhead
and improve system performance in production environment.

Currently, OOTB has this explode functionality on shopping cart level.
IMO, we need to have the same capabilities in the createSalesOrder service
(can be used as API call) as well.

Please share your thoughts on this. Is there any other better approach to
handle these business use cases?

--
Best Regards,
Suraj Khurana
Senior Technical Consultant


Re: New release of OFBiz-CAS plugin: ofbiz-17.12.03-cas-5.3.15.1

2020-08-04 Thread Suraj Khurana
Hi Raghuveer vyas,

Please help yourself: https://ofbiz.apache.org/mailing-lists.html

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Tue, Aug 4, 2020 at 10:50 PM Raghuveer vyas  wrote:

> Please unsubscribe me from ofbiz mails
>
> On Tue, Aug 4, 2020, 10:44 PM Shi Jinghai  wrote:
>
> > Hi list,
> >
> > I released a new version of OFBiz-CAS plugin
> (ofbiz-17.12.03-cas-5.3.15.1):
> > https://github.com/langhua/OFBiz-CAS/tree/ofbiz-17.12.03-cas-5.3.15.1
> >
> > This plugin helps OFBiz to be an OAuth2 server, and there’s an
> > openapi-demo to show how to use it with swagger-ui.
> >
> > Kind Regards,
> >
> > Shi Jinghai
> >
> >
>


Re: Order Pickup Option from facility

2020-07-20 Thread Suraj Khurana
Hello Madhi,

Hope you are doing well.

You can leverage the capabilities of the OOTB data model and achieve this.
Here are some things you need to set up:

- Setup facility data with GeoPoint having latitude/longitude data.
- When the user is accessing the browser, you can identify latitude and
longitude if the user has allowed access to location.
- I have created a JIRA [1] to add a method (getDistanceBetweenGeoPoints)
which you can use to get distance. I will add a patch for this soon. This
will be direct spatial distance between two geo points. You can also use
available Google API's [2]. You need to register for a key to use these
services.
- After that, you can render facilities sorted by distance easily on the
browser.
- For storing desired time slots, you can use estimatedDeliveryDate /
estimatedShipDate fields from OrderItem entity. There are methods available
to set this info into a ShoppingCartItem. These can be furthermore used as
and when required.

[1]: https://issues.apache.org/jira/browse/OFBIZ-11901
[2]:
https://developers.google.com/maps/documentation/distance-matrix/overview

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Mon, Jul 20, 2020 at 2:00 PM Madhi Krishnan <
madhi.krish...@udyogmandir.in> wrote:

> Hey All..
> Hope you all are doing well.
> I'm looking for a functionality where Customers can pick their orders from
> the nearest facility .
> The Customer should be able to select the facility and time slot of his
> choice.
> Is there any  functionality or something related to this that exists in
> ofbiz OOTB?
>
> Thanks & Regards
> Madhi krishnan
>


Re: Record keeping with OFBiz - contracts

2020-06-20 Thread Suraj Khurana
Hi Patrick,

Please help yourself: https://ofbiz.apache.org/mailing-lists.html (at
the bottom).

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Sat, Jun 20, 2020 at 7:12 PM Patrick O 
wrote:

> Please, please unsubscribe me!
> Patrick M O'Donnell
>
> On Saturday, June 20, 2020, 09:07:10 AM EDT, Eugen Stan <
> eugen.s...@netdava.com> wrote:
>
>  Thank you very much Pierre, helpful as always.
>
> I did discover an issue with
> https://demo-stable.ofbiz.apache.org/accounting/control/FindAgreement .
>
> On my computer (and I guess on all, it does not load the less file.
>
> ---
>
> URL
> :
> https://demo-stable.ofbiz.apache.org/rainbowstone/ra%C4%B1nbowstone-emerald.less
> Request :GET
> Status code: 404
>
> ---
>
> As you can see it loads "ra%C4%B1nbowstone-emerald.less" instead of
> "rainbowstone-emerald.less" which returns 200 OK.
>
> I believe it is a typo in the generated HTML.
>
>
> La 20.06.2020 09:40, Pierre Smits a scris:
> > 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
> >>
> >>
> --
> Eugen Stan
> +40720 898 747 / netdava.com
>


Re: Stock management

2020-06-15 Thread Suraj Khurana
Hello Lars,

One simple solution is you can add an custom ECA/SECA rule based on
required inventory levels (can be customised using
ProductFacility.minimumStock) to trigger PO creation.

Another is, you can explore some OOTB manufacturing capabilities where 'run
MRP' [1] is a process by which the system proposes requirements [2] and PO
can be created afterwards after approving those requirements.

Here [3] is a reference document.

[1]: https://demo-trunk.ofbiz.apache.org/manufacturing/control/RunMrp
[2]: https://demo-trunk.ofbiz.apache.org/ordermgr/control/FindRequirements
[3]:
https://cwiki.apache.org/confluence/display/OFBIZ/Manufacturing+Process+Stories+and+Diagrams

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Mon, Jun 15, 2020 at 5:09 PM Lars Bouma  wrote:

> Hello everyone,
> I’m in a small production company where we would like to use OFBiz for
> stock management and order management. I already have OFBiz running and the
> basic setup is also complete. There is only one thing were am running into
> at the moment. I would like the system to auto generate a purchase order
> whenever the quantity on hand level is below or at a certain level.
>
> Is there someone how could tell  me if this is possible. And if so, how do
> I setup the system for this usage?
>
>
> Kind regards,
> Lars Bouma
>
>


Re: Product Price Group

2020-06-03 Thread Suraj Khurana
Hello Ramesh,

ProductStoreGroupId is majorly used when you want to differentiate pricing
based on channels/stores etc. Here you want to differentiate pricing on the
basis of parties, so the best possible OOTB way is to achieve it by using
PriceRules or Agreements data model.

Links shared by Aditya Sharma contain more details on the same.

HTH.

--

Best Regards,
Suraj Khurana
Senior Technical Consultant


On Wed, Jun 3, 2020 at 12:50 AM Ramesh Kumar  wrote:

> Hi ,
> I want to implement product price group functionality in Ofbiz
> application by using Product store group id.
> Ofbiz have product Store Group id implementation in product price entity. I
> am facing problem on shopping cart. We have certain group of customer
> associated with different price group(Product Store group id). If customer
> belonging to price group 1 adding item to cart then item price related to
> price group 1 should apply here. Same way another customer who belong to
> another price group price should apply to related price group.
>  Here Each customer after login getting price group Id and same price
> group Id I want to send as input to shopping cart on cart add/get/update
> operation. There is no any property available in shopping cart class to
> send
> price group request.
> If anyone has implemented this kind of feature please provide some guide to
> implement this functionary properly.
>
> Regards
> Ramesh Kumar
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>


Re: Training - Ofbiz

2020-04-28 Thread Suraj Khurana
Hi James,

Sorry for the late reply.

For data feeding, you can write custom rules calling custom services,
fetching required data and sending it to desired destinations.
AFAIK, nothing is available OOTB for this, but the framework supports
writing custom rules and you can trigger them as per your needs.

HTH.
--
Best Regards,
Suraj Khurana
Senior Technical Consultant


On Tue, Sep 17, 2019 at 10:18 PM  wrote:

>
> We would like to create a product data feed that sends data feeds to all
> our retailers that includes, product ID, image url, description,
> pricing, etc.  Has anyone worked with a 3rd party data feed tool or is
> there something OTB with this?
>
> Thanks,
>
> James
>


Re: Valid Item Status for partial shipment

2020-04-25 Thread Suraj Khurana
Yes.

Adding up to this, in fact, OrderReadHelper.*getItemShippedQuantity*
handles *cancelQuantity* effectively. So we can efficiently get desired
results using these methods.

HTH.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant

On Sat, Apr 25, 2020 at 12:19 PM Mridul Pathak <
mridul.pat...@hotwaxsystems.com> wrote:

> The way order statuses works today seems to be fine, OrderReadHelper has
> the necessary methods to get additional details for the order item.
>
> 1) If order item is partially shipped and remaining quantity is pending
> you could get the shipped quantity from OrderReadHelper. Approved status
> seems valid here.
>
> 2) If order item is partially shipped and remaining quantity is cancelled,
> the cancelled quantity is stored in OrderItem.cancelQuantity. Again you
> could get the shipped quantity and cancelled quantity from OrderReadHelper.
> Completed status seems valid here.
>
> Thanks.
> Mridul Pathak
>
>
> > On 25-Apr-2020, at 10:57 AM, Mohammad Kathawala <
> mohammad.kathaw...@hotwaxsystems.com> wrote:
> >
> > Hello Shikha,
> >
> > The statuses mentioned by you in all the scenarios seem correct to me and
> > AFAIK it works in the same way in OFBiz. We can definitely improve it by
> > adding a 'Partially Complete/Partially Fulfilled' status to an order item
> > as mentioned by Pawan.
> >
> > Thanks & Regards
> > Mohammad Kathawala
> >
> > On Tue, Apr 14, 2020 at 6:03 PM Suraj Khurana 
> > wrote:
> >
> >> Adding Dev ML.
> >>
> >> --
> >> Best Regards,
> >> Suraj Khurana
> >> Senior Technical Consultant
> >>
> >> On Tue, Apr 14, 2020 at 5:13 PM Shikha Jaiswal <
> >> shikha.jais...@hotwaxsystems.com> wrote:
> >>
> >>> Hello team,
> >>>
> >>> From the business point of view, please share what should be the exact
> >>> status of an item after approval, if it is being shipped partially.
> >>>
> >>> Suppose an order item is of 3 qty and all three are split down into
> >>> separate ship groups and shipped one by one, what should be the ideal
> >>> status on each following instances, as we maintain item status on
> >> OrderItem
> >>> level only, not specific to OISGA:
> >>>
> >>> - One item is shipped, two are pending.
> >>> -- IMO, it should be Approved as there are still pending items, please
> >>> confirm.
> >>>
> >>> - Two items are shipped, one is pending.
> >>> -- IMO, it should be Approved as there are still pending items, please
> >>> confirm.
> >>>
> >>> - Two items are shipped, one is canceled.
> >>> -- IMO, it should be Completed as it is shipped or canceled, please
> >>> confirm.
> >>>
> >>> OR
> >>>
> >>> - All three items are shipped
> >>> -- IMO, it should be Completed as all items are shipped.
> >>>
> >>> Please let me know your thoughts on this.
> >>>
> >>> --
> >>> Thanks & Regards,
> >>> Shikha Jaiswal
> >>> Senior Enterprise Software Engineer
> >>>
> >>
>
>


Re: Multiple services run immediately

2020-04-25 Thread Suraj Khurana
Hello Ingo,

Hope you are doing good.

I am not sure about the environment you are currently trying to achieve
this. IMO, there are two ways:

- For improving performance, we can set up multiple OFBiz servers in
parallel. Yes, we can set up two OFBiz servers, one calling sync service
and another dedicated for async services only.
Here [1] is a reference blog for more details.

- You can increase jobs count in service engine [2], so that your OFBiz
server will be picking more jobs to complete at a time, be careful various
factors are responsible with this approach, like CPU core, deployed OFBiz
memory allocation, maximum DB threads enabled etc.

[1]
https://www.hotwaxsystems.com/ofbiz/ofbiz-tutorials/apache-ofbiz-performance/
[2] framework/service/config/serviceengine.xml

HTH.
--
Best Regards,
Suraj Khurana
Senior Techincal Consultant


On Fri, Apr 24, 2020 at 11:01 PM Ingo Wolfmayr 
wrote:

> Hi everybody,
>
> I want to run two or more services immediately after another service has
> finished.
>
> For example printing creating/printing the invoice and starting the pick
> process should be done immediately after orderchange  Invoicing and picking
> are two different processes that should be initiated at the same time.
> Picking should not wait until the invoice process is finished.
>
> Right no I have:
>
> 
> value="SALES_ORDER"/>
>  value="ORDER_APPROVED"/>
>  to-field-name="oldStatusId"/>
>  persist="true"/>
> 
> 
>
> The problem with that is, that if there are other tasks in the queue (solr
> product update, ...) it may come to unwanted delays.
>
> Would runSyncIgnore work?
>
> It would be great if I could use th eca service definitions to to it.
>
> Best regards
> Ingo
>


Re: Multiple Websites

2020-04-24 Thread Suraj Khurana
Hello James,

Please explore WebSite entity [1] for all the configurations. You can
associate *ProductStores* created using productStoreId field
Here is a document [2] for your reference.

[1] https://demo-trunk.ofbiz.apache.org/webtools/control/entity/find/WebSite
[2] https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=6553736

HTH.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant

On Fri, Apr 24, 2020 at 6:45 PM  wrote:

> Hello - Can someone point me in the right direction to configure
> multiple web sites in Ofbiz.  We have one instance and we have 3 stores
> configured.  We now need to know how we can configure for these ofbiz
> stores to have different physical websites.
>
> Thanks,
>
> James
>


Re: [Updates] Demo instance for OFBiz 17.12

2020-04-14 Thread Suraj Khurana
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 
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=ofbiz=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: Valid Item Status for partial shipment

2020-04-14 Thread Suraj Khurana
Adding Dev ML.

--
Best Regards,
Suraj Khurana
Senior Technical Consultant

On Tue, Apr 14, 2020 at 5:13 PM Shikha Jaiswal <
shikha.jais...@hotwaxsystems.com> wrote:

> Hello team,
>
> From the business point of view, please share what should be the exact
> status of an item after approval, if it is being shipped partially.
>
> Suppose an order item is of 3 qty and all three are split down into
> separate ship groups and shipped one by one, what should be the ideal
> status on each following instances, as we maintain item status on OrderItem
> level only, not specific to OISGA:
>
> - One item is shipped, two are pending.
> -- IMO, it should be Approved as there are still pending items, please
> confirm.
>
> - Two items are shipped, one is pending.
> -- IMO, it should be Approved as there are still pending items, please
> confirm.
>
> - Two items are shipped, one is canceled.
> -- IMO, it should be Completed as it is shipped or canceled, please
> confirm.
>
> OR
>
> - All three items are shipped
> -- IMO, it should be Completed as all items are shipped.
>
> Please let me know your thoughts on this.
>
> --
> Thanks & Regards,
> Shikha Jaiswal
> Senior Enterprise Software Engineer
>


Re: Global GL chart of accounts

2019-12-23 Thread Suraj Khurana
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: Multi Tenancy Support

2019-10-02 Thread Suraj Khurana
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: Price List Per Customer

2019-09-25 Thread Suraj Khurana
Hello James,

It looks like a B2B scenario where every customer is quoted a different
price.
You can also explore Agreement model for this, IMO, it will be more
manageable than managing separate price rules for every customer.

HTH
--
Best Regards,
Suraj Khurana
Technical Consultant






On Tue, Sep 24, 2019 at 9:48 PM  wrote:

> We have a situation where we have custom prices specifically to each
> customer.  These are not priced on a percentage of another price list
> ...pricing is random per product per customer.  Do Use Price Rules I
> would need to create a price rule for every product/customer
> combination.  Is there an easy way to create a custom price book per
> customer?
>
> Thanks,
>
> James
>


Re: [HC-Forum] ISO-3166 - Codes for the representation of names of countries and their subdivisions

2019-09-18 Thread Suraj Khurana
+1.

--
Best Regards,
Suraj Khurana
Technical Consultant






On Thu, Sep 19, 2019 at 10:56 AM Vaibhav Jain <
vaibhav.j...@hotwaxsystems.com> wrote:

> Hello team,
>
> *Bottom line:*
> I suggest that either we should use alpha-2/alpha-3 or we can use all of
> them and make them configurable as per business requirement.
>
> *Story:*
> As per the ISO-3166 standard for country and subdivision codes. There are
> three types of codes alpha-2, alpha-3 and numeric.
>
> Different countries are using a different standard as per there
> administration policy. It may be either alpha-2, alpha-3 or numeric.
>
> In the current system, we are using mixed-format like somewhere alpha-2
> and somewhere alpha-3. We should fix this for example:
>
> Example
> India country:
>   ISO-3166-1 alpha-2=IN ISO-3166-1 alpha-3= IND
>  alpha-numeric=356
> Indian state: Maharastra
>   ISO-3166-2 =IN-MH  ISO-3166-1 alpha-3=MH
>  alpha-numeric= NA
>
> In OFBiz
>   India:
> IN(ISO-3166-1 alpha-2)
>   Indian state: Maharastra
> MH(ISO-3166-1 alpha-3)
>
>   United States
> USA(alpha-3)
>   United States: New York
> NY(alpha-3)
>
> Here are some reference:
> https://www.iso.org/obp/ui/#iso:code:3166:IN
> https://en.wikipedia.org/wiki/ISO_3166-2:IN
>
> Kind Regards,
> Vaibhav Jain
> Senior Enterprise Software Engineer
> *HotWax Systems*
> *Enterprise open source experts*
> cell: 782 834 1900
> http://www.hotwaxsystems.com
>
> --
> You received this message because you are subscribed to the Google Groups
> "hc-forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to hc-forum+unsubscr...@hotwaxsystems.com.
> To view this discussion on the web visit
> https://groups.google.com/a/hotwaxsystems.com/d/msgid/hc-forum/CAPADGdjhewB_0yEwxDdwg81Tw4mDTCw9VdWBQqFSJvzb%3D3Ap7Q%40mail.gmail.com
> <https://groups.google.com/a/hotwaxsystems.com/d/msgid/hc-forum/CAPADGdjhewB_0yEwxDdwg81Tw4mDTCw9VdWBQqFSJvzb%3D3Ap7Q%40mail.gmail.com?utm_medium=email_source=footer>
> .
>


Re: Get values from entity not commited.

2019-07-03 Thread Suraj Khurana
Hello Ingo,

While defining eca, please use event as 'commit' instead of 'return'. BTW,
I would recommend to use seca over 'storeOrder' if scope is limited to this
service only.

HTH
--
Best Regards,
Suraj Khurana
Technical Consultant
HotWax Systems







On Wed, Jul 3, 2019 at 3:24 PM Ingo Wolfmayr 
wrote:

> Hi everybody,
>
> I have a question regarding services :
>
> I hava a "eecas" that a service after a new OrderPaymentPreference has
> been created/stored.
>
> Within this service I would need some fields from OrderHeader entity.
> Unfortunately at this this point the entity entry is not commited and
> therefore I cannot query it. Is there a way to get those values. The
> service "storeOrder" is the service that initiates everything.
>
> I would appreciate every hint.
>
> Thanks,
> Ingo
>


Re: Two same type of promotion applying on the cart

2019-06-20 Thread Suraj Khurana
Yes, I agree with you Paul.

@Rishi Solanki , we can set those fields,
but still there is fair chance that two or more promotions will be applied
in an order.

--
Best Regards,
Suraj Khurana
Technical Consultant
HotWax Systems







On Fri, Jun 21, 2019 at 8:42 AM Paul Foxworthy  wrote:

> On Wed, 19 Jun 2019 at 16:14, Rishi Solanki 
> wrote:
>
>
> > Instead of let the multiple promotion allow we can use limit per order,
> > limit per customer and limit per promotion flags to make single
> > applicability of promotion.
> >
>
> Thanks Pritam and Rishi. In the scenario Pritam described, I often see
> "excludes all other discounts" in the terms and conditions for a special
> offer. It would be good for OFBiz to support that.
>
> Cheers
>
> Paul Foxworthy
>
> --
> 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
>


Re: Two same type of promotion applying on the cart

2019-06-18 Thread Suraj Khurana
Hi Paul,

Thanks for bringing this to everyone's attention, a simple case could be
following two promotions are setup in parallel:

- A flat 200 off promotion to be available only after purchase of $2000 on
product X.
- A flat 15% off promotion on Category ABC and interestingly X product is
part of ABC category.

So when a user adds product X into cart, and cart value raises $2000, both
promotions gets applied, from companies perspective, its a loss and they
might only want to give one one promotion at a time.

HTH.
--
Best Regards,
Suraj Khurana
Technical Consultant
HotWax Systems







On Wed, Jun 19, 2019 at 10:18 AM Paul Foxworthy  wrote:

> Hi Suraj,
>
> Why would you want the $3 promotion if it will never be applied? If they
> have different data ranges, I think two separate $3 promotions for date
> ranges before and after the $5 one is a much clearer way to express it.
>
> What do you think?
>
> Cheers
>
> Paul
>
> On Tue, 18 Jun 2019 at 23:16, Suraj Khurana 
> wrote:
>
>> Hello,
>>
>> This is very common in e-commerce business that only one promotion should
>> be applied to any cart from business perspective, if a PriceRule is active
>> than also one promotion should be applied with maximum value.
>>
>> As current OOTB doesn't supports this, I think we can make it configurable
>> to use this as a feature.
>>
>> It can be a good to have feature !!
>> --
>> Best Regards,
>> Suraj Khurana
>> Technical Consultant
>> HotWax Systems
>> Enterprise open source experts
>> cell: 96697-50002
>> http://www.hotwaxsystems.com
>>
>>
>>
>>
>>
>>
>> On Tue, Jun 18, 2019 at 2:50 PM Jacques Le Roux <
>> jacques.le.r...@les7arts.com> wrote:
>>
>> > Le 18/06/2019 à 10:52, Pallavi Goyal a écrit :
>> > > Hello team,
>> > >
>> > > I have made two promotions-
>> > >
>> > > 1. Give flat $5 on order
>> > > 2. Give flat $3 on order
>> > >
>> > > Both of these are active at the same time. When I check the cart on
>> > > e-commerce, the discounts for both promotions are showing.
>> > >
>> > > Is this an expected result or only one promotion should be applied to
>> the
>> > > cart which is giving a higher discount.
>> > >
>> > > Please share your thoughts.
>> > >
>> > > --
>> > > Thanks
>> > > Pallavi Goyal
>> >
>> > Hi Pallavi,
>> >
>> > IMO if the user wants to give 2 different flat promo they should be
>> > applied, why not?
>> >
>> > Jacques
>> >
>> >
>>
>
>
> --
> 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
>


Re: Two same type of promotion applying on the cart

2019-06-18 Thread Suraj Khurana
Hello,

This is very common in e-commerce business that only one promotion should
be applied to any cart from business perspective, if a PriceRule is active
than also one promotion should be applied with maximum value.

As current OOTB doesn't supports this, I think we can make it configurable
to use this as a feature.

It can be a good to have feature !!
--
Best Regards,
Suraj Khurana
Technical Consultant
HotWax Systems
Enterprise open source experts
cell: 96697-50002
http://www.hotwaxsystems.com






On Tue, Jun 18, 2019 at 2:50 PM Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> Le 18/06/2019 à 10:52, Pallavi Goyal a écrit :
> > Hello team,
> >
> > I have made two promotions-
> >
> > 1. Give flat $5 on order
> > 2. Give flat $3 on order
> >
> > Both of these are active at the same time. When I check the cart on
> > e-commerce, the discounts for both promotions are showing.
> >
> > Is this an expected result or only one promotion should be applied to the
> > cart which is giving a higher discount.
> >
> > Please share your thoughts.
> >
> > --
> > Thanks
> > Pallavi Goyal
>
> Hi Pallavi,
>
> IMO if the user wants to give 2 different flat promo they should be
> applied, why not?
>
> Jacques
>
>


Re: Usage based Subscription billing

2019-06-07 Thread Suraj Khurana
Hello,

You can check demo product[1] on OFBiz demo instance[2].

[1]:
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=GZ-NEWS-1MO
[2]: https://demo-trunk.ofbiz.apache.org/ecommerce/control/main

HTH.
--
Best Regards,
Suraj Khurana
Technical Consultant
HotWax Systems







On Fri, Jun 7, 2019 at 1:34 PM Jacques Le Roux 
wrote:

> Oops forgot to copy the link
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Subscription
>
> Le 07/06/2019 à 09:57, Jacques Le Roux a écrit :
> > Hi Prats,
> >
> > Yes subscription is the best way.
> >
> > I guess you found this article already?
> >
> > HTH
> >
> > Jacques
> >
> > Le 06/06/2019 à 22:26, hacker.kids@gmail.com a écrit :
> >> Hi,
> >>
> >> I want to use OfBiz for the following use case.
> >>
> >> I want my customer to subscribe to my service( a digital product) and
> this is a post paid service (usage based). For example, I have a product
> >> "view my videos" and it is a paid service which will calculate billing
> based on how many times my user have viewed the videos.
> >>
> >> What is the best way to model this in OFBIZ? I have looked at the
> subscription module and am not able to figure out how to create invoice for
> usage
> >> based digital  product. Is subscription the best way to model it ?
> >>
> >> Best,
> >> Prats
> >>
> >
>


Re: Containers

2019-02-22 Thread Suraj Khurana
Hi Yokeshwaran,

It depends on how you have set up this Product.
Assuming that 1 pack of 500 mg is a Product, you can set its dimension into
*Product* entity on *productWeight*, *productDepth*, *productHeight*,
*productWidth*.
Similarly, you need to set up the box dimension on *ShipmentBoxType* entity.

HTH.

--
Best Regards,
Suraj Khurana
TECHNICAL CONSULTANT
mobile: +91 9669750002
email: suraj.khur...@hotwax.co
www.hotwax.co






On Fri, Feb 22, 2019 at 3:22 PM ygk  wrote:

> Hi All,
>
> Kindly help me on this Business Scenario
>
> 1.500 mg of wheat -10 pack
> 2.500 mg of rice-5 pack
> 3.500 mg of almonds- 15 pack
>
> By summing up,total pack is 30 pack.this all should fit in a box.Ofbiz
> should auto calculate and suggest how many pack can fit in a box?where to
> configure this.
>
> The same way, we have multiple orders.which has to be exported in a
> container.How many boxes can be fit in a shipping container.Ofbiz should
> auto calculate and suggest how many box can fit into a container?where to
> configure this?
>
> Regards,
> Krishnan.
>
>


Re: Mix and Match Product Confuguration for E COmmerce

2018-11-12 Thread Suraj Khurana
Hi Yokesh,

You can set up a marketing package type product. For example, please refer
to OFBiz demo data.
Refer: https://cwiki.apache.org/confluence/display/OFBENDUSER/Products

HTH.
--
Best Regards,
Suraj Khurana
Technical Consultant
*HotWax Commerce *
*Real OmniChannel. Real Results. *





On Mon, Nov 12, 2018 at 1:57 PM, yokesh  wrote:

> How to comine/mix and match two or more  products in the way of combo in a
> ofbiz.
>
> It should not be in the way of virtual/variant product.
>
>
> Regards,
> Yokesh.
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>


Re: Creating product packs

2018-10-04 Thread Suraj Khurana
Hi,

Yes, this is the case where 'Marketing Package' is used.

You can check demo data of OFBiz for reference. [1]

[1]:
https://demo-trunk-ofbiz.apache.org/catalog/control/EditProduct?productId=PIZZA

HTH.

--
Best Regards,
Suraj Khurana
Omnichannel OMS Technical Expert
HotWax Systems


On Thu, Oct 4, 2018 at 2:19 PM, wp.rauchh...@gmail.com <
wp.rauchh...@gmail.com> wrote:

> How to best setup a pack in ofbiz?
> With pack I mean a product (e.g. a pack for 7 days of food servings) that
> includes in this example 7 individual servings. Each of these servings
> could be sold individually too.
> The price is set for the pack, but the Customer should have the
> possibility on e-Commerce to open the pack and see what is inside.
> The pack is either defined or can be configured.
> Is this a case where 'Marketing Package' is used?
>
> Thanks, Wolfgang
>
>


Re: Purchase order minimum and packing units

2018-09-04 Thread Suraj Khurana
Hi Frank,

For packing units, IMO, there could be two possible solution for this case.
One is to setup product in OFBiz of type marketing package (if supplier
have multiple packing quantities this fits best), this is available OOTB
and services available to decompose marketing package into singular units
that can be used for selling, you can setup marketing packages and use them
for PO and individual product can be used for selling purpose.

On the other hand, it seems more feasible and less confusing to setup
quantity UOM while creating PO. This requires some custom changes as per
business while creating PO. SupplierProduct also have quantityUomId field
which can be used for this. Data model support is available OOTB and we can
define conversion quantity as per package quantity from Supplier.

For Order minimum, IMO, we can use agreement model to achieve this. We
could have an agreement with supplier about minimum order amount and can
have some custom logic to check that agreement and allow user to place
order or not.

HTH.

--
Thanks and Regards,
Suraj Khurana
Omnichannel OMS Technical Expert
HotWax Systems

On Tue, Sep 4, 2018 at 12:36 PM, Frank Herrman  wrote:

> Hi Rishi,
>
> Thank you for your reply. I see there are two fields: 'units included' and
> 'order qty increments', should I use the latter in my case? It is not that
> we order 1 product which contain 6 products, but that we are required to
> purchase them per 6. So the costprice of the product is the price of 1
> product, not a box of 6.
>
> The minimum order quantity is set on the product level, but I want to set
> it on the supplier level.  Furthermore I would like to have a minimum order
> _amount_. I am not required to order a minimum number of one specific
> product from a supplier, but I do need to have a minimum order amount which
> can be spread over multiple products.
>
> Kind regards,
>
> Frank
>
> Op 04-09-18 07:26 heeft Rishi Solanki 
> geschreven:
>
> Hi Frank,
> For packing units and minimum purchase please refer to SupplierProduct
> entity fields minimumOrderQuantity and unitsIncluded. This modeling
> supportive for purchasing from supplier. It works for all possible
> business
> use cases including yours.
> For sales minimum amount/quantity you may need to setup the
> ProductPrice
> for that product of type MINIMUM_ORDER_PRICE. Once setup the customer
> won't
> be able to purchase that product below that amount. On the basis of
> requirement you can decide the price to match the minimum
> amout/quantity.
>
> All this support OOTB available. HTH!
>
> --
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
>
> On Tue, Sep 4, 2018 at 1:10 AM Frank Herrman 
> wrote:
>
> > Hi there,
> >
> > I am currently looking into the purchase orders within Ofbiz. I
> would like
> > to define two things:
> >
> > Packing units
> > Many products are packaged in boxes in sets of multiple items. The
> > supplier delivers them per 6, we sell them per 1. Now there is an
> option
> > per product per supplier to enter the minimum order quantity. This
> does not
> > seem to ensure I will buy the product in this example per 6. I can
> also
> > order 7 in that case. I want the system to let me only order 6, 12,
> 18 etc.
> > What is the best way to go there?
> >
> > Order minimum
> > Many suppliers require me to place orders of a minimum amount and
> > sometimes a minimum quantity (usually it’s amount). Where can I set
> this
> > up? This is also something that does not seem to work well with the
> > requirements module. Every order that makes my QoH go below my
> minimum
> > quantity a requirement is created. I can make a purchase order out
> of it,
> > but that will only contain that specific product. When I order with a
> > supplier I want to be able to select from all the products he
> provides that
> > are below the QoH, and not in separate purchase orders. Is this
> possible as
> > well?
> >
> > Thank you in advance again.
> >
> > Kind regards,
> >
> > Frank
> >
> >
>
>
>


Re: Multiple Warehouse Item Reservation

2018-05-03 Thread Suraj Khurana
Hi James,

https://demo-trunk-ofbiz.apache.org/catalog/control/ProductStoreFacilities?productStoreId=9000

HTH.

--
Thanks and Regards,
*Suraj Khurana* | Omni-channel OMS Technical Expert
HotWax Commerce  by  HotWax Systems
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010


On Thu, May 3, 2018 at 3:19 PM <ja...@productive1.com> wrote:

>
> Thank you.  Is there a UI for ProductStore Facility?  I see I have the
> ability to have one warehouse assigned to the Product Store but I did
> see an area for a second one
>  Original Message 
> Subject: Re: Multiple Warehouse Item Reservation
> From: Vaibhav Jain <vaibhav.j...@hotwaxsystems.com>
> Date: Wed, May 02, 2018 10:23 pm
> To: user@ofbiz.apache.org
>
> Hello James,
>
> IMO, It is a data configuration issue.
>
> Please make sure that following data is configured properly:
>
>  1. "oneInventoryFacility" should be "N" for the respective product
> store.
>  2. Product store should have an association with both the facility in
>  "ProductStoreFacility" entity.
>
> HTH!
> Thanks & Regards
>
> Vaibhav Jain
> Sr. Enterprise Software Engineer
> HotWax Systems
> m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com
>
> On Thu, May 3, 2018 at 7:05 AM, <ja...@productive1.com> wrote:
>
> > We have two warehouses and just noticed the system is only reserving to
> > the default warehouse and backordering product even when I have it in
> > another warehouse. Is this how the system is suppose to behave.
> > Shouldn't it try and reserve it from the default warehouse and then the
> > other warehouses if default warehouse has zero stock.?
> >
> > Thanks,
> >
> > James
> >
>


Re: About OFBiz Email Passwords Sending

2018-03-15 Thread Suraj Khurana
Hi Michael, Schumann,

As per some recent code changes, there are many empty fields in data files
which removes the data when some reader is again loaded into the system.
Lets say I configured some email settings and mistakenly if ext reader is
loaded again, that data will be corrupted and user is unaware of that.

This ticket is created for changes regarding the same:
https://issues.apache.org/jira/browse/OFBIZ-10282

HTH.

--
Thanks and Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
HotWax Commerce  by  HotWax Systems
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010





On Thu, Mar 15, 2018 at 4:14 PM, Michael Brohl <michael.br...@ecomify.de>
wrote:

> Hi Schumann,
>
> please have a look at the SystemProperty table. Currently the demo data
> loads some configuration for email so the changes in general.properties are
> partly overwritten in the configuration logic. Either change the database
> entries or remove them to use general.properties settings.
>
> Best regards,
>
> Michael Brohl
> ecomify GmbH
> www.ecomify.de
>
>
> Am 15.03.18 um 10:20 schrieb Schumann Ye:
>
> Dear Gurus,
>>
>> When I try to activate OFBiz Passwords Forget (Email Passwords function)
>> in the Login webpage, I have got the following Error message:
>>
>> The Following Errors Occurred:
>> Error occurred: unable to email password. Please try again later or
>> contact customer service. (error was: [CON] Connection error when sending
>> message to ***@hotmail.com from @outlook.com
>> cc bcc subject New Password Sent (my own user login id)).
>>
>> What I have done in customizing the OFBiz Email Passwords is as follows:
>>
>> 1.  Update the fields (which are not null) From_Address, CC_Address
>> and BCC_Address from tables ofbiz.product_store_email_setting and
>> ofbiz.email_template_setting to sending email address **@
>> outlook.com
>>
>> 2.  Modify the file general.properties as follows:
>>  # -- general default 'fromEmailAddress' can be overridden in:
>> EmailTemplateSetting
>>  defaultFromEmailAddress=**@outlook.com
>>
>>  # -- mail notifications enabled (Y|N)
>>  mail.notifications.enabled=Y
>>
>>  # -- redirect all mail notifications to this address for testing
>>  #mail.notifications.redirectTo=
>>
>>  # -- the default mail server to use
>>  mail.smtp.relay.host=smtp.office365.com
>>
>>  # -- SMTP Auth settings
>>  mail.smtp.auth.user=**(my outlook mail name with
>> the @outlook.com)
>>  mail.smtp.auth.password=***(my outlook mailbox
>> passwords)
>>
>>  # -- Additional Required Fields needed for Gmail and other non
>> traditional smtp servers
>>  # -- These added fields also work for Yahoo business mail for
>> instance
>>  # -- Gmail smtp port can be either 465 or 587
>>  mail.smtp.port=587
>>  # -- Gmail requires StartTLS
>>  mail.smtp.starttls.enable=true
>>
>>  # -- Gmail requires a JSSE socket factory, the following
>> socketFactory settings will override JavaMail's default socketFactory
>> settings
>>  # -- Port needs to be the same as mail.smtp.port
>>  mail.smtp.socketFactory.port=587
>>  #mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
>>  #--Fallback [true|false] determines whether you will allow a non
>> secure connection if you are unable to get a secure one
>>  #mail.smtp.socketFactory.fallback=false
>>
>> 3.  Update the predefined fields from table ofbiz.system_property in
>> mysql database as above shown in point 2.
>> 4.  I also update the from_address from the preset mailbox to my
>> outlook mailbox in the moduel Ecommerce 
>> (applications/securityext/data/UserDemoData.xml),
>> although this is not necessary for now because I am using back-end only.
>>
>> After a successful reboot of OFBiz, I got the error message shown in the
>> very beginning.
>>
>> Can anybody help?
>> Thanks and have a nice day!
>>
>> Best Regards
>> Schumann
>> +86-1800-150-1800
>>
>>
>
>


Re: MRP Run for Plant and Warehouse

2018-03-12 Thread Suraj Khurana
Hi,

You can modify the code as




HTH.
--
Best Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
HotWax Commerce  by  HotWax Systems
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010




On Sun, Mar 11, 2018 at 6:10 PM, Schumann Ye <schumanny...@hotmail.com>
wrote:

> Dear Gurus,
>
> It came to my attention today that the Manufacturing MRP run applies only
> for Facility with TypeID “Warehouse”.
> For release 16.11.03, here below is the definition of the Forms:
>  description="${facilityName} [${facilityId}]">
>  operator="equals" value="WAREHOUSE"/>
> 
>
> I have set one of my Facility as “Plant” instead of “Warehouse”.
> My question is if I want to make both “warehouse” and “plant” possible for
> MRP run, how shall I modify the code above?
>
> Thanks for your advices!
> Schumann
> +86-18001501800
>
> 发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用
>
>


Re: Product inventory - facility connection

2018-01-30 Thread Suraj Khurana
Hi Jakub,

OFBiz is designed to be customized on a granular level and all the general
requirements are available OOTB.
This is not a generic structure to have virtual product assoc with a
facility to work for variants as well. It could be possible that you manage
particular variants at one facility and some other variants at another
facility.
So, this is not available OOTB, but if want to configure it, you need to
have a custom implementation for the same.

HTH.

--
Thanks and Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
*HotWax Commerce*  by  *HotWax Systems*
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010


On Wed, Jan 24, 2018 at 6:33 PM, Jakub Danek <jakub.da...@yoso.fi> wrote:

> Hello,
>
> I've spent quite some exploring the documentation and the code, yet with
> no satisfactory answer:
>
> We are using Ofbiz 16.11.
>
> If I receive a product into a facility, I can see the respective
> InventoryItem in facility's Inventory Items tab, however, when I click on
> the "Inventory" tab, I can see nothing.
>
> After I add the facility to the product at the product's Facilities tab, I
> can see the Inventory count at facility's Inventory tab.
>
> My question is this: Is there any way to either make Ofbiz return
> Inventory count based on Inventory items (i.e. no facility in Product's tab
> necessary) or make Ofbiz variant products inherit facility settings from
> their respective Virtual product (i.e. we have to add facility to virtual
> products, but not to each variant product separately)?
>
> We can modify the code to suit our needs, but first I wanted to make sure
> we are not missing some piece of configuration somewhere.
>
> Thank you in advance.
>
> BR,
>
> Jakub
>
>


Re: Order Allocation

2018-01-01 Thread Suraj Khurana
Hi,

This is already been proposed under OFBIZ-6964
<https://issues.apache.org/jira/browse/OFBIZ-6964>.
HTH.

--
*Suraj Khurana* | Sr. Enterprise Software Engineer
HotWax Commerce  by  HotWax Systems
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010


On Tue, Dec 19, 2017 at 12:08 PM, Vaibhav Jain <
vaibhav.j...@hotwaxsystems.com> wrote:

> Hello James,
>
> We can enhance data model to handle the scenarios defined above:
>
> *FacilityAssoc*
>   facilityId*
>   facilityIdTo*
>   facilityAssocTypeId*
>   fromDate*
>   thruDate
>   sequenceNo (For Ex: A facility have more than one alternate facility then
> seqneceNum is used for sequencing)
> *FacilityAssocType*
>   facilityAssocTypeId*
>   description
>
> Please share your thoughts on this.
>
> Thanks & Regards
>
> Vaibhav Jain
> Hotwax Systems,
> vaibhav.j...@hotwaxsystems.com
>
> On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote:
>
> >
> > I have a scenario where I have 2 warehouses.  I always want to ship
> > products from the nearest warehouse to the client.  How does ofbiz
> > handle order allocation of product on sales orders to a specific
> > warehouse.  Can we set up customers to get products from a specific
> > warehouse?
> >
> > Thanks,
> >
> > James
> >
>


Re: Order Allocation

2017-12-13 Thread Suraj Khurana
Hi James,

IMO, OFBiz data model supports this feature but can require some custom
logic implementation over it.
You can use Geo related entities for it to find the nearest location and
set it at ship group level in the cart that leads the current logic as it
is and do reservations from nearest facility.

HTH.

--
Thanks and Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
*HotWax Commerce*  by  *HotWax Systems*
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010


On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote:

>
> I have a scenario where I have 2 warehouses.  I always want to ship
> products from the nearest warehouse to the client.  How does ofbiz
> handle order allocation of product on sales orders to a specific
> warehouse.  Can we set up customers to get products from a specific
> warehouse?
>
> Thanks,
>
> James
>


Re: Where is the costs of Purchase Order Pulled From

2017-09-28 Thread Suraj Khurana
Hi Amit,

There is also a field in *SupplierProduct* entity named
*supplierPrefOrderId* in which we can store this supplier is the main or
alternative supplier of the product.
Currently, this is not entertained in
SupplierProductServices.getSuppliersForProduct()
method.
HTH.

--
Best Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
*HotWax Commerce*  by  *HotWax Systems*
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010


On Thu, Sep 28, 2017 at 10:42 AM, Amit Gadaley <
amit.gada...@hotwaxsystems.com> wrote:

> Hello Aditi,
>
> Is there any way to give priority to any supplier over other suppliers
> regardless the last price, min order qty or any other parameters?
>
> On Mon, Sep 25, 2017 at 7:37 PM, Aditi Patidar <
> aditi.pati...@hotwaxsystems.com> wrote:
>
> > Hello James,
> >
> > The SupplierProductServices.getSuppliersForProduct() returns a list of
> > SupplierProduct records in ascending order(lowest first) of lastPrice.
> This
> > method also filters out records on the basis of minimumOrderQuantity of
> the
> > product against the quantity ordered.
> >
> > I hope this answers your query.
> >
> > Thanks.
> > Aditi Patidar
> >
> > On Thu, Sep 21, 2017 at 3:53 PM, Rishi Solanki <rishisolan...@gmail.com>
> > wrote:
> >
> > > James,
> > >
> > > Please check PriceServices.calculatePurchasePrice() and it calls the
> > > SupplierProductServices.getSuppliersForProduct() service. As per
> > > implementation it always use latest lastPrice from SupplierProuct.
> > >
> > > HTH!
> > >
> > >
> > >
> > > Rishi Solanki
> > > Sr Manager, Enterprise Software Development
> > > HotWax Systems Pvt. Ltd.
> > > Direct: +91-9893287847
> > > http://www.hotwaxsystems.com
> > > www.hotwax.co
> > >
> > > On Thu, Sep 21, 2017 at 3:26 PM, <ja...@productive1.com> wrote:
> > >
> > > > Does it always use the latest last price?
> > > >
> > > >  Original Message 
> > > > Subject: Re: Where is the costs of Purchase Order Pulled From
> > > > From: Akash Jain <akash.j...@hotwaxsystems.com>
> > > > Date: Wed, September 20, 2017 8:56 pm
> > > > To: user@ofbiz.apache.org
> > > >
> > > > Hello James,
> > > >
> > > > Please check lastPrice in SupplierProduct entity.
> > > >
> > > > Thanks and Regards
> > > > --
> > > > Akash Jain
> > > > www.hotwaxsystems.com
> > > > www.hotwax.co
> > > >
> > > > On Thu, Sep 21, 2017 at 2:18 AM, <ja...@productive1.com> wrote:
> > > >
> > > > > Anyone know where do I find the costs that is used on a Purchase
> > Order?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > James
> > > > >
> > > > >  Original Message 
> > > > > Subject: Vendor Credit Memo Missing in OFbiz
> > > > > From: <ja...@productive1.com>
> > > > > Date: Mon, September 18, 2017 6:31 am
> > > > > To: user@ofbiz.apache.org
> > > > >
> > > > >
> > > > > Am I missing something or is there not a Vendor Credit memo in
> > Ofbiz? I
> > > > > see a Customer Credit Memo but not a Vendor? Experts please let me
> > > > > know.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > James
> > > > >
> > > >
> > >
> >
>
>
>
> --
> Thanks and Regards,
> *Amit Gadaley <https://about.me/amit_gadaley>* | Senior Enterprise
> Software
> Engineer
> HotWax Commerce <http://www.hotwax.co/> by HotWax Systems
> <http://www.hotwaxsystems.com/>
> Plot no. 80, Scheme no. 78 Part 2, Near Brilliant Convention Center,
> Indore,
> M.P., India - 452010
> Cell phone: +91 958.459.3069
>
> <https://about.me/amit_gadaley?promo=email_sig>
>


Re: not able to add to cart if price in INR

2017-08-28 Thread Suraj Khurana
Hi Rajesh,

So you are trying to place an order using e-commerce storefront.
In this case, you need to set default currency UOM of store to which
e-commerce website is associated.

https://erp.redgrape.tech/
catalog/control/EditProductStore?productStoreId=9000

Try this link, and under the localization tab, you can change the default
currency UOM of the store.

HTH.

--
Thanks and Regards
*Suraj Khurana* | Sr. Enterprise Software Engineer
HotWax Commerce  by  HotWax Systems


On Mon, Aug 28, 2017 at 3:03 PM, Rajesh Mallah <mallah.raj...@gmail.com>
wrote:

> @Suraj , @Pawan , @Deepak ,
>
> I am trying to place order from the ecommerce storefront
>
> https://erp.redgrape.tech/ecommerce/products/1
>
> Not able to place the product in the cart itself.
>
>
> regds
> mallah.
>
>
>
>
> On Mon, Aug 28, 2017 at 2:59 PM, Suraj Khurana <
> suraj.khur...@hotwaxsystems.com> wrote:
>
> > Hi Rajesh,
> >
> > While creating a new order, after adding customer to order, you will see
> a
> > screen with title *Enter Order Currency, Agreements, and Ship Dates,
> *from
> > here you can set order currency.
> >
> > HTH.
> >
> > --
> > Thanks and Regards
> > Suraj Khurana | Sr. Enterprise Software Engineer
> > HotWax Commerce  by  HotWax Systems
> >
> > On Mon, Aug 28, 2017 at 2:52 PM, Rajesh Mallah <mallah.raj...@gmail.com>
> > wrote:
> > >
> > > Dear Deepak ,
> > >
> > > thanks for the response. Kindly tell where it is set ,
> > > i looked for it in some places without success.
> > >
> > > regds
> > > mallah.
> > >
> > > On Mon, Aug 28, 2017 at 2:42 PM, Deepak Dixit <
> > > deepak.di...@hotwaxsystems.com> wrote:
> > >
> > > > Hi Rajesh,
> > > >
> > > > Please need to set the INR as order currency.
> > > >
> > > >
> > > > Thanks & Regards
> > > > --
> > > > Deepak Dixit
> > > > www.hotwaxsystems.com
> > > > www.hotwax.co
> > > >
> > > > On Mon, Aug 28, 2017 at 2:25 PM, Rajesh Mallah <
> > mallah.raj...@gmail.com>
> > > > wrote:
> > > >
> > > > > Hi ,
> > > > >
> > > > > Kindly help on below situation.
> > > > >
> > > > > I have started with demo data and did following
> > > > >
> > > > > (1) created a New Category and Catalog , and
> > > > >  added the catalog to Demo e-commerce Store.
> > > > >
> > > > > (2)  created a new product  in the new category.
> > > > >
> > > > > If i add pricing in USD the product is  getting added to cart,
> > > > >
> > > > > if i add pricing in INR its  giving error:
> > > > >
> > > > > "Could not find a valid price for the product with
> > > > > ID [1], not adding to cart."
> > > > >
> > > > > if i add 2 pricing one in INR and one in USD then only USD
> > > > > pricing is picked up and product is successfully getting added.
> > > > >
> > > > > I have changed default currency of store and other entities
> > > > > from USD to INR where ever i saw.
> > > > >
> > > > >
> > > > > regds
> > > > > mallah.
> > > > >
> > > >
> >
>


Re: not able to add to cart if price in INR

2017-08-28 Thread Suraj Khurana
Hi Rajesh,

While creating a new order, after adding customer to order, you will see a
screen with title *Enter Order Currency, Agreements, and Ship Dates, *from
here you can set order currency.

HTH.

--
Thanks and Regards
Suraj Khurana | Sr. Enterprise Software Engineer
HotWax Commerce  by  HotWax Systems

On Mon, Aug 28, 2017 at 2:52 PM, Rajesh Mallah <mallah.raj...@gmail.com>
wrote:
>
> Dear Deepak ,
>
> thanks for the response. Kindly tell where it is set ,
> i looked for it in some places without success.
>
> regds
> mallah.
>
> On Mon, Aug 28, 2017 at 2:42 PM, Deepak Dixit <
> deepak.di...@hotwaxsystems.com> wrote:
>
> > Hi Rajesh,
> >
> > Please need to set the INR as order currency.
> >
> >
> > Thanks & Regards
> > --
> > Deepak Dixit
> > www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Mon, Aug 28, 2017 at 2:25 PM, Rajesh Mallah <mallah.raj...@gmail.com>
> > wrote:
> >
> > > Hi ,
> > >
> > > Kindly help on below situation.
> > >
> > > I have started with demo data and did following
> > >
> > > (1) created a New Category and Catalog , and
> > >  added the catalog to Demo e-commerce Store.
> > >
> > > (2)  created a new product  in the new category.
> > >
> > > If i add pricing in USD the product is  getting added to cart,
> > >
> > > if i add pricing in INR its  giving error:
> > >
> > > "Could not find a valid price for the product with
> > > ID [1], not adding to cart."
> > >
> > > if i add 2 pricing one in INR and one in USD then only USD
> > > pricing is picked up and product is successfully getting added.
> > >
> > > I have changed default currency of store and other entities
> > > from USD to INR where ever i saw.
> > >
> > >
> > > regds
> > > mallah.
> > >
> >


Re: Inventory Transfer Feature

2017-08-25 Thread Suraj Khurana
Hi Deepak,

Please see my comments inline.


On Sat, Aug 26, 2017 at 10:18 AM, Deepak Nigam <
deepak.ni...@hotwaxsystems.com> wrote:

> Hello All,
>
> Do we have the support of features described below OTTB?
>
> 1) Inventory transfer from one warehouse to another warehouse.
>

Yes, in the facility detail screen, you will find Inventory Xfers menu
which willl lead to transfer inventory with one warehouse to another.


> 2) Inventory transfer from one location to another, within the same
> warehouse.
>

Yes, in the facility detail screen, you will find Stock Moves option which
will help to transfer stock from one location to another within the same
facility.


>
> If these features are available then please guide me to use them.
>
> Thanks in advance.
>
>
>
>
> Thanks & Regards
> --
> Deepak Nigam
> Technical Consultant/Team Lead
> HotWax Systems
> www.hotwaxsystems.com
>

HTH.
--
Thanks and Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer


Re: Price Rule

2017-07-19 Thread Suraj Khurana
Hi Ayush,
Please see my comments inline.

On Wed, Jul 19, 2017 at 5:14 PM, aayush jain <jaayush...@gmail.com> wrote:

> Hello,
> Greetings of the day!
>
> My question is related to Price Rule, While Creating Price Rule we get many
> options for actions:
> 1. Flat amount modify
>

Suppose the product list price is $10.00, and flat amount modify is set of
$2.00, than final price of product will be $12.00. (Can be negative value
as well)

2. Flat amount Override
>

Suppose the product list price is $10.00, and flat amount override is set
of $2.00, than final price of product will be $2.00.


> 3. Percent of Avg. cost
>

Suppose the product average cost is $10.00, and percent of average cost is
set of 80%, than final price of product will be $18.00. (Actually percent
is added to base average cost here)
price = price + perccent of average cost


> 4. Percent of default price
>

Suppose the product default price is $10.00, and percent of default price
is set of 10%, than final price of product will be $11.00.
price = price + perccent of default price


> 5. Percent of List Price
>

Suppose the product list price is $10.00, and percent of list price is set
of 120%, than final price of product will be $22.00.
price = price + perccent of list price


> 6. Percent of margin
>

Suppose the product margin (calculated internally or logic can be changed
according to business) is $10.00, and percent of margin is set of 90%, than
final price of product will be $19.00.
Currently, margin = list price - average cost.
If margin is found zero, than list price is used as priority.


> 7. Percent of wholesale
>

Suppose the product list price is $10.00, and percent of list price is set
of 120%, than final price of product will be $22.00.


> 8. Promo amount Override
>

Suppose the product promo price is set as $10.00, and promo amount override
is set of $18.00, than final price of product will be $18.00.
(It will use default price than list price for calculation if promo price
is not configured in the system)


> 9.Wholesale amount override
>

Suppose the product wholesale price is $10.00, and wholesale amount
override price is set of $15.00, than final price of product will be $25.00.
Here you might get confused with the name as it appends the override price
on the actual price.
(It will use default price than list price for calculation if whole sale
price is not configured in the system)


>
> What's the proper behavior of each Action type and difference between Flat
> Amount modify/override.
>

I hope difference between Flat amount modify and Flat amount Override is
also clear now.


>
> Thanks!
>

HTH.

--
Thanks and Regards,
*Suraj Khurana* | Sr. Enterprise Software Engineer
HotWax Commerce <http://www.hotwax.co/>  by  HotWax Systems
<http://www.hotwaxsystems.com/>
Plot no. 80, Scheme no. 78, Vijay Nagar, Indore, M.P. India 452010
Cell phone: +91 96697-50002
<https://about.me/surajkhurana?promo=email_sig>



HotWax Systems <http://www.hotwaxsystems.com/> recently received 8
mentions in *The Gartner Digital Commerce Vendor Guide, 2016 *by Gartner,
Inc., the world's leading IT research and advisory company.


Contributor registration request

2016-06-07 Thread Suraj Khurana
Hi,

Kindly register me as OFBiz contributor, my confluence username is
suraj.khurana

P.S. I have signed the ICL Agreement,
https://people.apache.org/unlistedclas.html (Suraj Khurana)

--
Thanks and Regards,
Suraj Khurana
Enterprise Software Engineer
HotWax Systems <http://www.hotwaxsystems.com/> - *The global leader in
innovative enterprise commerce solutions **powered by Apache OFBiz.*
<https://about.me/surajkhurana?promo=email_sig>