Skip to main content
Answer

Vendor Transaction History not working properly

  • November 17, 2025
  • 2 replies
  • 30 views
dales60
Freshman I

The Vendor Transaction History report (PM706220) / 24R1 is not pulling details properly when there is more than one project on the AP Bill / Invoice.  It only shows the invoice as project X

Is there a fix for this ?

 

Best answer by nickcerri32

​@dales60 - The Project field is taken from the APInvoice DAC in that report.  Out of the box, if there are multiple projects on a Bill, the DAC sets APInvoice.Project to “X.”  You may need to rework the schema in the report to pull from APTran instead, since that’s where the Project distinction is, although that could present other issues when grouping the report.  

Dale Simmerly / K&R Consulting

    2 replies

    nickcerri32
    Jr Varsity III
    Forum|alt.badge.img+1
    • nickcerri32
    • Jr Varsity III
    • Answer
    • November 17, 2025

    ​@dales60 - The Project field is taken from the APInvoice DAC in that report.  Out of the box, if there are multiple projects on a Bill, the DAC sets APInvoice.Project to “X.”  You may need to rework the schema in the report to pull from APTran instead, since that’s where the Project distinction is, although that could present other issues when grouping the report.  

    Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
    Chris Hackett
    dales60
    Freshman I
    • dales60
    • Author
    • Freshman I
    • November 17, 2025

    Thank you

    Dale Simmerly / K&R Consulting
    Chris Hackett
    nickcerri32
    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