76 Reply by seahawk

(17 replies, posted in Setup)

PHP 8 on 2.4.12 Invoice printing and email issue. The invoice does not want to print or email.

It shows that it was emailed, but it is never received.

On print, it just hangs.

When I revert back to PHP7.4 it prints and email.

Please advise.

Go to forum: Setup

77 Reply by seahawk

(3 replies, posted in Wish List)

Why is the English Wiki now displaying different languages?

Go to forum: Wish List

78 Reply by seahawk

(21 replies, posted in Reporting)

https://frontaccounting.com/punbb/viewtopic.php?id=7252&p=5
Have this been fixed or will this only be implemented in 2.5?

Go to forum: Reporting

79 Reply by seahawk

(21 replies, posted in Reporting)

joe wrote:

This has been fixed and committed to stable repo.

A fixed file can be downloaded on Mantis.

Thanks for  reporting this smile

Joe

In the latest update in 2.4.11 the same bug appears again. I have now downloaded this from the old issue that was fixed from Mantis.

This does not resolve the issue. It was resolved once in one of the previous versions. Maybe it is in another post.

Go to forum: Reporting

80 Reply by seahawk

(11 replies, posted in Reporting)

Thank @advocate. This topic was started before the other one and there was no response. So I did not search for others.

Thanks, Joe. It seems that it is solving the problem.

Go to forum: Reporting

81 Reply by seahawk

(11 replies, posted in Reporting)

I have checked now on a new installation of 2.4.11 and the problem with the Invoicing is still the same.

The Quotation now problem, the order, no problem, the delivery note, no problem. The problem is only on the Invoice?

The Invoice number displays correctly in the browser when you have completed the transaction and the email confirmation that the email was sent.

In the email header received by the client and the copy to admin, it shows Invoice 0 (instead of the invoice number). This must b a problem with $subject since the problem does not occur with Quotation nor, delivery or orders only with Invoice.

Please advise what to check?

Go to forum: Reporting

82 Reply by seahawk

(11 replies, posted in Reporting)

No, I have upgraded from 2.4.09. 

What is the new format?

My format is what it normally was as indicated above IN0012354. What must change to resolve this?

Go to forum: Reporting

83 Reply by seahawk

(9 replies, posted in Accounts Payable)

Followed the process above. Now get this when you want to void the delivery after voiding the Purchase invoice.:

The void cannot be processed because there is an insufficient quantity for item.

Go to forum: Accounts Payable

84 Reply by seahawk

(6 replies, posted in Announcements)

Well done. You deserve that.

Go to forum: Announcements

85 Reply by seahawk

(11 replies, posted in Reporting)

Hi Apmuthu

I just upgraded to the new version from the previous version. In the previous version, it would add the Invoice number. After the upgrade, it no longer adds the Invoice number just puts a zero.

It is not just recurring but all invoices, even the new direct invoices that now have "Invoice 0" (this should be the invoice number for example IN0012354) )  from "My Company Name" (which is correct).

Why is it now not picking up the invoice number in the email heading and the email body?

The Invoice number on the PDF attachment is correct. The email also does not enter the client name it just states "Dear," (No client name). Previously it would read "Dear Wynand,"

Go to forum: Reporting

86 Topic by seahawk

(11 replies, posted in Reporting)

When you email a recurring invoice or new invoice created it shows in the email heading the following:

Invoice 0 from Mycompany

In the content it reads:

Dear,

Attached you will find  Invoice 0 from MyCompany.

Before the upgrade, it displayed the actual invoice number. After the up[grade the above is displayed.

Go to forum: Reporting

87 Topic by seahawk

(1 replies, posted in Installation)

HI

After updating my current site, template "Blue Collar" is no longer displaying the summaries for the clients, outstanding invoices etc on the different tabs. Thought it was a php8 issue, but it makes no difference since I have only changed the PHP after the update was completed.

I have then changed to Canvas which is working. On canvas what must be activated in the Access setup on the accountant profile to be able to view the dashboard?

Go to forum: Installation

88 Reply by seahawk

(21 replies, posted in Reporting)

rafat wrote:

@seahawk

One thing for sure..stock FA 2.4.x does not support Tax on Bank Payments, deposits..etc..

The question is why not, since in RSA the banks charge VAT on all their baning transaction fees and account fees. There is no other way that these VAT can be incorporated into the TAX Report since it is only displayed on your bank statement. No separate VAT invoice is issued by the bank.

I can understand that it is not all banking transactions, but when you create a quick entry with VAT inclusive for bank cost and account fees, all of that is automated. Just enter the amount.

Any other transaction that happens once-off, who is not a customer or supplier will be handled the same way, although you have an invoice as proof.

Go to forum: Reporting

89 Reply by seahawk

(11 replies, posted in Banking and General Ledger)

Hi Joe,

I am on 2.4.9 and I do not see this selection on the trial balance report. Why would that be?

(Do not worry, found it on the drill-down, not the report.) Thanks

Go to forum: Banking and General Ledger

90 Reply by seahawk

(21 replies, posted in Reporting)

It seems that this bug has now reared its head again with the last update for report 709. TAX Report. The new one is not incorporating the VAT on bank costs from the bank accounts payment. Reverted back to the previous version of 2.3.25 report.

Go to forum: Reporting

91 Reply by seahawk

(4 replies, posted in Fixed Assets)

I have been watching this module developed over a number of years. I have not used it to date, since I do the records for these assets in a macro excel spreadsheet with all the individual assets, classes, venues etc. and just enter the accumulated depreciation and depreciation for a particular year.

Now that FA has developed this module, and I want to import 100's of assets from the previous excel spreadsheet, it seems that somehow it will be quite a complicated process to add these assist one by one, into FA. Some still have depreciable values whilst others are already at Zero.

This seems to be too much of an effort to add these hundreds of individual assets.

Thanks
Any alternative suggestions that we could add to the wiki for the take on of existing assets.

Go to forum: Fixed Assets

92 Reply by seahawk

(7 replies, posted in Banking and General Ledger)

Braath, I think you are correct. I will test again with the view of the transaction open, then edit and see what it does. I suspect that might be the problem.

Thanks will watch for that.

Go to forum: Banking and General Ledger

93 Reply by seahawk

(1 replies, posted in Accounts Receivable)

I could not find anything in the forum search but did found an answer on a google search on the following topic:
https://frontaccounting.com/punbb/viewtopic.php?id=6408

Worked great.

Thanks apmuthu.

Go to forum: Accounts Receivable

94 Topic by seahawk

(1 replies, posted in Accounts Receivable)

Is there a way that one could transfer a credit amount from one customer to another customer?

For example, if the customers are related companies, and Company nr 1 have a credit amount and company nr 2 have an outstanding debit balance. The customer gave written permission to allocate Company 1's credit to company 2.

Will appreciate your help since the normal Journal entry are not capable of doing that, since it does not post to specific customer only to the Debtors Control Account.

Go to forum: Accounts Receivable

95 Reply by seahawk

(7 replies, posted in Banking and General Ledger)

It only happens when you edit the Customer payment date. It should normally retain the original reference number, but for some or other reason the reference number stays in the system upon editing and when you want to save the payment after editing or change to a different customer, the system gives the error that the reference number already exists. It is not always, or it may be on second change.

If you have already reconciled the payment, the system will unreconcile the entry after saving the change.

Go to forum: Banking and General Ledger

96 Reply by seahawk

(7 replies, posted in Accounts Receivable)

said.omn wrote:

Hello, guys.

For example one of my customers has an invoice of $1000 but he prefers to pay the extra amount and keep it in the system for future purchases.

When I register the invoice payment I enter a $3000 instead of $1000, does the system keeps the extra credit in the system and notify me when the customer purchases again that he has credit where I can still the payment from?

Your advice is highly appreciated.

Yes, you can. Do normal Customer Payment. Add the $1000 amount next to invoice for the outstanding amount. The balance of the $2000 will be added to "Amount" and change the $1000 to $3000. The $1000 will then be allocated to the invoice and the balance will show as a credit.

On the issue of the next invoice for the customer: Go to Sales/Transactions/ Allocate Customer payment or Credit Notes and allocate the balance against the new invoice.

Trust this will help.

Then change

Go to forum: Accounts Receivable

97 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

98 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

99 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

100 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