Reopen a Purchase Order via the default API?

Hi ​@geoffatsource ,

You can extend the endpoint to include the ReOpen action.

Once the action is added, you can make a POST request to reopen the order.

Sample
URL: /entity/DefaultExtn/22.200.001/PurchaseOrder/ReopenPOOrder
JSON Request:

{

    "entity": {

        "Type": {

            "value": "RO"

        },

        "OrderNbr": {

            "value": "PO002058"

        }

    },

    "parameters": {}

}

It’s not working. I get a 500 Internal Server error with:

curl --location 'https://xxxxxx.acumatica.com/entity/SIPPIE/1.0.0/PurchaseOrder/ReopenPOOrder' \
--header 'Accept: application/json' \
--header 'Content-Type: application/json' \
--header 'Cookie: .ASPXAUTH=xxxxxxxx' \
--data '{
    "entity": {
        "Type": {
            "value": "RO"
        },
        "OrderNbr": {
            "value": "24-TST2-046"
        }
    },
    "parameters": {}
}'

Response:

{
    "message": "An error has occurred.",
    "exceptionMessage": "Operation failed",
    "exceptionType": "PX.Data.PXInvalidOperationException",
    "stackTrace": "   at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n   at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEntityService entityService, ICbEndpointFeature feature, EntityImpl entity, ActionImpl action, CbOperationContext operationContext)\r\n   at PX.Api.ContractBased.WebApi.Controllers.ActionController.InvokeAction(String objectName, String actionName, ActionInvocation invocation)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__13.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__24.MoveNext()",
    "innerException": {
        "message": "An error has occurred.",
        "exceptionMessage": "The Reopen Order button is disabled.",
        "exceptionType": "PX.Data.PXActionDisabledException",
        "stackTrace": "   at PX.Data.PXAction`1.<Press>d__39.MoveNext()\r\n   at PX.Api.SyImportProcessor.SyStep.PressButton(PXAction button, PXAdapter adapter, SyView view, String actionName, Object[] currents)\r\n   at PX.Api.SyImportProcessor.SyStep.CommitChangesInt(Object itemToBypass, PXFilterRow[] targetConditions, PXFilterRow[] filtersForAction, SyImportRowResult importResult)\r\n   at PX.Api.SyImportProcessor.SyStep.CommitChanges(Object& itemToBypass, PXFilterRow[] targetConditions, PXFilterRow[] filtersForAction)\r\n   at PX.Api.SyImportProcessor.ExportTableHelper.ExportTable(CancellationToken token)"
    }
}

It doesn’t seem to matter what values I put into Type or OrderNbr, either

curl --location 'https://xxxxxx.acumatica.com/entity/SIPPIE/1.0.0/PurchaseOrder/ReopenPOOrder' \
--header 'Accept: application/json' \
--header 'Content-Type: application/json' \
--header 'Cookie: .ASPXAUTH=xxxxxxxx' \
--data '{
    "entity": {
        "Type": {
            "value": "RO"
        },
        "OrderNbr": {
            "value": "24-TST2-046"
        }
    },
    "parameters": {}
}'

{
    "message": "An error has occurred.",
    "exceptionMessage": "Operation failed",
    "exceptionType": "PX.Data.PXInvalidOperationException",
    "stackTrace": "   at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n   at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEntityService entityService, ICbEndpointFeature feature, EntityImpl entity, ActionImpl action, CbOperationContext operationContext)\r\n   at PX.Api.ContractBased.WebApi.Controllers.ActionController.InvokeAction(String objectName, String actionName, ActionInvocation invocation)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__13.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__24.MoveNext()",
    "innerException": {
        "message": "An error has occurred.",
        "exceptionMessage": "The Reopen Order button is disabled.",
        "exceptionType": "PX.Data.PXActionDisabledException",
        "stackTrace": "   at PX.Data.PXAction`1.<Press>d__39.MoveNext()\r\n   at PX.Api.SyImportProcessor.SyStep.PressButton(PXAction button, PXAdapter adapter, SyView view, String actionName, Object[] currents)\r\n   at PX.Api.SyImportProcessor.SyStep.CommitChangesInt(Object itemToBypass, PXFilterRow[] targetConditions, PXFilterRow[] filtersForAction, SyImportRowResult importResult)\r\n   at PX.Api.SyImportProcessor.SyStep.CommitChanges(Object& itemToBypass, PXFilterRow[] targetConditions, PXFilterRow[] filtersForAction)\r\n   at PX.Api.SyImportProcessor.ExportTableHelper.ExportTable(CancellationToken token)"
    }
}

Could you please try to run that “Re-open” action from the UI?

Based on the error message “exceptionMessage": "The Reopen Order button is disabled.” it seems like your record is already in a state that it can not be reopened.

I also tried changing “Type” from “RO” to “PurchaseOrder” but then I get another error, and my session is corrupted.

 

{
    "id": "cf25cbbe-0f05-f011-8368-065d7e32b4d5",
    "rowNumber": 1,
    "note": {
        "value": ""
    },
    "BaseCurrencyID": {
        "value": "USD"
    },
    "ControlTotal": {
        "value": 0.0
    },
    "CurrencyEffectiveDate": {
        "value": "2025-03-19T00:00:00+00:00"
    },
    "CurrencyID": {
        "value": "USD"
    },
    "CurrencyRate": {
        "value": 1.0
    },
    "CurrencyRateTypeID": {},
    "CurrencyReciprocalRate": {
        "value": 1.0
    },
    "Date": {
        "value": "2025-03-19T00:00:00+00:00"
    },
    "Description": {},
    "Hold": {
        "value": true
    },
    "IsTaxValid": {
        "value": false
    },
    "LastModifiedDateTime": {
        "value": "2025-03-19T22:16:05.8822518+00:00"
    },
    "LineTotal": {
        "value": 0.0
    },
    "OrderNbr": {
        "value": "24-TST2-046"
    },
    "OrderTotal": {
        "value": 0.0
    },
    "Owner": {},
    "Project": {
        "value": "X"
    },
    "PromisedOn": {
        "value": "2025-03-19T00:00:00+00:00"
    },
    "Status": {
        "value": "On Hold"
    },
    "TaxTotal": {
        "value": 0.0
    },
    "Terms": {
        "error": "'Terms' cannot be empty."
    },
    "Type": {
        "value": "Pu",
        "error": "The 'Pu' list value is not allowed for the Type field. The allowed values are: Normal, Project Drop-Ship."
    },
    "VendorID": {
        "error": "'Vendor' cannot be empty."
    },
    "VendorRef": {},
    "VendorTaxZone": {},
    "custom": {},
    "_links": {
        "self": "/entity/SIPPIE/1.0.0/PurchaseOrder/cf25cbbe-0f05-f011-8368-065d7e32b4d5",
        "files:put": "/entity/SIPPIE/1.0.0/files/PX.Objects.PO.POOrderEntry/Document/cf25cbbe-0f05-f011-8368-065d7e32b4d5/{filename}"
    }
}

If I then retry the call, or any call, I get: 

{
    "message": "An error has occurred.",
    "exceptionMessage": "Object reference not set to an instance of an object.",
    "exceptionType": "System.NullReferenceException",
    "stackTrace": "   at PX.Data.Automation.PXWorkflowService.Configure(PXGraph graph)\r\n   at PX.Data.PXGraph.CreateInstance(Type graphType, String prefix)\r\n   at PX.Api.SyImportProcessor.CreateGraphWithPrefix(String graphName, String prefix, String screenID, Boolean export, Boolean contractBasedAPI)\r\n   at PX.Api.ContractBased.EntityExportHelpers.GetScreenGraph(String graphName, String screenId, Boolean export, Boolean contractBasedAPI)\r\n   at PX.Api.ContractBased.EntityExportContextBuilder..ctor(String version, String name, IMetadataProvider metadataProvider, IEntityMappingKeyService entityMappingKeyService, EntityImpl entity, IScreenInfoProvider screenInfoProvider, ISystemContract systemContract, PXGraph graph, Boolean shouldReadArchive)\r\n   at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n   at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEntityService entityService, ICbEndpointFeature feature, EntityImpl entity, ActionImpl action, CbOperationContext operationContext)\r\n   at PX.Api.ContractBased.WebApi.Controllers.ActionController.InvokeAction(String objectName, String actionName, ActionInvocation invocation)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__13.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__24.MoveNext()"
}

I then have to log out and log back in

I did already. The button works fine.

If I change the type to “PD” which is the same PurchaseOrder type as before, it works. 🤷 why is the Type field necessary?

The Purchase Order record’s Key is a combination of the Type and Order Nbr, so you must provide both to correctly find the record.

Ah that makes perfect sense, thanks.

As an aside, your API more often than not gives error messages that are unrelated to the actual error. It makes it very difficult to develop against.

I don’t work for Acumatica, but I understand the frustration with unclear error messages.

Usually, there is an innerException with a more readable exceptionMessage if the error is caused by validation when running an action. Otherwise, the API returns the exception itself at the top level.

For data creation or updates, the API typically returns the error message in the property that caused the failure—like in your example, where the Terms field was one of them. Hope that helps! Let me know if you need further clarification.

"Terms": {
        "error": "'Terms' cannot be empty."
    },

Thanks for your reply :)

That’s a good example. That error message had nothing to do with the actual error, which was an invalid PurchaseOrder type. And who knows why that caused my session cookie to become corrupted.