<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Insert rows between lines]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8870&amp;type=atom" />
	<updated>2020-07-19T14:03:48Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=8870</id>
		<entry>
			<title type="html"><![CDATA[Re: Insert rows between lines]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37817#p37817" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[mark0300]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20216</uri>
			</author>
			<updated>2020-07-19T14:03:48Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37817#p37817</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Insert rows between lines]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37796#p37796" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[mark0300]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20216</uri>
			</author>
			<updated>2020-07-13T14:27:27Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37796#p37796</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Insert rows between lines]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37795#p37795" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[mark0300]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20216</uri>
			</author>
			<updated>2020-07-13T14:26:23Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37795#p37795</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Insert rows between lines]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37786#p37786" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2020-07-12T14:54:56Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37786#p37786</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Insert rows between lines]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37782#p37782" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[Braath Waate]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41493</uri>
			</author>
			<updated>2020-07-12T12:26:32Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37782#p37782</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Insert rows between lines]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=37779#p37779" />
			<content type="html"><![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>]]></content>
			<author>
				<name><![CDATA[mark0300]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20216</uri>
			</author>
			<updated>2020-07-12T07:43:40Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=37779#p37779</id>
		</entry>
</feed>
