Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006322Openbravo ERP03. Procurement managementpublic2008-12-02 12:302011-02-04 09:11
ReporterRenateNieuwkoop 
Assigned Tormorley 
PrioritynormalSeverityminorReproducibilityN/A
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006322: RFE: Procurement: Purchase Order Delivery Report
DescriptionRight now there is the Purchase Dimensional Report, but it doesn't reflect the information you would typically want:

- reflect what Purchase Order lines are scheduled to be delivery in a date range
- reflect for a certain Vendor what Purchase Order lines we have outstanding and what their scheduled delivery dates will be

So there would be a filter by Business Partner (Vendor) and filtering by Scheduled Delivery date.

Columns that would always show: 'amount' and 'Quantity' (see Purchase Dimensional report).
It should be a dimensional report so you can also select Business Partner Group, Product, Product group and document number.
Steps To Reproduce
Proposed Solution
Additional Information
TagsReleaseCandidate, Uservoice
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-02 12:30RenateNieuwkoopNew Issue
2008-12-02 12:30RenateNieuwkoopAssigned To => rafaroda
2008-12-02 12:30RenateNieuwkoopsf_bug_id0 => 2376875
2008-12-02 16:33azabaletaNote Added: 0010903
2008-12-02 16:33azabaletaNote Edited: 0010903
2008-12-02 16:34RenateNieuwkoopNote Added: 0010905
2008-12-10 14:44rafarodaAssigned Torafaroda => pjuvara
2009-09-15 19:17pjuvaraTag Attached: ReleaseCandidate
2009-09-15 19:17pjuvaraTag Attached: Uservoice
2009-09-15 19:17pjuvaraStatusnew => acknowledged
2011-02-04 09:11jpabloaeAssigned Topjuvara => rmorley

Notes
(0010903)
azabaleta   
2008-12-02 16:33   
Possible query

SELECT CBP.NAME AS VENDOR, CO.DOCUMENTNO, COL.LINE, P.NAME AS PRODUCT, COL.QTYORDERED, COL.DATEPROMISED
FROM C_ORDER CO
  LEFT JOIN C_ORDERLINE COL ON COL.C_ORDER_ID=CO.C_ORDER_ID
    LEFT JOIN C_BPARTNER CBP ON CO.C_BPARTNER_ID=CBP.C_BPARTNER_ID
    LEFT JOIN M_PRODUCT P ON P.M_PRODUCT_ID=COL.M_PRODUCT_ID
WHERE CO.ISSOTRX='N'
AND CO.DOCSTATUS='CO'
order by COL.DATEPROMISED

This query does not have into account the delivered quantity
(0010905)
RenateNieuwkoop   
2008-12-02 16:34   
Yes, it would be great to take into account the delivered quantity also!