Updating the Matching Reference on Transaction Records
You can add or replace the matching reference on the transaction record to facilitate the search and identification of transaction lines on the GL Matching Dashboard.
Adding or editing the matching reference of the transaction will update the matching references of all transaction lines in that record that belong to a GL Matching-included account.
All roles with the GLM - Dashboard reference permission can add, edit, or delete the matching reference. For information about custom permissions, see Adding Standard and GL Matching Custom Permissions.
You can update the matching reference either directly on the transaction record or using a CSV import.
To update the matching reference on a transaction:
-
Open the transaction record where you want to add or edit the matching reference.
-
Go to the GL Matching subtab.
-
On the Matching Reference for All Lines field, enter the new matching reference.
-
Click outside the field.
A popup message appears.
-
Click Yes, continue if you want to proceed with the change. Click No, cancel if you do not want to update the matching reference.
-
Click Save.
The update may take a few minutes after saving the transaction.
To update the matching reference using a CSV import:
-
Go to Setup > Import/Export > Import CSV Records.
-
In the Import Type field, select Transactions.
-
In the Record Type field, select the transaction record type that you want to import.
-
Choose either One File to Upload or Multiple Files to Upload depending on the number of files you want to import.
-
Select the file that you want to import from your computer. For more information, see Select a File for Import.
-
Click Next.
-
On the Import Options page, choose Add. For more information about other import options, see Step Two Import Options.
-
Click Next.
-
(Required for multiple files import only) On the File Mapping page, select a key column from the linked files to map to the primary key column. For more information, see Step Three File Mapping.
-
On the Field Mapping page, verify that the Memo on your CSV file is mapped to the CSV Reference field in the left pane.
-
(Optional) On the Field Mapping page, click the edit icon next to the CSV Reference field in the left pane. Add a short text that will be used as the matching reference.
-
Click Next.
-
On the Save Mapping & Start Import page, enter an import map name and description.
-
Click Save & Run.
For more information about checking the import status, see Viewing the CSV Import Job Status Page.
The reference may take some time to update after the import process is complete.