Page Comparison

1. New Physical Trades -

• Add rows per page field

• Purchase/Sale dropdown list, when selected, table will show all purchase/sale contracts accordingly; default will be empty which shows both purchase and sale contracts

• Add/Change new columns

  • Brand

  • BL No.

  • Loadport

  • LP ETD

  • Disport

  • LP ETA

  • Warehouse

  • Contract Tax Rate %

  • Contract Ccy: for those existing trade, if contract_ccy != pricing_ccy, show in red if cell have value, but still can save.

  • Actual Price Flag: logic: if actual price is not empty, show TRUE, otherwise FALSE; default is FALSE when add new trade; Make the text dark red when it shows “FALSE”/”否“

  • Pricing Contract

  • Contract Premium

  • TAX RATE(%)→ SETTLEMENT TAX RATE(%) 结算税率(%）

  • ACTUAL PRICE →SETTLEMENT PRICE 结算价格

  • ACTUAL QTY → SETTLEMENT QTY 结算数量

• Add summation function for all items with quantity and amount

• Changes to Actual Price: for those existing trade, if contract_actual_price != total_actual_price, show in red if cell has value, but still can save.

  • total_actual_price = benchmark actual price + premium actual price

• Highlight three columns:

  1. if pricing_id is not empty or null and

     1. if contract_actual_qty != actual_qty, show ACTUAL QTY in green

     2. if contract_actual_price != total_actual_price, show ACTUAL PRICE in green

     3. if contract_tax_rate != tax_rate, show CONTRACT TAX RATE in green

• WH NAME & STATUS column, show each warehouse’s qty balance; When the text is too long to show all content, the pop up ad will appear if user move the cursor here.

• FIXED PRICE column had the same logic as FIXED PRICE in bulk trades upload:

  • If there are value in FIXED PRICE cell, BM PRICING and PREMIUM will be empty.

• SETTLEMENT PRICE (old ACTUAL PRICE) logic:

  • if there are provisional price for the row and “AUTO AP” (mentioned below) are ticked, the value of it will be same as provisional price.

• Change the checkbox name “AUTO AP” to “AUTO P&Q” 自动设置价格/数量

  new logic:

  1. auto fill if contract_actual_price instead of provisional_price

  2. auto fill actual_qty if contract_actual_qty has value

• For all columns need to highlight green, set the following condition:

  Only when the PHY PRICING ID is filled

  Columns：CONTRACT CCY、ACTUAL PRICE、ACTUAL QTY、CONTRACT TAX RATE(%)

Enhancement

2. Change columns name in Settlement table:

• ACTUAL PRICE →SETTLEMENT PRICE 结算价格

• ACTUAL QTY → SETTLEMENT QTY 结算数量

• Delete Contract Qty column

• When AUTO P&Q is ticked, settlement price and settlement qty can’t be changed.

• only empty will auto fill up. if any value, do not auto-update.

Logic:

DEAL NO:

• if existing deal no is selected, MTM Pricing will be empty and not allowed to fill in.

BM Pricing

• If there are value selected, FIXED PRICING CCY will be empty.

• if BM pricing empty, settlement price (actual_price) must have value

MTM Pricing

• If existing deal no is selected, it will not allowed to fill in. If new deal no is selected, it must be filled in instead.

FIXED PRICE column (removed) :

• If there are value selected, BM PRICING and PREMIUM will be empty .

Kook Siong Thenplease remove FIXED PRICE column (removed) logic

FIXED PRICING CCY

Kook Siong Then new logic for fixed pricing ccy

• if fixed pricing ccy is empty, BM pricing must have value

• if BM pricing empty, fixed pricing ccy must have value

SETTLEMENT PRICE & SETTLEMENT QTY logic:

• if there are contract actual price for the row and AUTO P&Q are ticked, the value of it will be same as contract actual price.

SETTLEMENT TAX RATE:

• Only can filled in when TRADE MODE is not OFFSHORE or does not have BM Pricing filled in (if trade mode for the row is not OFFSHORE)

EX RATE/ CUSTOM TAX AMOUNT:

• Only can filled in when TRADE MODE is not IMPORT EXPORT

Enhancement

3. Settlement and Update Settlement table

• In both settlement and updated settlement tabs, add following columns existed in trades tab:
  PRODUCT
  ENTITY OF CONTRACT
  COUNTERPARTY
  PURCHASE/SALE
  TRADER

  Before CONTRACT NO.

  QTY
  CONTRACT ACTUAL QTY
  合同实际数量
  CONTRACT ACTUAL PRICE
  合同实际价格
  CONTRACT CCY

  Before BM PRICING in SETTLEMENT.
  Before SETTLEMENT QTY in UPDATED SETTLEMENT

  All columns link to TRADES tab, only TRADER is editable.

  Add FIXED PRICING CCY in UPDATED SETTLEMENT
  After SETTLEMENT PRICE
  no editable

4. General Ledger -

• Add bulk upload template and function

• Bug fixed

Enhancement

5. Product Data - filter function fixed

Enhancement