101 Reply by seahawk

(7 replies, posted in Banking and General Ledger)

Hi Rafat

It happens on 2.4.9 when you would go Sales => Inquiries and reports => Customer transaction Inquiry or  Banking and General Ledger => Inquiries and Reports => Journal Inquiry. You cannot edit Supplier payments, do not know why not, but all the others that you would edit and then try and save again give the error that the reference number already exists.

Then you change the number to the next number, after that no auto number increase. You now have to go back to Setup => Company Setup => Transaction Reference and change the relevant  Transaction Type Reference number for the auto increase to work again. Maybe some form of change to the Setup to change the auto number +1 on the one that you just changed, for the next number.

I do not know if it might be that in 2.4 the References have changed and I am still using the 2.3 type layout that was converted in 2.4.

PHP 7.4.14 
MySQLi  5.5.5-10.3.27-MariaDB

Hope this will help.

Go to forum: Banking and General Ledger

102 Topic by seahawk

(7 replies, posted in Banking and General Ledger)

HI

when you edit a bank payment, it indicated that the reference number of the edited entry already exists. After that, the auto increase in the reference number does not work.

When you manually change the number to the next available number, the system does not auto increase that number after that.

One has to go back to the "Setup/Reference Numbers"  and change it there to increase again.

Next time, you edit another bank payment, the same problem oocur.

Kind regards

Go to forum: Banking and General Ledger

103 Reply by seahawk

(9 replies, posted in Report Bugs here)

boxygen wrote:

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.

The suggested solution for line 399 worked. Will report if I find another issue as a result.

Go to forum: Report Bugs here

104 Reply by seahawk

(9 replies, posted in Report Bugs here)

I also experience this issue where I had to do a journal entry to fix the Debtors control account and outstanding balances. Now because there is an unallocated journal entry, I cannot process the Allocate Customer Payment nor add Customer payment nor Bank Deposit.  When I process nothing happens. This means that the client account is stuck, but the debtor's control account balances is now correct.

How do we fix this issue?

Go to forum: Report Bugs here

105 Reply by seahawk

(11 replies, posted in Accounts Payable)

I, I see this has been an issue for quite some time. The only way to fix this is to go into databse but that can get messy. Another option is to Void the transaction and redo the transaction.

It would be nice if the supplier payment can be edited, since it happens that you pays from Cash instead of from bank.  The same would be if you made a wrong partial payment and want to correct it.

Even through the journall enquiry, it is not possible to edit the transaction.

Go to forum: Accounts Payable

106 Reply by seahawk

(4 replies, posted in Misc. Charts of Accounts)

What happened to the existing CoA for South Africa.

It seems that with 2.4.8 it is now the standard American chart of accounts?

With 2.3 there was an elaborate chart of accounts.

Go to forum: Misc. Charts of Accounts

107 Reply by seahawk

(114 replies, posted in Reporting)

HI all

Have not been part of the discussion for a while.

The changes from @Braath Waate worked within the 3.4.7 but it seems to be broken in 3.4.8 again. Not pulling the VAT from GL Bank payments and receipts, nor Journal corrections.

Is anybody else experiencing the problem again?

Go to forum: Reporting

108 Reply by seahawk

(8 replies, posted in Report Bugs here)

I have tried to get it to work but without any success.

Setup menu does not display at all, I could activate the setup in Install/Activate extensions and allocated it to the company Activated section, but nothing show in the setup tab.

I was told to try the following by the hosting provider in the php ini file:
sendmail_path = /usr/sbin/sendmail -t -i -f 'email@mydomain.coza'

I do not know if this will work however?

Go to forum: Report Bugs here

109 Reply by seahawk

(8 replies, posted in Report Bugs here)

Hi all

I am sitting with the same issue on the new VPS that I moved to.

On the shared server the normal email functions was fine most of the time, but on the VPS the "from"  line use to read: myemail@mycompanydomain.coza

On the VPS it is the same exept it has the "cpanelname@servername.coza on behalf of Compny name <myemail@mycompanydomain.coza>

According to the hosting provider, the VPS does not have cloud linux installed, since it costs extra, where shred server have this isntalled, and thus the reason for the above problem.

I have now trying to install https://github.com/serbanconstantinescu/fa_mail_phpmailer and will see what it does.

I have been using PHPlist (Mailing list) for a long time and they have implemented and option to use the normal php's mail() function or you could change the smtp settings in the config file using phpmailer6 , maybe you could have a look at it.

My deliverability is better with the smtp function through my mail server.

Will see if the serban idea will work and report back

Go to forum: Report Bugs here

110 Topic by seahawk

(2 replies, posted in Report Bugs here)

Hi

when you do a Supplier Inquiry the Purchase Order Delivery is showing for all years and not just the auto period selected. This means that your first page could be just full of old Purchase Order Delivery items.

Will appreciate if this could be fixed.

Go to forum: Report Bugs here

111 Reply by seahawk

(10 replies, posted in Setup)

Hi @apmuthu

On the new version the en_ZA chart of accounts and the en_za language does not display the Tax Invoice on the invoice when printed?

Did the language setup change, or how can I fix this in a new installation of 2.4.7 en_ZA.

Regards

Go to forum: Setup

112 Reply by seahawk

(3 replies, posted in Reporting)

Thanks @braath Waate.

It works well.

Go to forum: Reporting

113 Topic by seahawk

(3 replies, posted in Reporting)

When doing report - General Journal Reports / List of Journal Entries / Select Type: Tax Invoice, does not display the customer / person name only the memo. If there is nothing in memo, the field is blank.

Go to forum: Reporting

114 Reply by seahawk

(9 replies, posted in FA Modifications)

Thanks poncho tested and it works.

Go to forum: FA Modifications

115 Reply by seahawk

(15 replies, posted in Report Bugs here)

Thanks guys, its works.

Go to forum: Report Bugs here

116 Reply by seahawk

(15 replies, posted in Report Bugs here)

Thanks Joe and Braath. Have downloaded it. Will check later, but I think we nailed it now.

Go to forum: Report Bugs here

117 Reply by seahawk

(15 replies, posted in Report Bugs here)

Why is the _7 missing in the sting for emailing recurring invoices?

Where would this be coded?

Go to forum: Report Bugs here

118 Reply by seahawk

(15 replies, posted in Report Bugs here)

Yes, for some or other reason I had it the wrong way around:

On the one system I have FA 2.4.4  with PHP Version 7.1 and the other system I have FA 2.4.6 and PHPversion 7.1 Both have the same issue not sending email on recurring invoices.

Normal email tax invoice is the one:

/reporting/prn_redirect.php?PARAM_0=272-10&PARAM_1=272-10&PARAM_2=&PARAM_3=1&PARAM_4=&PARAM_5=&PARAM_6=&PARAM_7=0&REP_ID=107

The one without the _7 is then recurring invoice email.

Go to forum: Report Bugs here

119 Reply by seahawk

(15 replies, posted in Report Bugs here)

Braath

On the Direct Invoice creation email option it has the following for email function:

/reporting/prn_redirect.php?PARAM_0=1045-10&PARAM_1=1045-10&PARAM_2=&PARAM_3=1&PARAM_4=0&PARAM_5=&PARAM_6=1&REP_ID=107

On recurrent invoices the email option have the following:

/reporting/prn_redirect.php?PARAM_0=1045-10&PARAM_1=1045-10&PARAM_2=&PARAM_3=1&PARAM_4=&PARAM_5=&PARAM_6=&PARAM_7=0&REP_ID=107

It seems like the difference is that the recuurent invoice has a _7=0&REP_ID=107 whereas the Direct invoice email function have _6=1&REP_ID=107

Maybe you can figure out the difference, but I think the recurrent invoice email option should not have the _7, since the print function does not have a _7

Trust this will help to resolve the issue?

Wynand

Go to forum: Report Bugs here

120 Topic by seahawk

(1 replies, posted in FA Modifications)

With the new IFRIS standards and company compliance in Europe, RSA etc is becoming requirements to submit annual reports in the XBRL language, seems like Excel format report.

XBRL (eXtensible Business Reporting Language) is a freely available and global framework for exchanging business information. XBRL allows the expression of semantic meaning commonly required in business reporting. ... XBRL is a standards-based way to communicate and exchange business information between business systems.

Is there any indication if FA will implement this to comply with the XBRL standards?

Regards

Go to forum: FA Modifications

121 Reply by seahawk

(2 replies, posted in Accounts Receivable)

Thanks for that. appreciated

Go to forum: Accounts Receivable

122 Reply by seahawk

(2 replies, posted in Report Bugs here)

Thanks Rafat.

In 2.3 it was below the General Notes on the righthand side, once the branch has been opened.

Function is now displayed in a different way.

Go to forum: Report Bugs here

123 Reply by seahawk

(15 replies, posted in Report Bugs here)

Braath, Thanks for the feedback.

They both point to REP_ID=107

You can email it from sales reports, and you can mail it from Template invoices but not from Recurring invoices. Normally it would display a green bar that the email was successfull, but it does not do anything.


One change in 2.4 is more flexible reference numbers.  Perhaps PARAM_0 or PARAM_1 have some unsupported special characters?

Surely it would use the same PARAM is the email function is used either via Sales Reports, or after editing the invoice via Transaction Inquiry?

2. The next step then would be to instrument these pages to see where the call is being dropped

Have no idea what you are talking about here.

3.  Look to see if the email is being sent out of your system.

There is nothing. not send, no record.

Go to forum: Report Bugs here

124 Topic by seahawk

(2 replies, posted in Accounts Receivable)

Hi, we used to have a line where the customer would sign that they received the delivery.

What happened to that line, and how can we get that back?

Go to forum: Accounts Receivable

125 Topic by seahawk

(2 replies, posted in Report Bugs here)

One customer three branches. One branch close down.

I cannot see a selection to disable the branch. You cannot delete the branch since it has transactions.

Please advise if this is deliberate or just an oversight.  2.3.26 had a selection to disable the branch.

I had to login via the cpanel PHPmyadmin and set branch from 0 to 1 in the database table.

Go to forum: Report Bugs here