Sales Invoice
From UG
(Difference between revisions)
(→Pdf) |
(→Template Section B (TOC)) |
||
Line 38: | Line 38: | ||
[[File:Invoice_Air_Section_B.GIF|600px|thumb|Figure:Invoice Air Section B ]] | [[File:Invoice_Air_Section_B.GIF|600px|thumb|Figure:Invoice Air Section B ]] | ||
* Table of Charges (TOC): | * Table of Charges (TOC): | ||
- | * Action buttons | + | : Each line of table contains information that related to current Charge Code. This info divided by follows columns: |
- | : Maximize table | + | :* [[#Charge Codes | Charge Code]]. |
- | : Add. ''Also has dropdown list with range [1-10] and label "lines to the table".'' | + | :* Description. |
- | : Delete | + | :* Quantity. |
- | : Copy TOC from ImpTab | + | :* R (rate). |
- | * Total section | + | :* A (amount). |
- | : Sub-Total | + | :* Currency. |
- | : Total Subject to VAT | + | :* [[VAT]]. |
- | : Total Non Subject to VAT | + | * Action buttons: |
- | : VAT Amount | + | : All these buttons placed '''above''' the TOC in the next order from the left to the right: |
- | : Grand Total ''( | + | :* 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)''. | ||
=== Pdf === | === Pdf === |
Revision as of 16:35, 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):
- 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
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?