Skip to main content
Answer

Conversion error

  • March 28, 2025
  • 2 replies
  • 78 views
N
Freshman I

I am trying to retrieve the tax ID number from the vendor table. I see the field I need, but it comes up blank. All I need is the vendor and tax ID to show up in this query, and all I can get is the Vendor ID and name to show. I tried linking the location table, but I get the following error: conversion failed when converting the nvarchar value ‘Main” to data type integer. I feel like this should be a simple query, but I am obviously missing something.

Best answer by BenjaminCrisman

Hi ​@nikki7! This link already exists in another GI, the Vendor Locations GI, AP3030P1. The join being used in this GI is Location to Vendor on BAccountID = BAccountID. 

 

    2 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • March 28, 2025

    Hi ​@nikki7! This link already exists in another GI, the Vendor Locations GI, AP3030P1. The join being used in this GI is Location to Vendor on BAccountID = BAccountID. 

     

    Chris Hackett
    N
    Freshman I
    • nikki7
    • Author
    • Freshman I
    • March 28, 2025

    I knew it would be something simple. Thank you so much for your quick response! That worked perfectly.

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved