Upload Invoices Paid Amounts

From UG

(Difference between revisions)
Jump to: navigation, search
(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 - 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

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

  • ...
Personal tools