Missing Vendor Invoices

From UG

(Difference between revisions)
Jump to: navigation, search
(Columns)
(Spec)
Line 13: Line 13:
=== Intro ===
=== Intro ===
-
'''Vendor:'''
+
'''Vendor''': Company that issued invoice as defined in ''Admin > Address Book > Vendors''
-
: Company that issued invoice as defined in ''Admin > Address Book > Vendors''
+
 
 +
=== Business requirements ===
 +
* Report that shows CT's for which a vendor is listed in the shipment<br/>and
 +
* for which NO purchase invoice is listed in the P&L tab
=== Conditions ===
=== Conditions ===
Line 27: Line 30:
=== Output settings ===
=== Output settings ===
-
* Results of the report are displayed as table in HTML form with ability to download it to XLS spreadsheet.
+
* Results of the report are displayed as HTML table which can be downloaded as XLS spreadsheet.
* Spreadsheet version of this report has all the columns found on HTML.
* Spreadsheet version of this report has all the columns found on HTML.

Revision as of 11:51, 13 May 2014


Contents

Info

Scope:

This covers this one report: "Missing Vendor Invoices".

Spec

Intro

Vendor: Company that issued invoice as defined in Admin > Address Book > Vendors

Business requirements

  • Report that shows CT's for which a vendor is listed in the shipment
    and
  • for which NO purchase invoice is listed in the P&L tab

Conditions

There are no Hard coded or Hidden conditions (???) for this report which means that system will pull ALL invoices that satisfy conditions you set by filters.

Filters

  • Office
  • Time frame

Output settings

  • Results of the report are displayed as HTML table which can be downloaded as XLS spreadsheet.
  • Spreadsheet version of this report has all the columns found on HTML.

Columns

* Column Title - Column description/mapping

  • CT #
  • Client Name
  • Mode
  • Origin Country
  • Destination Country
  • Vendor (or Carrier)

Examples

File:HTML example.PNG
File:Spreadsheet example.PNG

SOWs

SOW 1


mantis: ???? (phase: ??, status: ??)

Core Requirements

  • .

Solution

TBD



Personal tools