101

(1 replies, posted in FA Modifications)

That needs customization in sales_order_entry.php

check this post https://frontaccounting.com/punbb/viewtopic.php?id=7652

I am unable to void a PaySlip. Is there any way or I am missing something. PaySlip Creates a Journal Entry that can be voided but the PaySlip itself can't be voided.

I have a comment. I defined the Salary Structure for Each Employee. That sturcuture has a Basic Salary, Conveyance amount, House Allowance etc.

While calculating the Payslip the employee had 62 Leave hours.

The system is deducting the amount against these leave hours on whole amount. But it should be only applied to Basic Salary Amount.

Here is the Screen Shot.

My point is am I correct or system is correct?

@minmaxfamily please open debug mode and then share the screen shot

As I said earlier its the accountants way to handle this. No predefined formula. Yes you may provided you can justify it.

This is a pure accounting adjustment and every accountant has his own taste.
What I do is that I have created an account named "Openging Balance" in Owners Equity Group.

After adding all entries of Assets and Liabilities either in Debit or Credit I put the the Balancing Figure in the above account.

@trainer2008, you can use modules hooks.php to call the module's sales_order_entry.php instead of core file from the Navigation of your theme.

Here is the little snippet of the code

function install_options($app) {
        global $path_to_root;

        switch($app->id) {
            case 'orders':
                $app->modules[0]->lappfunctions[3] = new app_function(_('Water In&voice'),'modules/water_invoice/sales_order_entry.php?NewInvoice=0','SA_OPEN',MENU_TRANSACTION);
                $app->modules[1]->lappfunctions[2] = new app_function(_('Customer Transaction Inquiry'),'modules/water_invoice/inquiry/customer_inquiry.php?','SA_OPEN',MENU_INQUIRY);
                $app->modules[2]->lappfunctions[0] = new app_function(_('Add and Manage Customers'),'modules/water_invoice/customers.php?','SA_OPEN',MENU_ENTRY);

Hello @ccmacachor, I am working as a FA consultant for more than 70 clients in my country. I have my own server and slightly modified FA version to fit in the needs of my clients. If you need my support please contact me via Forum Email.

@siddiquinoor I have that extension that may need some modifications to fit in your needs. Please Contact me via Forum Email

111

(3 replies, posted in Reporting)

You can change FontSize at Line # 64

    $rep = new FrontReport(_('List of Journal Entries'), "JournalEntries", user_pagesize(), 8, $orientation);

in config.php set

$go_debug = 2;

Set the debug mode to On and then try again and see the error logs. Share those Logs here.

114

(82 replies, posted in FA Modifications)

Great @joe, does this covers the custom dashboards through modules?

@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?

116

(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.

@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.

118

(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.

Finally the above bug is fixed and and committed Here

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.

This is a great honor for me. Thanks

I am getting this error in Print Payslip

https://prnt.sc/tsnpkh

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.

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

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?