Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0013056 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Localization Pack: Spain] AEAT 349 | critical | always | 2010-04-20 18:51 | 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 | 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 ] | ||||||||
|
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 => |
Copyright © 2000 - 2009 MantisBT Group |