PL Tab

From UG

Revision as of 13:12, 8 November 2013 (edit) Andrei (Talk | contribs) (→Latest Version) ← Older edit		Current revision as of 17:50, 13 November 2013 (edit) (undo) Andrei (Talk | contribs) (→Latest Version)
(23 intermediate revisions not shown)
Line 3:		Line 3:
	== Info ==		== Info ==
-	User is able to see P/L report through CT profile via clicking P/L tab	+	User is able to see '''Profit/Loss''' (P/L) report through CT profile via clicking P/L tab
-		+
	== Latest Version ==		== Latest Version ==
-	PL tab contains tables and controls that have differences in CT and Master Editor:	+	* PL tab contains:
-	* '''Sales Invoices''' table	+	:* tables of Invoices and Amounts related to current CT.
-	:* Issuing Office	+	:* additional controls for specific actions.
-	:* Bill To Party Company	+	* Look and feel of PL tab can be different in CT and Master Editor.
-	:* Invoice #	+	[[File:PL_tab_example.PNG|600px|thumb|Figure:Example of PL tab in CT Editor]]
-	:* CT #	+
-	:* Date	+	=== Sales Invoices table ===
-	:* Currency	+	* Contains list of [[Sales Invoice |'''Sales Invoices''']] (SI) that were issued against the current CT either individually or via Group
-	:* Amount'''*'''	+	* Consists of columns:
-	:* USD Amount'''*'''	+	:* Issuing Office - Jaguar Office issued the Invoice
-	* '''Purchase Invoices''' table	+	:* Bill To Party Company - [http://wiki.jaguarfreight.com/wiki/Sales_Invoice#Bill_To Bill To Company] billed by Jaguar
-	:* Receiving Office	+	:* Invoice # - [http://wiki.jaguarfreight.com/wiki/Sales_Invoice#Invoice_Number Invoice Number]
-	:* Vendor	+	:* CT # - current CT Number
-	:* Invoice #	+	:* Date - [http://wiki.jaguarfreight.com/wiki/Sales_Invoice#Issuing_Date Issuing Date]
-	:* CT #	+	:* Currency - [http://wiki.jaguarfreight.com/wiki/Sales_Invoice#Total_Invoice_Currency Currency] of the Invoice
-	:* Date	+	:* Amount'''*''' - [http://wiki.jaguarfreight.com/wiki/Sales_Invoice#Total_Invoice Total Amount] in Currency of the Invoice
-	:* Currency	+	:* USD Amount'''*''' - Amount of the Invoice converted to USD
-	:* Amount	+
-	* '''Internal Invoices''' table	+	=== Purchase Invoices table ===
-	:* Issuing Office	+	* Contains list of '''[[Purchase Invoices]]''' (PI) that were distributed to the current CT either individually or via Master
-	:* Receiving Office	+	* Consists of columns:
-	:* Consolidated #	+	:* Receiving Office - Jaguar Office billed by the Invoice
-	:* Invoice #	+	:* Vendor - Company issued the Invoice
-	:* CT #	+	:* Invoice # - PI Number
-	:* Date	+	:* CT # - current CT Number (distributed by the Invoice)
-	:* Currency	+	:* Date - Date of issuing the Invoice
-	:* Amount	+	:* Currency - Currency of the Invoice
-	* '''Profit/Loss Amounts''' table	+	:* Amount - Total Amount in Currency of the Invoice
-	:* Office	+	:* USD Amount'''*''' - Amount of the Invoice converted to USD
-	:* USD Sales	+
-	:* USD Purchase	+	=== Internal Invoices table ===
-	:* USD Int from	+	* Contains list of [[Internal Invoice |'''Internal Invoices''']] (II) that were issued against the current CT either manually or automatically during [[GMS |Gross Margin Split]] (GMS) process
-	:* USD Int to	+	* Consists of columns:
-	:* USD Profit/Loss'''*'''	+	:* Issuing Office - Jaguar Office that issued the Invoice from
		+	:* Receiving Office - Jaguar Office that issued the Invoice to
		+	:* Consolidated # - [[GMS#Consolidated_Internal_Invoice |Consolidated Internal Invoice]] issued by the system
		+	:* Invoice # - CT2 II Number
		+	:* CT # - current CT Number
		+	:* Date - Date of issuing the Invoice
		+	:* Currency - Currency of the Invoice
		+	:* Amount - Total Amount in Currency of the Invoice
		+	:* USD Amount'''*''' - Amount of the Invoice converted to USD
		+
		+	=== Profit/Loss Amounts table ===
		+	* Contains list of Jaguar Offices with appropriate Sales, Purchase and Internal amounts.
		+	* Consists of columns:
		+	:* Office - Jaguar Office
		+	:* USD Sales - total of all related Sales Amounts
		+	:* USD Purchase - total of all related Purchases Amounts
		+	:* USD Int from - distributed GMS charges (from Office)
		+	:* USD Int to - distributed GMS charges (to Office)
		+	:* USD Profit/Loss'''*''' - actual Profit/Loss for current CT (can be calculated for individuall CT or CT group)
-	* '''"Type"''' radiogroup - select type of Amount calculation ''(available only in CT editor)''	+	=== Additional Controls ===
-	:* CT Individual	+	* '''"Type"''' radiogroup - provides to select a type of Amounts' distribution on PL tab ''(available only in CT editor)''
-	:* CT Group	+	:* CT Individual - if selected, the Amounts will include sales and costs distributed to current CT only
-	* '''"Download to Excel"''' button	+	:* CT Group - if selected, the Amounts will include all values assigned to Group to which current CT belongs
-	* '''"Close/Open Shipment"''' button	+	* '''"Download to Excel"''' button - provides an ability to download the XLS copy of PL tab
		+	* '''"Close/Open Shipment"''' button - provides the changing of [[GMS#OC_status |OC status]] of current CT
-	NOTE: VAT is excluded from amounts in columns marked with '''*''' - this labelled on top-right corner of PL tab.	+	=== Additional Notes ===
		+	* NOTE 1: Amounts in columns marked with '''*''' are displayed without VAT  - this noted in top-right corner of PL tab with ''" * VAT has been excluded from amounts"''.
		+	* NOTE 2: Number of every Invoice is a hyperlink to open PDF form of the Invoice (SI, II) or Invoice Editor (PI).
-	=== CT ===	+	=== CT Editor ===
-	Invoices and Amounts	+	Displaying of Invoices and Amounts depends from the selected type of calculating (Individual or Group).
-	=== Master ===	+	=== Master Editor ===
	Contents all invoices from all CTs included to Master.		Contents all invoices from all CTs included to Master.

---

Current revision as of 17:50, 13 November 2013

Contents 1 Info 2 Latest Version 2.1 Sales Invoices table 2.2 Purchase Invoices table 2.3 Internal Invoices table 2.4 Profit/Loss Amounts table 2.5 Additional Controls 2.6 Additional Notes 2.7 CT Editor 2.8 Master Editor 3 Misc 3.1 Example with 3 currencies 3.2 Example with one currency EUR 4 SOWs 4.1 SOW 1

[edit] Info

User is able to see Profit/Loss (P/L) report through CT profile via clicking P/L tab

[edit] Latest Version

• PL tab contains:

• tables of Invoices and Amounts related to current CT.
• additional controls for specific actions.

• Look and feel of PL tab can be different in CT and Master Editor.

[edit] Sales Invoices table

• Contains list of Sales Invoices (SI) that were issued against the current CT either individually or via Group
• Consists of columns:

• Issuing Office - Jaguar Office issued the Invoice
• Bill To Party Company - Bill To Company billed by Jaguar
• Invoice # - Invoice Number
• CT # - current CT Number
• Date - Issuing Date
• Currency - Currency of the Invoice
• Amount* - Total Amount in Currency of the Invoice
• USD Amount* - Amount of the Invoice converted to USD

[edit] Purchase Invoices table

• Contains list of Purchase Invoices (PI) that were distributed to the current CT either individually or via Master
• Consists of columns:

• Receiving Office - Jaguar Office billed by the Invoice
• Vendor - Company issued the Invoice
• Invoice # - PI Number
• CT # - current CT Number (distributed by the Invoice)
• Date - Date of issuing the Invoice
• Currency - Currency of the Invoice
• Amount - Total Amount in Currency of the Invoice
• USD Amount* - Amount of the Invoice converted to USD

[edit] Internal Invoices table

• Contains list of Internal Invoices (II) that were issued against the current CT either manually or automatically during Gross Margin Split (GMS) process
• Consists of columns:

• Issuing Office - Jaguar Office that issued the Invoice from
• Receiving Office - Jaguar Office that issued the Invoice to
• Consolidated # - Consolidated Internal Invoice issued by the system
• Invoice # - CT2 II Number
• CT # - current CT Number
• Date - Date of issuing the Invoice
• Currency - Currency of the Invoice
• Amount - Total Amount in Currency of the Invoice
• USD Amount* - Amount of the Invoice converted to USD

[edit] Profit/Loss Amounts table

• Contains list of Jaguar Offices with appropriate Sales, Purchase and Internal amounts.
• Consists of columns:

• Office - Jaguar Office
• USD Sales - total of all related Sales Amounts
• USD Purchase - total of all related Purchases Amounts
• USD Int from - distributed GMS charges (from Office)
• USD Int to - distributed GMS charges (to Office)
• USD Profit/Loss* - actual Profit/Loss for current CT (can be calculated for individuall CT or CT group)

[edit] Additional Controls

• "Type" radiogroup - provides to select a type of Amounts' distribution on PL tab (available only in CT editor)

• CT Individual - if selected, the Amounts will include sales and costs distributed to current CT only
• CT Group - if selected, the Amounts will include all values assigned to Group to which current CT belongs

• "Download to Excel" button - provides an ability to download the XLS copy of PL tab
• "Close/Open Shipment" button - provides the changing of OC status of current CT

[edit] Additional Notes

• NOTE 1: Amounts in columns marked with * are displayed without VAT - this noted in top-right corner of PL tab with " * VAT has been excluded from amounts".
• NOTE 2: Number of every Invoice is a hyperlink to open PDF form of the Invoice (SI, II) or Invoice Editor (PI).

[edit] CT Editor

Displaying of Invoices and Amounts depends from the selected type of calculating (Individual or Group).

[edit] Master Editor

Contents all invoices from all CTs included to Master.

[edit] Misc

[edit] Example with 3 currencies

[edit] Example with one currency EUR

[edit] SOWs

[edit] SOW 1