How to Show Last Prices by Customer When Creating Orders?

English Forum
1

@support We’re using NocoBase to manage an internal order management system across multiple remote locations. One challenge we’re facing is with customer-specific pricing — we don’t have standard product prices, and prices vary frequently from one customer to another.

Currently, when creating a new order, users have no easy way to view previous prices for that specific customer. They have to manually search and open past orders one by one to find the last price, which is inefficient.

I tried creating a separate price table and linking it with the sales order table, but couldn’t get it to work as expected.

:question: Is there a way to:

  • Show the last 10–20 prices used for that customer for the selected product?
  • Display this as a dropdown or quick list when entering a new order line?

This would really help our users compare and enter prices faster. Any suggestions, plugins, or relational setups we can try?

Thanks in advance!

Something like this maybe:

image
image995×257 9.53 KB

2

NocoBase 1.x cannot easily meet this need. You can wait for us to release NocoBase 2.0, which will be able to handle this need flexibly and conveniently.

3

@support We’re happy to wait for Nocobase 2.0 —could you share an estimated release date or timeline for its launch?

4

A preview version can be released in July.

1 Like