<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — The deferred income GL posting could not be inserted]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=10581</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=10581&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in The deferred income GL posting could not be inserted.]]></description>
		<lastBuildDate>Wed, 10 Sep 2025 20:44:19 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43757#p43757</link>
			<description><![CDATA[<p>This is happening&nbsp; Have a look at this entry. </p><p>Account code - account name -&nbsp; &nbsp; &nbsp; debit -&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; credit&nbsp; &nbsp;-&nbsp; &nbsp;Memo<br />4011&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; annual fee&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120.00&nbsp; &nbsp; <br />2105&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Deferred Income&nbsp; 120.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;The deferred income GL posting could not be inserted</p><p>Shouldn&#039;t there be a GL posting and a 120.00 credit to negate the 120.00 debit, so that the deferred income reduces as items are delivered.</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Wed, 10 Sep 2025 20:44:19 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43757#p43757</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43756#p43756</link>
			<description><![CDATA[<p>OK so I thought this wasn&#039;t going to be a problem but now that I have reached the year end and I print the reports I can see that although the payments were received as deferred and then the item was actually distributed (subscription), <br />the deferred payments are still on the books so that I have deferred payments cancelling out the sales revenue. Is that correct. The assets are still correct in the bank account. Shouldn&#039;t those deferred payments be reversed once received.&nbsp; <br />I sure would appreciate help on this one.<br />It also looks like the deferred income keeps growing from year to year. Shouldn&#039;t it clear out?</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Wed, 10 Sep 2025 20:17:01 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43756#p43756</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43322#p43322</link>
			<description><![CDATA[<p>The code seems to be:</p><div class="codebox"><pre><code> if ($delivery-&gt;is_prepaid())
        {
                $deferred_act = get_company_pref(&#039;deferred_income_act&#039;);
                add_gl_trans(ST_CUSTDELIVERY, $delivery_no, $delivery-&gt;document_date, $deferred_act, 0, 0, 
                        &quot;The deferred income GL posting could not be inserted&quot;,
                        -$total, null, PT_CUSTOMER, $delivery-&gt;customer_id);
        }</code></pre></div><p>and to me that looks like this is just what gets entered into all prepaid items. So it&#039;s part of normal behaviour. <br />I would still like to know why it&#039;s worded like that. When one reads that it feels like it&#039;s an error.</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Fri, 16 Aug 2024 17:17:14 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43322#p43322</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43321#p43321</link>
			<description><![CDATA[<div class="quotebox"><cite>joe wrote:</cite><blockquote><p>Hard to tell. It has to be investigated. The $go_debug variabel should give us some clues. Please continue.</p><p>Joe</p></blockquote></div><p>That variable was set and that&#039;s how I got the error that I posted just before your message.</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Fri, 16 Aug 2024 17:09:10 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43321#p43321</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43320#p43320</link>
			<description><![CDATA[<p>This doesn&#039;t make any sense to me.&nbsp; There are no errors unless I do a report and I rarely need to do one. I don&#039;t even know what &quot;The deferred income GL posting could not be inserted&quot; means in the memo area of the deferred income account.&nbsp; Does nobody know why that message would be inserted into the memo area of all prepayments. <br />I guess I&#039;m also having trouble understanding how the prepayment and deferred income works.&nbsp; When I look at the trial balances after the prepayments, I see the items in the deferred income, and also in the sales revenue account that the sales related to. But how does the deferred income know what year it is deferred to. I would have thought that it was the delivery date. And if so, why is it still sitting in the deferred income account. Do I need to move it around manually???</p><p>EDIT: OOPS!, so I do see that the prepayment did set the Delivery date correct (I marked it as delivered on the first day of the next fiscal). And the income account does show the items going into the revenue account on the date I set (first day of the next fiscal). So that all seems to be working (I think). I&#039;m just not understanding why I would see that message in the memo field.&nbsp; Could it be designed to do that and it is working properly??? I&#039;m not a developer and so I can&#039;t really debug this on my own.</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Fri, 16 Aug 2024 16:47:21 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43320#p43320</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43319#p43319</link>
			<description><![CDATA[<p>Hard to tell. It has to be investigated. The $go_debug variabel should give us some clues. Please continue.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Fri, 16 Aug 2024 15:32:08 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43319#p43319</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43318#p43318</link>
			<description><![CDATA[<p>Try to do the same transaction in a fresh install of FA in PHP 5.x and MySQL 5.1 and you will note that NULL implementation and argument order may expose causes.</p><p>Lines 756-759 in <strong>reporting/includes/pdf_report.inc</strong> are:<br /></p><div class="codebox"><pre><code>    function TextCol($c, $n, $txt, $corr=0, $r=0, $border=0, $fill=0, $link=NULL, $stretch=1)
    {
        return $this-&gt;TextWrap($this-&gt;cols[$c], $this-&gt;row - $r, $this-&gt;cols[$n] - $this-&gt;cols[$c] + $corr, $txt, $this-&gt;aligns[$c], $border, $fill, $link, $stretch);
    }</code></pre></div><p>The above function has not changed in 15 years.<br />However in 2 places in the said file certain PHP 8.1 issues caused a change 2 years ago for the likes of:<br /></p><div class="codebox"><pre><code>$str = ($str != NULL ? strtr($str, array(&quot;\r&quot;=&gt;&#039;&#039;)) : &quot;&quot;);</code></pre></div><p>which may have to be revisited.</p><p>The function / method <strong>TextWrap</strong> is also defined in the same file (changed for PHP 8.1, <strong><a href="https://github.com/FrontAccountingERP/FA/commit/017f59aff3a7c74d7eb32cb93d343d5d6eb7cd20#diff-415e6963cf831190a4b10702ea913dcdc620c12e7a2d7715adf922662bfa5243">2 years ago</a></strong>) whilst the function / method <strong>addTextWrap</strong> called therefrom is defined in the file <strong>reporting/includes/class.pdf.inc</strong>.</p><p>Check if there are any PHP version related changes between PHP 5 and 8.1 that cause this situation.</p><p>@joe: any clues?</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Fri, 16 Aug 2024 13:23:44 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43318#p43318</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43317#p43317</link>
			<description><![CDATA[<p>I am using php 8. 11.2.4-MariaDB. But does that error even have anything to do with the &quot;The deferred income GL posting could not be inserted&quot; that is shown in the memo of all deferred income payments.</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Wed, 14 Aug 2024 21:50:00 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43317#p43317</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43315#p43315</link>
			<description><![CDATA[<p>Which version of PHP and MySQL are you using? Looks like a PHP 8 issue where arguments for functions with default values are generally pushed to the end.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 14 Aug 2024 18:13:38 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43315#p43315</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43314#p43314</link>
			<description><![CDATA[<p>This is the only error that showed up (site name changed for security):</p><p>Undefined array key 9 in file: /home/admin/web/mysite.com/public_html/reporting/includes/pdf_report.inc at line 758<br />/home/admin/web/mysite.com/public_html/reporting/rep112.php:197:&nbsp; &nbsp; (FrontReport Object)-&gt;TextCol(&#039;1&#039;,&#039;9&#039;,&#039;Purchases for your Service Dog is Tax Deductible. Keep this Receipt&#039;,&#039;-2&#039;)<br />/home/admin/web/mysite.com/public_html/reporting/rep112.php:29:&nbsp; &nbsp; print_receipts()<br />/home/admin/web/mysite.com/public_html/reporting/prn_redirect.php:58:&nbsp; &nbsp; require(&#039;/home/admin/web/mysite.com/public_html/reporting/rep112.php&#039;)</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Wed, 14 Aug 2024 18:06:21 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43314#p43314</guid>
		</item>
		<item>
			<title><![CDATA[Re: The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43313#p43313</link>
			<description><![CDATA[<p>Turn debug to 2 in <strong>config.php</strong> and execute the transaction and post the results.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Wed, 14 Aug 2024 15:26:37 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43313#p43313</guid>
		</item>
		<item>
			<title><![CDATA[The deferred income GL posting could not be inserted]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=43312#p43312</link>
			<description><![CDATA[<p>I am wondering why I am seeing this error/warning. I have a deferred income account (liability). The setup shows that account in the setup window for deferred income.&nbsp; <br />-I placed an order and set the payment to a prepayment &quot;prepay to next fiscal&quot; . <br />-I then did invoice prepaid orders. The dates on the sales order and the payments are today&#039;s date.&nbsp; <br />-I did a delivery and set the date to the first day of the next fiscal. The sales item is a membership fee and no product is transferred.&nbsp; <br />-When I look at the Trial balances for the defered income account it show that message. <br />What am I doing wrong?</p>]]></description>
			<author><![CDATA[null@example.com (baxterdmutt)]]></author>
			<pubDate>Tue, 13 Aug 2024 17:16:25 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=43312#p43312</guid>
		</item>
	</channel>
</rss>
