I must have some help from arabic developers. Will someone try to help us. The algoritms for the arabic calendars are inside the /includes/date_functions.inc .
1,202 05/16/2015 08:32:27 pm
Re: Release 2.4 beta (10 replies, posted in Announcements)
Yes, it would. Shortly, I guess the requirements are the same as for release 2.3. I will ask Janusz to give a more specific overview.
/Joe
1,203 05/14/2015 02:29:41 pm
Topic: Release 2.4 beta (10 replies, posted in Announcements)
Announcement
This is a preliminary FrontAccounting ERP 2.4 Beta release.
This version provides a couple of new important features (in addition to all the
features merged from latest 2.3.24 release), but main development effort was
focused on internal architecture changes and cleanups to make future FA development
easier. Please keep in mind the application in current beta stage is only rougly
tested, so installation on production servers is not recommended yet. Until final
2.4.0 version both software API and database scheme are subject to smaller changes.
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.
Due to deep changes made under the hood, we highly encourage all current FA 2.3 users
to make test upgrades on a copy of your working installation connected to separate database
filled with your real company data. This will allow us find and fix any possibl
upgrade issues before final 2.4 release. Please report any bugs/problems found via our
Mantis Bugtracker at http://mantis.frontaccounting.com.
Download instructions
In Sourceforge FrontAccounting, select
Files -> FrontAccounting 2.4 ->2.4.beta.
For Windows users select the zip file. For all other users select the tar.gz file.
Common
Added full UTF-8 support with per-company selectable collation, and automatical convertion
with charset repair from earlier FA versions during upgrade.Added attachment link after most popular entry forms
Added support for png and gif item images.
Changed hardcoded date range in inquiries (30) to be a user preference.
Additional separate permission level allowing other user's transactions edition.
New mysql/mysqli driver implemented. Uses mysqli driver from php version 5.5.
Many global variables from config.default.php has been moved to GL Setup, Company Setup and Display Setup.
Cleanup: removed all closing tags in php files.
Switching all MyISAM tables to InnoDB to ensure better db consistency.
Added stub for database query profiling.
Rewritten upgrade procedures now allow additional upgrade parameters selections.
Multiply cleanups in db scheme: removed obsolete fields, optimized some fields type.
Improved journal trans: added currency support, tax and source document date. Allowed multiply customer/supplier
allocations to single journal transaction.Transaction references extended with parametrized patterns, initial transaction reference patterns set to {001}/{YYYY}.
Sales
Legal text field in Company Setup increased to a text field.
Implemented sale in prepayment mode (invoices are issued for customer partial payments, as opposite to partial deliveries)
Removed sparse fields contact_name,disable_trans from cust_branch, added branch bank account field on customer entry form.
Salesman Report: fixed bug in provision calculation, Sales Persons: changed break point definition to turnover level.
Improved recurrent orders feature: added invoice date and memo edition, additional checks for proper nvoice generation.
Purchasing
Default Receival Days setting added in System and GL Setup.
Added possibility to assign payments against orders (to be reallocated to invoices later).
Added exchange rate field in grn_batch.
Added dimension edition on purchase invoice entry.
Items and Inventory
Added 'no_purchase' option for items (with default value set in stock category).
Inventory Adjustment: removed obsolete increase/descrease selector from entry form (negative quantities can now be entered
just with minus sign).Removed obsolete Movement Types handling.
Bank and General Ledger
Bank deposit/payment edition added.
Setting customer/supplier currency bank account in payment / deposit forms.
Rewitten document reports layout for easier modifications, support for multiply payment services.
Implemented journal entries with multiply virtual AR/AP subaccounts.
Shipping tax is now defined per tax group as set of selected tax type(s).
Bank charges posting can be now cutsomized using Bank Charges Account in bank account settings.
Added memo and usage fields in Quick Entries.
1,204 05/10/2015 09:26:04 pm
Re: Jalali calendar (5 replies, posted in Translations)
Hi,
Look into the file, config.php, in the root of the FA installation
About line 132 you will the following lines:
/* Date systems. 0 = traditional, 1 = Jalali used by Iran, nabour countries, Afghanistan and some other Central Asian nations,
2 = Islamic used by other arabic nations. 3 = traditional, but where non-workday is Friday and start of week is Saturday */
$date_system = 0;Set the $date_system = 1;
This will implement the Jalali calender 
/Joe
1,205 05/06/2015 02:19:32 pm
Re: Demand column has negative values (11 replies, posted in Items and Inventory)
You can see the Sql sentences in file /includes/db/manufacturing_db.inc.
The sentences are in function get_demand_qty().
Also function get_demand_qty_asm show some sql sentences.
Joe
1,206 05/05/2015 12:40:05 pm
Re: Plug-in Tax Inquiry - Cash Basis reports incorrect input tax (11 replies, posted in Reporting)
Hello guys.
Who has written this plug-in Tax Inquiry?
As I can see this is not part of the core.
Joe
1,207 05/04/2015 08:22:35 am
Re: White Screen after login after activating extensions (10 replies, posted in Report Bugs here)
Please set the variable $go_debug to 2 in config.php to trap any errors. If you try again maybe some errors will help us.
Joe
1,208 05/01/2015 09:41:13 am
Re: TRANSACTION TYPE (2 replies, posted in Setup)
Hello,
The transaction types are defined in the file /includes/types.inc at the beginning.
/joe
1,209 04/30/2015 02:49:02 pm
Re: Demand column has negative values (11 replies, posted in Items and Inventory)
I guess it should be positive values here, so forget what I said about negative values is out.
I cannot explain why you have a negative value. It seems like that in some way there have been an over delivery. It may also be because you have 'allow negative stock' checked in Company Setup.
Will you do me a favour and look at your Sales Orders? Look how many items have been delivered and match them to ordered Items.
Maybe you can spot an error somewhere.
If you use manufacturing, Advanced Assembly, there might also be some strange values. I am not sure, but there must be something causing the negative values.
Thanks in advance.
Joe
1,210 04/30/2015 02:25:23 pm
Re: Demand column has negative values (11 replies, posted in Items and Inventory)
I am not at office at present.
Will have a look when I am back
Joe
1,211 04/30/2015 12:03:41 pm
Re: Demand column has negative values (11 replies, posted in Items and Inventory)
Well, I guess you should read -1 as 1 out, right? This column will never hold any positive values, I guess.
/Joe
1,212 04/30/2015 09:51:03 am
Re: Demand column has negative values (11 replies, posted in Items and Inventory)
The values from the demand column are the items on Sales Orders not yet delivered. If this is -1, it means that there is 1 items on a Sales Order not yet delivered.
It could also be item values from Work Order BOMs, not yet produced.
On Order means values on purchase orders not yet delivered.
/Joe
1,213 04/29/2015 08:00:32 pm
Re: Adding Dimensions in Supplier invoice (4 replies, posted in Wish List)
For stock items, the costs for the dimension is first taken during delivery (direct invoice).
So when you do your delivery (or direct invoice) the delivery will result in the stock is taken from inventory and placed on the costs account. If the dimension is chosen when creating the delivery (or direct invoice) the costs is also placed on the dimension.
This can be seen by looking at the gl transaction.
The sales part for the dimension is first taken when invoicing.
Joe
1,214 04/29/2015 07:27:35 pm
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
If you mean report 304, that we just fixed, then the answer is yes. This report is automatically included in the next release.
Joe
1,215 04/29/2015 02:53:01 pm
Re: Supplier Credit Note Incorrect Header and GST (12 replies, posted in Accounts Payable)
This has now been resolved. GIT repository for 2.3.24 has been updated.
You can download the two files here:
/purchasing/includes/ui/invoice_ui.inc and
/purchasing/supplier_credit.php.
Please replace the files on your server.
/Joe
1,216 04/24/2015 07:50:42 am
Re: Supplier Credit Note Incorrect Header and GST (12 replies, posted in Accounts Payable)
I will have a look at this. I am out of office until monday.
Then I will have a look.
/Joe
1,217 04/23/2015 05:25:28 am
Re: Notepad Direct Print (5 replies, posted in Reporting)
Well, I am not an expert in this. Maybe someone from the audience can help you.
Joe
1,218 04/22/2015 03:06:31 pm
Re: Notepad Direct Print (5 replies, posted in Reporting)
Can't you just select the menu Print in Notepad for doing this?
Joe
1,219 04/14/2015 08:10:17 am
Re: Add Currency Symbol at Invoice Top (8 replies, posted in Accounts Receivable)
If you want to get an exchange rate from a currency, FA tries to get the latest date rate up to and included the date given.
This is the way it shall work, right?
Joe
1,220 04/14/2015 06:21:54 am
Re: Add Currency Symbol at Invoice Top (8 replies, posted in Accounts Receivable)
No, the implementation is correct. Has been so since about 2005.
/Joe
1,221 04/11/2015 07:27:01 am
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
This has been implemented in release 2.3.24. Git repository updated. Two files can be downloaded here
/reporting/reports_main.php and
/reporting/rep304.php .
Replace the files on your server.
/Joe
1,222 04/11/2015 06:08:10 am
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
Ok, I guess it could be done. Give me some time.
Joe
1,223 04/10/2015 06:02:34 am
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
@Mark,
Can't you just use the report 'Item Sales Summary Report' for this purpose?
/Joe
1,224 04/10/2015 05:33:58 am
Re: Inventory Sales Report (14 replies, posted in FA Modifications)
I will have a look ito this.
Joe
1,225 04/08/2015 12:18:48 pm
Re: Editing a Journal Entry results in a duplicate entry on Tax Report (20 replies, posted in Report Bugs here)
I will have a look into this later.
Joe