--- title: "Costing Worksheet" canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31101495/Costing%20Worksheet" format: markdown --- Goal: This option allows you to maintain the importing charges associated with a shipment. Steps: 1. From the ProStix Main Menu select options - ' Purchasing & Receipting ' - ' Import Purchasing ' - ' Shipment Maintenance '. Shipment Number : key the shipment number, or to search, or for a new shipment then choose the menu option 'Costing Worksheet'. You can search for shipments by shipment number, bill of lading, booking number, mark number, shipping line, name of vessel, supplier and product. 2. 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' - 'Costing Worksheet' - 'Maintain Worksheet'. 3 . In order to get more accurate average costing at the point of Stock Receipting, the Costing Worksheet allows the maintenance of associated importing costs. Each shipment can only have one costing worksheet. The costing worksheet will be finalised at the time of Goods Receipt based upon the quantity received; and the average cost will be updated based upon the costing worksheet total. 4 . When the option is used to create a new Shipment and then the 'Costing Worksheet' option is selected, the user is presented with the options of 'Maintain Worksheet' or 'Import Costs from CSV'. 5 . If you choose to import the worksheet then you will be prompted for the location and filename of the .csv file. The expected format is: ImportCode, 999999.99 ImportCode2, 9999.99 Each import code and amount on the worksheet will be on its own line within the csv file. The import code must be a valid import charges code that has been defined within ProStix or else an error report will be produced. It is assumed that the amounts imported are in the defined local currency. The worksheet header record and worksheet detail costing lines will be created for all lines successfully imported. It will then display the costing worksheet within ProStix as shown. The worksheet can then be maintained if you choose to do so. 6. Maintain Worksheet. If you choose to manually create the costing worksheet, then the header information is displayed. 7. If the shipment has attached purchase orders with products that have tariffs assigned to them (i.e. a tariff code indicated on the product's Master File Record, or at Product Group level), the duties will be calculated and displayed within the initial costing worksheet. For a new costing worksheet, only duties will be pre-populated on the import charges and amounts list. The duty amount will only be calculated when initially creating the costing worksheet. You will then have to add other import charges and estimated amounts onto the worksheet. 8. The menu on the right hand side gives you the following options: 9. Amounts on the costing worksheet can be in any currency. 10. There can only be one costing worksheet per shipment and thus the costing worksheet is referenced by the shipment number. 11. As charges and estimated amounts are added, updated or deleted, the import charges total within the status bar is updated to reflect the total amount of import charges on the costing worksheet. Note that this total does not include the stock purchases amount. Where the costing method of 'Mark' is chosen, a mark selection list will be displayed with an arrow indicating the marks that this cost is apportioned across. The same cost can be added across multiple lines on the Costing Worksheet to allow for different costs of the same type to be allocated to different Marks. 12. If there is an existing worksheet, the screens are displayed with the relevant information but the import charges screen is only in review mode. You have to select if you want to add, modify or delete the import charges within the costing worksheet. 13. The total displayed on the consignment header is derived from the total of all the purchase orders attached to the consignment and the currency code extracted from the local currency defined for the company. 14. Upon creation of the costing worksheet, the 'Creation Date' and 'Created By' fields need to be recorded with the 'Creation Date' being today and the 'Created By' field set to the user creating the worksheet. If the costing worksheet already existed and the user updates anything on the worksheet, the modified date and by fields are set to today and the current operator respectively. 15. Note that if the 'Finalised' flag is set to 'yes', the costing worksheet cannot be modified. On creation of a new worksheet, this flag is set to 'no' and you will not be able to change it. The flag can only be updated if you are returning back to the costing worksheet and it is the first field to be updated prior to you being able to view or modify the worksheet. 16. Finalise Worksheet allows you to change this flag from 'no' to 'yes'. 17.Recalculate Duties recalculates the duties after changes have been made. 18. Refresh to Defaults allows you to start the costing worksheet again, using the default container costs 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'. When these fields are first keyed, or later changed, the default costs are automatically copied across to the costing worksheet, unless the costing worksheet has already been changed from the defaults. Please note that importing charges with a type of 'duty' cannot be added to containers. 19. The default import costs may be overridden to accept any new costs based upon a user-defined factor. You may search and select a % of the cost of items on the shipment, a cost per cubic metre, linear metre or superfoot of the items on the shipment, or a total cost. If a method of 'total' is selected, you are prompted directly in the Estimated Cost field. The system will calculate the import costs using the conversion rate entered and if a BOL exists, the costs are to be apportioned by container (which is defined by a mark, not the container ID) and recorded in the container costs table. If you have entered the cost on the worksheet (rather than defaults) then the costs are divided across the containers by value or volume depending on the value of the 'ImpCstAvg' character flag. Please note that if 'ImpCstAvg' is set to 'volume' and a product has no volume assigned, then no cost will be assigned to it. Where the mark has had a container number keyed in then the full value of the container costs are assigned to each container. 20. A field Actual Cost is to record any costs received from a supplier invoice. The Actual Cost uses the exchange rate from the invoice. When the worksheet is finalised, the Actual and Estimated values are compared and if the difference exceeds a tailoring decimal value 'ImpCstVar', a warning is displayed to abort and review or proceed. The preference of apportioning Actual Costs or Estimated Costs is based upon the system flag 'ImpCstActl'. If this flag is set to 'yes' then the 'ImpCstVar' decimal is checked. The decision on actual versus estimate cost can be made on a line by line basis. We can only use the exchange rate of the FECs if the currency is the same as that entered in the costing worksheet. If the currency is not the same it uses the exchange rate from the estimate. After the worksheet is finalised, the display changes to show an additional column 'Applied'. If invoices are processed after finalisation they will be added to the actual column but the 'Applied' column is frozen at the point of finalisation. Review: You can now: Maintain the import charges associated with a shipment.