Upload Invoices Paid Amounts
From UG
(Difference between revisions)
(→Core Business Need) |
(→Upload Window) |
||
Line 36: | Line 36: | ||
* Controls: | * Controls: | ||
:* Browse button (and "Select XLS file to upload" label) | :* Browse button (and "Select XLS file to upload" label) | ||
- | :* Upload button - provides opening pop-up window for uploading the file of agreed | + | :* Upload button - provides opening pop-up window for uploading the file of agreed [[#Format of Uploaded file|format]] |
:* Cancel button - cancels process of uploading and closes the window. | :* Cancel button - cancels process of uploading and closes the window. | ||
Revision as of 11:44, 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: Acc -> Upload Invoices Paid Amounts
- User's actions - see log, upload/download file, .
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 window.
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
- ...