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

-

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

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

Enhancement

-

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

1. Physical Trades -

• PS Ledger: Ratio is saved inconsistently bug fixed

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

Enhancement

Managing Physical Trades

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

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

Enhancement

-

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

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

Enhancement

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

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

Managing Physical Trades

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

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

Managing Physical Trades

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

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

General Ledger

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

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

-

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

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

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

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

-

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

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

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

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

-

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

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

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

-

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

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

-

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

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

-

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

https://mafint.atlassian.net/browse/MAF-2975 https://mafint.atlassian.net/browse/MAF-2979

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

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

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

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

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

Enhancement

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

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

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

Enhancement

-

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

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

Managing Physical Trades

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

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: 发票

Managing Physical Trades

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

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

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 / 款项对方

General Ledger

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

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

-

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

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

Enhancement

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

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

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

Managing Physical Trades

https://mafint.atlassian.net/browse/MAF-2943 https://mafint.atlassian.net/browse/MAF-2944 https://mafint.atlassian.net/browse/MAF-2938

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

Managing Physical Trades

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

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

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

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

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

Managing Physical Trades

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

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

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

• https://mafint.atlassian.net/browse/MAF-2960

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

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

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

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

5. General Ledger

• Change header of WH Name to WH Entity

Enhancement

General Ledger

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

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

Managing Physical Trades

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

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

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

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

Managing Physical Trades

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

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

-

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

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

Managing Physical Trades

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

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

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

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

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

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

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