Proposal Summary
This proposal is to automatically generate a ‘Dangerous Goods form’ from the item fulfilment record in order to reduce human error and avoid violating ADR Regulations/Laws.
Requirement
Blueleaf needs to create a print template ‘Dangerous Goods form’ in the item fulfilment that needs to be populated automatically.
The form needs to be generated when an item line field ITEM DANGEROUS GOODS PREFERENCES (custcol_proppershippingname) has the “Limited Quantity” or “Dangerous Goods” ticked. The Item Fulfilment should have the item fulfilment status ‘Shipped’, ideally the form should be generated together with the delivery note.
MULTIMODAL DANGEROUS GOODS FORM
This form may be used as a dangerous goods declaration as it meets the requirements of SOLAS, chapter VII, regulation 4;
MARPOL, Annex III, Regulation 4.
| 1 Shipper/Consignor/Sender | 2 Transport document number | |||
| 3 Page No of | 4 Shipper’s reference | |||
| 5 Freight Forwarder’s Reference | ||||
| 6 Consignee | 7 Carrier (to be completed by the carrier) | |||
| SHIPPER’S DECLARATION I hereby declare that the contents of this consignment are fully and accurately described below by the Proper Shipping Name, and are classified, packaged, marked and labelled/placarded and are in all respects in proper condition for transport according to the applicable international and national governmental regulations. | ||||
| 8 This shipment is within the limitations prescribed for:- (Delete non Applicable) | 9 Additional handling information | |||
| Passenger and Cargo Aircraft | Cargo Aircraft Only | |||
| 10 Vessel | 11 Port/Place of loading | |||
| 12 Port/Place of discharge | 13 Destination | |||
| 14 Shipping Marks *Number and kind of packages: description of goods Gross mass (kg) Net mass (kg) Cube (m3) | ||||
| Example 1: UN 1098, ALLYL ALCOHOL, 6.1 (3), I, (21℃ c.c) Example 2: UN 1092, Acrolein, stabilized, class 6.1 (3), PGI, MARINE POLLUTANT | ||||
| 15 Container identification number / vehicle registration no. | 16. Seal number(s) | 17 Container / Vehicle size &type | 18 Tare mass (kg) | 19 Total gross mass (including tare) (kg) |
| CONTAINER/VEHICLE PACKING CERTIFICATE I hereby declare that the goods described above have been packed/loaded into the container/vehicle identified above in accordance with the applicable provisions ** MUST BE COMPLETED AND SIGNED FOR ALL CONTAINER / VEHICLE LOADS BY PERSON RESPONSIBLE FOR PACKING / LOADING | 21 RECEIVING ORGANISATION RECEIPT Received the above number of packages/containers/trailers in apparent good order and condition, unless stated hereon: RECEIVING ORGANISATION REMARKS: | |||
| 20 Name of Company | Haulier’s Name Vehicle Registration No. Signature and date | 22 Name of company (OF SHIPPER PREPARING THIS NOTE) | ||
| Name/status of declarant | Name/status of declarant | |||
| Place and Date | Place and date | |||
| Signature of declarant | DRIVER’S SIGNATURE | Signature of Declarant |
* DANGEROUS GOODS
You must specify: UN No., Proper Shipping name, hazard class, packing group, (where assigned), marine pollutant and observe the mandatory requirements under applicable national and international governmental regulations. For the purposes of the IMDG Code see 5.4.1.4
** For the purposes of the IMDG Code see 5.4.2.
This form is reproduced from IMDG code (amendment 37-14), Chapter 5.4 – Documentation, Page 275
There are some fields which will be required to be auto populated, these have been highlighted in yellow on the template. On the table below the fields which need to be auto populated have been mapped to the required NetSuite fields.
| Template field name | NetSuite field name | NetSuite field ID | Notes |
| 1 Shipper/ Consignor/ Sender | LOCATION ADDRESS The field is located on the Sales Order form under the Shipping tab | custbody_locationaddress | The shipper is Blueleaf – this needs to be the address of the location the Sales Order is being sent from |
| 3 Page No of | Should there be more than one page on an IF, this field should populate according to where the item is located on the IF. For example, page 2 | ||
| 4 Shipper’s reference | REF. NO. | tranid | This needs to be the Item Fulfilment number |
| 6 Consignee | ADDRESS The field is located on the Item Fulfilment form under the shipping tab | shipaddress | This is the customers address |
| 14 Shipping Marks | UN NUMBER (UN prefix) PROPER SHIPPING NAME TRANSPORT HAZARD CLASS FLASH POINT The UN number field will only generate a number. The letters UN need to be set on the form ready for the number to sit next to | custitem_unnumber custitem_propershippingname custitem_transportharardclass custitem_flash_point | All these fields are found under the preference tab on an item record. Two examples of how the layout should be displayed, have been shown on the template (page 2) |
| 19 Total gross | ITEM WEIGHT x QUANTITY | weight quantity | The total gross field needs to be the item weight of the item times the quantity of that item on the Sales Order |
Our Solution
We will be creating a button on the item fulfilment page when an item line field ITEM DANGEROUS GOODS PREFERENCES (custcol_proppershippingname) has the “Limited Quantity” or “Dangerous Goods” and the item fulfilment status is ‘Shipped’.
On the button click we can navigate to the print page that shows all the details as in the below table:
*********************************************************************************
MULTIMODAL DANGEROUS GOODS FORM
This form may be used as a dangerous goods declaration as it meets the requirements of SOLAS, chapter VII, regulation 4;
MARPOL, Annex III, Regulation 4.
| 1 Shipper/Consignor/Sender | 2 Transport document number | |||
| 3 Page No of | 4 Shipper’s reference | |||
| 5 Freight Forwarder’s Reference | ||||
| 6 Consignee | 7 Carrier (to be completed by the carrier) | |||
| SHIPPER’S DECLARATION I hereby declare that the contents of this consignment are fully and accurately described below by the Proper Shipping Name, and are classified, packaged, marked and labelled/placarded and are in all respects in proper condition for transport according to the applicable international and national governmental regulations. | ||||
| 8 This shipment is within the limitations prescribed for:- (Delete non Applicable) | 9 Additional handling information | |||
| Passenger and Cargo Aircraft | Cargo Aircraft Only | |||
| 10 Vessel | 11 Port/Place of loading | |||
| 12 Port/Place of discharge | 13 Destination | |||
| 14 Shipping Marks *Number and kind of packages: description of goods Gross mass (kg) Net mass (kg) Cube (m3) | ||||
| Item Names in the IF record | ||||
| 15 Container identification number / vehicle registration no. | 16. Seal number(s) | 17 Container / Vehicle size &type | 18 Tare mass (kg) | 19 Total gross mass (including tare) (kg) |
| CONTAINER/VEHICLE PACKING CERTIFICATE I hereby declare that the goods described above have been packed/loaded into the container/vehicle identified above in accordance with the applicable provisions ** MUST BE COMPLETED AND SIGNED FOR ALL CONTAINER / VEHICLE LOADS BY PERSON RESPONSIBLE FOR PACKING / LOADING | 21 RECEIVING ORGANISATION RECEIPT Received the above number of packages/containers/trailers in apparent good order and condition, unless stated hereon: RECEIVING ORGANISATION REMARKS: | |||
| 20 Name of Company | Haulier’s Name Vehicle Registration No. Signature and date | 22 Name of company (OF SHIPPER PREPARING THIS NOTE) | ||
| Name/status of declarant | Name/status of declarant | |||
| Place and Date | Place and date | |||
| Signature of declarant | DRIVER’S SIGNATURE | Signature of Declarant |
* DANGEROUS GOODS
You must specify: UN No., Proper Shipping name, hazard class, packing group, (where assigned), marine pollutant and observe the mandatory requirements under applicable national and international governmental regulations. For the purposes of the IMDG Code see 5.4.1.4
** For the purposes of the IMDG Code see 5.4.2.
This form is reproduced from IMDG code (amendment 37-14), Chapter 5.4 – Documentation, Page 275
**********************************************************************************
Assumptions
- Print will be generated in A4 page size.
- Only the field values which are filled with yellow colour need to populate from NetSuite
- Shipper/Consignor/Sender
- Page No of
- Shipper’s reference
- Consignee
- Shipping Marks
- The PDF page will expand based on the items in Item fulfilment record.
- We will fill the grey colour in the above-highlighted template columns
- HIPPER’S DECLARATION
- Name of company (OF SHIPPER PREPARING THIS NOTE)
- Name/status of declarant
- Place and date
- Signature of Declarant
Estimated Effort
Required Effort: 18 hrs