Upload Invoices Paid Amounts

From UG

Contents 1 Info 2 Business Need 3 Component Description 3.1 Upload Window 3.2 Format of Uploaded file 3.3 Validation 3.4 Misc

Info

• mantis: 0004470: Upload Payment feature

Business Need

• Ability to upload payment that is received from Data2Logistic with number of columns to upload
• This should work similar to SKU to planner mapping upload feature.

Component Description

• Payment information is a list of confirmed amounts per CT2 sales invoices that were transmitted to D2L for paying.
• Payment data is receiving from D2L every <...>, keeping in CT2 DB and can be showed as output of Main Report.
• User's actions.

Upload Window

• Table
• Controls
• Functionality

Format of Uploaded file

• Invoice Number
  • Meaning:
  • Type: Alphanumeric
  • Length:

• Paid Amount
  • Meaning:
  • Type: Currency
  • Length:

• Run Number
  • Meaning:
  • Type: Numeric
  • Length:

• Run Date
  • Meaning:
  • Type: Date
  • Length:

Validation

• ...

Misc

• ...