# Supplier prices Error

**URL:** <https://www.dolibarr.org/forum/t/supplier-prices-error/19385>\
**Category:** CRM/SRM Modules\
**Created:** [August 5, 2020, 9:12am UTC](https://www.dolibarr.org/forum/t/supplier-prices-error/19385 "2020-08-05T09:12:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![alinparcalab](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/a/e5b9ba/32.png) [@alinparcalab](https://www.dolibarr.org/forum/u/alinparcalab)\
**Post date:** [August 5, 2020, 9:12am UTC](https://www.dolibarr.org/forum/t/supplier-prices-error/19385/1 "2020-08-05T09:12:10Z")

</div>

Hello,

When I am trying to associate a product to a supplier I receive the following error:

Unknown column ‘unitcharges’ in ‘field list’ sql=UPDATE llx\_product\_fournisseur\_price SET fk\_user = 1 , ref\_fourn = ‘test001’, price = 2, quantity = 1, remise\_percent = 1, remise = 0, unitprice = 2, unitcharges = 0, fk\_availability = 0, entity = 1, tva\_tx = 0, default\_vat\_code=null, info\_bits = 0, charges = 0, delivery\_time\_days = 30, supplier\_reputation = NULL WHERE rowid = 18

Also:

Supplier prices (1)

Dolibarr has detected a technical error.  
This information can be useful for diagnostic purposes (you can set option $dolibarr\_main\_prod to ‘1’ to remove such notices):  
**Date:** 20200805121112  
**Dolibarr:** 7.0.5  
**Level of features:** 0  
**PHP:** 7.0.33  
**Server:** LiteSpeed  
**OS:** Linux [server62.romania-webhosting.com](http://server62.romania-webhosting.com) 3.10.0-962.3.2.lve1.5.27.el7.x86\_64 #1 SMP Sat Nov 30 02:18:52 EST 2019 x86\_64  
**UserAgent:** Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36

**Requested URL:** /dolibarr/htdocs/product/fournisseurs.php?id=961  
**Referer:** [http://erp.allengra.eu/dolibarr/htdocs/product/fournisseurs.php?id=961&action=add\_price](http://erp.allengra.eu/dolibarr/htdocs/product/fournisseurs.php?id=961&action=add_price)  
**Menu manager:** auguria\_menu.php

**Database type manager:** mysqli  
**Latest database access request error:** SELECT s.nom as supplier\_name, s.rowid as fourn\_id, pfp.rowid as product\_fourn\_pri\_id, pfp.ref\_fourn, pfp.fk\_product as product\_fourn\_id, pfp.fk\_supplier\_price\_expression, pfp.price, pfp.quantity, pfp.unitprice, pfp.remise\_percent, pfp.remise, pfp.tva\_tx, pfp.fk\_availability, pfp.charges, pfp.unitcharges, pfp.info\_bits, pfp.delivery\_time\_days, pfp.supplier\_reputation FROM llx\_product\_fournisseur\_price as pfp, llx\_societe as s WHERE pfp.entity IN (1) AND pfp.fk\_soc = s.rowid AND s.status=1 AND pfp.fk\_product = 961 ORDER BY s.nom ASC  
**Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD  
**Information for latest database access request error:** Unknown column ‘pfp.unitcharges’ in ‘field list’

Thank you very much!