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