Symptom
When you upload clearing house statement file, errors occur: Payment reference not provided; Bank statement format code XXX is not valid.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Liquidity Management work center.
- Go to Inbound Files view.
- Click New - Inbound File.
- Enter the required information such as company.
- Upload the clearing house statement attachment and click 'Start File Upload'.
- You can see errors: Payment reference not provided; Bank statement format code XXX is not valid.
Cause
Payment transaction reference in the clearing house statement file has errors.
Resolution
You first need to check whether the total payment reference IDs in the clearing house statement file itself is consistent. You can find the total payment reference IDs in the Tag:<ItemTotalNumberValue>.
You also need to check whether the payment reference IDs in the clearing house statement file are available in the system:
-
Go to Payment Management work center.
-
Go to Payment Monitor view.
- Search the payment reference ID in the clearing house statement file.
Keywords
clearing house statement, payment reference not provided, bank statement format code XXX is not valid , KBA , SRD-FIN-MOP , Payment Management , Problem