Sales Invoice

From UG

(Difference between revisions)
Jump to: navigation, search
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.
+
: 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

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
  • 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?
Personal tools