Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008165 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] 07. Sales management | major | always | 2009-03-17 17:45 | 2011-05-24 10:57 | |||
| Reporter | jaimetorre | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | urgent | Resolution | open | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | a | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | 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 | 0008165: Orders Awaiting Delivery Report does not exist | |||||||
| Description | A sales report showing all the orders pending delivery (shipment) is needed. | |||||||
| Proposed Solution | Following current report 'Orders Awaiting Invoice Report' structure (Sales Management || Analysis Tools || Orders Awaiting Invoice Report), create a report with the following filters (see attached OADRfilter.png): * From Date * To Date * Business Partner * Delivery Terms * Organization Display the following data (see attached OADRreport.png): * From To (Subtitle) * Organization (Level 1) * Business Partner (Level 2) * Order Doc Number (Level 3) * Order Date (Level 3) * Delivery Date (Level 3) * Delivery Terms (Level 3) * Delivery Location (Level 3) * Product (Level 4) * Ordered Quantity (c_orderline.qtyordered - Quantity ordered) (Level 4) * Pending Quantity (c_orderline.qtyordered - c_orderline.qtydelivered - Quantity pending to be delivered) (Level 4) * Quantity on hand (m_storage_detail.qtyonhand - Quantity on stock) (Level 4) Other data that could be shown: * Pre-Quantity (m_storage_detail.preqty - Transactions in draft status) (Level 4) * Pending Receipts (m_storage_pending.qtyordered - Sum of all quantities which have been purchased but not received) (Level 4) * Pending Shipments (m_storage_pending.qtyreserved - Sum of all quantities which have been sold but not received) (Level 4) | |||||||
| Tags | closingMay2011, tictech | |||||||
| Attached Files |  OADRfilter.png [^] (15,268 bytes) 2009-03-25 08:37
OADRreport.png [^] (23,212 bytes) 2009-03-25 08:37
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0017090) rafaroda (developer) 2009-06-08 13:51 |
Forge project: http://forge.openbravo.com/projects/ordersawaitingdlivery [^] Documentation: http://forge.openbravo.com/plugins/mwiki/index.php/Ordersawaitingdlivery [^] |
|
(0018398) rafaroda (developer) 2009-07-20 10:00 |
First version of the module can be found at http://forge.openbravo.com/uploads/mwiki/a/ab/Ordersawaitingdelivery.zip [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-03-17 17:45 | jaimetorre | New Issue | |
| 2009-03-17 17:45 | jaimetorre | Assigned To | => rafaroda |
| 2009-03-17 17:45 | jaimetorre | Regression testing | => No |
| 2009-03-17 17:50 | jaimetorre | Issue cloned | 0008166 |
| 2009-03-17 19:35 | jaimetorre | Tag Attached: tictech | |
| 2009-03-25 08:36 | rafaroda | Assigned To | rafaroda => gmauleon |
| 2009-03-25 08:36 | rafaroda | Status | new => acknowledged |
| 2009-03-25 08:36 | rafaroda | Description Updated | |
| 2009-03-25 08:36 | rafaroda | Steps to Reproduce Updated | |
| 2009-03-25 08:37 | rafaroda | File Added: OADRfilter.png | |
| 2009-03-25 08:37 | rafaroda | File Added: OADRreport.png | |
| 2009-03-25 08:40 | rafaroda | Relationship added | related to 0008166 |
| 2009-05-19 17:03 | pjuvara | Priority | immediate => urgent |
| 2009-06-08 13:51 | rafaroda | Note Added: 0017090 | |
| 2009-06-08 13:51 | rafaroda | Assigned To | gmauleon => rafaroda |
| 2009-06-08 13:51 | rafaroda | Status | acknowledged => scheduled |
| 2009-07-20 10:00 | rafaroda | Note Added: 0018398 | |
| 2009-07-20 10:00 | rafaroda | Status | scheduled => resolved |
| 2009-07-20 10:00 | rafaroda | Fixed in SCM revision | => n/a |
| 2011-05-24 09:59 | dalsasua | Tag Attached: closingMay2011 | |
| 2011-05-24 10:57 | dalsasua | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |