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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034318
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Payment Aging Balance Reportminoralways2016-10-27 13:252016-10-28 15:16
ReportervmromanosView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision3fc3b54d7cf8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date2016-06-29
Regression introduced by commithttps://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/8b5c51b059369333dc5607bfdcd0b0476bb21f27 [^]
Regression levelProduction - QA Approved
Review Assigned Toaferraz
Regression introduced in release
Summary

0034318: Supplier Reference stopped working

DescriptionThe document number displayed in the Payables Aging Schedule can show either the invoice/payment number or the supplier reference. This can be configured at Organization | Information tab, in the field: Purchase Invoice's Reference for Payment Description.

When that field is set to "Supplier Reference", the document no. shown in the payables report must show the supplier reference, and if blank, the invoice document number.


This feature stopped working.
Steps To ReproduceLog into F&B client
Create a Purchase invoice for Region Norte organization for 2 months ago. Leave the Supplier Reference empty.
Enter any line and process it. Do not pay it
Go to Organization window. Select Region Norte organization
Go to Information tab and select Supplier Reference inside the Purchase Invoice's Reference for Payment Description field
Open the Payables Aging Schedule window, select Region Norte organization, Show details = Y and leave the default value in the rest of fields.
Press search button.
Find the invoice previously created. Verify the document no. is equal to the invoice number. OK
Browse to that invoice and enter any value in the Supplier Reference field. Save it.
Launch the Payables Aging Schedule report again. The document no. should be the value entered in the Supplier Reference field, but instead it's the invoice number.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by defect 0033262 closedmarkmm82 To show "Supplier reference" for credit payments (same as invoices) in case Organization is configured for that 

-  Notes
(0090954)
vmromanos (manager)
2016-10-27 13:29

 Test plan:

Create a Purchase invoice for Region Norte organization for 2 months ago. Leave the Supplier Reference empty.
Enter any line and process it. Do not pay it
Go to Organization window. Select Region Norte organization
Go to Information tab and select Supplier Reference inside the Purchase Invoice's Reference for Payment Description field
Open the Payables Aging Schedule window, select Region Norte organization, Show details = Y and leave the default value in the rest of fields.
Press search button.
Find the invoice previously created. Verify the document no. is equal to the invoice number.
Browse to that invoice and enter any value in the Supplier Reference field. Save it.
Launch the Payables Aging Schedule report again. Verify the document no. is equal to the Supplier Reference introduced before.
Go to Organization window. Select Region Norte organization
Go to Information tab and select Invoice Document Number inside the Purchase Invoice's Reference for Payment Description field.
Launch the Payables Aging Schedule report again.
Find the invoice previously created. Verify the document no. is equal to the invoice number.
(0090955)
hgbot (developer)
2016-10-27 13:43

 Repository: erp/mods/org.openbravo.agingbalance
Changeset: 3fc3b54d7cf8c314737fb1c1d62e25b1f25a8887
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Oct 27 13:42:07 2016 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/3fc3b54d7cf8c314737fb1c1d62e25b1f25a8887 [^]

Fixed bug 34318: Supplier Reference stopped working

The fp.referenceno <> '' and i.poreference <> '' are wrongly evaluated by the database. In case any of these fields is not null, the database will evaluate these expressions as false. Thus the AGING_GETDOCNO function is never called and the report always shows the invoice number.

Removing those expressions fixes the issue.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/agingbalance/ad_reports/AgingDao_data.xsql
---
(0090956)
vmromanos (manager)
2016-10-27 13:44

 Fixed in module version 3.1.1701 (or higher)
(0090999)
aferraz (manager)
2016-10-28 15:16

 Bug is only reproducible in Oracle.
(0091000)
aferraz (manager)
2016-10-28 15:16

 Code review + Testing OK

- Issue History
Date Modified Username Field Change
2016-10-27 13:25 vmromanos New Issue
2016-10-27 13:25 vmromanos Assigned To => vmromanos
2016-10-27 13:25 vmromanos Regression date => 2016-06-29
2016-10-27 13:25 vmromanos Regression introduced by commit => https://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/8b5c51b059369333dc5607bfdcd0b0476bb21f27 [^]
2016-10-27 13:25 vmromanos Regression level => Production - QA Approved
2016-10-27 13:26 vmromanos Relationship added caused by 0033262
2016-10-27 13:29 vmromanos Note Added: 0090954
2016-10-27 13:34 vmromanos Status new => scheduled
2016-10-27 13:42 vmromanos Review Assigned To => aferraz
2016-10-27 13:43 hgbot Checkin
2016-10-27 13:43 hgbot Note Added: 0090955
2016-10-27 13:43 hgbot Status scheduled => resolved
2016-10-27 13:43 hgbot Resolution open => fixed
2016-10-27 13:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/3fc3b54d7cf8c314737fb1c1d62e25b1f25a8887 [^]
2016-10-27 13:44 vmromanos Note Added: 0090956
2016-10-28 15:16 aferraz Note Added: 0090999
2016-10-28 15:16 aferraz Note Added: 0091000
2016-10-28 15:16 aferraz Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker