Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #16161 All Revisions ] Back to Issue ]
Summary 0016161: 347 tax report - does not properly show "collections" over 6000,00 €
Revision 2011-03-08 19:21 by psanjuan
Steps To Reproduce Create and post a sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-09-2010. Product "Local de negocio" tax = Entregas IVA 18%

Create and post another sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-10-2010. Product "Local de negocio" tax = Entregas IVA 18%

Go to Financial Management || Receivables & Payables || Setup || Cashbook || Cashbook and make sure there is a cash journal

Go to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and create a new cash journal just for 1 invoice, amount 4.130,00
Transaction and Accounting date = 20-09-2010
Go to lines and enter a new one.
Select Debt-Payment and select the payment of 4130 with due date 20-09-2010
Process and Post

Run the 347 tax report

23472010B3124567802889768W ARRENDATARIO A D28 B000000000826000 X0000000008260000000000000000002010

and you will realize that the file is showing an amount of 8.260,00 as collection (positions 100-114) as well as 2010 year (positions 130-1133) but only 4.130,00 has been actually collected.

Besides In this case the collection should not be shown unless it is over 6000,00€

Another scenario:

Create a new customer named (Cash Customer); form of payment = Cash
Enter and post a sales invoice for a total amount of 4060.00
Navigate to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and process and post the cash journal for 4060

Launch the 347 tax report

file is showing below record which is not right as it is showing a collection of 4060*2

23472010B31245678A89876765 CASH CUSTOMER D00 B000000000406000 0000000008120000000000000000002010

Another scenario:
Create a new customer named "Cash Customer 2", form of payment "Cash"
Enter a sales invoice for an amount of 12083.20 dated on 2009
complete and post
Navigate to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and process and post the cash journal for 12083.20
by changing the accounting date to 2010 and selecting the 2009 as the 347 year.

Run the 347 tax report
file is showing below record which is not right as it is showing 12083.20*2

23472010B31245678B67898767 CASH CUSTOMER 2 D00 B000000000000000 0000000024166400000000000000002009


Revision 2011-03-08 19:09 by psanjuan
Steps To Reproduce Create and post a sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-09-2010. Product "Local de negocio" tax = Entregas IVA 18%

Create and post another sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-10-2010. Product "Local de negocio" tax = Entregas IVA 18%

Go to Financial Management || Receivables & Payables || Setup || Cashbook || Cashbook and make sure there is a cash journal

Go to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and create a new cash journal just for 1 invoice, amount 4.130,00
Transaction and Accounting date = 20-09-2010
Go to lines and enter a new one.
Select Debt-Payment and select the payment of 4130 with due date 20-09-2010
Process and Post

Run the 347 tax report

23472010B3124567802889768W ARRENDATARIO A D28 B000000000826000 X0000000008260000000000000000002010

and you will realize that the file is showing an amount of 8.260,00 as collection (positions 100-114) as well as 2010 year (positions 130-1133) but only 4.130,00 has been actually collected.

Besides In this case the collection should not be shown unless it is over 6000,00€

Another scenario:

Create a new customer named (Cash Customer); form of payment = Cash
Enter and post a sales invoice for a total amount of 4060.00
Navigate to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and process and post the cash journal for 4060

Launch the 347 tax report

file is showing below record which is not right

23472010B31245678A89876765 CASH CUSTOMER D00 B000000000406000 0000000008120000000000000000002010
Revision 2011-03-07 18:38 by psanjuan
Steps To Reproduce Create and post a sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-09-2010. Product "Local de negocio" tax = Entregas IVA 18%

Create and post another sales invoice for customer "Arrendatario A" for a total amount of 4.130,00€. Invoice date and Due Date 20-10-2010. Product "Local de negocio" tax = Entregas IVA 18%

Go to Financial Management || Receivables & Payables || Setup || Cashbook || Cashbook and make sure there is a cash journal

Go to Financial Management || Receivables & Payables || Transactions || Cash Journal || Header and create a new cash journal just for 1 invoice, amount 4.130,00
Transaction and Accounting date = 20-09-2010
Go to lines and enter a new one.
Select Debt-Payment and select the payment of 4130 with due date 20-09-2010
Process and Post

Run the 347 tax report

23472010B3124567802889768W ARRENDATARIO A D28 B000000000826000 X0000000008260000000000000000002010

and you will realize that the file is showing an amount of 8.260,00 as collection (positions 100-114) as well as 2010 year (positions 130-1133) but only 4.130,00 has been actually collected.

Besides In this case the collection should not be shown unless it is over 6000,00€

Revision 2011-03-07 18:28 by psanjuan
Steps To Reproduce


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker