Updating the Matching Reference on Transaction Records
You can add or change the matching reference on the transaction record to help find transaction lines on the GL Matching Dashboard.
Adding or editing the matching reference updates all transaction lines in that record that belong to a GL Matching account.
Anyone 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 on the transaction record or through a CSV import.
To update the matching reference on a transaction:
-
Open the transaction record you want to add or edit the matching reference for.
-
Go to the GL Matching subtab.
-
On the Matching Reference for All Lines field, enter the new matching reference.
-
Click outside the field and you'll see a message.
-
Click Yes, continue to proceed with the change.
Click No, cancel if you don't want to update the matching reference.
-
Click Save.
The update may take a few minutes after you save 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 type you want to import.
-
Choose One File to Upload or Multiple Files to Upload, depending on how many files you're importing.
-
Select the file 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.