Page Comparison

1. Proprietary Market Data - Upload file and it shows loading bug fixed

Enhancement

1. New Physical Trades -

• Upload invoice bug fixed

• Price Before Tax bug fixed

• Map Unit when upload invoice

• Upload PS Ledger bug fixed

• PS Ledger

  • Hide MAIN CONTRACT NO. , QTY, PRICE, UNIT, PRICE UNIT, RATIO columns

  • COUNTERPARTY and AMOUNT should not be editable after saving (they can only edit these when split)
    Change chinese translation for Third party: 第三方 to 收/付款

  • Counterparty should not be compulsory

  • When COUNTERPARTY ≠ THIRD PARTY, highlight COUNTERPARTY green

  • When filter Trade tab in new physical trades by product, add new row will appear in the table automatically

• Filter all green highlight columns in UPDATED SETTLEMENT

  • Add new checkbox in UPDATED SETTLEMENT

    FILTER T≠S Chinese: 筛选 结算≠合同

    When the user tick the check box，table will only show rows with green highlight

• Group P/L when click Save bug fixed

Enhancement

Creating New Physical Trade(s)

2. Demurrage - Audit Trail missing Created by and Updated by Name

Enhancement

Demurrage Claims Table

3. Daily Statement bug fixed

Enhancement

1. Dashboard - New Daily Statement model

New Feature

-

2. PS Ledger -

Currently, users input payment and invoice information in the same tab, we need to split them into two tabs and add some new functions.

1、For PS LEDGER tab, set PSL TYPE as PAYMENT default and can’t be modified.

2、Add upload csv file function, plz refer to the attached file.

• I have highlight all the required information

• DATE = 交易日期时间

• COMPANY = 账户名称

• COUNTERPARTY = 对方户名

• LEDGER TYPE: if amount is on “借” column，LEDGER TYPE = RECEIVED; if amount is on “贷“ column，LEDGER TYPE = PAID

• AMOUNT = amount on ”借“ or ”贷“ column

• CCY = 币种

Enhancement

New Physical Trades

3. Dashboard - Group P/L: when click Save, bug fixed

Enhancement

4. New Physical Trades - For formulas, once remove value for one factor, the other will be excluded

Enhancement

Creating New Physical Trade(s)

5. New Physical Trades -

• Add Settlement Remarks columns for Settlement tab and Updated Settlement tab

• Price before Tax column filter bug fixed

Enhancement

Creating New Physical Trade(s)

3.1.3

6. PS Ledger -

• Add new Bank column

• PSL TYPE as PAYMENT by default and can’t be modified

• Do not fetch CCY, user can select the currency and the currency in all rows uploaded will be autofilled accordingly

• Allow upload of file, amount will not be editable

• Delete Invoice No.

• Bank column duplicated values in drop down list fixed

• After they upload files, for each PS Ledger, we allow them to split:

  1: add a “split” button in PS LEDGER tab, once click, pop up a window similar as “Group trades”

  2: for each PSL，they can split to many items.

  for each grouped row in right side，copy all the columns at left side

  once users choose the contract no, leave qty、price、amt blank (users key by themselves)
  after key the qty and amt, system calculate the price

  Validations: 1、check total amt of grouped rows (left = right)

  2、ccy of each should be same

• since they can split the PSL, sometimes payee ≠ counterparty, we can add a new column to show the counterparty when they choose the contract

Enhancement

7. New Physical Trade - Now set SETTLEMENT AMT BEFORE TAX as(both in settlement and updated settlement):

if trade mode = offshore, import/export :

SETTLEMENT AMT BEFORE TAX = PRICE BEFORE TAX * SETTLEMENT QTY + CUSTOM TAX AMOUNT (If or else = 0）

all other trade modes are just as original：

SETTLEMENT AMT BEFORE TAX = PRICE BEFORE TAX * SETTLEMENT QTY

Enhancement

8. New Physical - Add a new Invoice tab

New Function

9. Dashboard - Open Positions Details and Position Matrix app bug fixed

Enhancement

10. Group - Allow user to create up to 10 groups for free trial accounts

Enhancement

-

1. Proprietary Market Data - Upload file and it shows loading bug fixed

Enhancement

Proprietary Market Data 101

1. New Physical Trades tab - For Chinese version, there is no contract amt when ACTUAL PRICE FLAG = TRUE bug fixed

Enhancement

New Physical Trades

2. New Physical Trades - Settlement tab - adjustment to calculation formulas

• PRICE BEFORE TAX = SETTLEMENT PRICE /(1+SETTLEMENT TAX RATE(%))

• if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE /(1+SETTLEMENT TAX RATE(%))

• SETTLEMENT AMT BEFORE TAX = SETTLEMENT AMT /(1+SETTLEMENT TAX RATE(%))

Enhancement

New Physical Trades

3. New Physical Trades - Updated Settlement tab - can edit Settlement Tax Rate

check

1. old physical trade pricing page

2. old physical bulk update table

3. new physical updated settlement

4. check tax rate validation. e.g, offshore should not have tax rate.

5. check if multiple update successfully

6. check pl is updated correct after multiple update tax rate.

Enhancement

New Physical Trades

4. New Physical - Settlement and Updated Settlement:

a. Change formula for PRICE BEFORE TAX:

• if trade mode = offshore:

PRICE BEFORE TAX = SETTLEMENT PRICE, if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE

• if trade mode = import/export or offshore-cross ccy:

PRICE BEFORE TAX = SETTLEMENT PRICE * EXCHANGE RATE /(1+SETTLEMENT TAX RATE(%)), if no SETTLEMENT PRICE, PRICE BEFORE TAX = ESTED.PRICE *EXCHANGE RATE /(1+SETTLEMENT TAX RATE(%))

• all other trade modes are just as original.

b. Now set SETTLEMENT AMT BEFORE TAX: SETTLEMENT AMT BEFORE TAX = PRICE BEFORE TAX * SETTLEMENT QTY

Enhancement

New Physical Trades

1. New Physical Trade -

• CONTRACT PRICE BEFORE TAX

after CONTRACT ACTUAL PRICE

Chinese: 合同不含税价格

CONTRACT PRICE BEFORE TAX = CONTRACT ACTUAL PRICE/(1+CONTRACT TAX RATE(%))
if no CONTRACT ACTUAL PRICE, use PROVISIONAL PRICE

• CONTRACT AMT BEFORE TAX
  after CONTRACT AMT

Chinese: 合同不含税金额

CONTRACT AMT BEFORE TAX = CONTRACT PRICE BEFORE TAX * CONTRACT ACTUAL QTY

If no CONTRACT ACTUAL QTY, use QTY

• CONTRACT TAX AMT

after CONTRACT AMT BEFORE TAX

Chinese: 合同税额

CONTRACT TAX AMT = CONTRACT AMT - CONTRACT AMT BEFORE TAX

Enhancement

New Physical Trades

5. The prices of Guangzhou Futures Exchange（GFEX) have not been updated for two days bug fixed

Enhancement

New Physical Trades