Upload Invoices Paid Amounts
From UG
(Difference between revisions)
(→Info) |
|||
| Line 4: | Line 4: | ||
* '''mantis: [http://mantis.jaguarfreight.com/mantis/view.php?id=4470 0004470]:''' Upload Payment feature | * '''mantis: [http://mantis.jaguarfreight.com/mantis/view.php?id=4470 0004470]:''' Upload Payment feature | ||
| - | == | + | == Glossary == |
| + | * Data2Logistic (D2L) - Jaguar's vendor company allowed to pay transmitted CT2 invoices | ||
| + | * Run - process of handling the invoices on D2L side | ||
| + | * Payment information is a list of confirmed amounts per CT2 sales invoices that were transmitted to D2L for paying. | ||
| + | == Core Business Need == | ||
* Ability to upload payment that is received from Data2Logistic with number of columns to upload | * Ability to upload payment that is received from Data2Logistic with number of columns to upload | ||
* This should work similar to [http://wiki.jaguarfreight.com/wiki/ASN_1.X#SKU_to_Planner_Mapping_Feature SKU to planner mapping] upload feature. | * This should work similar to [http://wiki.jaguarfreight.com/wiki/ASN_1.X#SKU_to_Planner_Mapping_Feature SKU to planner mapping] upload feature. | ||
| + | * Payment data is receiving from D2L as Excel file (see [[#Format of Uploaded file|format]]), keeping in CT2 DB and can be showed as output of [http://wiki.jaguarfreight.com/wiki/Main_Report Main Report]. | ||
== Component Description == | == 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 === | + | ==== Upload Window ==== |
| - | + | * Title: "XLS File Upload" | |
| - | * | + | * Controls: |
| - | * Controls | + | :* Browse button (and "Select XLS file to upload" label) |
| - | * | + | :* 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. | ||
=== Format of Uploaded file === | === Format of Uploaded file === | ||
Revision as of 17:34, 31 March 2014
Contents |
Info
- mantis: 0004470: Upload Payment feature
Glossary
- Data2Logistic (D2L) - Jaguar's vendor company allowed to pay transmitted CT2 invoices
- Run - process of handling the invoices on D2L side
- Payment information is a list of confirmed amounts per CT2 sales invoices that were transmitted to D2L for paying.
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 showed 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
- ...
