<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — incorrect customer balance after Cash collection transactions]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=9542</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9542&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in incorrect customer balance after Cash collection transactions.]]></description>
		<lastBuildDate>Fri, 05 Nov 2021 09:18:09 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40220#p40220</link>
			<description><![CDATA[<p>You can push the codes to github and share it to Joe or itronics,&nbsp; </p><p>They will further review the code. Or speak with cambell or Andrews,&nbsp; who worked initially&nbsp; to connected them to push the contribution the github. </p><p>Or you can speak with apmuthu, who actually maintains separate repository for it. Either way it&#039;s good to go with existing developers..</p>]]></description>
			<author><![CDATA[null@example.com (kvvaradha)]]></author>
			<pubDate>Fri, 05 Nov 2021 09:18:09 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40220#p40220</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40212#p40212</link>
			<description><![CDATA[<p>Great! I&#039;m now nearly Finished with the (Allocate Customer payments) Api also </p><p>just testing it to make sure it works with no problems</p><p>please tell me where you want me to push and I&#039;m reedy</p>]]></description>
			<author><![CDATA[null@example.com (DrCard)]]></author>
			<pubDate>Thu, 04 Nov 2021 14:53:30 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40212#p40212</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40211#p40211</link>
			<description><![CDATA[<p>You are welcome and thanks.</p><p>I have nothing to do with the api. I don&#039;t recall who is maintaining this.<br />We will try to CALL for him, please.<br />So the author of the API, please help us with Mr. DrCard&#039;s contribution.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Thu, 04 Nov 2021 10:36:20 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40211#p40211</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40210#p40210</link>
			<description><![CDATA[<p>Thank you so much Mr Joe&nbsp; &#039;Allocate Customer payments&#039; fully did the job nicely now i have to do it throw API </p><p>i have made Purchase (suppliers) &amp; edit/delete APIs if you like i can push them in a git if you like , i have fully tested them and they are working fine</p>]]></description>
			<author><![CDATA[null@example.com (DrCard)]]></author>
			<pubDate>Thu, 04 Nov 2021 09:36:15 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40210#p40210</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40207#p40207</link>
			<description><![CDATA[<p>I will try to make things a little more clear.</p><p>You started with a Journal Entry with 40 Cr.<br />This is handled as some kind of a pre payment. Your customer owes this money. Hasn&#039;t got any services yet.<br />Then you invoiced a 10.<br />Instead of using the customer payment you could use the pre payment for allocating the invoice in the menu &#039;Allocate Customer payments ...&#039;.<br />You still have 30 Cr, on the pre payment so this can also be used for allocating the second invoice.</p><p>I hope you see this. You have been overpaid by your customer.</p><p>Regarding the Balance of -40 is that your customer owes it. Thats the reason it is in minus.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 03 Nov 2021 16:31:50 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40207#p40207</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40206#p40206</link>
			<description><![CDATA[<p>@DrCard</p><p>Your discussion is right until <br />&#039;once paid the customer balance....&#039;<br />You still haven&#039;t allocated the -40 that was booked in the Journal Entry.<br />They should not be paid (it is already some kind of payment). They should instead be used for allocation as I told in my former answer.<br />I can understand that this is tricky to see, but this is the way it is done. </p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 03 Nov 2021 16:00:17 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40206#p40206</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40205#p40205</link>
			<description><![CDATA[<p>Thank you Joe for the reply </p><br /><p>this is the entry for the $40 that is Credited to account receivable under customer account in this case KK.</p><p><a href="https://ibb.co/BZkBJkH">https://ibb.co/BZkBJkH</a></p><p>as you can see we took $50 the order price is $10 USD and we Credited the customer account with $40 as in the report we have to pay $40 to the customer -$40 is showing in the report </p><p><a href="https://ibb.co/TqtfCH7">https://ibb.co/TqtfCH7</a></p><p>The second order is $10 as there is no money to be collected just the order fee. </p><p><a href="https://ibb.co/02wC8bJ">https://ibb.co/02wC8bJ</a></p><p>as you can see that the $10 is Debited to the customer account and the balance amount is correct.</p><p><a href="https://ibb.co/FW9kcmK">https://ibb.co/FW9kcmK</a></p><p>the issue come when you go to customer payments as you can see the amount is still $10 balance on the customer </p><p><a href="https://ibb.co/tKTwnNS">https://ibb.co/tKTwnNS</a></p><p>once paid the Customer balance becomes -$40 again witch is incorrect </p><p><a href="https://ibb.co/h1cctLC">https://ibb.co/h1cctLC</a></p><p>i tried Credit note it adds to the outstanding and it still does not fix the second order Balance </p><p><a href="https://ibb.co/BVTPhtc">https://ibb.co/BVTPhtc</a></p><p>so if his balance was -$40 it will become -$50 after payment it processed</p><p><a href="https://ibb.co/sWZVZdR">https://ibb.co/sWZVZdR</a></p><p>Please post for me the entries if my way is incorrect to take off the $10 payment for the second order.<br />Thank you so much Joe</p>]]></description>
			<author><![CDATA[null@example.com (DrCard)]]></author>
			<pubDate>Wed, 03 Nov 2021 15:40:22 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40205#p40205</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40204#p40204</link>
			<description><![CDATA[<p>@DrCard</p><p>the Journal Entry Cr post of 40 is handled as a Payment (You are reducing the debt from the customer).<br />So everything is handled correctly.<br />You can use the Journal Entry with Cr 40 in &#039;Allocate Customer Payments or Credit Notes&#039; to allocate other debts.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Wed, 03 Nov 2021 14:30:47 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40204#p40204</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40202#p40202</link>
			<description><![CDATA[<p>It would be great if a CPA chimed in on this and described the proper way to deal with this.</p>]]></description>
			<author><![CDATA[null@example.com (ScriptBASIC)]]></author>
			<pubDate>Wed, 03 Nov 2021 10:25:04 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40202#p40202</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40201#p40201</link>
			<description><![CDATA[<div class="quotebox"><cite>joe wrote:</cite><blockquote><p>This bug is related to Mantis Bug 5510 on Mantis. Fixed a couple of days ago.</p><p>Please download /sales/includes/db/custalloc_db.inc <a href="https://sourceforge.net/p/frontaccounting/git/ci/master/tree/sales/includes/db/custalloc_db.inc">here</a>.<br />And please download /reporting/rep108.php <a href="https://sourceforge.net/p/frontaccounting/git/ci/master/tree/reporting/rep108.php">here</a>.</p><p>Replace the files and you should be running ok.</p><p>Joe</p></blockquote></div><p>Still same issue </p><p>this is what i did </p><p>First Order Amount to be collected $50 from end customer. Fees $10.</p><p>Direct Invoice -&gt; made an invoice of $10. Payment terms -&gt; due within 10 days.<br />input an address and I have -&gt; placed invoice.</p><p>Sales -&gt; Customer Payments. This allocation which is for invoice -&gt; All -&gt; Add Payment </p><p>Banking and General Ledger -&gt; Journal Entry -&gt; Account : Checking account Dr. 40 -&gt; Add Item -&gt; Account: Account receivable -&gt; Counter Party (Customer) -&gt; Cr. 40 -&gt; Process Journal Entry.</p><p><a href="https://ibb.co/qmx5wdr">https://ibb.co/qmx5wdr</a></p><p>Second Order No Amounts to be collected from end customer. Fees $10.</p><p>Direct Invoice -&gt; made an invoice of $10. Payment terms -&gt; due within 10 days.<br />input an address and I have -&gt; placed invoice.</p><p><a href="https://ibb.co/c38W80G">https://ibb.co/c38W80G</a></p><p>Before second payment the Customer balance Report is correct but the payment is still outstanding in sales&gt; customer payments.<br /> So, if I want to clear this payment (second payment) the customer balance report will become incorrect. it should reconcile with the customer balance from the beginning which is the $40 that is in the customer account. As in with the customer balance report it becomes $ -30 and the payment is still pending.<br />If I do the payment, the balance changes back to $ -40.</p><p><a href="https://ibb.co/ZMg8PJM">https://ibb.co/ZMg8PJM</a></p><p>so the bug is still there </p><p>Regards</p>]]></description>
			<author><![CDATA[null@example.com (DrCard)]]></author>
			<pubDate>Wed, 03 Nov 2021 09:21:05 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40201#p40201</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40196#p40196</link>
			<description><![CDATA[<p>thank you so much <br />ill download it and tell you how its goes </p><p>Regards</p>]]></description>
			<author><![CDATA[null@example.com (DrCard)]]></author>
			<pubDate>Tue, 02 Nov 2021 04:38:09 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40196#p40196</guid>
		</item>
		<item>
			<title><![CDATA[Re: incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40195#p40195</link>
			<description><![CDATA[<p>This bug is related to Mantis Bug 5510 on Mantis. Fixed a couple of days ago.</p><p>Please download /sales/includes/db/custalloc_db.inc <a href="https://sourceforge.net/p/frontaccounting/git/ci/master/tree/sales/includes/db/custalloc_db.inc">here</a>.<br />And please download /reporting/rep108.php <a href="https://sourceforge.net/p/frontaccounting/git/ci/master/tree/reporting/rep108.php">here</a>.</p><p>Replace the files and you should be running ok.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Mon, 01 Nov 2021 21:37:41 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40195#p40195</guid>
		</item>
		<item>
			<title><![CDATA[incorrect customer balance after Cash collection transactions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=40193#p40193</link>
			<description><![CDATA[<p>Main Post here<br /><a href="https://frontaccounting.com/punbb/viewtopic.php?pid=40192#p40192">https://frontaccounting.com/punbb/viewt … 192#p40192</a></p><p>I run a delivery service which is collecting money from customers, I charge my clients 10$, the clients charge his customers $50 for the items being delivered by my company.</p><p>I invoice the client $10 and I have $50 cash in hand which will be deposited in my bank account.&nbsp; I reconcile the $10&nbsp; from the $50 and pay the client $40&nbsp; however we have remaining $10 in customers payments to allocate in the system and by doing so. we will have incorrect customer balance.</p><p>*how the we did the entry&#039;s</p><p>Direct Invoice the $10 then Receive the $50 ...Go<br />Banking and General Ledger -&gt;Journal Entry</p><p>Journal Date&nbsp; &nbsp; Account Code&nbsp; &nbsp; Account Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Debit&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Credit&nbsp; &nbsp; &nbsp; Memo<br />01/11/2021&nbsp; &nbsp; 1060&nbsp; &nbsp; Checking Account&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50.00&nbsp; &nbsp; &nbsp; &nbsp;<br />01/11/2021&nbsp; &nbsp; 1200 00001&nbsp; &nbsp; Accounts Receivables: Donald Easter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10.00&nbsp; &nbsp;<br />01/11/2021&nbsp; &nbsp; 2100 00001&nbsp; &nbsp; Accounts Payable: Dino Saurius&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40.00&nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50.00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50.00</p><p>Before second Payment <br /><a href="https://ibb.co/b5LpQvK">https://ibb.co/b5LpQvK</a> customer balance correct<br /><a href="https://ibb.co/pWNyS5g">https://ibb.co/pWNyS5g</a> remaining for the customer to pay (shouldn&#039;t be anything left)</p><p>After second Payment <br /><a href="https://ibb.co/4gyd4SR">https://ibb.co/4gyd4SR</a> customer Balance Incorrect</p><p>as kvvaradha said we need to fix the code </p><p>any suggestion or help in how to fix this bug</p>]]></description>
			<author><![CDATA[null@example.com (DrCard)]]></author>
			<pubDate>Mon, 01 Nov 2021 20:14:32 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=40193#p40193</guid>
		</item>
	</channel>
</rss>
