3435426 - Manage Bank Statement App - The external transaction code is not copied to the field when importing the BS items using template.

In Manage Bank Statements, the external transaction code is not copied to the field when the bank statement items are uploaded through the template.

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP S/4HANA Cloud 

1. Click on "Generate Template".
2. Fill the information into the generated template.
3. Save the template excel with your data on your system.
4. Click on "Import".
5. You will now see a warning dialog, that all data already entered will be deleted, you click on "Yes".
6. Now click on "Upload" (or drag the file from your system).
7. Select the file and click on "Ok/Open" (drop the file into the dialog).

The code fix will be done in a CFD, and the changes will reach customer system by 13th April. Meanwhile, please make use of the straightforward functionality by using the modern excel integration which requires less steps for you, once you have set up your variant in Manage Bank Statements app. 

Note:

• You will be receiving an excel from the bank (or from other sources), but it is important that you copy the values to the excel provided by SAP from the excel provided by the bank. You can download the excel provided by SAP by using Generate Template option in the app Manage Bank Statements.
• There is no need to add the column for currency (Amount Currency and Payment Currency) in the UI, but it is mandatory to have the column in the excel.

Creation of a variant:(This is a one-time-activity)

1. Click on the settings wheel icon.
   
2. Deselect the fields that are not relevant for you (Our recommendation is to hide those fields that you do not want to manually fill, for instance the Line Item number is filled by the system anyway).
   
   
3. Select the fields that are relevant for your business and needs to be updated from the excel. For eg: External Transaction, Profit Center). There is no need to add the column for currency in the UI, but it is important to have the column in the excel.
   
   
   
4. Re-arrange their position on the UI. The sequence of how you order them is important and has to be aligned with the sequence of your excel file. Make sure "Is Completed" and "Possible Action" are at the end of the list or you can deselect it.
   
   
   
5. Click on “OK” and double check if the sequence on the UI is aligned to your excel.
6. Now create your variant, so that these columns are always ordered like that.
   
   * Click on "Standard" next to Bank Statement Items section. Click on "Save As".
   
   * Provide a view name. You can set this as your default variant, so it appears whenever you enter this app.
   
   

Copying data from the excel file.

1. Download the excel by clicking on the Generate Template option in Manage Bank Statements app.
   
   
2. Enter the values to the columns in the excel sheet. You can copy the values to this excel from the excel sheet you received from your bank.
   
   
3. Ensure that the columns in the excel sheet is aligned with the one in the UI in Manage Bank Statements. For eg: In the above variant, I have added external transaction and profit center. The order of the columns in the excel sheet should match the same as in the UI.
   
   
4. Copy the rows (Select and Ctrl+C (For Windows), Select and Command + C (For Mac)).
   
   
5. Paste (Select and Ctrl+V (For Windows), Select and Command+V (For Mac)) it to the table, by simply clicking on the area around “Bank Statement Items”.
   
   
6. The values are copied to the fields.
   
   

Manage Bank Statements, Generate Template, Manual Upload, Excel, Spreadsheet, External transaction code, PAYMENTEXTERNALTRANSACTYPE, 2402, regression, S4_PC, S4_1C , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , Problem