Solved

How to create a sales order via the REST API

  • 31 January 2023
  • 5 replies
  • 1214 views
aaldrich
Rank
Userlevel 1

 

Hello, I’m wondering how I can go about importing a sales order into Acumatica by using the REST API. I realized that this is likely through the use of the Actions however I could not find one that would do the action of “New Sales Order”

 

Any ideas on how to do this?

icon

Best answer by aaldrich 1 February 2023, 14:58

View original

5 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @yhartman  Below is the JSON API Request to create the Sales Order.

 

API Request URL: - https://URL/InstanceName/entity/APISamplesEndpoint/18.200.001/SalesOrder

Request Body:

{
    "OrderNbr": {
        "value": "<NEW>"
    },
    "OrderType": {
        "value": "SO"
    },
    "CustomerID": {
        "value": "AACUSTOMER"
    },
    "note": "",
    "CustomerOrder": {
        "value": "STG21002"
    }, 

    "Details": [        
        {
            "note": "",
            "InventoryID": {
                "value": "AACOMPUT01"
            },
            "OrderQty": {
                "value": "1.0000"
            },
            "MasterQty": {
                "value": "1.0000"
            },
            "ManualPrice": {
                "value": true
            },
            "UnitPrice": {
                "value": 79.99
            },
            "ManualDIscount": {
                "value": true
            },
            "DiscountAmount": {
                "value": 0
            },
            "TaxCategory": {
                "value": "DEFAULT"
            }          
        }

    ]



    "Date": {
        "value": "12/01/2022"
    },
    "RequestedOn": {
        "value": "12/01/2022"
    }   
}

 

 

 

Naveen B
Y
Rank
Userlevel 5
Badge +3

Hi,

Look at the below video around minutes 45, it should help! Watch the whole video to understand how Acumatica apis work.

https://youtu.be/WZjlfsN6aew

Also, you can look at https://openuni.acumatica.com/courses/integration/i330-data-manipulation-with-rest-api/

I hope this helps!

Yisroel Hartman • https://www.linkedin.com/in/yisroelhartman/
priekenberg40
Rank
Userlevel 2
Badge

@mariolavignasse6, you need to include the id in each detail which you get in the first post ($expand=Details). If the id is omited detail is handled a new detail.

aaldrich
Rank
Userlevel 1

Hi @yhartman  Below is the JSON API Request to create the Sales Order.

 

API Request URL: - https://URL/InstanceName/entity/APISamplesEndpoint/18.200.001/SalesOrder

Request Body:

{
    "OrderNbr": {
        "value": "<NEW>"
    },
    "OrderType": {
        "value": "SO"
    },
    "CustomerID": {
        "value": "AACUSTOMER"
    },
    "note": "",
    "CustomerOrder": {
        "value": "STG21002"
    }, 

    "Details": [        
        {
            "note": "",
            "InventoryID": {
                "value": "AACOMPUT01"
            },
            "OrderQty": {
                "value": "1.0000"
            },
            "MasterQty": {
                "value": "1.0000"
            },
            "ManualPrice": {
                "value": true
            },
            "UnitPrice": {
                "value": 79.99
            },
            "ManualDIscount": {
                "value": true
            },
            "DiscountAmount": {
                "value": 0
            },
            "TaxCategory": {
                "value": "DEFAULT"
            }          
        }

    ],
    "Date": {
        "value": "12/01/2022"
    },
    "RequestedOn": {
        "value": "12/01/2022"
    }   
}

 

 

 

This answer works great - It is a PUT request (You can also use the endpoint /entity/Default/20.200.001/SalesOrder)

https://help-2022r2.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=9d966d50-a0a1-4456-a9ff-1cc2159d48d4

(I was able to find the link above because of @yhartman post)

 

M
Rank

Hi, do you know if it is possible to send again the same sales order and UPDATE the items?

When I resend the same sales order, it updates the fields in the header as expected, but instead of updating the line items, it adds new line items.

Thanks,

Mario

 

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