SAP Knowledge Base Article - Public

3454574 - Error "ID 1 / Item XYZ not valid; amount has invalid number of decimals" when Uploading Bank Statement File

Symptom

You are uploading a bank statement file, for example in format SWIFT MT940. 
An error shows as "ID 1 / Item XYZ not valid; amount has invalid number of decimals".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Liquidity Management work center.
  2. Go to Bank Statements view.
  3. Click New > Bank Statement Upload.
  4. Enter required data for Company, Bank ID and Import Format.
  5. Click Add > File and select the respective file.

The error shows as:
"ID 1 / Item XYZ not valid; amount has invalid number of decimals"
(XYZ representing an affected bank statement transaction)

Cause

This error most likely will occur in bank statement files based on a pertinent MT940 format, for example MT940 UK. 
The number of amount decimals in MT940 is usually is defined as 2 following SWIFT format specifications.
In case the characters following the amount are numeric, these are parsed and interpreted as additional digits, provoking the error. 

For example: 
In MT940 UK The amount follows the date and C/D sign. The amount has 2 decimals and is followed by a 3 digits (letters) representing the External Transaction Code. This is followed by transaction references.

:61:240404C1,25STONONREF 
 
In case numeric content following the amount (2 decimals) is passed this will be interpreted as additional decimals contravening applicable specifications for MT940.

For example:
A transaction line showing as: 

:61:240404C1,251234 

- will be met with an error: "ID 1 / Item XYZ not valid; amount has invalid number of decimals" 

Resolution

Only upload files adhering to pertinent SWIFT specifications for bank statements. 
For example:
https://www.sepaforcorporates.com/swift-for-corporates/account-statement-mt940-file-format-overview/

Keywords

KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign 2402