MAF CLOUD - NEW RELEASE + FIX UPDATES NOV 2022

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

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

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

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

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

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

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

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

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

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

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 .

please remove FIXED PRICE column (removed) logic

FIXED PRICING CCY

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

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

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

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

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

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

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

4. General Ledger -

• Add bulk upload template and function

• Bug fixed

Enhancement

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

https://mafint.atlassian.net/browse/MAF-3535 https://mafint.atlassian.net/browse/MAF-3534

5. Product Data - filter function fixed

Enhancement

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

1. Dashboard - Group P/L Chart

• Add Scope above Series Keys and in chart

• UI enhancements

• Add loading icon

• Translations added

  • Group P/L Chart: 组别盈亏曲线

  • Series Key: 分组依据

  • Scope：范围

Enhancement

-

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

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

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

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

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

2. Dashboard - Group P/L

• When select All Portfolios, it will exclude Default Portfolio

Enhancement

https://mafint.atlassian.net/wiki/spaces/MCUGC/pages/1952120833

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

1. Physical Trades

• PS Ledger empty price value bug fixed

Enhancement

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

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

2. Admin Management - Add Group Name in table

Enhancement

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

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

3. Dashboard - Group P/L Chart

New Feature

-

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

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

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

4. Dashboard - Group P/L

• Click on All Portfolios to select all portfolios

Enhancement

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

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

1. New Physical Trades - Add Auto AP tick box, if ticked, Actual Price in Settlement tab will be auto filled based on Provisional Price in Trades tab

Enhancement

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

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

1. Physical Trades - Remove Roll function in pricing page

Enhancement

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