Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Return to Overview

...


Name
Description
Type
Example
Start DateStart of product time-series. Empty by default, you are free to fill in as necessary.Date (YYYY-MM-DD)2015-06-01
End DateEnd of product time-series. Today's date by default.Date (YYYY-MM-DD)2019-06-14
Auto Update (question)

Tick: Resets the dates to default once you leave the ‘Dashboard’ page.

Untick: Dates according to your settings remain unchanged once you leave the ‘Dashboard’ page.

Checkbox-
CommentsUseful for documentation purposes or for settings description.Text-


...


Description

Type

Product/Strategy Information

Basically if input data in PS Ledger, the total quantity and amount with PSL TYPE as INVOICE for the trade will be reflected as SETTLED quantity and amount in the Physical Trade Status app; otherwise, will be reflected in UNSETTLED quantity and amount.

If input data in PS Ledger, the total quantity and amount with PSL TYPE as PAYMENT for the trade will be reflected as SETTLED quantity and amount in the Physical Trade Status app; otherwise, will be reflected in UNSETTLED quantity and amount.

This app uses Contract No. to link the stock in/out cargo to the contract, allowing accurate monitoring of cargo quantity and amount.

If the undelivered/open quantity and amount (Unsettled Qty and Unsettled Amount) are displayed in red, it means that the inventory has not been completed yet, allowing you to monitor and manage your outstanding contracts more efficiently.

STATUS: If all unsettled contract is settled (quantity and amount displayed as 0), the status will auto become "settled"

UNSETTLED QTY: For stock contract quantity that has not been input as PAYMENT (PSL TYPE) into PS Ledgers table, the total stock quantity will be reflected as Unsettled Qty in the app. Unsettled Qty = Actual Qty - Settled Qty

UNSETTLED AMT: For stock contract quantity that has not been input as PAYMENT (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Unsettled Amt in the app

UNSETTLED INV QTY:  For stock contract quantity that has not been input as INVOICE (PSL TYPE) into PS Ledgers table, the total stock quantity will be reflected as Unsettled Inv Qty in the app Unsettled Inv Qty = Settled Invoice Qty - Invoice Qty. Invoice Qty refers to the quantity input as INVOICE (PSL TYPE) into PS Ledgers table.

UNSETTLED INV AMT: For stock contract quantity that has not been input as INVOICE (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Unsettled Inv Amt in the app

SETTLED QTY: If you input the stock contract as PAYMENT (PSL TYPE) into PS Ledgers table, the total stock quantity will be reflected as Settled Qty in the app. Settled Qty = Actual Qty

SETTLED AMT: If you input the stock contract as PAYMENT (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Settled Amt in the app

SETTLED INV QTY: If you input the stock contract as INVOICE (PSL TYPE) into PS Ledgers table, the total stock quantity will be reflected as Settled Inv Qty in the app

SETTLED INV AMT: If you input the stock contract as INVOICE (PSL TYPE) into PS Ledgers table, the total stock amount will be reflected as Settled Inv Amt in the app


  • Unsettled Amt and Contract Amt can be empty as Actual Price is not filled so we do not know the value of the contract, this allows user to monitor if the contract has Actual Price or not


Text


...

Example



Add a column called ACTUAL QTY (实际量) after CONTRACT QTY

  1. SETTLED QTY now is ACTUAL QTY

  2. UNSETTED QTY = ACTUAL QTY - SETTLED QTY

  3. UNSETTED INV QTY = SETTLED QTY - INVOICE QTY



Example:

After inputting a new trade and its title transfer date, the trade will appear in the Physical Trade Status table. 

...