Symptom
You are trying to upload a bank statement Inbound file for the import format MT 940 DE. The upload terminates with an exception and an error message:
'Statement AAA Already Posted or Already Uploaded And Ready For Manual Posting'
AAA means the Bank Statement ID.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Go to the File Management view and select the Inbound Files subview.
- Click New and select Inbound File.
- Under Attachments click Add and select File.
- Add the file and click Start File Upload.
Cause
Tag 28C indicates Statement Number/Sequence Number.
For example:
00009/001
Tag 28C can be repeated multiple times in the file, but if your previous upload of the file has exactly the same details used and upload is already through, then your current file will be inconsistent and system will not allow any duplicate/uploading of the same file data twice.
Resolution
When several messages are sent to convey information about a single statement, the first message must contain 001 in Sequence Number. The sequence number must be incremented by one for each additional message of Tag 28C.
If in the same file Tag 28C shows 00007/001, 00008/001 indicates that this file includes data of another bank statement which may have already posted. You need to request the latest bank file from your bank and try importing of the statement again.
Keywords
bank statement; MT940; 28C; bank statement upload; file upload , KBA , bank statement , 28c , bank statement upload , mt940 , file upload , AP-PAY-BS , Bank Statement , How To