I will have a look at it later.
Joe
726 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)
727 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
728 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
729 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
730 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
731 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
732 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
733 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
734 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
735 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
736 05/09/2018 01:41:05 pm
Re: Adding Attachments to Dimension (2 replies, posted in Dimensions)
Committed to Repo.
/Joe
737 05/09/2018 05:07:54 am
Re: Adding Attachments to Dimension (2 replies, posted in Dimensions)
A good idea. Willdo.
Joe
738 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
739 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
740 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
741 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
742 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
743 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
744 04/17/2018 08:36:02 pm
Re: Typo in rep103 (1 replies, posted in Report Bugs here)
Thanks. Committed to Repo.
/Joe
745 04/16/2018 07:21:48 am
Topic: The Future of FrontAccounting (6 replies, posted in Development)
Hello all Senior Members and Developers
----------------------------------------
On a Developer meeting yeaster day we, @itronics (Janusz) and I, have decided to call for more help.
Janusz is very occupied by his main work, but he will still be helping us with his great knowledge and Code
implementing.
I am getting older, and am no longer such a Work Horse as before, although still fit for tasks.
We are looking forward to the next major 2.5 and more.
At present we are very satisfied with the core implementation. It is not fully object oriented, but we feel it is
easy to work with. Eventually change of the core could be a candidate to a future 3.0 version. We will see.
On the Forums, @apmuthu is doing a tremendious job. He tries to help all, both newbies and more skilled users.
Very good.
Janusz is very fond of @notrinos's implementation of a tiny Human Resource extension, FrontHrm, on Github.
He would like to give it a closer look and eventually some modifying of the Tax implementations and other things
before including in the core.
You should be proud, @notrinos, he is not easy to convince 
This would be a candidate for 2.5 release.
I guess we will start with an active 2.5 release soon on our Git repo.
We need help with php/javascript developers, 2 to 3 guys. I have seen the following guys contributing with
various code:
@notrinos
@boxygen
@kvvaradha
@davidkumi
@Braath Waate
@poncho1234
@seahawk
@cambell
@Alaa
@alvin
@barbarian
@chaitanya
@p2409
@tom
Just to name a few. I know there are more. Some of these have not been active lately.
Should anyone of you have a knowledge of php/javascript, just tell us if you are interested in beeing part
of the keveloper team.
We also need a Website Administrator and Designer to rewire the frontaccounting.com page(s).
And we also need some good writers for doing some Public Relations for us. We feel that a lot more people should
know about FrontAccounting.
Should you feel interesting, please be in touch. Either here or use our email addresses.
This topic will be both on the Announcement Forum, but the Working Horse will be in the Modifications Forum.
Developers, Senior Members are welcome with things needed in 2.4 and future 2.5. We welcome source code for your solutions.
An example is the 'Landing Costs' discussed earlier. If someone can find a simple solution to this, it would be nice.
Please use the Modification Forum version for dialogs. It will be a Sticky topic.
/joe
746 04/16/2018 07:19:52 am
Topic: The Future of FrontAccounting (1 replies, posted in Announcements)
Hello all Senior Members and Developers
----------------------------------------
On a Developer meeting yesterday we, @itronics (Janusz) and I, have decided to call for more help.
Janusz is very occupied by his main work, but he will still be helping us with his great knowledge and Code
implementing.
I am getting older, and am no longer such a Work Horse as before, although still fit for tasks.
We are looking forward to the next major 2.5 and more.
At present we are very satisfied with the core implementation. It is not fully object oriented, but we feel it is
easy to work with. Eventually change of the core could be a candidate to a future 3.0 version. We will see.
On the Forums, @apmuthu is doing a tremendious job. He tries to help all, both newbies and more skilled users.
Very good.
Janusz is very fond of @notrinos's implementation of a tiny Human Resource extension, FrontHrm, on Github.
He would like to give it a closer look and eventually some modifying of the Tax implementations and other things
before including in the core.
You should be proud, @notrinos, he is not easy to convince
This would be a candidate for 2.5 release.
I guess we will start with an active 2.5 release soon on our Git repo.
We need help with php/javascript developers, 2 to 3 guys. I have seen the following guys contributing with
various code:
@notrinos
@boxygen
@kvvaradha
@davidkumi
@Braath Waate
@poncho1234
@seahawk
@cambell
@Alaa
@alvin
@barbarian
@chaitanya
@p2409
@tom
Just to name a few. I know there are more. Some of these have not been active lately.
Should anyone of you have a knowledge of php/javascript, just tell us if you are interested in being part
of the developer team.
We also need a Website Administrator and Designer to rewire the frontaccounting.com page(s).
And we also need some good writers for doing some Public Relations for us. We feel that a lot more people should know about FrontAccounting.
Should you feel interested, please be in touch. Either here or use our email addresses.
This topic will be both on the Announcement Forum, but the Working Horse will be in the Modifications Forum.
Developers, Senior Members are welcome with things needed in 2.4 and future 2.5. We welcome source code for your solutions.
An example is the 'Landing Costs' discussed earlier. If someone can find a simple solution to this, it would be nice.
Please use the Modification Forum version for dialogs. It will be a Sticky topic.
/joe
747 04/16/2018 06:41:03 am
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
On a meeting this Weekend between me and @itronics (Janusz) we have decided to implement the automatic increase of document references shown by @kvvaradha. Slightly modified.
For backwards compatibility it is implemented as a Company Setup switch. 'Auto Increase of Document References'. You will have to mark this item for enabling this.
This change has been committed. You can download the files at the repo here
/Joe
748 04/16/2018 06:37:09 am
Re: Journal Entry Number (#) Changes after Editing in 2.4 Version! (22 replies, posted in Banking and General Ledger)
Hello Guys
@itronics (Janusz) and I have been discussing this item this Weekend. There are some complicated sideeffects if changing it back to 2.3.
In the future, we are only going to show the reference numbers in all views and reports (not the built in numbers).
An Access-role will make it possible to see both the built-in number and the reference number.
Janusz will make a post in a while, explaining why he prefers this method.
/Joe
749 04/11/2018 05:21:11 am
Re: Not working: Automatic Increase of reference number fields in FA 2.4.2 (67 replies, posted in Setup)
I am aware of these behaviours and the shown solutions are subject to be fixed.
This weekend I am having a meeting with Janusz and we are among others talking about the subjects.
So just stay put. We are trying to solve it the best ways.
Thanks for the various solutions
Joe
750 04/09/2018 08:21:57 am
Re: Session error (5 replies, posted in Report Bugs here)
Thanks for reporting. This will be fixed asap.
Currently there are problems committing to Sourceforge Git, but as soon as it is working again, it will be committed.
/Joe