MAF CLOUD - NEW RELEASE + FIX UPDATES APR 2023

1. New Physical Trades - PS Ledger and Invoice

If modifications are made to saved data, the cells should be displayed in a prominent colour to easily indicate which changes were made. Once saved, the color display is no longer necessary.

Enhancement

New Physical Trades

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

1. Company Data - Add a new column in company data invoice tab

Tax classification name

Chinese: 税收分类名称

after INVOICE NO. text format compulsory

 IN invoice issuing

add Tax classification name in ITEMS dropdown list

add inv_group_no in ITEMS dropdown list so that they only need to choose one time and inv_group_no doesn’t need dropdown list anymore since it will be auto filled after ITEMS are chosen.

Enhancement

Company Data

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

1. Invoice - Upload invoice in chinese version but unit remains english bug fixed

Enhancement

New Physical Trades

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

1. INVOICE -PAID:

1：SPECIFICATION column should not be compulsory

2: CCY column auto fill by CONTRACT CCY (when they choose contract no.)

3：unit should be 中文 （we can now just translate kilogram and metric ton to 千克， 吨）

4：when choose contract no, if there is only one 开票品名 and one 税收分类编码， tax rate should also auto fill， also check if the 税收分类编码 is right

 COMPANY DATA -INVOICE :

1: CHINESE TRANSLATION of INVOICE NO. 发票号 to 税收分类编码 

INVOICE ISSUE EXPORT：

 1：税收分类编码 should be text format

2：can we move all rows have been issued to another place (like assigned and unassigned in RECEIVED)

3： ISSUE TEMPLATE MODIFY: 税率（%） to 税率 ， Add a percentage sign after the exported number.

Enhancement

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

2. add sum function for all related columns in SETTLEMENT AND UPDATED SETTLEMENT

all columns related with QTY

all columns related with AMT/AMOUNT

also，tick row to view aggregated summary

Enhancement

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

3. Position issue of Daily statement - physical trade position and paper trade split

Enhancement

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

4. New Physical Trades - Reduce white space in table for light theme

Enhancement

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

5. Admin - add company name in User Management and Clean up table

Enhancement

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

1. New Physical Trades - horizontal scroll bar disappeared issue bug fixed

2. Right click to set small, middle, large for table height, default is small

   small：15 rows middle：20 rows large：25 rows

Enhancement

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

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

3. Receiving invoice - upload file template change; also only highlight columns need to be upload

changes：购买方名称 map to COMPANY

货物或应税劳务名称 map to INVOICE PROD

税收分类编码 map to inv_group_no （INVOICE NO. in PAID tab, we have not added this column in RECEIVED yet）

the new template delete the TOTAL PRICE & TAX column, now when uploading, system should firstly upload AMOUNT and TAX AMT, then fill this column ( AMOUNT + TAX AMT)

new aggregate rule:

after they upload the file, system should aggregate all the rows with same “开票日，商品名称（货物或应税劳务名称 in template），规格型号，单位，税率，销方名称, 税收分类编码“ and recalculate the sum of “数量，金额，税额，价税合计（金额+税额）”

4. Upload file in RECEIVED, all the LEDGER TYPE = 开票 . It should be 收票 and save to RECEIVED

5. 不在一个GROUP的人，看不到收票信息

Enhancement

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

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

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

6. Set table size (right click to set height) in dashboard

After we deploy the set the size of contract interface, the size of the table can also be set in the dashboard. However, there are some areas that need to be optimised.

1：After changing the size, the horizontal scroll bar may disappear or become unresponsive.

2：After changing the size, how can they adjust it back to the original default size of the system

Enhancement

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

7. New trades tab

Allow pin all columns located from the left or right instead of individually select columns to pin - for trades tab first

Enhancement

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

8. New Physical Trade - Trades table

add ACTION column

one of item in ACTION column is

AUTO CO (auto contract no. from main, please improve it if you have better idea)

1. it is enable if the row main contract no has value

2. click AUTO CO, to pop up a new window

3. in new window, FE will select all rows with the same main contract no in the table, put them into two sub table:

   1. upper table is all empty contract no rows, ordered by phy_trade_id

   2. lower table shows all existing contract no rows, ordered by contract no

4. Press Auto button, FE auto fill up all the empty contract no based on

   1. MAIN CONTRACT NO_AN

   2. AN is the next number of max AN in existing contract no rows.

   3. if no existing contract no rows, AN = 1

5. SAVE, CANCEL

   1. SAVE to update rows

   2. CANCEL to return main table without save or changes

Enhancement

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

9. Purchase and sale contract - adjust positive and negative signs

Enhancement

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

10. When a cell is selected, the row and column that the cell belongs to are highlighted with colours - for trades table first

Enhancement

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

11. Daily Statement enhancements

1： remove these two columns path and group since they are too long and affect the readability of the report. With only one screen to work with, these two columns take up half of the space.

2: need group function

3：Daily changes are normal, but they become "nan" when they are included in the Daily statement.

4：If too many portfolios are selected in the Daily statement, the table cannot be opened.

5：When they changed the end date in the settings, the table failed to load.

Enhancement

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

12. PSL & Invoice amt calculation issue

We use the quantity and price recorded in the contract to calculate the amount in the Trades tab. However, we use the data in the pricing to calculate the amount in the Invoice and PSL sections. This may cause issues, and we need to decide how to modify it.

1. when we do portfolio P/L calculation, we use phy_trade actual qty (qty) and actual_price (ested_price) in phy_pricing table, which means in settlement tables controlled by risk department

2. for contract_amt, psl, invoice, we use contract_actual_qty (qty) and contract_actual_price (provisional_price) to calculate.

   1. BE in dropdown list in psl, invoice

   2. FE un_inc_amt, un_payment_amt in psl, invoice table

   3. FE contract_amt … in phy_trade table

Enhancement

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

13. New Physical Trades - Trade tab - Bug for PSL&invoice related columns fixed

bugs: for 102685, after I delete all QTY and PRICE data, there are still BAL AMT and UN INV AMT

for 102686, after I key the PRICE and QTY, BAL AMT and UN INV QTY UN INV AMT are null

The right logic should be: for each trade, once they key the price and qty but not yet record PSL or INVOICE for this contract, PSL AMT, INV QTY, INV AMT should be 0 and BAL AMT , UN INV QTY , UN INV AMT should not be null.

Initial BAL AMT, UN INV QTY, UN INV AMT formulas have no change

Enhancement

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

14. ALL the columns have this filter issue, when deselect certain item, it is not filtered

Having issue on filter master row data. Need to filter out the child row value first then only can filter master row. If remove master row (with child row) might solve the issue.

Enhancement

1. Demurrage - Add validation message to prevent user from deleting main tab in calculation page

Enhancement

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

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

2. Company Data - Add new tab in company data management

New Feature

Company Data

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

3. New Physical Trades - PS Ledger and Invoice

• If modifications are made to saved data, the cells should be displayed in a prominent color to easily indicate which changes were made. Once saved, the color display is no longer necessary.

Enhancement

New Physical Trades

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

4. New Physical - Invoice: Add Issue Invoice tab

Pre-set two types of layouts in the invoice tab in advance, one is for Receive and the other is for Issue. Current Invoice page is for Receive

• Delete choose “assigned” and “unassigned” UI

• Delete “Recalculate” and “Split”

• steps：

  1、When users generate invoices, they first add a new row and select the contract no.

  The setting for the contract no should be similar to that for receiving invoices, with a dropdown list displaying the UN INV QTY AND UN INV AMT. Users can manually enter the Counterparty to filter the range of contracts.

  2、After selecting the contract no, the system will autofill related columns(MAIN CONTRACT NO, SPECIFICATION, UNIT, COUNTERPARTY, QTY, PRICE), as well as match the corresponding ITEMS (inv_product) in the company data with the product. The system will return a dropdown list for the user to select ITEMS.

  3、After selecting the ITEMS, If this ITEM corresponds to only one INVOICE NO, the system will automatically fill in the INVOICE NO and the corresponding tax rate.

  4、They need to export the invoicing information, and the template is attached. It should be considered whether to export directly or design a new UI if necessary.

Enhancement

New Physical Trades

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

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

5. New Physical Trades - Updated Settlement tab

• Allow user to reallocate deals by clicking on the Setting button under Action column or tick multiple rows and click on Reallocate

Enhancement