Update Fields for Virtual Group

From UG

Contents 1 General 2 Business Requirements 3 Solution 3.1 Figure 1 3.2 PT DT counter 3.3 Updating PT and DT fields 3.4 List of fields to Update

General

• mantis http://mantis.jaguarfreight.com/mantis/view.php?id=1910

Business Requirements

Field updates must be automated.

Solution

Figure 1

• On OK system must confirm that action has been taken
• fields will be updated with new values in every CT in the virtual group

PT DT counter

This is an independent counter in the systems. It starts with 1. Next number is 2 and so on. It is used to automate assignments of CT#PT Number or/and CT#DT Number

Updating PT and DT fields

User have choices:

• 1) enter numbers manually
• 2) click "PT only" button. In this case system will:
  • generate next number from #PT DT counter
  • prefill PT number textbox with it (see #Figure 1)

• 3) click "DT only" button. In this case system will:
  • generate next number from #PT DT counter
  • prefill DT number textbox with it (see #Figure 1)

• 4) click "PT and DT" button. In this case system will:
  • generate next number from #PT DT counter
  • prefill PT number textbox and DT number textbox with it (see #Figure 1)

List of fields to Update

• CT#PT_Number
• CT#DT_Number
• CT#Estimated Export Pick Up Date
• CT#Actual Pick up Date
• CT#Estimated Delivery Date
• CT#Actual Delivery Date
• CT#Pick up Trucker
• CT#Delivery Trucker