101 Topic by boxygen

(1 replies, posted in Wish List)

How to re-open Closed work order.

Work order closed by mistake. There is any way to reopen this

Go to forum: Wish List

102 Reply by boxygen

(4 replies, posted in Banking and General Ledger)

Thanks a lot for this detailed information.

Go to forum: Banking and General Ledger

103 Topic by boxygen

(4 replies, posted in Banking and General Ledger)

Dear all UAE members here specially @rafat,

Can you please explain the FTA requirements by UAE authorities for any accounting solution? Is there any defined report/format?

Does FA fulfil those requirements or we need to do some modifications?

Go to forum: Banking and General Ledger

104 Reply by boxygen

(8 replies, posted in Setup)

said.omn wrote:

Thank you for your reply

In fact, I don't have a problem with working on the database, I have good experience but I need the database relationship diagram to find out the related tables, in order to change the Item Code using SQL statement.

I think the database designer should have added an independent indexed field for the barcode where it's not a primary key, this way it will be easy even to change the item barcode without effecting the whole table or other tables in the database.

Good Suggestion

Go to forum: Setup

105 Reply by boxygen

(9 replies, posted in Report Bugs here)

The similar handling needs to be done for Supplier Transactions Allocation at Line # 410

                $trans = get_supp_trans($_SESSION['alloc']->allocs[$counter]->type_no, $_SESSION['alloc']->allocs[$counter]->type, $_SESSION['alloc']->person_id);

I suggest to commit the core for this.

Go to forum: Report Bugs here

106 Reply by boxygen

(1 replies, posted in Installation)

Ok, I found the problem. Server Locales were not updated.

I found this thread useful https://serverfault.com/questions/54591 … -on-debian

Go to forum: Installation

107 Topic by boxygen

(1 replies, posted in Installation)

Hello I am facing difficulty in Installing Languages in latest repo of FA2.4.9.

Below is the error message.

click here

Go to forum: Installation

108 Topic by boxygen

(9 replies, posted in Report Bugs here)

The bug I am going to detail here needs a scenario.

Using on Journal Entry I recorded the Opening Balances of all customers.
Upon recording payment for one out of those customers I encountered following error.

/PATH-TO-FA/includes/errors.inc:207:    trigger_error('DATABASE ERROR : duplicate debtor transactions found for given params
sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, trans.prep_amount>0 as prepaid,com.memo_, branch.* FROM debtor_trans trans LEFT JOIN comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN shippers ON shippers.shipper_id=trans.ship_via, debtors_master cust, cust_branch branch WHERE trans.trans_no='96' AND trans.type='0' AND trans.debtor_no=cust.debtor_no AND branch.branch_code = trans.branch_code


','256')
/PATH-TO-FA/sales/includes/db/cust_trans_db.inc:214:    display_db_error('duplicate debtor transactions found for given params','SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, trans.prep_amount>0 as prepaid,com.memo_, branch.* FROM &TB_PREF&debtor_trans trans LEFT JOIN &TB_PREF&comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN &TB_PREF&shippers ON &TB_PREF&shippers.shipper_id=trans.ship_via, &TB_PREF&debtors_master cust, &TB_PREF&cust_branch branch WHERE trans.trans_no='96' AND trans.type='0' AND trans.debtor_no=cust.debtor_no AND branch.branch_code = trans.branch_code ','1')
/PATH-TO-FA/includes/ui/allocation_cart.inc:381:    get_customer_trans('96','0')
/PATH-TO-FA/sales/customer_payments.php:222:    check_allocations()
/PATH-TO-FA/sales/customer_payments.php:236:    can_process()

The reason for this bug is that multiple customer payments are recorded for One Transaction Number and Same Transaction Type.

I found the solution to this is to add 3rd argument in function call get_customer_trans() in /includes/ui/allocation_cart.inc as below on Line#399

                $trans = get_customer_trans($_SESSION['alloc']->allocs[$counter]->type_no, $_SESSION['alloc']->allocs[$counter]->type, $_SESSION['alloc']->person_id);

I hope this shall not cause any other bug.

Go to forum: Report Bugs here

109 Reply by boxygen

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

I have a sms plugin for FA. You can send forum email to me if needed .

Go to forum: Modules Add-on's

110 Topic by boxygen

(1 replies, posted in Report Bugs here)

in purchasing_db.inc on line # 200 the 10th argument true is extra I think

Go to forum: Report Bugs here

111 Reply by boxygen

(1 replies, posted in FA Modifications)

That needs customization in sales_order_entry.php

Go to forum: FA Modifications

112 Reply by boxygen

(2 replies, posted in Accounts Payable)

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

Go to forum: Accounts Payable

113 Reply by boxygen

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

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.

Go to forum: Modules Add-on's

114 Reply by boxygen

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

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?

Go to forum: Modules Add-on's

115 Reply by boxygen

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

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

Go to forum: Modules Add-on's

116 Reply by boxygen

(5 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

117 Reply by boxygen

(5 replies, posted in Banking and General Ledger)

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.

Go to forum: Banking and General Ledger

118 Reply by boxygen

(7 replies, posted in FA Modifications)

@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);

Go to forum: FA Modifications

119 Reply by boxygen

(3 replies, posted in Jobs wanted/offered, non-free offers)

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.

Go to forum: Jobs wanted/offered, non-free offers

120 Reply by boxygen

(4 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

121 Reply by boxygen

(3 replies, posted in Reporting)

You can change FontSize at Line # 64

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

Go to forum: Reporting

122 Reply by boxygen

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

in config.php set

$go_debug = 2;

Go to forum: Modules Add-on's

123 Reply by boxygen

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

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

Go to forum: Modules Add-on's

124 Reply by boxygen

(82 replies, posted in FA Modifications)

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

Go to forum: FA Modifications

125 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