Shipment Load Tracking

Added changes to the functionality to track ordered Item delivery. User is able to track Shipment, Booking, Delivering, Arriving, Receiving Items.  For this opportunity has been added the following changes and improvements:

• Renamed “Container load tracking” to “Shipment Load Tracking” for all related buttons, forms, panels, etc

“Create SLT” button

• if were selected orders from different stores then the message will be displayed: “You cannot create Shipment load tracking for POs from different stores”
• if were checked POs for which had been created Item Receipt then after clicking on the button, the message will be displayed: “SLT order could not be created for PO if Item Receipt has been added”

“Shipment load tracking” edit form

• Renamed “Vendor” drop-down to “Shipper”
• Renamed CLT # to “Reference #”
• Statuses: Draft, Booked, Departed, Arrived, Received
• Added fields: Booking #, Est. Departure Date, Est. Arrival Date, Scheduled Delivery Date, Export Port, Import Port, Container Size, Container #
• Excluded fields: Follow up Date, Ship Date, Release Date, Vessel Arrival Date, Arrived Date, Store, Name/Address, Terms & Conditions
• Datagrid. If items with the same Name/Description/UOM/Cost were added to the SLT then Items should not be merged in one line item
• Added columns:
  • Qty/Carton. Qty/Carton = “Shipment Qty” / “Total/Cartons” .  
  • Total/Cartons. Total/Cartons = “Shipment Qty” / “Qty/Carton”

• Excluded columns: Received Qty, UOM
• Сopy logic for Units Qty/Carton / Total/Cartons
  • if Shipment Qty on SLT = Total Units on IR then Total/Cartons and Qty/Carton will be copied from SLT to IR

• • if Shipment Qty on SLT > Total Units on IR then
    • Qty/Carton should be automatically copied to the IR to Units Per case
    • Number of cases should be recalculated on IR based on the Units Per case
• CBM. CBM = qty * item weight (taken from the Item base dimensions)
• Bill #. After clicking on the number, corresponding  edit form will be opened
• COGS. COGS = Shipment Qty* Price from PO
• Landed Cost. Landed Cost = (Landed Cost amount from PO) / (Shipment Qty)
• Total / Item. Total / Item = (COGS / Shipment Qty) + Landed Cost
• Totals
  • Shipment Qty. Shipment Qty = sum (Shipment Qty). Displayed if all Items dn’t have UOMs
  • Total/Cartons. Total/Cartons = sum (Number Of Cartons)
  • CBM. CBM = sum(CBM)
  • COGS. COGS = sum(COGS)
  • Landed Cost. Landed Cost = sum(Landed Cost)

“Container load tracking” list form

• Filters:
  • Order Statuses: Draft, Booked, Departed, Arrived, Received
  • Reference #. Search SLT by SLT #
  • Shipper
  • Booking
  • Container Size
  • PO#
  • Item
  • Export Port
  • Import Port
  • Vendor
  • Estimate Departure Date
  • Est Arrival
  • Scheduled Delivery Date
• Datagrid
  • All columns are the same as Filters mentioned above

Import/Export Port, Shipment Container size dictionaries

 

• Port. New dictionary is added to the Top menu. User is able to delete only Ports that havn’t been used in the system previously
• Shipment Container size. New dictionary is added to the Top menu. User is able to delete only Container sizes that havn’t been used in the system previously.

Purchase Order

“Save & Receipt” / “Save & Create Receipt / Bill / Invoice” button is disabled if to PO linked at least one SLT order. It isn’t allowed to create IR if SLT already has been created.