Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006322
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 03. Procurement managementminorN/A2008-12-02 12:302011-02-04 09:11
ReporterRenateNieuwkoopView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006322: 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.
TagsReleaseCandidate, Uservoice
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0010903)
azabaleta (developer)
2008-12-02 16:33
edited on: 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 (reporter)
2008-12-02 16:34

Yes, it would be great to take into account the delivered quantity also!

- Issue History
Date Modified Username Field Change
2008-12-02 12:30 RenateNieuwkoop New Issue
2008-12-02 12:30 RenateNieuwkoop Assigned To => rafaroda
2008-12-02 12:30 RenateNieuwkoop sf_bug_id 0 => 2376875
2008-12-02 16:33 azabaleta Note Added: 0010903
2008-12-02 16:33 azabaleta Note Edited: 0010903
2008-12-02 16:34 RenateNieuwkoop Note Added: 0010905
2008-12-10 14:44 rafaroda Assigned To rafaroda => pjuvara
2009-09-15 19:17 pjuvara Tag Attached: ReleaseCandidate
2009-09-15 19:17 pjuvara Tag Attached: Uservoice
2009-09-15 19:17 pjuvara Status new => acknowledged
2011-02-04 09:11 jpabloae Assigned To pjuvara => rmorley


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker