0043023: The loadBPLocations function of BusinessPartner model is not retrieving the last created/used BPLocation

Description

The loadBPLocations is shorting the results using the c_bpartner_location_id. This orderby clause is not ensuring that the result will the last created/used location.

This problem is easy to see when we have the preference 'Enable Remote for Customer' = Y

Steps To Reproduce

1.- Config in back-end the preference 'Enable Remote for Customer' = Y
2.- Log into the WebPOS
3.- Create a customer with 5 addresses
4.- Search the customer and select it.

EXPECTED RESULT:
You can see that is not mandatory have the latest created/used address assigned to the ticket.

Proposed Solution

Change the orderby clause of:

loadBPLocations: function (shipping, billing, callback, bpId) {

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

causes

defect

0043838

closed

ranjith_qualiantech_com

Business Partner location masterdata load is failing in WebPOS with a large amount of records

Notes
(0117342) hgbot (developer) 2020-01-30 08:39	Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: c8581f1f793bc6812092f8d302693a332453a9db Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Thu Jan 30 13:09:30 2020 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c8581f1f793bc6812092f8d302693a332453a9db [^] Fixed issue 43023 : Customer Location should be listed by last creationDate --- M src/org/openbravo/retail/posterminal/master/BPLocation.java M src/org/openbravo/retail/posterminal/master/BPLocationProperties.java M web/org.openbravo.retail.posterminal/js/model/bplocation.js M web/org.openbravo.retail.posterminal/js/model/businesspartner.js ---

Issue History
Date Modified	Username	Field	Change
2020-01-28 11:08	kchoperena	New Issue
2020-01-28 11:08	kchoperena	Assigned To	=> Retail
2020-01-28 11:08	kchoperena	Resolution time	=> 1581375600
2020-01-28 11:08	kchoperena	Triggers an Emergency Pack	=> No
2020-01-29 07:35	ranjith_qualiantech_com	Assigned To	Retail => ranjith_qualiantech_com
2020-01-29 10:56	ranjith_qualiantech_com	Status	new => scheduled
2020-01-30 08:39	hgbot	Checkin
2020-01-30 08:39	hgbot	Note Added: 0117342
2020-01-30 08:39	hgbot	Status	scheduled => resolved
2020-01-30 08:39	hgbot	Resolution	open => fixed
2020-01-30 08:39	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c8581f1f793bc6812092f8d302693a332453a9db [^]
2020-01-31 11:37	guilleaer	Review Assigned To	=> guilleaer
2020-01-31 11:37	guilleaer	Status	resolved => closed
2020-01-31 11:37	guilleaer	Fixed in Version	=> RR20Q2
2020-04-24 20:41	dmitry_mezentsev	Relationship added	causes 0043838