Task #19643
Updated by Redmine Admin 5 months ago
Generate a Cost and Sales report—Working Sheet for each HAWB in PDF format, including shipment details, routing details, parties involved, and detailed sales/cost charges with profit information. **Requirements:** [WORKING SHEET.doc](/uploads/2d735acd2fbf4d03d0aedc2a45dafa2b/WORKING_SHEET.doc) The system must generate one Cost and Sales report per HAWB. \ HAWB.\ The Cost and Sales report must serve as an internal operational and costing document showing: * File information * MAWB and HAWB references * Shipper / Consignee / Agent / Notify Party * Shipment details * Shipping / flight details * Charges Details * Totals, VAT, and Gross Profit * Remarks section [WORKING SHEET.doc](/uploads/2d735acd2fbf4d03d0aedc2a45dafa2b/WORKING_SHEET.doc) Attached is a sample Cost and Sales document used by WSC for reference. however, note that the The format of the Charges Details section must follow the same structure as in ocean module (sample provided below), where Sales and Cost are displayed side by side and totals are shown clearly at the bottom. {width="610" height="138"} {width=610 height=138} **Scope** This functionality applies to: * Air Export HAWB * Air Import HAWB where applicable, with the same financial format but data populated based on import transactions The Cost and Sales report is generated at HAWB level. **Preconditions** 1. A valid HAWB must exist in the system. 2. The HAWB can either be linked to a File Reference or not. 3. Shipment party details must be available: * Shipper * Consignee * Agent, if applicable * Notify Party, if applicable 4. Flight / routing information must be available where relevant. 5. Charges must exist: * Sales charges * Cost charges 6. Exchange rate data must exist for any charge not in default currency. 7. VAT setup must exist for relevant charge lines. **Trigger** The Cost and Sales report is generated when the user clicks: Action \> Download Working Sheet\ or\ Action \> Preview Working Sheet from the HAWB / File Reference—Retrieve screen in the HAWB level. Reference screen. **Main Functional Description** When the user generates the Cost and Sales report, the system shall produce a formatted report for the selected HAWB containing the following sections. **1. Header Section** The report shall display: * Company Name * Company Address * Company Contact Details * Working Sheet Title * Master File Ref. * File Ref. * Date * Issued By **2. Shipment Reference Section** The report shall display: * MAWB No * HAWB No **3. Parties Section** The report shall display: * Shipper name and address * Consignee name and address * Agent name and address, where applicable * Notify Party name and address, where applicable **4. Shipment Details Section** The report shall display, where available: * Number of Packages * Packaging Type * Goods Description * Gross Weight * Volume * HS Code, where captured * Manifested Ocean/Air Freight value if maintained * Currency of Freight * Incoterms * Stuffing Place / Place of Receipt where relevant * Freight Payable At * Place of Issue **5. Shipping Details Section** The report shall display, where applicable: * Airline * Local Agent * Flight No * Airport of Loading * Airport of Discharge * Final Destination * ETD * ETA * ATA * Place of Receipt **6. Charges Details Section** The Charges Details section must follow the required presentation structure and show Sales and Cost in parallel.\ This section is mandatory in the Cost and Sales report. **6.1 Column Structure** The section shall display one row per charge description, with the following layout: **Common column** * Desc. **Sales side** * Curr. * Vat * ROE * Amt. Without Vat in FCY * Amt. Without Vat MUR **Cost side** * Curr. * Vat * ROE * Amt. Without Vat in FCY * Amt. Without Vat MUR This layout must visually separate Sales and Cost as two parallel financial blocks. **6.2 Charge Line Population Rules** 1. Each charge row shall be grouped by charge description. 2. The same description may contain: * Sales only * Cost only * Both Sales and Cost 3. If a charge exists only on one side: * the opposite side shall remain blank or zero as per report design 4. The report shall list charges in the sequence configured in the system or, if no sequence exists, by charge creation order. 5. Charge descriptions must be displayed as saved in the HAWB cost / sales grid. **6.3 VAT Display Rules** For each charge row: * The Vat column shall display the VAT amount applicable to that row * If no VAT applies, display 0.00 or blank based on approved report format * VAT must be shown separately from the amount without VAT **6.4 Currency and ROE Rules** For each Sales and Cost row: * Curr. shall display the transaction currency of the charge * ROE shall display the rate of exchange used to convert FCY to MUR * If charge currency is MUR, ROE shall default to **1** * If charge is maintained in foreign currency, MUR amount must be calculated using the saved ROE **6.5 Amount Rules** For each line: * Amt. Without Vat in FCY = charge amount excluding VAT in source currency * Amt. Without Vat MUR = charge amount excluding VAT converted to MUR VAT must not be included in these two amount columns. **7. Totals Section** At the bottom of the Charges Details section, the system shall display: * TOTAL SALES (MUR) * TOTAL COST (MUR) * TOTAL VAT SALES (MUR) * TOTAL SALES (MUR) inclusive of VAT * TOTAL VAT COSTS (MUR) * G PROFIT (MUR) **7.1 Calculation Rules** **Total Sales (Without VAT)** Sum of all Sales line amounts in MUR excluding VAT. **Total Cost (Without VAT)** Sum of all Cost line amounts in MUR excluding VAT. **Total VAT Sales** Sum of VAT amounts for all Sales lines. **Total VAT Costs** Sum of VAT amounts for all Cost lines. **Total Sales Inclusive of VAT** `Total Sales Without VAT + Total VAT Sales` **Gross Profit** `Total Sales Inclusive of VAT - (Total Cost Without VAT + Total VAT Costs)` **Remarks Section** The report shall include a Remarks section at the bottom. Rules: * If remarks exist on the HAWB / File / Working Sheet remarks field, they shall print * If no remarks exist, the section shall still appear blank for manual use if required **Functional Rules** 1. One Working Sheet must be generated per HAWB. 2. The report must always use the selected HAWB data only. 3. If multiple HAWBs exist under one MAWB, each HAWB must have its own separate Working Sheet. 4. The report must be available in: * Preview format * PDF export format 5. The report must reflect the latest saved values at the time of generation. 6. Cancelled or inactive charges must not appear unless a configuration explicitly allows this. 7. Charges must be shown in MUR totals even if entered in foreign currency. **Exception / Validation Rules** **Case 1: No charges exist** If no Sales and no Cost charges exist for the HAWB: * system shall still generate the Working Sheet * Charges Details section shall show No Charges Available or remain blank as per approved design * totals shall default to zero