Skip to main content
Solved

How to Create SalesOrder with payment details REST API

  • February 24, 2025
  • 7 replies
  • 210 views
J
Freshman I

How to Create SalesOrder with Shipping and Payment details using REST API in node js

Best answer by Naveen Boga

​@Jayavenitha Please find the jSON below to create the Sales Order with Payment. I just tried in my local machine with the demo data and it is working as expected. Please check with this jSON and confirm.

 

{
    "OrderNbr": {
        "value": "<NEW>"
    },
    "CustomerID": {
        "value": "AACUSTOMER"
    },
    "CustomerLocation": {
        "value": "MAIN"
    },
    "ExternalRef": {
        "value": "801PM00000DhqGnYAJ"
    },
    "OrderType": {
        "value": "SO"
    },
    "IsSpecialOrder": {
        "value": false
    },
    "OrderDate": {
        "value": "2024-04-22"
    },
    "BillToAddressLine1": {
        "value": "1332 Twin Oaks Drive"
    },
    "BillToOverrideAddress": {
        "value": true
    },
    "BillToOverrideContact": {
        "value": true
    },
    "BillToCity": {
        "value": "Kinston"
    },
    "BillToCountry": {
        "value": "US"
    },
    "BillToPostalCode": {
        "value": "28501"
    },
    "BillToState": {
        "value": "NC"
    },
    "BillToEmail": {
        "value": "Test@Test.com"
    },
    "BillToPhone1": {
        "value": "4233492"
    },
    "ShipToAddressLine1": {
        "value": "Test"
    },
    "ShipToOverrideAddress": {
        "value": true
    },
    "ShipToOverrideContact": {
        "value": true
    },
    "ShipToCity": {
        "value": "Test"
    },
    "ShipToCountry": {
        "value": "US"
    },
    "ShipToPostalCode": {
        "value": "42131"
    },
    "ShipToState": {
        "value": "NY"
    },
    "ShipToPhone1": {
        "value": "\\245454"
    },
    "Details": [
        {
            "Amount": {
                "value": 500.00
            },
            "OrderQty": {
                "value": 1
            },
            "UnitPrice": {
                "value": 500.00
            },
            "Branch": {
                "value": "PRODWHOLE"
            },
            "WarehouseID": {
                "value": "WHOLESALE"
            },
            "InventoryID": {
                "value": "AACOMPUT01"
            },
            "ManualPrice": {
                "value": true
            },
            "UOM": {
                "value": "EA"
            }
        }
    ] ,
    "Payments": [
        {
            "DocType": {
                "value": "Payment"
            },
            "PaymentAmount": {
                "value": 500.00
            },
            "ApplicationDate": {
                "value": "2025-02-25T00:00:00+03:00"
            },
            "AppliedToOrder": {
                "value": 500.00
            },
            "PaymentMethod": {
                "value": "CHECK"
            },
            "CashAccount": {
                "value": "10200"
            },
            "PaymentRef": {
                "value": "PMT02241"
            }
        }        
    ]
}

 

hdussa

7 replies

J
Freshman I
  • Jayavenitha
  • Author
  • Freshman I
  • February 25, 2025

Given Payload Input
{

    "OrderNbr": {

        "value": "xxxx"

    },

    "OrderType": {

        "value": "SO"

    },

    "CustomerID": {

        "value": "xxxx"

    },

    "note": "",

    "CustomerOrder": {

        "value": "xxxxx"

    },

 

    "Details": [        

        {

            "note": "",

            "id": "xxxx",

            "InventoryID": {

                "value": "xxx”

            },

            "OrderQty": {

                "value": "1.0000"

            },

            "MasterQty": {

                "value": "1.0000"

            },

            "ManualPrice": {

                "value": true

            },

            "UnitPrice": {

                "value": 79.99

            },

            "ManualDIscount": {

                "value": true

            },

            "DiscountAmount": {

                "value": 0

            },

            "TaxCategory": {

                "value": "xxx"

            }          

        }

 

    ],

    "Payments": [

    {

        "PaymentRef": {

            "value": "xxx"

        },

        "CashAccount": {

            "value": "xxx"

        },

        "PaymentMethod": {

            "value": "xxxx"

        },

        "OrigDocAmt": {

            "value" : "xx"

        }

    }

    ],

    "Date": {

        "value": "12/02/2025"

    },

    "RequestedOn": {

        "value": "12/02/2025"

    }  

}

When adding payment it throws error 
 "error": "'OrigDocAmt' cannot be empty.; OrigDocAmt: 'OrigDocAmt' cannot be empty.",
Can anyone help in resolving this

hdussa
Jr Varsity I
Forum|alt.badge.img+1
  • hdussa
  • Jr Varsity I
  • February 25, 2025

Hello ​@Jayavenitha ,

 

I created a sales order with details and payment info with the following request.

{
    "CustomerID": {"value": "WIDGETCC"},
    "Date": {"value": "2024-05-10T00:00:00"},
    "Description": {"value": "Internal CC Payment"},
    "Details": [
        {
            "Branch": {"value": "PRODWHOLE"},
            "DiscountAmount": {"value": 10.00},
            "ExtendedPrice": {"value": 500.00},
            "FreeItem": {"value": false},
            "InventoryID": {"value": "AACOMPUT01"},
            "OrderQty": {"value": 1.00},
            "UnitPrice": {"value": 500.00},
            "UOM": {"value": "EA"},
            "WarehouseID": {"value": "WHOLESALE"}
        }
    ],
    "Hold": {"value": false},
    "LocationID": {"value": "MAIN"},
    "OrderType": {"value": "SO"},
    "Payments": [
        {
            "ApplicationDate": {"value": "2024-08-11T00:00:00+03:00"},
            "AppliedToOrder": {"value": 480.00},
            "CashAccount": {"value": "10200"},
            "PaymentAmount": {"value": 980.00},
            "PaymentMethod": {"value": "CHECK"} 
        }
    ],
    "RequestedOn": {"value": "2024-05-10T00:00:00"}
}

Hope this helps!

~ Harish Dussa
Chris Hackett
J
J
Freshman I
  • Jayavenitha
  • Author
  • Freshman I
  • February 25, 2025

Hi ​@hdussa When I create without payment it works fine, but when I include payment array it throws below error with 402 code. Is this related to Id mismatch. I directly creating sales order with payment only not shipping now. Can you help in this?
 "error": "Inserting  'AR Payment' record raised at least one error. Please review the errors.; CashAccountID: 'Cash Account' cannot be empty.",

hdussa
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • Answer
  • February 25, 2025

​@Jayavenitha Please find the jSON below to create the Sales Order with Payment. I just tried in my local machine with the demo data and it is working as expected. Please check with this jSON and confirm.

 

{
    "OrderNbr": {
        "value": "<NEW>"
    },
    "CustomerID": {
        "value": "AACUSTOMER"
    },
    "CustomerLocation": {
        "value": "MAIN"
    },
    "ExternalRef": {
        "value": "801PM00000DhqGnYAJ"
    },
    "OrderType": {
        "value": "SO"
    },
    "IsSpecialOrder": {
        "value": false
    },
    "OrderDate": {
        "value": "2024-04-22"
    },
    "BillToAddressLine1": {
        "value": "1332 Twin Oaks Drive"
    },
    "BillToOverrideAddress": {
        "value": true
    },
    "BillToOverrideContact": {
        "value": true
    },
    "BillToCity": {
        "value": "Kinston"
    },
    "BillToCountry": {
        "value": "US"
    },
    "BillToPostalCode": {
        "value": "28501"
    },
    "BillToState": {
        "value": "NC"
    },
    "BillToEmail": {
        "value": "Test@Test.com"
    },
    "BillToPhone1": {
        "value": "4233492"
    },
    "ShipToAddressLine1": {
        "value": "Test"
    },
    "ShipToOverrideAddress": {
        "value": true
    },
    "ShipToOverrideContact": {
        "value": true
    },
    "ShipToCity": {
        "value": "Test"
    },
    "ShipToCountry": {
        "value": "US"
    },
    "ShipToPostalCode": {
        "value": "42131"
    },
    "ShipToState": {
        "value": "NY"
    },
    "ShipToPhone1": {
        "value": "\\245454"
    },
    "Details": [
        {
            "Amount": {
                "value": 500.00
            },
            "OrderQty": {
                "value": 1
            },
            "UnitPrice": {
                "value": 500.00
            },
            "Branch": {
                "value": "PRODWHOLE"
            },
            "WarehouseID": {
                "value": "WHOLESALE"
            },
            "InventoryID": {
                "value": "AACOMPUT01"
            },
            "ManualPrice": {
                "value": true
            },
            "UOM": {
                "value": "EA"
            }
        }
    ] ,
    "Payments": [
        {
            "DocType": {
                "value": "Payment"
            },
            "PaymentAmount": {
                "value": 500.00
            },
            "ApplicationDate": {
                "value": "2025-02-25T00:00:00+03:00"
            },
            "AppliedToOrder": {
                "value": 500.00
            },
            "PaymentMethod": {
                "value": "CHECK"
            },
            "CashAccount": {
                "value": "10200"
            },
            "PaymentRef": {
                "value": "PMT02241"
            }
        }        
    ]
}

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
hdussa
Jr Varsity I
Forum|alt.badge.img+1
  • hdussa
  • Jr Varsity I
  • February 25, 2025

Hi ​@hdussa When I create without payment it works fine, but when I include payment array it throws below error with 402 code. Is this related to Id mismatch. I directly creating sales order with payment only not shipping now. Can you help in this?
 "error": "Inserting  'AR Payment' record raised at least one error. Please review the errors.; CashAccountID: 'Cash Account' cannot be empty.",

Hi ​@Jayavenitha ,

It is possible that there is a data mismatch or missing a field value. How about you share the request load against the demo data here? This way it is easy to replicate the issue and suggest the solution.

~ Harish Dussa
Chris Hackett
J
variuxDavidE
Varsity I
Forum|alt.badge.img
  • variuxDavidE
  • Varsity I
  • April 27, 2025

​@Jayavenitha Did you get this figured out? If you are still stuck I’d like to help you get unstuck so we can document the solution here in the forum. 

- David Edmonson, Variux.com, Acumatica and Ecommerce Project Management and Turnarounds
Chris Hackett
valentynbeznosiuk
Jr Varsity I
Forum|alt.badge.img+3

Hello ​@Jayavenitha 

As an alternative option, you can consider relating payment to the Sales Order from the Payment side. Let me know if this option works for you, and if you need further assistance with such a payload

Valentyn Beznosiuk || Business Analyst / Acumatica ERP Consultant at ACUPOWER LTD || www.linkedin.com/in/valentynbeznosiuk
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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