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

Description

There is a difference in the grouping of insert invoice headers and insert invoice lines during the cash-up process.

Steps To Reproduce

OrderGroupingProcessor_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 [^]

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

closed

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