Skip to main content
Question

Vendor ID Field

  • May 20, 2026
  • 3 replies
  • 40 views
K
Freshman I

Hi Team,

I created the tables as shown in the screenshot for the Expenses Paid AP report and am currently trying to fetch the vendor details, specifically AcctCD and AcctName.

I tried multiple possible approaches, including adding APTran, Vendor, and PMTran tables, but still no luck. I’m running into issues such as:

  • Missing records

  • Duplicate records

  • Incorrect IDs being picked even after applying grouping

It seems the joins/grouping logic is not returning consistent results for the vendor details. Could you please help review the approach or suggest the best way to retrieve the correct vendor information without duplication or mismatched IDs?

Thanks!

 

3 replies

lauraj46
Captain II
Forum|alt.badge.img+9
  • lauraj46
  • Captain II
  • May 21, 2026

Hi ​@KCHEKURI ,

You should be able to join on EPExpenseClaimDetails.EmployeeID = Vendor.BAccountID

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    K
    Freshman I
    • KCHEKURI
    • Author
    • May 21, 2026

    ​@lauraj46 

    For the Expenses Paid AP report, I tried joining EPExpenseClaimDetails.EmployeeID = Vendor.BAccountID to get vendor AcctCD and AcctName, but this is not returning all vendor IDs.

     

    lauraj46
    Captain II
    Forum|alt.badge.img+9
    • lauraj46
    • Captain II
    • May 22, 2026

    Hi ​@KCHEKURI ,

    You could also try joining on EPExpenseClaim.EmployeeID = Vendor.BAccountID .  Let me know if that helps.

    Thanks,

    Laura

    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
      Terms & ConditionsAccessibility 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