Upload Invoices Paid Amounts

From UG

Contents 1 Info 2 Glossary 3 Core Business Need 4 Component Description 4.1 Upload Log 4.1.1 Upload Window 4.2 Format of Uploaded file 4.3 Validation 4.4 Misc

Info

• mantis: 0004470: Upload Payment feature

Glossary

• Data2Logistic (D2L) - Jaguar's EDI partner company participated in SI EDI project
• Run - process of handling the CT2 invoices on D2L side

Vendor receives invoices electronically, validates them and then posts them into company's information system
Each run has unique number in D2L system (Run Number)

• Payment information is a D2L report that includes the list of confirmed amounts per CT2 Sales Invoices that were transmitted to D2L for handling.

Core 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.
• Payment data is receiving from D2L as Excel file (see format), keeping in CT2 DB and can be displayed as output of Main Report.

Component Description

• Menu path: Acc -> Upload Invoices Paid Amounts
• User's actions - upload/download Payment information, see log.

Upload Log

• Title: "Upload Invoices Paid Amounts"
• Log Table shows history of uploads and contains of 5 columns:

• Date - date of upload
• File - name of uploaded file
• Upload By - name of person who uploaded the file (name and e-mail).
• Success - number of successfully proceeded payments
• Rejected - number of rejected payments

• Controls

• Upload button - provides opening pop-up window for selecting and uploading the file D2L with payment info
• Close button - closes the current window

Upload Window

• Title: "XLS File Upload"
• Controls:

• Browse button (and "Select XLS file to upload" label)
• Upload button - provides opening pop-up window for uploading the file of agreed format
• Cancel button - cancels process of uploading and closes the current window.

Format of Uploaded file

Each line of the Uploaded file is a payment record and consists of 4 fields:

• Invoice Number
  • Meaning: CT2 number of Sales Invoice transmitted to and reported by D2L
  • Type: Alphanumeric

• Paid Amount
  • Meaning: Amount paid for Invoice
  • Type: Currency

• Run Number
  • Meaning: unique sequence number of handling process event provided by D2L
  • Type: Numeric

• Run Date
  • Meaning: date when event with the "Run Number" occured
  • Type: Date

Validation

• Some payments from the uploaded file can be rejected by CT2:

• if Invoice Number is not found in CT2
• if Invoice was accepted with current Run Number

• Paid Amount is not validated and can be a part of Invoice Amount

Misc

• Once Payment file uploaded the system displays report message that contains two parts:

• list of successfully handled payment records
• list of rejected payments