0013056: AEAT 349 V2010 do not take into account periods

Description

Whatever Report I select for whatever period it always shown all the transactions in the system for the Fiscal Year

Steps To Reproduce

       * As System Administrator go to General Setup // Client // Initial Client Setup and create a new Entity
    * Client = Client349
    * Client UserName = ClienteAdmin349
    * Currency = euro
    * Include Accounting = yes
    * Reference Data = Chart of Accounts PYMES + Taxes for Spain
    * Accounting Dimensions = BP+Product+Project
    * Presss OK
    * As Cliente349Admin Go to General Setup // Initial Organization setup // and create a new Organization
    * Organization = Org349
    * Org UserName = OrgUser349
    * Organization type = Legal with Accounting
    * Include Accounting = Yes
    * Currency = euro
    * Reference Data = Modelo 349 1.0.5 + Modelo 347 1.1.3
    * Accounting Dimensions = BP+Product+Project
    * Press OK
    * Go to General Setup // Enterprise // Organization // Organization, and set Org349 as:
    * Organization type = Legal with Accounting
    * Allow Period Control = Yes
    * Calendar = Cliente349 Calendar
    * Go to Information Tab and setup Spain as Location and enter the complete address including Postal Code and City.
    * Enter TAX Id information
    * Go back and press Set as Ready button

    * Enter in the application As Cliente349 Admin and for Org340 organization
    * Go to Financial Management // Accounting // Setup // Fiscal Calendar // Calendar and create 2009 and 2010 Years for Cliente349 Calendar, with the corresponding Periods.
    * Go to Financial Management // Accounting // Transactions // Open/Close Period Control and Open all periods for 2009 and 2010 years
    * Go to Master Data Management // Business Partner Setup // Business Partner Category and create customer and vendor categories
    * Go to Master Data Management // Business Partner Setup // Payment Term and create a new one as 30 days by example
    * Go to Master Data Management // Product Setup // Product Category and create 2, one for products and one for services
    * Go to Master Data Management // Pricing // Price List Schema and Price List and create a price list for Purchase and a price list for Sales
    * Go to Master Data Management // BP and create below vendor/customer BP all located in a EU country (by example France or Germany)
    * UE Vendor Products A (France)
    * UE Vendor Products B (Germany)
    * UE Vendor Services A (Italy)
    * UE Vendor Services B (Greece)
    * UE Customer Products A (France)
    * UE Customer Products B (Germany)
    * UE Customer Services A (Italy)
    * UE Customer Services B (Greece)
    * It is important to enter for each of them a TAX ID and assign them to the corresponding Purchase/Sales List
    * Go to Master Data Management // Product and create 2 products A and B and 2 services A and B
    * Product A and Product B linked to product (Product Category), Product Type = item, and IVA 16% and IVA 7% as Tax Category respectively.
    * Service A and Service B linked to service (Product Category), Product Type = services, and IVA 16% Servicios and IVA 7% Servicios respectively
    * Go to Master Data Management // Pricing // Price List and assign Product and Services to Purchase and Sales Price list
    * Go to Mater Data Management // BP and create a vendor and a customer both located in Spain, named as National Vendor A and National Customer A.

    * Go to Procurement Management // Transactions // Purchase Invoice and complete/post below Purchase invoices (Document Typ = AP Invoice):

   1. Purchase Invoice 100 - Dated on January 2010 - BP = UE Vendor Products A
   2. Line 10 = Product A - Invoiced Quantity = 15 - Net Unit Price = 150.00 - Line Net Amount = 2250.00 Tax =Adquisiciones Intracomunitarias 16% - Tax key = A
   3. Line 20 = Product B - Invoiced Quantity = 25 - Net Unit Price = 200 - Line Net Amount = 3000.00 Tax=Adquisiciones Intracomunitarias 7% - Tax key = A

    * Invoice 100 Total UE Vendor Products A = Tax Key A = Total = 5250

   1. Purchase Invoice 101 - Dated on January 2010 - BP = UE Vendor Products A
   2. Line 10 = Product A - Invoiced Quantity = 25 - Net Unit Price = 150.00 - Line Net Amount = 3750.00 - Tax=Adquisiciones Intracomunitarias 16% - Tax key A = 3750
   3. Line 20 = Service A - Invoiced Quantity = 25 - Net Unit Price = 550.00 - Line Net Amount = 13750.00 - Tax=Inversion Sujeto Pasivo 16% - Tax Key I = 13750

    * Invoice 101 Total UE Vendor Products A = Tax Key A = 3750.00 & Tax Key I = 13750

   1. Purchase Invoice 102 - Dated on February 2010 - BP = UE Vendor Services A
   2. Line 10 = Service A - Invoiced Quantity = 53 - Net Unit Price = 550 - Line Net Amount = 29150 - Tax = Inversion Sujeto Pasivo 16% - Tax Key I = 29150
   3. Line 20 = Service B - Invoiced Quantity = 59 - Net Unit Price = 650 - Line Net Amount = 38350 - Tax = Inversion Sujeto Pasivo 7% - Tax Key I = 38350

Proposed Solution

    * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher
    * Select = Org349
    * Report = Modelo 349 Mensual v 2010
    * Period = Jan-10
    * Press Input Parameters
    * Enter a File Name, Contact Person and Phone
    * Press Generate Electronic File
    * There should be 1 transactions in the file for UE Vendor Products A - Tax key A = 9.000
    * and 1 transaction in the file for UE Vendor Products A - Tax Key I = 13750

but the system also include February Transaction:
UE Vendor Services A = Tax Key I = 67500
But the sy

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0013057

closed

vmromanos

AEAT 349 V2020 do not take the right amounts

Notes
(0026593) hgbot (developer) 2010-04-23 10:04	Repository: erp/pmods/org.openbravo.module.aeat349.es Changeset: b4393f429f8628f175991915637fc6c706f59bdf Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Fri Apr 23 10:04:05 2010 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/b4393f429f8628f175991915637fc6c706f59bdf [^] Fixed bug 13058 Fixed bug 13056 Fixed bug 13057 Fixed bug 13083 --- M referencedata/standard/349_Tax_Parameters.xml M src-db/database/sourcedata/AD_DATASET_TABLE.xml M src-db/database/sourcedata/AD_MESSAGE.xml M src-db/database/sourcedata/AD_MODULE.xml M src-db/database/sourcedata/AD_REFERENCE.xml M src/org/openbravo/module/aeat349/es/AEAT3492010Report.java M src/org/openbravo/module/aeat349/es/AEAT3492010ReportDao.java ---

Issue History
Date Modified	Username	Field	Change
2010-04-20 18:51	psanjuan	New Issue
2010-04-20 18:51	psanjuan	Assigned To	=> vmromanos
2010-04-20 18:52	psanjuan	Proposed Solution updated
2010-04-20 18:52	psanjuan	Assigned To	vmromanos => dalsasua
2010-04-21 08:56	dalsasua	Assigned To	dalsasua => vmromanos
2010-04-21 11:07	vmromanos	Issue Monitored: vmromanos
2010-04-21 11:07	vmromanos	Issue End Monitor: vmromanos
2010-04-21 11:07	vmromanos	Status	new => scheduled
2010-04-21 11:07	vmromanos	fix_in_branch	=> pi
2010-04-21 11:15	vmromanos	Relationship added	related to 0013057
2010-04-23 10:04	hgbot	Checkin
2010-04-23 10:04	hgbot	Note Added: 0026593
2010-04-23 10:04	hgbot	Status	scheduled => resolved
2010-04-23 10:04	hgbot	Resolution	open => fixed
2010-04-23 10:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/b4393f429f8628f175991915637fc6c706f59bdf [^]
2010-04-23 11:31	psanjuan	Status	resolved => closed
2010-04-23 11:31	psanjuan	fix_in_branch	pi =>