Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 41 of 200)
Topics by joe User defined search
Posts found: 1,001 to 1,025 of 4,986
Announcement
This is a First FrontAccounting ERP 2.4.1 release.
This version provides a couple of new important features (in addition to all the
features merged from latest 2.3.25 and 2.3.26 releases), but main development effort was
focused on internal architecture changes and cleanups to make future FA development
easier.
At the time of release most of optional extension modules available from central
extensions repo has been also ported to 2.4 and should be mostly usable. Most Themes are
updated and many new Themes are available.
Please report any bugs/problems found via our
Mantis Bugtracker at http://mantis.frontaccounting.com.
Download instructions
In Sourceforge FrontAccounting (https:/sourceforge.net/projects/frontaccounting), select
Files -> FrontAccounting 2.4 ->2.4.1.
For Windows users select the zip file. For all other users select the tar.gz file.
Common
Fixed typos in installer translation files, fixed translations in dashboard procedures.
Fixed access control to tabbed dialogs in Items/Suppliers/Customers.
Fixed security check for last tab in tabbed_content.
Fixed broken html enities handling in longer TextWrap fields in reports.
Increased space for built in number columns etc. in reports.
Fixed problem with installing third party extension packages.
Bug submitting forms in FA 2.4.x when checkbox field not changed. Fixed
0003658: Errors during reference line edition when no table prefix is used.
0003733: Fixed php7 compatibility issue.
Improved entropy for report file urls.
Fixed problems with excel report generation.
Added a small Arabic font file, reporting/fonts/zarnormal.ttf, and improved the builtin DashBoard.
0003789: Comments is cut off when actual invoice is printed. Maximized to 130 characters.
Sales
0003816: Customer Credit Note (stand alone) does not restore inventory
Customer Balances Report | Allocated column not showing correctly. Fixed.
0003780: Sales Invoice to partial delivery was improperly issued as final prepayment invoice.
Sales type bug in tax_included (persistent on). Fixed.
Purchasing
0003585: 'Exclude from purchase' function not working in PO.
Dimension is missing in Supplier Invoice View GL Rows. Fixed a parameter bug in add_supp_invoice_gl_item.
Supplier Payment: by default bank account is selected to be the same as that used on the last payment for
the supplier (if any, or default currency account otherwise).
0003667: Fixed incomplete supplier payment link after entering supplier invoice.
0003795: Fixed incorrect GL postings for cash purchase invoices.
Supplier Balances Report | Allocated column not showing correctly. Fixed.
tems and Inventory
Manufacturing
Fixed Assets
0003862: Straight Line Depreciation value calculation is wrong
0003863: Fixed Assets Valuation Report Includes inactive Items with Valuation
0003864: Fixed Asset Sales GL Transactions were wrong. Fixed.
Bank and General Ledger
Fixed bug in bank account edition
Bloomberg Rate has changed their wrapper from span to div.
Fixed date checks in is_date_in_fiscalyears().
Minor bug in deleting fiscal years.
Announcement
This is a final 2.3.26 bugfix release. The last release in the 2.3 series.
Common
Fixed typos in some installer translation files.
Fixed access control to tabbed pages in Items/Customers/Suppliers.
Fixed checkbox abnormalities in forms.
Improved entropy for report file urls.
Fixed problem with Excel report generation.
Sales
Cleanup in sales_invoice_db.inc (obsolete parameters in update_debtor_trans_allocation calls)
Customer Balances Report. Allocated column not showing correctly. Fixed.
Sales Type potential bug in tax_included (persistent on) on certains machines.
Purchasing
Dimension is missing in Supplier Invoice View, GL Rows.
Supplier Payment link after entering supplier invoice fixed.
Supplier Balances Report. Allocated column not showing correctly. Fixed.
Items and Inventory
Manufacturing
Banking and General Ledger
Fixed bug in Bank Accounts edition.
Bloomberg Rate has changed their wrapper from span to div.
Minor bugs in deleting fiscal years.
I found a PHP_XLSXWriter class here
https://github.com/mk-j/PHP_XLSXWriter
I will check if this class can be used. It handles 1048576 rows.
If it is ok, I will implement it during the 2.4 series. Maybe already the 2.4.2 release.
Joe
There is a catch 22 effect in counting the lines. The report Title is printed before the eventual counting of the printed lines could be done.
I guess it is quite rare to have that many rows in a report If we have, say 60 rows per page, it will result in over 800 pages!
I guess it is better to just wiki this as I said before and let some skilled programmer fix this during the 2.4 series.
/Joe
Yes, there was a bug. And it is fixed and committed to 2.4 unstable. You can download it here and replace in /includes/dashboard.inc.
/Joe
I will have a look. Maybe we can test for that the menu is set.
Joe
I don't know how to do this. Maybe we could wiki it until someone can help. Will you apmuthu, please?
Hello,
I cannot reproduce this error. Can you tell me a little more detailed about it. I wonder if this is Theme based. Which theme are you using?
/Joe
Yes, you are right. Fixed in unstable (2.4) repo. Thanks for detecting this. Also backported to 2.3 for safety.
/Joe
You could include the phone number in the address field on the customer/branch. F.i. separated with an enter character.
Joe
This has now been fixed and committed to 2.3 stable and 2.4 unstable repo.
Thanks for your participation, boxygen. You have made my day 
/Joe
Thanks boxygen.
Will look into this and optimize it. Forget my earlier files. Will remove them.
/Joe
Hello boxygen,
There is a flag in config.php, called $use_costed_values that is set to 0 by default. In that case the standard cost set in the stock_master table (the last average standard cost) is used all over the period. This is only used in rep301.php
If this flag is set to 1, it will use the costed values all over the period, and the total will be the same as in the Costed Inventory Movements.
The reason for setting this variable $use_costed_values to 0 (default) is that this also can cope with manual changes in the standard costs.
I guess we use the same algorithms for Costed Values in both rep 301 and 308. Right?
/Joe
Yes, I have been looking into this also tonight and think you are right. What you mean is to use to the stock_moves standard_cost instead of calcutating from the purchase price, right?
I guess your idea is better. The question is if we should change rep301 too in accordance to this. What do you think?
I have changed the copyright to FrontAccounting LLC and inserted your name as the creator. I have also optimized the report.
Please rename the file to extension php.
Can I commit this report and also in 2.4?
/Joe
The change in currency rates can change the value of the stock so that the value at the end is not the same as in the General Ledger.
To compensate for this you may enter a Journal Voucher.
This report gives you a more adequate value than the report on the average standard costs over time.
/Joe
The report is in the file /reporting/rep308.php.
You see the algorithms here. Can you advise me how you would implement this report in detail. As I told I didn't create this report. So I would appreciate if you will help.
Joe
Hello again Alaa,
In the file
/reporting/includes/class.graphics.inc
I have increased the font size with 2 pixels. And the space between works has been replaced by two spaces .
Was the font too big or is it ok? And was the space between words better now.
The php GD library doesn't support RTL languages, so we had to fix the strings to do so, but we could not change the graphics itself.
I guess this is the best we can do for now. Maybe there are some skilled developers that can help us in the future. This can always be worked on between releases. It doesn't require any database update.
Please replace the file /reporting/includes/class.graphics.inc with this one.
/Joe
Hello Alaa,
I see you are using the Arabic language and this is good test for me.
A couple of years ago I helped another guy with Arabic language to get a suitable font to be used in the Graphics.
We found some, but I had to fix the leadings and other things with the fonts. I did that and we got some usable fonts.
In the config.php file, there is a variable called
$UTF8_fontfile = "FreeSans.ttf";
This fontfile doesn't work with the Arabic language. I have listed some utf8 fonts that can be used with the Arabic language.
Will you help and test them and give me a high five (1 - 5) character of the usability of the fonts?
Remember to spell the font names exactly. The smaller the file is the better, but it should be usable of course.
I will then incorporate one of the fonts in the default package, and change the variable in the config.default.php.
/Joe
Hello again,
I didn't create this report. So I had to go into the source code.
As I can see, the rate is based on
1. Initial values is based on the rate on the beginning date.
2. Incoming values are based on the average rate during the period.
3. The same for outgoing values.
4. The end values are based on the average values for the whole period.
The guy who wrote this report are not reachable at present.
Can you use some of the other reports if this is not adequate.
Joe
Please use this link for customer balance.
https://sourceforge.net/p/frontaccounting/git/ci/unstable/tree/reporting/rep101.php
Abd this link for supplier balance
https://sourceforge.net/p/frontaccounting/git/ci/unstable/tree/reporting/rep201.php
Please be aware that these links are for 2.4
Joe
Ah, I see. 2.3. Will have a look into this.
Joe
Are you referring to 2.3 or 2.4 or maybe both?
Joe
This has now been fixed in both the 2.3 stable repo as well as the 2.4 unstable repo.
In the allocated columns a correct - sign is shown for credit allocations and the summations are now also correctly done.
/Joe
The allocated column should only be seen isolated for each record.
The mistake here is, that the column has been totalized. This should not have been done. Or it should show a minus sign for payments so the totalisation would be correctly presented.
Will fix this.
Joe
No this is not a duplicate code. This is an outgoing and an ingoing stamp with writeoff reference. These 2 transactions is not seen in the stock movements transactions.
So you will not see anything in the stock movements. Only when looking into the database.
This has been changed slightly in 2.4.
Due to no sideeffects in 2.3 as it is now, we will not change anything here.
/Joe
Posts found: 1,001 to 1,025 of 4,986
