Generic inquiry

Userlevel 4

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 17 July 2023, 12:20

View original

2 replies

Userlevel 7
Badge +18

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

Badge +18


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.



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