SAP Knowledge Base Article - Public

2608899 - The Invoice Date in Supplier Invoices Uploaded via SAP Collaboration Window is Wrong

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

  1. Go to Supplier Invoicing work center.
  2. Select the Invoices and Credit Memos view.
  3. Show All Documents and search for ABC (ABC represents the relevant Supplier Invoice ID).
  4. Click Edit.
  5. 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

Product

SAP Business ByDesign all versions