Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0013057 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Localization Pack: Spain] AEAT 349 | critical | always | 2010-04-20 18:56 | 2010-04-23 11:31 | |||
Reporter | psanjuan | View Status | public | |||||
Assigned To | vmromanos | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | b4393f429f86 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 32 bit | Database | Oracle | Java version | 1.6 | |||
OS Version | Ubuntu 8.04.1 | Database version | 11.1.0.6.0 | Ant version | 1.7.0 | |||
Product Version | SCM revision | |||||||
Regression date | ||||||||
Regression introduced by commit | ||||||||
Regression level | ||||||||
Review Assigned To | ||||||||
Regression introduced in release | ||||||||
Summary | 0013057: AEAT 349 V2020 do not take the right amounts | |||||||
Description | AEAT 349 V2020 do not take the right amounts | |||||||
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 * Invoice 102 Total UE Vendor Services A = Tax Key I = 67500 1. Purchase Invoice 103 - Dated on February 2010 - BP = UE Vendor Services B 2. Line 10 = Service A - Invoiced Quantity = 23 - Net Unit Price = 550,23 - Line Net Amount = 12655.29 - Tax = Inversion Sujeto Pasivo 16% - Tax Key I = 12655.29 3. Line 20 = Product B - Invoiced Quantity = 37 - Net Unit Price = 200 - Line Net Amount = 7400 - Tax =Adquisiciones Intracomunitarias 7% - Tax Key A = 7400 * Invoice 103 Total UE Vendor Services B = Tax Key A = 7400 - Tax Key I = 12655.29 1. Purchase Invoice 104 - Dated on March 2010 - BP = UE Vendor Product B 2. Line 10 = Product A - Invoiced Quantity = 27.33 - Net Unit Price = 150 - Line Net Amount =4099.50 - Tax =Adquisiciones Intracomunitarias 16% - Tax Key A = 4099.50 3. Line 20 = Product B - Invoiced Quantity = 27.37 - Net Unit Price = 200 - Line Net Amount = 5474 - Tax =Adquisiciones Intracomunitarias 7% - Tax Key A = 5474 * Invoice 104 Total UE Vendor Product B = Tax Key A = 9573.57 1. Purchase Invoice 105 - Dated on March 2010 - BP = UE Vendor Product B 2. Line 10 = Product A - Invoiced Quantity = 27.33 - Net Unit Price = 150 - Line Net Amount =4099.50 - Tax =Adquisiciones Intracomunitarias 16% - Tax Key A = 4099.50 3. Line 20 = Product B - Invoiced Quantity = 27.37 - Net Unit Price = 200 - Line Net Amount = 5474 - Tax =Adquisiciones Intracomunitarias 7% - Tax Key A = 5474 * Invoice 105 Total UE Vendor Product B = Tax Key A = 9573.57 1. Purchase Invoice 106 - Dated on June 2010 - BP = UE Vendor Product A 2. Line 10 = Product A - Invoiced Quantity = 15 - Net Unit Price = 150 - Line Net Amount =2250 - Tax =Adquisiciones Intracomunitarias 16% - Tax Key A = 2250 3. Line 20 = Product B - Invoiced Quantity =8 - Net Unit Price = 200 - Line Net Amount = 1600 - Tax =Adquisiciones Intracomunitarias 7% - Tax Key A = 1600 4. Line 30 = Service A - Invoiced Quantity =21 - Net Unit Price = 550 - Line Net Amount =11550- Tax =Inversión Sujeto Pasivo 16% - Tax Key I = 11550 * Invoice 106 Total UE Vendor Product A = Tax Key A = 3850 - Tax Key I = 11550 1. Purchase Invoice 107 - Dated on June 2010 - BP = UE Vendor Product B 2. Line 10 = Product A - Invoiced Quantity = 55 - Net Unit Price =210.33 - Line Net Amount =11568.15 - Tax =Adquisiciones Intracomunitarias 16% - Tax Key A = 11568.15 3. Line 20 = Product B - Invoiced Quantity = 5 - Net Unit Price = 327.45- Line Net Amount = 1637.25 - Tax =Adquisiciones Intracomunitarias 7% - Tax Key A = 1637.25 4. Line 30 = Service B - Invoiced Quantity =1 - Net Unit Price = 650 - Line Net Amount =650- Tax =Inversión Sujeto Pasivo 7% - Tax Key I = 650 * Invoice 107 Total UE Vendor Product B = Tax Key A = 13205.40 - Tax Key I =650 1. Purchase Invoice 108 - Dated on June 2010 - BP = UE Vendor Services A 2. Line 10 = Service A - Invoiced Quantity = 3.5 - Net Unit Price =550 - Line Net Amount =1925 - Tax =Inversión Sujeto Pasivo 16% - Tax Key I = 1925 3. Line 20 = Service B - Invoiced Quantity = 3.5 - Net Unit Price = 650 - Line Net Amount =2275 - Tax =Inversión Sujeto Pasivo 7% - Tax Key I =2275 4. Line 30 = Product A - Invoiced Quantity =1 - Net Unit Price = 150 - Line Net Amount =150- Tax =Adquisiciones Intracomunitarias 16% - Tax Key A =150 * Invoice 108 Total UE Vendor Service A = Tax Key A = 150 - Tax Key I = 4200 1. Purchase Invoice 109 - Dated on June 2010 - BP = UE Vendor Services B 2. Line 10 = Service A - Invoiced Quantity = 17 - Net Unit Price =550 - Line Net Amount =9350 - Tax =Inversión Sujeto Pasivo 16% - Tax Key I = 9350 3. Line 20 = Service B - Invoiced Quantity = 1- Net Unit Price = 738 - Line Net Amount =738 - Tax =Inversión Sujeto Pasivo 7% - Tax Key I =738 4. Line 30 = Product A - Invoiced Quantity =1 - Net Unit Price = 227 - Line Net Amount =227- Tax =Adquisiciones Intracomunitarias 16% - Tax Key A =227 5. Line 40 = Product B - Invoice Quantity = 1 - Net Unit Price = 333 - Line Net Amount 33 - Tax= Adquisiciones Intracomunitarias 7% - Tax Key A=333 * Invoice 108 Total UE Vendor Service A = Tax Key A = 150 - Tax Key I = 4200 Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher and run: - Modelo 349 Mensual v210 for Jan-10 - Modelo 349 Mensual v210 for Feb-10 - Modelo 349 Mensual v210 for March-10 - Modelo 349 Mensual v210 for June-10 - Modelo 349 Mensual v210 for March-10 (bi-montly) - Modelo 349 Quater v210 for 1st Quarter - Modelo 349 Annual v210 for 2010 it always get the same file (see attached); but that should not be the case | |||||||
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 * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher * Select = Org349 * Report = Modelo 349 Mensual v 2010 * Period = Feb-10 * Press Input Parameters * Enter a File Name, Contact Person and Phone * Press Generate Electronic File * There should be 1 transaction in the file for UE Vendor Services A. Tax key I = 67500 * 1 transaction in the file for UE Vendor Services B. Tax Key I = 12655.29 * and 1 transaction in the file for UE Vendor Service B. Tax Key A=7400 * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher * Select = Org349 * Report = Modelo 349 Mensual v 2010 * Period = Marc-10 * Press Input Parameters * Enter a File Name, Contact Person and Phone * Press Generate Electronic File * There should be 1 transaction in the file for UE Vendor Products B. Tax key A = 19147 * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher * Select = Org349 * Report = Modelo 349 Mensual v 2010 * Period = June-10 * Press Input Parameters * Enter a File Name, Contact Person and Phone * Press Generate Electronic File * There should below transactions: * UE Vendor Product A - Key A =3850 * UE Vendor Product A - Key I =11550 * UE Vendor Product B - Key A=13205.40 * UE Vendor Product B - Key I=650 * UE Vendor Service A - Key A=150 * UE Vendor Service A - Key I=4200 * UE Vendor Service B - Key A=10088 * UE Vendor Service B - Key I=560 * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher * Select = Org349 * Report = Modelo 349 Mensual v 2010 * Period = Marc-10 * Press Input Parameters * Enter a File Name, Contact Person and Phone * Mark "Cambiar periodicidad del informe" flag as YES * Press Generate Electronic File * File should contain February and March Transactions below: * 1 transaction in the file for UE Vendor Services A. Tax key I = 67500 * 1 transaction in the file for UE Vendor Services B. Tax Key I = 12655.29 * 1 transaction in the file for UE Vendor Service B. Tax Key A=7400 * 1 transaction in the file for UE Vendor Products B. Tax key A = 19147 * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher * Select = Org349 * Report = Modelo 349 Trimestral v 2010 * Period = Jan-10 - Marc-10 * Press Input Parameters * Enter a File Name, Contact Person and Phone * Press Generate Electronic File * File should contain January, February and March Transactions below: * 1 transactions in the file for UE Vendor Products A - Tax key A = 9.000 * 1 transaction in the file for UE Vendor Products A - Tax Key I = 13750 * 1 transaction in the file for UE Vendor Services A. Tax key I = 67500 * 1 transaction in the file for UE Vendor Services B. Tax Key I = 12655.29 * 1 transaction in the file for UE Vendor Service B. Tax Key A=7400 * 1 transaction in the file for UE Vendor Products B. Tax key A = 19147 * Go to Financial Management // Accounting // Analysis Tools // Tax Report Launcher * Select = Org349 * Report = Modelo 349 Anual v 2010 * Period = Anually * Press Input Parameters * Enter a File Name, Contact Person and Phone * Press Generate Electronic File * File should contain January, February, March and June Transactions below: * 1 transactions in the file for UE Vendor Products A - Tax key A = 9.000+3850=12850 * 1 transaction in the file for UE Vendor Products A - Tax Key I = 13750 +11550=25300 * 1 transaction in the file for UE Vendor Services A. Tax key I = 67500 +4200=71700 * 1 transaction in the file for UE Vendor Services A. Tax Key A = 150=150 * 1 transaction in the file for UE Vendor Services B. Tax Key I = 12655.29 +560=13215.29 * 1 transaction in the file for UE Vendor Service B. Tax Key A=7400+10088=17488 * 1 transaction in the file for UE Vendor Products B. Tax key A = 19147 +13205.40=32352.40 * 1 transaction in the file for UE Vendor Products B. Tax Key I = 650=650 | |||||||
Tags | No tags attached. | |||||||
Attached Files | Feb_2010 [^] (4,502 bytes) 2010-04-20 18:56 [Show Content] | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0026594) 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:56 | psanjuan | New Issue | |
2010-04-20 18:56 | psanjuan | Assigned To | => vmromanos |
2010-04-20 18:56 | psanjuan | File Added: Feb_2010 | |
2010-04-20 18:57 | psanjuan | Assigned To | vmromanos => dalsasua |
2010-04-21 08:56 | dalsasua | Assigned To | dalsasua => vmromanos |
2010-04-21 11:05 | vmromanos | Status | new => scheduled |
2010-04-21 11:05 | vmromanos | fix_in_branch | => pi |
2010-04-21 11:15 | vmromanos | Relationship added | related to 0013056 |
2010-04-23 10:04 | hgbot | Checkin | |
2010-04-23 10:04 | hgbot | Note Added: 0026594 | |
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 => |
Copyright © 2000 - 2009 MantisBT Group |