Skip to main content
Solved

Odata - Generic Inquiries with parameter - Not working as expected

  • July 14, 2025
  • 7 replies
  • 154 views

Forum|alt.badge.img+1

Hi everyone,

I’ve been trying to retrieve data via OData using a Generic Inquiry (GI) with a parameter, but I’m running into some issues.

In my GI, I’ve defined a parameter named PPeriod and when I use it in the Acumatica web UI (for example, entering "092025" for 09-2025), everything works fine — I get the expected result with EndDate as 2025-02-02, along with the correct data for document FCV002141.

 

 

GI parameter


 

GI result enddate with 09-2025 and FCV002141

However, when I call the same GI via OData in Postman using the same parameter, I receive a 200 OK response but it completely ignores the parameter and returns bad data : 

 

Postman Odata result , dont take in account the parameter

 

If I try with REST API, it work, but i need the odata ..

 

Here’s what I’ve confirmed so far:

  • The parameter is correctly defined in the metadata as:

    <Function Name="AR_Documents_PeriodSensitive"> <Parameter Name="PPeriod" Type="Edm.String" /> <ReturnType Type="Collection(GenericInquiry.AR_Documents_PeriodSensitive)" Nullable="false" /> </Function>

  • When using the REST API with the same filter value, it works as expected.

  • But I specifically need this to work via OData for integration reasons.

Has anyone faced a similar issue with GI parameters not applying in OData calls? Any insights on what I might be missing or misconfiguring?

Thanks in advance!

Best answer by Dmitrii Naumov

@raphrf the issue is fixed in 25r2 release (not it beta though)

7 replies

Forum|alt.badge.img+7
  • Captain II
  • July 14, 2025

Is your EndDate column stored in the database or is it calculated?


Forum|alt.badge.img+1
  • Author
  • Captain I
  • July 14, 2025

@Django  No, Endate is directly the endate of a table, in this case masterfinperiod, You can see here or the attached XML of the GI
 

 


bwhite49
Captain II
Forum|alt.badge.img+11
  • Captain II
  • July 15, 2025

I have not had any luck with the new OData links and passing parameters. I’m curious if anybody has found success yet. 


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • July 15, 2025

Hmm, I’ve tested your GI and seems to works for me. 

Is there anything customized on this instance?

 


Forum|alt.badge.img+1
  • Author
  • Captain I
  • July 15, 2025

@Dmitrii Naumov  You should have End date filled , isnt it?

 

no customization on my side


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • July 15, 2025

@raphrf Ah, I see. In that case it’s probably a bug then. I’ll check a bit more and report to the eng team


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • Answer
  • July 28, 2025

@raphrf the issue is fixed in 25r2 release (not it beta though)