+1 database technology changes but business level constraints are
permanent (most of the time) and are usually tied to the real world not
technology.
On 27/11/2014 10:10 AM, Jacopo Cappellato wrote:
hmmm... in a complex system like OFBiz there are so many configuration
constraints (even spanning data on different tables) that we will always need
to enforce them at the business layer: I don't see a big value in adding this
constraint at the db layer.
We should instead, in my opinion, implement this constraint in the services
that are responsible for the creation and update of the information in the
ProductStore
Jacopo
On Nov 27, 2014, at 3:38 PM, Jacques Le Roux <jacques.le.r...@les7arts.com>
wrote:
Even though it makes sense, we could maybe add a constraint for that in DB.
Unfortunately I don't think this possibility already exists in OFBiz and it
depends on DBMS
http://www.w3schools.com/sql/sql_check.asp
<<If you define a CHECK constraint on a table it can limit the values in certain
columns based on values in other columns in the row.>>
We could create a Jira and fill the gap when we get a chance, opinions?
Jacques
Le 27/11/2014 14:51, Hoan dang van a écrit :
Thanks Divesh Dutta very much
I have just done follow you and system run as I like
On Thu, Nov 27, 2014 at 7:39 PM, Divesh Dutta <divesh.du...@hotwaxmedia.com>
wrote:
Hi Hoan dang van,
isImmediatelyFulfilled and reserveInvetory flags are mutually exclusive,
i.e if isImmediatelyFulfilled is set to "Y" then reserveInventory should
always set to "N" and vice versa. So for web stores/e-commerce stores
settings should be :
isImmediatelyFulfilled = N
reserveInventory = Y
Other warehouse settings for web store are given here:
http://www.hotwaxmedia.com/apache-ofbiz-blog/diy-configure-ofbiz-warehouse-management/
and for POS stores:
isImmediatelyFulfilled = Y
reserveInventory = N
requireInventory = System avoids this field when reserveInventory = "N". So
you can leave it empty or set it to N.
Items should be immediately issued, skipping reservation process of system.
So ideally, once order is placed it should be marked completed
automatically.
Thanks
--
Divesh Dutta.
On Thu, Nov 27, 2014 at 4:08 PM, Hoan dang van <hoand...@gmail.com> wrote:
Hi Rishi Solanki
Yes, I'm using OFBIZ trunk. This is my product store xml
However, when I completed order form webpos component (status of order is
completed), the quantity of items which I had bought before is imported
into " Ordered", instead of "Ship request".
On Wed, Nov 26, 2014 at 5:34 PM, Rishi Solanki <rishisolan...@gmail.com>
wrote:
Hoan dang van,
As requested on original ticket where you shared this problem, could you
please share the complete product store xml data you have setup. It will
help us to diagnose the problem you are facing. I'm assuming you are
using
13.07 or trunk to setup your store.
Best Regards,
Rishi Solanki
Manager, Enterprise Software Development
HotWax Media Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxmedia.com
On Tue, Nov 25, 2014 at 1:01 PM, Hoan dang van <hoand...@gmail.com>
wrote:
Hi Scott Gray!
I have set up reserve inventory is Y.
On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray <
scott.g...@hotwaxmedia.com
wrote:
Is your store configured to reserve inventory? It's that setting
that
causes reservations to be created which in turn to decreases ATP
Regards
Scott
On Tue, Nov 25, 2014 at 6:05 PM, Hoan dang van <hoand...@gmail.com>
wrote:
When I configure store in catalog component and i selected Is
Immediately
Fulfilled Tab is N then i create a order by webpos. The order is
completed
but when i check this order in order, i appear that the product
that i
buy,
have Qty Shipped status is 0 and Ship Request status is 2 (2 is
quantity
that i bought in this order)
When i selected again Is Immediately Fulfilled Tab is Y , Qty
Shipped
status is 2 and Ship Request status is 0. Then i create a order by
order
component , Order is created but ATP of product that i bought with
this
order, not automatic decrease (equal before i bought )
Can everybody tell me where i do wrong and how to fix it
Thanks
--
Ron Wheeler
President
Artifact Software Inc
email: rwhee...@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
