MAF CLOUD - NEW RELEASE + FIX UPDATES AUG 2023

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

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

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

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

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

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

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

share app or dashboard access permission level issue

1. move API function from shared blueprint to the original function blueprint

2. make some modification in get_access_permission_list to ensure user_id is sharing user_id

3. dismiss shared blueprint eventually.

for shared app, now it is the same access level as owner’s app.

we will dismiss shared API access level.

so in this case, the owner of the app should have the same issue : two root portfolio.

if so, then we consider it works well.

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

Add new condition checking for loading.

In PH, PSL, Receive, Issue, Stock table, since our insert and update API is separated, please add different loading variable key for insert and update.

Update or Insert rows in the following table:
PS Ledgers , Receive / Issue Invoice , Stock Details and see the loading will show when save button is pressed. (FE only do some enhancements on loading icon)

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

开票页 未开票数量为0的合同仍在列表里

有几个合同，未开票数量和未开票金额为0，但在开票页面一直有，请帮忙查一查是什么原因

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

开票页 未开票数量和未开票金额计算错误

1. BE already fixed 0 issue. I believe those are old data. so just need do recalculate

2. seems like recalculate function got issue. I think we only need fix this issue.

FE not calculate 未开票数量 when user click recalculate button in issue table

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

group p/l error

the issue is from daily position recal.

coz our testing data server memory is not enough to do daily recal. so the position of portfolio is not updated yet.

once recal portfolio (in portfolio page). it should be okay.

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

error message in dashboard

Not an issue, those portfolio have been deleted. need reselect portfolios

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

APP ENHANCEMENTS for 4. 出入库计划表 STOCK MGMT PLANS

in STOCK MGMT PLANS app

1. it should have two warehouse name columns in app

   1. 1st warehouse should from actual warehouse (stock mgmt table), the columns before stock qty

   2. 2nd warehouse should from phy trade, contract warehouse, the columns is before un_stock_qty

2. add un_stock_qty, which is the same as phy trade table un_stock_qty.

Contract WH column added in Stock Management Plans, the value is from Contract WH in Trades tab.

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

Assigned licence page cannot be viewable

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

when swap function

1. we only update qty, but should also update contract qty accordingly

2. stock type in swap out row should be the same as original row stock type

3. stock type in swap in row should be the stock type selected by user in swap panel.

for point 1, I think it works well. qty is the figure that user would like to swap in/out or reallocate in/out partially

for point 2, I think their suggestion is good. so in this case

1. we need to combine swap and reallocate into one. so please remove Reallocate In/Out from BE

2. in swap function, we also allow user to fill up updated warehouse, default is original warehouse.

   1. if they also change warehouse, then we need to update warehouse as well

      1. swap out → warehouse is original warehouse

      2. swap in → warehouse is updated/selected warehouse.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

outstanding psl payment app

same as phy trade table

QTY: should be contract actual qty or qty

BAL AMT: should be (contract actual qty or qty) * contract actual price

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

outstanding invoice app

QTY should be contract acutal qty or qty

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

cancelled trades enhancement 取消的合同后续处理

in cancel trades page

1. add an icon called DEL SETTLEMENT

2. use is able to multiple select cancelled trade and click it

3. call BE

   1. delete phy_pricing

   2. remove pricing_id from trade execution

   3. delete trades

4. for delete trades, please use the code below coz it will trigger recal

once del settlement, it means no trade in portfolio, no p/l calculation. if user change those cancelled trade to normal trade, they need re-insert settlement.

当一个现货合同取消以后，需要满足以下要求 when a contract is cancelled, the following requirements need to be met:

1. 已取消的合同不应该再计算盈亏，在交易组合盈亏明细或是组别盈亏报表里如何不体现已取消的合同？The cancelled contract should no longer be considered for profit and loss calculations. How can the cancelled contract be excluded from the portfolio's p/l details or group p/l app?

1. check if related trade deleted

2. check if related settlement deleted (remove from update settlement table, appear into settlement table)

in delete API for phy trade API, BE will delete more other things, such as

1. delete phy trade

2. delete deal/portfolio if empty

3. delete inc/exp

4. …

to delete settlement (current delete), we only

1. delete phy_pricing

2. update trade execute to remove pricing_id

3. delete trade (trigger recal)

this is because we do not delete phy_trade data.

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

filter issue in psl allocate table

1. apply filter in lower table

2. add trade into middle table

3. remove trade from middle table

4. lower table filter gone.

we should keep filter in lower table

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

OPEN POSITION DETAILS app

1. add PRICED IN tick box in settings

2. key: inc_priced_in

   1. True if ticked else false

   2. default is unticked

   3. keep value without reset.

fyi if tick priced in, will show all priced in true and false, if never tick then will only show priced in false

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

cancel phy trade validation check

before user convert phy trade contract to cancel, BE need to do validation

1. if there is any exp_inc linked to the phy_trade

2. if there is stock_mgmt linked to the phy_trade

3. if there is psl linked to the phy_trade

4. if there is invoice linked to the phy_trade

if any, raise error to FE.

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

entity management table export issue 230815 公司数据设置导出格式

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

new app: 1. 发票存量表 INVOICE BALANCE REPORT

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

new app: 4. 出入库计划表 STOCK MGMT PLANS

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

new app: 5.在库库存表 INVENTORY DETAILS

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

delete phy deal and portfolio in delete settlement

when delete settlement, we need to check if delete the deal and portfolio, the steps are

1. remove phy_deal_id from cancelled phy trade

2. check if the phy_deal is empty

   1. if empty, delete phy_deal and linked portfolio.

reference code could be found in deal phy trade function

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

Digital invoice

HT-230727 全电开票申请

add a new issue icon to for digital invoice

1. add a new issue icon → DIGITAL INVOICE

2. select rows (un-issue), click DIGITAL INVOICE

   1. only available in un-issue table

   2. selected rows must have INVOICE SERIES NO value (BE will add it), otherwise, disable DIGITAL INVOICE icon https://mafint.atlassian.net/browse/MAF-4085

3. export two excels

   1. same logic as our current ISSUE icon

   2. excel format as below

1. 1st excel: for all INVOICE TYPE is special

   1. header must be in Chinese, follow the table below

   2. how to map to MAF

   3. sheet 1:

   4. sheet 2:

2. 2nd excel: for all INVOICE TYPE is normal

3. 1st excel and 2nd excel header seems like the same.

4. we need to export header and value in the each sheet (1 and 2 sheet), ensure the order of header is the same as the file attached from haitian saide.

5. need to add invoice code column in issue table, please refer to below logic - basically add invoice code column (non uneditable) in issue table, so will auto fill up invoice code according to the counterparty. invoice code is

   • not must item in company data (entity mgmt) table

   • but must item in issue table (as invoice code is required for issuing digital invoice), non editable so will auto fill from company data

6. then they can issue digital invoice after fill up.

7. in 1-发票基本信息 sheet, FE will show one row if any duplicate row

   1. unique key: [invoice series no, counterparty and invoice code]

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

ps ledger allocate wrong - ps ledger calculation incorrect

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

Unstock Qty should be = ( CONTRACT ACTUAL QTY if have else using QTY ) - STOCK QTY

After deleted stock details for this phy trade id, UNSTOCK QTY is empty, from the issue mentioned above should be equals to ( CONTRACT ACTUAL QTY if have else using QTY )

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

ps ledger bug

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

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

digital invoice issue 230808 全电开票申请导出格式错误

issue 1:

1. in 1-发票基本信息 sheet, FE will show one row if any duplicate row

   1. unique key: [invoice series no, counterparty and invoice code]

issue 2:

when export into digital invoice, please change all number to positive. and must be in number format.

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

1. when upload file in issue table, those columns linked to items (inv setting table in company data) should get value from dropdown list of items, instead of reading value from uploaded file

2. those columns in issue table linked to items, should not be editable.

3. if can not find contract no, then raise error to remind user

4. if can not find items, then raise error to remind user too.

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

230809 收票分批错误

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

invoice unissued table, add a new row or click any row at the top and key in all the required fields and save and got this error

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

issue bottom table calculation issue

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

in issue invoice, when click on digital invoice, it should auto jump from unassigned table to assigned table

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

add common term into API controller

for controlling settings for entity management in company data

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

ps ledger allocate wrong

不能保存的问题

付款金额44439，几个合同的尾款正好也是44439，但是分批里面选了合同以后，还有尾款金额

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

issue 1:

1. in 1-发票基本信息 sheet, FE will show one row if any duplicate row

   1. unique key: [invoice series no, counterparty and invoice code]

issue 2:

when export into digital invoice, please change all number to positive. and must be in number format.

全电开票申请导出格式错误

全电开票申请导出问题：

1. 发票基本信息：一个发票流水号只显示一条，不能重复显示(下面这个流水号是2的有两条记录，应该只保留一条记录)

2. 发票明细信息：

1） 导出的开票申请数量必须是正数，且是数值格式

2） 单价必须是数值格式