User Tools

Site Tools


finance:utilities:mergevendornumber

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
finance:utilities:mergevendornumber [2017/08/15 21:01] emorenofinance:utilities:mergevendornumber [2021/01/27 16:19] (current) emoreno
Line 5: Line 5:
 //**Finance > Utilities > Merge Vendor Number**// //**Finance > Utilities > Merge Vendor Number**//
  
-<WRAP round intro>utility is used to move all vendor information from one vendor to another vendor. Use the utility when two different vendor numbers are assigned to the same vendor.+<WRAP round intro>This utility is used to move all vendor information from one vendor to another vendor. It can also be used when two different vendor numbers are assigned to the same vendor.
  
 **Notes**:   **Notes**:  
   * When you select to merge from vendor A to vendor B, the transactions for vendor A are combined with vendor B's transactions, and then vendor A is deleted.   * When you select to merge from vendor A to vendor B, the transactions for vendor A are combined with vendor B's transactions, and then vendor A is deleted.
-  * If a vendor has been used in a previous file ID, the vendor cannot be merged until that file ID has been deleted. 
   * In Finance, the vendor name for paid checks will remain the same (From Vendor) after merging the vendors. The vendor number will change to the To Vendor number.       * In Finance, the vendor name for paid checks will remain the same (From Vendor) after merging the vendors. The vendor number will change to the To Vendor number.    
   * In Finance, the vendor name for unpaid checks will be the To Vendor Remittance Address name. If the remittance address is blank, then the To Vendor name will be used.     * In Finance, the vendor name for unpaid checks will be the To Vendor Remittance Address name. If the remittance address is blank, then the To Vendor name will be used.  
Line 17: Line 16:
  
  
-[[https://txeis.net/upload/page/0051/docs/TxEIS%20Import%20Travel%20Check%20Transactions.pdf|File layout]] 
 </WRAP> </WRAP>
  
Line 24: Line 22:
  
 ^Field ^Description ^ ^Field ^Description ^
-^From Vendor Number|Begin typing the vendor name or number. As you type the data, a drop-down list of corresponding data is displayed. Select the desired vendor number or name. Or, click {{:images:picklist_large.png|}} to select a valid vendor from the list of existing vendors (both active and inactive). The **Vendor Information**, **Order Address**, and **Remittance Address** sections are populated based on the to vendor number selected. This is a required field.|+^From Vendor Number|Begin typing the vendor name or number. As you type the data, a drop-down list of corresponding data is displayed. Select vendor number or name. Or, click {{:images:picklist_large.png|Picklist Icon}} to select a valid vendor from the list of existing vendors (both active and inactive). The **Vendor Information**, **Order Address**, and **Remittance Address** sections are populated based on the to vendor number selected. This is a required field.|
  
-Click **Refresh From Vendor** to update the vendor information if the vendor number in the **From Vendor Number** field is changed.+VCV Click **Refresh From Vendor** to update the vendor information if the vendor number in the **From Vendor Number** field is changed.
  
-^To Vendor Number|Begin typing the vendor name or number. As you type the data, a drop-down list of corresponding data is displayed. Select the desired vendor number or name. Or, click {{:images:picklist_large.png|}} to select a valid vendor number from the list of existing vendors (both active and inactive). The **Vendor Information**, **Order Address**, and **Remittance Address** sections are populated based on the to vendor number selected. This is a required field.|+^To Vendor Number|Begin typing the vendor name or number. As you type the data, a drop-down list of corresponding data is displayed. Select vendor number or name. Or, click {{:images:picklist_large.png|Ellipsis Icon}} to select a valid vendor number from the list of existing vendors (both active and inactive). The **Vendor Information**, **Order Address**, and **Remittance Address** sections are populated based on the to vendor number selected. This is a required field.|
  
-Click **Refresh To Vendor** to update the vendor information if the vendor number in the **To Vendor Number** field is changed.+VCV Click **Refresh To Vendor** to update the vendor information if the vendor number in the **To Vendor Number** field is changed.
  
-Click **Execute** to start the merge process. A message is displayed indicating that you are about to update records permanently and confirming that you want to continue. Click **Yes** to continue processing the merge function, or click **No** to cancel the merge. If the user clicks **Yes**, then a message is displayed asking if you would like to create a system backup. A backup is highly recommended.+VCV Click **Execute** to start the merge process. 
  
-Click **Yes** to export a copy of the affected tables, or click **No** to not create the backup and continue with the merge. If the user clicks **Yes**, the export tables dialog box is displayed.+<div indent>A message is displayed indicating that you are about to update records permanently and confirming that you want to continue.  
 +</div> 
 +  * Click **Yes** to continue processing the merge function, or click **No** to cancel the merge.  
 +  * If you click **Yes**, you are prompted to create a backup using the Export By File ID Utility before continuing. 
 +    * Click **Yes** to continue with the merge. A message is displayed indicating that the vendor numbers were merged. Click **OK**. 
 +    * Click **No** to exit the process.
  
-  * In the **Export Path** field, perform one of the following functions: 
-    * Type the drive and folder name of where to export a copy of the tables. The system creates the export files (e.g., db001007_6_03192002_01(s).rsf for payroll). 
-    * Click **Browse**, then select the folder into which to export a copy of the tables. 
-    * Click **OK** to select the folder, or click **Cancel** to close the dialog box without processing. 
-  * Click **Execute**. A message is displayed asking you to verify the path of the export. 
-    * Click **Yes** to accept the export path or No to not accept the export path and return to the Merge Vendor Number page. 
-    * Click **Cancel** to close the dialog box without exporting tables. 
-  * In the archive password dialog box, type a password, and then click **OK**. 
-  * The tables are exported, and a message is displayed indicating that the export process completed successfully. Click **OK**. 
-  * A dialog box is displayed indicating that the vendor numbers were merged. Click **OK** to return to the Merge Vendor Number page. 
  
 {{indexmenu_n>75}} {{indexmenu_n>75}}
finance/utilities/mergevendornumber.1502830895.txt.gz · Last modified: 2017/08/15 16:01 (external edit)