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
151 08/02/2020 09:30:43 am
Re: Payroll & Human Resource Management. (216 replies, posted in Modules Add-on's)
152 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?
153 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
154 08/01/2020 02:56:43 pm
Re: Journal Inquiry Dates (35 replies, posted in Banking and General Ledger)
It worked bro!!
155 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.
156 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
157 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
158 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.
159 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
160 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
161 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
162 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?
163 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 
164 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
165 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.
166 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_type167 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.
168 06/10/2020 12:14:48 pm
Topic: Sales Order Inquiry -- Wrong Figure (7 replies, posted in Accounts Receivable)
When we check the Delivery Against Sales Order Inquiry View, it shows the Order Total Value for the Value of the order that is still not delivered. But there is still an anomaly there.
In the attached image you can find that there was big order and all delivered except for one item.
That items total value in the order is 108,000.
Undelivered is 5 out of 6.
The inquiry page shall show the amount 90,000 but it is showing 108,000.
If this is a bug then need a fix. Or if I am mis interpreting it then please let me know.
169 05/13/2020 10:35:21 am
Topic: [Solved] Line Endings Issue (1 replies, posted in Development)
Dear All,
My last two days were too hectic. My FA was not exporting the reports in Excel Properly. No Error was shown. I was unable to locate the issue. I had one month old backup that has no issue. I compared both and found an issue that one of latest module's hooks.php file was not having LF line endings.
I found this Swiss File Knife Tool helpful to check in bulk and convert the whole projects Line Endings to LF.
Since I am using Linux server so I needed LF.
This Post is also helpful https://stackoverflow.com/a/16886243
Once installed the above tool. Open the Project Directory in Command Prompt and write the below command
> sfk remcr -dir your_project_directory -yes
170 05/10/2020 08:59:48 pm
Topic: PHP 7.4 bug (20 replies, posted in Report Bugs here)
Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in file: gl/includes/db/gl_db_trans.inc at line 464
171 04/21/2020 06:51:38 am
Re: Interest in Magento Integration or Shopify Integration (5 replies, posted in Modules Add-on's)
@bkort, yes you can sell it commercially. Since FA has no marketplace so you make a free version and then paid version. Free users can then migrate to paid one.
Free version can then be made available at FA forum.
Can you do the same for WooCommerce? I have few clients who may be interested in that.
172 04/17/2020 06:32:42 pm
Topic: Edit Multiple Bank Payments in Multiple Tabs (0 replies, posted in Banking and General Ledger)
I just want to give a bundle of thanks to @BraathWate for his work in this commit that has solved a great problem for me.
Hats off for you @Braath.
173 03/22/2020 10:46:16 am
Re: The Header option from module itself (19 replies, posted in Modules Add-on's)
can u provide a sample template to test?
174 03/22/2020 10:37:15 am
Re: Added Functionality to Manufacture Multiple Products with One WO (6 replies, posted in Manufactoring)
hello I am travelling now so couldn't check earlier. I will send you the demo soon once reached.
175 02/24/2020 06:50:04 pm
Re: Data Migration from Another Accounting Software (6 replies, posted in Jobs wanted/offered, non-free offers)
This is the modified import_items that takes care of opening stock.