SAP Knowledge Base Article - Public

2785678 - How Due Date is Determined in the Supplier invoice which is Uploaded via Excel?

Symptom

Document due date is automatically filled in the supplier invoice when the invoice is uploaded via excel.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supplier invoicing work center
  2. Select view Invoices and Credit Memos
  3. Select New
  4. Select Import Via Microsoft Excel
  5. Login to Bydesign system from the excel and enter the mandatory fields
  6. Select Save to to upload the invoice in the system
  7. The document Due Date is automatically filled in the uploaded invoice

Cause

The Due date of the invoice is taken from the Document Date field which is entered in the excel.

Resolution

Please fill this Document Date field correctly so that Due date is correctly filled in the uploaded invoice.

Note: Please ensure Payment Baseline Date column is not filled in the excel which may overwrite document due date .

Keywords

Document date, Due Date, Invoice date, excel upload , KBA , AP-SIP-SIV , Supplier Invoice , Problem

Product

SAP Business ByDesign all versions