26

(38 replies, posted in Reporting)

That happens when I updated FA to 2.4.17. Email an invoice to a client and that is what the client receives.

Then I will replace the standard class.mail.inc with the the one I have changed as indicated. by changing all the \n code in the file to \r\n and it works on both PHP7.4, HP8.0, 8.1 and 8.2.

Then it sends the invoice correctly as a PDF attachment.

27

(38 replies, posted in Reporting)

This is what I receive in the email if I am lucky enough to get one without my changes to the file above:

--d6d94ed3a97c22d3af03070ba9b0c91c
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

JVBERi0xLjMKMS4wMCB3CjMgMCBvYmoKPDwvVHlwZSAvUGFnZQovUGFyZW50IDEgMCBSCi9N
ZWRpYUJveCBbMCAwIDU5NS4yOCA4NDEuODldCi9SZXNvdXJjZXMgMiAwIFIKL0NvbnRlbnRz
IDQgMCBSPj4KZW5kb2JqCjQgMCBvYmoKPDwvRmlsdGVyIC9GbGF0ZURlY29kZSAvTGVuZ3Ro
IDE1MDU+PgpzdHJlYW0KeJzVWltT2zgUfs+vOC87284QV5IlX3hqIKGTTqEUvO3utn0QsQLe
+gKyDU1//Up2LnISCJ1p7OkwdpBzLH/nO1cpxhZC8AAI3qrjP/j8VX2E6nijjuveUQCvTjBg
oqWCKYyCHv7ZG5DlIQrm+eJNj1az9JjD9D+O5+mPpEeRMYx7cDl/nJqEIQLmWU2Cf3oSz8Xq
dh85+kwYyOu5NPMrxIxUU/Vxda8UMF17yFwuad5mPmRN3qUN+Xr4hDxzGvL18LlKEPQ8JWq5
pHnbE6BQU2m0Q2lMGkrMh6Z8g72tytIm3YuxIUJYc5LF2BCxWXOWxdgQoc4aFGdjlnXTN01V
z2ISuU1v6tOmRD02RdaN0ySzErkDTD2LqThSf/VDaGVk168GkwRejTEMM/hQRyJpROLikr0z
mrdEG2x1vDsd9aAmnuNwK3hBCJ9fDO7KKI45DML7KM9kDpPJy68QvFWPhQ/6FqxR/FgCww1g
W7AuLvm/FL7lUtY4y1ofYlvMrxRy/VqhYPA3jM8+vh8fj3Yp4q+hxvCLQSM1hXmWphEcx7K9
GvM4ncRlGKXXsDBHIHmUqgsrFfYPiNEloPP3cJR9B+ywNgFQsgTwhst8mqWFiNIDOJeiyGTE
DwAhSgxEldXsVq1moxVJN1kqHvOx/QHBaAMJ8mzHdRBluH04c15UGVugOeHfu2PFwIE8Bxhm    etc.




With the changes implemented as indicated above, a pdf copy is correctly received as an attachment to the email and a proper email.

28

(38 replies, posted in Reporting)

Just changed it and tested and now it mails to client and to admin in the copy to email address in company setup.

The standard class.mail.inc  sends nothing.

Replaced /n with /r/n and it works again.

29

(38 replies, posted in Reporting)

With the 2.4.17 this issue is still there. It seems that the reporting/includes/class.mail.inc is still not fixed. With every update the new file is overwritten and we are back to the same issue.

When I replace the core file with the change information as indicated below it will send the emails and attachments as expected.

"I have found the solutions by changing all the \n code in the file to \r\n and it works on both PHP7.4 and PHP8.0

Emails are now sending and displaying correctly when sent from FA.

\r\n is for a new line in windows as for \n in the new line in Linux.

Use \r\n instead of \n for your implode -- explicitly specifies CRLF as the line terminator."


Why are we keep on having the same issue irrespective of the PHP it is set on?

Is no one else have the same issue?

30

(5 replies, posted in Accounts Receivable)

When I set my PHP to 8.2 with FA 2.4.17 the following error shows:

Creation of dynamic property front_accounting::$renderer is deprecated in file: /home/mydomain/public_html/accounts/frontaccounting.php at line 66

When I switch back to php 8.1 it goes away.

31

(1 replies, posted in Accounts Receivable)

The aged Customer Analysis differs from the customer Balance report.

As can be seen from the two attachments, the Customer balance shows correctly whilst the Aged Customer analysis does not.


The Customer balance sees the journal as a credit, while the Aged Customer Analysis see the same journal as a debit.

I cannot upload the second file.

It still displays the information requested, will the errors on top of the info. Irrespective of the setting for the php.ini file display_errors = Off or On, the info still displays

There is nothing in the error logs.

See something here https://stackoverflow.com/questions/74862088/warning-trying-to-access-array-offset-on-value-of-type-bool-error-when-upgrading

It seems something in the customer_inquiry.php is the issue.

When selecting All Customers, there is no error. When selecting any other customer, receive the error. It seems to only throw the error on certain customers. For other customers, there is no problem.

Version 2.4.16 and PHP 8.0

Sorry for omitting that.

As far as I am aware, the cash accounts and savings accounts cannot go into negative. Chequing and credit accounts would. Select the correct type of account

35

(2 replies, posted in Wish List)

On the setup tab for company setup/ there is a tick box for Search Customers. Switch that on and see if that is what you are looking for.

Just tested it and if you select the search function direct invoice with company address it will display that.

Go to gl reports and save the format that you need in CSV instead of PDF.

You can also install the Transaction import module under Install/Activate Extensions on Setup Tab/ Maintenance.

37

(38 replies, posted in Reporting)

I found a solution for the reporting/includes/class.mail.inc when I got the issue with the same thing.

I have found the solutions by changing all the \n code in the file to \r\n and it works on both PHP7.4 and PHP8.0

Emails are now sending and displaying correctly when sent from FA.

\r\n is for a new line in windows as for \n in the new line in Linux.

Use \r\n instead of \n for your implode -- explicitly specifies CRLF as the line terminator.

38

(5 replies, posted in Installation)

You should not delete your database. That will wipe everything.

Should only remove your FA folders inside of your frontaccounting installations.

Hopefully, you have an up-to-date backup of your database.

Change the Theme. Some themes on FA have issues with PHP8

When you go sales/ Inquiries and Reports /  Customer Transaction Inquiry

When I select any client I get the following error although the information is still displaying.

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 116

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 131

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 132

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 133

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 134

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 135

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 136

Trying to access array offset on value of type bool in file: /home/mywebsite/public_html/accounts/sales/inquiry/customer_inquiry.php at line 137

What would cause this issue?

Here is the screenshot I am talking about for the memo fields not population in the recon and recon report.

41

(17 replies, posted in Setup)

Once I change the coding on the Rep17, it sends the pdf as an attachment. When emailing an invoice or any document, it creates this code inside the email. Cannot send that to the clients.

It is the emailing function in FA that creates the issue.

Relating to the following post:



I found a solution for the reporting/includes/class.mail.inc

I have found the solutions by changing all the \n code in the file to \r\n and it works on both PHP7.4 and PHP8.0

Emails are now sending and displaying correctly when sent from FA.

\r\n is for a new line in windows as for \n in the new line in Linux.

Use \r\n instead of \n for your implode -- explicitly specifies CRLF as the line terminator.

When I change this in the lass.mail.inc it send correctly on PHP8

42

(17 replies, posted in Setup)

After updating to FA 2.4.16, found that this email issue raised its head again. When I change the reporting/includes/class.mail.inc file to my changes made as indicated above, it sends correctly to me and the client.

It sends a plain coded email mail that looks like this small extract

JVBERi0xLjMKMS4wMCB3CjMgMCBvYmoKPDwvVHlwZSAvUGFnZQovUGFyZW50IDEgMCBSCi9N
ZWRpYUJveCBbMCAwIDU5NS4yOCA4NDEuODldCi9SZXNvdXJjZXMgMiAwIFIKL0NvbnRlbnRz
IDQgMCBSPj4KZW5kb2JqCjQgMCBvYmoKPDwvRmlsdGVyIC9GbGF0ZURlY29kZSAvTGVuZ3Ro
IDE1Mzc+PgpzdHJlYW0KeJzVWltz0zgUfu+vOC/MwkxjJFvypU8kTdoNA6W0WZZd4EHEamuw

Nothing is attached to the email.

In RSA you have to declare Discounts received from a supplier and discounts Given to Clients.

I do not know if it is a language "South African English" issue or what. FA 2.4.14

When you do a Direct sales/ Direct invoice/ your first line item headings Column from left to right are:

1. Item Code
2. Item Description
3. Quantity
4. Unit
5. Price after tax
6. Discount%
7. Total
8. Add item.

On Purchases/ Direct Supplier Invoices/ columns are L2R:

1. Item Code
2. Item Description
3. Quantity
4. Unit
5. Price before tax
6. Line Total
7. Add Item

No discount option.

Why is there no discount option on Supplier or Direct Supplier Invoices global or per line item?

How do we indicate these discounts received?

46

(21 replies, posted in Reporting)

Don't worry, I copied an old 709 Report back and is now working.

This is a PHP file but cannot upload PHP, so made it txy file

47

(21 replies, posted in Reporting)

I have upgraded to FA 2.4.14 and found the same issue with VAT Exists.

It is not the bank payment quick entry that is the problem. It does not pull the bank payment transactions containing VAT through to report 709 when processed through Bank payments or the journals.

This leaves me now with a huge issue since I cannot submit client VAT reports to the South African Tax authorities.

I am now between the devil and the big blue sea. I have to submit it tomorrow and have been spending most of the day to resolve the issue.

This is a serious disappointment

Thanks, That means for now just live with it. It still works but is difficult when the TAX/VAT must pull through to the VAT report. That report must be submitted to our tax authorities in RSA with all support documents to indicate how you calculated your sale or value-added tax.

49

(1 replies, posted in Accounts Receivable)

I found a solution. Check this post:

https://frontaccounting.com/punbb/viewtopic.php?id=9899

I have had a look at the current info on the demo.

#21 and #23 as well as #22 in the Banking Gand General Ledger/Transactions/Reconcile Bank account. Bca Account.

All Bank Payments have empty information in the Person/Item Column. In item 23 and 21, The Transaction Memo (Which is available on all Bank Payments, Bank Deposits, Customer Payments and Supplier Payments) is showing, not the Line Memo. #23 Also have a Line memo. But it does not show.

I created #24 in Bank Payments in Bank Account (Bca). So on Reconcile Bank account (Bca) Nothing is shown in the Person Item, even though I selected The following:

1. (Pay To) Miscellaneous (which is normally used for paying bank fees for example)
2. In the  (To the Order of) field I entered "Miscellaneous Payment"
3. In the (Line memo) I entered "Line Memo" and
4. In the (Transaction Memo) I entered Transaction Memo.

Go to Banking and General Ledger/Transactions/Reconcile Bank Account/ Bank Payment #24, there is a credit for 10 000 in the Credit Column; Nothing in the Person/Item Column; and Transaction Memo in the Memo column.

Click on item #24 you find the following information:



There should be a Person/Item on Bank Payments and Bank Deposits instead of the line memo, since not all companies use customer invoicing and payments, for example, charity donations.

When you draw the Banking report for account Bca for December 2022, #21 has a blank space at Person/Item while #23 Has information.

1. Pay To: Empty
2. Items for this payment: In column Memo, Item Line Memo.

Select the line Ledger entry:

1. Transaction Memo shows on line 4 of the window and shows against the Bank Loans line, whilst the Original Line Memo shows in the Sales Account.

Select Banking and General Ledger/Inquiries and Reports/ Banking Reports/Bank Statement/Bank Account Bca:

1. #24 Now shows the Person/Item that was entered with the entry as indicated above with Bank Payments/ Miscellaneous
2. I have found that when I create a shortcut for the same transaction, you also get empty fields like #21 on the Bank statement.
3. Line memo nor Transaction memo is to be found.

Select Banking and General Ledger/Inquiries and Reports/ Banking Reports/Bank Statement w/Reconcile/Bank Account Bca:

It now adds the Reco Date and Narration (Which is the same as the transaction Memo) Line memo is nowhere to be found.

Select Reports and analysis/ General Ledger/

1. In the ledger reports none of the Memos is showing at all within the two ledger accounts.

If Sales tax was included, then these banking transactions that is using Quick entries, also do not have anything displaying one of the Memos on the Tax report. I have not included Sales tax for ease of illustration. 

Trust this will help to make sense.