<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Development]]></title>
		<link>https://frontaccounting.com/punbb/index.php</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=37&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent topics at FrontAccounting forum.]]></description>
		<lastBuildDate>Wed, 17 Nov 2021 08:48:12 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Integration with gridphp.com]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=9559&amp;action=new</link>
			<description><![CDATA[<p>Hello<br />I was trying to integrate gridphp.com in FA.</p><p>Facing this error. May be some JS is conflicting. Can anyone help?</p><p><a href="https://prnt.sc/1zvrs70">https://prnt.sc/1zvrs70</a></p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Wed, 17 Nov 2021 08:48:12 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=9559&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[How to manage Call to API From within FA]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=9293&amp;action=new</link>
			<description><![CDATA[<p>I am trying to use API in a project where API call is from within FA for the currently logged in user and company.</p><p>In this case how the session will be handled in the current FA API plugin.</p><p><strong>Session Handling</strong><br />I don&#039;t want to create a new session. Instead want to use the same session.</p><p><strong>API Call</strong><br />I created a test page and called the absolute url using file_get_contents as below and I got response.</p><p>$result = file_get_contents(&#039;https://pakerp.net/modules/api-bx/category&#039;);</p><p>But I am not sure what is the right way to call API using relative path within FA.</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Fri, 07 May 2021 05:47:29 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=9293&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Activate Ajax on Input Text Field]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=9289&amp;action=new</link>
			<description><![CDATA[<p>In FA we can activate Ajax on Combo fields by setting Submit_on_Change to true.</p><p>Is there any way we can activate Ajax on Input Text Field if the value is changed then Ajax is called?</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Mon, 03 May 2021 09:29:33 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=9289&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[[Solved] Line Endings Issue]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8800&amp;action=new</link>
			<description><![CDATA[<p>Dear All,</p><p>My last two days were too hectic. My FA was not exporting the reports in Excel Properly. No Error was shown. I was unable to locate the issue. I had one month old backup that has no issue. I compared both and found an issue that one of latest module&#039;s hooks.php file was not having LF line endings.</p><p>I found this <a href="http://stahlworks.com/dev/?tool=addcrlf">Swiss File Knife Tool</a> helpful to check in bulk and convert the whole projects Line Endings to LF.</p><p>Since I am using Linux server so I needed LF.</p><p>This Post is also helpful <a href="https://stackoverflow.com/a/16886243">https://stackoverflow.com/a/16886243</a></p><p>Once installed the above tool. Open the Project Directory in Command Prompt and write the below command</p><p>&gt; sfk remcr -dir your_project_directory -yes</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Wed, 13 May 2020 10:35:21 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8800&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Forum Posting - Hall of Shame]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8707&amp;action=new</link>
			<description><![CDATA[<p>Although the forum users DB has been trimmed to be around 5300 users, over the years 45K users have registered and many have become inactive even without posting and others have gotten deleted for malicious posting too.</p><p>Attached herewith is a list of remaining users summary who have been Banned for unacceptable posts belonging to different domains where such activity exceeds 10 users in the domain.</p><p>Many legitimate domains too have been used.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Tue, 03 Mar 2020 07:52:18 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8707&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Relationship between User and POS]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8514&amp;action=new</link>
			<description><![CDATA[<p>Currently we have a field user in the table 0_audit_trail to store relationship between users and transactions.<br />In the future when transactions statistics for sales points is needed, developers can use user field in the table 0_audit_trial then join it with table 0_users to know which transaction is belong to which sales point.<br />This would cause wrong statistical problem if an user is moved to another sales points.<br />So it is necessary to have additional field <strong>pos_id</strong> in the table 0_audit_trail to fix the relationship between transaction and sales point</p>]]></description>
			<author><![CDATA[null@example.com (notrinos)]]></author>
			<pubDate>Sun, 17 Nov 2019 02:44:49 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8514&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Sourceforge Statistics]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8485&amp;action=new</link>
			<description><![CDATA[<p>Dears,</p><p>looking at Sourceforge statistics one thing that drew my attention besides the UK is the biggest country of downloads is also that most of the OS downloads are unknown. Is there a reason? Just curious.</p><p>https://sourceforge.net/projects/frontaccounting/files/FrontAccounting%202.4/stats/map?dates=2019-07-01%20to%202019-10-01&amp;period=monthly</p><p>@rafat</p>]]></description>
			<author><![CDATA[null@example.com (rafat)]]></author>
			<pubDate>Fri, 01 Nov 2019 14:30:11 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8485&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[PHP Coding Standards Fixer Using Atom]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8402&amp;action=new</link>
			<description><![CDATA[<p>As a developer it is very important to follow the Coding Standards. <strong>Atom</strong> provides a very easy built in system after installing this <a href="https://atom.io/packages/php-cs-fixer">Package</a>.</p><p>Once installed in windows with XAMPP in the settings set values as below.</p><p>PHP executable path: c:\xampp\php\php.exe</p><p>PHP-CS-fixer executable path: [path_to_atom]\.atom\packages\php-cs-fixer\php-cs-fixer-v2.phar</p><p>You need to download <strong>php-cs-fixer-v2.phar</strong> file from <a href="https://cs.symfony.com/download/php-cs-fixer-v2.phar">here</a> in the above path.</p><p>Enjoy...</p>]]></description>
			<author><![CDATA[null@example.com (boxygen)]]></author>
			<pubDate>Sat, 14 Sep 2019 06:02:18 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8402&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Search Customers, Suppliers by Phones]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8377&amp;action=new</link>
			<description><![CDATA[<p>The following 4 files is my modification to allow user can search customer, supplier by their phones<br />Especially searching customers by phone number is very common in retail activities.</p>]]></description>
			<author><![CDATA[null@example.com (notrinos)]]></author>
			<pubDate>Mon, 02 Sep 2019 15:51:49 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8377&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Salesman system to be more flexible in next major release]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8374&amp;action=new</link>
			<description><![CDATA[<p>It would be more realistic to link sales person with sales order instead of only with branch the way it is now.<br />We will still need to keep the current relationship between sales person and branch so that can have a default salesman every time select a branch on a sales order.<br />This is a real situation that I have encountered when implementing systems for service providers such as spa, salon, law firms office...</p>]]></description>
			<author><![CDATA[null@example.com (notrinos)]]></author>
			<pubDate>Fri, 30 Aug 2019 14:57:30 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8374&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[New/Changed Fields in Database for release 2.5]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8324&amp;action=new</link>
			<description><![CDATA[<p>New/Changed Fields that are going to be implemented in 2.5:</p><div class="codebox"><pre><code>supplier.bank_account - 60 chars =&gt; 100 chars
audit_trail.description - 60 chars =&gt; tinytext
    Remove substr in function add_audit_trail.

Attaching MS Office documents like docx, xlsx, pptx, etc will result in error as the mime type exceeds 60 characters - need to increase the size of the field attachments.filetype to say 100 from the current 60 characters.

Weight and size on Items for totalizing on order/invoice. (https://frontaccounting.com/punbb/viewtopic.php?id=8692).
FrontAccounting forum → Reporting → Bug in rep102.php. Using Journal Entry problem.
FrontAccounting forum → FA Modifications → Working on an extension for invoicing and I have questions.... Empty rows.
Salesman also related to sales order:
   https://frontaccounting.com/punbb/viewtopic.php?pid=35862#p35862
Stock Item. An extra field for secondary code (barcode).
More to come here....</code></pre></div><p>/Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Sat, 10 Aug 2019 08:16:15 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8324&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Planned changes in stock_moves table structure in FA 2.5]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8238&amp;action=new</link>
			<description><![CDATA[<p>In FA 2.4 table stock_moves was designed as log of changes in inventory, but due to some inconsistencies in table&#039;s fields usage in the code, when some costing problem appears it is not easy to track where the problem arose. Therefore we plan to change stock_moves structure in next major release, to make it better also for inventory cost tracking purposes.</p><p>Following changes are planned:<br />1. &#039;reference&#039; field removed<br /> Rationale: this field is both not used and double redundant to refs table and reference fields in respective transaction tables.<br />2. `standard_cost` changed to `avg_cost` - store for item average cost (stock_master.material_cost)&nbsp; before transaction<br /> Rationale: while this field is not strictly necessary, it make tracking average cost changes easier. BTW the standard_cost name is just historical artefact not&nbsp; related to what is stored here now;<br />3. `price` superseded by `unit_cost` - store for unit_cost in transaction<br />Rationale: currently price field is used for cost calculations, while this is the cost which is needed finally. Price is stored in transaction lines records, and always can be retrieved if needed.</p><p>Finally planned stock_moves table structure in FA 2.5:<br /></p><div class="codebox"><pre><code>CREATE TABLE `0_stock_moves` (
  `trans_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` smallint(6) NOT NULL DEFAULT &#039;0&#039;,
  `trans_no` int(11) NOT NULL DEFAULT &#039;0&#039;,
  `stock_id` char(20) NOT NULL DEFAULT &#039;&#039;,
  `loc_code` char(5) NOT NULL DEFAULT &#039;&#039;,
  `tran_date` date NOT NULL DEFAULT &#039;0000-00-00&#039;,
  `qty` double NOT NULL DEFAULT &#039;1&#039;,
  `unit_cost` double NOT NULL DEFAULT &#039;0&#039;,
  `avg_cost` double NOT NULL DEFAULT &#039;0&#039;, 
  
  PRIMARY KEY (`trans_id`),
  KEY `type` (`type`,`trans_no`),
  KEY `Move` (`stock_id`,`loc_code`,`tran_date`)
) ENGINE=InnoDB;</code></pre></div><p>All comments are welcome.<br />J.</p>]]></description>
			<author><![CDATA[null@example.com (itronics)]]></author>
			<pubDate>Sun, 23 Jun 2019 11:16:25 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8238&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Release 2.5.]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=8137&amp;action=new</link>
			<description><![CDATA[<p>Hello all active/passive Developers.</p><p>I am going to initiate the upcoming implementation of 2.5. Please tell me if I have forgotton anyting or things you think should be considered.</p><p>I will put this in the &#039;Code&#039; section below as we agree on it.<br /></p><div class="codebox"><pre><code>1. HRM module in the core. I wil check with Janusz. If he is out of time, maybe @notrinos can take over this.
2. Interactive DashBoard. Initiative by @notrinos. Changing part of the core to make it work smoothly. @notrinos can fix this.
3. More modern default theme, but still keeping the existing. Add option for own login box etc. @joe is looking into that.
4. Approval System for GL Postings. https://frontaccounting.com/punbb/viewtopic.php?pid=36415#p36415
5. Some kind of Landed Costs when entering Supplier Invoice.
6. Bank Account. Fields for sort-code/ABA/Region, IBAN, Swift/BIC code.
....
99. More options to come here as they are agreed.</code></pre></div><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Thu, 02 May 2019 07:55:50 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=8137&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[Copyrights for FA source]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7816&amp;action=new</link>
			<description><![CDATA[<p>Hello,</p><p>Due to the many developers contributing to FA source, we will change the Copyright note in the beginning of most source files to:<br />Copyright (c) FrontAccounting Team (see README.md).</p><p>And in the README.md we will mention the members that have contributed to the FA source.</p><p>We plan to do this in the next major (2.5) release.</p><p>/Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 14 Nov 2018 08:36:50 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7816&amp;action=new</guid>
		</item>
		<item>
			<title><![CDATA[A new default theme for FA.]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?id=7815&amp;action=new</link>
			<description><![CDATA[<p>Hello Guys,</p><p>Our default theme is a bit outdated at the moment. If anyone of you developers/senior members have a proposal for a new default theme, please contribute. It will be much appreciated.</p><p>I would like to see some fancy, simple, examples.</p><p>Thanks in advance.</p><p>/Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 14 Nov 2018 08:32:32 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?id=7815&amp;action=new</guid>
		</item>
	</channel>
</rss>
