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

组别盈亏 Group P/L App - 用户指南

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

1. Physical Trades

• PS Ledger empty price value bug fixed

Enhancement

New Physical Trades

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

2. Admin Management - Add Group Name in table

Enhancement

Admin Management

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

Group P/L

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

New Physical Trades

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

1. Physical Trades - Remove Roll function in pricing page

Enhancement

Managing Physical Trades

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

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

New Physical Trades

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

2. Physical Trades - Remove Roll function in pricing page

Enhancement

Managing Physical Trades

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

1. New Physical Trade -

• Shifted PS Ledger tab from old physical trade to new physical trade

• Change Cargo Ops ID to Execution ID in Settlement tab

Enhancement

New Physical Trades

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

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

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

1. Portfolio tree hierarchy structure updated

Enhancement

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

2. New Physical Trades - Trades

Will be linked to old physical trades page

• Empty Trade ID bug fixed

• Deal ID in old phy trades table will be empty for trades created in New Phy Trades table bug fixed

• Disable Actions button in old phy trade table for trades created in New Phy Trades table

• All fields will be displayed once saved

• Purchase/Sale items should not allow add new tag and dropdown list bug fixed

• Translations added

  • Product = 产品

  • Cat = 品种

  • New Physical Trade 新现货合同

  • Exchange conversion date = “购汇日期“.

  • Phy pricing id =”价格编号

• Deal No. auto map to Settlement Currency

• If have Physical Pricing ID, must have Deal No.

• Add Created by, Last Updated by and Time

• only for IMPORT/EXPORT, CUSTOM TAX and EXCHANGE RATE fields will be applicable for inputting - Logic is similar to Bulk Trade Upload

• Add Main Contract No. column

• Add Actual Qty and Actual Price columns

New Feature

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

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

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

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

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

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

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

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

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

3. New Physical Trades - Settlement

• To save trades, tick the checkbox of the trade and click on Save Changes

• When save, pricing will link to its Trade Execution

• Trade mode missing and Deal ID bug fixed in old phy trade table

• Add Main Contract No. column

• Add Trade Execution No. column

• Add AUTO TTD tick box, will auto fill Title Transfer Date according to Trade Date

• Exchange rate in New Physical Trades linked to old physical trade value bug fixed

New Feature

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

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

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

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

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

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

4. New Physical Trades - Updated Settlement

• Trade ID duplicated bug fixed

• Premium, Trader and Custom Tax Rate return bug fixed

• Trader should be auto linked to Trade table

• Actual Price update bug fixed

• Allow add, edit and delete Premium, if Pricing Mode = Fix, no Premium can be input

• Add Exchange Conversion Date

New Feature

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

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

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

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

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

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

5. Physical Trades - PS Ledger

• Trades created in New Phy Trade table will be available under Contract No. in PS Ledger

• Add Main Contract No. column

• Missing Unit and Price Unit bug fixed

Enhancement

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

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

6. Stock Management -

• When selecting Contract No., Quantity will capture Contract Quantity value, if Actual Quantity value is available, it will capture Actual Quantity value

• Warehouse name bug fixed

Enhancement

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

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

7. Physical Trades - Bulk Trades Upload

• if select existing deal no., deal id and deal ccy will auto appear and are uneditable

• if select new deal no., deal ccy is must and will be editable

Same logic for New Physical Trades - Settlement table

Enhancement

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

8. Delete in table

• Allow delete of cell of dropdown list item in table directly instead of double clicking to delete

• Delete in dropdown list bugs fixed

Enhancement

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

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

9. Physical Trades

• Deal tab bug fixed

  • Old bulk insert and update do not support exchange rate date; only new settlement insert and update do; only trade with trade mode == import/export is allowed to have ex rate date.

Enhancement

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

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

1. Physical Trades - Physical trade page Deal ID bug fixed

• to add new physical trade,

  • choose existing deal no, deal id should be assigned and disabled edit.

  • deal currency should be assigned and disabled edit as well.

  • for new added deal no, deal currency should be able edit. deal id should be empty and disabled edit.

Enhancement

Managing Physical Trades

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