Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2020-09-21 11:032020-09-24 09:03
ReportermaiteView Statuspublic 
Assigned Toinigo_lerga 
PriorityurgentResolutionfixedFixed in VersionPR20Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression levelPre packaging ( pi )
Regression date2020-08-14
Regression introduced in releasepi
Regression introduced by commit [^]
Triggers an Emergency PackNo

0045097: Payment wrongly shown as Credit, as it is also associated to the invoice

DescriptionPayment associated to an invoiced order appears as Credit, when it should not
Steps To Reproduce1. Create Sales Order for any org and BP. Set Immediate invoice terms. Add any product and complete it
2. Create Sales Invoice for same org and BP. Run Create Lines from and select previous order. Complete
3. Go to Sales Order and run Add Payment process to pay both order and invoice
4. Run Receivables Aging Report and realize that this payment appears in Credits section. It should not appear as it is also paying the invoice
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0045099PR20Q3.1 closedinigo_lerga Payment wrongly shown as Credit, as it is also associated to the invoice 
depends on backport 0045100PR20Q2.2 closedinigo_lerga Payment wrongly shown as Credit, as it is also associated to the invoice 
caused by defect 0044788 closedinigo_lerga Wrong information in Credits section of Aging Report: the date when a prepaid order was invoiced needs to be considered 

-  Notes
dmiguelez (developer)
2020-09-21 11:34

In the previous steps to reproduce, the date used for all documents was 'Today'

If the Aging report is executed for 'Tomorrow' the information shown is correct.

This means that the issue is related to how the dates are compared between the filter and the Invoice Date.
inigo_lerga (developer)
2020-09-22 09:20
edited on: 2020-09-22 14:36

--Test Plan Mantis--

As the F&B International Group Admin role in Backend:
1º- Go to Sales Order window and create a new record with 'Alimentos y Supermercados, S.A' as Business Partner.
2º- Set the Invoice Terms to Inmediate.
3º- Go to Lines Tab and create a new line with any product and quantity desired.
4º- Save and Book the record.
5º- Go to Sales Invoice window and create a new record with 'Alimentos y Supermercados, S.A' as Business Partner.
6º- Set Today as Invoice Date
7º- Press the Create Lines From Order button and select the ones from the previous Sales Order.
8º- Save and Complete the Sales Invoice.
9º- Go back to Sales Order window, to previous record, Press the Add payment button and Done button in the popup window.
10º- Go to Receivables Aging Schedule window, set Today as the As Of Date field and press the View button.

    #You will see that now this payment is not wrongly shown as Credit#

hgbot (developer)
2020-09-22 09:33

Merge Request created: [^]
dmiguelez (developer)
2020-09-22 11:44

Test Plan.

Also tested plan for Issue [^]
hgbot (developer)
2020-09-22 11:48

Merge request merged: [^]
hgbot (developer)
2020-09-22 11:48

Directly closing issue as related merge request is already approved.

Repository: [^]
Changeset: fc66b38a794b2a1bbdf9775aea9b9e4571d5d46e
Author: inigo_lerga <>
Date: 2020-09-21T18:00:07+02:00
URL: [^]

fixes BUG-45097:Date of order invoice properly considered

Records can be shown as Credit only if the reference date of
the report is previous to the records' invoice date.

M src/org/openbravo/erpCommon/ad_reports/AgingDao_data.xsql

- Issue History
Date Modified Username Field Change
2020-09-21 11:03 maite New Issue
2020-09-21 11:03 maite Assigned To => Triage Finance
2020-09-21 11:03 maite Modules => Core
2020-09-21 11:03 maite Triggers an Emergency Pack => No
2020-09-21 11:34 dmiguelez Note Added: 0123258
2020-09-21 11:35 dmiguelez Assigned To Triage Finance => inigo_lerga
2020-09-21 13:05 inigo_lerga Status new => scheduled
2020-09-22 09:20 inigo_lerga Note Added: 0123274
2020-09-22 09:21 inigo_lerga Note Edited: 0123274 View Revisions
2020-09-22 09:21 inigo_lerga Note Edited: 0123274 View Revisions
2020-09-22 09:33 hgbot Note Added: 0123275
2020-09-22 11:44 dmiguelez Regression level => Pre packaging ( pi )
2020-09-22 11:44 dmiguelez Regression date => 2020-08-14
2020-09-22 11:44 dmiguelez Regression introduced in release => pi
2020-09-22 11:44 dmiguelez Regression introduced by commit => [^]
2020-09-22 11:44 dmiguelez Note Added: 0123279
2020-09-22 11:48 hgbot Note Added: 0123280
2020-09-22 11:48 hgbot Resolution open => fixed
2020-09-22 11:48 hgbot Status scheduled => closed
2020-09-22 11:48 hgbot Fixed in Version => PR20Q4
2020-09-22 11:48 hgbot Note Added: 0123281
2020-09-22 14:36 inigo_lerga Note Edited: 0123274 View Revisions
2020-09-24 09:03 maite Relationship added caused by 0044788

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker