3700366 - The data in the Thailand VAT Return - PP30 (Input/Output tax report) has been split into two columns - SAP S/4HANA Cloud Public Edition

In the Excel, some line items within the Thailand PP30 Input/Output Tax Report are split into two columns, which is inconvenient for customers.

SAP S/4HANA Cloud Public Edition

1. Generate the Thailand PP30 Report in the Run Statutory Reports app.
2. Download and open the Input/Output Tax Report file using Microsoft Excel.
3. Observe that some line items are split into two columns due to the presence of commas in company names.

The format of the report is CSV, and it is opened in Microsoft Excel. The default delimiter used by Excel to split columns is the comma. In the report, some company names contain commas, which causes these line items to be split into two columns.

1. Open the CSV file using Notepad.
2. Alternatively, select the "Equals Sign" as delimiter when loading the CSV file in Microsoft Excel.

Thailand VAT PP30 report, Thailand localization, excel delimiter, Input/Output tax report , KBA , FI-LOC-FI-TH , Thailand , Problem