MAF CLOUD - NEW RELEASE + FIX UPDATES MAR 2023

1. New Physical Trades -

• PS Ledger

  • add additional information for CONTRACT NO. dropdown list:

    1、UN INV AMT （未开票金额） - invoice

    2、未收/付款 - PSL

    • un_inv = CONTRACT AMT - inv_amt

un_payment = CONTRACT AMT - payment_amt

any insert or update in PSL or Invoice table, will update inv_amt or payment_amt in phy_trade table

when dropdown list in PSL or invoice table, BE do calculate un_inv_amt or un_payment_amt, if it is close to 0, we filter out. coz those contract already fully settled.

be careful purchase, sales of contract and credit, debit of payment and invoice. sign is important here

FE need to keep update un_inv_amt or un_payment_amt if any contract selected before saving.

un payment amt should = contract AMT is payment_amt is empty. coz un_payment_amt = contract_amt - payment_amt(payment_amt from db)

contract_amt should be contract qty x price, which should be calculated in BE when select.

In 5 conditions FE should change the un payment in dropdown list of contract (before save):

1: Assign contract no to PSL

2: change the contract no (from A to B )

3: Delete the contract no

4: delete row with contract no

5: change psl amt with contract no

• the dropdown list be sorted by the latest contract date（DATE in TRADES tab) at the top of the list. after entering the customer name

  • Since it returns un payment,
    autofill AMOUNT with un_payment_amt calculated by BE in contract dropdown list in PSL when they choose the contract

  • in invoice table and psl table, inv_amt and psl_amt in Database should be always positive.

    we use ledger type to control the amt should be positive or negative.

    if split in psl into negative, I suggest we update ledge type to PAID (negative), RECEIVED (positive).

  • 1、dropdown list, when users choose the “Assigned(已分配） ”，table will show all PSL or invoice with contract no.
    when users choose “Unassigned（未分配）”, table will show all PSL or invoice without contract no.

     

    2、default：Unassigned，show all PSL or invoice without contract no

Enhancement

MAF-3672 - Getting issue details... STATUS MAF-3676 - Getting issue details... STATUS

MAF-3677 - Getting issue details... STATUS

MAF-3679 - Getting issue details... STATUS

2. New Physical Trades -

• Invoice

  • add additional information for CONTRACT NO. dropdown list:

    1、UN INV AMT （未开票金额） - invoice

    2、未收/付款 - PSL

    • un_inv = CONTRACT AMT - inv_amt

      un_payment = CONTRACT AMT - payment_amt

  • in invoice table and psl table, inv_amt and psl_amt in Database should be always positive.

  • we use ledger type to control the amt should be positive or negative.

  • if split in psl into negative, I suggest we update ledge type to PAID (negative), RECEIVED (positive).

  • Upload bug fixed

  • 1、dropdown list, when users choose the “Assigned(已分配） ”，table will show all PSL or invoice with contract no.
    when users choose “Unassigned（未分配）”, table will show all PSL or invoice without contract no.

 2、default：Unassigned，show all PSL or invoice without contract no

• In 5 conditions FE should change the un payment in dropdown list of contract (before save):

1: Assign contract no to PSL

2: change the contract no (from A to B )

3: Delete the contract no

4: delete row with contract no

5: change psl amt with contract no

Enhancement

MAF-3672 - Getting issue details... STATUS MAF-3677 - Getting issue details... STATUS

MAF-3678 - Getting issue details... STATUS

MAF-3679 - Getting issue details... STATUS

3. Demurrage Claims Table - In demurrage claims table, add a sentence to show how many rows have been updated when saved so user can tell immediately if more rows have been updated unintentionally

Enhancement

MAF-3681 - Getting issue details... STATUS

1. Company Data - Add new tab in company data management

Enhancement

MAF-3632 - Getting issue details... STATUS

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)

MAF-3665 - Getting issue details... STATUS

MAF-3666 - Getting issue details... STATUS

MAF-3667 - Getting issue details... STATUS

MAF-3668 - Getting issue details... STATUS

MAF-3669 - Getting issue details... STATUS

MAF-3673 - Getting issue details... STATUS

MAF-3674 - Getting issue details... STATUS

MAF-3675 - Getting issue details... STATUS

MAF-3652 - Getting issue details... STATUS

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

Enhancement

Demurrage Claims Table

MAF-3670 - Getting issue details... STATUS

3. Daily Statement bug fixed

Enhancement

MAF-3641 - 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

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

Enhancement

MAF-3652 - Getting issue details... STATUS

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

Enhancement

Creating New Physical Trade(s)

MAF-3654 - Getting issue details... STATUS

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)

MAF-3655 - Getting issue details... STATUS

MAF-3662 - Getting issue details... STATUS

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

MAF-3653 - Getting issue details... STATUS

MAF-3619 - Getting issue details... STATUS

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

MAF-3660 - Getting issue details... STATUS

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

MAF-3658 - Getting issue details... STATUS

8. New Physical - Add a new Invoice tab

New Function

MAF-3659 - Getting issue details... STATUS

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

Enhancement

MAF-3663 - Getting issue details... STATUS

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

Enhancement

-

MAF-3664 - Getting issue details... STATUS

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

Enhancement

Proprietary Market Data 101

MAF-3661 - Getting issue details... STATUS

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. 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