Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0006322 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| feature request | [Openbravo ERP] 03. Procurement management | minor | N/A | 2008-12-02 12:30 | 2011-02-04 09:11 | ||||||
| Reporter | RenateNieuwkoop | View Status | public | ||||||||
| Assigned To | rmorley | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Oracle | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0006322: RFE: Procurement: Purchase Order Delivery Report | ||||||||||
| Description | Right 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. | ||||||||||
| Tags | ReleaseCandidate, Uservoice | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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! |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |