Tax Inquiry - Tax not showing

View the tax table relationships in the EDR in the Wiki. You probably have not attached the tax to the tax group  / tax instance.

Attached your file here as well.

There are 3 tax lookup tables in the FA database - tax_groups, tax_types, tax_group_items - have a look at their raw contents and see what is missing.

Attached your image here.

Please see if the "error" is there for all items and if so whether the item_tax_types and item_tax_type_exemptions tables data are messing up.

Delete all rate=0 entries in 0_tax_types and 0_tax_group_items tables whilst all 3 records in the 0_tax_groups table can remain as is. You may want to switch the sales_gl_code and purchasing_gl_code to 2150 whilst removing the 2151 and 2152 account codes from the 0_chart_master and suitably fixing the "System and General GL Setup".

There should not be any gl-codes in the CoA for zero tax entries.....

1. Logout.
2. Clear browser cache.
3. Clear FA cache (company/#/js_cache/*.js).
4. Login and check.

PM me a link to your backup.

What purpose is served if zero rated entries show up? FA takes decisions on amount=0 in many situations that need to be fathomed. How did you get amount=0 for the first entry if it was Irish VAT 23% ?

Attached your image here.

You do not have any gl_trans entries for account 2152.

The code does eliminate 0 amount entries in lines 138-142 in function get_gl_transactions() in gl/includes/db/gl_db_trans.inc for rep708.php (Trial Balance):

    if ($amount_min != null)
        $sql .= " AND ABS(".TB_PREF."gl_trans.amount) >= ABS(".db_escape($amount_min).")";
    
    if ($amount_max != null)
        $sql .= " AND ABS(".TB_PREF."gl_trans.amount) <= ABS(".db_escape($amount_max).")";

to avoid computed tiny balance entries (very tiny amounts: ie., less than 1 cent).

The variable $config_allocation_settled_allowance in the config.php file is used in supplier/customer payment/credit allocations.

The "Zero Values" choice for rep708.php (Trial Balance) uses the amount_min and amount_min input variables as "0" when chosen.

Attachment (in my next post) shows the Tax Report (rep709.php) which is what you may be looking for. There is a summary page for it as well. The report was taken with your backup with no edition.

There are several entries for 2150 in the gl_trans table and that is why it shows. There are no entries for 2152 in it and that is why it is absent.

After adding a dummy entry for 2152, we can see it in the attached Tax Report.

The Tax inquiry doesn't show it because of the non-zero filter in the sqls it uses.

The config.php setting $show_voided_gl_trans, if set to 1, will show the voided (amount = 0) transactions as well.

Will investigate it further.

Hi,

Is it possible that some transactions are not showing in the Tax Report because they are in a different currency than the default currency?

For example Supplier Invoice #6 and #11 are not showing.

EDIT: It doesn't seem to be related to currency. I created a dummy supplier with the default currency and the Non-EU tax group and it's not showing too.

EDIT2: I think it's because I used "Enter Supplier Invoice" instead of "Direct Purchase Invoice Entry".

I am not sure about the details. Janusz has changed a lot here.

The zero tax values are important inside EU countries to track the outputs/inputs for non taxed values.

Joe

@joe/itronics: please advise way forward - for now use the config variable but check with voided table as well.