Skip to main content
Solved

Odata pulling extra columns into excel

  • Oct 27, 2026 4:14 PM UTC
  • 2 replies
  • 32 views
  • Translate All
Freshman II
Forum|alt.badge.img

Hey, I am pulling data from Acumatica, but it is pulling extra columns that are not in the GI.

this is the GI

 

This is my result in acumatica

 

 

But this is the result I am getting when it comes to excel.

 It has added 6 extra columns

 

 

Best answer by BenjaminCrisman

​@SandyA These look like key linking fields from the tables which are used. Sometimes it’s necessary to have them for the export, but I’ve also seen at least one bug where unexpected columns are appearing in the results set which was not a part of the GI. Are you exporting from Modern UI or Classic UI?

 

Edit: I see it’s Classic UI. Might want to check if the results are different in Modern UI

View original

    2 replies

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4
    • BenjaminCrisman
    • Acumatica Support Team
    • Answer
    • Oct 27, 2026 4:22 PM UTC

    ​@SandyA These look like key linking fields from the tables which are used. Sometimes it’s necessary to have them for the export, but I’ve also seen at least one bug where unexpected columns are appearing in the results set which was not a part of the GI. Are you exporting from Modern UI or Classic UI?

     

    Edit: I see it’s Classic UI. Might want to check if the results are different in Modern UI

    Translate
    Freshman II
    Forum|alt.badge.img
    • SandyA
    • Author
    • Freshman II
    • Oct 27, 2026 5:01 PM UTC

    ​@BenjaminCrisman thanks a lot

    Translate
    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