Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044788Openbravo ERP09. Financial managementpublic2020-08-12 08:282020-08-14 12:01
Reportermaite 
Assigned Toinigo_lerga 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR20Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Web browser
ModulesCore
Support ticket17468
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0044788: Wrong information in Credits section of Aging Report: the date when a prepaid order was invoiced needs to be considered
DescriptionAt the moment, as soon as a prepaid order is invoiced it will never be shown as Credit independently of the report's date. This is not correct as in case the report is executed in a date when the order was not invoiced yet it should show as Credit information
Steps To Reproduce1. Create Sales Order for any Org and BP. Set date 10/08/2020. Add any line and Book the order
2. Run Add Payment process and prepay the order
3. Run Receivables Aging Schedule report for this BP and date 11/08/2020. Realize that the order appears in Credit section
4. Register Sales Invoice for same Org and BP. Set date 12/08/2020. Run Create Lines from and select previous order. Book the invoice
5. Run Receivables Aging Schedule report for this BP and date 11/08/2020. Realize that the order DO NOT appears in Credit section, what is wrong
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0045097 closed inigo_lerga Payment wrongly shown as Credit, as it is also associated to the invoice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-08-12 08:28maiteNew Issue
2020-08-12 08:28maiteAssigned To => Triage Finance
2020-08-12 08:28maiteOBNetwork customer => Gold
2020-08-12 08:28maiteModules => Core
2020-08-12 08:28maiteSupport ticket => 17468
2020-08-12 08:28maiteResolution time => 1598997600
2020-08-12 08:28maiteTriggers an Emergency Pack => No
2020-08-12 08:29maiteIssue Monitored: networkb
2020-08-12 10:56ngarciaIssue Monitored: ngarcia
2020-08-12 14:09dmiguelezAssigned ToTriage Finance => inigo_lerga
2020-08-13 09:38inigo_lergaStatusnew => scheduled
2020-08-13 14:27inigo_lergaNote Added: 0122029
2020-08-14 09:48hgbotMerge Request Status => open
2020-08-14 09:48hgbotNote Added: 0122048
2020-08-14 12:01hgbotMerge Request Statusopen => approved
2020-08-14 12:01hgbotResolutionopen => fixed
2020-08-14 12:01hgbotStatusscheduled => closed
2020-08-14 12:01hgbotFixed in Version => PR20Q4
2020-08-14 12:01hgbotNote Added: 0122066
2020-08-14 12:01hgbotNote Added: 0122067
2020-09-24 09:03maiteRelationship addedcauses 0045097

Notes
(0122029)
inigo_lerga   
2020-08-13 14:27   
--Test Plan Mantis HQL--

As the F&B International Group Admin role in Backend:
- Go to Sales Order window and create a new record with 'Alimentos y Supermercados, S.A'
  as Business Partner.
  Set the Invoice Terms to Inmediate.
  Go to Lines Tab and create a new line with any product and quantity desired.
  Save and Book the record.
  Press the Add payment button and Done button in the popup window.

- Go to Sales Invoice window and create a new record with 'Alimentos y Supermercados, S.A'
  as Business Partner.
  Set as Invoice Date the date two days from now (Today + 2 days)
  Press the Create Lines From Order button and select the ones from the previous
  Sales Order.
  Save and Complete the Sales Invoice.

- Go to Receivables Aging Schedule window and set tomorrow (Today + 1 day)
  as the As Of Date field.
  Press the View button.

#Now this workflow is successfully executed"
(0122048)
hgbot   
2020-08-14 09:48   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/120 [^]
(0122066)
hgbot   
2020-08-14 12:01   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: b6f4205fb4260501abd5493116377646ffad38b2
Author: inigo_lerga <inigo.lerga@openbravo.com>
Date: 2020-08-14T10:01:42+00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/b6f4205fb4260501abd5493116377646ffad38b2 [^]

fixes BUG-44788:Date of prepaid order invoice considered now

The date in which an invoice of a prepaid order is now
considered in que query, being properly shown as Credit
independtly of the report's date.

---
M src/org/openbravo/erpCommon/ad_reports/AgingDao_data.xsql
---
(0122067)
hgbot   
2020-08-14 12:01   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/120 [^]