Upload Invoices Paid Amounts

From UG

(Difference between revisions)
Jump to: navigation, search
(Glossary)
(Glossary)
Line 9: Line 9:
  Vendor receives invoices electronically, validates them and then posts them into company's information system
  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''')
  Each run has unique number in D2L system ('''Run Number''')
-
* '''Payment information''' is a D2L report that included the list of confirmed amounts per CT2 Sales Invoices that were transmitted to D2L for handling.
+
* '''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 ==
== Core Business Need ==

Revision as of 12:01, 2 April 2014


Contents

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

  • Invoice Number
    • Meaning: CT2 number of Sales Invoice transmitted to and reported by D2L
    • Type: Alphanumeric
  • Paid Amount
    • Meaning:
    • Type: Currency
  • Run Number
    • Meaning:
    • Type: Numeric
  • Run Date
    • Meaning:
    • Type: Date

Validation

  • ...

Misc

  • ...
Personal tools