Upload Invoices Paid Amounts

From UG

Revision as of 11:44, 2 April 2014 (edit) Andrei (Talk | contribs) (→Upload Window) ← Older edit		Revision as of 11:56, 2 April 2014 (edit) (undo) Andrei (Talk | contribs) (→Component Description) Newer edit →
Line 17:		Line 17:
	== Component Description ==		== Component Description ==
-	* Menu: Acc -> Upload Invoices Paid Amounts	+	* Menu path: Acc -> Upload Invoices Paid Amounts
-	* User's actions - see log, upload/download file, .	+	* 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
-	** Length:
	* '''Paid Amount'''		* '''Paid Amount'''
	** Meaning:		** Meaning:
	** Type: Currency		** Type: Currency
-	** Length:
	* '''Run Number'''		* '''Run Number'''
	** Meaning:		** Meaning:
	** Type: Numeric		** Type: Numeric
-	** Length:
	* '''Run Date'''		* '''Run Date'''
	** Meaning:		** Meaning:
	** Type: Date		** Type: Date
-	** Length:
	=== Validation ===		=== Validation ===

---

Revision as of 11:56, 2 April 2014

Contents 1 Info 2 Glossary 3 Core Business Need 4 Component Description 4.1 Upload Log 4.1.1 Upload Window 4.2 Format of Uploaded file 4.3 Validation 4.4 Misc

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

• ...