<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=6580</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=6580&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Changing one of the columns in "Invoice Against Sales Delivery".]]></description>
		<lastBuildDate>Thu, 15 Dec 2016 18:40:26 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27062#p27062</link>
			<description><![CDATA[<p>Keeping the Branch Column and adding the Ship_From field along with the appropriate report and sql filters / where constructs and the headings ($cols) will mitigate the Branch filter issue.</p><p>1. Create a local Git repo using TortoiseGIT in your windows environment (works with Linux and Mac too) with the core files in a core folder. <br />2. Place your files in a mods sibling folder. Import the affected core files as is into the same path under your mods folder and commit the change. <br />3. Make changes to the files in the mods folder and commit the change with information regarding the feature / change envisaged with it.<br />4. Whenever the core file changes, compare with your modded file and implement the changes thereof in it.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Thu, 15 Dec 2016 18:40:26 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27062#p27062</guid>
		</item>
		<item>
			<title><![CDATA[Re: Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27039#p27039</link>
			<description><![CDATA[<p>I guess another question I have is I have made a lot of modifications to the core and hard coding changes to FA.&nbsp; Is there a way to take what I have done and turn it into a module or way to package it up so when an update to FA comes along I won&#039;t be pulling my hair out trying to redo all the modifications I have created?</p>]]></description>
			<author><![CDATA[null@example.com (myhandgunpursedotcom)]]></author>
			<pubDate>Thu, 15 Dec 2016 05:50:43 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27039#p27039</guid>
		</item>
		<item>
			<title><![CDATA[Re: Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27038#p27038</link>
			<description><![CDATA[<div class="quotebox"><cite>apmuthu wrote:</cite><blockquote><p>Your navigation:</p><p><strong>Sales -&gt; Invoice Against Sales Delivery</strong></p><p>will yield a url like:<br /></p><div class="codebox"><pre><code>http://localhost/sales/inquiry/sales_deliveries_view.php?OutstandingOnly=1</code></pre></div><p>The file <strong>sales/inquiry/sales_deliveries_view.php</strong> calls the <strong><em>function</em> get_sql_for_sales_deliveries_view()</strong> defined in <strong>sales/includes/db/cust_trans_db.inc</strong> just before assigning the array of column headings to <strong>$cols</strong>. </p><p>Edit the SQL in the said function to include the <strong>Ship_From</strong> field and adjust the <strong>$cols</strong> for the heading (either by hardcoding or as gettext translation string in .po/.mo).</p></blockquote></div><p>Wow, that was so easy to do.&nbsp; Thank you for all the help.</p><p>On a side note though, by making that change to the <strong><em>function</em> get_sql_for_sales_deliveries_view()</strong> defined in <strong>sales/includes/db/cust_trans_db.inc</strong> it now allows me to batch invoice deliveries from the same customer but different branches.&nbsp; If I process the invoice will that mess up the transactions in the GL or any of the other accounts?&nbsp; I guess I could make a quick backup of the db and then create the batch invoice and see what happens.&nbsp; Just was curious if there was something in the deep background that might get messed up with that invoice if I did that.</p>]]></description>
			<author><![CDATA[null@example.com (myhandgunpursedotcom)]]></author>
			<pubDate>Thu, 15 Dec 2016 05:48:03 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27038#p27038</guid>
		</item>
		<item>
			<title><![CDATA[Re: Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27037#p27037</link>
			<description><![CDATA[<p>Your navigation:</p><p><strong>Sales -&gt; Invoice Against Sales Delivery</strong></p><p>will yield a url like:<br /></p><div class="codebox"><pre><code>http://localhost/sales/inquiry/sales_deliveries_view.php?OutstandingOnly=1</code></pre></div><p>The file <strong>sales/inquiry/sales_deliveries_view.php</strong> calls the <strong><em>function</em> get_sql_for_sales_deliveries_view()</strong> defined in <strong>sales/includes/db/cust_trans_db.inc</strong> just before assigning the array of column headings to <strong>$cols</strong>. </p><p>Edit the SQL in the said function to include the <strong>Ship_From</strong> field and adjust the <strong>$cols</strong> for the heading (either by hardcoding or as gettext translation string in .po/.mo).</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 14 Dec 2016 16:24:18 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27037#p27037</guid>
		</item>
		<item>
			<title><![CDATA[Re: Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27029#p27029</link>
			<description><![CDATA[<div class="quotebox"><cite>apmuthu wrote:</cite><blockquote><p>You are trying to change the heading label - it has nothing to do with the actual field from where it comes. The <em>type</em> array element is for formatting the column and also has nothing to do with the contents of any table&#039;s field.</p><p>Anything like: <strong>_(&quot;string&quot;)</strong> is shortform for <strong>gettext(&quot;string&quot;)</strong> and is changed by changing the *.po file and compiling it as *.mo file using msgfmt. Refer the Translations page in the Wiki.</p><p>To achieve what you want, pick out the strings that are affected and then trace the translation strings in the appropriate .po file and edit them in a text editor using &quot;No BOM&quot; format and then compile it it as the *.mo file and replace it in the fa install.</p></blockquote></div><p>Ok, I think I didn&#039;t explain what I was trying to do that well.</p><p>What I am want to do is instead of the Branch information being shown in the branch column, have it pull from my DB the Ship From information instead.&nbsp; I did that with the Sales Order Search page, but I can&#039;t figure out how to do that with the Invoice Against Deliveries page.</p><p><a href="https://drive.google.com/open?id=0B6yNa5cxS_7Hd3BLT2hmYW04eDA">Here is what the page looks like now</a></p><p><a href="https://drive.google.com/open?id=0B6yNa5cxS_7HekthUUliODRfdHM">Here is what I want to change</a></p><p><a href="https://drive.google.com/open?id=0B6yNa5cxS_7HS2NHeEo1RTdHbkU">Here is how I changed the data in the search sales order page</a></p>]]></description>
			<author><![CDATA[null@example.com (myhandgunpursedotcom)]]></author>
			<pubDate>Wed, 14 Dec 2016 00:40:15 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27029#p27029</guid>
		</item>
		<item>
			<title><![CDATA[Re: Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27014#p27014</link>
			<description><![CDATA[<p>You are trying to change the heading label - it has nothing to do with the actual field from where it comes. The <em>type</em> array element is for formatting the column and also has nothing to do with the contents of any table&#039;s field.</p><p>Anything like: <strong>_(&quot;string&quot;)</strong> is shortform for <strong>gettext(&quot;string&quot;)</strong> and is changed by changing the *.po file and compiling it as *.mo file using msgfmt. Refer the Translations page in the Wiki.</p><p>To achieve what you want, pick out the strings that are affected and then trace the translation strings in the appropriate .po file and edit them in a text editor using &quot;No BOM&quot; format and then compile it it as the *.mo file and replace it in the fa install.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sun, 11 Dec 2016 05:01:16 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27014#p27014</guid>
		</item>
		<item>
			<title><![CDATA[Changing one of the columns in "Invoice Against Sales Delivery"]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=27012#p27012</link>
			<description><![CDATA[<p>Need some help getting pointed in the direction for where the code is that determines what data is pulled from the database.</p><p>What I am trying to do is change the &quot;Branch&quot; column to show my new &quot;Ship From&quot; data.&nbsp; Now I can change the column heading all day long, what I can&#039;t figure out is where to change the data that&#039;s being called up.&nbsp; I was able to make it change in the &quot;Sales Order Inquiry&quot; to where it shows the &quot;Ship From&quot; data from my database.&nbsp; After I made that change this afternoon, I forgot how I did it have been trying to figure that out as well so I could do the same thing for the &quot;Invoice Against Sales Delivery&quot;.</p><p>I see in <strong>sales/inquiry/sales_deliveries_view.php</strong> where it calls the sql and the sets up the columns, but I can&#039;t find where it calls the data from the database.<br /></p><div class="quotebox"><blockquote><p>$sql = get_sql_for_sales_deliveries_view($selected_customer, $selected_stock_item, $_POST[&#039;customer_id&#039;]);</p><p>$cols = array(<br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Delivery #&quot;) =&gt; array(&#039;fun&#039;=&gt;&#039;trans_view&#039;), <br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Customer&quot;), <br />&nbsp; &nbsp; &nbsp; &nbsp; &#039;branch_code&#039; =&gt; &#039;skip&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Branch&quot;) =&gt; array(&#039;ord&#039;=&gt;&#039;&#039;), <br />&nbsp; &nbsp; &nbsp; &nbsp; //_(&quot;Ship From&quot;) =&gt; array(&#039;type&#039; =&gt; &#039;ship_from&#039; , &#039;ord&#039; =&gt; &#039;&#039;) , <strong>This is a line I added, but is commented out right now.&nbsp; I know if I comment out the line above and uncomment this one I can change the column title.</strong><br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Deliver To&quot;),<br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Reference&quot;), <br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Cust Ref&quot;), <br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Delivery Date&quot;) =&gt; array(&#039;type&#039;=&gt;&#039;date&#039;, &#039;ord&#039;=&gt;&#039;&#039;),<br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Due By&quot;) =&gt; &#039;date&#039;, <br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Delivery Total&quot;) =&gt; array(&#039;type&#039;=&gt;&#039;amount&#039;, &#039;ord&#039;=&gt;&#039;&#039;),<br />&nbsp; &nbsp; &nbsp; &nbsp; _(&quot;Currency&quot;) =&gt; array(&#039;align&#039;=&gt;&#039;center&#039;),<br />&nbsp; &nbsp; &nbsp; &nbsp; submit(&#039;BatchInvoice&#039;,_(&quot;Batch&quot;), false, _(&quot;Batch Invoicing&quot;)) <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; array(&#039;insert&#039;=&gt;true, &#039;fun&#039;=&gt;&#039;batch_checkbox&#039;, &#039;align&#039;=&gt;&#039;center&#039;),<br />&nbsp; &nbsp; &nbsp; &nbsp; array(&#039;insert&#039;=&gt;true, &#039;fun&#039;=&gt;&#039;edit_link&#039;),<br />&nbsp; &nbsp; &nbsp; &nbsp; array(&#039;insert&#039;=&gt;true, &#039;fun&#039;=&gt;&#039;invoice_link&#039;),<br />&nbsp; &nbsp; &nbsp; &nbsp; array(&#039;insert&#039;=&gt;true, &#039;fun&#039;=&gt;&#039;prt_link&#039;)<br />);</p></blockquote></div><p>Thank you for the help in this!</p>]]></description>
			<author><![CDATA[null@example.com (myhandgunpursedotcom)]]></author>
			<pubDate>Sun, 11 Dec 2016 03:28:15 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=27012#p27012</guid>
		</item>
	</channel>
</rss>
