Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0046711 | Retail Modules | Web POS | public | 2021-05-18 13:44 | 2021-05-31 07:58 |
|
| Reporter | santi_lozano | |
| Assigned To | rqueralta | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR21Q3 | |
| Merge Request Status | approved |
| Review Assigned To | marvintm |
| OBNetwork customer | Gold |
| Support ticket | 23614 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0046711: Incremental refresh not updating business partner multiple price list |
| Description | Set preferences to have multiple price list functionality, set a new value for a product on a price list different of the used one in webpos, assign this price list to a customer, check this customer has a custom price for this product on webpos, set not active this custom price on backoffice, do an incremental refresh on webpos, check on webpos that the price is still custom (when it should have disappeared). This can lead to incorrect prices in webpos. |
| Steps To Reproduce | * Download a tip instance locally and install retail and retail sampledata (I have used a QAA version because I wasn't able to install sampledata on tip and build correctly)
* as System Admin on Windows Tabs and Fields, for window Price List then for tab Product Price allow the field Active to be shown (not shown there by default), compile the application to apply the change (it would be necessary to set core in development in order to do this)
* access as System Admin. Go to window Preference. Set this preferences to be "Web POS Enable Multi Price List" and "Web POS Show Standard Price on Search and Browse" with value = Y, and selected = yes
* access as White Valley Group Admin, go to Price List window, select CTS - Price List, on tab Product Price add a new price of 500 for product Alpine Poles
* go to Business Partner tab, select Arturo Montoro, on its tab change its price list to be CTS - Price List
* go to the webpos
* search for the product Alpine Pole with anonymous customer, it is 36.50
* change customer to be Arturo Montoro, search for the product Alpine Pole its price shows the custom 500
* remove filters there
* go to backoffice, on window Price List, set the Alpine Pole entry that we have just created to be inactive
* on webpos do an incremental refresh, now search for the Alpine Pole product again, it still shows the 500 price, this should have been updated with the refresh |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  23614 - test in qaa - terminal log.csv (50,069) 2021-05-18 13:44
https://issues.openbravo.com/file_download.php?file_id=15758&type=bug
 23614 - multiple price.png (85,025) 2021-05-18 13:45
https://issues.openbravo.com/file_download.php?file_id=15759&type=bug
|
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2021-05-18 13:44 | santi_lozano | New Issue | |
| 2021-05-18 13:44 | santi_lozano | Assigned To | => Retail |
| 2021-05-18 13:44 | santi_lozano | File Added: 23614 - test in qaa - terminal log.csv | |
| 2021-05-18 13:44 | santi_lozano | OBNetwork customer | => Gold |
| 2021-05-18 13:44 | santi_lozano | Support ticket | => 23614 |
| 2021-05-18 13:44 | santi_lozano | Resolution time | => 1623103200 |
| 2021-05-18 13:44 | santi_lozano | Triggers an Emergency Pack | => No |
| 2021-05-18 13:45 | santi_lozano | File Added: 23614 - multiple price.png | |
| 2021-05-24 06:53 | marvintm | Review Assigned To | => marvintm |
| 2021-05-24 06:53 | marvintm | Note Added: 0128528 | |
| 2021-05-24 06:53 | marvintm | Status | new => closed |
| 2021-05-24 06:53 | marvintm | Resolution | open => no change required |
| 2021-05-25 10:56 | santi_lozano | Status | closed => new |
| 2021-05-25 10:57 | santi_lozano | Resolution time | 1623103200 => 1623708000 |
| 2021-05-25 11:03 | santi_lozano | Description Updated | bug_revision_view_page.php?rev_id=22593#r22593 |
| 2021-05-25 11:03 | santi_lozano | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=22595#r22595 |
| 2021-05-25 11:04 | santi_lozano | Note Added: 0128609 | |
| 2021-05-25 22:44 | rqueralta | Assigned To | Retail => rqueralta |
| 2021-05-25 22:44 | rqueralta | Status | new => scheduled |
| 2021-05-27 01:19 | hgbot | Merge Request Status | => open |
| 2021-05-27 01:19 | hgbot | Note Added: 0128689 | |
| 2021-05-31 07:58 | hgbot | Merge Request Status | open => approved |
| 2021-05-31 07:58 | hgbot | Note Added: 0128789 | |
| 2021-05-31 07:58 | hgbot | Resolution | no change required => fixed |
| 2021-05-31 07:58 | hgbot | Status | scheduled => closed |
| 2021-05-31 07:58 | hgbot | Fixed in Version | => RR21Q3 |
| 2021-05-31 07:58 | hgbot | Note Added: 0128790 | |
|
Notes |
|
|
|
Incremental refresh cannot work with masterdata deletions:
http://wiki.openbravo.com/wiki/Retail:MasterdataLoading [^]
"This mode has a specific limitation: it is not able to detect data removals, due to using the updated column to check which records changed. "
The price records should be disabled instead. |
|
|
|
(0128609)
|
|
santi_lozano
|
|
2021-05-25 11:04
|
|
|
I have updated the issue, it also happens when you disable a price record |
|
|
|
(0128689)
|
|
hgbot
|
|
2021-05-27 01:19
|
|
|
|
|
(0128789)
|
|
hgbot
|
|
2021-05-31 07:58
|
|
|
|
|
(0128790)
|
|
hgbot
|
|
2021-05-31 07:58
|
|
|