<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Release 2.1 - Recurrent Invoices. How to?]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=461</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=461&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Release 2.1 - Recurrent Invoices. How to?.]]></description>
		<lastBuildDate>Mon, 17 Feb 2020 18:37:32 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=37023#p37023</link>
			<description><![CDATA[<p>Pardon my noob-ness but I am _not_ an accountant and know nothing about accounting, I am an IT/programmer guy.</p><p>That being said, I am trying to use frontaccounting to keep track of membership fees for a makerspace.&nbsp; Members can pay for 3 months, 6 months, or a year at a time via Paypal, etransfer, or cash.&nbsp; I am trying to figure out how to do a recurring invoice for this scenario.</p><p>I want to set up recurring invoices so we can send members a reminder that their membership is due.&nbsp; I see this is done via &quot;recurring invoices&quot; and that seems to require a &quot;template&quot;.&nbsp; From what I can tell, you create templates by checking off a box when you run the sales order inqury report.&nbsp; However after I do a sales order, then delivery, then invoice, there is no &quot;template checkbox&quot; in the sales order inquriry report.</p><p>Does anybody have any ideas on what I&#039;m doing wrong and/or how I can set this up?</p><p>Many thanks,<br />SW</p>]]></description>
			<author><![CDATA[null@example.com (SW1)]]></author>
			<pubDate>Mon, 17 Feb 2020 18:37:32 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=37023#p37023</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33963#p33963</link>
			<description><![CDATA[<p>This issue is still not resolved. </p><p>When I go Sales/ Create and Print Recurrent Tax Invoices / Create invoice with new description and date. You get two options:</p><p>1. Print recurring invoice<br />2. Email recurring invoice</p><p>1. Print is fine and display and print correctly.<br />2. Does not email the invoice at all and display no message in the browser that the mail was send. </p><p>I then have one of two options to email the invoice:</p><p>1. Go to Sales/ Inquiries and Reports / Customer Transactions Inquiry / select the invoice to modify and when finished you save and get the options to print and to email invoice. When emailed from here it sends the email and displays in a green bar confirming that email was send.<br />2. Go to Sales Reports/ Select the Invoice to print/display/email. Select email options and click display. The email sends and is confirmed as send and received by client.</p><p>The previous solutions did not work. I do not know if this send email in the first instance point somewhere else and not the same as the other two. Not sure where to look.</p><br /><p>Thanks</p>]]></description>
			<author><![CDATA[null@example.com (seahawk)]]></author>
			<pubDate>Mon, 14 Jan 2019 15:00:35 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33963#p33963</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=33209#p33209</link>
			<description><![CDATA[<p>This option send 350 old&nbsp; invoices to the client.</p><p>When I created the Recurring Invoices, (Transactions/Create and print recurrent tax invoices) select the invoice, modify and submit the invoice, the option screen then gives you option to Prit, email etc. I then click email Invoice, It does nothing.</p><p>When I go to (Inquiries and Reports/Customer transaction enquiry/) and select the invoice to edit the invoice, save and then click email invoice, it sends the email invoice just fine. </p><p>I cannot get it figured out, why a it is not sending the email under recurring invoices. Will this be two separate functions, that the one is working and the other one not.</p>]]></description>
			<author><![CDATA[null@example.com (seahawk)]]></author>
			<pubDate>Fri, 09 Nov 2018 07:05:11 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=33209#p33209</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32807#p32807</link>
			<description><![CDATA[<p>@seahawk - The email invoice is working and sent email. Probably, enable debugging mode and check the email functionality. <br />&nbsp; Try this directly.</p><p>FA url and add&nbsp; this url string, and check it </p><p>reporting/prn_redirect.php?PARAM_0=15-10&amp;PARAM_1=15-10&amp;PARAM_2=&amp;PARAM_3=1&amp;PARAM_4=0&amp;PARAM_5=&amp;PARAM_6=1&amp;REP_ID=107</p><p>Here 15 is sales invoice number. I feel the SMTP blocks, if the server enabled ssl, the email functionality may not work properly.</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Tue, 02 Oct 2018 13:48:39 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32807#p32807</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32801#p32801</link>
			<description><![CDATA[<p>Not the case. It does not even indicate that it is sent after creation via recurring invoices. <br />When redone through either reports or change of invoice and submit and then emailed it goes through in both cases.</p><p>If the SMTP was blocked then no emails will be received or send outside of the recurring invoices either.</p>]]></description>
			<author><![CDATA[null@example.com (seahawk)]]></author>
			<pubDate>Tue, 02 Oct 2018 13:08:28 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32801#p32801</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32796#p32796</link>
			<description><![CDATA[<p>There are two more possibilities,<br />&nbsp; &nbsp;* The email might reach junk or spam folder of your email <br />&nbsp; &nbsp;* The SMTP blocked to send emails</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Tue, 02 Oct 2018 11:42:44 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32796#p32796</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32787#p32787</link>
			<description><![CDATA[<p>Hi nortinos</p><p>The system is on online server, and the customer&#039;s contacts are correct. </p><p>It worked on the 2.3 system before upgrade to 2.4.&nbsp; When the email invoice is selected, it does not show that the email was sent. It just remains blank. I just assumed that the email was send, but even I did not receive a copy. </p><p>On normal direct invoice, it sends the email as well as on reports, Invoices, email invoice.</p><p>There must e something else wrong with the recurrent invoices?</p><p>Regards</p>]]></description>
			<author><![CDATA[null@example.com (seahawk)]]></author>
			<pubDate>Tue, 02 Oct 2018 07:33:43 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32787#p32787</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32783#p32783</link>
			<description><![CDATA[<p>Prerequisites to send invoice email are:</p><p>- System is running on a online server, not localhost.<br />- Customer&#039;s contact must have an correct email.</p><p>If the two conditions are satisfied and system has no problem then email would be sent</p>]]></description>
			<author><![CDATA[null@example.com (notrinos)]]></author>
			<pubDate>Tue, 02 Oct 2018 06:16:24 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32783#p32783</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32781#p32781</link>
			<description><![CDATA[<p>I am struggling on 2.4.4 recurring invoice to email the invoice. It creates the invoice and print the invoice correctly, but when I click email invoice, nothing happens. I have to then go to invoices in reports&nbsp; and select the invoice to email or I must edit the invoice and emal again.</p><p>Cannot figure out why the invoice is not emailing after the repeating invoices was created.</p>]]></description>
			<author><![CDATA[null@example.com (seahawk)]]></author>
			<pubDate>Tue, 02 Oct 2018 05:58:19 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32781#p32781</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32724#p32724</link>
			<description><![CDATA[<p>got it work after empty comments table.</p>]]></description>
			<author><![CDATA[null@example.com (chunket)]]></author>
			<pubDate>Tue, 25 Sep 2018 09:23:56 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32724#p32724</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32723#p32723</link>
			<description><![CDATA[<p>C:\xampp53670\htdocs\frontaccounting\sales\includes\db\cust_trans_db.inc:213: &nbsp; &nbsp; display_backtrace()<br />C:\xampp53670\htdocs\frontaccounting\sales\includes\sales_db.inc:233: &nbsp; &nbsp; get_customer_trans(&#039;4&#039;,&#039;13&#039;)<br />C:\xampp53670\htdocs\frontaccounting\sales\includes\cart_class.inc:220: &nbsp; &nbsp; read_sales_trans(&#039;13&#039;,(Array[1]),(Cart Object))<br />C:\xampp53670\htdocs\frontaccounting\sales\includes\cart_class.inc:308: &nbsp; &nbsp; (Cart Object)-&gt;read(&#039;13&#039;,&#039;4&#039;,&#039;1&#039;)<br />C:\xampp53670\htdocs\frontaccounting\sales\create_recurrent_invoices.php:59: &nbsp; &nbsp; (Cart Object)-&gt;write(&#039;1&#039;)<br />C:\xampp53670\htdocs\frontaccounting\sales\create_recurrent_invoices.php:125: &nbsp; &nbsp; create_recurrent_invoices(&#039;4&#039;,&#039;4&#039;,&#039;1&#039;,&#039;2&#039;,&#039;02-08-2018&#039;,&#039;01-07-2018&#039;,&#039;02-07-2018&#039;,&#039;Recurrent Invoice covers period 01-08-2018 - 31-08-2018.&#039;)<br />DATABASE ERROR : duplicate debtor transactions found for given params<br />sql that failed was : SELECT trans.*,ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,cust.name AS DebtorName, cust.address, cust.curr_code, cust.tax_id, trans.prep_amount&gt;0 as prepaid,com.memo_, shippers.shipper_name, sales_types.sales_type, sales_types.tax_included, branch.*, cust.discount, tax_groups.name AS tax_group_name, tax_groups.id AS tax_group_id FROM debtor_trans trans LEFT JOIN comments com ON trans.type=com.type AND trans.trans_no=com.id LEFT JOIN shippers ON shippers.shipper_id=trans.ship_via, debtors_master cust, sales_types, cust_branch branch, tax_groups WHERE trans.trans_no=&#039;4&#039; AND trans.type=&#039;13&#039; AND trans.debtor_no=cust.debtor_no AND sales_types.id = trans.tpe AND branch.branch_code = trans.branch_code AND branch.tax_group_id = tax_groups.id </p><p>No luck to get it work. debtor_trans table is empty. i wondering why duplicate debtor transactions found.</p>]]></description>
			<author><![CDATA[null@example.com (chunket)]]></author>
			<pubDate>Tue, 25 Sep 2018 08:36:00 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32723#p32723</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32722#p32722</link>
			<description><![CDATA[<p>Debug mode database warning:<br />error code : 1054<br />error message : Unknown column &#039;0_loc_stock.reorder_level&#039; in &#039;where clause&#039;<br />sql that failed was : select stock_master.description, SUM(IF(stock_moves.stock_id IS NULL,0,stock_moves.qty)) AS QtyOnHand ,loc_stock.reorder_level FROM (stock_master, stock_category,loc_stock) LEFT JOIN stock_moves ON (stock_master.stock_id=stock_moves.stock_id) WHERE stock_master.category_id=stock_category.category_id AND stock_master.stock_id=loc_stock.stock_id AND (stock_master.mb_flag=&#039;B&#039; OR stock_master.mb_flag=&#039;M&#039;) AND 0_loc_stock.reorder_level!=0 GROUP BY stock_master.category_id, stock_category.description, stock_master.stock_id, stock_master.description ORDER BY QtyOnHand DESC</p>]]></description>
			<author><![CDATA[null@example.com (chunket)]]></author>
			<pubDate>Tue, 25 Sep 2018 07:25:10 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32722#p32722</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=32719#p32719</link>
			<description><![CDATA[<p>I follow the wiki guide but I cant get it work. Today date is 24, i put day=24 and month=1. But in Create and Print Recurrent Invoices didn&#039;t show anything. Can provide more example parameters? It doesn&#039;t need to use cron right? Some button will be show in Create and Print Recurrent Invoices page? I need a quick test. Please advise.</p>]]></description>
			<author><![CDATA[null@example.com (chunket)]]></author>
			<pubDate>Mon, 24 Sep 2018 10:18:54 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=32719#p32719</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=28286#p28286</link>
			<description><![CDATA[<p>I have tried the following to get advanced payments to work, and the system seems to accept it, but I would like to know if there are any unwanted implications:</p><p>I setup the recurrent invoice as normal, put 12 in the months field, but put -365 in the days field.&nbsp; The system then offers to produce invoices for the future year.&nbsp; However, I suspect the invoices would be dated on the day generated, which according to accounting principles, should be just fine.</p><p>Any suggestions?</p>]]></description>
			<author><![CDATA[null@example.com (trentdavis)]]></author>
			<pubDate>Thu, 27 Jul 2017 15:39:34 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=28286#p28286</guid>
		</item>
		<item>
			<title><![CDATA[Re: Release 2.1 - Recurrent Invoices. How to?]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=23656#p23656</link>
			<description><![CDATA[<p>So - recurring invoices in advance.&nbsp; How&#039;s this for a plan.</p><p>A tick box is added so that a recurring invoice is marked as being in advance.&nbsp; Then, in create_recurrent_invoices.php the message which is added to the comments depends on whether the tick box has been ticked or not.&nbsp; In arrears should show:</p><p>$doc-&gt;Comments .= sprintf(_(&quot;Recurrent Invoice covers period %s - %s.&quot;), $from, add_days($to, -1));</p><p>in advance should show:</p><p>$doc-&gt;Comments .= sprintf(_(&quot;Recurrent Invoice covers period from %s.&quot;), $to);</p><p>with hopefully the end date of the period being worked out as well.</p><p>Cheers,</p><p>Kevin</p>]]></description>
			<author><![CDATA[null@example.com (bailey86)]]></author>
			<pubDate>Mon, 08 Jun 2015 08:37:24 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=23656#p23656</guid>
		</item>
	</channel>
</rss>
