31 MAY 2023 - VERSION 3.1.5
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| Enhancement |
| |||||||||
2. RECEIVE allocate window - UN INV QTY issue fixed: User manually adjusts the quantity and amount of contracts to match the numbers exported from the tax system. However, in the 3rd panel, UN INV QTY still appears in red because the system did not treat “0.0000” as 0. Amount, below 0.05 will assume as 0 Qty, below 0.0005 will assume as 0 | Enhancement |
| |||||||||
3. Bug in receive table after assign After user assigned the contract in the RECEIVE table, they noticed an additional record in the unassigned page. The underlying cause of this bug is similar to MAF-3861, where the system failed to treat "0.00" in INV AMT as 0, resulting in an extra update of a new record. | Enhancement |
| |||||||||
4. in Unassigned tab only (phy_trade_id empty)
Now we have no tax rate (税率)column in table, FE calculate tax rate tax rate = 税额/不含税金额 | Enhancement |
| |||||||||
5. PS LEDGERS Assigned page: MAIN CONTRACT NO., QTY, PRICE Allocate window 2nd panel: MAIN CONTRACT NO., QTY, PRICE QTY use qty and contract actual qty from physical trade (priority: contract actual qty > qty) PRICE use provisional price and contract actual price (priority: contract actual price > provisional price)
RECEIVE Assigned page: QTY, PRICE, CONTRACT AMT QTY use qty and contract actual qty from physical trade (priority: contract actual qty > qty) PRICE contract actual price DO NOT USE PROVISIONAL PRICE FE calculate CONTRACT AMT (QTY * PRICE)
ISSUE upper table: CONTRACT AMOUNT (from physical trade) Add Created by and Updated by time and date for both ISSUE and RECEIVE | Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
the correct logic:
use closeto to compare two value. tot = number of decimal from settings + 1 | Enhancement |
| |||||||||
2. in issue invoice tab last table un inv qty and un inv amt cannot be positive same logic as received invoice if sign of un inv qty and un inv amt is different from initial sign of inv qty, con qty and inv amount, highlight in red and cannot save reference:
| Enhancement |
| |||||||||
3. issue tab delete bottom table row issue - in issue tab select all rows in top table and they will appear at bottom table but when delete 1 row in the bottom table, all the rows will return in the top table instead of 1 | Enhancement |
| |||||||||
4. Auto contract They only can auto generate contract no for one main contract no one by one. so to solve this issue. We use BE to handle
FE
BE
| Enhancement |
| |||||||||
5. RECALCULATE bug in receive and issue In invoice receive and issue table, after recalculate, un_inv_qty is not updated. un_inv_qty = un_inv_qty - (con_qty or psl_qty) | Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
1. Updated settlement filter - T not equal to S issue the correct logic:
| Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
| Enhancement |
| |||||||||
2. Save validation in PSL/RECEIVE allocate window logic save enable validation new logic
| Enhancement |
| |||||||||
3. allocate window can‘t save- PSL bug fixed | Enhancement |
| |||||||||
4. Remove the setting to keep two decimal places of qty columns in PSL & INVOICE Remove the setting to keep two decimal places of following qty columns : RECEIVE TABLE INV QTY ISSUE TAB, LOWER TABLE INV QTY ALLOCATE WINDOW OF PSL 3rd panel: QTY ALLOCATE WINDOW OF RECEIVE 1st panel: INV QTY 2nd panel: INV QTY 3rd panel: QTY inv qty will be unlimited dp, amt will be 2dp the rest not indicated above wont change | Enhancement |
| |||||||||
5. add validation when click issue in ISSUE tab only invoices for same company are allowed to issued together. If they click invoices with multiple companies like this, do not allow them to issue | Enhancement |
| |||||||||
6. make save button always loading if no reaction once click In PSL, RECEIVE, ISSUE and allocate window of PSL & RECEIVE once user clicked save button, if no response, make this button always show loading( user can’t click it again until there is response) | Enhancement |
| |||||||||
7. Bug: INV AMT and UN INV AMT both equal 0 use payment_amt instead of psl_amt | Enhancement |
| |||||||||
8. Logic change for PSL table assign contract old logic: assigned contract amt can not less than amount column in selected row. use BE value to compare instead of FE value (BE value all are positive). it means in FE
new logic:
| Enhancement |
| |||||||||
9. Click on fields to view the aggregated summary in PSL and INVOICE in RECEIVE table, ISSUE (both upper and lower table), allocate window of PSL & RECEIVE(only 3rd panel), for all amt and qty related columns, add similar function; Also in PSL table | Enhancement |
| |||||||||
10. UN INV AMT decimal issue In allocate window of ISSUE tab, Our setting for UN INV AMT is to display only two decimal places. This causes an issue where if there are more than two decimal places after this cell, it will display as 0.00 and cannot be saved. The system needs to be configured to allow saving when the first two decimal places of UN INV AMT are both 0. RN for all UN PAYMENT / UN INV AMT, if value < 0.05, treat it as 0. | Enhancement |
| |||||||||
For all contracts in 3rd panel (no matter PURCHASE or SALE contracts), when click or select the contract In 2nd panel, we just create a new PSL record and fill the AMOUNT column with UN PAYMENT AMT in 3rd panel : If UN PAYMENT AMT<0, auto PSL record whose LEDGER TYPE = RECEIVE If UN PAYMENT AMT >0, auto a PSL record whose LEDGER TYPE = PAID
so please remove currently logic if sign of UN PAYMENT AMT is different from sign of PSL in the first panel, the amt will be auto empty. this is the special case, when UN PAYMENT AMT sign is different from sign of PSL AMT in the 1st panel. | Enhancement |
| |||||||||
11. update amt in phy_trade table update inv_amt, payment_amt, inv_qty in phy trade when
test:
| Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
if selected row from 3rd panel, still remain in the 3rd panel (it means the selected contract un_payment_amt or un_inv_qty or un_inv_amt is not 0) please highlight amt, inv qty cell in the row in 2nd panel. Green(Green is for amount that is not equal to contract amt) | Enhancement |
| |||||||||
2. Highlight INV and PSL columns with reversed sign in TRADES table for all PURCHASE contracts: if BAL AMT or UN INV QTY or UN INV AMT <0 , highlight these columns red for all SALES contracts: if BAL AMT or UN INV QTY or UN INV AMT >0, highlight these columns red | Enhancement |
| |||||||||
3. new phy trade table sign convertor bugs For phy trade table payment_amt (psl_amt) psl_amt_bal inv_qty inv_amt inv_qty_bal inv_amt_bal
for those keys, BE already done the converter based on sale or purchase, so please remove converter in FE for those keys |
| ||||||||||
4. Bugs in ag grid table fixed | Enhancement |
| |||||||||
5. In PSL table, contract no dropdown list: delete the contract/ledger type filter condition for all rows, show
In PSL allocate window: delete the contract/ledger type filter condition in the last panel, show contracts
if un_payment_amt in 3rd panel has reverse sign compared to the amt in 1st panel, once click contracts in 3rd panel, amt in 2nd panel would not be filled by un_payment_amt, but leave it empty |
| ||||||||||
6. Highlight UN INV QTY and UN INV AMT with reversed sign in ISSUE tab In ISSUE tab, upper(contracts) table if r UN INV QTY or UN INV AMT >0, highlight these columns red same logic as trade table (please use the same function to handle it) | Enhancement |
| |||||||||
7. add more columns in 3rd panel of allocate window - PSL and RECEIVE add these columns in 3rd panel of allocate window PSL INVOICE MONTH ACTUAL PEICE FLAG EXECUTION STATUS STOCK DATE WH NAME & STATUS STOCK QTY UNSTOCK QTY PSL AMT PSL DATE INV QTY INV AMT UN INV QTY UN INV AMT REMARKS
RECEIVE INVOICE MONTH ACTUAL PEICE FLAG EXECUTION STATUS STOCK DATE WH NAME & STATUS STOCK QTY UNSTOCK QTY PSL AMT PSL DATE BAL AMT INV QTY INV AMT REMARKS | |||||||||||
8. FE issue of delete contract no before save in PSL tab In PSL, when assign contract no, COUNTERPARTY will auto fill. If user tried to delete contract no before save, COUNTERPART should change back to blank, now it would not. | Enhancement |
| |||||||||
9. add more columns in upper table of ISSUE tab BRAND SPECIFICATION PSL AMT BAL AMT REMARKS | Enhancement |
| |||||||||
10. when change data range, there is contract map bug move the from to date and search button to the upper table. for physical trade API select, add from to date to filter select in BE to ensure the select rows are the same as dropdown list phy_trades | Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
qty in contract no dropdown list should be contract actual qty or qty (priority: contract actual qty > qty) | Enhancement |
| |||||||||
2. In issue tab upper table add two columns
API:
in lower table QTY is INV QTY actually (not contract QTY) AMT is INV AMT actually (not contract AMT) change the columns name from
initial value map
IN RECEIVE tab table, Please change column name QTY to INV QTY AMT to INV AMT | Enhancement |
| |||||||||
3. Narrow the borders and navigation bar on our webpage to match the width of the left border and bookmark bar shown in the image | Enhancement |
| |||||||||
4. for invoice issue or receive when save to BE, inv_amt, inv_qty must be positive! BE also need do some validation.
| Enhancement |
| |||||||||
5. Issue tab - when press save button to call BE API to upsert for pay_inv_amt_list, we only update rows if there is a update. currently, we just update all rows, which is incorrect. | Enhancement |
| |||||||||
6. Receive tab - when click “总计” and upload file, it shows error bug fixed | Enhancement |
| |||||||||
7. Issue tab - they need to edit the invoice in issued page; now once they edit and click save, system is supposed to move these invoices back to unissued page.
| Enhancement |
| |||||||||
invoice, psl recalculate function bugs = in dropdown list, for Contract No (phy_trade_id) in BE, all keys are converted sign based on purchase or sales | Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ps ledgers: CONTRACT NO. REMARKS invoice: INVOICE ID CONTRACT NO.
| Enhancement |
| |||||||||||||||||
| Enhancement |
| |||||||||||||||||
2. PS Ledger - Unpayment amount calculations and contract number drop down bug fixed | Enhancement |
| |||||||||||||||||
3. Invoice (Issue) - INVOICE ID in issue table be automatically generated by system, no rules, just be different with each other
重量,含税金额,不含税金额,税额 in exported file should be positive, negative in table only | Enhancement |
| |||||||||||||||||
4. Invoice (Issue) - bug fixed
| Enhancement |
| |||||||||||||||||
5. PS Ledger - Allocate PSL allocate: 1、in allocate pop window, show all UN_PSL_AMT not 0 (depends on in PSL or INVOICE) table contracts rows with the same of counterparty name(THIRD PARTY in PSL record) and same company name with selected row above
2、add combine function for PSL (FE and BE) condition and logic
FE:
Contract's counterparty match with Third Party (not counterparty) in Psl record | Enhancement |
| |||||||||||||||||
6. General Ledger - Add tick row to view aggregated summary | Enhancement |
| |||||||||||||||||
7. Change ? icon message fo PS Ledger and Receive tab | Enhancement |
| |||||||||||||||||
8. PSL tables
receive table
| Enhancement |
| |||||||||||||||||
9. BOTH PSL and RECEIVE tab allocate: 1、when they allocate the contracts to psl or invoice records, once amount Change the positive/negative sign, It should show red and allocate can’t be confirmed. 2、When the assigned and amount of contracts are greater than the qty and amount of invoices or psl(which means they will change the positive/negative sign of amount), please reduce the assigned qty and amount to match the qty and amount of invoices or psl 3、FE: add select all tick box for lower table, add sum function in all three tables for all qty and amt related columns
RECEIVE tab: 1、add QTY in middle table, add UN INV QTY in lower table 2、When they allocate the AMT, firstly we allocate the TAX AMT proportionally, calculate the AMT BEFORE TAX of each contract (AMT - AMT BEFORE TAX), then we can calculate the balance of these three amt of selected invoice. |
| ||||||||||||||||||
10. PSL and RECEIVE allocate issue
| Enhancement |
| |||||||||||||||||
11. In both PSL and INVOICE (receive and issue) table, contract no dropdown list: add PURCHASE/SALE information
In PSL tab: CONTRACT NO dropdown list should only show physical trades whose purchase/sale type related to ledger TYPE (if ledger TYPE = PAID, only show PURCHASE contracts; if ledger = RECEIVE, only show SALE contracts the filter logic is the same as the logic as ticket 3777 | Enhancement |
| |||||||||||||||||
12. Issue tab - when click contract in top table, will show error to fill amount but no price information from BE, system can’t calculate amount | Enhancement |
| |||||||||||||||||
13. PS Ledger - condition and logic change for combine function
| Enhancement |
| |||||||||||||||||
14. Invoice issue table: CONTRACT NO dropdown list should only show physical trades whose purchase type = Sale | Enhancement |
| |||||||||||||||||
15. PS Ledger and Receive tab - Disable allocate button for assigned table | Enhancement |
| |||||||||||||||||
16. PS Ledger and Invoice contract no dropdown list filter logic
similar to what charles mentioned previously, please make sure the contracts with the same counterparty/third party will appear at the top of the contract number dropdown list “contracts with the same counterparty/third party will appear at the top of the contract number dropdown list” This means the contracts whose counterparty is same as the third party of PSL should appear at the top for example: here the third party = HEHE, so all the contracts with counterparty = HEHE should show in the top, not EEE currently they only choose ITEMS in issue table, contract no will be auto fill once they click the contract in upper table. so will disable contract number column | Enhancement |
| |||||||||||||||||
17. stable FE: phy trades table upsert bug - when update or insert, please do not pass sign to BE. BE only store positive number. Please check such as qty, contract actual qty … specially for sales contract. urgent!
BTW, BE dev_3.1.4 add some converter to ensure qty is positive. but in testing server, new_master branch, I have not merged yet. | Enhancement |
| |||||||||||||||||
18. Enhancement for allocate in psl and combine New:
2、add combine function for PSL (FE and BE) condition and logic
FE:
| Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1. PS ledger adjustment for contract no. drop down list and split function
| Enhancement | ||||||||||||||||||||||||||||||||||
2. Bulk Issue Invoice 批量开票
| New Feature |
| |||||||||||||||||||||||||||||||||
2. Dashboard - Daily Statement scroll bar bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
3. PS Ledger - In allocate pop window, show all UN_PSL_AMT or UN_INV_AMT not 0 (depends on in PSL or INVOICE) table contracts rows with the same of counterparty name and same company name with selected row above 4. If not allocate, the dropdown list of contract no is supposed to only show contracts with same company name with selected psl, The contract corresponding to the same counterparty with psl shall be displayed at the top. | Enhancement |
| |||||||||||||||||||||||||||||||||
5. PS Ledger and Invoice - Recalculate button does not work bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
6. New Physical Trades - PS Ledger Receive page TAX AMT (AMOUNT * TAX RATE) CHANGE TO psl_amt_tax - psl_amt | Enhancement |
| |||||||||||||||||||||||||||||||||
7. Group-level(ops) personnel are not allowed to modify or delete PSL and invoicing information imported under company-level accounts. They can only assign under the contract number or split(allocate) the records. Non-creator should only be allowed to edit following columns: ps ledgers: CONTRACT NO. REMARKS invoice: INVOICE ID CONTRACT NO. logic in FE
| Enhancement |
| |||||||||||||||||||||||||||||||||
After UN INV QTY done in invoice tab, we should work on this issue: They will convert the unit from tons in the contract to kilograms when recording invoice information. Our current setting allows them to change the unit and manually convert the quantity and price. However, we also need to consider the consistency of the unit when calculating the UN INV QTY
e.g., invoice unit is KG and qty is 1000, but contract unit MT, therefore con_qty is 1000 / 1000 = 1 MT (convert from 1000KG) to be aware that from_unit must be the same dim as to_unit’s. it means e.g., MT to KG you can not convert from MT to Barrels here. | Enhancement |
| |||||||||||||||||||||||||||||||||
8. PS Ledger -
| Enhancement |
| |||||||||||||||||||||||||||||||||
9. New Physical Trades - Copy paste and ctrl + shift + v bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
10. RECEIVE tab - CONTRACT NO dropdown list should only show physical trades whose purchase type = Purchase | Enhancement |
| |||||||||||||||||||||||||||||||||
11. PS Ledger - Unpayment amt incorrect bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
12. Updated Settlement - cannot open page bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
13. PS Ledger - Contract No. filter bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
14. Issue invoice page - Assigned/Unassigned drop down list bug fixed | Enhancement |
| |||||||||||||||||||||||||||||||||
15. Template 列间距再缩小一点,让一个页面能看到更多内容 浅色版与深色版列宽不一致(浅色比深色更宽一点),且浅色版高度小中大三种模式与深色版也不一致 | Enhancement |
| |||||||||||||||||||||||||||||||||
16. PS Ledger enhancements amt amt includes tax, need to remap into upload file amt before tax
tax amt
psl_amt_tax is no longer exist. | Enhancement |
| |||||||||||||||||||||||||||||||||
17. RECEIVED tab in new physical trade same as AGGR tick box in create new paper trade, user can tick the box or not to choose if they want to aggregate uploading data. Aggregate rule does not change, just make sure they can also upload without group/sum. ”1: For Aggregate : after they upload the file, system should aggregate all the rows with same “开票日,商品名称,规格型号,单位,税率,销方名称, 税收分类编码“ and recalculate the sum of “数量,金额,税额,价税合计”” | Enhancement |
| |||||||||||||||||||||||||||||||||
18. in both receive and issue table, add con qty column after qty Chinese: 转换后数量 Receive 转换后重量 Issue | Enhancement |
|
...
Issue/Request | Type | User Guide | Jira Ticket | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
1: For Aggregate : after theyupload the file, system should aggregate all the rows with same “开票日,商品名称,规格型号,单位,税率,销方名称, 税收分类编码“ and recalculate the sum of “数量,金额,税额,价税合计” 2: Add UN INV QTY(未开票数量)in contract no dropdown list Same logic as UN INV AMT, when there is contract actual qty, we use that for contract qty, else we just use qty in trades. 3: For split: allow them to split both QTY and TOTAL PRICE & TAX when add new row or split: after users assign contract no, auto fill QTY AND INV AMT based on UN INV QTY and UN INV AMT(same logic as PSL) 4: no idea about why “税额“(TAX AMT) is missing now, add that column (both in table and split page) 5: INV AMT column should be UN INV AMT, same logic in PSL Our previous idea was not to separately set the UN INV QTY, but to retrieve the price from the contract after the contract is assigned . In theory, this would only require splitting the total price & tax However, Sometimes when there is no pricing in the contract but an invoice needs to be issued, haitian will randomly use a market price to issue a partial invoice. After the pricing is finalized, the remaining invoice will be issued and the price at that time will be calculated by subtracting the previous invoiced amount from the final amount in the contract.. | Enhancement |
| |||||||||
Internal stock action Optimization: Currently, the process of relocating items within the warehouse is too complex. |
| ||||||||||
Display data modified on the current day using colors the areas that have been newly added or modified on the same day be highlighted with a color or another visual indicator to easily indicate updates? Note: This request has been cancelled at 1:30 pm on the following day. |
| ||||||||||
Handle annual settlement |
| ||||||||||
GENERAL LEDGER, Separate FUND IN/OUT and EXP/INC into two different modules. |
| ||||||||||
In Admin page, add a new tab table called CLEAN UP the able is the same as user management, the only different is
once we have the table in FE, we need some buttons to for all those users.
for delete trade:
same as delete physical trade and delete portfolio
we must use existing delete functions coz they will other linked actions such as recal portfolios … |
| ||||||||||
Short form for company name |
| ||||||||||
Auto save function |
| ||||||||||
Dashboard - currently we have performance issue in dashboard. so let’s limit No. of apps loading once a time
|
| ||||||||||
PS Ledger - split multiple records one time |
| ||||||||||
...