Calculate unit price

This command helps you determine the unit price when only the total amount and the quantity of the securities sold are known. It is particularly useful when a bank statement provides only these two values, but not the precise unit price.

How It Works

1. Select the security sale transaction row: This row should contain the total amount of the sale (the net proceeds), but no quantity or unit price yet.
2. Enter the quantity: When you run the Calculate Unit Price command, a dialog will ask you to enter the quantity of the securities sold.
3. Review the Preview: After the command calculates the unit price by dividing the total amount by the entered quantity, a preview of the updated row is displayed. You can accept or cancel these changes before they are applied.
4. Confirm the Changes: Once you confirm, the newly calculated unit price is applied to the transaction row, making it ready for any further actions (e.g., generating a final sale record or calculating profit or loss).

Troubleshooting

• The selected row does not contain the Security ID: This message is shown when you are trying to create sales records having selected a row without a valid security id. Each row on which changes are made must contain the valid id of a title in the Items table.
• The selected row does not contain a valid Amount: This message is shown when you are trying to create sales records having selected a row with a non valid amount.
• The selected row in the Transactions table is not valid: The selected row in the transactions table is not a valid row.