Skip to main content
Solved

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

  • March 13, 2022
  • 5 replies
  • 576 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+20
    • 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 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
      B
      Jr Varsity III
      Forum|alt.badge.img
      • bernadeth58
      • Author
      • Jr Varsity III
      • March 14, 2022

      Thank you @Naveen Boga! We will try this. 

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

        It works @Naveen Boga. Thank you!

          Naveen Boga
          Captain II
          Forum|alt.badge.img+20
          • Naveen Boga
          • Captain II
          • March 14, 2022

          Awesome :) Thanks for sharing the update @bernadeth58  

          Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
            F
            Freshman I
            • fbuffa2003
            • Freshman I
            • June 1, 2022

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

            Terms & ConditionsAccessibility 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