Skip to main content
Solved

can we create a GI from report directly

  • February 21, 2023
  • 2 replies
  • 193 views
T
Freshman I
Forum|alt.badge.img

Can we create a GI directly from a report. I want to make changes in the report and it is very hard with the report designer to do that. 

Best answer by BenjaminCrisman

@tanuj81 Unfortunately there isn’t a way to take the schema from the report and import it into a GI, though I would think it could be a useful feature and worth adding to the Product Ideas if it doesn’t already exist.

You can do this with a GI, export the relations and conditions into a report, but it doesn’t work backwards currently

    2 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • February 21, 2023

    @tanuj81 Unfortunately there isn’t a way to take the schema from the report and import it into a GI, though I would think it could be a useful feature and worth adding to the Product Ideas if it doesn’t already exist.

    You can do this with a GI, export the relations and conditions into a report, but it doesn’t work backwards currently

      drmccann
      Freshman I
      • drmccann
      • Freshman I
      • April 21, 2026

      Here’s how I was able to convert an Acumatica Report (from Report Designer in .rpx format) to a Generic Inquiry (GI; xml format for import):

      I gave ChatGPT the .rpx report file (which is just an XML file) and it generated the GI in one shot.  It dutifully thought for over 6 min, and I didn’t even have to include a sample exported GI, though that likely would have helped.  I had to remove a <GenericInquiryScreen> element, and fix one of the JOINs, but much better than creating from scratch in the GI UI.

       

      Then just import the outputted XML:

       

        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