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.
127 08/06/2020 02:36:39 am
Re: Clarification on Fiscal Year and Closing GL Transactions (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.
128 08/06/2020 02:15:44 am
Re: Multiple company access (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.
129 08/04/2020 06:34:07 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
Finally the above bug is fixed and and committed Here
130 08/04/2020 11:57:25 am
Re: Payroll & Human Resource Management. (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.
131 08/02/2020 05:51:50 pm
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
This is a great honor for me. Thanks
132 08/02/2020 11:57:11 am
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
I am getting this error in Print Payslip
133 08/02/2020 11:56:04 am
Re: Payroll & Human Resource Management. (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.
134 08/02/2020 09:30:43 am
Re: Payroll & Human Resource Management. (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
135 08/02/2020 08:02:25 am
Re: Payroll & Human Resource Management. (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?
136 08/02/2020 07:13:26 am
Re: Payroll & Human Resource Management. (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
137 08/01/2020 02:56:43 pm
Re: Journal Inquiry Dates (35 replies, posted in Banking and General Ledger)
It worked bro!!
138 07/31/2020 06:27:01 am
Re: Journal Inquiry Dates (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
Similarly for Supplier Invoices it is showing for some invoices and not for all. What could be the reason.
139 07/29/2020 01:15:32 pm
Re: Bug in Supplier Credit Note Edit (4 replies, posted in Report Bugs here)
@BraathWate it worked. Thanks
140 07/29/2020 07:19:16 am
Topic: Bug in Supplier Credit Note Edit (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
141 07/09/2020 09:46:07 am
Topic: Suppliers UOM in Direct Supplier Invoice (0 replies, posted in Items and Inventory)
Hello Every one,
As per the image below
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.
142 07/04/2020 03:22:46 am
Re: PHP 7.4 bug (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
143 06/25/2020 09:33:56 am
Re: Added Functionality to Manufacture Multiple Products with One WO (6 replies, posted in Manufactoring)
email sent. check and reply via email
144 06/24/2020 12:59:11 pm
Re: Added Functionality to Manufacture Multiple Products with One WO (6 replies, posted in Manufactoring)
Oh yes sending you demo via forum email
145 06/19/2020 11:41:27 am
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
@samsa in this theme you have included the idea of @notrinos? To have dashboard modularized?
146 06/18/2020 11:51:22 am
Re: Modularizing the Dashboard (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 
147 06/16/2020 06:19:37 pm
Re: Modularizing the Dashboard (82 replies, posted in FA Modifications)
you can upload the screen shot to imgur.com and share the link here
148 06/14/2020 02:57:54 am
Re: How to Add Petty Cash Account in the DropDown Payment/Deposit process (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.
149 06/12/2020 11:26:12 am
Re: Sales Order Inquiry -- Wrong Figure (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_type150 06/11/2020 07:18:15 am
Re: Sales Order Inquiry -- Wrong Figure (7 replies, posted in Accounts Receivable)
No, If we go through Menu Sales Order Inquiry then it shows Order Total.
But if we go through Menu Delivery Against Sales Order then it is supposed to show the Total of Outstanding.
In the above case I mentioned Delivery Against Sales Order is not showing the Total of Outstanding correctly.
The Order was big and all items are fully delivered except for one that I highlighted.
The system shall show the Total Outstanding as 90,000 (5 * 18000) but it is showing 108,000 (6 * 18,000).
Regards.