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

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

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

4. General Ledger -

• Add bulk upload template and function

• Bug fixed

Enhancement

5. Product Data - filter function fixed

Enhancement

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

-

2. Dashboard - Group P/L

• When select All Portfolios, it will exclude Default Portfolio

Enhancement

1. Physical Trades

• PS Ledger empty price value bug fixed

Enhancement

2. Admin Management - Add Group Name in table

Enhancement

3. Dashboard - Group P/L Chart

New Feature

-

4. Dashboard - Group P/L

• Click on All Portfolios to select all portfolios

Enhancement

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

1. Physical Trades - Remove Roll function in pricing page

Enhancement

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

2. Physical Trades - Remove Roll function in pricing page

Enhancement

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

1. Portfolio tree hierarchy structure updated

Enhancement

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

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

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

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

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

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

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

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

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