Skip to main content
Answer

Vendor Contract Cost for the same item

  • March 3, 2025
  • 5 replies
  • 87 views

Forum|alt.badge.img

I have a customer that needs to set up pricing per customer (which we can do).  This issue is that the vendor (manufacture) has established a specific customer price and a specific cost for the distributor.  How do I set up vendor contracts for the same item with different cost (not price)

 

Example

I am a distributor.  My vendor sets up contract pricing for my customer for Item A for $10.  Normal price is $12.  My new cost for this item for this customer is $5 when my normal cost is $6.  I may have several contracts with different customer prices (which effects what the distributor pays).  I need Vendor contract by item by end user.  Any ideas?

 

Best answer by plambert

You could set up matching Customer and Vendor Discount codes for each customer at the rate agreed upon. I don’t believe there’s a way to automatically apply those discount based on anything like a PO-SO link, but it could streamline the process of applying these custom price/costs. Perhaps business events could be set up to apply those discounts on new orders upon order creation, but I can’t think of any direct Vendor to Customer connections.

To be specific, with Vendor V123 and Customer C456: Made a Vendor discount code named C456 and a Customer discount code of V123. Then a GI could track when a new order is made with the proper PO-SO link. That GI will be the source for a business event that applies the customer-named discount to the PO and vendor-named discount to the SO. It would be rather complicated to set up, but any angle is either going to involve manual application or some custom rule making.

5 replies

Samvel Petrosov
Jr Varsity II
Forum|alt.badge.img+8

This sounds like a Vendor rebate that is being passed to the customer as a discount.

Check AcuRebate - Rebate Processing - Marketplace | Acumatica Cloud ERP, it sounds like it should be able to handle this.


nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • March 4, 2025

Hi ​@cherryw10 

Have you tried finding out "Sales Price Worksheets" and "Sales Price"?
On "Sales Price Worksheets" or "Sales Price" screen > Select "Price Type" as "Customer Price Class" > With "Price Code" see it as Vendor > Inventory ID with "Price" according to the price of each "Price Code"

 

In the Customers screen you will specify which "Price Class" the customer will belong to.

Note: The "Price Class" field in the Customer screen is the "Price Code" field in the "Sales Price" screen.

 

 

 

Please refer to the post below.

 

 

Best Regards,

NNT


Forum|alt.badge.img
  • Author
  • Freshman I
  • March 4, 2025

Good Morning and thank you for your response.  I know I can get the customer price correct.  I am trying to solve for the vendor cost for that customer…   See example below..  Any ideas would be welcomed!!!

 

Part Number 02807356

 

  • Purchase Price
    • Customer 1 purchase price $10.25
    • Customer 2 purchase price $10.60
    • Customer 3 purchase price $12.51
  • Sell Price
    • Customer 1 sell price $13.67
    • Customer 2 sell price $15.51
    • Customer 3 sell price $16.04

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 17, 2025

Hi ​@cherryw10 were you able to find a solution? Thank you!


plambert
Semi-Pro I
Forum|alt.badge.img+2
  • Semi-Pro I
  • Answer
  • June 17, 2025

You could set up matching Customer and Vendor Discount codes for each customer at the rate agreed upon. I don’t believe there’s a way to automatically apply those discount based on anything like a PO-SO link, but it could streamline the process of applying these custom price/costs. Perhaps business events could be set up to apply those discounts on new orders upon order creation, but I can’t think of any direct Vendor to Customer connections.

To be specific, with Vendor V123 and Customer C456: Made a Vendor discount code named C456 and a Customer discount code of V123. Then a GI could track when a new order is made with the proper PO-SO link. That GI will be the source for a business event that applies the customer-named discount to the PO and vendor-named discount to the SO. It would be rather complicated to set up, but any angle is either going to involve manual application or some custom rule making.