MAF CLOUD - NEW RELEASE + FIX UPDATES OCT 2023

get API token for API access in the future

for admin account only

Enhancement

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

change p/l from open position app issue

1. download content time is too long

2. exception in console

Enhancement

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

some of stock can not do recalculate

enable checkbox for all row. I will disabled those action button if user chooses Pairs stock, users need to know why those button are disabled.

Enhancement

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

add Tradex sftp settings table in company data

To setup SFTP for tradex, go to 'Tradex SFTP' under company data to fill up required details of it.

1. Test the function in the table (insert/delete/update)

Once setup done, go to paper trade page and open TRADEX dropdown to select one of sftp from 1. table to open the Tradex files that had been stored in SFTP
(Must be valid IP, PORT, USERNAME and PASSWORD from 1. table) to retrieve the file list or else BE will return error.

1. Test the remaining functions (download, open the file to create new paper trade page etc.)

Enhancement

231027 采销资金备注

when split, remarks' contents should remain

Enhancement

stock Mgmt calculate button logic changes

currnetly we only consider stock in and out.

we need to consider all stocks regardless stock in/out or swap in/out.

coz sometime there is a certain loss when swap in and out.

e.g, move out 1000 MT, but move in 999.2 MT. there will be 0.8MT loss in total stock.

when recalculate, please include all stock_actions

STOCK_ACTIONS = {
STOCK_IN: 'STOCK IN',
STOCK_OUT: 'STOCK OUT',
SWAP_IN: 'SWAP IN',
SWAP_OUT: 'SWAP OUT'
}

Enhancement

TRADEX - MAF paper trade integration

1. double click to open file to BE, not double click to select file.

2. multiple select must hold shift + single click

3. single click one file, will dismiss select from selected file.

4. if click from 1st, hold shift and click last one , it should select all between 1st to last

just ensure it is the same keyboard operation in excel.

Enhancement

231018 更新的结算价加上发票日期

stock management search function

Enhancement

231025 收票 不同账号看到的合同不一样

So the issues are need to be checked later are:

1. Ensure the filter and logic only exist in PS Ledger allocate

2. tick should be reset when close the window. It should untick by default when open the window.

Enhancement

stock detail group exception

in stock mgmt table, when drag a column to group, got error.

Enhancement

paper trade portfolio name mapping for tradex file

for Tradex and only for Tradex

BE will return portfolio_name in trade row

please map portfolio_name in the portfolio name list in FE. if not in the list, show it in red.

if it is in the list, then add portfolio_name (portfolio_id) in the table.

Enhancement

paper trade upload bug for tradex

Enhancement

230831 库存明细 unstock qty empty

unstock qty should nvr be empty even for users in group level account

update contract qty and unstock qty should be auto updated

I have added a column to store stock_contract_qty in phy trade database.

previously, we do calculation of stock_contract_qty in memory when select phy trade.

now we store it into database, we do not need to calculation anymore. we handle it in the ways like what we have done for inv_qty.

please amend it accordingly and we have to show un stock qty in stock mgmt table.

i have just changed the key to total_stock_qty in phy_trade

total_stock_qty is sum up all stock_qty (stock_contract_qty or stock_qty) just like what we have done for inv_qty in phy_trade.

btw, we need use total_stock_qty to replace the key stock_contract_qty in many places. need to check carefully.

Enhancement

231016 客户更名

add a status column in company data table, if select INVALID for the counterparty, then the counterparty will not appear in the counterparty drop down list

Enhancement

cannot allocate portfolio for paper trades bug fixed

Enhancement

230911 合同拆分后续 point 1 undone

when split trade, psl and stock mgmt amount and quantity will be auto split accordingly

Enhancement

add total_actual_stock_qty in phy trade database

1. add total_actual_stock_qty in phy trade database

   1. added in testing server

2. amend calculateWhPsl

   1. stock_actual_qty

   2. qty_variation

Enhancement

remove split function in old phy trade page

Enhancement

paper trade keys dictionary

Enhancement

230911 合同拆分后续 point 1 undone - add negative sign to split qty

1. if it is a sale contract, the split qty in this pop up box should show it is auto negative right? currently it is not. but after split it is auto negative

2. qty value to BE must be positive no matter it is sale or purchase contract.

    

i think that is good suggestion.

1. let’s show PURCHASE or SALE

2. NEW SPLIT QTY, will auto convert to negative if it is sale, and positive if it is PURCHASE. (but value to BE still positive no matter P or S)

3. please issue a new ticket for FE

Enhancement

replace of stock_contract_qty

in current code, there are lots of places where BE is using stock_contract_qty as total_stock_qty.

since phy trade already have total_stock_qty, not stock_contract_qty is dismissed, please use total_stock_qty to replace of stock_contract_qty.

highlight:

stock_contract_qty is also one of columns in stock_mgmt database table. please do not change those stock_contract_qty keys

Enhancement

in new phy trade page, when reset psl and invoice using this button, need to reset all stock-related qty too - same logic

Enhancement

add recalculate button in stock management page

similar logic as the recalculate button in ps ledger

Enhancement

231023 采销资金分批

check what filter FE is using to list phy trade in third panel currently. I guess one of keys is ‘third party’ or ‘counterparty’.

means contract connterparty must be the same as third party in psl data.

now, user requests we add a tick box, once it is ticked, then remove countparty key from the filters. so FE will refresh phy trade lists in third panel based on new filter.

Enhancement

231018 更新的结算价加上发票日期

when double click the cell, phy trade id of the row will be passed to BE and when opening the new tab and trigger its related API, it will only show the selected phy trade id rows in the table.

If need to check the other rows other than the selected phy trade id rows need to click the search for date range to show the other data.

Enhancement

231013 交易模式选择性修改

allow changing of trade mode for at the moment - 可以，先让内贸，交割，期转现，长单这几种可以相互换

Enhancement

231013 新现货合同页添加要素 split issue

when split trade, FE also need pass business_mode into BE.

after split trade, business mode should be the same as original trade

Enhancement

231023有款项总额无日期

Enhancement

出入库计划表错误 issue 2

when stock_mgmt stock_band is empty from select, and link contract no has brand, FE will auto fill up band into stock_band. but

1. after auto fill, please treat it as value changed, show it in green as normal update value

2. which is allowed user to SAVE to update stock_band

please debug it with test2 in testing server. there are some cases for you to try.

1557
1560
1449
1561

how to test:

1. create stock row with contract no which has no brand, and leave brand as empty and save

2. go to phy trade to add brand into the contract no

3. go back to stock magt table

4. currently, you can see the brand auto fill

   1. but FE did not show it in green, which means value updated

   2. can not save

Enhancement

231019 全电开票申请出错

Make sure that only the row/s got series no can click Digital Invoice button 全电开票, before the fix if you select row got inv series no, and select another row without inv series no, actually it can click the button which is bug

Enhancement

231013 新现货合同页添加要素

现货合同页需要加上以下信息：

1. 业务模式：手动填写，带记忆功能

Enhancement

231018 合同均分添加要素 point 1

1. 因为财务要求，有些产品因为成分或是用途等不同，导致财务处理里需要分成两个产品来处理，因此在均分合同页面麻烦帮忙添加一个产品框，

Enhancement

cancel trade require delete ps ledger, invoice and stock; dong said not feasible

when cancel trade (not delete), if have ps ledger/stock/invoice, will have this error

dong said it is not feasible as they still need the ps ledger/stock/invoice data for refund/return

Enhancement

更新的结算价加上发票日期

add invoice date in updated settlement

Double-click the cell to open a new window showing the stock details for the selected contract number

Enhancement

231016 出入库计划表错误

出入库计划表里的未收货/出库数量方向与合同页相反

在库存明细里更新过的信息不反馈到出入库计划表里：

PTA的库存类型上周已经调整好了，在在库库存表里更新了，但是出入库计划表里还是没有更新

Enhancement

230905 黑色合同模板1

Enhancement

231012 新用户加入

when add new user into group, all access permission is given by default. group owner can untick access permission so user will not have any permission unless granted by group owner

Enhancement

230905 黑色合同模板1

这个合同还有以下问题

1. 导出来的文件名称可以为合同号，是指合同里的合同号，即主合同号

1. 保证金金额不能为负数，另外如果涉及到保证金比例的地方，比如下方5%，也不能为负数（有些情况下我们的保证金比例在MAF里会写成负数，导出的合同必须为正数）

今天我们同事测试发现这个支付合同总货款的%，本来应该用合同页的保证金比例，但目前导出来的合同用的都是合同约定追保比例，所以这里的支付合同总货款的%和括号后计算的人民币金额都是错误的。也请帮忙一并更新

Enhancement

231010 出入库数量格式有误

有一个合同HTTC-P-2300703082_2, 在库存明细里是三笔31.9吨组成，一共95.7吨，在现货合同页面，出入库数量是95.7吨，但是仓储名称&状态里的是三房巷 | 现货: 95.69999999999999，导致未了结合同表里显示有误（已经完结的合同，仍显示为部分提货）

Enhancement

P/L & Position Change From Daily Open Position compare date

the rules are as compare date should always auto reset to 1 weekday before end date when loading or click submit. As follows,

Enhancement

231012 库存明细与报表页不一致

hi adam, i guess it is a bug in our side. our current design is only take care about stock in/out.

in this way, we may miss some important information. e.g., in this case,

it should have 9000 physical instead of warrant.

please amend the logic as follows

get all stock rows regardless it is swap in/out or stock in/out. then we group them together, which gives us a full details. in this case,

1. stock in 9000 warrant

2. swap out 9000 warrant

3. swap in 9000 physical

group them together will be: 9000 warrant - 9000 warrant + 9000 physical = 9000 physical.

so the result should be 9000 physical instead of 9000 warrant.

i think warrant/physical is stock_type which is one of group keys.

if so, then no need do it separately. just group them together.

Enhancement

231010 收票数字格式显示错误

check the table with summary, see will get the correct values or not when insert/update/delete/filter/group row.

Enhancement

黑色合同模板1 enhancements

Enhancement

portfolio performance label issue

Choose longer portfolio name and observe the label see will still this issue still exist or not

Enhancement

231010 出入库数量格式有误

should use isclose to handle it instead of adjust decimal.

Enhancement

shared link cannot use scroll bar for group p/l and historical group p/l app

Enhancement

P/L & Position Change from Daily Open Position enhancement

Enhancement

黑色合同模板1

remove counterparty filter in company data table, so user does not have to select counterparty in company data table

Enhancement

P/L & Position Change From Daily Open Position duplicate row

Enhancement

230905 黑色合同模板1

generate contract report for 黑色 product

Enhancement

P/L & Position Change from Daily Open Position

buyorsell can not be a key to group. in fact, we should group buyorsell to get position changes.

once buyorsell become a key, then they can not group together.

before group, BE should assign sign to size based on buyorsell to get position changes.

BE will change to negative if sell. So can remove this on FE.

Enhancement

portfolio page init loading

when go to portfolio page, it will auto load 1st portfolio summary and which takes long time to load.

suggestion:

when go to portfolio page, do not auto load 1st portfolio summary (the other two APIs still calling).

ensure there is wont affect other function in the page after stop auto loading

Enhancement

P/L & Position Change from Daily Open Position

• added new group key buyorsell to ensure that positive/negative sign of pre-price is correct

• if empty, treat it as 0, we need calculate position change if one of size is empty

Enhancement

经纪商数据库

我的账户可以自主创建期货经纪商信息，但在公司数据库中不显示，且无法看到公司已创建的经纪商数据库，因为级别只是operation吗？

Enhancement

开票页面添加出入库日期

在开票页面的上面框里，添加列：出入库日期（带入合同页的出入库日期）

Enhancement