Sales Invoice
From UG
Contents |
Business Needs and Requirements
Technical Specification
Summary
Template Section A. MOT Air
- 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)
- Table of Charges (TOC):
- Each line of table contains information that related to current Charge Code. This info divided by follows columns:
- Charge Code.
- Description.
- Quantity.
- R (rate).
- A (amount).
- Currency.
- VAT.
- Action buttons:
- All these buttons placed above the TOC in the next order from the left to the right:
- Maximize table.
- Add. Also has dropdown list with range [1-10] and label "lines to the table".
- Delete.
- Copy TOC from ImpTab.
- Total section:
- All total values placed on the template below the TOC in the next order:
- Sub-Total for each currency.
- Total Subject to VAT.
- Total Non Subject to VAT.
- VAT Amount.
- Grand Total (with Currency dropdown list).
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
- Bill To:
- Bill To Address:
- Date
- Invoice Comments:
- File ref#:
- CT ref#:
- P.O. Numbers:
- Shipper
- Consignee
- Notify Party:
- VESSEL:
- PORT OF DEPARTURE:
- PORT OF ARRIVAL:
- VOYAGE NUMBER:
- Date Of Departure:
- Estimated Date of Arrival:
- CONTAINER No(s):
- Packages:
- Pallets
- Cartons on Pallets
- Cartons (loose)
- Weight/Volume:
- Weight:
- Volume:
MOT FCL
- Bill To:
- Bill To Address:
- Date
- Invoice Comments:
- File ref#:
- CT ref#:
- P.O. Numbers:
- Shipper
- Consignee
- Notify Party:
- VESSEL:
- PORT OF DEPARTURE:
- PORT OF ARRIVAL:
- VOYAGE NUMBER:
- Date Of Departure:
- Estimated Date of Arrival:
- CONTAINER No(s):
- Packages:
- Pallets
- Cartons on Pallets
- Cartons (loose)
- Weight/Volume:
- Weight:
- Volume:
MOT Truck
Group Generate
In case of group generate (when Invoice is generated from CT which is a part of group) the user gets the ability to include an info of each grouped CT to Invoice. System shows the selection window that works exactly the same as in group generate case for any PDF. After user's choice (in checkboxes) the Invoice template should contain an aggregate info from one or multiple CTs.
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?
