Selling price and cost price in the database

Using my Dolibarr Financial modules
1

where can I find in the database the selling price and cost price? I can’t find the table name like for example llx_commande, llx_product, etc.

Margins Selling price Cost price Margin Margin rate Mark rate
Margin / Products 5,650.00 4,250.00 1,400.00 32.94% 24.78%
2

Hej deploy,

i can’t look at my database currently. But as far as i remember out of my mind the prices are located in the product table. If not let me know. Then i will look at the database tonight.

regards
Stefan

3

thanks whynot, I found it…but what about the margin and margin rate?

4

Hej deploy,

the margin depends on the selling and purchasing prices. It’s just the difference between selling and purchasing. There is no further calculating as you might know from creating a balance and showing EBIT, EBITDA and so on. It’s just a raw margin that is calculated every time.

regards
Stefan

1 Like
5

Hi Stefan,

I really appreciated the way you interact and respond. Thank you very much for your speedy and quick response. What I did was I extract my data from libre dbase then copy paste to libre calc. to play with it. I manually get all the selling price and cost price for each item using vlookup function, after that I calculated the margin. Hopefully, the dolibarr team will implement the BI as soon as possible for us to be easily generate the necessary reports that is very vital in decision making with regards to our business.