Upload Invoices Paid Amounts
From UG
(Difference between revisions)
(→Format of Uploaded file) |
|||
| (16 intermediate revisions not shown) | |||
| Line 3: | Line 3: | ||
== Info == | == Info == | ||
* '''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 | ||
| + | * '''related mantis: [http://mantis.jaguarfreight.com/mantis/view.php?id=4471 0004471]:''' Add "Uploaded payment info" to Main report output | ||
== Glossary == | == Glossary == | ||
| - | * Data2Logistic (D2L) - Jaguar's | + | * Data2Logistic ('''D2L''') - Jaguar's EDI partner company participated in [http://wiki.jaguarfreight.com/wiki/SI_EDI SI EDI project] |
| - | * Run - process of handling the invoices on D2L side | + | * '''Run''' - process of handling the CT2 invoices on D2L side |
| - | * Payment information is a list of confirmed amounts per CT2 | + | 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 == | == 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 | + | * Payment data is receiving from D2L as Excel file (see [[#Format of Uploaded file|format]]), keeping in CT2 DB and can be displayed as output of [http://wiki.jaguarfreight.com/wiki/Main_Report Main Report]. |
== 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 === | ||
* Title: "Upload Invoices Paid Amounts" | * Title: "Upload Invoices Paid Amounts" | ||
| - | * Log Table shows history of uploads and | + | * Log Table shows history of uploads and consists of 5 columns: |
:* Date - date of upload | :* Date - date of upload | ||
:* File - name of uploaded file | :* File - name of uploaded file | ||
| Line 34: | Line 37: | ||
* 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 current window. |
=== Format of Uploaded file === | === Format of Uploaded file === | ||
| + | |||
| + | Each line of the Uploaded file is a payment record and includes 4 fields: | ||
* '''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: Amount paid for Invoice |
** Type: Currency | ** Type: Currency | ||
| - | |||
* '''Run Number''' | * '''Run Number''' | ||
| - | ** Meaning: | + | ** Meaning: unique sequence number of handling process event provided by D2L |
** Type: Numeric | ** Type: Numeric | ||
| - | |||
* '''Run Date''' | * '''Run Date''' | ||
| - | ** Meaning: | + | ** Meaning: date when event with the "Run Number" occured |
** Type: Date | ** Type: Date | ||
| - | |||
=== Validation === | === 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 === | === Misc === | ||
| - | * | + | * Once Payment file uploaded the system displays report message that contains two parts: |
| + | :* list of successfully handled payment records | ||
| + | :* list of rejected payments | ||
Current revision as of 11:19, 4 April 2014
Contents |
[edit] Info
- mantis: 0004470: Upload Payment feature
- related mantis: 0004471: Add "Uploaded payment info" to Main report output
[edit] 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.
[edit] 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.
[edit] Component Description
- Menu path: Acc -> Upload Invoices Paid Amounts
- User's actions - upload/download Payment information, see log.
[edit] Upload Log
- Title: "Upload Invoices Paid Amounts"
- Log Table shows history of uploads and consists 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
[edit] 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.
[edit] Format of Uploaded file
Each line of the Uploaded file is a payment record and includes 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
[edit] 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
[edit] Misc
- Once Payment file uploaded the system displays report message that contains two parts:
- list of successfully handled payment records
- list of rejected payments
