Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039389Retail ModulesCash uppublic2018-08-27 13:562018-10-18 13:04
ReporterLeyre 
Assigned Togorka_gil 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR18Q3.2Fixed in VersionRR18Q3.2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039389: 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 [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0039191 closed gorka_gil Incorrect grouping by ad_user_id in SQL of insert invoice headers in cash-up process 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-10-02 13:28marvintmTypedefect => backport
2018-10-02 13:28marvintmTarget Version => RR18Q3.2
2018-10-16 13:53hgbotCheckin
2018-10-16 13:53hgbotNote Added: 0107334
2018-10-16 13:53hgbotStatusscheduled => resolved
2018-10-16 13:53hgbotResolutionopen => fixed
2018-10-16 13:53hgbotFixed in SCM revisionhttp://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:04marvintmStatusresolved => closed
2018-10-18 13:04marvintmFixed in Version => RR18Q3.2

Notes
(0107334)
hgbot   
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
---