-
Type: Testing Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: No Longer Required
-
Affects Version/s: CFA 2019R2, CFA 2020R2
-
Fix Version/s: None
-
Component/s: CollectedSales
-
Labels:
-
Root cause - Reason:Bad data
Scenario - 00663 in testing/ April 9
This store has multiple records in the CustomerInformation table with trailing and leading spaces.
When a customer that has a leading space or a trailing space is used (# of leading or trailing is irrelevant) for a Collected Sale on the POS
AND when that customer is selected from the Unapplied view in MXC
And Apply to Invoice is clicked
And the Select Customer modal is displayed
Defect - the customer is not displayed by default as it should - as in this case with Roper Mt.Science Center which has leading spaces.
These queries were used to determine the lead and trailing spaces by store EntityID. In this case I am working with 00663 / Entity ID 386 in testing.
SELECT entityID,CustomerName --trailing spaces
FROM CustomerInformation where CustomerName not like RTRIM(CustomerName)
and entityId ='386'
entityID CustomerName
386 Aldersgate Child Developement
386 Sealed Air
386 Mt Lebenon Elem
386 Shannon Brame Jour. HospMoo86
386 Janice Grant--Duke
386 Becky Hyatt Pelham LinksMOO26
386 PMP Swimteam
SELECT entityID,CustomerName --leading & trailing spaces both
FROM CustomerInformation where CustomerName not like LTRIM(CustomerName) and CustomerName not like RTRIM(CustomerName)
--and entityId ='386'
**NONE**
SELECT entityID,CustomerName --leading spaces
FROM CustomerInformation where CustomerName not like LTRIM(CustomerName)
and entityId ='386'
386 Carolina Center for BSMOO 45
386 Roper Mt. Science Cent
- relates to
-
CFAMX-5958 CM - Collected Sales - MxC - Re-write & redesign the Collected Sales Page in MXC
- Closed