Skip to main content
Answer

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

  • March 13, 2022
  • 5 replies
  • 520 views
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:

 

 

    5 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 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
    B
    Jr Varsity III
    Forum|alt.badge.img
    • bernadeth58
    • Author
    • Jr Varsity III
    • March 14, 2022

    Thank you @Naveen Boga! We will try this. 

    Naveen Boga
    B
    Jr Varsity III
    Forum|alt.badge.img
    • bernadeth58
    • Author
    • Jr Varsity III
    • March 14, 2022

    It works @Naveen Boga. Thank you!

    Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • 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
    F
    Freshman I
    • fbuffa2003
    • Freshman I
    • June 1, 2022

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

    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