The Tax Inquiry and General Ledger Inquiry produce inconsistent results for taxes. General Ledger Inquiry results are correct while Tax Inquiry is omitting Bank Payment and Deposit type of transactions.
26 10/31/2017 02:10:55 pm
Re: Banking and GL - Tax Inquiry summation problem (7 replies, posted in Banking and General Ledger)
27 10/31/2017 01:50:52 am
Topic: Banking and GL - Tax Inquiry summation problem (7 replies, posted in Banking and General Ledger)
FA 2.4.2 Tax summing is not correct in Tax Inquiry page. Supplier invoice taxes also show up as sales invoice taxes and they are added instead of being subtracted.
Example.
Type Description Amount Outputs/Inputs
GST / TPS 5% Charged on sales (Output Tax): 82.80 1,656.00
GST / TPS 5% Paid on purchases (Input Tax): 82.80 1,656.00
GST / TPS 5% Net payable or collectible: 165.60
28 10/30/2017 06:03:04 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
This is not the case with FA 2.3.22 where all tax details are pulled by the TAX Report.
29 10/30/2017 05:49:20 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
All postings from these documents are expected to show up on TAX Report.
Transcation Type
Journal Entry 0
Bank Payment 1
Bank Deposit 2
Sales Invoice 10
Customer Credit Note 11
Supplier Invoice 20
Supplier Credit Note 21
30 10/30/2017 05:47:37 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
Please see my latest post. Even Invoices are not populating reg_type files if GL entries are used. And with reg_type field as NULL the Tax Report shows no results.
31 10/30/2017 05:32:04 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
On Supplier Invoice
Items Received Yet to be Invoiced - Tax Report shows the taxes incurred
GL Items for this Invoice - Tax Report doesn't show the taxes incurred
32 10/30/2017 05:21:39 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
I just posted another supplier invoice using a quick entry and the reg_type filed on tax detail table was not populated. This could be due to quick entries.
33 10/30/2017 05:16:15 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
I am using quick entries in bank payments with taxes. And these postings don't show up on tax reports.
34 10/30/2017 04:13:53 pm
Re: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
Correction to my post. Direct Invoice is ok. Only Bank Payment taxes are affected.
35 10/30/2017 04:05:11 pm
Topic: Trans_Tax-Details Reg-Type Null on Bank Payment and Direct Invoice (15 replies, posted in Banking and General Ledger)
FA 2.4.2 Tax Report not complete
I noticed the Tax Report is not reporting all tax postings from trans_tax_details table. Every time I record a Direct Invoice or Bank Payment the Tax Report is not showing the taxes posted by these forms.
Here is how my table looks like:
Trans_Type 20 Reg-Type 1
Trans_Type 10 Reg-Type 0
Trans_type 13 Reg_Type Null
Trans_type 11 Reg_Type Null
Trans_type 1 Reg_Type Null
36 10/29/2017 06:11:54 pm
Re: FA 2.4.2 General Ledger Inquiry Drilldown Person/Item gibberish (3 replies, posted in Banking and General Ledger)
BLOB fields were not export/imported properly. I set the charset to UTF-8 and exported as sql instead of excel or text. Now everything shows up normally.
However this din't fix the duplicate lines of one particular bank payment. This duplicate line only appears on General Ledrer view without affecting the account balance in general.
37 10/28/2017 11:58:01 am
Topic: FA 2.4.2 General Ledger Inquiry Drilldown Person/Item gibberish (3 replies, posted in Banking and General Ledger)
Hello,
I would like to report this problem on Frontaccounting 2.4.2.
My data was imported from excel from FA 2.3 using Navicat import/export feature.
On General Ledger Inquiry screen the Person/Item field looks gibberish (Customer [0x333135eJ¼aE]) for imported entries and shows only person id (230) instead of name for new entries.
Also, when drilling down to General Ledger Inquiry view there could be duplicates of entries.
Bank Payment 734 07/04/2017 Customer [0x3830354eJ\X] 45.00 2,380.80
Bank Payment 734 07/04/2017 Customer [0x3830354eJ\X] 45.00 2,335.80
38 10/27/2017 11:36:10 am
Re: Check Printing (Canada) not showing up on Purchaser Reports in 2.4.2 (9 replies, posted in Modules Add-on's)
Yes, it worked when I changed rep_check_print.php with the one on your repo.
Appreciate your help.
39 10/27/2017 12:14:23 am
Re: Check Printing (Canada) not showing up on Purchaser Reports in 2.4.2 (9 replies, posted in Modules Add-on's)
Thank you. I was able to install and activate the extension. But as Alaa stated the printing part is not working.
40 10/26/2017 06:44:32 pm
Topic: Check Printing (Canada) not showing up on Purchaser Reports in 2.4.2 (9 replies, posted in Modules Add-on's)
Hello,
Installed the extension on FA 2.4.2 but the module not showing up on Purchaser Reports.
Do we need to make some changes in this code to make it work in 2.42?
<?php
global $reports, $dim;
$reports->addReport(RC_SUPPLIER, "_cheque_print",'&Cheque Printing',
array( 'Cheque No.' => 'TEXT',
'Payment' => 'REMITTANCE'));
?>
Thank you for your help.
Jack
41 02/20/2015 02:26:56 pm
Re: Change font size, colors on Orders, Invoices... (6 replies, posted in Reporting)
thank you for more information. The only thing I was not able to change is the line height just before charge to delivered to line. I wanted to make this line black and bolder.
42 02/18/2015 10:46:26 pm
Re: Change font size, colors on Orders, Invoices... (6 replies, posted in Reporting)
I figured this out.
To change the color of the document title I changed the codes using http://www.color-hex.com/color/d1199b
// Document title
$this->SetTextColor(190, 190, 190);
To make phone and fax normal I change 'italic' to 'normal':
// Company data
$this->TextWrapLines($ccol, $icol, $this->company['postal_address']);
$this->Font('italic');
43 02/18/2015 10:30:05 pm
Re: Change font size, colors on Orders, Invoices... (6 replies, posted in Reporting)
Thank you for your quick help. This worked for me.
Do you know the lines for these 2 changes?
Color and line weight on the header? I want to make it bolder and black.
Phone number, Fax, Email are in italics. How to make them normal?
Thank you
Jack
44 02/18/2015 06:07:44 pm
Topic: Change font size, colors on Orders, Invoices... (6 replies, posted in Reporting)
Hi developers,
First, thank you for this awesome program. I am glad that I gave FA a try. I have been using Adempiere for the past 5 years and decided to switch to something lightweight and easier to learn. After using it for 1-2 weeks I already started to feel comfortable with it . It is fast and has many features that simply function.
I have few questions concerning document modification if you can help with.
Font size of "Charge to" and "Delivered to" appear too small to read. How to increase it?
How can I change the color and line weight on the header?
Phone number, Fax, Email are in italics. How to make them normal?
If you can point at the php file and line number that affect these I would appreciate it.
Thank you
Jack