Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008166Openbravo ERP07. Sales managementpublic2009-03-17 17:502011-05-24 10:57
jaimetorre 
rafaroda 
urgentmajoralways
closedopen 
5
 
 
Core
No
0008166: Shipments Awaiting Invoice Report does not exist
A report showing the orders that have not yet been invoiced already exists. However, some companies (and Openbravo allows it) invoice shipments instead of orders. Therefore, a report showing the shipments that have not yet been invoiced is needed.
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 SAIRfilter.png):
* From Date
* To Date
* Business Partner
* Form of Payment
* Payment Terms
* Organization

Display the following data (see attached SAIRreport.png):
1 - Group by Options

    * Organization
    * Business Partner
    * Sending Address

Note: For the address, in order to improve the visibility, I suggest to only keep the Postal code, the City and the Region.

2 - Information Available

    * Shipment date
    * CONTROL_STRING
          o If (Amount Invoiced <= 0) Then CONTROL_STRING = “ABONO” Else CONTROL_STRING = “” End-If;
          o Warning: This column is important for the customer but completely specific. This column will be deleted for the standard new report. Please comment without any restriction the code associated in order to easily suppress it.
    * Amount Invoiced Pending
    * Shipment Status
    * Form of payment
    * Payment Terms
    * % Discount (of “Pronto Pago” if exists in Business Partner information).
closingMay2011, tictech
related to feature request 0008165 closed rafaroda Orders Awaiting Delivery Report does not exist 
png SAIRfilter.png (14,664) 2009-03-27 15:28
https://issues.openbravo.com/file_download.php?file_id=1084&type=bug
png

png SAIRreport.png (14,539) 2009-03-27 15:28
https://issues.openbravo.com/file_download.php?file_id=1085&type=bug
png
Issue History
2009-03-17 17:50jaimetorreNew Issue
2009-03-17 17:50jaimetorreAssigned To => rafaroda
2009-03-17 17:50jaimetorreRegression testing => No
2009-03-17 17:50jaimetorreIssue generated from0008165
2009-03-17 19:35jaimetorreTag Attached: tictech
2009-03-25 08:40rafarodaRelationship addedrelated to 0008165
2009-03-27 15:28rafarodaAssigned Torafaroda => gmauleon
2009-03-27 15:28rafarodaStatusnew => acknowledged
2009-03-27 15:28rafarodaDescription Updated
2009-03-27 15:28rafarodaSteps to Reproduce Updated
2009-03-27 15:28rafarodaFile Added: SAIRfilter.png
2009-03-27 15:28rafarodaFile Added: SAIRreport.png
2009-05-19 17:03pjuvaraPriorityimmediate => urgent
2009-06-08 13:52rafarodaNote Added: 0017091
2009-06-08 13:52rafarodaAssigned Togmauleon => rafaroda
2009-06-08 13:52rafarodaStatusacknowledged => scheduled
2009-07-20 10:01rafarodaNote Added: 0018399
2009-07-20 10:01rafarodaStatusscheduled => resolved
2009-07-20 10:01rafarodaFixed in SCM revision => n/a
2009-07-20 10:01rafarodaNote Edited: 0018399
2011-05-24 09:59dalsasuaTag Attached: closingMay2011
2011-05-24 10:57dalsasuaStatusresolved => closed

Notes
(0017091)
rafaroda   
2009-06-08 13:52   
Forge project: http://forge.openbravo.com/projects/shipmentawaitinginvoice [^]

Documentation: http://forge.openbravo.com/plugins/mwiki/index.php/Shipmentawaitinginvoice [^]
(0018399)
rafaroda   
2009-07-20 10:01   
First version of the module can be found at http://forge.openbravo.com/uploads/mwiki/e/e1/Shipmentawaitinginvoice.zip [^]