Validity on purchase pricing

Using my Dolibarr PM modules
1

Hello all,

Would like to know if something like this exists. I want to put a valid until on my buying prices. We receive new pricelist every 3 months from our suppliers. When the valid until date is expired i would like to get a pop-up that we need to check pricing.

Is something like this possible?

Regards,
Sebastiaan

2

Hi Sebastiaan,

you could add an Extra field in the products → Additional Attributes (Supplier Prices) section to enter the valid until date.

grafik
grafik1584Ă—1117 61.9 KB

as soon as the filed is there you can easily create a query to get lists, pop-ups…

Regards,
Kim

3

Hi Kim,

Thanks for this info. I have created to extra field. Can you help me out setting up a pop-up on the moment you select a product but the price is not valid anymore.

I’m fairly new to Dolibarr so i don’t have a clue how to do this.

Thanks,

Sebastiaan

4

Hi Sebastiaan,
a pup-up is not in the standard of Dolibarr.
Besides that I think you need some more “clever” way for this. Just imagine you will have
200 articles expireing the same day → 200 pop-ups?
I guess one per supplier or one per “list” would be good.
Just send me a PM and we’ll have a chat to find the most suitable soltuion.

Speak to you,
Kim

5

Hi Kim,
The only way “I think” you could achieve your goal (for example, displaying expired products in a different color) is to create a custom module and use one of the many hooks Dolibarr provides.
But this requires programming expertise.

6

Thank you @mgribaudo,

I would have couple ideas to solve it but “pop up window” per product I don’t see as a good solution.

I know about the hooks and such a module can be quickly done. Sebastiaan need to tell what exactly he like to have.

Thanks anyways for the hints.

7

Hi Guys, i have build a custom module that checks the validity of the price as soon as i add a product to a quotation / order. When the price is expired i’ll get a pop-up telling me the price is expired and i’m unable to add the product untill i updated the price.

So topic can be closed, but thanks anyway for your suggestions and tips!

2 Likes
8

You’re right, I was in a hurry to reply to you, but I actually meant to address Sebastian.
Sorry for the oversight :slight_smile:

1 Like
9

your input is appreciated anyway. Thank you!

10

Hi @swalen, as @Kim_KW1975 said, create an extra field on the supplier price, then use hooks to write some code there (IF valid_until < today
THEN show a warning pop-up) , so it’s easy to check the validity date, and it will show a pop-up on your screen. It will be better to do this by developing a custom module, particularly for the hook.

Thanks & Regards
Saikat Koley
Software Developer(Dolibarr)
Call/WhatsApp : +919903256573
Email : saikatkoley@hotmail.com
https://www.linkedin.com/in/saikatkoley/