It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by dls
I have a situation where I want to change the fiscal YE from January to April. Can I extend the current year to end in April and have a longer year? Or do I need to create a small intermediate step between the full years? (and then have the inconvenience of adding them together at new year end) What would be the correct and easiest way to achieve this in FA?
Thanks
I'm still using FA 2.3.22 for various reasons and happy with it.
I have just installed the Transaction import module which is working ok (as far as I have used it so far). However, now since installing the module, when generating reports under Banking & General Ledger-Reports and Analysis and directing to Excel, the format has an error so the file doesn't load properly. Viewing in a Hex editor it now adds 0D 0A (CRLF) to the start of the file. By deleting these the file will open correctly as it always has previously.
Has anyone had this problem? Seen a similar issue on here but only with a workaround.
Hello,
During a meeting between Janusz (@itronics) and I this last weekend we decided that Janusz should look into this. He already has done a test module. More to come in a while.
/Joe
Just wondered how this was going and if the test module was available for evaluation?
Thanks
@joe: That sounds great.. i'm sure it's a good move for the benefit of FA all round and other countries reporting systems will follow similarly in due course if not already!
My reporting may be slightly different than many others as I use the Cash Accounting Plugin module - Works ok for input and output tax with the exception of tracking Credit notes, which I have to manually adjust at the moment prior to submitting to relevant box. I also have to manually work out Sales and manually work my way through the individual expenses and total for the relevant box. Best solution would really need to encompassed both accrual and cash accounting methods.
I did start to look into an implementation, but ran short of time.... Please keep us informed of progress and method, very happy to help in any way I can.
Many thanks
dls
@OLDDOG: Have you got any further on this?
@doug86: I would definitely be interested - i'm using the Cash basis module and would also like the 0% VAT tracking/reporting to be more comprehensive to aid box filling on the returns. This is another detail that perhaps needs some work for MTD
I'm also exploring some bridging software via my auditors Deloitte, but would prefer a more seamless integrated solution. Willing to help, but not enough time to fully develop solution.
I'm sure an integrated solution to this would further promote the use of FA in UK... I'm not sure how many UK users there are? It's a great flexible system that continues to evolve, with a fantastic community of support. The more people using it the better for everyone.
openssl enabled and proceedure from FA 2.3.22 through 2.3.26 to FA 2.4.6 was followed. Database upgrade performed as expected and all else appears to be working well so far. Still can't install extensions. Is there a detailed proceedure on how to manually install extensions as i have them downloaded?
thanks
Just installed a test version 2.4.6 of frontaccounting and up and running well with data from currently used 2.3.22
I just cant get the extension install/activation to work. it lockes the screen up after the yellow triangle appears. Am i missing something or some file/folder permissions etc? Has anyone else had this problem?
Many thanks
I'm UK based and using the Cash Accounting Basis reporting module for a few years now. I have many transactions using 0% vat rates, some at 5%, 7.15% and 20%. The system took a little setting up, so i'm still on V2.3.22 as it works well. I have to draw some figures in 'longhand' (ie individual expenses total for quarter) for Box 7 and can only access correct data from the comprehensive cash basis GL report printout. (pdf or Excel)
I am definitely interested in MTD solutions. I'm not quite sure what is meant by no manipulation of the data from software to software which is mentioned in the video link given by gj6n68 and shown below:
Just found this guys who are already providing solutions it seems
https://www.taxoptimiser.co.uk/Features/MTDVAT
Any experiences or advice in this area would be much appreciated as April is not so far away!
Many thanks
@apmuthu: Thanks for the reply - Could you expand on that please, i'm still not quite sure how to go about it.
I have the opening balances all set for the required year. I just want to clear all the data from the supplier and customer tables prior to the required year which have no allocation or other side to allocate to. supplier data represents about 300 transactions (payments to). The only customer data to clear is one customer who self bills - therefore each transaction is a bank deposit -12 transactions in the year.
Many thanks
Problem is I'm using some items - something of a 'half-way house' - is it possible to clear the older data from the closed years out of the supplier/customer tables cleanly without interfering with anything else?
Sure I understand. It was definitely a mistake on my behalf as I was getting to grips with the system.
My problem is that I have used invoices/SI where necessary and not where not necessary. For the most part this has been ok, and in fact worked quite well for me, but I now see the problem!! The unallocated invoice data from previous years is left in the system giving an incorrect opening balance on the Supplier/customer balance reports. ( I also input much data in a previous year alongside my old system as a trial) I have closed previous years and have the balance sheet etc now set up ok. However I now wish to clear the remains of this earlier data from previous years affecting the Supplier balances and Customer balances.
I wish to find out the best way to do this without affecting anything else. (the years in question have been closed and deleted) Is it a case of phpmyadmin and mass deletion of earlier dated entries in sup_trans etc? will this cause other damage?? Are there any other counter posts to the database?
Also going forward - will I have to input Supplier invoices using the GL entry part and the subsequent payment of these for every transaction to track the Creditors and Debtors more easily? That equates to a significant amount of extra work than I have been doing. I don't use the inventory part of FA hence not using SI for every purchase. Is it possible to use the system as I have been and tidy at the end of each year with perhaps a JE to adjust the Creditor/Debtor values?
Has anyone else experienced this problem? Any advice would be much appreciated.
I too am having this problem.
I have been directly entering some payments and deposits from the banking and general ledger deposits and banking. these payments/deposits have no direct invoices/supplier invoices associated. At the end of year this causes a problem with easy retrieval of Creditors/Debtors.
By outputting the Supplier/customer balances to an excel file with Show Balances set by running the formula on each entry line
=(IF(AND(allocated=0,(OR(AND(credit=0,charges<>0),AND(charges=0,credits<>0)))),balance,0)
By totalling all the lines output from this formula and subtracting this from the original balance total this gives the Creditors/Debtors.
Initial checks suggest this works without error.
This method of input of payments/deposits without invoice works for me in my system as is, minimising extra work etc. However is there any other tidier way? I'm using Cash Accounting. Auto generation of a SI would be helpful.
As noted above the PDF print generation problem is only directly from the reports and analysis screen. I can email the pdf from this screen ok and I can pick up a perfectly generated PDF from the company/1/pdf_files/ folder. The corrupt file output obtained directly from the screen is shown below. This should be a pdf file of the invoice/statement etc.
Any pointers as to which files to look at which generate the file from the reports and analysis screen?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html dir='ltr' >
<head profile="http://www.w3.org/2005/10/profile"><title>Reports and Analysis</title><meta http-equiv='Content-type' content='text/html; charset=iso-8859-1'><link href='../themes/default/default.css' rel='stylesheet' type='text/css'>
<link href='../themes/default/images/favicon.ico' rel='icon' type='image/x-icon'>
<script language="javascript" type="text/javascript" src="../company/1/js_cache/JsHttpRequest.js"></script><script language="javascript" type="text/javascript" src="../company/1/js_cache/behaviour.js"></script><script language="javascript" type="text/javascript" src="../company/1/js_cache/utils.js"></script><script language="javascript" type="text/javascript" src="../company/1/js_cache/inserts.js"></script><script language="javascript" type="text/javascript" src="../company/1/js_cache/reports.js"></script><script language="javascript" type="text/javascript" src="../company/1/js_cache/date_picker.js"></script></head>
<body><table class='callout_main' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2' rowspan='2'>
<table class='main_page' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td class='quick_menu'>
<table cellpadding=0 cellspacing=0 width='100%'><tr><td><div class=tabs><a class='selected' href='../index.php?application=orders' accesskey='S'><u>S</u>ales</a><a class='menu_tab' href='../index.php?application=AP' accesskey='P'><u>P</u>urchases</a><a class='menu_tab' href='../index.php?application=stock' accesskey='I'><u>I</u>tems and Inventory</a><a class='menu_tab' href='../index.php?application=manuf' accesskey='M'><u>M</u>anufacturing</a><a class='menu_tab' href='../index.php?application=proj' accesskey='D'><u>D</u>imensions</a><a class='menu_tab' href='../index.php?application=GL' accesskey='B'><u>B</u>anking and General Ledger</a><a class='menu_tab' href='../index.php?application=system' accesskey='E'>S<u>e</u>tup</a></div></td></tr></table><table class=logoutBar><tr><td class=headingtext3>Leech & Sons | 91.84.138.17 | Administrator</td><td class='logoutBarRight'><img id='ajaxmark' src='../themes/default/images/ajax-loader.gif' align='center' style='visibility:hidden;'></td> <td class='logoutBarRight'><a class='shortcut' href='../admin/display_prefs.php?'>Preferences</a>
<a class='shortcut' href='../admin/change_current_user_password.php?selected_id=admin'>Change password</a>
<img src='../themes/default/images/login.gif' width='14' height='14' border='0' alt='Logout'> <a class='shortcut' href='../access/logout.php?'>Logout</a> </td></tr><tr><td colspan=3></td></tr></table></td></tr></table><center><table id='title'><tr><td width='100%' class='titletext'>Reports and Analysis</td><td align=right><span id='hints'></span></td></tr></table></center><div id='msgbox'></div><div id='_page_body'><table align='center' width='80%' style='border:1px solid #cccccc;'><tr valign='top'><td width='30%'><b>Report Classes:</b><br><a href='/frontaccounting/reporting/reports_main.php?Class=0' style='font-weight:bold' class='repclass_link' id='class0'>Customer</a> <br><a href='/frontaccounting/reporting/reports_main.php?Class=1' style='font-weight:normal' class='repclass_link' id='class1'>Supplier</a> <br><a href='/frontaccounting/reporting/reports_main.php?Class=2' style='font-weight:normal' class='repclass_link' id='class2'>Inventory</a> <br><a href='/frontaccounting/reporting/reports_main.php?Class=3' style='font-weight:normal' class='repclass_link' id='class3'>Manufacturing</a> <br><a href='/frontaccounting/reporting/reports_main.php?Class=4' style='font-weight:normal' class='repclass_link' id='class4'>Dimensions</a> <br><a href='/frontaccounting/reporting/reports_main.php?Class=5' style='font-weight:normal' class='repclass_link' id='class5'>Banking</a> <br><a href='/frontaccounting/reporting/reports_main.php?Class=6' style='font-weight:normal' class='repclass_link' id='class6'>General Ledger</a> <br></td><td width='35%' style='border-left:1px solid #cccccc;border-right:1px solid #cccccc;padding-left:3px;'><table class='repclass' id='TAB_0' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: Customer</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=101' style='font-weight:normal' id='_el56b1c99f163177.24665220' accesskey='B'>Customer <u>B</u>alances</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=102' style='font-weight:normal' id='_el56b1c99f1648a0.88689630' accesskey='A'><u>A</u>ged Customer Analysis</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=103' style='font-weight:normal' id='_el56b1c99f165b76.09965020' accesskey='D'>Customer <u>D</u>etail Listing</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=114' style='font-weight:normal' id='_el56b1c99f166da2.30432197' accesskey='S'>Sales <u>S</u>ummary Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=104' style='font-weight:normal' id='_el56b1c99f167f96.40659362' accesskey='P'><u>P</u>rice Listing</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=105' style='font-weight:normal' id='_el56b1c99f169183.95003141' accesskey='O'><u>O</u>rder Status Listing</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=106' style='font-weight:normal' id='_el56b1c99f16a340.01355730' accesskey='S'><u>S</u>alesman Listing</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=107' style='font-weight:normal' id='_el56b1c99f16bd71.08439688' accesskey='I'>Print <u>I</u>nvoices</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=113' style='font-weight:normal' id='_el56b1c99f16cfd7.28356498' accesskey='C'>Print <u>C</u>redit Notes</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=110' style='font-weight:normal' id='_el56b1c99f16e1c5.36268778' accesskey='D'>Print <u>D</u>eliveries</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=108' style='font-weight:normal' id='_el56b1c99f16f3b5.57250059' accesskey='S'>Print <u>S</u>tatements</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=109' style='font-weight:normal' id='_el56b1c99f170581.11395967' accesskey='P'><u>P</u>rint Sales Orders</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=111' style='font-weight:normal' id='_el56b1c99f1717a1.27390745' accesskey='P'><u>P</u>rint Sales Quotations</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=0&REP_ID=112' style='font-weight:normal' id='_el56b1c99f172777.16529769'>Print Receipts</a><tr><td>
</table><table class='repclass' id='TAB_1' style='display:none' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: Supplier</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=201' style='font-weight:normal' id='_el56b1c99f174132.75308995' accesskey='B'>Supplier <u>B</u>alances</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=202' style='font-weight:normal' id='_el56b1c99f1753a2.99348034' accesskey='A'><u>A</u>ged Supplier Analyses</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=203' style='font-weight:normal' id='_el56b1c99f1765b4.98954137' accesskey='P'><u>P</u>ayment Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=204' style='font-weight:normal' id='_el56b1c99f177791.47039124' accesskey='G'>Outstanding <u>G</u>RNs Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=205' style='font-weight:normal' id='_el56b1c99f178970.71086221' accesskey='D'>Supplier <u>D</u>etail Listing</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=209' style='font-weight:normal' id='_el56b1c99f179b70.30048173' accesskey='O'>Print Purchase <u>O</u>rders</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=1&REP_ID=210' style='font-weight:normal' id='_el56b1c99f17ac22.91196124'>Print Remittances</a><tr><td>
</table><table class='repclass' id='TAB_2' style='display:none' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: Inventory</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=301' style='font-weight:normal' id='_el56b1c99f17c562.19128376' accesskey='V'>Inventory <u>V</u>aluation Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=302' style='font-weight:normal' id='_el56b1c99f17d785.00100709' accesskey='P'>Inventory <u>P</u>lanning Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=303' style='font-weight:normal' id='_el56b1c99f17e984.25893828' accesskey='C'>Stock <u>C</u>heck Sheets</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=304' style='font-weight:normal' id='_el56b1c99f17fba9.99609909' accesskey='S'>Inventory <u>S</u>ales Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=305' style='font-weight:normal' id='_el56b1c99f180d91.03711580' accesskey='G'><u>G</u>RN Valuation Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=306' style='font-weight:normal' id='_el56b1c99f181fb9.28213596' accesskey='U'>Inventory P<u>u</u>rchasing Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=307' style='font-weight:normal' id='_el56b1c99f1831c6.63724630' accesskey='M'>Inventory <u>M</u>ovement Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=308' style='font-weight:normal' id='_el56b1c99f184410.95680099' accesskey='O'>C<u>o</u>sted Inventory Movement Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=2&REP_ID=309' style='font-weight:normal' id='_el56b1c99f185648.66219691' accesskey='S'>Item <u>S</u>ales Summary Report</a><tr><td>
</table><table class='repclass' id='TAB_3' style='display:none' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: Manufacturing</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=3&REP_ID=401' style='font-weight:normal' id='_el56b1c99f186f98.28038982' accesskey='B'><u>B</u>ill of Material Listing</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=3&REP_ID=402' style='font-weight:normal' id='_el56b1c99f188180.72679464' accesskey='L'>Work Order <u>L</u>isting</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=3&REP_ID=409' style='font-weight:normal' id='_el56b1c99f189366.09178502' accesskey='W'>Print <u>W</u>ork Orders</a><tr><td>
</table><table class='repclass' id='TAB_4' style='display:none' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: Dimensions</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=4&REP_ID=501' style='font-weight:normal' id='_el56b1c99f18ac09.71319648' accesskey='S'>Dimension <u>S</u>ummary</a><tr><td>
</table><table class='repclass' id='TAB_5' style='display:none' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: Banking</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=5&REP_ID=601' style='font-weight:normal' id='_el56b1c99f18c4a3.47986700' accesskey='S'>Bank <u>S</u>tatement</a><tr><td>
</table><table class='repclass' id='TAB_6' style='display:none' cellpadding=0 cellspacing=0 border=0 width='100%'><tr><td><b>Reports For Class: General Ledger</b></td></tr>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=701' style='font-weight:normal' id='_el56b1c99f18de05.70928389' accesskey='A'>Chart of <u>A</u>ccounts</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=702' style='font-weight:normal' id='_el56b1c99f18f024.71550230' accesskey='J'>List of <u>J</u>ournal Entries</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=704' style='font-weight:normal' id='_el56b1c99f190229.83418280' accesskey='T'>GL Account <u>T</u>ransactions</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=705' style='font-weight:normal' id='_el56b1c99f191434.64786031' accesskey='E'>Annual <u>E</u>xpense Breakdown</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=706' style='font-weight:normal' id='_el56b1c99f193b03.42488125' accesskey='B'><u>B</u>alance Sheet</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=707' style='font-weight:normal' id='_el56b1c99f194dd6.31402646' accesskey='P'><u>P</u>rofit and Loss Statement</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=708' style='font-weight:normal' id='_el56b1c99f195fe1.95516970' accesskey='B'>Trial <u>B</u>alance</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=709' style='font-weight:normal' id='_el56b1c99f1971b3.17095028' accesskey='X'>Ta<u>x</u> Report</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=710' style='font-weight:normal' id='_el56b1c99f1981a8.30772453'>Audit Trail</a><tr><td>
<tr><td><a class='repopts_link' href='/frontaccounting/reporting/reports_main.php?Class=6&REP_ID=_tax_details_cash' style='font-weight:normal' id='_el56b1c99f199142.05006817'>Tax Details (Cash Basis)</a><tr><td>
</table></td><td width='35%'><div id='rep_form'></div></td></tr></table><br><center><center><table width=20% cellpadding=2 cellspacing=0>
<tr>
<td align=center><a href='javascript:goBack();'>Back</a></td>
</tr>
</table></center>
</center><br></div></td></tr></table>
<table class=bottomBar2>
<tr><td class=bottomBarCell>03/02/2016 | 09:34</td>
<td id='hotkeyshelp'></td></td></tr></table>
</td></tr> </table>
</table>
<table align='center' id='footer'>
<tr>
<td align='center' class='footer'><a target='_blank' href='https://frontaccounting.com' tabindex='-1'><font color='#ffffff'>FrontAccounting 2.3.22 - Theme: default - </font></a></td>
</tr>
<tr>
<td align='center' class='footer'><a target='_blank' href='https://frontaccounting.com' tabindex='-1'><font color='#ffff00'>FrontAccounting</font></a></td>
</tr>
</table><br><br>
<script>
_focus = '_el56b1c99f163177.24665220';
_validate = [ ];
var editors = [ ];
</script>
<script type="text/javascript"><!--
var user = {
theme: '../themes/default/',
loadtxt: 'Requesting data...',
date: '03/02/2016',
datesys: 0,
datefmt: 1,
datesep: '/',
ts: ',',
ds: '.',
pdec : 2}
--></script>
</body></html>
I'm using v2.3.22 with English language C installed, iso-8859-1 encoding on a Qnap TS219P+
I can generate PDF invoices at time of creation but I seem to have a problem creating PDFs from the Report and Analysis Screen. As noted I can retrieve them from the company/pdf_files/ folder perfectly.
I have the Dejavu files extracted in the reporting/fonts folder and the relevant line inserted in the class_pdf.inc file
It's beginning to annoy me having to retrieve the report 'longhanded' - How would the files get the multi-byte UTF data in them (As a result of a setting incorrect?) and how can I detect whether this is happening?
Many thanks for your help - much appreciated
I can print the majority of invoices, reports etc, but some do not giving a comment on the top line that PDF may not print properly. I am assuming it is when the file is above a certain size? Excel output always works ok.
I can, however, retrieve the pdfs from the company/1/pdf_file folder and these print perfectly. Can anyone advise me if there is a specific setting (in php.ini for instance) that I need to change/increase that will allow the PDF files to be accessed and printed in the normal manner
Thanks
I believe that the following code replacing the first section of the SELECT statement in the tax_cash_db.inc file sorts the problem discussed in the previous post - could someone please try this and compare the results with the original and confirm?
(Please note I am tracking 0%VAT transactions and 20%VAT transactions - but this should effect any multi VAT listings in any single invoice)
$sql = "SELECT
'Output',
ca.amt gross_output,
(ca.amt/(
SELECT sum(ttd1.net_amount) + sum(ttd1.amount)
FROM ".TB_PREF."trans_tax_details ttd1
WHERE ttd1.trans_type = ttd.trans_type AND ttd1.trans_no = ttd.trans_no
)) * ttd.net_amount * ex_rate net_output,
(ca.amt/(
SELECT sum(ttd1.net_amount) + sum(ttd1.amount)
FROM ".TB_PREF."trans_tax_details ttd1
WHERE ttd1.trans_type = ttd.trans_type AND ttd1.trans_no = ttd.trans_no
)) * ttd.amount*ex_rate payable,
0 gross_input,
0 net_input,
0 collectible,
ttd.rate,
bt.type,
bt.person_type_id,
bt.person_id,
ttd.trans_no,
tt.id,
tt.name,
bt.trans_date
FROM ".TB_PREF."bank_trans bt
INNER JOIN ".TB_PREF."cust_allocations ca
ON bt.type = ca.trans_type_from
AND bt.trans_no = ca.trans_no_from
INNER JOIN ".TB_PREF."debtor_trans dt
ON dt.type = ca.trans_type_from
AND dt.trans_no = ca.trans_no_from
INNER JOIN ".TB_PREF."trans_tax_details ttd
ON ttd.trans_type = ca.trans_type_to
AND ttd.trans_no = ca.trans_no_to
INNER JOIN ".TB_PREF."tax_types tt
ON tt.id = ttd.tax_type_id
WHERE bt.trans_date >= '$fromdate'
AND bt.trans_date <= '$todate'
UNION ALL
Many thanks
I have deleted my previous post as it was not the correct reason for the problem. I will explain the problem and see if anyone else has this issue.
I process invoices with multiple lines with different VATs associated with different entries. So some entries may be 0VAT and some may be 20% VAT entries. These all appear in the trans_tax_details table for the particular invoice(debt) as multiple rows all with the correct respective net_amount and amount entries.
The Select statement
SELECT
'Output',
ca.amt gross_output,
(ca.amt/(ttd.net_amount+ttd.amount)) * ttd.net_amount * ex_rate net_output,
(ca.amt/(ttd.net_amount+ttd.amount)) * ttd.amount*ex_rate payable,
is performed to determine the correct amount if the invoice is not settled (allocated) in full. However, as I see it this only works if the invoice is summarised in one row with one VAT. That is, ca.amt is compared with each row and if this doesn't relate directly to the ttd.net_amount and ttd.amount in one row it doesn't work?
Am I reading this wrongly?
As I noted before I deleted my earlier post using
SELECT
'Output',
ca.amt gross_output,
ttd.net_amount * ex_rate net_output,
ttd.amount*ex_rate payable,
will work but technically only if the allocation is in full.
Can anyone please confirm if it's an error or if I am seeing this wrongly??
Many thanks
apologies... I did not realise elax_tax_support_files was not so available. I can definitely recommend it for UK accounting, indeed with Box 7 requirements and 0VAT in returns etc I would find FA not so appealing without, which would be a shame as I honestly think it is fantastic in general.
I believe something on the same lines should be considered for the core. With a combination of Elax's files and the Cash Basis module I have a system that works really well for me - Thank you so much.
By commenting out the following search like so
WHERE /* bt.type = ".BT_CHEQUE."
AND */ bt.person_type_id = ".PT_SUPPLIER."
I can get the Credit Note and correct VAT listed. However it does need to be input from the supplier menu.
In this particular case the Credit Note refers to an old payment which had long since been paid. It is also from a previous fiscal year and this is my first year using FA. I therefore have no previous unallocated payments that I can allocate the credit note to. I can't seem to find a way to allocate this credit note to the bank deposit made!!
If I use the bank deposit method the deposit VAT is posted as input tax claimable (as if it were a payment) whereas it should then be payable. However, net amount is posted correctly for returns outward. Is this a Bug??
I am therefore left with the option to fudge a fix with a journal entry using quick entry and attaching some memo
Surely When a bank deposit is made from the supplier - ie money is placed into the account - it should not be registered in the bank trans table as type credit? I would have thought placed into a cheque account it would be cheque type??
I've tried that with same result.
It's down to the search criterion not pulling the required Credit Note data out.
WHERE bt.type = ".BT_CHEQUE."
AND bt.person_type_id = ".PT_SUPPLIER."
WHERE bt.type <> ".BT_CREDIT."
AND bt.person_type_id <> ".PT_CUSTOMER."
WHERE bt.type = ".BT_CHEQUE."
AND bt.person_type_id = ".PT_CUSTOMER."
WHERE bt.type = ".BT_CREDIT."
AND bt.person_type_id <> ".PT_SUPPLIER."
These are in the cash basis tax report module and don't work - When the credit note is entered bt.type is set to BT_CREDIT and bt.person_type.id is set to PT_SUPPLIER
Question is (hoping to save time with further working out etc)
Can anyone who knows the inner workings well advise on a search criterion that will pull the Credit Notes out without pulling out other unwanted data? ie - if I just set the criterion to pull the bt.type= BT_CREDIT and bt.person_type.id = PT_SUPPLIER, I assume I will get all the unwanted credit data too!
I entered the credit note via Bank Deposit in banking & GL screen as payment into checking account and it notes the bt.type as BT_CREDIT is that right? it's not a credit control account?
Thanks
I have installed this module for UK Tax reporting and it seems to be working well - I do have a problem with it catching up with Credit notes from Suppliers.
Before I look further, has any one else found this? And any workarounds or fixes?
Many thanks
@:elax Many thanks for the advice - much appreciated.
FrontAccounting forum → Posts by dls
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.