Skip to main content
Solved

Need a detailed vendor report that shows address and tax registration id for all vendors

  • December 15, 2021
  • 3 replies
  • 963 views
C
Freshman I

I need to be able to export a listing showing all vendors, along with their main address and tax registration and contact information.  Does anyone have a report created that I could upload, or give me some assistance on how to create that?  I am new to Acumatica and not very skilled at the report designer or generic inquiry, but have tinkered a bit with both.  Not very successfully!

Any help would be greatly appreciated!

Best answer by vkumar

Hi @caroll42 

You can pull relevant information from Baccount, Location, Contact and Address tables.

  • VendorID and name from Baccount (type of baccount VE for Vendor)
  • Tax registration ID from Location table
  • Contact information from Contact table (link using DefContacID from Baccount)
  • Address from ‘Address’ table (link using DefAddressID from Baccount)

Hope this helps you build the GI. Let us know the result.

Regards,

View original
    Did this topic help you find an answer to your question?

    3 replies

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • 871 replies
    • Answer
    • December 16, 2021

    Hi @caroll42 

    You can pull relevant information from Baccount, Location, Contact and Address tables.

    • VendorID and name from Baccount (type of baccount VE for Vendor)
    • Tax registration ID from Location table
    • Contact information from Contact table (link using DefContacID from Baccount)
    • Address from ‘Address’ table (link using DefAddressID from Baccount)

    Hope this helps you build the GI. Let us know the result.

    Regards,

    VijayKumarU
    DConcannon
    Chris Hackett
    2 people like this
    • DConcannon
      DConcannon
    • Chris Hackett
      Chris Hackett
    DConcannon
    Varsity II
    Forum|alt.badge.img+2
    • DConcannon
    • Varsity II
    • 120 replies
    • December 16, 2021

    Hi @caroll42,

    Building on what @vkumar has shared, you can leverage the Vendors Primary List GI by copying it to a new GI. Using the Add Related Table button on the Tables tab of the GI is very helpful to add additional tables as it builds the table relationships for you. Acumatica has the best context-sensitive help I have seen in ERP and GI form reference does a good job explaining the five table-join options. Additionally, the Inspect Element feature is a great tool to identify the table and field name needed in your GI results.

    Best,

    Dan

    1 Attachments
    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    C
    Freshman I
    • caroll42
    • Author
    • Freshman I
    • 8 replies
    • January 7, 2022

    Unfortunately, we don’t seem to have a Vendors Primary List GI to pull from.  I ended up creating a list manually, as it was a small company.  But we will be needing to extract a full listing of vendors soon.  

    I will be exploring Vijay Kumar’s suggestion next, as that seems to be the only option.  

    Thanks to you both for the suggestions!

    Carol

    DConcannon
    Chris Hackett
    2 people like this
    • DConcannon
      DConcannon
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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