MAF CLOUD - NEW RELEASE + FIX UPDATES NOV 2023

update phy trade trade data and title transfer date in yr settlement

after click yr settlement button

1. those phy trade trade date will be changed to 1st business day of next of settle yr. e.g, settle yr is 2022, then trade date will change to 1st Jan 2023 (or 2nd Jan 2023 if 1st Jan 2023 is weekend)

2. those phy trade title trans date will be changed to 1st business day of next of settle yr (if original trade has title trans date)

3. custom tax of those phy trades if any, the exp inc date will be changed to 1st business day of next of settle yr

Enhancement

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

business mode is not show properly for english and chinese

Enhancement

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

'when FE auto filled, but can not save coz FE does not trigger update in table.'
yes FE need to update this part, so once the value is mapped and auto filled, those row/s with auto filled value will be saved.

Only in update settlement list, since in settlement list only saved when the row is ticked

Enhancement

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

add stock management status in stock management table

Enhancement

add one more business mode in phy trade: 5-1: 美元开证USD LC

Enhancement

settlement and update settlement tables strtg column

FE:

1. add a column called STRTG after CAT in settlement table and update settlement table

   1. editable

   2. dropdown list, no validation (same as cat)

   3. auto fill (only empty) if meet phy trade strtg mapping settings.

      1. if psmp value and strtg value both empty, follow key’s value

      2. if psmp value and strtg value both there, follw psmp value and strtg value mapping, if can not find it, empty.

2. add Phy business mode in settlement and update settlement table

   1. not editable, value from phy trade table.

BE:

1. strtg is the same as cat, which is stored in trade table.

2. update strtg will trigger auto calculate, same as cat.

Enhancement

physical trade portfolio yearly settlement

1. if done phy trade contracts, user will move them to archive, user need to delete settlement

   1. once delete settlement, it means the pricing in portfolio will be deleted. for yearly settlement, user only remove pricing of contracts on previous year date. BE will do validation

2. still alive phy trade contracts, user will click yearly settle button to settle it

   1. TOTAL AMT = MTM AMT+ BENCHMARK AMT + CUSTOM TAX AMT on 31 Dec of previous year (weekday)

   2. insert -1 * TOTAL AMT into general ledger table as initial amt on 1st Jan of the year

3. how to do phy trade year settlement

   1. select phy trade which are needed to do yr settlement

   2. press YEAR SETTLEMENT (icon better with hint)

   3. call API

      /smartfin/api/v1/physical_trade/yr_settle POST phy_trade_ids sett_yr: '2022' or '2023' (user to fill up, it must 4 digits, default is last year)

   4. return list of general ledger rows

   5. FE pop up a table, display those rows (only show cols in attached excel with values)

   6. those rows are not allowed to edit, view only

   7. default all rows are selected, user is able to un-select which is not going to be settled.

   8. click SAVE button to settle

      1. the API is general ledger insert.

   9. once save successfully, you will see those rows in general ledger.

Enhancement

Change password bug

Enhancement

del settlement validation in archive table

in archive table, the purpose of del settlement is to close past yr position in portfolio, which BE wont bring them to current yr.

so in archive table, BE need to validate if trade_date not in current yr.

if trade_date is in current yr, BE reject and raise error msg.

(btw, cancelled table no need do validation)

Enhancement

new app fix 外贸已出入库未定价合同

这个报表只需要显示有出入库没结算价格的合同

未出入库合同表/未开票合同-已出入库

Enhancement

add phy trade strtg mapping table in company data

Enhancement

20231122 出入库数量计算错误

Enhancement

new app - 未开票合同-已出入库 issue

Enhancement

add DEL SETTEMENT button in archive table

1. add DEL SETTEMENT button in archive table same as CANCELLED table

2. for those trade settlement deleted, highlight in different color to identify it. for both tables cancelled and archive

Enhancement

231108-财务调整表

外贸已出入库未定价合同 ( Unpriced Stocked Cargos )，未出入库合同 ( Outstanding Stock/In Out Contracts )，未开票合同-已出入库 ( Outstanding Invoice For Stocked Cargos )

• add contract number column

• when double click, it will open a new window to view details for the contract

Enhancement

未出入库合同 Outstanding Stock/In Out Contracts：

1. each r will have sett_ccy from portfolio

2. we need to compare sett_ccy vs pricing_ccy

3. if r['pricing_ccy'] == 'CNY': this part also need to modify to standardise it.

4. if portfolio settlement ccy equal to phy trade pricing ccy, the FINANCE EX RATE = 1, no matters what ex rate in settings.

    

Enhancement

231120 issue invoice

quantity - copy paste issue

Enhancement

new apps issue - 3 外贸已出入库未定价合同 ( Unpriced Stocked Cargos )，未出入库合同 ( Outstanding Stock/In Out Contracts )，未开票合同 ( Outstanding Invoice For Stocked Cargos )-已出入库

Enhancement

外贸已出入库未定价合同 Unpriced Stocked Cargos

Enhancement

外贸未出入库合同 Outstanding Stock/In Out Phy Contracts - add Trade Mode

Enhancement

new app issue Outstanding Stock/In Out Phy Contracts

if no actual_qty, please filter it out. so no need (actual_qty or qty) in the formula.

Enhancement

new app issue Outstanding Invoice For Stocked Cargos

we are using total_actual_stock_qty right now, change to use total_stock_qty

Enhancement

swap in/out link no is missed and stock actual qty mis-matched

Enhancement

API document for c-strategy

Enhancement

new app OUTSTANDING STOCK IN/OUT PHY CONTRACTS

New Feature

new app OUTSTANDING INVOICE FOR STOCKED CARGOS

New Feature

231113 合同拆分

合同拆分后，有以下几项在新合同里无数据

1） 点价价格

2） 最初入库日期

3） 作价方

4） 已追保比例

5） 合同约定追保比例

6） 库存类型

need to copy those value from original trade to new splited trade.

Enhancement

231113 现货授信报表

calculation issue

Enhancement

Add new columns in Updated Settlement Table

FINANCE EXCHANGE RATE 财务汇率

1. finace_ex_rate

2. number

3. same format as ex_rate

4. FINANCE YR MTH 财务入账月

   1. finance_sett_yr_mth

   2. text

   3. BE only accept format ‘202304' or '2304’

5. FINANCE SETTLEMENT AMT BEFORE TAX

   1. what is SETTLEMENT AMT BEFORE TAX formula in FE?
      If the trade mode is IMPORT/EXPORT
      SETTLEMENT AMT BEFORE TAX = ( Settlement Qty * Price Before Tax ) + ( Custom Tax Amount)

      Or else,
      SETTLEMENT AMT BEFORE TAX = Settlement Qty * Price Before Tax

as discussed, Price Before Tax has two modes

1. current mode which is mode=1 (default)

2. new mode which is mode=2

if mode=1, use ex_rate, if mode=2, use finance_ex_rate

so

FINANCE SETTLEMENT AMT BEFORE TAX is the same as SETTLEMENT AMT BEFORE TAX, but mode is 2

so need to show 2 value of Price Before Tax according to its mode (Eg. 12.00 / 11.56 , Column name could change to ‘Price Before Tax ( SETTLEMENT / FINANCE SETTLEMENT )’ )? Because it could have different value.

Enhancement