Transaction Reconciliation Fields
Here is a description of the elements on the Transaction Reconciliation page.
Transaction Line Lists
The following information is displayed above each list.
Field | Description |
---|---|
Search box | Search the list for particular transactions by entering search text in this box. The results are filtered so that only lines matching the search text are displayed. The matching text is highlighted on each line. Use the < and > buttons to cycle through selecting each transaction line in turn. Clear the search text to display all the transaction lines retrieved in the list. Note that only data displayed in the grid is matched against the search text. |
Show All drop-down list | Allows you to switch between displaying selected and deselected transactions lines in the list. By default all transaction lines that match the search text are displayed. |
Transactions Retrieved | The total number of transaction lines retrieved in this list. |
Total Retrieved | The total value of the transaction lines in this list. |
Unreconciled | The total value of all unreconciled transaction lines in this list. This value updates automatically in response to your selections. |
Reconciled | The total value of all reconciled transaction lines in this list. This value updates automatically in response to your selections. |
Transaction Reconciliation Detail
Here are the fields and buttons that display on the Transaction Reconciliation Detail page.
Fields
Key: R – Read-only in all contexts.
Field |
|
Description |
---|---|---|
Reconciliations Name | Name of the transaction reconciliation. | |
Description | Description of the transaction reconciliation. | |
Status | R | Status of this transaction reconciliation: "Error", "In Progress", or "Reconciling". |
Outstanding Difference | R | Difference between the total line in both the grid and the selected lines. |
Buttons
Button | Description |
---|---|
Back to List | Returns you to the Transaction Reconciliations list view. |
Commit |
Stores reconciliation information, such as reconciliation name and date, back to the transaction line item to show that it has been included in a reconciliation. |
DEPRECATED: Commit | This button is obsolete. To store reconciliation information back to the transaction line from a Lightning page, you must add the Commit button to the page. |
Rerun Batch | Reruns the batch after an error has occurred in the unreconciliation process. |
Retrieve | Retrieves transaction line data based on your filter criteria. |
Save Draft |
Saves the current reconciliation without committing any changes to the transaction lines. A record of the selections you have made for the current filter criteria is saved for you to refer back to or resume working on in future. |
Unreconcile | Unreconciles selected transaction line items in a reconciliation transaction record. |
Transaction Reconciliation Window
The following fields and buttons display on the Reconcile Transactions window.
Fields
Your System Administrator can customize the columns in this window by editing the Transaction Reconciliation Columns field set on the Transaction Line Item object. The eight fields shown in the table below cannot be removed from the field set.
Field | Description |
---|---|
Account | The account for this transaction. |
Document Value | The value for the transaction line item. |
Document Currency | The document currency taken from the transaction line item. |
Transaction Date | Date copied from the originating document, such as the invoice or cash entry date. |
Line Description | The description taken from the transaction line item. |
Document Number | The document currency taken from the transaction line item. |
Intercompany Transfer | Link to the related intercompany transfer record. |
Buttons
Button | Description |
---|---|
Auto Match Settings | Displays the Auto Match window, where you can select the fields to use for automatic matching. |
Reconcile and Continue |
Stores reconciliation information, such as reconciliation name and date, back to the transaction line item to show that it has been included in a reconciliation. |
Reconcile and Finish | Reconciles the selected transactions and closes the Transaction Reconciliation window. |
Cancel | Cancels the reconciliation and closes the window. |
Close | Closes the Transaction Reconciliation window. This button only displays if there are no available transactions to reconcile in one or both of the grids. |
Transaction Filtering
When you retrieve transactions for reconciliation, any filters that you apply are used in subsequent transaction retrievals. You can click Clear to remove these filters. If you change the filters while reconciling transactions, the changes are saved for future transaction retrievals when you click Reconcile and Finish.
Fields
The following fields are displayed for each company on the Retrieve Transactions window:
Field | Description |
---|---|
Account | The account you want to retrieve transactions for. If you have encryption enabled in your org, you must be as specific as possible when typing the account name to ensure that the account is found. See Shield Platform Encryption for more information. |
Company |
The company you want to retrieve transactions from. If you subsequently retrieve transactions for the same reconciliation, this field is read only. |
GLA | The general ledger account that you want to retrieve transactions for. You can select multiple GLAs from a drop-down list, or enter a From/To range. |
Period | The accounting period you want to retrieve transactions for. It defaults to the current period for the selected company. You can select multiple periods from a drop-down list, or enter a From/To range. |
Buttons
The following buttons are displayed on the Retrieve Transactions window.
Button | Description |
---|---|
Cancel | Cancels the selections and closes the Retrieve Transactions window. |
Clear | Clears all data from the related company. |
Copy Data |
Copies the selections from the First Company to the Second Company fields. |
Retrieve | Retrieves transactions using the selected criteria. |
Auto Match
The following fields, links and buttons display on the Auto Match window.
Fields
Field |
Description |
---|---|
Save As Default | Sets the selected fields as default criteria to use in all transaction reconciliations. |
Transaction Fields | The fields selected as criteria for automatic matching. You can select up to 5 transaction fields. |
Buttons and Links
Button or Link |
Description |
---|---|
Removes the selected transaction field. | |
Add More Fields | Adds more fields to the Transaction Fields list. You can have a maximum of 5 fields. |
Apply | Applies the selected criteria to the current transaction selections. |