<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Banking and General Ledger]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=25&amp;type=atom" />
	<updated>2024-03-13T20:29:29Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/index.php</id>
		<entry>
			<title type="html"><![CDATA[Edit Journal -> orphaned attachments.]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10489&amp;action=new" />
			<summary type="html"><![CDATA[<p>FA 2.4.1 - If you create a journal entry, attach a document, and then later edit the journal entry (e.g. journal enquiry - edit), the old journal number is voided, and a new journal number created.&nbsp; However, the attachment data is NOT updated, so the document is orphaned, and the journal no longer is associated to the document, so doesn&#039;t list it for viewing.</p><p>The FIX:&nbsp; (in gl/gl_journal.php)<br />Line 298:<br />if (isset($_POST[&#039;Process&#039;]))<br />{<br />&nbsp; &nbsp; &nbsp; &nbsp; $cart = &amp;$_SESSION[&#039;journal_items&#039;];<br />&nbsp; &nbsp; &nbsp; &nbsp; $new = $cart-&gt;order_id == 0;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /***************<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * Start of fix for orphaned attachments<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ***************/<br />&nbsp; &nbsp; &nbsp; &nbsp; $old_trans_type = $cart-&gt;trans_type;<br />&nbsp; &nbsp; &nbsp; &nbsp; $old_trans_no = $cart-&gt;order_id;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /***************/</p><p>new line 342:<br />&nbsp; &nbsp; &nbsp; &nbsp; unset($_SESSION[&#039;journal_items&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /*********************************************<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * original code does not update attachments.<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * The old trans no is zero&#039;d/marked voided and a new trans created<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * This leads to an orphaned transaction.&nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; *<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * Update attachment info<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ***********************************************/<br />&nbsp; &nbsp; &nbsp; &nbsp; if( isset( $old_trans_no ) )<br />&nbsp; &nbsp; &nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;UPDATE &quot; . TB_PREF . &quot;attachments SET `trans_no` = &#039;&quot; . $trans_no . &quot;&#039; WHERE trans_no = &#039;&quot; . $old_trans_no . &quot;&#039; and type_no = &#039;&quot; . $old_trans_type . &quot;&#039;&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; db_query( $sql, &quot;Couldn&#039;t update attachments&quot; );<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /***************/</p><p>I have not checked the other functions (i.e. bank payments/deposits, etc) but expect they are similar.&nbsp; I did see void_transaction function then calls different void_XXX_trans functions so didn&#039;t chase down the rabbit hole.&nbsp; If they all call the db HOOKs calls this could be made into a module but I didn&#039;t chase that neither.</p>]]></summary>
			<author>
				<name><![CDATA[fraserks]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41872</uri>
			</author>
			<updated>2024-03-13T20:29:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10489&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Closing equity accounts for start of new year]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10448&amp;action=new" />
			<summary type="html"><![CDATA[<p>I have two equity accounts for recording federal and state taxes paid throughout the year.&nbsp; During the year end closing for 2023 these accounts were not zeroed out.&nbsp; It seems logical to me that these accounts should have a zero balance for the new year, but I&#039;m not sure.&nbsp; If it is OK to zero these accounts what is the appropriate GL account to use for the credit entry?</p>]]></summary>
			<author>
				<name><![CDATA[diventi.enterprises]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42171</uri>
			</author>
			<updated>2024-01-05T19:36:50Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10448&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Bank Account Type]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10420&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi All<br />Anyone can help me, How to change Bank Account&nbsp; type Savings Account to Cash Account.</p>]]></summary>
			<author>
				<name><![CDATA[rahmanbd]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=43553</uri>
			</author>
			<updated>2023-11-24T13:19:53Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10420&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Print the payment, deposit and transfer transactions directly]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10406&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi</p><p>As a contribution for this forum included the customization files to print the transaction directly when you register the payment, deposit and transfer operations.</p><p>For those who are interested insert the files into this path:</p><p>/gl/gl_bank.php<br />/gl/bank_transfer.php</p>]]></summary>
			<author>
				<name><![CDATA[Rmendez]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=40570</uri>
			</author>
			<updated>2023-11-09T20:18:00Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10406&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Pricing exclusive of taxes in Sales Quote, Trial Balance adjustments]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10400&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi, </p><p>I made few modifications in the ERP, I edited sales quotation, altered the unit price as exclusive of taxes and then added the taxes in the at the sub total. This alteration disturbed the tax calculation at the backed, then I edited the tax calculation formula in tax_calc.php file, Now it calculates the tax correctly but the other features and modules of the ERP are still assuming that my prices are inclusive of tax and due to this I am facing issues in GL accounts (i.e Sales Revenue, Sales, Receivables &amp; etc). </p><p>Now here i think that I should not have edited the sales quotation in this way.<br />Is there any other way to create sales quotation mentioning unit prices exclusive of tax?<br />Or anyone can guide me to edit entire calculations in the GL.</p><p>Thanks</p>]]></summary>
			<author>
				<name><![CDATA[humzazahed]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=47529</uri>
			</author>
			<updated>2023-11-06T15:27:40Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10400&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Fail to enter new Journal Entry]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10392&amp;action=new" />
			<summary type="html"><![CDATA[<p>It&#039;s maybe a more general problem.</p><p>The problem started at a go with two different installations of FA concerning 2 different non-profit NGOs.</p><p>On screen you see the little triangle that shows a problem there, but no explanation&nbsp; what is the problem.</p><p>It worked for 2 years, suddenly it stopped in one day. Accountants are confused.</p><p>/edited from here/</p><p>I changed php to 8.0 (8.1 works with fs similarly), that is when problem started. Now now I changed the php back to older version and it is ok now.</p>]]></summary>
			<author>
				<name><![CDATA[esh.okela]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=47520</uri>
			</author>
			<updated>2023-10-26T02:19:21Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10392&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Edit option is disabled for Bank Payment]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10385&amp;action=new" />
			<summary type="html"><![CDATA[<p>By mistake I have made one bank payment, now when i try to edit or void transactions, system is not allowing me to edit or void. </p><p>The selected transaction was closed for edition and cannot be voided.</p><br /><p>Screenshot attached.</p>]]></summary>
			<author>
				<name><![CDATA[fsharif630]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=46626</uri>
			</author>
			<updated>2023-09-27T12:05:49Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10385&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Unnecessary payment entry having the same debit and credit account]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10361&amp;action=new" />
			<summary type="html"><![CDATA[<p>A) Our first transaction is created in Sales - Direct Invoice- Direct Sales Invoice<br />&nbsp; &nbsp; Payment set is -Cash Only<br />&nbsp; &nbsp; Cash account set is -Bank account<br />&nbsp; &nbsp; We have a direct cash revenue collection amounting to 100</p><p>After we placed the invoice, below are the generated journal entries when looking into the General Ledger Inquiry of our bank account </p><p>1) Sales Invoice journal entry (OK) <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bank account (debit) 100 <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Revenue (credit) 100&nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />2) Customer Payment journal entry (take note below of the same debit and credit bank account created that is Unnecessary)<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bank account (debit) 100&nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bank account (credit) 100 </p><br /><p>B)Our second transaction&nbsp; is created in Purchases-&nbsp; Direct Supplier Invoice - Direct Purchase Invoice Entry</p><p>Payment set is – Bank account and not Delayed<br />We have a direct cash payment purchase transaction amounting to 200</p><p>After we placed the invoice, below are the generated journal entries when looking into the General Ledger Inquiry of our bank account</p><p>1) Supplier Invoice journal entry (OK)<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Expense account (debit) 200&nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bank account (credit) 200 <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />2) Supplier Payment journal entry (take note below of the same debit and credit bank account created that is Unnecessary )<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bank account (debit) 200&nbsp; &nbsp; &nbsp;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bank account (credit) 200 </p><p>We notice that both journal entry marked as 2) that was created using separate transaction in Direct Sales Invoice Direct Purchase Invoice Entry&nbsp; have the same debit and credit bank account which is unnecessary and will create only an additional file.&nbsp; &nbsp;How can we make the system not to create the said unnecessary payment entry 2) for each separate transaction in&nbsp; Direct Sales Invoice and Direct Purchase Invoice. Thanks</p>]]></summary>
			<author>
				<name><![CDATA[Marc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=9423</uri>
			</author>
			<updated>2023-08-27T11:22:27Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10361&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[how i can]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10351&amp;action=new" />
			<summary type="html"><![CDATA[<p>How do I prevent the modification of the daily entries after the entry from the powers of the users without the need to close the transactions, as well as how do I grant the authority to search in the inventory items, suppliers and accounts without giving the authority to add items or add suppliers or edit the general ledger accounts</p>]]></summary>
			<author>
				<name><![CDATA[sulheen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42785</uri>
			</author>
			<updated>2023-08-23T22:41:48Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10351&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Tax Report Help needed]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10332&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi all,</p><p>Sorry to create a new post but it seems most topics on the tax reports have been locked down and not sure if they&#039;ve been fully resolved, I say this because there was a working soclution which seems to have disappered in recent relesases.</p><p>I did try to follow up <a href="https://frontaccounting.com/punbb/viewtopic.php?pid=29845#p29845">here</a>&nbsp; But, not update.</p><p>Then <a href="https://frontaccounting.com/punbb/viewtopic.php?pid=42353#p42353">here</a> but, again no update.</p><p>Not sure if there has been a solution to this which I haven&#039;t found on the forum but, I would really be grateful as it helps most of us working from EU to file our VAT correct.</p><p>@Joe, I believe a previous version of rep709 did list out all the taxes including the ones which were created with 0% in &#039;taxes&#039; and included/exempted in tax group/items respectively.</p><p>For taxes to appear on the report you had to not select them in the &#039;tax group&#039;, though the 0% tax was created in &#039;taxes&#039;</p><p>I hope someone points me to a solution if already discussed.</p><p>Currently I only get Supplier invoices which are all taxed at 20%.<br />My sales invoices which are zero rates don&#039;t show up at all.<br />I have setup all the taxes correctly, even the 0% one and assigned it to relevant customers.</p><p>(edit)Another bug in the tax report is when the vat entries as posted via journal entry feature. If a business bought something and wants to expense it using journal entry, the vat amount entered in this entry is not captured within tax reporting, effectively missing out on vat savings. This was never reported in any version of rep709 from my memory.</p><p>Having made this work before it is more frustating to lose the solution.</p>]]></summary>
			<author>
				<name><![CDATA[gj6n68]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=21080</uri>
			</author>
			<updated>2023-07-27T17:27:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10332&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[how to use tag properly on dimension and account]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10278&amp;action=new" />
			<summary type="html"><![CDATA[<p>how to use tag properly on dimension and account</p>]]></summary>
			<author>
				<name><![CDATA[sulheen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42785</uri>
			</author>
			<updated>2023-04-27T20:19:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10278&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Cannot post to GL account used by more than one tax type]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10216&amp;action=new" />
			<summary type="html"><![CDATA[<p>I made a quick entries and during its payment in Bank Account Payment Entry the error appear &quot;Cannot post to GL account used by more than one tax type&quot;</p><p>How can I bypass this, the reality is that I indeed and need to post to GL account used by more than one tax type.</p><p>Please help what file I need to modify.</p>]]></summary>
			<author>
				<name><![CDATA[Marc]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=9423</uri>
			</author>
			<updated>2023-03-06T03:32:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10216&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Date not accepted]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10205&amp;action=new" />
			<summary type="html"><![CDATA[<p>I am using FrontAccounting 2.4.14. </p><p>Any date that I enter is not accepted. There is no message, it just stays on the entry. The date shows in red.</p><p>I have tried changing the fiscal year, and using dates in and out of the fiscal year, to no avail. Only the current fiscal year is open.</p><p>Any suggestions?</p>]]></summary>
			<author>
				<name><![CDATA[daryl51]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41685</uri>
			</author>
			<updated>2023-02-22T12:49:49Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10205&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[How to clean up old dandruff and past errors from closed years]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10181&amp;action=new" />
			<summary type="html"><![CDATA[<p>I have been using FA for about 10 years now.&nbsp; As I have upgraded, learned what the hell I was doing, changed my procedures, and generally used the system, there has been a slow accumulation of errors that I would like to somehow purge.&nbsp; </p><p>Off the top of my head:<br />- Unallocated payments<br />- unreconciled bank transactions<br />- default bank reconciling starting balances </p><p>I have items that are up to 10 years old that still show up (but are locked because the years are long closed) that I would like to make go away.<br />Any ideas?<br />Thanks</p>]]></summary>
			<author>
				<name><![CDATA[brucek@pelhamhs.org]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=41547</uri>
			</author>
			<updated>2023-02-07T14:59:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10181&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Bank Payments and Deposits Entry - Double memo fields]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10110&amp;action=new" />
			<summary type="html"><![CDATA[<p>On the Banking and General Ledger / Bank Payments screen, the inline item where you add the Account/ Dimension/ Amount/ Memo/ and add Item has a problem in the Bank recon tab.&nbsp; I think this line item must be Person/Item and not memo. There is already a memo block at the bottom of the line transactions.</p><p>When you do the bank reconciliation and the banking reports, the inline memo item (Person/Item) is not displayed at all within the bank reconciliation. If you have entered something in the separate memo block, that will be displayed in the bank reconciliation. </p><p>The same is true in Bank Deposits. Also, two Memo items on the screen that I presume have an error when you do the reconciliation, VAT reports, and Bank Recon Report.</p><p>Unfortunately, I cannot upload screenshots here, which would have explained the situation better.</p><p>Would be appreciated if this can be fixed in future releases.</p>]]></summary>
			<author>
				<name><![CDATA[seahawk]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=544</uri>
			</author>
			<updated>2022-12-01T15:32:52Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10110&amp;action=new</id>
		</entry>
</feed>
