Search Invoices Report

From UG

Contents 1 Info 1.1 Mantis 1.2 Scope 2 Biz requirement 3 Filters 4 Button 5 Output 6 With download to xls 7 History 7.1 Tweak V.1.a 7.1.1 Figure 1. 7.2 0002960 [Acc 2011] (Acc Report:Search Inv) Add feature to run this report showing VAT charges separately

Info

Mantis

• http://ct.jaguarfreight.com/mantis/view.php?id=1942

Scope

This covers this one report: "Search Invoices".

Biz requirement

Search Invoice is used for search invoices report for Purchase, Sales, or Internal Invoices by applying filters

Filters

• Invoice Type > radio button
  • Purchase Invoices
  • Sales Invoices
  • Internal Invoices
• Receiving Office > dropdown (office lists and All option) > for Purchase or Internal Invoices radio button selected
• Issuing Office > dropdown (office lists and All option) > for Sales or Internal Invoices radio button selected
• Vendor > dropdown list (vendor)> for Purchase Invoices radio selected
• Bill To Party company > dropdown list > for Sales Invoices radio selected
• Invoice # contains> text box
• Date > from/to date calendar
• Amount > from/to number fields

Button

• Go back > go back to the previous page
• Reset Form > clear all filter
• Generate Result > HTML result(s) with CT#links and paging
  • Go back > go back to the previous page
  • Edit > edit record by selecting record that need to be edited
  • Remove > remove record by selecting record that need to be removed
  • Download to Excel > Excel report with CT# links

Output

• 8 columns for Purchase Invoices:
  • Receiving office
  • Vendor
  • Invoice# with links
  • Date
  • CT/M#s
  • Currency
  • Amount
  • Status > show X with description for incomplete invoices
• 7 columns for Sales Invoices:
  • Issuing office
  • Bill To Party Company
  • Invoice# with links
  • Date
  • CT/M#s
  • Currency
  • Amount
• 7 columns for Internal Invoices:
  • Issuing office
  • Receiving office
  • Invoice# with links
  • Date
  • CT/M#s
  • Currency
  • Amount
• Button
  • Go back
  • Edit
  • Remove
  • Download to Excel
• With paging and sorting for all reports.

With download to xls

• Excel format

Same as HTML (ZUL)

History

Tweak V.1.a

tw1) Add radio button for Credit Note Invoices to the forth choice of Invoice Type filter

Steps

• If user selects Credit Note Invoices radio button
• Filter dynamic changes"
  • Issuing Office > dropdown (office lists and All option) > Credit Note Invoices Invoices radio button selected
  • Bill To Party company > dropdown list > for Credit Note Invoices radio selected
  • Date > from/to date calendar
  • Amount > from/to number fields
• User set filters and clicks "generate result" button
• See result

tw2) HTML report 8 columns for Credit Note Invoices:

• Issuing office
• Bill To Party Company
• Credit Note# with links
• Issued by
• Date
• CT/M#s with links
• Currency
• Amount

tw3) Buttons on the HTML result page

• Go back
• Download to Excel

tw4) With paging and sorting for all reports.

tw5) Result shows for both approved and unapproved(pending) credit notes.

• Credit Note Invoice consists of credit notes that issued against sale invoice and internal invoice; Result will show by category of type of invoice separating by tabs. See figure 1 below.
  • External Invoices
  • Internal Invoices
• Each type of credit note invoice shows how many record on the tab.
• When a tab is open, it should show 20 records per page.

Note: One tab is open at a time.

tw6)Make hyperlink for CT/M#s for purchase, sale, Internal and Credit Note invoices on HTML report and EXCEL report

NOTE: Tw1)-tw6) are updated by Tira 3:30 PM 17 Jan 2010

Figure 1.

0002960 [Acc 2011] (Acc Report:Search Inv) Add feature to run this report showing VAT charges separately

WU? No