It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by boxygen
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?
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
It worked bro!!
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.
@BraathWate it worked. Thanks
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
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.
Array and string offset access syntax with curly braces is deprecated in file: ...../reporting/includes/tcpdf.php at line 9305
email sent. check and reply via email
Oh yes sending you demo via forum email
@samsa in this theme you have included the idea of @notrinos? To have dashboard modularized?
Once you become Senior Member you will be granted that privilege automatically. That requires a good number of posts in the forum 
you can upload the screen shot to imgur.com and share the link here
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.
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_typeNo, 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.
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.
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
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
@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.
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.
can u provide a sample template to test?
hello I am travelling now so couldn't check earlier. I will send you the demo soon once reached.
FrontAccounting forum → Posts by boxygen
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.