-->
Welcome, Guest
Username: Password: Remember me
You can also tweak your setup of Dolibarr by setting hidden configurations found in Dolibarr Setup Other

TOPIC: How to get a new field row in product list view

How to get a new field row in product list view 2 months 1 week ago #36198

  • scaleo
  • scaleo's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 2
  • Karma: 0
Hi all,
I use dolibarr 8.0.4.
If I show Products->list I see the total physical stock amoun t of each product.

I need the physical stock of each warehouse in a new extra row. This is necessary to have a overview which products are in my factory warehouse and which products are at the suppliers warehouse.

So, how can I expand that list, to show me the physical stock of each warehouse?


Thanks for all hints.
scaleo
The administrator has disabled public write access.

How to get a new field row in product list view 2 months 1 week ago #36200

  • Peter A. Gebhardt
  • Peter A. Gebhardt's Avatar
  • OFFLINE
  • Master
  • Financial Consultancy & Expert Assessment
  • Posts: 522
  • Thank you received: 88
  • Karma: 20
Look into this module. It may fit your requirements:

https://www.dolistore.com/en/modules/547-myList---personalized-dynamic-Lists.html
The administrator has disabled public write access.

How to get a new field row in product list view 2 months 1 week ago #36211

  • scaleo
  • scaleo's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 2
  • Karma: 0
I tried that, but without any success.
The module discription does not have any examples and so I only try and have errors… ist a horrible way.
Do you have any examples that show, how I have to handle the module?

Without using that module:
Is there a SQL request available which returns me the amount of stock for each warehouse ?
The administrator has disabled public write access.

How to get a new field row in product list view 2 months 1 week ago #36216

  • ariffidaali
  • ariffidaali's Avatar
  • OFFLINE
  • Master
  • Just another Dolibarian!
  • Posts: 256
  • Thank you received: 51
  • Karma: 11
Hi Scaleo,
Try the below SQL query:
SELECT 
	p.ref as ItemCode, 
	p.label as Item_Description, 
	COALESCE(p.price_ttc,0) AS Sell_Price,
	e.label as Warehouse, 
	COALESCE(s.reel,0) as Qty, 
	COALESCE(p.cost_price,0) as Cost_Price, 
	COALESCE(s.reel*p.cost_price,0) AS Value
FROM 
	llx_product_stock s
	RIGHT join llx_product p on p.rowid=s.fk_product
	LEFT join llx_entrepot e on e.rowid = s.fk_entrepot
The administrator has disabled public write access.

How to get a new field row in product list view 2 months 1 week ago #36217

  • ariffidaali
  • ariffidaali's Avatar
  • OFFLINE
  • Master
  • Just another Dolibarian!
  • Posts: 256
  • Thank you received: 51
  • Karma: 11
The result
Stockreport.png
The administrator has disabled public write access.

How to get a new field row in product list view 4 weeks 17 hours ago #36719

  • Joness777
  • Joness777's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 5
  • Karma: -1
sorry, can't open that link :(
The administrator has disabled public write access.
Time to create page: 0.160 seconds