From UG

Revision as of 21:10, 2 September 2009 (edit) Montira (Talk | contribs) ← Older edit		Revision as of 21:21, 2 September 2009 (edit) (undo) Montira (Talk | contribs) (→Profit/Loss on CT profile) Newer edit →
Line 14:		Line 14:
	== Profit/Loss on CT profile ==		== Profit/Loss on CT profile ==
-		+	* User is able to see P/L report through CT
	== Profit/Loss on Master profile ==		== Profit/Loss on Master profile ==

---

Revision as of 21:21, 2 September 2009

Contents 1 Biz requirement 1.1 Profit/Loss on CT profile 1.2 Profit/Loss on Master profile 1.3 Profit/Loss by CT# 1.3.1 Report 1.4 Profit/Loss for Multiple CTs

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 for Multiple CTs
  • Acc > Reports > Profit/Loss by CT #

Profit/Loss on CT profile

• User is able to see P/L report through CT

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

• Saling Date = origin port(oP)