Skip to main content
Solved

How to get customer specific pricing out of Acumatica via API?

B
Jr Varsity III
Forum|alt.badge.img

Hi. Is anyone can give me an advice on how to get customer specific pricing out of Acumatica via API?

Best answer by Naveen Boga

Hi @bernadeth58  Below the REST API to fetch the Customer Price from the Sales Price screen. 

Please find API details and screenshots for reference and hope this helps!!

Method: PUT

API URL: http://localhost/21R1Test/entity/default/20.200.001/SalesPricesInquiry?$expand=SalesPriceDetails

BODY: 

{

"PriceType": {

        "value": "Customer"

    },

    "PriceCode": {

        "value": "AACUSTOMER"

    }

}

 

Screenshots:

 

 

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

    5 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3410 replies
    • Answer
    • March 13, 2022

    Hi @bernadeth58  Below the REST API to fetch the Customer Price from the Sales Price screen. 

    Please find API details and screenshots for reference and hope this helps!!

    Method: PUT

    API URL: http://localhost/21R1Test/entity/default/20.200.001/SalesPricesInquiry?$expand=SalesPriceDetails

    BODY: 

    {

    "PriceType": {

            "value": "Customer"

        },

        "PriceCode": {

            "value": "AACUSTOMER"

        }

    }

     

    Screenshots:

     

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    B
    Chris Hackett
    2 people like this
    • B
      bernadeth58
    • Chris Hackett
      Chris Hackett
    B
    Jr Varsity III
    Forum|alt.badge.img
    • bernadeth58
    • Author
    • Jr Varsity III
    • 67 replies
    • March 14, 2022

    Thank you @Naveen Boga! We will try this. 

    Naveen Boga
    1 person likes this
    • Naveen Boga
      Naveen Boga
    B
    Jr Varsity III
    Forum|alt.badge.img
    • bernadeth58
    • Author
    • Jr Varsity III
    • 67 replies
    • March 14, 2022

    It works @Naveen Boga. Thank you!

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 3410 replies
    • March 14, 2022

    Awesome :) Thanks for sharing the update @bernadeth58  

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    B
    1 person likes this
    • B
      bernadeth58
    F
    Freshman I
    • fbuffa2003
    • Freshman I
    • 4 replies
    • June 1, 2022

    There is any way to get the full list of SalesPrice?

    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