Seems that I forgot this one https://issues.apache.org/jira/browse/OFBIZ-3161
Too much things on my plate :/ I will try to review...
Jacques
Le 31/05/2014 01:44, Jen Sing Choe a écrit :
Even if i apply ordering, it will still create confusing especially on the
ecommerce/PO/invoice
I feel a bit weird that out-of-the-box, ofbiz does not prevent over-lapping
on the time-based condition.
Ofbiz only prevent the from having the same start date.
Is it better, if there is over-lapping time-based checking (on date without
timestamp) ?
On Fri, May 30, 2014 at 2:59 PM, james_sg <[email protected]> wrote:
Hi,
In the database, the dates are stored with non-zero time.
When selecting a price, you can choose to filter with a date with zero
time.
So the effect is you will retrieve only 1 record.
twosolution wrote
Hi,
In product pricing, we can define multiple record
PRIMARY KEY (product_id, product_price_type_id, product_price_purpose_id,
currency_uom_id, product_store_group_id, from_date)
My below scenario is at below
(1 + 2 + 3 + 4 + 5 + 2Jan2014 ) and thruDate = 15Jan2014
(1 + 2 + 3 + 4 + 5 + 15Jan2014 ) and thruDate is null
and i would like to return 15jan2014 pricing, and i will return 2
records.
And assuming timestamp is not important in this scenario. Just only the
date
What is the current practice of choosing which record to retrieve ?
--
Disclaimer : This E-mail is intended only for the use of the individual
or
entity named above and may contain information that is confidential. If
you
are not the intended recipients, please immediately notify us by return
email and delete it from your system. Any unauthorised dissemination,
distribution or copying of this email is strictly prohibited. Thank You.
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Product-Pricing-multiple-time-based-record-tp4651240p4651249.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
--
