Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006515Openbravo ERP02. Master data managementpublic2008-12-12 17:042011-02-04 09:15
networkb 
rmorley 
highmajoralways
acknowledgedopen 
5
2.40 
 
Core
No
0006515: Multi-currency volume discounts
Currently volume discounts are specific to a currency.

As a consequence, the volume discount of a certain business partner does not include invoices in currencies different from the one of the volume discount definition.
Go to business partner setup and create a volume discount with included product and categories Not Selected and currency different from EUR.
Create a sales invoice for any BP and product with enough quantity to apply the created discount.
Go to the business partner/volume discount tab and try to create invoice with the volume discount chosen
ReleaseCandidate
Issue History
2008-12-12 17:04maiteElizariNew Issue
2008-12-12 17:04maiteElizariAssigned To => rafaroda
2008-12-12 17:04maiteElizarisf_bug_id0 => 2421659
2008-12-12 18:27networkbReportermaiteElizari => networkb
2008-12-12 18:27networkbPrioritynormal => immediate
2008-12-12 18:27networkbIssue Monitored: networkb
2008-12-12 18:33psarobeNote Added: 0011277
2008-12-12 19:02networkbProposed Solution updated
2008-12-13 12:32rafarodaNote Added: 0011289
2008-12-13 12:32rafarodaStatusnew => feedback
2008-12-15 16:37networkbNote Added: 0011375
2008-12-15 16:37networkbTypedefect => feature request
2008-12-15 18:25networkbPriorityimmediate => high
2008-12-17 10:07rafarodaAssigned Torafaroda => pjuvara
2008-12-17 20:01pjuvaraStatusfeedback => new
2008-12-17 20:01pjuvaraSummaryCurrency of volume discount and invoice => Multi-currency volume discounts
2008-12-17 20:01pjuvaraDescription Updated
2008-12-17 20:01pjuvaraTag Attached: ReleaseCandidate
2008-12-17 20:01pjuvaraStatusnew => acknowledged
2011-02-04 09:15jpabloaeAssigned Topjuvara => rmorley

Notes
(0011277)
psarobe   
2008-12-12 18:33   
We need to have a better description and steps to reproduce in order to reproduce the bug. Otherwise the bug will be rejected. Think that once the bug has been resolved by engineering also QA needs to verify.

Thanks in advance
(0011289)
rafaroda   
2008-12-13 12:32   
The definition of a rappel is done via the following steps [1]:

1) Create a new volume discount inside 'Master Data Management || Business Partner Setup || Volume Discount' with:
* Name = 50% discount
* Included Product = Not Selected
* Included Product Categories = Not Selected
* Currency = EUR

Please notice that a currency has to be selected so the rappel will only apply to the invoices with this same currency (see function M_RAPPEL_INVOICE_CREATE [2]). In other words, the functionality of currency conversion during the creation of rappels is not implemented. Should this issue change its type to feature request?

[1] http://wiki.openbravo.com/wiki/Technical_FAQ_about_Openbravo_ERP#How_can_I_create_volume_discounts_.28Rappels.29.3F [^]
[2] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml [^]
SELECT COALESCE(SUM(IL.LINENETAMT), 0)
    INTO v_TotalLines
    FROM C_INVOICE I,
      C_INVOICELINE IL,
      M_RAPPEL_BPARTNER RP,
      C_BPARTNER_LOCATION PL,
      M_RAPPEL R
    WHERE I.C_INVOICE_ID=IL.C_INVOICE_ID
      AND R.M_RAPPEL_ID=RP.M_RAPPEL_ID
      AND R.C_CURRENCY_ID=I.C_CURRENCY_ID <-- Same currency required in rappel and invoice
      AND I.PROCESSED='Y'
      AND I.DATEINVOICED>=RP.VALIDFROM
      AND I.DATEINVOICED<v_LimitDate+1
      AND I.C_BPARTNER_ID=RP.C_BPARTNER_ID
      AND I.C_BPARTNER_ID = PL.C_BPARTNER_ID
(0011375)
networkb   
2008-12-15 16:37   
Ok. so the type is changed to Feature Request. Thanks