Sales Invoice

From UG

Revision as of 14:16, 12 August 2010

Business Needs and Requirements

Technical Specification

Summary

Template Section A. MOT Air

Figure:Invoice Air Section A

• Bill To:
• Bill To Address:
• Date
• Invoice Comments:
• File ref#:
• CT ref#:
• P.O. Numbers:
• Shipper
• Consignee
• Notify Party:
• AIRLINE:
• AIRPORT OF DEPARTURE:
• AIRPORT OF DESTINATION:
• FLIGHT NUMBER:
• Date Of Departure:
• Estimated Date of Arrival:
• CUSTOMER REF:
• Packages:
  • Pallets
  • Cartons on Pallets
  • Cartons (loose)

• Weight/Volume:
  • Weight:
  • Chargeable:
  • Volume:

Template Section B (TOC)

Figure:Invoice Air Section B

• Table of Charges (TOC):
• Action buttons (above the TOC):

Maximize table

Add. Also has dropdown list with range [1-10] and label "lines to the table".

Delete

Copy TOC from ImpTab

• Total section (below the TOC):

Sub-Total" for each currency

Total Subject to VAT:

Total Non Subject to VAT:

VAT Amount:

Grand Total (and Currency dropdown list)

Pdf

Figure:Sales Invoice PDF

Printed form of Sales Invoice should be in compliance with the Common specs for pdfs.

System generates 3-page PDF of Sales Invoice. The content of each page are identical, except the grey bolded "Copy label" at bottom of each page: Original, File Copy and Accounts Copy.

• Header

• Jaguar Office address based on login user.

font: standard Jaguar font (AGRevueCyr Roman Medium).

aligned: to right.

• Bill To + Bill To Address

Label: TO:.

aligned: to left.

• Invoice's number and date of its creating

Labels: Invoice No: and Date:.

aligned: to right.

NOTE: Header of Sales Invoice doesn't contain Jaguar logo.

• Body

• Top Section - reflects Template Section A, except:

- "Bill To", "Date" (should be print on Header).

- "Invoice Comments" (should be print on Footer).

• Commodity Section - reflects Template Section B (Table of Charge).

• Table. List of columns:

- CC#.

- Description.

- Currency.

- Amount.

• Totals. List of totals:

- sub-total for each used currency.

- total non-subject to VAT.

- total subject to VAT.

- VAT Amount.

- Total Invoice.

• Footer

• Comments section. Reflects Template Invoice Comments. Takes 2 lines.

Label: COMMENTS:.

• Textline "Terms - Net upon receive Invoice".
• Login user's first name and last name.

Label: PREPARED BY:.

• Page X of Y.
• Copy label.

MOT LCL

MOT FCL

MOT Truck

Group Generate

In Database

mysql> describe tblShipmentInvoices;
+-----------------------+---------------+------+-----+---------+----------------+
| Field                 | Type          | Null | Key | Default | Extra          |
+-----------------------+---------------+------+-----+---------+----------------+
| Id                    | int(10)       | NO   | PRI | NULL    | auto_increment |
| ShipmentId            | int(10)       | NO   | MUL | NULL    |                |
| IssueDate             | datetime      | NO   |     | NULL    |                |
| UserId                | int(10)       | NO   | MUL | NULL    |                |
| Amount                | double        | NO   |     | 0       |                |
| BillToCompany         | varchar(255)  | YES  |     | NULL    |                |
| BillToAddress         | varchar(512)  | YES  |     | NULL    |                |
| CurrencyId            | int(10)       | NO   | MUL | NULL    |                |
| OfficeId              | int(10)       | NO   | MUL | NULL    |                |
| DateOfDeparture       | date          | YES  |     | NULL    |                |
| DateOfArrival         | date          | YES  |     | NULL    |                |
| PortOfDeparture       | varchar(128)  | YES  |     | NULL    |                |
| PortOfArrival         | varchar(128)  | YES  |     | NULL    |                |
| Vesselname            | varchar(128)  | YES  |     | NULL    |                |
| Shipper               | varchar(512)  | YES  |     | NULL    |                |
| Consignee             | varchar(512)  | YES  |     | NULL    |                |
| NotifyParty           | varchar(512)  | YES  |     | NULL    |                |
| FileRef               | varchar(512)  | YES  |     | NULL    |                |
| InvoiceType           | int(10)       | NO   | MUL | 0       |                |
| CreditNoteOnInvoiceId | int(10)       | YES  | MUL | NULL    |                |
| VoyageNumber          | varchar(20)   | YES  |     | NULL    |                |
| TotalOfPallets        | int(10)       | YES  |     | NULL    |                |
| TotalPkgsOnPlts       | int(10)       | YES  |     | NULL    |                |
| TotalLoosePkgsOnPlts  | int(10)       | YES  |     | NULL    |                |
| BillToOfficeId        | int(10)       | YES  | MUL | NULL    |                |
| BillToCompanyId       | int(10)       | YES  | MUL | NULL    |                |
| WeightInKg            | double        | YES  |     | NULL    |                |
| VolumeInCbm           | double        | YES  |     | NULL    |                |
| Comments              | varchar(1024) | YES  |     | NULL    |                |
| PONumbers             | varchar(1024) | YES  |     | NULL    |                |
| CTRef                 | varchar(512)  | YES  |     | NULL    |                |
| VATAmount             | double        | YES  |     | NULL    |                |
| TotalWithVAT          | double        | YES  |     | NULL    |                |
| TotalNonVAT           | double        | YES  |     | NULL    |                |
| CustomerRef           | varchar(512)  | YES  |     | NULL    |                |
| ChargeableWeight      | double        | YES  |     | NULL    |                |
| TableOfChargesId      | int(10)       | YES  | MUL | NULL    |                |
| ShowToClient          | tinyint(1)    | NO   |     | 0       |                |
| InvoiceNumber         | int(10)       | NO   | MUL | 0       |                |
| MainOfficeId          | int(10)       | YES  | MUL | NULL    |                |
+-----------------------+---------------+------+-----+---------+----------------+
40 rows in set

mysql> describe tblTableOfCharges;
+--------------+---------+------+-----+---------+----------------+
| Field        | Type    | Null | Key | Default | Extra          |
+--------------+---------+------+-----+---------+----------------+
| Id           | int(10) | NO   | PRI | NULL    | auto_increment |
| Amount       | double  | YES  |     | NULL    |                |
| AmountVAT    | double  | YES  |     | NULL    |                |
| TotalWithVAT | double  | YES  |     | NULL    |                |
| TotalNonVAT  | double  | YES  |     | NULL    |                |
| CurrencyId   | int(10) | YES  | MUL | NULL    |                |
+--------------+---------+------+-----+---------+----------------+
6 rows in set

Dev, QA and History of Changes

RFC

• Block issuing invoice for Undefined CT?