Payment Upload Errors

  • Updated

Payment uploads are used to update Unimarket invoices with payment details from your ERP. When these uploads fail, the invoices remain "Awaiting Payment." This guide provides definitions for common errors and instructions on how to resolve them, within your upload file.

 

Error Definitions and Resolutions

Error MessageMeaningResolution
No supplier exists with vendor code "XXXX"There is no supplier profile in Unimarket associated with that specific Supplier ID/Vendor Code.

Verify the ID matches the Supplier ID in Unimarket. If the ID is missing or incorrect in your file, update it to match the Unimarket profile.

Recommendation: Copy information from within Unimarket.

[Invoice Number] doesn't existThe system cannot find the invoice record with the number provided in your file.

1. Go to the Invoices module.

2. Search for the invoice number.

3. If no invoice exists in Unimarket, remove all lines associated with that number from your file and re-upload.

4. Further research the error payments. Once resolved, re-upload them.

Payment must have NEW operation typeThe "Operation" column in your file is missing or contains an invalid value.

Every row in your payment upload file must have the word NEW (case-sensitive) in the Operation column.

Note: If the payment already exist in Unimarket (i.e. not NEW), refer to the Payment Status Transactions flowchart (below) to determine what the status should be, at the time of upload.

(Payment Method): 'XXXX' is not valid valueThe payment method text in your file does not match the exact values recognized by your community.

1. Locate the Supplier Profile in Unimarket.

2. Go to Transactions > Invoices.

3. Click the Payments tab of a successfully paid invoice.

4. Copy the exact text of the Payment Method (e.g., 'ACH/EFT') and paste it into your file.

Multiple invoices found with the identifier "...", none matched by supplier name [...]There is a mismatch between the invoice number and supplier name in the file.Refer to "Resolving Mismatched Identifiers & Special Characters" (below).
Multiple suppliers provided for payment "XXXX"Two or more supplier profiles share the same Supplier ID/Vendor Code.

Unimarket cannot determine which profile to apply the payment to. You must change the ID on the duplicate or unwanted profile (e.g., append _OLD to the ID).

Refer to "Resolving Duplicate Supplier IDs" (below).

Invalid Payment StatusThe status value (e.g., Void) is not recognized.Ensure you are using only standard Unimarket values. Refer to the Payment Status Transactions flowchart (below).

Resolving Mismatched Identifiers & Special Characters

The error "Multiple invoices found with the identifier..." typically occurs because, the combination of Invoice Number and Supplier Name (in your file) does not match the system records.

Common Causes:

  • Mismatch: The invoice number or supplier name is slightly different (e.g., "Supplier Inc" vs "Supplier Inc.").
  • Special Characters: Hidden spaces or dashes in the invoice number are preventing a match.
  • Formatting: Excel has truncated the number or converted it to scientific notation.

Resolution: The Excel "Text" Recommendation

To ensure your data matches the system exactly, follow these steps:

  1. Locate the record in Unimarket, to verify the correct Supplier Name and Invoice Number.
  2. Copy the supplier's name and invoice number.
  3. In your Excel file, go to the applicable Supplier and Invoice Number cell.
  4. Click in the applicable cell > select Text format, to prevent Excel from stripping leading zeros once the file is saved.
  5. Paste the values directly from Unimarket, into the Excel Formula bar.

 

  1. Check for and remove any special characters or leading/trailing spaces.
  2. Save the file as a CSV (Comma Delimited) and re-upload.

 

Resolving Duplicate Supplier IDs

If you receive the error "Multiple suppliers provided for payment," follow these steps to clear the conflict:

  1. Go to the Administration module > Suppliers > Search Suppliers.
  2. Enter the Supplier ID/Vendor Code from the error message.
  3. Select the "x" in the State field to search all states (Active and Inactive).
  4. If multiple profiles appear, edit the profile you do not want to use and change its' Supplier ID (e.g., add INACTIVE or DO NOT USE, to the front of the ID).

 

Payment Status Transactions Flowchart

 

Best Practices for Successful Uploads

  • Excel Data Integrity: Always set columns to Text before pasting data to prevent Excel from stripping leading zeros.
  • Partial Uploads: If a file contains many errors, it is often faster to remove the problematic lines, upload the "clean" data. And then troubleshoot the failed lines in a separate, smaller file.