126 Reply by boxygen

(216 replies, posted in Modules Add-on's)

@notrinos, the Employee Transaction Inquiry has a bug. Once you Select any one Employee, the Transactions related to Employee Advance is not shown. I tried a lot of ways but in vain. The SQL Query is too complex

Can anyone help out in this?

Go to forum: Modules Add-on's

127 Reply by boxygen

(13 replies, posted in Setup)

Thats not possible currently in FA. you may need some modifications to achieve this but not recommended because it will hit the current $_SESSION settings.

Go to forum: Setup

128 Reply by boxygen

(4 replies, posted in Banking and General Ledger)

@jcnew the Closing Journal Entries are not done automatically. You need to close your Profit and Loss Accounts manually to shift them to Retained Earnings.

When you close a Fiscal Year then FA ensures that all previous fiscal years are also closed.

Closing a Fiscal Year also sets the sys_pref variable gl_closing_date to the Fiscal Year's ending date.

But if you want to set the 'gl_closing_date' during the fiscal year i.e. after one quarter you can use Closing GL Transactions page for this purpose to restrict gl transactions before that date.

Go to forum: Banking and General Ledger

129 Reply by boxygen

(13 replies, posted in Setup)

In Multiple Companies add same user say admin and same password say bangladesh

Now on login screen you just need to select the company from Drop Down.

Go to forum: Setup

130 Reply by boxygen

(216 replies, posted in Modules Add-on's)

Finally the above bug is fixed and and committed Here

Go to forum: Modules Add-on's

131 Reply by boxygen

(216 replies, posted in Modules Add-on's)

Ok I got the reason for the issue mentioned in Post # 174.

The function in_ajax() is returning false in pdf_report.inc in function End() that is why $Ajax->redirect($fname) is not being called.

I added on emp_inquiry.php below code to activate Ajax.

$Ajax->activate('trans_tbl');

$sql = get_sql_for_payslips(get_post('Ref'), get_post('Memo'), get_post('FromDate'), get_post('ToDate'), get_post('DeptId'), get_post('EmpId'), check_value('OnlyUnpaid'));

but it didn't worked.

Any clue how to activate Ajax on this page.

Go to forum: Modules Add-on's

132 Reply by boxygen

(216 replies, posted in Modules Add-on's)

This is a great honor for me. Thanks

Go to forum: Modules Add-on's

133 Reply by boxygen

(216 replies, posted in Modules Add-on's)

I am getting this error in Print Payslip

https://prnt.sc/tsnpkh

Go to forum: Modules Add-on's

134 Reply by boxygen

(216 replies, posted in Modules Add-on's)

I have a suggestion.

In the function generate_gl_items() in payslip_ui.inc we have some calculations based on $salary_amount/$Work_days.

We shall enclosed such calculations with round(X, 2) function. Otherwise it is likely to have the error 

        display_error(_('The journal must balance (debits equal to credits) before it can be processed.'));

I got this error and fixed by applying round function.

Go to forum: Modules Add-on's

135 Reply by boxygen

(216 replies, posted in Modules Add-on's)

Ok, I got the reason. The word leave is a SQL keyword. I am getting error because I am using Child Companies without TB_PREF. Since this is an option in FA so its better to change the name of table leave to may be leave_details

Go to forum: Modules Add-on's

136 Reply by boxygen

(216 replies, posted in Modules Add-on's)

One more issue at attendance_db.inc at Line 34.

I just changed the table name to leave1 and it worked. It seems that word leave have some reserved rights in sql.

I don't know why I am facing these bugs because I am using this FrontHrm very late and not expecting such bugs.

Or is it due to the PHP version issue. Mine is 7.2

Any comment?

Go to forum: Modules Add-on's

137 Reply by boxygen

(216 replies, posted in Modules Add-on's)

Hello, I found a bug in Insert Statement of Job Position.

Fix at /includes/db/job_position_db.inc at Line 30

        $sql = "INSERT INTO ".TB_PREF."position (position_name, pay_basis) VALUES (".db_escape($name).",".db_escape($pay_basis).")";

Just given a whitespace after position

Go to forum: Modules Add-on's

138 Reply by boxygen

(35 replies, posted in Banking and General Ledger)

It worked bro!!

Go to forum: Banking and General Ledger

139 Reply by boxygen

(35 replies, posted in Banking and General Ledger)

Hello, Today I was just checking and found that in Journal Inquiry 2.4.8 the Counter Party column is not showing the Customer Name for Sales Invoices.

Here is the Screen Shot


https://prnt.sc/trl5mj

Similarly for Supplier Invoices it is showing for some invoices and not for all. What could be the reason.

https://prnt.sc/trl9yi

Go to forum: Banking and General Ledger

140 Reply by boxygen

(4 replies, posted in Report Bugs here)

@BraathWate it worked. Thanks

Go to forum: Report Bugs here

141 Topic by boxygen

(4 replies, posted in Report Bugs here)

When I tried to Edit Credit Note of Supplier in FA 2.4.8 I faced following bug. My PHP is 7.4

Trying to get property 'Comments' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 16
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'tran_date' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 17
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'due_date' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 18
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'supp_reference' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 19
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'reference' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 20
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'supplier_id' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 21
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'dimension' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 22
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'dimension2' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 23
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'ex_rate' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 25
/home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc:80:    copy_from_trans('')
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'trans_type' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 86
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'trans_no' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 97
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Trying to get property 'supplier_id' of non-object in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 104
/home/pakerp/web/core.pakerp.net/public_html/purchasing/supplier_credit.php:348:    invoice_header('')
Unhandled exception [0]: Call to a member function clear_items() on null. in file: /home/pakerp/web/core.pakerp.net/public_html/purchasing/includes/ui/invoice_ui.inc at line 109
exception_handler((Error Object))

I don't think its a PHP related bug. The Session Variable is not instantiated.

Here is the Screen shot https://prnt.sc/tqcosv

Go to forum: Report Bugs here

142 Topic by boxygen

(0 replies, posted in Items and Inventory)

Hello Every one,

As per the image below

https://prnt.sc/temb2l

Currently the System is converting the price to our UOM w.r.t the factor.

In my opinion it should show the Suppliers UOM on Supplier Invoice and Price should be as defined in Item Setup.

When the Invoice is Processed this converts to our UOM at the Back End.

This is quite confusing for the Purchase Officer.

He shall be inputting Data based on the Invoice received from Supplier.

Now Supplier has given his Invoice for Cartons but System is converting Cartons into Bottles without entering any data.

If System takes input as per the Suppliers Invoice and does the Conversion at Backend to update our Inventory as per our UOM then it will be much better.

If @joe and @Jansuz agree to this then I can try to do this coding.

Regards.

Go to forum: Items and Inventory

143 Reply by boxygen

(20 replies, posted in Report Bugs here)

Array and string offset access syntax with curly braces is deprecated in file: ...../reporting/includes/tcpdf.php at line 9305

Go to forum: Report Bugs here

144 Reply by boxygen

(6 replies, posted in Manufactoring)

email sent. check and reply via email

Go to forum: Manufactoring

145 Reply by boxygen

(6 replies, posted in Manufactoring)

Oh yes sending you demo via forum email

Go to forum: Manufactoring

146 Reply by boxygen

(82 replies, posted in FA Modifications)

@samsa in this theme you have included the idea of @notrinos? To have dashboard modularized?

Go to forum: FA Modifications

147 Reply by boxygen

(82 replies, posted in FA Modifications)

Once you become Senior Member you will be granted that privilege automatically. That requires a good number of posts in the forum smile

Go to forum: FA Modifications

148 Reply by boxygen

(82 replies, posted in FA Modifications)

you can upload the screen shot to imgur.com and share the link here

Go to forum: FA Modifications

149 Reply by boxygen

(6 replies, posted in Banking and General Ledger)

I have written a module for Cash Transactions. This creates a new Transaction Type Cash Payment and Cash Deposit.

I don't remember if for this I made some core changes. Just give a try. May be this solves your problem.

Go to forum: Banking and General Ledger

150 Reply by boxygen

(7 replies, posted in Accounts Receivable)

Fix is here.

Change the lines of the function get_sql_for_sales_order_view() as follows

function get_sql_for_sales_orders_view($trans_type, $trans_no, $filter,
    $stock_item='', $from='', $to='', $ref='', $location=ALL_TEXT, $customer_id=ALL_TEXT)
{

    if ($filter=='OutstandingOnly')
        $order_value = 'Sum(line.unit_price*(line.quantity-line.qty_sent)*(1-line.discount_percent))+freight_cost AS OrderValue,';
    else
        $order_value = 'Sum(line.unit_price*line.quantity*(1-line.discount_percent))+freight_cost AS OrderValue,';

    $sql = "SELECT
            sorder.order_no,
            sorder.reference,
            debtor.name,
            branch.br_name,"
            .($filter=='InvoiceTemplates'
                || $filter=='DeliveryTemplates' ?
             "sorder.comments, " : "sorder.customer_ref, ")
            ."sorder.ord_date,
            sorder.delivery_date,
            sorder.deliver_to,
            $order_value
            sorder.type,
            debtor.curr_code,
            Sum(line.qty_sent) AS TotDelivered,
            Sum(line.quantity) AS TotQuantity,
            Sum(line.invoiced) AS TotInvoiced,
            alloc,
            prep_amount,
            allocs.ord_payments,
            inv.inv_payments,
            sorder.total,
            sorder.trans_type

Go to forum: Accounts Receivable