<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Reporting]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;fid=10&amp;type=atom" />
	<updated>2026-02-18T09:21:13Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/index.php</id>
		<entry>
			<title type="html"><![CDATA[Email Button for General Ledger and Other Financial Reports]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10711&amp;action=new" />
			<summary type="html"><![CDATA[<p>Dear FrontAccounting Team,</p><p>I would like to submit a feature request for consideration in a future version of FrontAccounting. Currently, I am using Version 2.4.19 (Build 07.11.2025), and while the system successfully sends emails for user registration and password reset through SMTP, there is no built-in option to email General Ledger or other financial reports directly from the reporting screen.</p><p>My suggestion is to add an “Email Report” button within the report output screen for reports such as General Ledger, Trial Balance, Profit and Loss, Balance Sheet, and similar financial statements. After generating a report and viewing it in PDF format, the user should have the option to click an “Email Report” button. Upon clicking, the system should prompt the user with a simple form asking for the recipient’s email address (and optionally subject and message body). Once submitted, FrontAccounting should automatically attach the generated PDF report and send it using the already configured SMTP settings.</p><p>This would significantly improve workflow efficiency, especially for companies that regularly send financial reports to accountants, auditors, directors, or branch managers. Currently, the process requires manually generating the PDF, downloading it, and then composing an email outside the system. Integrating this feature directly into the reporting module would save time and reduce repetitive manual steps.</p><p>Since SMTP configuration is already part of FrontAccounting and works correctly for system-generated emails, it seems technically feasible to extend this functionality to financial reports. The system already generates PDFs, so attaching them to an email would be a natural extension of existing capabilities.</p><p>This feature would enhance usability and make FrontAccounting more competitive with other accounting systems that allow direct emailing of financial reports. It would also maintain consistency with the existing email functionality available for sales invoices and statements.</p><p>Thank you for considering this request. I believe many users would find this enhancement valuable in their day-to-day operations.</p><p>Kind regards,<br />Shehroz Kaleem</p>]]></summary>
			<author>
				<name><![CDATA[xehroz]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44932</uri>
			</author>
			<updated>2026-02-18T09:21:13Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10711&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Custom PDF Header]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10709&amp;action=new" />
			<summary type="html"><![CDATA[<p>I can see there is a function in pdf_report.inc that includes some Customer Header Template from<br />/reporting/forms folder</p><div class="codebox"><pre><code>function NewPage() 
    {
        if ($this-&gt;pageNumber==0)
        {
            // check if there is pdf header template for this report
            // and set if it is found
            $tmpl_pdf = find_custom_file(&quot;/reporting/forms/&quot;.$this-&gt;headerTmpl.&quot;.pdf&quot;);
            if ($tmpl_pdf) {
                $this-&gt;tmplSize = $this-&gt;setSourceFile($tmpl_pdf);
            }
        }

        $this-&gt;pageNumber++;
        parent::newPage();

        if ($this-&gt;tmplSize) {
            $this-&gt;row = $this-&gt;pageHeight - $this-&gt;topMargin; // reset row
            $id = $this-&gt;importPage(min($this-&gt;pageNumber, $this-&gt;tmplSize));
            $this-&gt;useTemplate($id);
        }

        // include related php file if any
        $tmpl_php = find_custom_file(&quot;/reporting/forms/&quot;.$this-&gt;headerTmpl.&quot;.php&quot;);
        if ($tmpl_php) {
            include($tmpl_php);
        }

        if (method_exists($this, $this-&gt;headerTmpl))    // draw predefined page layout if any
            $this-&gt;{$this-&gt;headerTmpl}();
    }</code></pre></div><p>I am not sure How to use this If I add some custom header page in my module. Any help, ideas, sample?</p>]]></summary>
			<author>
				<name><![CDATA[boxygen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=20175</uri>
			</author>
			<updated>2026-02-08T10:14:30Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10709&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[PHPMailer]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10703&amp;action=new" />
			<summary type="html"><![CDATA[<p>https://github.com/apmuthu/FA24extensions/blob/master/Extensions/mail/class.mail.inc#L119</p><p>There is an error in line 119. The current line reads as follow:</p><p>$this-&gt;phpmailer-&gt;addAttachment($file);</p><p>This means that when you send an invoice you get an invoice number 4HvxRnbc6Ja138vRa_WRcQxx.pdf</p><p>When I change it to the Following: $this-&gt;phpmailer-&gt;addAttachment($file, $filename);</p><p>I get the correct Invoice number on the attachment InvoiceIN001809.pdf</p>]]></summary>
			<author>
				<name><![CDATA[seahawk]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=544</uri>
			</author>
			<updated>2026-01-12T14:31:37Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10703&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Modify the Invoice Table Content]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10663&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hello All,</p><p>Kudos to our developers. You guys are great. </p><p>I needed to modify the Invoice layout. I wanted to remove the Stock code from the invoice printout so that I am left with Item description, Quantity, Unit, Price &amp; Total while&nbsp; Code and discount is removed. </p><p>Can someone show me how to do this.</p><p>Thanks.</p><p>Popsicles12.</p>]]></summary>
			<author>
				<name><![CDATA[popsicles12]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=36</uri>
			</author>
			<updated>2025-05-14T13:32:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10663&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Backup file = Zero "0"]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10628&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hello All,<br />Happy New year everyone.<br />I just discovered that when I do my backup in FA, It backup fine. But when you look at the backup file, it is empty. Its Zero.</p><p>How do I correct this?</p><p>Popsicles12</p>]]></summary>
			<author>
				<name><![CDATA[popsicles12]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=36</uri>
			</author>
			<updated>2025-01-14T16:35:20Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10628&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Valuation Report unit cost question]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10627&amp;action=new" />
			<summary type="html"><![CDATA[<p>In my Valuation report (attached)</p><p>Acculap Pitch are always 13.73 but values range from 10.66 to 23.08</p><p>10.66 may have been a very old price for them...</p><p>I am not overly concerned how this happened, I just want to correct it moving forward.</p><p>Maybe it was wrong in the 10+ yr spam of usage database that I used to create my 2024 one...</p><p>I am looking at other issues, but it is likely if I can fix it for one item, that will allow me to fix them all</p><p>I assume that manufactured items get the value when they are manufactured, but I do not have a surplus, so those should correct over time.</p><p>Tom</p>]]></summary>
			<author>
				<name><![CDATA[tom]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=331</uri>
			</author>
			<updated>2025-01-12T13:44:47Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10627&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Costed Inventory Movements]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10626&amp;action=new" />
			<summary type="html"><![CDATA[<p>When I run the Costed Inventory Movements report I get some strange negative numbers for some items</p><p>The report is attached</p><p>How can I tell if these assumed values have totally corrupted my COGS?</p><p>I also attached my Valuation Report and it has a lot of wrong numbers.</p><p>The unit purchase pricing and reported unit cost are different, some time off by a lot.<br />How can I correct this?</p><p>I assume Unit Cost is used for COGS or Costed BOM for manufactured items.</p><p>Tom</p>]]></summary>
			<author>
				<name><![CDATA[tom]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=331</uri>
			</author>
			<updated>2025-01-12T12:02:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10626&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Refunding Sales Tax Paid Inadvertently by the Customer]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10621&amp;action=new" />
			<summary type="html"><![CDATA[<p>I am paying year end Sales Tax, but have a confusing situation.</p><p>I had a few customers pay tax that should not have this year.&nbsp; I would refund the Sales Tax with a Credit Note and Bank payment against the Sales Tax account.</p><p>When I run the Tax Report, however, it will only show tax refunded if a partial portion of an order or full order was refunded.&nbsp; Just refunding the Sales Tax through a credit note is not reflected on here.</p><p>Is there a separate Journal Entry that I should be using to make Sale Tax report reflect a Bank Payment/Credit Note to Sales Tax Payable?</p><p>I hope this makes sense.&nbsp; Thank you.</p>]]></summary>
			<author>
				<name><![CDATA[jeskremer]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=47694</uri>
			</author>
			<updated>2025-01-02T17:28:25Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10621&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Shipper Added to Sales Order]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10617&amp;action=new" />
			<summary type="html"><![CDATA[<p>OK, I&#039;ve spent a few hours on this already and can&#039;t figure it out.&nbsp; I&#039;ve looked at the wiki mentioned previously on this issue and scoured the database and search terms in the forums.</p><p>Here is what I have so far.&nbsp; What should be on the &quot;Shipping Method&quot; line to show the shipper_name?:</p><div class="codebox"><pre><code>case ST_SALESORDER:
            $this-&gt;title = ($this-&gt;params[&#039;print_quote&#039;] ? _(&quot;QUOTE&quot;) : ($this-&gt;formData[&#039;prepaid&#039;] ? _(&quot;PREPAYMENT ORDER&quot;) : _(&quot;SALES ORDER ACKNOWLEDGEMENT&quot;)));
            $this-&gt;formData[&#039;document_name&#039;] =_(&quot;Order Ackn. No.&quot;);
            $this-&gt;formData[&#039;document_date&#039;] = $this-&gt;formData[&#039;ord_date&#039;];
            $this-&gt;formData[&#039;document_number&#039;] = $SysPrefs-&gt;print_invoice_no() == 0 &amp;&amp; isset($this-&gt;formData[&#039;reference&#039;])
                ? $this-&gt;formData[&#039;reference&#039;] : $this-&gt;formData[&#039;order_no&#039;];
            $this-&gt;formData[&#039;document_amount&#039;] = $this-&gt;formData[&#039;order_no&#039;];

            $aux_info = array(
                _(&quot;Customer&#039;s Reference&quot;) =&gt; $this-&gt;formData[&quot;customer_ref&quot;],
                _(&quot;Sales Person&quot;) =&gt; get_salesman_name($this-&gt;formData[&#039;salesman&#039;]),
                _(&quot;Shipping Method&quot;) =&gt; $this-&gt;formData[&#039;shipper&#039;],
                _(&quot;Internal Order No&quot;) =&gt; $this-&gt;formData[&#039;order_no&#039;],
                _(&quot;Delivery Date&quot;) =&gt; sql2date($this-&gt;formData[&#039;delivery_date&#039;]),
            );
            break;</code></pre></div>]]></summary>
			<author>
				<name><![CDATA[jeskremer]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=47694</uri>
			</author>
			<updated>2024-11-30T19:29:43Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10617&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Alternative to RepGen]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10605&amp;action=new" />
			<summary type="html"><![CDATA[<p>I was trying to find an alternative to the old RepGen module and I came across <a href="https://www.reportico.org">Reportico</a>, finding it really interesting and powerful.</p><p>Does anyone ever consider reportico as a integrated module to build frontaccounting reports?</p>]]></summary>
			<author>
				<name><![CDATA[fburbano]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45139</uri>
			</author>
			<updated>2024-10-07T18:27:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10605&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[eInvoicing - Malaysia]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10600&amp;action=new" />
			<summary type="html"><![CDATA[<p>By 2025, e-Invoicing is to come into effect fully in Malaysia.</p><p>https://www.complyance.io/malaysia-blog/e-invoicing-malaysia-guide</p><p>There are some guides for eCommerce in general at:<br />https://www.frontaccounting.com/fawiki/index.php?n=Help.SquareConnector<br />https://github.com/braathwaate/FA24extensions/tree/master/Extensions/square<br />https://frontaccounting.com/punbb/viewtopic.php?pid=43386#p43386<br />https://www.frontaccounting.com/punbb/viewtopic.php?id=2096</p><p>If there any solutions for FA do contact <a href="http://mailto:lcchen@sita.com.my">LC Chen</a> of the Sita Group - +60-3-375-8888.</p><p>Is @TCLim still around - if so, what is the new website for his FA connectors?</p>]]></summary>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2024-09-27T09:44:57Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10600&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[report headers language]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10596&amp;action=new" />
			<summary type="html"><![CDATA[<p>I&#039;m using Arabic language as default language, when generating any report the header of the report table (fields title) are all in English , please advise how do I can change this to Arabic.</p>]]></summary>
			<author>
				<name><![CDATA[automac_eg]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=48672</uri>
			</author>
			<updated>2024-09-15T22:50:22Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10596&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[BOM Inventory Requirement Report and Production Feasibility]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10553&amp;action=new" />
			<summary type="html"><![CDATA[<p>We have a manufacturing business.</p><p>is there a report that show how many Products that I can Manufacture from the current inventory based on the BOM. And If I need to produce a given amount of an item, how many more BOM Stocks I would need. </p><p>Example:<br />So, to Produce Item A, it would need 2 Item B and 1 Item C. So, at the moment I have 3 from Item B and I have 2 From Item C. So I need a report shows me that I can Produce 1 Item A.<br />Also, lets say i needed to produce 100 Item A, it would tell me that I need 197 Item B more (3 in inventory so in total 200) And 98 from Item C (2 in inventory so in total 100).</p>]]></summary>
			<author>
				<name><![CDATA[DrCard]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=45206</uri>
			</author>
			<updated>2024-06-26T08:38:57Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10553&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[i do not found Report for Transfers item]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10543&amp;action=new" />
			<summary type="html"><![CDATA[<p>i do not found Report for Transfers item from Location to Location</p>]]></summary>
			<author>
				<name><![CDATA[sulheen]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=42785</uri>
			</author>
			<updated>2024-06-21T13:08:21Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10543&amp;action=new</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Trial Balance Format requires some changes]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?id=10528&amp;action=new" />
			<summary type="html"><![CDATA[<p>Hi, The trial balance format is somehow very old fashioned as it is showing both debit and credit entries of the same account head. </p><p>I don&#039;t have PHP coding knowledge but I want someone from the team member to change that format as opening balance should not be segregated as debit and credit it should be netted off and only balance should be shown.</p><p>If anyone can help me with that I would be highly obliged and I am using FA on webserver.</p><p>thanks and regards</p>]]></summary>
			<author>
				<name><![CDATA[Shoaib AKbar]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=47585</uri>
			</author>
			<updated>2024-05-24T21:26:29Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?id=10528&amp;action=new</id>
		</entry>
</feed>
