Notice: Undefined property: stdClass::$ar_revenue_schedule_cb in C:\wamp\www\inoerp\extensions\site_info\class_site_info.inc on line 142

I create the purchase order ,it showing Setup in complete. No currency found. Error @ trait_dbObject_t.inc @@ line 1355
Record couldnt be saved. Error @ trait_dbObject_t.inc @@line730
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'currency' cannot be null
Action Completed

how to fix this error,i filled all the field but it showing currency error

Hi,
In Purchasing Transaction i create invoice it showing Record couldnt be saved. Error @ trait_dbObject_t.inc @@line730
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'inv_intorg_transfer_line_id' in 'field list'
Transaction complete

I have downloaded the latest version of inoerp and install to my virtualbox. Installation done successfully but I can't search any org data "Org->Search Org". I have checked Mysql and there are some records inside. I am login using inoerp .

FA asset template keeps popping header save but cant save without assigning employee
separated them into header and lines

<div id ="form_header">
 <form action=""  method="post" id="fa_asset"  name="fa_asset">
  <span class="heading"><?php echo gettext('Fixed Asset Details') ?></span>
  <!--div id="form_header"-->
   <div id="tabsHeader">
    <ul class="tabMain">
     <li><a href="#tabsHeader-1"><?php echo gettext('Basic') ?></a></li>
     <li><a href="#tabsHeader-2"><?php echo gettext('Tracking Info') ?></a></li>
     <li><a href="#tabsHeader-3"><?php echo gettext('Attachments') ?></a></li>
     <li><a href="#tabsHeader-4"><?php echo gettext('Note') ?></a></li>
    </ul>
    <div class="tabContainer">
     <div id="tabsHeader-1" class="tabContent">
      <ul class="column header_field">
       <li><?php $f->l_text_field_dr_withSearch('fa_asset_id') ?>
        <a name="show" href="form.php?class_name=fa_asset&<?php echo "mode=$mode"; ?>" class="show document_id fa_asset_id">
         <i class="fa fa-refresh"></i></a> 
       </li>
       <li><?php $f->l_text_field_d('asset_number'); ?></li>
       <li><?php $f->l_select_field_from_object('fa_asset_category_id', fa_asset_category::find_all(), 'fa_asset_category_id', 'asset_category', $$class->fa_asset_category_id, 'fa_asset_category_id', '', 1); ?></li>
       <li><?php $f->l_select_field_from_array('status', fa_asset::$status_a, $$class->status, 'status'); ?></li>
       <li><?php $f->l_text_field_dm('units'); ?></li>
       <li><?php $f->l_select_field_from_array('type', fa_asset::$type_a, $$class->type, '', '', 1); ?></li>
       <li><?php $f->l_text_field_d('parent_asset_id'); ?></li>
       <li><?php $f->l_text_field_d('description'); ?></li>
      </ul>
     </div>
     <div id="tabsHeader-2" class="tabContent">
      <ul class="column header_field">
       <li><?php $f->l_text_field_d('tag_number'); ?></li>
       <li><?php $f->l_text_field_d('serial_number'); ?></li>
       <li><?php $f->l_text_field_d('key_number'); ?></li>
       <li><?php $f->l_text_field_d('manufacturer'); ?></li>
       <li><?php $f->l_text_field_d('model_number'); ?></li>
       <li><?php $f->l_text_field_d('warrranty_number'); ?></li>
       <li><?php $f->l_text_field_d('lease_number'); ?></li>
       <li><label>Physical Inv?</label><?php echo $f->checkBox_field('physical_inventory_cb', $$class->physical_inventory_cb); ?></li>
       <li><?php $f->l_text_field_d('rev_number'); ?></li>
      </ul>
     </div>
     <div id="tabsHeader-3" class="tabContent">
      <div> <?php echo ino_attachement($file) ?> </div>
     </div>
     <div id="tabsHeader-4" class="tabContent">
      <div id="comments">
       <div id="comment_list">
        <?php echo!(empty($comments)) ? $comments : ""; ?>
       </div>
       <div id ="display_comment_form">
        <?php
        $reference_table = 'fa_asset';
        $reference_id = $$class->fa_asset_id;
        ?>
       </div>
       <div id="new_comment">
       </div>
      </div>
      <div> 
      </div>
     </div>
    </div>
   </div>
   </form>
  </div>

  <div id ="form_line" class="form_line"><span class="heading">Asset Line Details </span>
<form action=""  method="post" id="fa_asset_assignment"  name="fa_asset_assignment">
   <div id="tabsLine">
    <ul class="tabMain">
     <li><a href="#tabsLine-1"><?php echo gettext('Assignments') ?></a></li>
     <li><a href="#tabsLine-2"><?php echo gettext('Other Details') ?> </a></li>
    </ul>
    <div class="tabContainer"> 
     <div id="tabsLine-1" class="tabContent">
      <table class="form_table">
       <thead> 
        <tr>
         <th><?php echo gettext('Action') ?></th>
         <th><?php echo gettext('Line Id') ?></th>
         <th><?php echo gettext('Units') ?>#</th>
         <th><?php echo gettext('Employee') ?></th>
         <th><?php echo gettext('Expense') ?></th>
         <th><?php echo gettext('Address') ?></th>
         <th><?php echo gettext('Description') ?></th>
        </tr>
       </thead>
       <tbody class="form_data_line_tbody fa_asset_assignment_values" >
        <?php
        $count = 0;
        $fa_asset_assignment_object_ai = new ArrayIterator($fa_asset_assignment_object);
        $fa_asset_assignment_object_ai->seek($position);
        while ($fa_asset_assignment_object_ai->valid()) {
         $fa_asset_assignment = $fa_asset_assignment_object_ai->current();
         if (!empty($fa_asset_assignment->hr_employee_id)) {
          $emp_details_l = hr_employee::find_by_id($fa_asset_assignment->hr_employee_id);
          $fa_asset_assignment->employee_name = $emp_details_l->first_name . ' ' . $emp_details_l->last_name;
         } else {
          $fa_asset_assignment->employee_name = null;
         }

         if (!empty($fa_asset_assignment->address_id)) {
          $address_l = address::find_by_id($fa_asset_assignment->address_id);
          $fa_asset_assignment->address_name = $address_l->address_name;
         } else {
          $fa_asset_assignment->address_name = null;
         }
         ?>         
         <tr class="fa_asset_assignment<?php echo $count ?>">
          <td>
           <?php
           echo ino_inline_action($fa_asset_assignment->fa_asset_assignment_id, array('fa_asset_id' => $$class->fa_asset_id));
           ?>
          </td>
          <td><?php form::number_field_wid2sr('fa_asset_assignment_id'); ?></td>
          <td><?php echo $f->number_field('units', $$class_second->units, '', '', 'line_units'); ?></td>
          <td><?php
          echo $f->val_field('employee_name', $$class_second->employee_name, '', '', 'vf_select_member_employee_name', '', '', 'hr_employee_v', 'employee_name');
          echo $f->hidden_field('hr_employee_id', $$class_second->hr_employee_id);
           ?><i class="generic g_select_employee_name select_popup clickable fa fa-search" data-class_name="hr_employee_v"></i></td>
          <td><?php $f->ac_field_d2m('expense_ac_id'); ?></td>
          <td><?php
          echo $f->val_field('address_name', $$class_second->address_name, '', '', 'vf_select_address_name', '', '', 'address', 'address_name');
          echo $f->hidden_field('address_id', $$class_second->address_id);
           ?><i class="generic g_select_address select_popup clickable fa fa-search" data-class_name="address"></i></td>
          <td><?php $f->text_field_wid2('description'); ?></td>
         </tr>
         <?php
         $fa_asset_assignment_object_ai->next();
         if ($fa_asset_assignment_object_ai->key() == $position + $per_page) {
          break;
         }
         $count = $count + 1;
        }
        ?>
       </tbody>
      </table>
      <!--end of tab1 div three_column-->
     </div> 
     <div id="tabsLine-2" class="tabContent">
      <ul class='column header_field'>
       <li>
        <div class="btn-group row">
         <button type="button" class="btn btn-primary btn-lg">
          <span  aria-hidden="true"></span><i class='fa fa-book white-font-link'></i> Asset Books</button>
         <button type="button" class="btn btn-primary dropdown-toggle btn-lg" data-toggle="dropdown" aria-expanded="false">
          <span class="caret"></span>
          <span class="sr-only">Toggle Dropdown</span>
         </button>
         <ul class="dropdown-menu" role="menu">
          <?php
          $ab = fa_asset_book::find_all();
          foreach ($ab as $ab_i) {
           echo '<li><a target="_blank" href="form.php?mode=9&class_name=fa_asset_book_info&fa_asset_book_id=' .
           $ab_i->fa_asset_book_id . '&fa_asset_id=' . $$class->fa_asset_id . '">' . $ab_i->asset_book_name . '</a></li>';
          }
          ?>
         </ul>
        </div>
       </li>
       <li><a target="_blank" role="button"  class="btn btn-primary btn-lg white-font-link" href="form.php?mode=9&class_name=fa_asset_source&fa_asset_id=<?php echo $$class->fa_asset_id ?>"> <i class="fa fa-reorder white-font-link"></i> Source Lines </a>  </li>
       <li> <button type="button" class="btn btn-primary btn-lg "> <i class="fa fa-list-ul white-font-link"></i> Components </button>  </li>
       <li> <button type="button" class="btn btn-primary btn-lg "> <i class="fa fa-bolt white-font-link"></i> Retirements </button>  </li>
       <li> <button type="button" class="btn btn-primary btn-lg "> <i class="fa fa-money white-font-link"></i> Financial Inquiry </button>  </li>
      </ul>

     </div>

    </div>


   </div>


</form>
  </div> 

 <div id="pagination" style="clear: both;">
  <?php echo ($total_count > 9 ) ? $pagination->show_pagination() : ''; ?>
 </div>
</div>




<div id="js_data">
 <ul id="js_saving_data">
  <li class="headerClassName" data-headerClassName="fa_asset" ></li>
  <li class="lineClassName" data-lineClassName="fa_asset_assignment" ></li>
  <li class="savingOnlyHeader" data-savingOnlyHeader="false" ></li>
  <li class="primary_column_id" data-primary_column_id="fa_asset_id" ></li>
  <li class="form_header_id" data-form_header_id="fa_asset" ></li>
  <li class="line_key_field" data-line_key_field="line_type" ></li>
  <li class="single_line" data-single_line="false" ></li>
  <li class="form_line_id" data-form_line_id="fa_asset_assignment" ></li>
 </ul>
 <ul id="js_contextMenu_data">
  <li class="docHedaderId" data-docHedaderId="fa_asset_id" ></li>
  <li class="docLineId" data-docLineId="fa_asset_assignment_id" ></li>
  <li class="btn1DivId" data-btn1DivId="fa_asset" ></li>
  <li class="btn2DivId" data-btn2DivId="form_line" ></li>
  <li class="trClass" data-docHedaderId="fa_asset_assignment" ></li>
  <li class="tbodyClass" data-tbodyClass="form_data_line_tbody" ></li>
  <li class="noOfTabbs" data-noOfTabbs="3" ></li>
 </ul>
</div>

Approvals seem not to be working in all modules, i have created approval limits and configured purchasing control for supervisor

In HR supervisor is not getting saved, also employee associations to user do not update in DB

I'm getting this error during installation:

`( ! ) Fatal error: Cannot redeclare __() (previously declared in C:\vhosts\Sistemas-Ino1\locale\gettext.inc:286) in C:...\locale\gettext.inc on line 501
Call Stack

Time Memory Function Location

1 0.0030 371224 {main}( ) ...\install.php:0
2 0.0804 503800 include_once( 'C:...\includes\basics\basics.inc' ) ...\install.php:13
3 2.2916 7910568 require_once( 'C:...\locale\gettext.inc' ) ...\basics.inc:450
`

It's fixed by changing gettext.inc at line 501 from this:
function __($msgid) { return ___($msgid); }

To this:
if (!function_exists('__')) { function __($msgid) { return ___($msgid); } }

hi, i just installed on demo mode and when i open the POS link (Hybrid POS) it dose not show anything, if i to refresh it it will give me an errors:

Notice: Trying to get property of non-object in C:\xampp\htdocs\i\modules\sys\profile\class_sys_profile_line.inc on line 65

Notice: Trying to get property of non-object in C:\xampp\htdocs\i\modules\sys\profile\class_sys_profile_line.inc on line 68

am i to install anything before this or what?

P.S: in the demo also the POS links dose not work

thanks
mark

Trying to learn the system, its comprehensive, i have noticed that Sales and distribution does not have any approvals and would like to understand why the business process for sales does not include approvals at any level..

The balances for both income and balance sheet differ for detailed and summary report types

Is there any chance to get InoERP work with Woocommerce ?

@inoerp, I don't know which payment term was considered here (please check the red circled one):

I think this is something you may need to check on your sql files.

Getting Infinity pop up "Readonly Filed" when selecting "Group Access ID" field from http://127.0.0.1/inoERP/inoerp/form.php?class_name=user_group_access&mode=9 . I know it is not expected to be focused but should pop up the alert only once.

if the SO has many item lines, AR transaction complete only picks the last one

changed line 182 code in AR transaction line to

Public static function find_sumAmounts($ar_transaction_header_id) {
$sql = " SELECT SUM(inv_line_price) as total_line_amount, SUM(tax_amount) as total_tax_amount, ar_transaction_line_id
FROM ar_transaction_line
WHERE ar_transaction_header_id = '{$ar_transaction_header_id}'
GROUP BY ar_transaction_header_id ";
//echo $sql;
$result = self::find_by_sql($sql);
return !empty($result) ? array_pop($result) : null;
}

How can I add italian language? Can I translate inoERP into italian language?

how to provide a role to user in inoerp from admin section

Cant login after pulling latest commits, no errors in error log

Role assignment seems to have broken, the assigned modules are not being seen by the user

While installing the demo company with version 0.4.1 this error occurs:
SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'prj_percent_line_id'

If you check the file inoerp/engine/install/inoerp.sql you can see the problem in the section "Structure for view prj_percent_line_v". There the column 'prj_percent_line_id' is defined twice.

Hi Sir

Why it show error message as follow:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1) DEFAULT NULL, last_update_by int(12) NOT NULL, last_update_date ' at line 33
The sql is: CREATE TABLE IF NOT EXISTS prj_role ( prj_role_id int(12) unsigned NOT NULL AUTO_INCREMENT, role_name varchar(25) NOT NULL, description varchar(255) DEFAULT NULL, user_role varchar(25) DEFAULT NULL, effective_from date DEFAULT NULL, effective_to date DEFAULT NULL, labor_cost_cb tinyint(1) DEFAULT NULL, contract_member_cb tinyint(1) DEFAULT NULL, project_member_cb tinyint(1) DEFAULT NULL, task_member_cb tinyint(1) DEFAULT NULL, scheduling_cb tinyint(1) DEFAULT NULL, min_job_level int(4) DEFAULT NULL, max_job_level int(4) DEFAULT NULL, hr_job_id int(12) DEFAULT NULL, created_by int(12) NOT NULL, creation_date datetime(1) DEFAULT NULL, last_update_by int(12) NOT NULL, last_update_date datetime DEFAULT NULL, PRIMARY KEY (prj_role_id), UNIQUE KEY value_group (role_name) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'domain databased.prj_role' doesn't exist
The sql is: INSERT INTO prj_role (prj_role_id, role_name, description, user_role, effective_from, effective_to, labor_cost_cb, contract_member_cb, project_member_cb, task_member_cb, scheduling_cb, min_job_level, max_job_level, hr_job_id, created_by, creation_date, last_update_by, last_update_date) VALUES (1, 'Account Manager', 'Account Manager', NULL, NULL, NULL, 1, 1, 1, NULL, 1, 10, 15, NULL, 34, '2015-06-22 05:30:08.0', 34, '2015-06-22 05:30:08'), (2, 'Administrative ', 'Administrative Work', NULL, NULL, NULL, NULL, 1, 1, 1, NULL, 10, 15, NULL, 34, '2015-06-22 05:33:37.0', 34, '2015-06-22 05:33:37'), (3, 'Business Analyst', 'Business Analyst', NULL, NULL, NULL, 1, NULL, 1, NULL, 1, 10, 15, NULL, 34, '2015-06-22 05:34:29.0', 34, '2015-06-22 05:34:29')

if you update file, could you send to my mail [email protected]

best regard
Author

I'm new to this erp library and I want to know each purpose of the AR models. Is their any documentation explaining the models in each modules? Thanks!

I try install InoERP, but I got error message :
Notice: Undefined property: stdClass::$phone_no in C:\UniServer\www\inoerp\extensions\site_info\class_site_info.inc on line 116

Fatal error: Can't use function return value in write context in C:\UniServer\www\inoerp\modules\inv\locator\class_locator.inc on line 171

What's wrong in my step?

Thanks

I have multiple items that i can sell on same sales order but would like the GL to credit the sales accounts for the different items when posting invoice, it seems to be taking only from the header document type, not line document type

I created a user in inoerp and changed their role as a buyer. after that In buyer dashboard we used a purchased order section but there is no save section to save purchased order.

Hi ,

I want to install inoerp on my shared hosting ,
Initially I was getting
Fatal error: Cannot redeclare __() (previously declared in C:\localhost\inoERP-master\inoerp\locale\gettext.inc:290) in C:\localhost\inoERP-master\inoerp\locale\gettext.inc on line 505.

as per suggestion : http://inoideas.org/content/installation-problem?pageno=1&installation-problem
I comment out following lines.

function __($msgid) {
return ___($msgid);
}

to

// function __($msgid) {
// return ___($msgid);
// }

But Now I can navigate to Installation page one but asking me to fix the issue : "gettext module is required" .

Please suggest

Regards
Sukanta Manna

Hi,

I have install InoERP ver 0.5.1 successfully.
However, i can not assign user in 'User Group Assignment' tab (in My Details).

It say: ' savefailed [object Object]errorForbidden' everytime i click save button.
The screenshot is here.

Anyone able to help me to resolve this issue?
Thank you in advance.

Warning: First parameter must either be an object or the name of an existing class in C:\xampp\htdocs\inoERP-master\inoerp\modules\sys\profile\class_sys_profile_line.inc on line 66

Warning: First parameter must either be an object or the name of an existing class in C:\xampp\htdocs\inoERP-master\inoerp\modules\sys\profile\class_sys_profile_line.inc on line 72

Hello ,

I went through the video of InoERP and its really good,
but we are unable to add the new organizations and users for that organization
Please help us.
Thank You

I am developing a custom module in my system,here i can create any number of records,here in the search button i need to get the only particular(login) records.(for example a particular user,should see only his records,not other records.But here I can see all other user records also).So how can I restrict other user records.

example:abc user create 2 records. and xyz user create 4 records.
if abc user login ,it should be display only abc records when click on search button.

Hello,
I need to know the flow of inoerp could you provide me the documentation

Hi,

In the file inoerp.sql i keep getting errors...

On 3 different servers...

SQL-query:

CREATE TABLE IF NOT EXISTS prj_role (
prj_role_id int(12) unsigned NOT NULL AUTO_INCREMENT,
role_name varchar(25) NOT NULL,
description varchar(255) DEFAULT NULL,
user_role varchar(25) DEFAULT NULL,
effective_from date DEFAULT NULL,
effective_to date DEFAULT NULL,
labor_cost_cb tinyint(1) DEFAULT NULL,
contract_member_cb tinyint(1) DEFAULT NULL,
project_member_cb tinyint(1) DEFAULT NULL,
task_member_cb tinyint(1) DEFAULT NULL,
scheduling_cb tinyint(1) DEFAULT NULL,
min_job_level int(4) DEFAULT NULL,
max_job_level int(4) DEFAULT NULL,
hr_job_id int(12) DEFAULT NULL,
created_by int(12) NOT NULL,
creation_date datetime(1) DEFAULT NULL,
last_update_by int(12) NOT NULL,
last_update_date datetime DEFAULT NULL,
PRIMARY KEY (prj_role_id),
UNIQUE KEY value_group (role_name)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4
MySQL meldt: Documentatie
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(1) DEFAULT NULL,

last_update_by int(12) NOT NULL,
last_update_date date' at line 17

While creating the Purchase Order I am getting error on Currency. I have entered Doc Currency and Ledger Currencly. Stil i am getting currency error. For support i am attaching the Screen short for same.

What should be the process to handle this issue.
below is the message shows at record saving tme.

Save failed!! error@inosavel line 254
DateTime::__construct(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.
Transaction complete 3

Hi to all,

I am unable to install the InoERP on my localhost through XAMPP, While installation InoERP on my localhost error is showing that C:\xampp\htdocs\inoerp\includes\basics\settings\dbsettings.incFile: : file not writable.

Please help me in this matter

Regards
B4ALLB4U

front end registration time i am passing status value 0 but in db saving default value 1

$new_user->status = 0;

I have following warning before installation:

Warning: set_time_limit() has been disabled for security reasons in /home/vol11_4/byethost11.com/b11_18957543/inoerp.byethost11.com/htdocs/install.php on line 6

And I retrieve following error during install:

Fatal error: Maximum execution time of 20 seconds exceeded in /home/vol11_4/byethost11.com/b11_18957543/inoerp.byethost11.com/htdocs/engine/install/steps/complete_install.php on line 42.

And as I have not permission to modify php.ini to give change default time with set_time_limit(), that is set in 20 second.

Can I solve in some way ?

Thank you in advance

Piercarlo

can I find the Arabic language translation file? how can use it as a deafult
i tried to use it and changed code in basics.inc
defined('DEFAULT_LOCALE') ? null : define('DEFAULT_LOCALE', 'ar_SA');
Please provide me with the details to be able to change localization of the system .
Thank you in advance .

Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in C:\Program Files (x86)\Ampps\www\inoERP\inoerp\includes\general_class\class_ino_session.inc on line 135

basic role user able to update the all users address.please find the attachment

Can this be integrated in Nginx? Can we also have a full documentation how to do the manual installation in nginx? The manual installation flow is quite vague in my own level of understanding.

I am adding payroll data, it's not adding status, period name,and description.

I installed inoERP on my local host. And I register a new user "scott", then I log in as admin. From Admin->User->"Search Users", I input "scott" in Username field, then press Search button. But I got a prompt "Search Failed".
I should see the use "scott", but Failed. Why?

In payroll data are not adding,

This issue not fixing...Your demo server also not working...

Notice: Undefined property: stdClass::$content_color in C:\xampp\htdocs\inoerp\extensions\site_info\class_site_info.inc on line 134

Hello Nishit,

Thanks For the reply , Can you provide me the steps to follow the above. And also can you provide the stesps to create the Group and how to assign that group to the organization and then users to that group.

Thank You

Just installed sucessfully last version of inoERP (0.6.1)

I try to access to the site and I get following errors:

Parse error: syntax error, unexpected 'class' (T_CLASS) in /home/jpghanab/admin.jpghana.biz/extensions/site_info/class_site_info.inc on line 1

Some body can help ?

Thank you

Please make an database backup module in the inoerp. ERP application data grows exponentially by the time. It is very very important to keep a proper database backup. ERP application has many many tables in the database that is why it is important database backup or asynchronous backup module which takes database back silently and elegantly just like your installation module. which makes database backup much more easy and good for production usage of application.

Thanks

HR module Org Id dropdown list not display

why do i can't install inoerp whether using github or directly download in zip..
the error is :

Parse error: syntax error, unexpected '$object' (T_VARIABLE) in C:\xampp\htdocs\inoerp\includes\general_class\trait_dbObject_t.inc on line 1110