MAF CLOUD - NEW RELEASE + FIX UPDATES MAR 2023

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

Enhancement

New Physical Trades

MAF-3626 - Getting issue details... STATUS

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

MAF-3627 - Getting issue details... STATUS

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

MAF-3647 - Getting issue details... STATUS

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

MAF-3649 - Getting issue details... STATUS

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

MAF-3650 - Getting issue details... STATUS https://mafint.atlassian.net/browse/MAF-3645

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

Enhancement

New Physical Trades

MAF-3645 - Getting issue details... STATUS

1. Dashboard - New Daily Statement model

New Feature

MAF-3641 - Getting issue details... STATUS

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

MAF-3619 - Getting issue details... STATUS

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

MAF-3652 - Getting issue details... STATUS

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

MAF-3654 - Getting issue details... STATUS

New Physical - Add Settlement Remarks columns for Settlement tab and Updated Settlement tab

MAF-3655 - Getting issue details... STATUS

3.1.3

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

MAF-3653 - Getting issue details... STATUS

MAF-3619 - Getting issue details... STATUS

MAF-3657 - Getting issue details... STATUS MAF-3651 - Getting issue details... STATUS

1. New physical trade

• set error message when users try to delete contracts if the trade has stock management record; just as we set in PS Ledger: “PLEASE DELETE PS LEDGERS BEFORE DELETING PHYSICAL TRADE!”

• Edit quantity bug fixed, if Settlement Qty is Settlement page is input, Contract Qty cannot be edited. Have to remove Settlement Qty and

Enhancement

New Physical Trades

MAF-3638 - Getting issue details... STATUS

MAF-3643 - Getting issue details... STATUS

2. New Physical Trade - add new column in Settlement tab

add the “provisional price” in trades tab to settlement tab

before CONTRACT ACTUAL PRICE

not editable

Also, for AUTO P&Q function, now we only need to set qty. delete autofill price function here, change the name to “auto qty” Chinese: 自动设置数量

Enhancement

New Physical Trades

MAF-3639 - Getting issue details... STATUS

3. New Physical Trade - modify Highlight logic in updated settlement tab

For qty, now we set the rule as:

if the trade has contract actual qty

contract_actual_qty != actual_qty, show CONTRACT ACTUAL QTY in green

if the trade has only qty

qty != actual_qty, show QTY in green

Enhancement

New Physical Trades

MAF-3640 - Getting issue details... STATUS

4. Stock Management - right now, default qty for both sale and purchase is positive

If it's marked with P（purchase）, it will automatically be a positive number; if it's marked with （sale）, it will automatically be a negative number. Alternatively, we can add an option for outgoing/incoming, as it's a bit odd to have to enter negative numbers.

Enhancement

Stock Management Function

MAF-3642 - Getting issue details... STATUS

5. since no user is using, we will hide these pages

1. Op Cal in Paper Trade

2. Exotic Trade

Enhancement

MAF-3646 - Getting issue details... STATUS