Upload Invoices Paid Amounts
From UG
(Difference between revisions)
(→Upload Window) |
(→Component Description) |
||
Line 17: | Line 17: | ||
== Component Description == | == Component Description == | ||
- | * Menu: Acc -> Upload Invoices Paid Amounts | + | * Menu path: Acc -> Upload Invoices Paid Amounts |
- | * User's actions - | + | * User's actions - [[#Upload Window|upload/download]] Payment information, see [[#Upload Log|log]]. |
=== Upload Log === | === Upload Log === | ||
Line 42: | Line 42: | ||
* '''Invoice Number''' | * '''Invoice Number''' | ||
- | ** Meaning: | + | ** Meaning: CT2 number of Sales Invoice transmitted to and reported by D2L |
** Type: Alphanumeric | ** Type: Alphanumeric | ||
- | |||
* '''Paid Amount''' | * '''Paid Amount''' | ||
** Meaning: | ** Meaning: | ||
** Type: Currency | ** Type: Currency | ||
- | |||
* '''Run Number''' | * '''Run Number''' | ||
** Meaning: | ** Meaning: | ||
** Type: Numeric | ** Type: Numeric | ||
- | |||
* '''Run Date''' | * '''Run Date''' | ||
** Meaning: | ** Meaning: | ||
** Type: Date | ** Type: Date | ||
- | |||
=== Validation === | === Validation === |
Revision as of 11:56, 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 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 included 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
- ...