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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008166
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementmajoralways2009-03-17 17:502011-05-24 10:57
ReporterjaimetorreView Statuspublic 
Assigned Torafaroda 
PriorityurgentResolutionopenFixed in Version
StatusclosedFix in branchFixed in SCM revisiona
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava 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

0008166: Shipments Awaiting Invoice Report does not exist

DescriptionA 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.
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 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).
TagsclosingMay2011, tictech
Attached Filespng file icon SAIRfilter.png [^] (14,664 bytes) 2009-03-27 15:28


png file icon SAIRreport.png [^] (14,539 bytes) 2009-03-27 15:28

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0008165 closedrafaroda Orders Awaiting Delivery Report does not exist 

-  Notes
(0017091)
rafaroda (developer)
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 (developer)
2009-07-20 10:01
edited on: 2009-07-20 10:01

First version of the module can be found at http://forge.openbravo.com/uploads/mwiki/e/e1/Shipmentawaitinginvoice.zip [^]


- Issue History
Date Modified Username Field Change
2009-03-17 17:50 jaimetorre New Issue
2009-03-17 17:50 jaimetorre Assigned To => rafaroda
2009-03-17 17:50 jaimetorre Regression testing => No
2009-03-17 17:50 jaimetorre Issue generated from 0008165
2009-03-17 19:35 jaimetorre Tag Attached: tictech
2009-03-25 08:40 rafaroda Relationship added related to 0008165
2009-03-27 15:28 rafaroda Assigned To rafaroda => gmauleon
2009-03-27 15:28 rafaroda Status new => acknowledged
2009-03-27 15:28 rafaroda Description Updated
2009-03-27 15:28 rafaroda Steps to Reproduce Updated
2009-03-27 15:28 rafaroda File Added: SAIRfilter.png
2009-03-27 15:28 rafaroda File Added: SAIRreport.png
2009-05-19 17:03 pjuvara Priority immediate => urgent
2009-06-08 13:52 rafaroda Note Added: 0017091
2009-06-08 13:52 rafaroda Assigned To gmauleon => rafaroda
2009-06-08 13:52 rafaroda Status acknowledged => scheduled
2009-07-20 10:01 rafaroda Note Added: 0018399
2009-07-20 10:01 rafaroda Status scheduled => resolved
2009-07-20 10:01 rafaroda Fixed in SCM revision => n/a
2009-07-20 10:01 rafaroda Note Edited: 0018399
2011-05-24 09:59 dalsasua Tag Attached: closingMay2011
2011-05-24 10:57 dalsasua Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker