Page Comparison

1. New Physical Trades -

• PS Ledger

• • add additional information for CONTRACT NO.

• • dropdown list:

    1、UN INV AMT （未开票金额） - invoice

    2、未收/付款 - PSL

    • un_inv = CONTRACT AMT - inv_amt

un_payment = CONTRACT AMT - payment_amt

any insert or update in PSL or Invoice table, will update inv_amt or payment_amt in phy_trade table

when dropdown list in PSL or invoice table, BE do calculate un_inv_amt or un_payment_amt, if it is close to 0, we filter out. coz those contract already fully settled.

be careful purchase, sales of contract and credit, debit of payment and invoice. sign is important here

FE need to keep update un_inv_amt or un_payment_amt if any contract selected before saving.

un payment amt should = contract AMT is payment_amt is empty. coz un_payment_amt = contract_amt - payment_amt(payment_amt from db)

contract_amt should be contract qty x price, which should be calculated in BE when select.

In 5 conditions FE should change the un payment in dropdown list of contract (before save):

1: Assign contract no to PSL

2: change the contract no (from A to B )

3: Delete the contract no

4: delete row with contract no

5: change psl amt with contract no

• the dropdown list be sorted by the latest contract date（DATE in TRADES tab) at the top of the list. after entering the customer name

  • Since it returns un payment,
    autofill AMOUNT with un_payment_amt calculated by BE in contract dropdown list in PSL when they choose the contract

  • in invoice table and psl table, inv_amt and psl_amt in Database should be always positive.

    we use ledger type to control the amt should be positive or negative.

    if split in psl into negative, I suggest we update ledge type to PAID (negative), RECEIVED (positive).

  • 1、dropdown list, when users choose the “Assigned(已分配） ”，table will show all PSL or invoice with contract no.
    when users choose “Unassigned（未分配）”, table will show all PSL or invoice without contract no.

     

    2、default：Unassigned，show all PSL or invoice without contract no

Enhancement

2. New Physical Trades -

• Invoice

  • add additional information for CONTRACT NO. dropdown list:

    1、UN INV AMT （未开票金额） - invoice

    2、未收/付款 - PSL

    • un_inv = CONTRACT AMT - inv_amt

      un_payment = CONTRACT AMT - payment_amt

  • in invoice table and psl table, inv_amt and psl_amt in Database should be always positive.

  • we use ledger type to control the amt should be positive or negative.

  • if split in psl into negative, I suggest we update ledge type to PAID (negative), RECEIVED (positive).

  • Upload bug fixed

  • 1、dropdown list, when users choose the “Assigned(已分配） ”，table will show all PSL or invoice with contract no.
    when users choose “Unassigned（未分配）”, table will show all PSL or invoice without contract no.

 2、default：Unassigned，show all PSL or invoice without contract no

• In 5 conditions FE should change the un payment in dropdown list of contract (before save):

1: Assign contract no to PSL

2: change the contract no (from A to B )

3: Delete the contract no

4: delete row with contract no

5: change psl amt with contract no

Enhancement

3. Demurrage Claims Table - In demurrage claims table, add a sentence to show how many rows have been updated when saved so user can tell immediately if more rows have been updated unintentionally

Enhancement

1. Company Data - Add new tab in company data management

Enhancement

1. New Physical Trades -

• Upload invoice bug fixed

• Price Before Tax bug fixed

• Map Unit when upload invoice

• Upload PS Ledger bug fixed

• PS Ledger

  • Hide MAIN CONTRACT NO. , QTY, PRICE, UNIT, PRICE UNIT, RATIO columns

  • COUNTERPARTY and AMOUNT should not be editable after saving (they can only edit these when split)
    Change chinese translation for Third party: 第三方 to 收/付款

  • Counterparty should not be compulsory

  • When COUNTERPARTY ≠ THIRD PARTY, highlight COUNTERPARTY green

  • When filter Trade tab in new physical trades by product, add new row will appear in the table automatically

• Filter all green highlight columns in UPDATED SETTLEMENT

  • Add new checkbox in UPDATED SETTLEMENT

    FILTER T≠S Chinese: 筛选 结算≠合同

    When the user tick the check box，table will only show rows with green highlight

• Group P/L when click Save bug fixed

Enhancement

Creating New Physical Trade(s)

2. Demurrage - Audit Trail missing Created by and Updated by Name

Enhancement

Demurrage Claims Table

Enhancement

3. Daily Statement bug fixed

2. Demurrage - Audit Trail missing Created by and Updated by Name

Enhancement

Demurrage Claims Table

3. Daily Statement bug fixed

Enhancement