Sales Invoice
From UG
(Difference between revisions)
m (→Pdf) |
m (→Pdf) |
||
| Line 58: | Line 58: | ||
: NOTE: header '''doesn't''' contain Jaguar logo. | : NOTE: header '''doesn't''' contain Jaguar logo. | ||
* '''Body:''' | * '''Body:''' | ||
| - | : Top Section - reflects Template | + | : Top Section - reflects Template Section A. |
| - | : Commodity Section - reflects Table of Charge. | + | : Commodity Section - reflects Template Section B (Table of Charge). |
* '''Footer''': | * '''Footer''': | ||
: Comments section | : Comments section | ||
Revision as of 12:40, 12 August 2010
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):
- 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)
- Header:
- Jaguar Office address based on login user
- Bill To + Bill To Address
- Invoice number and date of its creating
- NOTE: header doesn't contain Jaguar logo.
- Body:
- Top Section - reflects Template Section A.
- Commodity Section - reflects Template Section B (Table of Charge).
- Footer:
- Comments section
- Line "Terms - Net upon receive Invoice".
- Prepared By and login user's first name and last name.
- Page X of Y
NOTE: 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.
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?
