Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008165Openbravo ERP07. Sales managementpublic2009-03-17 17:452011-05-24 10:57
Reporterjaimetorre 
Assigned Torafaroda 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008165: Orders Awaiting Delivery Report does not exist
DescriptionA sales report showing all the orders pending delivery (shipment) is needed.
Steps To Reproduce
Proposed SolutionFollowing 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)
Additional Information
TagsclosingMay2011, tictech
Relationships
related to feature request 0008166 closed rafaroda Shipments Awaiting Invoice Report does not exist 
Attached Filespng OADRfilter.png (15,268) 2009-03-25 08:37
https://issues.openbravo.com/file_download.php?file_id=1057&type=bug
png

png OADRreport.png (23,212) 2009-03-25 08:37
https://issues.openbravo.com/file_download.php?file_id=1058&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-03-17 17:45jaimetorreNew Issue
2009-03-17 17:45jaimetorreAssigned To => rafaroda
2009-03-17 17:45jaimetorreOBNetwork customer => Yes
2009-03-17 17:45jaimetorreRegression testing => No
2009-03-17 17:50jaimetorreIssue cloned0008166
2009-03-17 19:35jaimetorreTag Attached: tictech
2009-03-25 08:36rafarodaAssigned Torafaroda => gmauleon
2009-03-25 08:36rafarodaStatusnew => acknowledged
2009-03-25 08:36rafarodaDescription Updated
2009-03-25 08:36rafarodaSteps to Reproduce Updated
2009-03-25 08:37rafarodaFile Added: OADRfilter.png
2009-03-25 08:37rafarodaFile Added: OADRreport.png
2009-03-25 08:40rafarodaRelationship addedrelated to 0008166
2009-05-19 17:03pjuvaraPriorityimmediate => urgent
2009-06-08 13:51rafarodaNote Added: 0017090
2009-06-08 13:51rafarodaAssigned Togmauleon => rafaroda
2009-06-08 13:51rafarodaStatusacknowledged => scheduled
2009-07-20 10:00rafarodaNote Added: 0018398
2009-07-20 10:00rafarodaStatusscheduled => resolved
2009-07-20 10:00rafarodaFixed in SCM revision => n/a
2011-05-24 09:59dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0017090)
rafaroda   
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   
2009-07-20 10:00   
First version of the module can be found at http://forge.openbravo.com/uploads/mwiki/a/ab/Ordersawaitingdelivery.zip [^]