MAF CLOUD - NEW RELEASE + FIX UPDATES MAR 2022

1. Stock Management

• Copy and paste data with spacing/break line issue fixed

Enhancement

-

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

2. Dashboard - Physical Trade Status

• Translation for dropdown list will auto convert accordingly

• Multiple filters for 0 fixed

Enhancement

-

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

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

3. Sign up - Email verification email will last for 60 mins before expiring. User can relogin and a new verification email will be sent

Enhancement

-

4. Dashboard - Portfolio P/L Details label for Contract Year fixed

Enhancement

-

1. Physical Trades -

• PS Ledger: Ratio is saved inconsistently bug fixed

• Bulk Trade Upload: Dropdown list has [object] bug fixed

Enhancement

2. Dashboard - Physical Trade Status: Columns with 0 should not be highlighted in red

Enhancement

-

1. Physical Trade - PS Ledger: Ratio displayed is inconsistent bug fixed

Enhancement

1. PS Ledger - Added ? icon next to Ledger Type with the message:

Select RECEIVED if amount is received from counterparty

Select PAID if amount is paid to counterparty

Amount will always be positive value (+)

选择收款如果收到的金额来自于对手方

选择付款如果金额是支付给对手方

金额必须是正值 (+)

Note: Other logic is applicable:

• If “PSL Type” is “Payment”:

Purchase, + Amount = PAID
Purchase, - Amount = RECEIVED
Sale, + Amount = RECEIVED
Sale, - Amount = PAID

• If “PSL Type” is “Invoice”: If the invoice is paid, “Ledger Type” will be PAID

• 如果“账类别”是“款项”：

采购, 正数量 = 付款
采购, 负数量 = 收款
销售, 正数量= 收款
销售, 负数量 = 付款

• 如果“账类别”是“发票”：如果发票已付款了，”分类账种类”是 PAID

Enhancement

2. PS Ledger - Ratio can be input in % form, eg 100% and the system will calculate accordingly by returning in decimal form to BE

Enhancement

3. General Ledger - Added ? icon next to Amount with the message:

Please input negative sign as necessary:

If Type is Inc or Fund In: +

If Type is Exp/Fund Out: -

If Type is Init Fund: + or -

Eg If Type is Exp, amount will be -1000

请根据您的需要输入负号:

• 如果类型是 Inc 或 Fund In: 金额是正数 (+)

• 如果类型是 Exp 或 Fund Out: 金额是负数 (-)

• 如果类型是 Init Fund: 金额是正数 (+) 或 负数 (-)

• 例如：如果类型是 Exp， 金额将会是 -1000

Enhancement

4. Trade>Stock Management

• Copy and paste negative values in Qty will not cause summary of quantity to be NaN

• Match ID’s Bal Qty amount will be auto updated for convenience once Match ID has been selected

• Match ID dropdown list will show selected Match ID’s details

• If never key ratio, Amount calculation will be according to 100%

Enhancement

-

5. Dashboard - Inventory Stock Type Details

• No auto-grouping of Stock Type column by default

• Add Trans Supplier after WH Name column

• Add WH Entity column before WH Name column

• When use Physical Product filter in Settings, it will show selected products in table if available

Enhancement

-

6. Dashboard - Physical Trade Status

• Settled Inv Amount and Settled Inv Qty have swopped places

• Summary values have been added for all columns with numbers and master rows

• Unsettled Amt and Contract Amt can be empty as Actual Price is not filled so we do not know the value of the contract, this allows user to monitor if the contract has Actual Price or not

Enhancement

-

1. Dashboard/Physical Trade - New App: Physical Trades Status 现货合同状态

• Settings

1. START DATE

   1. default is 1st day of current year

   2. must item

   3. date

2. END DATE

   1. default is today

   2. must item

   3. date

3. AUTO UPDATE:

   1. auto update END DATE only

   2. tick

   3. default tick

4. CARGO TRANSFER RULE / 货权转移准则

   1. dropdown list in dashboard metadata

   2. key is inventory_rules

   3. single select, default is WAREHOUSE

   4. must

5. CHECK ITEMS

   1. dropdown list in dashboard metadata

   2. key is phy_payment_rules

   3. multiple select

   4. default is empty

6. SELECT GROUP

   1. dropdown list in dashboard metadata

   2. phy_status_group

   3. single select, default is UNSETTLED

   4. must

New Feature

-

2. Dashboard/Physical Trade - New App: Inventory Stock Type Details/库存类型详细

• Qty is derived from the Quantity in Stock Management table; can use group rows to check and add up all the quantity to tabulate

New Feature

-

3. Trade>Stock Management

• Enable grouping for Stock Details table

• Add COD DATE/卸货结束日 column : COD DATE (completion of discharge date) is used to monitor if transportation has been completed. It is a key field to calculate how many qty is still in transportation, which will be linked to a new app coming soon

  1. after ETA NOTE

  2. date format

  3. not must item

• Change to dropdown list for Stock Action

• Add To WH Name column after Stock Action column

  • Show WH ID, WH Entity and WH Name

• Add Transportation Supplier column after To WH Name column

  • Dropdown list

• Change to dropdown list for Match ID

  • Shows Stock ID, WH Name, Qty and Bal Qty

• Removed WH ID and Phy Trade ID columns

• Match ID:

  • Will only be editable if the Qty is negative, regardless of whether Scope is Internal or External; if qty is positive, disable edit match ID.

  • Dropdown list format to allow you to view auto-updated Bal Qty after matching stock out quantity with stock in quantity for convenience

• Sum up group master row and Qty, Bal Qty and Cost Amt; and summary row

  • After clicking on Qty, summed Qty in master row will not disappear

  • After grouping the rows and editing the table, the rows will remain expanded for convenience

Enhancement

-

4. Physical Trade - Added Contract No. in all pages in the physical trade details page

Enhancement

5. Login page - Allow user to choose to show password for convenience

Enhancement

-

6. Physical Trade Mode - Translation changed for Physical Trade Details table/page and bulk trade upload

1: 'OFFSHORE', 离岸

2. 'DOMESTIC CHINA', 内贸

3: 'DELIVERY CHINA', 交割

4: 'IMPORT/EXPORT', 进出口

5: 'BASIS TRADE CHINA', 基差

• When upload file with Chinese Trade Mode, if the system is in English, Trade Mode will be displayed in Chinese as per normal; and vice versa

Enhancement

7. PS Ledger Enhancements

1. delete columns:

   1. INVOICE DATE

   2. INVOICE PRICE

   3. INVOICE QTY

   4. INVOICE AMT

2. add a column:

   1. after DATE

   2. PSL TYPE/账类别

   3. dropdown list, psl_type

   4. addtag, check validation

   5. store value, show label

   6. must

3. psl_type, ledger_type follow local language

   1. ledger_type should have Chinese

   2. psl_type:

      1. PAYMENT: 款项

      2. INVOICE: 发票

8. General Ledger Enhancements

1. add columns in table

   1. INVOICE NO / should have Chinese already

      1. map to invoice_no

      2. after INVOICE AMT

      3. text

   2. TAX RATE (%) / should have chinese already

      1. map to gl_tax_rate

      2. after INVOICE NO

      3. number, default decimal point

      4. value should be divided to 100 to BE (e.g., 16 in table, but to BE it is 0.16, just like tax rate in phy trade page)

   3. GL DETAILS / 款项详细

      1. map to gl_details

      2. after DESCRIPTION

      3. tex

2. change key from wh_entity to gl_cp

   1. label change from WH ENTITY to GL CP / 款项对方

9. Mobile Web - You will be able to access the mobile version of MAF Portal on your mobile phone. It will only consist of Group Dashboard function for ease of viewing of the models/reports shared by and with group members.

Enhancement

-

10. Dashboard - Physical Trade Inventory: Removed Inventory Rule in Settings

Enhancement

1. Physical Trade - New columns added

a. Add Delivery Rule 交货准则

• Trade Page

  • After Q+Q field

• Trade Table

  • Before Remarks field

  • Can be editable directly in table

b. Add Pricing Date 点价日 and Pricing Contract 点价合约

• Execution Page

  • After Custom Tax Amount

• Execution Table

  • After Contract No. field

  • Can be editable directly in table

• Bulk Trade Upload Table

  • After Delivery Rule

New Feature

2. Physical Trade Execution Table -

a. These columns can be editable:

• Execution No.

• Counterparty Ref No.

• Spec

• Payment Date

• Remarks

• Port/WH Name

• Inco Term

• Delivery Rule

• Doc Date

b. Trade Recap section in trade execution will be removed

c. Warehouse details such as WH Name, WH Date etc will be removed as they will appear in the Stock Management page

Enhancement

3. Physical Trade Table - These columns can be editable in physical trade table and available in Bulk Trade Upload table

• Spec 质量标准

• Port/WH Name 交货地

  • Changed label from Port/Country

  • Changed to dropdown list in phy trade table

• Incoterm 交货方式

• Delivery Rule 交货期限

• Doc Date 原件归档

• Company Name (not available in bulk trade upload table)

Enhancement

4. Company Data - Warehouses - Add Warehouse Entity Column 仓储公司 before WH Name

• 1 Warehouse Entity could have multiple Warehouse Name

• Warehouse Name can be exactly the same for different Warehouse Entity

• Compulsory item to fill

• Combination of Warehouse Entity and Warehouse Name should be unique.

New Feature

5. General Ledger

• Change header of WH Name to WH Entity

Enhancement

6. PS Ledger

• Change PHY EXE NO. to CONTRACT NO

  • In dropdown list:

    • Phy exe no. change to Contract No.

    • Execution ID change to Phy Trade ID

• Price unit will always be combination of CCY/UNIT

• Switch column position INVOICE QTY and INVOICE AMOUNT

• Add two more columns:

  1. RATIO

     1. before AMOUNT

     2. non-neg numbers

     3. decimal no limitation

  2. INVOICE PRICE

     1. before INVOICE QTY

     2. number format

     3. phy trade price decimal

• New formula:

  1. AMOUNT = QTY * PRICE * RATIO

  2. INVOICE AMT = INVOICE QTY * INVOICE PRICE

• When input data, 1st new row in table will be last row in list to BE (need to to reserve sorting first)

• When delete physical trade with PS Ledger items, pop up message will appear (repeated message has been removed)

• Using tab or enter key on keyboard will allow auto calculation of

  • AMOUNT = QTY * PRICE * RATIO

  • INVOICE AMT = INVOICE QTY * INVOICE PRICE

New Feature

7. Bulk Trade Upload -

• File upload will remove those “unnecessary” data (no change to current logic)

• Copy paste (ctrl + shift + v or ctrl + v) will show keep those “unnecessary” data indicated in red

Enhancement

8. Trade>Stock Management page

1. Added a new subpage under Trade (after Physical Trade) from the navigation sidebar on the left called Stock Management 库存管理

2. in the page, add tab

   1. name: STOCK DETAILS 库存明细

3. tab details

   1. same as PS LEDGERS, but after TO (date), add PHYSICAL PRODUCT

      1. single select now

      2. not must item, could be empty

   2. start date default 1st date of current year

   3. end date can not belong today, default today

   4. PHYSICAL PRODUCT default empty

   5. Bal Qty must have number (either positive or negative value) or 0

• SCOPE is used to identify if the record is from/to external party (real delivery) or action internally. it will be used for calculating how many stock in/out from/to external party.

  • Acope:

    1. external if any buy or sell with external party

    2. else, internal

• Match ID:

  • All stock out will match to stock in row, then stock in should have bal qty

  • All stock in must have bal qty; if no, means bug

New Feature

-

9. Physical Trades - bugs fixed:

• Cannot use Bulk Exe Update function

• Cannot Duplicate Trade

• Cannot use AUTO TTD in trade execution table

• Pricing Date is missing after update eg update bulk exe

Enhancement

1. Demurrage - 0.00 will appear at the top of the filter list for all amount columns such as in demurrage claims table, offset list and archive table

Enhancement

1. Bulk Trade Upload -

• If copy and paste (ctrl v or ctrl shift v) rows from Excel into the table, the Deal ID should not be empty if Deal No. already exists (therefore Deal ID should exist too)

• No issue if upload the file, deal ID will appear accordingly

Enhancement

1. Portfolio - All inactive portfolios can be renewed with valid licence by clicking on the “Activate Now” button in the view portfolio table

Enhancement

2. Physical Trade - Bulk Trade Upload:

• If upload file or copy and paste data with both benchmark pricing and fixed price, both values will be uploaded as per normal but benchmark pricing should be in red to signify that only either benchmark pricing or fixed pricing can exist at the same time

• If copy and paste date from Excel, the dates pasted in system will be in correct format

• Add “Provisional Price” column after “Estimated Price”

  • Not compulsory item

  • Number format, Decimal point will follow “Physical Price Decimal Point”

Enhancement

3. Physical Trade - Trade Execution:

a. Enable “Provisional Price” column to be editable in the table directly (before Actual Qty)

• Not compulsory item

• Number format, Decimal point will follow “Physical Price Decimal Point”

Enhancement

4. Translation for Company Data “Save” button and Group Member Access Permission Setting updated

Enhancement

-

5. Physical Trade:

• Delete trade error message fixed

• Delete Trade Execution label changed to Delete Row, button will not be overlapped by other buttons

Enhancement

6. Physical Trade - PS Ledger:

• Company Name did not appear for some accounts bugs fixed

Enhancement

1. Product translation in physical trade function has been changed to 产品

Enhancement

-

2. Group Ownership Transfer Enhancement

• Group Owner A creates Company (Company Profile) and creates a group which is auto under the company

• Group Owner A transfers group ownership to other user (Group Owner B) in the group

• Group Owner B removes Group Owner A from the group

• The group will still be under the Company that Group Owner A sets up

Enhancement

3. Group Remove Member Enhancement for Portfolio

• Old logic:

  • if a group member has been removed from group, if the member has portfolio data, the portfolios will be transferred to any member of the group, and portfolio’s status will become invalid, any licence from portfolio will be removed

     

• New logic:

  • if a group member has been removed from group, if the member has portfolio data, the portfolios will be transferred to any member of the group

  • Changed part: if the portfolio is generated from member under free trial status (which means no linked licence), then the portfolios will still be valid. For the portfolios linked to licence, it will follow old logic

Enhancement

1. Groups - Change Group Ownership: Current status of existing group owner will apply to the new group owner when transferring group ownership:

• If user is under Free Trial status, when user transfers group ownership to another user, no licence is required and the group’s owner will be auto updated to the new group owner

• If user is under Active status, when user transfers group ownership to another user, a licence is required and the new owner will require a licence to activate the group before officially becoming the group owner of the group

Enhancement

2. Settings - Layout Settings Grouped Rows Colour: Add Reset button to reset colours to default

Enhancement

1. Dashboard - Futures Account:

• Added Cut Off Date in Settings to allow you to input the cut off date to calculate the change in amount from End Date to Cut Off Date

• Added Change Amount column after Amount column to reflect the change in amount from End Date to Cut Off Date

• Cut Off Date cannot be after Settlement Date

• Eg if want to see total amount for 2022, you may choose Cut Off Date as 31/12/2021

Enhancement

2. All translations of similar English words will be auto updated if one has been changed

Enhancement

-

1. Company Data - Entity Management Table: Added CREDIT CCY after CREDIT AMOUNT column. If CREDIT CCY is input, CREDIT AMOUNT must be input and vice versa

Enhancement

2. Dashboard -

• Chinese translation for dropdown lists in apps' settings have been added

• Dashboard - When click on “Open In New Window”, the titles of the models in Dashboard will appear

Enhancement

1. Dashboard - Historical Group P/L is now available:

• Similar to Group P/L but without:

  • Compare Date

  • Default group is Settlement Date

  • Historical GPPL

  • Excl T Plus

• You can add “Days” in Settings which refers to the maximum days to display eg 30 refers to 30 days maximum displayed for settlement days. Otherwise, it will display whole year records which will slow down the performance of the app.

New Feature

2. Dashboard - Group P/L: If click on Save, grouped rows will not be ungrouped

Enhancement

1. General Ledger - Add WH Name (仓储名称), Invoice Date (收票日期) and Invoice Amount (收票金额) columns after Company columns

Enhancement

2. New PS Ledgers tab - after Expenses & Income table in Physical Trade page

• Select from “Phy Exe No.” to auto fill details in the row according to the trade execution’s details

  • Empty Quantity, Price and Amount will be auto filled if “Phy Exe No.” is selected

  • The other fields will be replaced by the select “Phy Exe No.” accordingly

• System will auto calculate Quantity, Price and Amount. If one of the columns is not filled and the other 2 columns have values eg, if price and amount have values and quantity is not filled yet, the system will calculate and auto fill accordingly. 

• Formula = AMOUNT = QTY * PRICE for most of the cases, but there is a special case where the unit is US CENT etc but CCY is USD, so AMOUNT = QTY * PRICE / 100

• Validation - If any row in PS Ledger is linked to deleted trade execution, an error will be raised as trade Execution cannot be deleted until its corresponding PS Ledger item is deleted

• Validation date column cannot be bigger than today

New Feature

3. Company Data - Entity Management Table:

a. If Company Name has been input in Company Data>Entity Management table, it will be linked to the Counterparty in physical trades page, so the lists of Counterparty will only be limited to the list input in Company Data>Entity Management table; pertaining to the Counterparty in:

• Create New Physical Trade

• Bulk Create Physical Trade

• Trade Execution

• Bulk Trade Execution Update

b. Counterparty will be listed under Company Type

c. New columns have been added:

• Credit Amount

• Invoice Code

• Invoice Address

• Invoice Bank

• Reg. No.

Enhancement

4. General Ledger - Created date bug fixed

Enhancement

5. Dashboard - Group P/L - add header to grouped row and click on “Save” will have successful pop up message

Enhancement

6. Trade Execution - Empty WH Name or WH Start Date should not allow saving successfully

Enhancement

1. Demurrrage Audit Trail - Works for claims with multiple ports and op adjustments

Enhancement

2. Trade Execution - WH Name and WH Start Date must be filled in the Company Data>Warehouses table, cannot fill in directly from trade execution page/table

Enhancement

1. General Ledger - When upload file with existing Broker, Account and Company Name in Paper Brokers table, Company Name will be auto filled

Enhancement

2. Physical Trades Execution - WH Start and WH End Date can be same date

Enhancement

3. Demurrage - New Audit Trail tab: Input Claim ID and you will be able to view the previous updates of the claim (system will save last updated data for up to 7 times only)

Open

New Feature