<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Additional Fields Extension]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=7749</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=7749&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Additional Fields Extension.]]></description>
		<lastBuildDate>Mon, 18 Jan 2021 08:00:14 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=38986#p38986</link>
			<description><![CDATA[<p>@poncho1234, if we didn&#039;t make the custom fields inside core, your module is simple extra. Though it&#039;s useful to the customers.&nbsp; But it&#039;s not handy to use. And also we need to use the custom fields to reports as well. And also we have to provide the custom fields to transactions like sales invoice,&nbsp; order,&nbsp; delivery,&nbsp; etc. That&#039;s the full level of usage. And also we need to add more hooks to have control over the system.&nbsp; Probably @itronics and @Joe planned something.&nbsp; They are not actively listening the community developers new improvements.&nbsp; Hope they will reopen the tickets to give some dev repo access to developers to contribute new enhancements and updates, modules, themes, etc.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Mon, 18 Jan 2021 08:00:14 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=38986#p38986</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=38977#p38977</link>
			<description><![CDATA[<div class="quotebox"><cite>joe wrote:</cite><blockquote><p>Hello @kvvaradha and @poncho1234</p><p>I am trying to follow you guys in your wishes.<br />Let us try to focus on 2.5. Which fields do we need? I will put it on the developer site for 2.5.</p><p>Joe</p></blockquote></div><p>@joe</p><p>IMHO the problem with additional fields is its quite niche - not everybody wants them and those that do, want something different;<br />there are numerous requests all over this forum some for the same thing, some for different.<br />The latest request is here <a href="https://frontaccounting.com/punbb/viewtopic.php?id=9162">https://frontaccounting.com/punbb/viewtopic.php?id=9162</a></p><p>In the module I tried to be generic as possible whilst adding what I needed and with the use of custom fields any user could add the data that they require: Which should meet every users needs.</p><p>As to what fields you need in 2.5 my wish list is as follows:-</p><p>For each of <strong>Customer, Branch and Supplier:-</strong><br />City<br />Department<br />Country<br />Postcode<br />Document type(Possibly not required for supplier and branch)<br />Start date<br />Sector<br />Class<br />4 Custom fields for user definition</p><br /><p><strong>Item:-</strong><br />Bin number/Stock location reference<br />Primary Supplier<br />Alternative Supplier<br />Alternative part number<br />Manufactures part number<br />Start date<br />4 Custom fields for user definition</p><br /><p>@kvvaradha thoughts please? And if you want to discuss this offline please PM.</p>]]></description>
			<author><![CDATA[null@example.com (poncho1234)]]></author>
			<pubDate>Sun, 17 Jan 2021 18:47:06 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=38977#p38977</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37899#p37899</link>
			<description><![CDATA[<p>Hello,</p><p>Jut a followup on this extension. Just want to know if this will still make to FA.&nbsp; It would be a useful feature to have as many would have need for custom data field for capturing differing pieces of information. I am jut getting acquainted with FA and looking forward to adopt it.</p>]]></description>
			<author><![CDATA[null@example.com (btesec)]]></author>
			<pubDate>Sat, 01 Aug 2020 19:57:24 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37899#p37899</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37378#p37378</link>
			<description><![CDATA[<p>PHP has a <a href="https://www.php.net/manual/en/function.json-encode.php">json_encode</a> and <a href="https://www.php.net/manual/en/function.json-decode.php">json_decode</a> functions to convert to/from array.</p><p><a href="https://stackoverflow.com/questions/2467945/how-to-generate-json-file-with-php">Sample Code</a></p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Thu, 30 Apr 2020 17:56:33 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37378#p37378</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37370#p37370</link>
			<description><![CDATA[<p>Yes. But for more&nbsp; customization get only one value from that minified string. We have to decode all the custom fields. May be a choice to do that.suppose if we have to bring hsn code for items. And we have to take tax reports based on hsn code. It might be complex to get and process the results.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Wed, 29 Apr 2020 20:01:45 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37370#p37370</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37366#p37366</link>
			<description><![CDATA[<p>Alternatively, can keep a JSON field in each such table that needs extra field data and define all such data definitions in a single table.</p><p>Yet another alternative: Keep an XML file for extra fields definition in each application - suppliers, items, customers, invoices, etc and keep all such data in a single table with an application name/type field to segregate them.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 29 Apr 2020 18:01:20 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37366#p37366</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37357#p37357</link>
			<description><![CDATA[<p>We have to add two tables for custom fields. One for the field definition and another one to store data of custom fields. </p><p>Actually I am thinking to extend this to sales invoice&nbsp; and purchase invoice.</p><p>@poncho1234 - we have to focus on next major release. I can understand.&nbsp; Let&#039;s try to contribute something to next release.</p><p>@Joe&nbsp; users are eagerly waiting for the next major update. So let&#039;s focus on it.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Wed, 29 Apr 2020 14:23:19 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37357#p37357</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37345#p37345</link>
			<description><![CDATA[<p>Hello @kvvaradha and @poncho1234</p><p>I am trying to follow you guys in your wishes.<br />Let us try to focus on 2.5. Which fields do we need? I will put it on the developer site for 2.5.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Tue, 28 Apr 2020 22:21:51 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37345#p37345</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37344#p37344</link>
			<description><![CDATA[<p>@kvvaradha - OK, Bit busy at the moment, but I&#039;ll have a think and post something.</p><p>Also, it seems &#039;Bin Number&#039; is a definite inclusion in Items.</p>]]></description>
			<author><![CDATA[null@example.com (poncho1234)]]></author>
			<pubDate>Tue, 28 Apr 2020 19:32:02 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37344#p37344</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37343#p37343</link>
			<description><![CDATA[<p>This program we wrote it for 2.5 it&#039;s not for 2.4 those who wish to customize the core they can give it a try with this module. Other than that this code will be used inside 2.5 the next major update.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Tue, 28 Apr 2020 17:59:28 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37343#p37343</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37342#p37342</link>
			<description><![CDATA[<p>@kvvaradha - It has been made clear by Joe/Janus that there will be no more DB changes in 2.4, i.e, Any modifications requiring DB changes will not be considered for V2.4 only for 2.5 and if they consider the modifications are right for FA.</p><p>Its relatively easy to add extra fields to the core, not so easy to include them in FA functionality, but including them now brings all the disadvantages of modifying core files - upgrades, management, etc.</p><p>Given the above a module seemed to be the only viable solution. The module I wrote is quite &#039;bulky&#039; as I tried to incorporate as many additional fields as I thought users would want. (Each user/business would want there own fields) The original &#039;integrated&#039; version did not work, which leads to the current version using extra pages: The remains bearing not much resemblance to the initial idea :-(</p><p>So my thoughts on your mod are - I&#039;d think I&#039;d leave just the custom fields from my module in, 4 for each of customers, Items and suppliers, that way users can label the fields to what they want. You can use any code from the module.</p>]]></description>
			<author><![CDATA[null@example.com (poncho1234)]]></author>
			<pubDate>Tue, 28 Apr 2020 16:00:03 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37342#p37342</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37340#p37340</link>
			<description><![CDATA[<p>@poncho1234, What i tried to explain you is to get the custom fields inside the respective pages. Usually its hard to remember and work in separate page for the custom fields. So we have to put the custom fields within the existing page itself. Here i have created a demo for understanding it.</p><p><a href="http://demo.kvcodes.com/FA"> Kvcodes Demo for Custom Fields </a><br />Username : custom<br />Password : 123456</p><p>This is my very initial version.&nbsp; We will enhance and develop it to bring more possible custom fields to custom pages.&nbsp; Looking for users and developers feedback to enhance it better.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Tue, 28 Apr 2020 12:40:19 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37340#p37340</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=35640#p35640</link>
			<description><![CDATA[<p>Can please explain how i can use this code ? I&#039;m not into programming</p>]]></description>
			<author><![CDATA[null@example.com (shereif)]]></author>
			<pubDate>Tue, 06 Aug 2019 17:09:21 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=35640#p35640</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33968#p33968</link>
			<description><![CDATA[<p>FYI, I played with a different approach: defining additional fields as xml inside a text field.&nbsp; There are no database changes and no changes to the items, suppliers, or customers pages.</p><p><a href="https://gist.github.com/braathwaate/07c97f599143f6bc4584d515d231b968">Gist</a></p><p>Screenshots:</p><p><a href="https://drive.google.com/open?id=11J8B9yTuvopg7oY54Y8PXk09t1ag30DK">Customers</a><br /><a href="https://drive.google.com/open?id=1HhiPWK4FK2jGdFF5pV9DQ7tbCjImi9o4">Items</a></p>]]></description>
			<author><![CDATA[null@example.com (Braath Waate)]]></author>
			<pubDate>Mon, 14 Jan 2019 16:56:17 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33968#p33968</guid>
		</item>
		<item>
			<title><![CDATA[Re: Additional Fields Extension]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33731#p33731</link>
			<description><![CDATA[<p>The <strong>id</strong> field of the <strong>0_item_codes</strong> table is the Primary Key that can be used instead of the <strong>stock_id</strong> or the <strong>item_code</strong> field for linking into the additional fields extension&#039;s tables.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sun, 23 Dec 2018 03:14:57 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33731#p33731</guid>
		</item>
	</channel>
</rss>
