Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008173Openbravo ERP07. Sales managementpublic2009-03-17 18:372009-07-03 14:26
Reporterjaimetorre 
Assigned Tovmromanos 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP1 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0008173: Create invoices from orders: does not follow invoice terms
DescriptionIf an order is partially shipped and the invoice term for that partner is set to 'after delivery' the Create Invoices From Order should show the partial amount that will be invoiced and not the total amount of the order. (In the order selection list, both the 'lines amt' and the 'not invoiced' are incorrect.)
Steps To Reproduce
Proposed SolutionAdd a new check to select gross/net so depending the checkbox the amounts shown will be gross or net. The default value will be gross as it is the amounts shown currently.

3 amount columns will be visible:

-Line amt (gross/net)
-Not invoiced (gross/net)
-Pending to invoice taking into account the invoice term.

Add a new column with the invoice term of the order.
Additional Information
Tagstictech
Relationships
related to feature request 0008175 closed vmromanos Create Invoices from Orders: the amounts shown don't include taxes 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-17 18:37jaimetorreNew Issue
2009-03-17 18:37jaimetorreAssigned To => rafaroda
2009-03-17 18:37jaimetorreRegression testing => No
2009-03-17 18:39jaimetorreDescription Updated
2009-03-17 19:35jaimetorreTag Attached: tictech
2009-03-18 09:28rafarodaversion => 2.40MP1
2009-03-24 13:34pmagninNote Added: 0014897
2009-03-24 13:34pmagninTypedefect => feature request
2009-03-24 13:37gorkaionRelationship addedrelated to 0008175
2009-03-24 13:44gorkaionSteps to Reproduce Updated
2009-03-24 13:45gorkaionStatusnew => acknowledged
2009-03-26 11:04rafarodaAssigned Torafaroda => gmauleon
2009-04-02 12:36vmromanosAssigned Togmauleon => vmromanos
2009-04-02 12:36vmromanosStatusacknowledged => scheduled
2009-04-02 12:36vmromanosfix_in_branch => pi
2009-04-22 12:41hgbotCheckin
2009-04-22 12:41hgbotNote Added: 0015522
2009-04-22 12:41hgbotStatusscheduled => resolved
2009-04-22 12:41hgbotResolutionopen => fixed
2009-04-22 12:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/03e9f606c46e9dfaa6ca001fd4dc93f1faa41ebd [^]
2009-06-05 18:53pjuvaraStatusresolved => closed
2009-06-06 00:00anonymoussf_bug_id0 => 2802026
2009-07-03 14:26pjuvaraPriorityimmediate => urgent

Notes
(0014897)
pmagnin   
2009-03-24 13:34   
This behavior is standard in Openbravo, the application is showing the total gross sales order amount and the total pending gross amount to be invoiced (without any consideration of invoice term).

For example:
Sales Order: 10 bicycles for 1000 euros (Invoice Term=After Delivery)
Shipment: 5 bicycles
Sales Invoice (Manual): 2 bicycles (200 euros)

Create Invoice from Order:
Lines amt=1000
Not Invoiced=800

This information is correct, but does not show the “Pending Invoiced Amount”. In this case 0 euros because I didn’t receive more than the 200 first bicycles. But the process is working fine: If you click on the ‘Process’ Button, you won’t create any invoice.

I would recommend complementing the current information and adding a column to improve the interpretation:

1) Change column title “Lines amt” by “Total Gross Amt”
2) Change “Not Invoiced” by “Total Gross Amt not invoiced”
3) Add “Total Gross Amt pending to be invoiced”

For this column, the calculation will depend on the Invoice term, the process the lines with an amount of 0 (zero).
If I receive 2 new bicycles from the same sales order and go to “Create Invoice from Order”, the new information will be:

Total Gross Amt =1000
Total Gross Amt not invoiced =800
Total Gross Amt pending to be invoiced=200
(0015522)
hgbot   
2009-04-22 12:41   
Repository: erp/devel/pi
Changeset: 03e9f606c46e9dfaa6ca001fd4dc93f1faa41ebd
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed Apr 22 12:40:21 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/03e9f606c46e9dfaa6ca001fd4dc93f1faa41ebd [^]

Fixed issue 8173 and 8175: Improved the Create Invoices from Orders window

---
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrderRecord_data.xsql
M src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual.html
M src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual.java
M src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual.xml
M src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual_data.xsql
---