Page Comparison

Steps:

...

 如想了解更多关于群组设置，请查阅https://mafint.atlassian.net/wiki/spaces/MCUGC/pages/1858174992#%E8%AE%BE%E7%AB%8B%E7%BE%A4%E7%BB%84 。

...

2.

...

The New Physical Trade function allows users from different departments/teams to access the designated pages to input their data, ensuring a consistent operational workflow and clear delegation of responsibilities for different teams.

Alternatively, you may choose to use the old methods to input your data:

...

录入现货交易数据

新现货合同页面为用户提供了一个多部门协作录入的环境并且与各职能单位的工作流程相匹配。

a.

...

在新现货合同页面中录入基本交易信息 (现货合同)

i. Please click on Trade, followed by New Physical Trade from the navigation sidebar on the left to enter the physical trade page,请在左侧导航栏中选择成交明细，在下拉菜单中点击新现货合同。

...

ii. Please click on + New Trade and a new row will be added for you to input your data. Please refer to the definitions below for more information.

• Trade ID：Input is not required, once you save your trade data, the Trade ID will be generated automatically

• Trade Date*：Trade date of the contract

• Product*：Product name, for example Corn

• Specification：Product specification, you may fill in for your reference if necessary, eg Product is Rubber and specification is XX1

• Entity of Contract*：Name of your company (can be input in Settings>Company>Company Profile page)

• Counterparty*：Counterparty name

• Contract No.：Every purchase and sale contract should have its own contract number

• Purchase/Sale*：Purchase/Buy or Sale/Sell

• Match No.: Assign the same match number to the corresponding purchase and sale contracts for your reference

• Contract Delivery Date: Contract delivery date

• Trader：Name of trader

• Trade Mode *：

  • Offshore refers to offshore contracts - Cannot input for Tax Rate, Exchange Rate and Custom Tax Rate

  • Domestic China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate

  • Delivery China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate

  • Import/Export refers to import/export contracts - Can input Tax Rate, Exchange Rate (If Deal Currency and Product Currency are different) and Custom Tax Rate

  • Basis Trade China - Can input Tax Rate, cannot input Exchange Rate and Custom Tax Rate

If an offshore company imports/exports, there are 3 trades contracts involved:

1. Offshore companies purchase from suppliers - Offshore

2. Offshore companies sell to domestic companies (exported by offshore companies) - Import/Export

3. Domestic companies purchase from offshore companies (imported by domestic companies) - Import/Export

• Quantity*：Contract quantity

• Unit*：Unit of contract/product eg metric ton

• Contract Pricing Date: Contract pricing date

• Margin: Collateral value deposited with the counterparty

• Provisional Price: Temporary price, will be used to calculate P/L if Estimated Price or Actual Price is not available yet. The system will follow this order of priority to calculate P/L if the price is available: Actual Price - Estimated Price - Provisional Price

• Pricing Date：Pricing Date

• Execution Status: Status of contract eg settled, pending etc

• Stock Date: The latest stock in/stock out date recorded in Stock Management Function

• WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here

• Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function

• Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity

• PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger will be automatically reflected here

• PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger will be automatically reflected here

• Bal Amount: Balance Amount = Trade value - PS Ledger Amount will be automatically reflected here

• Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here

• Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger will be automatically reflected here

• Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity will be automatically reflected here

• Un Inv Amt: Un-Invoiced Amount = Trade Value - Invoice Amount will be automatically reflected here

• Remarks：Remarks

Once done, please click on Save Changes to save your data.

b. Input Pricing Data in New Physical Trade (Settlement)

Once done, please click on Save Changes to save your data.

c. Input Stock/Inventory Data in Stock Management

Please refer to Stock Management Function for the user guide.

Once stock data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.

• Stock Date: The latest stock in/stock out date recorded in Stock Management Function

• WH Name & Status: Name of warehouse and Stock Type recorded in Stock Management Function will be automatically reflected here

• Stock Qty: Stock In/Out quantity that has been recorded in Stock Management Function

• Unstock Qty: Stock In/Out quantity that has not been recorded in Stock Management Function, Un-stocked Quantity = Quantity - Stock Quantity

d. Input Payment and Invoice Data in PS Ledger

Please refer to Managing Physical Trades for the user guide.

Once PS Ledger data has been input, the following columns for each trade in the New Physical Trade table will be reflected automatically.

...

PSL Amt: PS Ledger amount with PSL Type: Payment recorded in PS Ledger

...

PSL Date: PS Ledger date with PSL Type: Payment recorded in PS Ledger

...

Bal Amount: Balance Amount = Trade value - PS Ledger Amount

...

Inv Qty: Invoice quantity with PSL Type: Invoice recorded in PS Ledger

...

Inv Amt: Invoice amount with PSL Type: Invoice recorded in PS Ledger

...

Un Inv Qty: Un-Invoiced Quantity = Quantity - Invoice Quantity

...

请点击+新交易，您可以在新添加的一行里录入您的数据。录入数据的细节请参考以下指南：

• 交易ID：非必需录入，当您保存完您的交易数据后，系统会自动生成交易ID。

• 交易日*：合同上注明的交易日。

• 产品*：产品名称，例如 玉米。

• 产品规格：产品规格，如有需要您可以根据您的参考依据来录入, 例如 产品 橡胶，产品规格 XX1。

• 公司名称*：贵公司名称(可以在设置>公司>公司资料中录入)

• 客户名称*：买/卖客户名称

• 合同编号.：每一笔买/卖合同都需要有专属的合同编号。

• 买/卖*：采购或是销售合同

• 匹配号.: 根据相同的匹配号来来一一对应每笔采购和销售合同。

• 提货日: 合同约定的货权转移日。

• 交易员：交易员名称。

• 交易模式 *：

  • 离岸 -对应离岸合同 - 无法录入税率、汇率以及海关税。

  • 内贸 - 可以录入税率，无法录入汇率及海关税。

  • 交割 - 可以录入税率，无法录入汇率及海关税。

  • 进出口 -对应进出口合同-可以录入税率、汇率（当交易币种与产品币种不同时）以及海关税。

  • 基差 - 可以录入税率，无法录入汇率和海关税。

当离岸公司发生进出口贸易时，将会包含以下三种交易合同:

1. 离岸公司从供应商处买入—离岸

2. 离岸公司卖给境内公司 (由离岸公司出口) -进出口

3. 境内公司从离岸公司处买入 (由境内公司进口) - 进出口

• 数量*：合同采购数量。

• 单位*：合同/产品的交易单位 例如 metric ton

• 约定点价日: 合同约定的点价日。

• 保证金比例: 保证金占采购金额的比例

• 临时价格: 暂定价格。当预估价和实际价格不可用时将会被用来计算盈亏。系统使用各项价格数据来计算盈亏的优先级：实际价格>预估价>临时价格。

• 点价日：实际的点价日。

• 采/销执行状态: 合同执行的实时状态，例如 执行完毕。

• 库存单据日期: 在 Stock Management Function 中记录的最新出入库日期。

• 仓储名称/状态: 在 Stock Management Function 中录入的仓库名称和货物状态会在此自动填充。

• 出入库数量: 在 Stock Management Function中录入的总出入库数量会在此自动填充

• 未收货/出库数量: 采/销数量 - 出入库数量

• 款项总额: 在 PS Ledger 录入的总收付款金额会在此自动填充。

• 款项日期: 在 PS Ledger 录入的实际收付款日期会在此自动填充。

• 款项余额: 尾款= 采/销总额 - 款项总额，会在此自动填充。

• 发票数量: 在PS Ledger录入的总发票数量会在此自动填充。

• 发票金额: 在PS Ledger录入的总发票金额会在此自动填充。

• 未开票数量: 采/销数量 - 发票数量，会在此自动填充。

• 未开票金额: 采/销金额 - 发票金额，会在此自动填充。

• 备注

录入完毕后，请点击保存来保存您的数据。

...

b. 在新现货合同中录入价格数据(结算价)

录入完毕后，请点击保存来保存您的数据。

...

c. 在库存管理中录入库存数据

请参考 Stock Management Function 。

当出入库数据被录入后，以下的条目会在新现货合同页面中自动填充。

• 库存单据日期: 在 Stock Management Function 中记录的最新出入库日期。

• 仓储名称/状态: 在 Stock Management Function 中录入的仓库名称和货物状态会在此自动填充。

• 出入库数量: 在 Stock Management Function中录入的总出入库数量会在此自动填充

• 未收货/出库数量: 采/销数量 - 出入库数量

...

d. 在采销金额中录入收付款、发票数据。

请参考 Managing Physical Trades 。

当收付款、发票数据录入后，以下的条目会在新现货合同页面中自动填充。

• 款项总额: 在 PS Ledger 录入的总收付款金额会在此自动填充。

• 款项日期: 在 PS Ledger 录入的实际收付款日期会在此自动填充。

• 款项余额: 尾款= 采/销总额 - 款项总额，会在此自动填充。

• 发票数量: 在PS Ledger录入的总发票数量会在此自动填充。

• 发票金额: 在PS Ledger录入的总发票金额会在此自动填充。

• 未开票数量: 采/销数量 - 发票数量，会在此自动填充。

• 未开票金额: 采/销金额 - 发票金额，会在此自动填充。

...

3. 创建量化模型/报表

仪表盘-我的仪表盘

...