Acc Reports P and L

From UG

(Difference between revisions)
Jump to: navigation, search
(Profit/Loss for Multiple CTs)
(Profit/Loss for Multiple CTs)
Line 48: Line 48:
=== Filers ===
=== Filers ===
 +
* Date Type: Radio button for Saling Date and Issuing Date
 +
** Saling Date = origin port(oP)
 +
** Issuing Date = ???
 +
** Default > Saling Date
 +
* Date: Radio button for Month and Year and Date Range
 +
** Month and Year: Drop down for Month(Jan-Dec) and Year(2008 - ...)
 +
** Date Range: from/to date calendar
 +
** Default > Month and Year
 +
* Profit/Loss: Radio button for Amount Range and Percentage Range
 +
** Amount Range: text box for from and to (with 2 decimal places)
 +
** Percentage Range????
 +
** Default > Amount Range
 +
* Output Type: Radio button for Summary and Detailed ???
 +
** Default > summary
 +
* Consignees: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
 +
* Client Companies: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
 +
* Bill To Party Companies: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
 +
* Vendors: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
 +
* Transport Modes: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
 +
* Regions From: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
 +
* Region To: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
-
* Saling Date = origin port(oP)
+
 
 +
=== Button ===
 +
* Go back > go back to a previous page
 +
* Reset Form > clear all filters except radio buttons default ???
 +
* Generate Result > report result
 +
** Go back?
 +
** Download to Excel?
 +
 
 +
=== Output ===
 +
* Summary
 +
* Detaile
 +
 
 +
=== Report ===
 +
* HTML
 +
* Excel report
 +
 
 +
*

Revision as of 02:40, 3 September 2009


Contents

Biz requirement

It allows user to generate P/L report for individual CT or Master or multiple CTs

Notes:

  • Types of P&L reports:
    • P/L Tab on CT profile
    • P/L Tab on Master profile
    • Acc > Reports > Profit/Loss by CT #
    • Acc > Reports > Profit/Loss for Multiple CTs

Profit/Loss on CT profile

Profit/Loss on Master profile

Profit/Loss by CT#

  • It allows user to generate P/L report by CT#
  • Only one filter > CT#: text box
  • Buttons
    • Go back > go back to the previous page
    • Reset Form > clear info in text box for CT#
    • Generate Result > generate report

Report

  • HTML
    • Report for a specific CT# with 4 sections
      • Sales Invoices
        • Issuing office, Bill to Party company, Invoice#, CT#, Date, Currency, Amount, USD amount and Total
      • Purchase Invoices
        • Receiving office, Vendor, Invoice#, CT#, Date, Currency, Amount, USA amount, and Total
      • Internal Invoices
        • Issuing office, Receiving office, Invoice#, CT#, Date, Currency, Amount, USA amount, and Total
      • Profit/Loss Amount
        • Office, Sales, Purchase, Internal from, Internal to, Profit/Loss, and Total
    • Invoice links
  • Download to Excel button
    • Excel report (same as HTML) with Invoice link

Profit/Loss for Multiple CTs

  • It allows user to generate P/L report for multiple CTs

Filers

  • Date Type: Radio button for Saling Date and Issuing Date
    • Saling Date = origin port(oP)
    • Issuing Date = ???
    • Default > Saling Date
  • Date: Radio button for Month and Year and Date Range
    • Month and Year: Drop down for Month(Jan-Dec) and Year(2008 - ...)
    • Date Range: from/to date calendar
    • Default > Month and Year
  • Profit/Loss: Radio button for Amount Range and Percentage Range
    • Amount Range: text box for from and to (with 2 decimal places)
    • Percentage Range????
    • Default > Amount Range
  • Output Type: Radio button for Summary and Detailed ???
    • Default > summary
  • Consignees: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
  • Client Companies: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
  • Bill To Party Companies: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
  • Vendors: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
  • Transport Modes: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
  • Regions From: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box
  • Region To: Dropdown list on the left and list box on the right with >> and << symbol to add and remove list from filter or list box


Button

  • Go back > go back to a previous page
  • Reset Form > clear all filters except radio buttons default ???
  • Generate Result > report result
    • Go back?
    • Download to Excel?

Output

  • Summary
  • Detaile

Report

  • HTML
  • Excel report
Personal tools