MAF CLOUD - NEW RELEASE + FIX UPDATES MAR 2023

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

https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/181502045

https://mafint.atlassian.net/browse/MAF-3665

https://mafint.atlassian.net/browse/MAF-3666

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

Enhancement

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

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

5. New Physical Trades -

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

• Price before Tax column filter bug fixed

Enhancement

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

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

Enhancement

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

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

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

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

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

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

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

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

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

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

1. Op Cal in Paper Trade

2. Exotic Trade

Enhancement