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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039389
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Cash upmajoralways2018-08-27 13:562018-10-18 13:04
ReporterLeyreView Statuspublic 
Assigned Togorka_gil 
PriorityimmediateResolutionfixedFixed in VersionRR18Q3.2
StatusclosedFix in branchFixed in SCM revisione75343bde0b6
ProjectionnoneETAnoneTarget VersionRR18Q3.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039389: Incorrect grouping by ad_user_id in SQL of insert invoice headers in cash-up process

DescriptionThere is a difference in the grouping of insert invoice headers and insert invoice lines during the cash-up process.
Steps To ReproduceOrderGroupingProcessor_data.xsql:

The SQL of insert invoice header( grouping orders and no grouping orders), it is grouped by ad_user_id, unlike the SQL of insert invoice lines.

It may be caused by https://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4effbcf40012566124172b75b2fc0a9c5ed6a893 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0039191 closedgorka_gil Incorrect grouping by ad_user_id in SQL of insert invoice headers in cash-up process 

-  Notes
(0107334)
hgbot (developer)
2018-10-16 13:53

Repository: retail/backports/3.0RR18Q3.2/org.openbravo.retail.posterminal
Changeset: e75343bde0b61a93e17008b465e5e1ddbe707f5b
Author: Gorka Gil <gorka.gil <at> openbravo.com>
Date: Mon Sep 03 13:29:05 2018 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR18Q3.2/org.openbravo.retail.posterminal/rev/e75343bde0b61a93e17008b465e5e1ddbe707f5b [^]

Fixes issue 39389: fix the grouping for invoices generated in cashup process

Add ad_user_id to the grouping in missing sqls.

Add condition that ad_user of the invoice and the order is the same.

If ad_user null, used coalesce to set to '1', for compare since nulls can not be compared.
Note: Used '1' instead '', because oracle consired '' like a null and con not be compared neither.

---
M src/org/openbravo/retail/posterminal/OrderGroupingProcessor_data.xsql
---

- Issue History
Date Modified Username Field Change
2018-10-02 13:28 marvintm Type defect => backport
2018-10-02 13:28 marvintm Target Version => RR18Q3.2
2018-10-16 13:53 hgbot Checkin
2018-10-16 13:53 hgbot Note Added: 0107334
2018-10-16 13:53 hgbot Status scheduled => resolved
2018-10-16 13:53 hgbot Resolution open => fixed
2018-10-16 13:53 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/6887f3de710760293d267067bc0039daa2669299 [^] => http://code.openbravo.com/retail/backports/3.0RR18Q3.2/org.openbravo.retail.posterminal/rev/e75343bde0b61a93e17008b465e5e1ddbe707f5b [^]
2018-10-18 13:04 marvintm Status resolved => closed
2018-10-18 13:04 marvintm Fixed in Version => RR18Q3.2


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker