MAF CLOUD - NEW RELEASE + FIX UPDATES SEP 2023

Petro Win New app requirement

-P/L & Position Change From Daily Open Position app 当日开仓持仓盈亏和仓位变动
-pre-sett price 前结算价

• settlement price: 当日结算价

-pre size 昨日仓位
-price change 价格变动
-p/l change 盈亏变动

Enhancement

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

230927 开票页面添加出入库日期

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

Enhancement

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

Enhancement

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

Enhancement

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

Enhancement

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

Enhancement

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

issue invoice can not save, FE exception urgent!

Enhancement

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

230925 实际价格为0的合同

我们有一部分合同实际价格为0的合同，是否终价显示的为否，能否改为实际价格为0的合同，是否终价显示为是？因为在我们理解中，合同实际价格空着不填的才是否，有些合同确实价格为0，比如盘盈盘亏，还有一些样品出口的合同，如果显示为否，我们在一些报表里就会看到这些合同（未点价合同表，未了结合同表等等）

if empty or null, it is false, if having value including 0, then true.

Enhancement

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

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

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

new requirements VAR report

(Background) Each portfolio has a max allowed loss amt, so they want to a % to show % of VAR and Shortfall value.

2 things needed for this new requirement:

1. Add the “Max Allowed Loss Amt” in the Settings for the Var model for users to input the data:

Please add two percentage parameters in the Var chart. The formula is as follows:

VaR% = |VaR| / |Max allowed loss amt| * 100

Shortfall % = |Shortfall| / |Max allowed loss amt| * 100

var% and shortfall% keep to 2 dp

change to 最大亏损金额（自定义

put sample below shortfall %

Enhancement

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

230925 开票

FE exception

https://mafint.atlassian.net/browse/MAF-4262 https://mafint.atlassian.net/browse/MAF-4272

230925 报表更新

1. 现货追保及止损表

1） 添加列：追保价（含升贴水）---在现在追保价的基础上，加上升贴水，计算得出追保价（含升贴水）contract_prem

2） 添加列：合同约定追保比例 ---带入现货合同页的合同约定追保比例

1. 未点价合同表

添加列：采/销---带入现货合同页的采/销

1. 未了结合同表

添加列：公司名称---带入现货合同页的公司名称

1. 未了结款项表

添加列：交易日期---带入现货合同页的交易日期

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

230922 采/销售量汇总

ensure they have the same settings to get correct result.

we use group or company level to control data access scope.

Enhancement

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

230922 出入库计划表 -group账号查看

open settings, change the group keys and resubmit.

issue 1: change settings or close app and create a new app

issue 2: change it to group level if it is group level.

Enhancement

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

add ? logic explanation in column header

try to list down necessary column in this ticket to add going forward.

1. stock mgmt → back to back → QTY (IN) Added and deployed.

Enhancement

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

cannot enter market data

Enhancement

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

add custom tax rate 关税日期 column in updated settlement table

Enhancement

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

230918 日期输入方法

in phy trade table,

if trade_date not in this year (2023) before saving, show yellow color, so at least to warning user that the date may incorrect.

Enhancement

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

230918 商务报表更新 现货追保及止损表

bug fixed

Enhancement

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

phy trade page FE exception can not save after updating

edit or add new row in phy trade table and save see can save successfully or not.

Enhancement

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

230816 库存明细 上级group

add username, group and created by etc columns in back to back table

add product column in back to back table

Enhancement

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

230831 更新的结算价 价格不一致 enhancements

settlement tax rate (结算税率) is empty , most of the trade modes except OFFSHORE are depends on it to calculate price before tax ,if settlement tax rate is not filled , price before tax would not be calculated and thus settlement amt before tax would not be calculated as well.

if it is not filled, then treat it as 0 tax rate.

Enhancement

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

group pl duplicate issue

it is empty list issue. anyway, if it is empty list, then BE would not yield to FE. seems like it work now.

Enhancement

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

发票存量表 enhancements; invoice balance report

it happened when there is not match_id value in stock_mgmt data. I have made some modification in code to cover this kinds of case.

Enhancement

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

230915 库存明细-默认出入库

in stock mgmt and bulk stock mgmt (in new phy trade)

if purchase → stock action auto stock in else stock out

Enhancement

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

230915 取消的合同

add status column in cancelled trades to determine which contracts have their settlement deleted

Enhancement

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

发票存量表 enhancements; invoice balance report

in settings:

group keys should be

1. COMPANY → company_name

2. PRODUCT → product

3. INVOICE NO.(1st 7 characters) → is_inv_group_no

4. ITEMS → is_inv_product

5. SPECIFICATION → invoice_spec

in table,

keys are:

1. company_name

2. is_inv_group_no

3. is_inv_product

4. invoice_spec

5. psl_unit

6. psl_ccy

BE has done is_pair part, need FE to update something to work

1. keys changes from BE rsp

   1. bal_qty → psl_qty

   2. bal_tax → psl_tax_amt

   3. bal_amt → psl_amt

2. add columns if is_pair ticket

   1. PURCHASE CONTRACT → purchase_contract_no

   2. PURCHASE COUNTERPARTY → purchase_counterparty

Enhancement

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

230915 开票-单价小数位显示错误

今天有一笔开票，数量为33.234吨，单价为8001.151，金额为265910.25，数量和金额都没问题，但是单价只显示两位小数点，点全电开票以后下载的开票申请里的单价是8001.15，导致产生错误，请帮忙修改一下单价的显示，不要保留两位小数，显示为我们实际的价格，开票的时候，数量和单价都可能会有多位小数点，只有发票金额需要保留两位小数点。

都显示实际的价格吧

Enhancement

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

230911 合同拆分后续

2） 合同拆分后，原合同和新拆分来的合同的约定仓储名称和约定仓储地址都没有了

3） 合同拆分后，原合同和新拆分的合同的合同实际数量还是原来的合同实际数量（修改为原来的合同实际数量就留在原合同里，新拆分出来的合同的合同实际数量空着）

4） 合同拆分后，新合同以下信息缺失：签署、合同版本、合同类别、收付款方式、约定收付款日（这些应该都与原合同保持一致）

5） 合同拆分后，新合同是否可以自动生成合同编号？不用再手动点一下生成合同编号

目前拆分合同只能拆分数量，是否可以在拆分框里多加点信息？

1） 在均分交易后面显示合同号和客户名称（不允许修改，只是方便商务在拆分的时候知道自己在拆哪个合同）

2） 在拆分数据信息里增加：客户名称, 品牌，产品规格，临时价格，合同实际价格，合同升贴水（这些信息自动带入原合同信息，但允许修改）

Enhancement

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

商务报表-未了结合同表 enhancements

1）未开票数量为0的合同还显示为部分开票，以下合同应该为已完结，不显示在未了结合同表里（第一个浙江济桐的合同不知道为什么有两个已结算）

 2） 请添加列：采/销

目前合同数量采购和销售都是正数，因此请添加列：采/销，并将销售合同数量显示为负值，方便我们看报表的时候检查一下

Enhancement

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

230914 收票录入重复

今天在补录进口收票的时候，发现记录也重复了，但是很奇怪，53.62吨的收票在刚保存的时候看是重复了，结果刷新以后再看又不重复了，但是48.655吨的收票刷新以后仍然是重复的

Enhancement

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

230816 库存明细 上级group

• choose username instead of email address so can add username to choose from the dropdown list

• add a GROUP column (similar to the one in paper trades) in stock details page so she can see which group the user belongs to

Enhancement

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

230831 商务报表-未了结合同表 PHY TRADE ON GOING STATUS

1. also add two columns: 交易日期，交易模式

2. if trade mode in 进出口，离岸，离岸跨币种, invoice status should be empty, you should not see 未开票 部分开票 已开票

3. if 款项未清, other status should not be shown. only show 款项未清

4. status key typo changes

   1. PARIAL → PARTIAL

5. change key UN_SETTLE to UN_SETTLE_PAYMENT

6. if final_settle_status == UN_SETTLE_PAYMENT then show → UN_SETTLE_PAYMENT (款项未清)

7. ignore other status, only show UN_SETTLE_PAYMENT (款项未清)

Enhancement

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

出入库计划表 stock mgmt plan enhancements

missing columns added

1. CONTRACT DELIVERY DATE

2. COUNTERPARTY

Enhancement

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

230911 款项余额为0的合同如何进行收付款认领

currently, in psl table, dropdown list only show un_payment_amt is not 0 contract to assign.

they have some special case to handle. sometimes, they need assign psl to un_payment_amt is 0 contract. such as refund, top-up margin etc.

so our solution

1. in psl page only, above the table, add a tick box PAID

2. default untick

3. if tick, then dropdown list show un_payment_amt is 0 only (other logic will keep the same as normal)

Enhancement

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

230913 采销资金 无法认领

allow changing of ledger type in ps ledger table and ps ledger allocate (middle table); invoice and received invoice remain unchanged

Enhancement

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

change phy trade qty new logic to settlement:

1. user is able to change qty of phy trade even there is settlement qty in update settlement table

2. if there is settlement qty, change qty wont impact trade and portfolio pl and position, the portfolio will still use original settlement qty

3. if there is no settlement qty, change qty will impact trade and portfolio pl and position, the portfolio will use new qty. note that if no sett qty, change qty will not change sett qty unlike previous logic

Enhancement

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

dashboard - the dashboard data cannot be refreshed in real time for certain account

Enhancement

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

issue invoice cannot save after changing from usd value to cny value

1. as spoken, we will dismiss ex_rate in psl, receive and issue tables.

2. if trade mode is import/export only, we remove inv amt > contract amt validation in FE in receive and issue tables.

Enhancement

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

stock mgmt plan enhancements

the correct logic below:

1. in settings page

   1. add GROUP (please refer to image below)

      1. default values added in

         1. COMPANY

         2. PRODUCT

         3. BRAND

         4. SPEC

         5. CONTRACT WH

         6. CONTRACT DELIVERY DATE

         7. COUNTERPARTY

      2. other values

         1. CONTRACT WH ADD

         2. BL NO.

         3. CON STOCK DATE

1. get phy trade data from DB, only if un stock qty is not 0

2. group by group keys from FE

3. sum up un stock qty based on group keys

4. columns based on group keys + sum up of un stock qty

Enhancement

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

230904 合同页未收货/出库数量计算不对

qty, actualQty, contractActualQty is under phy trade directly.

buy is positive and sell is negative. so we keep them

stock_qty different, BE will do calculation of stock qty. so we should keep sign of stock_qty from BE.

Enhancement

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

230831 更新的结算价 价格不一致 enhancements

1. sometimes contract amt is not calculated correctly ,i tweak a bit of its condition now it should always correct one

2. dong claims that some rows which does not have green cells cannot be filtered, i also update the condition now once filtered you will not see any rows that does not green cell remains in the table liao , you can check like this

3. check settlement amount before tax , dong complains that value of settlement amount before tax mainly for import/export and offshore ccy is empty, that's because they both share the same formula, you can check on CC's comments, now even not entered exchange rate it will treat as 1 to calculate price before tax thus it will calculate  settlement amount before tax as well

4. BE did not calculate the invoice related values like those value in trades tab, now all the invoice-related values in updated settlement should be the same as the one in trades tab liao

Exchange Rate is treated as 1 if they didnt input anything on that column

• Price before tax:

If phy trade mode is IMPORT / EXPORT (转口) or OFFSHORE-CROSS CCY (转口),
Price before tax = ( Settlement Price or Estimated Price ) * Exchange Rate / (1 + ( Settlement Tax Rate / 100 ))

Enhancement

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

split trade action in phy trade table

Enhancement