Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge Download Epesi BIM Free & Open Source CRM


We acquired this weekend Inventory mgt module and tried to setup warehouse and first items manually (no uploading). We have not tried to change any defauklt recordset etc.
When entering the item we tried both options of skipping tax selection and using it but it results in the below error code (tax was properly set before). Our regional setting is local HRK currency with decimal as comma. I would appreciate help with undwerstanding what is driving this error (looks like gross_price field is not accepted by recordset)

ERROR:
who=2
type=256
message=gross_price - unknown field for record
a:27:{s:2:"id";s:1:"1";s:7:":active";s:1:"1";s:10:"created_by";s:1:"2";s:10:"created_on";s:19:"2015-03-01
18:33:59";s:3:"sku";s:7:"#000001";s:9:"item_type";s:1:"2";s:9:"item_name";s:14:"bon_NOxIYtpGcB";s:12:"product_code";s:10:"NOxIYtpGcB";s:3:"upc";s:0:"";s:16:"quantity_on_hand";s:1:"0";s:13:"quantity_sold";s:0:"";s:17:"quantity_en_route";s:0:"";s:13:"available_qty";s:0:"";s:12:"reserved_qty";s:0:"";s:13:"reorder_point";s:1:"0";s:6:"weight";s:1:"1";s:6:"volume";s:0:"";s:24:"manufacturer_part_number";s:0:"";s:12:"manufacturer";s:1:"1";s:6:"vendor";s:1:"1";s:9:"net_price";s:5:"39__1";s:8:"tax_rate";s:0:"";s:4:"cost";s:4:"1__1";s:8:"category";a:1:{i:1;s:1:"1";}s:11:"description";s:0:"";s:15:"last_sale_price";s:3:"__1";s:19:"last_purchase_price";s:3:"__1";}
error
file=/home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
error line=48

Welcome on board!

Please provide rest of this error report. It's required to spot the issue.

Regards,
Adam

Adam thx for coming back. Here's the full code list

Type: E_USER_ERROR (256)
Message: gross_price - unknown field for record a:28:{s:2:"id";s:1:"1";s:7:":active";s:1:"1";s:10:"created_by";s:1:"2";s:10:"created_on";s:19:"2015-03-0115:37:32";s:3:"sku";s:7:"#000001";s:9:"item_type";s:1:"0";s:9:"item_name";s:4:"test";s:12:"product_code";s:6:"xd3df5";s:3:"upc";s:0:"";s:16:"quantity_on_hand";s:1:"0";s:13:"quantity_sold";s:0:"";s:17:"quantity_en_route";s:0:"";s:13:"available_qty";s:0:"";s:12:"reserved_qty";s:0:"";s:8:"dist_qty";s:0:"";s:13:"reorder_point";s:1:"0";s:6:"weight";s:1:"1";s:6:"volume";s:0:"";s:24:"manufacturer_part_number";s:0:"";s:12:"manufacturer";s:0:"";s:6:"vendor";s:0:"";s:9:"net_price";s:5:"39__1";s:8:"tax_rate";s:1:"1";s:4:"cost";s:3:"__1";s:8:"category";a:1:{s:3:"1/2";s:3:"1/2";}s:11:"description";s:0:"";s:15:"last_sale_price";s:3:"__1";s:19:"last_purchase_price";s:3:"__1";}
File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
Line=48
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "gross_price - unknown field for record a:28:{s:2:\"id\";s:1:\"1\";s:7:\":active\";s:1:\"1\";s:10:\"created_by\";s:1:\"2\";s:10:\"created_on\";s:19:\"2015-03-01 15:37:32\";s:3:\"sku\";s:7:\"#000001\";s:9:\"item_type\";s:1:\"0\";s:9:\"item_name\";s:4:\"test\";s:12:\"product_code\";s:6:\"xd3df5\";s:3:\"upc\";s:0:\"\";s:16:\"quantity_on_hand\";s:1:\"0\";s:13:\"quantity_sold\";s:0:\"\";s:17:\"quantity_en_route\";s:0:\"\";s:13:\"available_qty\";s:0:\"\";s:12:\"reserved_qty\";s:0:\"\";s:8:\"dist_qty\";s:0:\"\";s:13:\"reorder_point\";s:1:\"0\";s:6:\"weight\";s:1:\"1\";s:6:\"volume\";s:0:\"\";s:24:\"manufacturer_part_number\";s:0:\"\";s:12:\"manufacturer\";s:0:\"\";s:6:\"vendor\";s:0:\"\";s:9:\"net_price\";s:5:\"39__1\";s:8:\"tax_rate\";s:1:\"1\";s:4:\"cost\";s:3:\"__1\";s:8:\"category\";a:1:{s:3:\"1/2\";s:3:\"1/2\";}s:11:\"description\";s:0:\"\";s:15:\"last_sale_price\";s:3:\"__1\";s:19:\"last_purchase_price\";s:3:\"__1\";}", "/home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php", 48, Array ("premium_warehouse_items", "Gross Price", Array (#28), false, Array (#15), "/"))

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 48
function called: trigger_error("gross_price - unknown field for record a:28:{s:2:\"id\";s:1:\"1\";s:7:\":active\";s:1:\"1\";s:10:\"created_by\";s:1:\"2\";s:10:\"created_on\";s:19:\"2015-03-01 15:37:32\";s:3:\"sku\";s:7:\"#000001\";s:9:\"item_type\";s:1:\"0\";s:9:\"item_name\";s:4:\"test\";s:12:\"product_code\";s:6:\"xd3df5\";s:3:\"upc\";s:0:\"\";s:16:\"quantity_on_hand\";s:1:\"0\";s:13:\"quantity_sold\";s:0:\"\";s:17:\"quantity_en_route\";s:0:\"\";s:13:\"available_qty\";s:0:\"\";s:12:\"reserved_qty\";s:0:\"\";s:8:\"dist_qty\";s:0:\"\";s:13:\"reorder_point\";s:1:\"0\";s:6:\"weight\";s:1:\"1\";s:6:\"volume\";s:0:\"\";s:24:\"manufacturer_part_number\";s:0:\"\";s:12:\"manufacturer\";s:0:\"\";s:6:\"vendor\";s:0:\"\";s:9:\"net_price\";s:5:\"39__1\";s:8:\"tax_rate\";s:1:\"1\";s:4:\"cost\";s:3:\"__1\";s:8:\"category\";a:1:{s:3:\"1/2\";s:3:\"1/2\";}s:11:\"description\";s:0:\"\";s:15:\"last_sale_price\";s:3:\"__1\";s:19:\"last_purchase_price\";s:3:\"__1\";}", 256)

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 153
function called: get_val("premium_warehouse_items", "Gross Price", Array (#28), false, Array (#15))

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 968
function called: get_val("Gross Price", Array (#28), false, Array (#15))

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 298
function called: show_data(Array (), Array (true, true), Array ("ASC"))

[PHP core called function]
function called: body(Array (), Array (), Array (true, true))

File: /home/interfokushr/public_html/crm/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array (Array (#0), Array (#0), Array (#2)))

File: /home/interfokushr/public_html/crm/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#0), Array (#0), Array (#2)), null)

File: /home/interfokushr/public_html/crm/modules/Premium/Warehouse/Items/Items_0.php
line 82
function called: display_module("Object (Utils_RecordBrowser)", Array (Array (#0), Array (#0), Array (#2)))

[PHP core called function]
function called: body()

File: /home/interfokushr/public_html/crm/include/module.php
line 793
function called: call_user_func_array(Array (Object (Premium_Warehouse_Items), "body"), Array ())

File: /home/interfokushr/public_html/crm/include/module.php
line 713
function called: get_html_of_module(Object (Premium_Warehouse_Items), null, null)

File: /home/interfokushr/public_html/crm/modules/Base/Box/Box_0.php
line 151
function called: display_module("Object (Premium_Warehouse_Items)")

File: /home/interfokushr/public_html/crm/include/epesi.php
line 241
function called: body()

File: /home/interfokushr/public_html/crm/include/epesi.php
line 286
function called: go(Object (Base_Box))

File: /home/interfokushr/public_html/crm/process.php
line 35
function called: process("__action_module__=%2FBase_Box%7C0%2FBase_Admin%7Cmain_442b2787f112c58a8060679276cc3a73%2FUtils_RecordBrowser%7C0&%2FBase_Box%7C0%2FBase_Admin%7Cmain_442b2787f112c58a8060679276cc3a73%2FUtils_RecordBrowser%7C0_back=1", false)

Type: E_USER_ERROR (256)
Message: gross_price - unknown field for record a:28:{s:2:"id";s:1:"1";s:7:":active";s:1:"1";s:10:"created_by";s:1:"2";s:10:"created_on";s:19:"2015-03-0115:37:32";s:3:"sku";s:7:"#000001";s:9:"item_type";s:1:"0";s:9:"item_name";s:4:"test";s:12:"product_code";s:6:"xd3df5";s:3:"upc";s:0:"";s:16:"quantity_on_hand";s:1:"0";s:13:"quantity_sold";s:0:"";s:17:"quantity_en_route";s:0:"";s:13:"available_qty";s:0:"";s:12:"reserved_qty";s:0:"";s:8:"dist_qty";s:0:"";s:13:"reorder_point";s:1:"0";s:6:"weight";s:1:"1";s:6:"volume";s:0:"";s:24:"manufacturer_part_number";s:0:"";s:12:"manufacturer";s:0:"";s:6:"vendor";s:0:"";s:9:"net_price";s:5:"39__1";s:8:"tax_rate";s:1:"1";s:4:"cost";s:3:"__1";s:8:"category";a:1:{s:3:"1/2";s:3:"1/2";}s:11:"description";s:0:"";s:15:"last_sale_price";s:3:"__1";s:19:"last_purchase_price";s:3:"__1";}
File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
Line=48
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "gross_price - unknown field for record a:28:{s:2:\"id\";s:1:\"1\";s:7:\":active\";s:1:\"1\";s:10:\"created_by\";s:1:\"2\";s:10:\"created_on\";s:19:\"2015-03-01 15:37:32\";s:3:\"sku\";s:7:\"#000001\";s:9:\"item_type\";s:1:\"0\";s:9:\"item_name\";s:4:\"test\";s:12:\"product_code\";s:6:\"xd3df5\";s:3:\"upc\";s:0:\"\";s:16:\"quantity_on_hand\";s:1:\"0\";s:13:\"quantity_sold\";s:0:\"\";s:17:\"quantity_en_route\";s:0:\"\";s:13:\"available_qty\";s:0:\"\";s:12:\"reserved_qty\";s:0:\"\";s:8:\"dist_qty\";s:0:\"\";s:13:\"reorder_point\";s:1:\"0\";s:6:\"weight\";s:1:\"1\";s:6:\"volume\";s:0:\"\";s:24:\"manufacturer_part_number\";s:0:\"\";s:12:\"manufacturer\";s:0:\"\";s:6:\"vendor\";s:0:\"\";s:9:\"net_price\";s:5:\"39__1\";s:8:\"tax_rate\";s:1:\"1\";s:4:\"cost\";s:3:\"__1\";s:8:\"category\";a:1:{s:3:\"1/2\";s:3:\"1/2\";}s:11:\"description\";s:0:\"\";s:15:\"last_sale_price\";s:3:\"__1\";s:19:\"last_purchase_price\";s:3:\"__1\";}", "/home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php", 48, Array ("premium_warehouse_items", "Gross Price", Array (#28), false, Array (#15), "/"))

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 48
function called: trigger_error("gross_price - unknown field for record a:28:{s:2:\"id\";s:1:\"1\";s:7:\":active\";s:1:\"1\";s:10:\"created_by\";s:1:\"2\";s:10:\"created_on\";s:19:\"2015-03-01 15:37:32\";s:3:\"sku\";s:7:\"#000001\";s:9:\"item_type\";s:1:\"0\";s:9:\"item_name\";s:4:\"test\";s:12:\"product_code\";s:6:\"xd3df5\";s:3:\"upc\";s:0:\"\";s:16:\"quantity_on_hand\";s:1:\"0\";s:13:\"quantity_sold\";s:0:\"\";s:17:\"quantity_en_route\";s:0:\"\";s:13:\"available_qty\";s:0:\"\";s:12:\"reserved_qty\";s:0:\"\";s:8:\"dist_qty\";s:0:\"\";s:13:\"reorder_point\";s:1:\"0\";s:6:\"weight\";s:1:\"1\";s:6:\"volume\";s:0:\"\";s:24:\"manufacturer_part_number\";s:0:\"\";s:12:\"manufacturer\";s:0:\"\";s:6:\"vendor\";s:0:\"\";s:9:\"net_price\";s:5:\"39__1\";s:8:\"tax_rate\";s:1:\"1\";s:4:\"cost\";s:3:\"__1\";s:8:\"category\";a:1:{s:3:\"1/2\";s:3:\"1/2\";}s:11:\"description\";s:0:\"\";s:15:\"last_sale_price\";s:3:\"__1\";s:19:\"last_purchase_price\";s:3:\"__1\";}", 256)

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 153
function called: get_val("premium_warehouse_items", "Gross Price", Array (#28), false, Array (#15))

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 968
function called: get_val("Gross Price", Array (#28), false, Array (#15))

File: /home/interfokushr/public_html/crm/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 298
function called: show_data(Array (), Array (true, true), Array ("ASC"))

[PHP core called function]
function called: body(Array (), Array (), Array (true, true))

File: /home/interfokushr/public_html/crm/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array (Array (#0), Array (#0), Array (#2)))

File: /home/interfokushr/public_html/crm/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array (Array (#0), Array (#0), Array (#2)), null)

File: /home/interfokushr/public_html/crm/modules/Premium/Warehouse/Items/Items_0.php
line 82
function called: display_module("Object (Utils_RecordBrowser)", Array (Array (#0), Array (#0), Array (#2)))

[PHP core called function]
function called: body()

File: /home/interfokushr/public_html/crm/include/module.php
line 793
function called: call_user_func_array(Array (Object (Premium_Warehouse_Items), "body"), Array ())

File: /home/interfokushr/public_html/crm/include/module.php
line 713
function called: get_html_of_module(Object (Premium_Warehouse_Items), null, null)

File: /home/interfokushr/public_html/crm/modules/Base/Box/Box_0.php
line 151
function called: display_module("Object (Premium_Warehouse_Items)")

File: /home/interfokushr/public_html/crm/include/epesi.php
line 241
function called: body()

File: /home/interfokushr/public_html/crm/include/epesi.php
line 286
function called: go(Object (Base_Box))

File: /home/interfokushr/public_html/crm/process.php
line 35
function called: process("parent_module=Premium_Warehouse_Items&box_main_href=47f2955ca572c989fac5ba163de8bdb0", false)

Hi,
we released fixed version in epesi store - please go there in your Epesi and do update.

Regards,
Pawel

Hi Pawel, thx for the code fix. It worked well. We are just facing one strange behavior and trying to understand if it's code related or we're still setting up permissions over recordsets wrongly for "items" and "items_location". We are unable to enter "Quantity on Hand" while in the "Items location" tab we do not get 'Add new button'. We tried with setting full permissione for employee, manager, admin and even superadmin but we could not get it editable.
Thx for clarification.
Leo

Hi
You cannot modify quantity. You have to create transaction:
Menu->Inventory->Items transactions->New->"Inv. adjustment" or "Purchase"->choose magazine->save->add products->close transaction (change status).

Regards
Pawel

Write a Reply...