EXCHLOTS is an ITAS option to reorganise stock records into ‘lots’ as agreed with the Exchange and a Warehouse.

The screen consists of 2 grids and 2 filter buttons.
The 1st filter button is general selections (e.g. terminal, commodity) and is locked once entered.
The 2nd filter button may be selected multiple times during the process (e.g. contract no. warrant), it works in addition to the 1st filter button and fills the top grid.

Quantity and Bags are selected in the top grid.
Quantity is defaulted from entry of bags.
Entry of lower quantity splits the line i.e. creates a new row of the residue which is not selected.

A lot is built up by selections in the top grid.
When the lot is complete the user clicks the 'Bank' button.
This opens a sub screen, prompts for Lot ref and warrant (both mandatory) and moves the selected items from the top grid to the bottom grid.
There is also be a button to move items back to the top grid in case of erroneous entry.

The user may then select more stock as above using the 2nd filter button, thus building up all lots in the lower grid.
Note residual stock i.e. that partially selected in a prior 'bank' will be available for another lot.

Once all required items have been lotted the Main Save button is clicked.
This will split the selected stock items (even if this means the selected split will come down to zero quantity). The new splits will have the new lot ref and warrant. They will also have a ‘Bank’ id (phys01_exchlotbankref - the unique id for the 'Bank' function') and a process id (phys01_exchlotprocref -  the unique id for the entire process). The Ids are for trace and reverse.

There is a reverse process where either a bank id or process id may be selected. This will merge those splits onto their parent.

There is an ‘Exchange Lotting Report’ report in TRADE.