3
Recommendations:
- Open the downloaded file in Notepad, press Ctrl+F, and replace all
with a space. Save and re‑generate the report. - When regenerating, review expanded rows—missing lines commonly appear in the address column due to CSV conversion.
Data Hygiene Recommendations:
- Avoid using quote marks (“) in vendor/customer name or address master.
- Keep addresses concise and avoid multiple commas.
Validation in UAT
Please refresh UAT from Prod and run:
SQL
select * from LOGISTICSPOSTALADDRESS where address like '%"%'
Kindly share the query output and a sample of the affected file; we’ll validate and advise next steps.
STATUS DETAILS
New
