Solved

Request for assistance on APIs - Restriction Group by Subaccount and Reverse Journal Transaction

  • 27 November 2023
  • 8 replies
  • 141 views
V
Rank
Userlevel 1

Hello Team,

 

We are working on the following APIs and facing the issue as data not getting updated to the screen, even though the status is Success with 200 code.

  1.  Custom Endpoint created for Endpoint for Restriction Group by Subaccount (GL104030):  Requirement  is to update groups for Subaccount
    API to select the Group names and save by passing the Subaccount ID and the Group name via API (Postman)

     

  2. Endpoint for Journal Transaction screen (GL301000):Requirement is to reverse the Journal transaction entry. We have added the action to the standard Endpoint. Same issue here as well, call is success with 204 code but transaction is reversed. (Please confirm if its feasible or not

Thanks & Regards,

Vidyakeerthi K

icon

Best answer by Vignesh Ponnusamy 20 December 2023, 16:28

View original

8 replies

Vignesh Ponnusamy
Rank
Userlevel 7
Badge +4

Hi @vidyakeerthik,

For the 1st question,

From the Restriction Groups by Subaccount(GL104030) screen, you can enable or disable the Included checkbox in the grid. To do that, map the GL104030 and its detail entity like in below screenshot,

 

Do a GET request with expand, like

GET: <<Instance URL>>/entity/DefaultExt/23.200.001/RestrictionGroupsSubAcct/000000?$expand=RestrictionGroup

Now do PUT request using ID(like below) to update the Included value, 

Put: <<Instance URL>>/entity/DefaultExt/23.200.001/RestrictionGroupsSubAcct

{
    "id": "f29cb555-4129-44dd-9565-075eb0733e62",
    "RestrictionGroup": [
        {
            "id": "c5544f14-8e0b-4127-ba40-0a84413ff8f1",
            "Included": {
                "value": true
            }
        }
    ]
}

Feel free to post if you have any questions.!

#VP
Vignesh Ponnusamy
Rank
Userlevel 7
Badge +4

Hi @vidyakeerthik,

For the 2nd question,

When you invoke Reverse action from UI, you can notice there is a pop-up warning message(think depends on the transaction you are reversing) and upon user confirmation the system creates a new GL but doesn’t save it. So the new Journal Transaction created will simply be <NEW> unless you save it manually.

 

There could be the two possible reasons, why the reversed transactions isn’t saved when invoked from API.

It might be tricky, but to be able to do it from API you might have to customize to ideally bypass the pop-up message and persist the new transaction that is being created. Hope that helps, Good Luck.!

#VP
V
Rank
Userlevel 1

Hi Vignesh,

Thanks for your review and detailed inputs.

#2 yes, we understood and its working now.

#1, we tried the same way like first to get id and the use that id in the put call, to udpate Restriction groups, no luck.

Same behaviour like, we don’t see any error, status is 200 but selected groups are not reflecting in the instance screen.

Below are the screenshots sharing for your reference.

 

Vignesh Ponnusamy
Rank
Userlevel 7
Badge +4

Hi @vidyakeerthik,

Request seems good to me. Can you please share screenshot of the Endpoint extension and the field mapping of the Restriction Group?

Other, possible reason could be that you are passing the wrong ID in the PUT request. Kindly test and confirm if you are using the right IDs. Thanks

#VP
A
Rank

Hi Vignesh,

Thank you for your response. I've attached additional screenshots as per your request.

Could you please review and provide your Inputs.

Note: A custom endpoint has been created for the restriction group by Subaccount (GL104030) i.e RestrictionGroupBySubaccount

Requirement : The requirement involves updating groups for a specific subaccount. The API allows selection of group names and saving them by passing the Subaccount ID and the Group name through Postman.

Looking forward to your feedback.

 


As we have mentioned in above screenshots ,  WID-000 Subaccount ID  putted request Included true for Cash Account Access


Adding the Endpoint Screenshot
 



Thanks & Regards,
Aditya D

V
Rank
Userlevel 1

Hi Vignesh,

Did you get a chance to look into the inputs shared by Aditya.

Any further suggestion please

 

Thanks & Regards,

Vidyakeerthi K

 

Vignesh Ponnusamy
Rank
Userlevel 7
Badge +4

Hi @adityad50 and @vidyakeerthik,

From the screenshots, looks like you are using 23R1 and extension of the Default 22.200.001 endpoint.

As far as I tested, the issue seems to be with 23R1 version. The API seems to be work in 23R2 and extension of 23.200.001 endpoint.

For us to check and track this further, I would suggest you create a support ticket.

Thanks & Good Luck.!  

 

#VP
V
Rank
Userlevel 1

Sure Vignesh,

Thank you so much for your review and inputs on this request.

Will create a case and coordinate further.

 

Reply


Terms & ConditionsCookie 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