--- title: "Container Worksheet" canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31101501/Container%20Worksheet" format: markdown --- Goal: This option allows you to maintain the container details associated with a shipment. If the feature 'FeatureCnt' is not activated, a warning is displayed and the BOL (Container Worksheet) does not proceed. The BOL worksheet can only be accessed if at least one purchase order has been added, the shipping basis is fob and the vessel and port of loading details have been entered in the shipment header. Steps: From the 'Main Menu' select options - 'Purchasing & Receipting' - 'Import Purchasing' - 'Shipment Maintenance'. Shipment Number: key the shipment number, or to search, or for a new consignment then choose menu option 'Container Worksheet'. You can search for shipments by shipment number, bill of lading, booking number, mark number, shipping line, name of vessel, supplier and product. Alternatively, you can access a shipment via one of the purchase orders associated with it. From the 'Main Menu' select options - 'Purchasing & Receipting' - 'Purchase Order Processing' - [select purchase order] - 'Importing' - 'Import Shipping Maintenance' - 'Container Worksheet'. When the Container Worksheet is first created, or later changed, the Costing Worksheet is populated with the default charges for the combination of Port of Loading, Port of Arrival and Shipping Line. The defaults are setup in the option - 'Purchasing & Receipting' - 'Import Purchasing' - 'Container Costs'. The shipping basis must be fob (free on board). Please note that importing charges with a type of 'duty' cannot be added to containers. A BOL may have many mark numbers. A booking number may have many containers. The Container worksheet has the following fields: Mark : the mark number for the shipment. These are pre-loaded into the worksheet from the purchase orders that are attached, and must be added or deleted at the purchase order level. Selecting a mark number and pressing will drill down to display the products that make up the mark. The same products with various packs are consolidated into one line. Default import costs are automatically assigned to the BOL if shipping details (shipping basis must be fob [free on board] and the combination of Port of Loading, Port of Arrival and Shipping Line) match, otherwise a warning is given that no default charges can be found. The costs are totalled across the BOL and recorded as 'Estimated Costs' in the Costing Worksheet. The following fields are displayed when you press to drill down: The Charges function allows you to further drill down to the import charges attached to the mark number. Here there is an facility to add mark level costs. When you then go and view the Costing Worksheet, these costs will be shown with a costing method of 'Mark'. Any marks that are removed from the selection list will have the mark level cost deleted and the cost for the Import Charge displayed will be the total of the remaining marks. If this value is changed then the cost will be apportioned either by value or volume across the remaining marks (depending on the Tailoring Code ' ImpCstAvg '). Booking : key the booking number once it has been received from the freight forwarder. Line : key the Shipping Line, or to search. Arr. Port: Search can be used. This is copied to the Container Worksheet from the header field when it is first created. Supplier : This is retrieved from the purchase orders that are attached. Product : Free-form text. Container: Free-form text. BOL (Bill of Lading): Free-form text. This is copied to the Container Worksheet from the header field when it is first created. Date Arrival : Key a valid date. This is copied to the Container Worksheet from the header field when it is first created. The Print function will print a shipping instruction to be forwarded to a freight forwarder. Review: You can now: Maintain the container details associated with a shipment.