<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Tax Report and Inquiry Bug]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=9547&amp;type=atom" />
	<updated>2021-11-16T13:14:56Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=9547</id>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40251#p40251" />
			<content type="html"><![CDATA[<p>Yes sir @joe. Its working as expected. Thanks for your efforts.</p>]]></content>
			<author>
				<name><![CDATA[rafat]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41964</uri>
			</author>
			<updated>2021-11-16T13:14:56Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40251#p40251</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40250#p40250" />
			<content type="html"><![CDATA[<p>Fixed and committed to stable repo. Thanks for helping @rafat.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2021-11-16T11:53:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40250#p40250</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40249#p40249" />
			<content type="html"><![CDATA[<p>Ok, I see.<br />Will have a look. It is rather complex all these issues, however we will fix it.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2021-11-16T10:01:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40249#p40249</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40248#p40248" />
			<content type="html"><![CDATA[<p>One last thing @Joe and hopefully we will be out of the woods:<br />The tax within the QE in the Supplier Invoice (GL Items for this invoice) is accounted for in the report but in in the Inquiry.<br />So either we remove from Report or add to Inquiry. (I prefer add to Inquiry)...It depends of course on the requirement of different users.</p>]]></content>
			<author>
				<name><![CDATA[rafat]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41964</uri>
			</author>
			<updated>2021-11-16T09:11:46Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40248#p40248</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40247#p40247" />
			<content type="html"><![CDATA[<p>Tax Report (rep709.php) has been checked, tested and committed to stable repo.</p><p>/Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2021-11-16T07:29:57Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40247#p40247</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40246#p40246" />
			<content type="html"><![CDATA[<p>Yes, I guess I will have to check the rep709 again.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2021-11-16T05:32:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40246#p40246</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40245#p40245" />
			<content type="html"><![CDATA[<p>@Joe</p><p>The Tax report now shows Tax on Bank Payments, Customer Credit Notes ...etc. I believe this should not be the case because now the Inquiry and the Report don&#039;t tally. Of course I prefer these to be included but then both the Inquiry and Report should be the same.</p><p>I think we should stick to the previous version of rep709 if we are not introducing Tax on Bank Payments ..etc...</p>]]></content>
			<author>
				<name><![CDATA[rafat]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41964</uri>
			</author>
			<updated>2021-11-15T19:10:42Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40245#p40245</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40244#p40244" />
			<content type="html"><![CDATA[<p>This issue has now been fixed and committed to stable repo.</p><p>Joe</p>]]></content>
			<author>
				<name><![CDATA[joe]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=3</uri>
			</author>
			<updated>2021-11-15T17:02:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40244#p40244</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40230#p40230" />
			<content type="html"><![CDATA[<p>Hello guys, <br />I was bit stuck with temple consecration. I just&nbsp; checked it.&nbsp; You need to have additional condition during the time of creating journal entry. That will be the only way to fix it. Journal entry works for both sales and purchase, so input and output tax both handled inside one transaction.&nbsp; But you guys found an issue which we are not applying the conditions properly. </p><p>If you guys apply extra condition, which helps to fix this issue. Post it for the community welfare. And also check in the forum carefully. May be someone has solution in it already</p>]]></content>
			<author>
				<name><![CDATA[kvvaradha]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19348</uri>
			</author>
			<updated>2021-11-09T08:20:18Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40230#p40230</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40227#p40227" />
			<content type="html"><![CDATA[<p>I have problem this same issues. @kvvaradha could you help this?</p>]]></content>
			<author>
				<name><![CDATA[nagadev]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46040</uri>
			</author>
			<updated>2021-11-07T10:59:48Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40227#p40227</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Tax Report and Inquiry Bug]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=40226#p40226" />
			<content type="html"><![CDATA[<p>Tax Report Showing Negative Value<br />I am facing Two problem with Tax in FA<br />Problem Number 1.</p><p>when i use same Gl for both sales and purchase tax in tax setup like Sales Tax<br /> and enter the sales or purchase transaction through direct invoice&nbsp; <br />it shows correct in both tax inquiry as well as tax&nbsp; report<br />but when i post the&nbsp; voucher through journal entry</p><br /><p>Journal Date&nbsp; &nbsp; Account Code&nbsp; &nbsp; Account Name&nbsp; &nbsp; Dimension&nbsp; &nbsp; Debit&nbsp; &nbsp; Credit&nbsp; &nbsp; Memo<br />2021.11.07&nbsp; &nbsp; 2150&nbsp; &nbsp; Sales Tax&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; 1,300.00&nbsp; &nbsp; &nbsp; &nbsp; <br />2021.11.07&nbsp; &nbsp; 2100 00001&nbsp; &nbsp; Accounts Payable: a&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11,300.00&nbsp; &nbsp; <br />2021.11.07&nbsp; &nbsp; 5615&nbsp; &nbsp; Advertising &amp; Promotions&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; 10,000.00&nbsp; &nbsp; &nbsp; &nbsp; <br />Total&nbsp; &nbsp; &nbsp; &nbsp; 11,300.00&nbsp; &nbsp; 11,300.00&nbsp; &nbsp; </p><br /><p>Like this tax inquiry shows this <br />Where journal Transaction effects on both Charged on sales (Output Tax) and Paid on purchases (Input Tax):</p><p>Type&nbsp; &nbsp; Description&nbsp; &nbsp; Amount&nbsp; &nbsp; Outputs/Inputs<br />Tax 13%&nbsp; &nbsp; Charged on sales (Output Tax):&nbsp; &nbsp; 1,300.00&nbsp; &nbsp; 10,000.00<br />Tax 13%&nbsp; &nbsp; Paid on purchases (Input Tax):&nbsp; &nbsp; -1,300.00&nbsp; &nbsp; -10,000.00<br />Tax 13%&nbsp; &nbsp; Net payable or collectible:&nbsp; &nbsp; 0.00&nbsp; &nbsp; <br />&nbsp; &nbsp; Total payable or refund:&nbsp; &nbsp; 0.00&nbsp; &nbsp; </p><p>But tax report shows correct as per sales Gl<br />Now my question is how to fix this error so that tax inquiry will show the correct amount as per Tax GL</p><br /><br /><br /><p>Problem Number 2<br />when i use different&nbsp; Gl for&nbsp; both sales and purchase tax in tax setup like Sales Tax and Purchase Tax <br /> and enter the sales or purchase transaction through direct invoice&nbsp; <br />f<br />it shows correct in both tax inquiry as well as tax&nbsp; report<br />but when i post the&nbsp; voucher through journal entry<br />Journal Date&nbsp; &nbsp; Account Code&nbsp; &nbsp; Account Name&nbsp; &nbsp; Dimension&nbsp; &nbsp; Debit&nbsp; &nbsp; Credit&nbsp; &nbsp; Memo<br />2021.11.07&nbsp; &nbsp; 1200 00001&nbsp; &nbsp; Accounts Receivables: a1&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; 113,000.00&nbsp; &nbsp; &nbsp; &nbsp; <br />2021.11.07&nbsp; &nbsp; 2150&nbsp; &nbsp; Sales Tax&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13,000.00&nbsp; &nbsp; <br />2021.11.07&nbsp; &nbsp; 4010&nbsp; &nbsp; Sales&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100,000.00&nbsp; &nbsp; <br />Total&nbsp; &nbsp; &nbsp; &nbsp; 113,000.00&nbsp; &nbsp; 113,000.00&nbsp; &nbsp; </p><br /><p>It shows Correct in Tax Inquiry <br />Tax 13%&nbsp; &nbsp; Charged on sales (Output Tax):&nbsp; &nbsp; 13,650.00&nbsp; &nbsp; 105,000.00<br />Tax 13%&nbsp; &nbsp; Paid on purchases (Input Tax):&nbsp; &nbsp; -1,300.00&nbsp; &nbsp; -10,000.00<br />Tax 13%&nbsp; &nbsp; Net payable or collectible:&nbsp; &nbsp; 12,350.00&nbsp; &nbsp; <br />&nbsp; &nbsp; Total payable or refund:&nbsp; &nbsp; 12,350.00&nbsp; &nbsp; </p><br /><p>But in Tax Report<br />Tax Rate Outputs Output Tax Inputs Input Tax Net Tax<br />Exempt 0.00 0.00 0.00 0.00 0.00<br />Tax 13.00% -95,000.00 -12,350.00 -10,000.00 -1,300.00 -13,650.00<br />Total payable or refund -13,650.00</p><p>Journal Entry 001/2021&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2021.11.07 a1 a1 -100,000.00 13.00 -13,000.00 Tax<br />Sales Invoice 001/2021 &nbsp; &nbsp; &nbsp; &nbsp; 2021.11.07 a1 a1 &nbsp; &nbsp; 5,000.00 13.00 650.00 Tax<br />Supplier Invoice 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021.11.07 a &nbsp; &nbsp; &nbsp; &nbsp; -10,000.00 13.00 -1,300.00 Tax<br />The amount we enter Through Journal Entry of Sales Has been displayed in Negativ Value which is -100000</p>]]></content>
			<author>
				<name><![CDATA[yubrajkafle99]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41884</uri>
			</author>
			<updated>2021-11-07T10:42:27Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=40226#p40226</id>
		</entry>
</feed>
