ATP not automatic decrease when a order is created
Locked
 
|
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 |
Re: ATP not automatic decrease when a order is created
|
|
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 <[hidden email]> 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 |
|
|
Hi Scott Gray!
I have set up reserve inventory is Y. On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray <[hidden email]> 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 <[hidden email]> 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 > |
Re: ATP not automatic decrease when a order is created
|
|
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 <[hidden email]> wrote: > Hi Scott Gray! > I have set up reserve inventory is Y. > > > > On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray <[hidden email]> > 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 <[hidden email]> > 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 > > > |
|
|
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 <[hidden email]> wrote: Hoan dang van, |
ProductStore.xml (2K)
Re: ATP not automatic decrease when a order is created
|
|
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 <[hidden email]> 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 <[hidden email]> > 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 <[hidden email]> >> wrote: >> >> > Hi Scott Gray! >> > I have set up reserve inventory is Y. >> > >> > >> > >> > On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray <[hidden email] >> > >> > 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 <[hidden email]> >> > 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 >> > > >> > >> > > |
|
|
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> > > 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 <[hidden email]> > >> wrote: > >> > >> > Hi Scott Gray! > >> > I have set up reserve inventory is Y. > >> > > >> > > >> > > >> > On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray < > [hidden email] > >> > > >> > 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 <[hidden email]> > >> > 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 > >> > > > >> > > >> > > > > > |
Re: ATP not automatic decrease when a order is created
Administrator
|
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 <[hidden email]> > 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 <[hidden email]> 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 <[hidden email]> >>> 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 <[hidden email]> >>>> wrote: >>>> >>>>> Hi Scott Gray! >>>>> I have set up reserve inventory is Y. >>>>> >>>>> >>>>> >>>>> On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray < >> [hidden email] >>>>> 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 <[hidden email]> >>>>> 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 >>> |
Re: ATP not automatic decrease when a order is created
|
|
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 <[hidden email]> 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 <[hidden email]> >> 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 <[hidden email]> 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 <[hidden email]> >>>> 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 <[hidden email]> >>>>> wrote: >>>>> >>>>>> Hi Scott Gray! >>>>>> I have set up reserve inventory is Y. >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray < >>> [hidden email] >>>>>> 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 <[hidden email]> >>>>>> 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 >>>> |
Re: ATP not automatic decrease when a order is created
|
Administrator
|
Yes, that's another good solution (though less general, I always prefer to cut issues at their roots. But I must admit I have, at the moment, no time
to contribute a change at the Entity Engine level :/ ) I will create a Jira for both solutions (2 Jira issues I mean). Better to keep track of ideas, I will see later if I get a chance to implement it at the DB level. Jacques Le 27/11/2014 16:10, Jacopo Cappellato a écrit : > 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 <[hidden email]> 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 <[hidden email]> >>> 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 <[hidden email]> 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 <[hidden email]> >>>>> 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 <[hidden email]> >>>>>> wrote: >>>>>> >>>>>>> Hi Scott Gray! >>>>>>> I have set up reserve inventory is Y. >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray < >>>> [hidden email] >>>>>>> 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 <[hidden email]> >>>>>>> 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 > > |
Re: ATP not automatic decrease when a order is created
|
|
In reply to this post by Jacopo Cappellato-4
+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 <[hidden email]> 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 <[hidden email]> >>> 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 <[hidden email]> 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 <[hidden email]> >>>>> 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 <[hidden email]> >>>>>> wrote: >>>>>> >>>>>>> Hi Scott Gray! >>>>>>> I have set up reserve inventory is Y. >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Nov 25, 2014 at 1:23 PM, Scott Gray < >>>> [hidden email] >>>>>>> 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 <[hidden email]> >>>>>>> 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: [hidden email] skype: ronaldmwheeler phone: 866-970-2435, ext 102 |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |