Skip to main content
Solved

Not able to see latest payment objects in GET payments

  • December 3, 2024
  • 4 replies
  • 50 views
Q
Freshman II

Hello,

We are working on an integration into Acumatica via the REST Api and have had some troubles with pulling the latest payment objects. When logged into Acumatica I can see recent payments objects in our demo account but when pulling payment via the REST Api I’m only seeing the demo account data. I’ve verified that our user and api account have access to all of the branches/companies in the Acumatica account so I m unsure why I wouldn’t be seeing all payments? I’ve attached a screen shot with a modifiedDatefilter and it returns no results. When changing the date filter to april of this year I do receive payment objects that were setup in the demo account. The second screen shot is showing the many newly created payment objects in many different status’ that do not come back.

Any help is greatly appreciated. Thank you

Best answer by QuicklyTest

Following up here. This was a misunderstanding of which modules return which payment types. The /payment routes are specific to accounts receivable where I was looking for accounts payable payments which come back in the /check routes.

View original
2 Attachments
Did this topic help you find an answer to your question?

4 replies

jinin
Pro I
Forum|alt.badge.img+11
  • jinin
  • Pro I
  • 701 replies
  • December 3, 2024

Hi ​@QuicklyTest ,

We can retrieve the Documents to Apply details for individual payment records using the REST API. To fetch all documents associated with multiple payments, create a custom GI and endpoint to retrieve the aggregated data with filters such as date range.

 

Jini N
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Dmitrii Naumov
  • Acumatica Moderator
  • 632 replies
  • December 3, 2024

​@QuicklyTest 

I’m not sure what’s wrong with this test. It should work. 

Please double check if you are logging in to the same site, same tenant. 

Also you can try filtering by ‘LatModifiedDateTime’  instead

Chris Hackett
Q
2 people like this
  • Chris Hackett
    Chris Hackett
  • Q
    QuicklyTest
Q
Freshman II
  • QuicklyTest
  • Author
  • Freshman II
  • 2 replies
  • December 5, 2024

Thank you for the replies

​@Dmitrii Naumov as far as I can tell we are connected to the correct site/tenant. I’ve attached some screen shots of our connection details from our logged in user. When sorting my lastmodifieddatetime I only receive results back when I filter back to 2022. Anything after that nothing.

 

Thank you

 

 

Q
Freshman II
  • QuicklyTest
  • Author
  • Freshman II
  • 2 replies
  • Answer
  • December 11, 2024

Following up here. This was a misunderstanding of which modules return which payment types. The /payment routes are specific to accounts receivable where I was looking for accounts payable payments which come back in the /check routes.

Dmitrii Naumov
Chris Hackett
2 people like this
  • Dmitrii Naumov
    Dmitrii Naumov
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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