Acc Reports P and L
From UG
(Difference between revisions)
(→Profit/Loss for Multiple CTs) |
(→Profit/Loss for Multiple CTs) |
||
Line 47: | Line 47: | ||
* It allows user to generate P/L report for multiple CTs | * It allows user to generate P/L report for multiple CTs | ||
- | === | + | === Filters === |
* Date Type: Radio button for Saling Date and Issuing Date | * Date Type: Radio button for Saling Date and Issuing Date | ||
** Saling Date = origin port(oP) | ** Saling Date = origin port(oP) | ||
- | ** Issuing Date = | + | ** Issuing Date = Inv.Date |
** Default > Saling Date | ** Default > Saling Date | ||
* Date: Radio button for Month and Year and Date Range | * Date: Radio button for Month and Year and Date Range | ||
Line 58: | Line 58: | ||
* Profit/Loss: Radio button for Amount Range and Percentage Range | * Profit/Loss: Radio button for Amount Range and Percentage Range | ||
** Amount Range: text box for from and to (with 2 decimal places) | ** Amount Range: text box for from and to (with 2 decimal places) | ||
- | ** Percentage Range | + | ** Percentage Range: text box for from and to (with 2 decimal places) |
** Default > Amount Range | ** Default > Amount Range | ||
- | * Output Type: Radio button for Summary and Detailed | + | * Output Type: Radio button for Summary and Detailed |
** Default > summary | ** Default > summary | ||
Line 74: | Line 74: | ||
=== Button === | === Button === | ||
* Go back > go back to a previous page | * Go back > go back to a previous page | ||
- | * Reset Form > clear all filters except radio buttons default | + | * Reset Form > clear all filters except radio buttons default |
* Generate Result > report result | * Generate Result > report result | ||
- | ** Go back | + | ** Go back > go back to a previous page |
- | ** Download to Excel | + | ** Download to Excel > Excel spread sheet report(same as HTML) |
=== Output === | === Output === | ||
- | * Summary | + | * Summary (paging) |
- | * | + | ** CT# (with link to CT detail) |
+ | ** Client | ||
+ | ** Sale | ||
+ | ** Purchase | ||
+ | ** Profit/Loss | ||
+ | ** Profit/Loss % | ||
+ | ** Total | ||
+ | * Detailed (paging) | ||
+ | ** CT# (with link to CT detail) | ||
+ | ** Bill To Party Company/Vendor | ||
+ | ** Date | ||
+ | ** Office | ||
+ | ** Sales | ||
+ | ** Purchase | ||
+ | ** Profit/Loss | ||
+ | ** Profit/Loss% | ||
+ | ** Total | ||
=== Report === | === Report === | ||
* HTML | * HTML | ||
- | * Excel report | + | * Excel report (result is the same as HTML) |
- | + | ||
- | + |
Revision as of 14:28, 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
- User is able to see P/L report through CT profile via clicking P/L tab
- Report result is the same as Profit/Loss by CT# http://mantis.jaguarfreight.com/wiki/Acc_Reports_P_and_L#Report
Profit/Loss on Master profile
- User is able to see P/L report through M profile via clicking Profit/Loss tab
- Report result is the same as Profit/Loss on CT profile or Profit/Loss by CT# http://mantis.jaguarfreight.com/wiki/Acc_Reports_P_and_L#Report
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
- Sales Invoices
- Invoice links
- Report for a specific CT# with 4 sections
- 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
Filters
- Date Type: Radio button for Saling Date and Issuing Date
- Saling Date = origin port(oP)
- Issuing Date = Inv.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: text box for from and to (with 2 decimal places)
- 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 > go back to a previous page
- Download to Excel > Excel spread sheet report(same as HTML)
Output
- Summary (paging)
- CT# (with link to CT detail)
- Client
- Sale
- Purchase
- Profit/Loss
- Profit/Loss %
- Total
- Detailed (paging)
- CT# (with link to CT detail)
- Bill To Party Company/Vendor
- Date
- Office
- Sales
- Purchase
- Profit/Loss
- Profit/Loss%
- Total
Report
- HTML
- Excel report (result is the same as HTML)