Symptom
You are uploading Supplier Invoices via the SAP Collaboration Window using TXT and PDF files for each Supplier Invoice.
The upload is successful and you can find the uploaded Supplier Invoices in the Invoices and Credit Memos view of the Supplier Invoicing work center.
However, in the uploaded Supplier Invoices the Invoice Date is not the same as in the original TXT file. Another date found in the TXT and PDF files, for example the Due On date, has been assigned as Invoice Date in the uploaded Supplier Invoices.
Environment
SAP Business ByDesign all systems.
Reproducing the Issue
- Go to Supplier Invoicing work center.
- Select the Invoices and Credit Memos view.
- Show All Documents and search for ABC (ABC represents the relevant Supplier Invoice ID).
- Click Edit.
- Click View All.
In the General tab, you can see that the Invoice Date is not the same as in the TXT file used for the upload. Instead another date found in these files, for example the Due On date, has been assigned as the Invoice Date.
Cause
In the Supplier Invoice upload via SAP Collaboration Window, the system only uses the TXT file to verify the Invoice Date and no keywords are used in this verification. Instead the system checks for various date formats, for example dd.mm.yyyy or dd.mm.yy, in the TXT file.
If the Invoice Date has several formats in the TXT file, and another date has only one consistent format, then the date with the consistent format will be picked as the Invoice Date for the uploaded Supplier Invoices.
Resolution
Please make sure that in the TXT file that you use for the upload, the Invoice Date has one consistent date format if it appears more than once.
Keywords
SAP, Collaboration, Window, Supplier, Invoice, Upload, Invoice, Date, Wrong, Not, Correct, Same, TXT, PDF, File , KBA , AP-SIP-SIV , Supplier Invoice , Problem