Skip to main content
Answer

Generic inquiry

  • July 17, 2023
  • 2 replies
  • 66 views
H
Freshman I
Forum|alt.badge.img

Am creating a generic inquiry that list all the purchases accruals. Can someone kindly advise on how to achieve this? Have tried it several times using the information from Build Schema for report designer but still I can’t achieve this

 

 

Best answer by Naveen Boga

Hi @helpdesk37  I see that you have not added any JOIN conditions in your GI. Please check and add the conditions.

    Laura03

    2 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • July 17, 2023

    Hi @helpdesk37  I see that you have not added any JOIN conditions in your GI. Please check and add the conditions.

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    Laura03
    Captain II
    Forum|alt.badge.img+19
    • Laura03
    • Captain II
    • July 17, 2023

    Hello,

    Did you try the existing Purchase Order Accrual GI and Reports?  It may be helpful to study how the tables are joined in the existing GI and reports.  It may be helpful to explain what fields or records you need in your GI,  that is not already included with the Acumatica-standard PO accrual GI and reports.

     

    ~ Laura Barber, WM Synergy
    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