<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Insert rows between lines]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=8870</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8870&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Insert rows between lines.]]></description>
		<lastBuildDate>Sun, 19 Jul 2020 14:03:48 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Insert rows between lines]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37817#p37817</link>
			<description><![CDATA[<div class="quotebox"><cite>Braath Waate wrote:</cite><blockquote><p>You could take the same approach for item insertion when modifying the code: make a copy of the cart, insert a new line, delete the cart items after the new line, then add the items after the new line from the cart copy.&nbsp; &nbsp;This would be a nice feature to offer for inclusion into the base code.</p><p>Alternatively, you could avoid using the FA editor and instead enter orders as csv files and use the import transactions extension.&nbsp; When a customer makes a change, void the entire order, and update the csv using a text editor and reimport.&nbsp; However, I think this only currently supports sales orders and direct invoices and not quotations.</p><p>Because FA does not have line numbers on the order, you can also use a pdf editor to move stuff around to match the look of the customer&#039;s PO before you print.&nbsp; &nbsp;For this purpose, I use Libreoffice Draw, which works quite well.</p></blockquote></div><p>Hi Braath, APMuthu,</p><p>I ran through the functions of copy_to_cart(), function handle_new_item(), function handle_delete_item($line_no).&nbsp; &nbsp;I am getting a bit frustrated when I try to construct something out on Sales Order Entry.&nbsp; My idea is to add a &quot;+&quot; icon next to the pencil icon (edit) such that when I click on the &quot;+&quot; icon, it will add a line above it.&nbsp; However, I got stuck after adding the &quot;+&quot; icon.&nbsp; I can&#039;t add a new line above the current line and I do not know how to push the rest of the lines downward.&nbsp; Would you be able to guide me with some codes or provide some simple function codes so that I could get things moving...? </p><p>Thanks...</p><p>/Mark</p>]]></description>
			<author><![CDATA[null@example.com (mark0300)]]></author>
			<pubDate>Sun, 19 Jul 2020 14:03:48 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37817#p37817</guid>
		</item>
		<item>
			<title><![CDATA[Re: Insert rows between lines]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37796#p37796</link>
			<description><![CDATA[<div class="quotebox"><cite>apmuthu wrote:</cite><blockquote><p>Changing the primary keys of the respective tables and re-ordering them is possible but must be done carefully or through a separate script / extension.</p></blockquote></div><p>Hi APMuthu,</p><p>Noted with thanks.</p><p>/Mark</p>]]></description>
			<author><![CDATA[null@example.com (mark0300)]]></author>
			<pubDate>Mon, 13 Jul 2020 14:27:27 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37796#p37796</guid>
		</item>
		<item>
			<title><![CDATA[Re: Insert rows between lines]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37795#p37795</link>
			<description><![CDATA[<div class="quotebox"><cite>Braath Waate wrote:</cite><blockquote><p>You could take the same approach for item insertion when modifying the code: make a copy of the cart, insert a new line, delete the cart items after the new line, then add the items after the new line from the cart copy.&nbsp; &nbsp;This would be a nice feature to offer for inclusion into the base code.</p><p>Alternatively, you could avoid using the FA editor and instead enter orders as csv files and use the import transactions extension.&nbsp; When a customer makes a change, void the entire order, and update the csv using a text editor and reimport.&nbsp; However, I think this only currently supports sales orders and direct invoices and not quotations.</p><p>Because FA does not have line numbers on the order, you can also use a pdf editor to move stuff around to match the look of the customer&#039;s PO before you print.&nbsp; &nbsp;For this purpose, I use Libreoffice Draw, which works quite well.</p></blockquote></div><p>Hi Braath,</p><p>I got what you mean.&nbsp; I will look into it.</p><p>Thanks!</p><p>/Mark</p>]]></description>
			<author><![CDATA[null@example.com (mark0300)]]></author>
			<pubDate>Mon, 13 Jul 2020 14:26:23 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37795#p37795</guid>
		</item>
		<item>
			<title><![CDATA[Re: Insert rows between lines]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37786#p37786</link>
			<description><![CDATA[<p>Changing the primary keys of the respective tables and re-ordering them is possible but must be done carefully or through a separate script / extension.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sun, 12 Jul 2020 14:54:56 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37786#p37786</guid>
		</item>
		<item>
			<title><![CDATA[Re: Insert rows between lines]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37782#p37782</link>
			<description><![CDATA[<p>You could take the same approach for item insertion when modifying the code: make a copy of the cart, insert a new line, delete the cart items after the new line, then add the items after the new line from the cart copy.&nbsp; &nbsp;This would be a nice feature to offer for inclusion into the base code.</p><p>Alternatively, you could avoid using the FA editor and instead enter orders as csv files and use the import transactions extension.&nbsp; When a customer makes a change, void the entire order, and update the csv using a text editor and reimport.&nbsp; However, I think this only currently supports sales orders and direct invoices and not quotations.</p><p>Because FA does not have line numbers on the order, you can also use a pdf editor to move stuff around to match the look of the customer&#039;s PO before you print.&nbsp; &nbsp;For this purpose, I use Libreoffice Draw, which works quite well.</p>]]></description>
			<author><![CDATA[null@example.com (Braath Waate)]]></author>
			<pubDate>Sun, 12 Jul 2020 12:26:32 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37782#p37782</guid>
		</item>
		<item>
			<title><![CDATA[Insert rows between lines]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37779#p37779</link>
			<description><![CDATA[<p>Hi there,</p><p>When creating new or editing SO, DN, Quotation etc, I need to insert a new row between rows of items which I already entered.&nbsp; This is because some customers required me to follow the exact sequence of their orders.&nbsp; &nbsp;This happened often for some customers as their demands are changing very often.&nbsp; </p><p>If there are 20 line items in the order and the customer make a change of their order by inserting a new line item say at row 2, I will have to delete the rows from 2 and below and re-enter everything after inserting the new line.</p><p>How do I modify the codes to allow a insertion of row in between rows?</p><p>Thanks.</p><p>/Mark</p>]]></description>
			<author><![CDATA[null@example.com (mark0300)]]></author>
			<pubDate>Sun, 12 Jul 2020 07:43:40 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37779#p37779</guid>
		</item>
	</channel>
</rss>
