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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0039390
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Cash upmajoralways2018-08-27 13:562018-10-18 13:04
ReporterLeyreView Statuspublic 
Assigned Togorka_gil 
PriorityimmediateResolutionfixedFixed in VersionRR18Q2.4
StatusclosedFix in branchFixed in SCM revision49068666f0d0
ProjectionnoneETAnoneTarget VersionRR18Q2.4
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

0039390: 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
(0107335)
gorka_gil (administrator)
2018-10-16 13:56

 Repository: retail/backports/3.0RR18Q2.4/org.openbravo.retail.posterminal
Changeset: 49068666f0d01cddefc97e52047e41f1cc461920
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.0RR18Q2.4/org.openbravo.retail.posterminal/rev/49068666f0d01cddefc97e52047e41f1cc461920 [^]

Fixes issue 39190 : 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 => RR18Q2.4
2018-10-16 13:56 gorka_gil Note Added: 0107335
2018-10-16 13:59 gorka_gil Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/6887f3de710760293d267067bc0039daa2669299 [^] => https://code.openbravo.com/retail/backports/3.0RR18Q2.4/org.openbravo.retail.posterminal/rev/49068666f0d01cddefc97e52047e41f1cc461920 [^]
2018-10-16 14:00 gorka_gil Status scheduled => resolved
2018-10-16 14:00 gorka_gil Resolution open => fixed
2018-10-18 13:04 marvintm Status resolved => closed
2018-10-18 13:04 marvintm Fixed in Version => RR18Q2.4

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker