726 06/16/2018 05:52:49 am
Re: FA2.4.4 Aged Supplier Analysis (3 replies, posted in Report Bugs here)
727 06/15/2018 05:43:06 am
Re: Anyone else have problems viewing the wiki? As in empty pages. (11 replies, posted in Report Bugs here)
Janusz is investigating this.
Joe
728 06/14/2018 04:58:45 am
Re: Anyone else have problems viewing the wiki? As in empty pages. (11 replies, posted in Report Bugs here)
I will have a look at this.
Joe
729 06/12/2018 06:52:30 pm
Re: Wrong unit cost for AP Surf Set in demo data (12 replies, posted in Report Bugs here)
@apmuthu
I guess your sharp eyes have spotted an issue belonging to the old 2.3 release.
Will have a look at it later.
Joe
730 06/12/2018 05:47:46 am
Re: Wrong unit cost for AP Surf Set in demo data (12 replies, posted in Report Bugs here)
@notrinos
Sorry you are absolutely right. But a good thing is that we got hand of the additional_costs in the 0_workorders table 
/Joe
731 06/11/2018 09:19:25 pm
Re: Wrong unit cost for AP Surf Set in demo data (12 replies, posted in Report Bugs here)
The last field in the workorders table is additional_costs and it seems redundant after our 2.4 release.
It is not used any more. The material costs, overhead_costs etc. is on the stock_moves and stock_master tables.
We will remove this field when releasing the 2.5 version.
So the value of 0 is ok at the moment.
Joe
732 06/11/2018 07:36:50 pm
Re: Wrong unit cost for AP Surf Set in demo data (12 replies, posted in Report Bugs here)
I will have a look at it later.
Joe
733 06/08/2018 10:32:15 pm
Re: Account Code to be define as int (4 replies, posted in Banking and General Ledger)
Hello @boxygen
Yes it will. There are many tables where there are references to the account number, so please do not change this. Why do you want to change from varchar to int. The reason for using varchar is how the account numbers are sorted and there might be a wish in some countries to have them alphanumeric.
In most serious accounting systems this variable is varchar.
Joe
734 06/04/2018 09:40:45 pm
Re: Frontaccounting 2.4.4 bug in Reports - List of Journal Entries (7 replies, posted in Report Bugs here)
This is only change to an existing report and an optional one. It will not interfere with anything else.
The change is needed to see the underlying GL rows for a Work Order. This is a mirror on the View Work Order in Work Order Inquiry.
Joe
735 06/04/2018 08:43:49 am
Re: Frontaccounting 2.4.4 bug in Reports - List of Journal Entries (7 replies, posted in Report Bugs here)
The Report Workorder Listing has now got an option for printing the GL rows for the workorders.
This has been committed to Repo and can be download here:
rep402.php (Workorder Listing)
reports_main.php
Please replace the files in your setup.
/Joe
736 06/03/2018 10:36:18 pm
Re: Frontaccounting 2.4.4 bug in Reports - List of Journal Entries (7 replies, posted in Report Bugs here)
Due to the complexity with using the normal report, List of Journal Entries, for presenting work order GL listing, I have decided to use one of the Reports in the Manufacturing tab for this purpose.
I will use the report Work Order Listing and add a filter, Show GL Details or something and when selecting this I will list all the other types, just like the view in the Workorder Entries. These listings will be after very Workorder if this filer is selected.
/Joe
737 06/03/2018 03:14:28 pm
Re: Frontaccounting 2.4.4 bug in Reports - List of Journal Entries (7 replies, posted in Report Bugs here)
This is a tricky one. The Work Order may have Productions, Issues and Overhead cost entries, which have their own types.
You can see the complete transactions for a Work Order in Manufacturing, Work Order Entries, and press the GL transactions.
However, I will try to fix this, but it might take some time. The solution is to check if the Work Orders have these transaction types to also list them if so.
Joe
738 05/28/2018 09:32:58 pm
Re: Editing a Direct Invoice entry (3 replies, posted in FA Modifications)
@boxygen
I think you mean the delivery note of the sales invoice, right?
/Joe
739 05/24/2018 08:03:18 pm
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
Oops! Will be fixed asap. Thanks.
Joe
740 05/24/2018 01:24:38 pm
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
Commited to Repo with rerun cleanup.
/Joe
741 05/24/2018 11:38:29 am
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
Willdo later today.
Joe
742 05/09/2018 01:41:05 pm
Re: Adding Attachments to Dimension (2 replies, posted in Dimensions)
Committed to Repo.
/Joe
743 05/09/2018 05:07:54 am
Re: Adding Attachments to Dimension (2 replies, posted in Dimensions)
A good idea. Willdo.
Joe
744 05/07/2018 07:06:05 am
Re: Australian Tax Invoice extension (9 replies, posted in Modules Add-on's)
Fixed and committed to Repo.
/Joe
745 04/25/2018 06:47:09 am
Re: inventory valuation report (6 replies, posted in Reporting)
If the $use_costed_values is set to 1, then the date range is used on the stock_moves material costs for each transaction.
This is not the same as the material_cost set on the stock_master table.
If the end date is today then the values should be the same if the stock_moves are updated correctly.
Joe
746 04/24/2018 08:48:44 pm
Re: inventory valuation report (6 replies, posted in Reporting)
@boxygen
As I can see we do use the global variable, $use_costed_values, in rep301.php.
It is on line 209:
if (isset($SysPrefs->use_costed_values) && $SysPrefs->use_costed_values==1)
{
$UnitCost = getAverageCost($trans['stock_id'], $location, $date);
$ItemTotal = $trans['QtyOnHand'] * $UnitCost;
}
else
{
$UnitCost = $trans['UnitCost'];
$ItemTotal = $trans['ItemTotal'];
} Joe
747 04/23/2018 05:55:26 am
Re: The Future of FrontAccounting (6 replies, posted in Development)
@boxygen
You are a valued senior member and it is good to have you among the developers.
I will assemble what we have got of interested developers during today. Janusz amd I will have a chat about how to proceed.
I guess a new Forum for development is a good place to start. Amd maybe an internal mailing list.
Joe
748 04/23/2018 05:47:59 am
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
The solution with automatic increment of references only works with documents.
Joe
749 04/18/2018 09:25:21 am
Re: db_pager.inc - count(): Parameter must be an array (1 replies, posted in Report Bugs here)
Thanks. Fixed and committed to Repo.
/Joe
750 04/17/2018 08:36:02 pm
Re: Typo in rep103 (1 replies, posted in Report Bugs here)
Thanks. Committed to Repo.
/Joe