Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020354Openbravo ERP09. Financial managementpublic2012-04-26 11:042012-05-31 13:59
maite 
dmiguelez 
urgentmajoralways
closedfixed 
5
 
3.0MP12 
Core
No
0020354: Add possibility to define specific account for COGS-Returns
Currently, is not possible to define several COGS accounts but just one general COGS account.
1. Go to Accounting Schema | Default values section and verify that you only can set one specific value for general COGS account
No tags attached.
Issue History
2012-04-26 11:04maiteNew Issue
2012-04-26 11:04maiteAssigned To => vmromanos
2012-04-26 11:04maiteModules => Core
2012-04-26 11:04maiteAssigned Tovmromanos => eduardo_Argal
2012-04-26 13:55dmiguelezAssigned Toeduardo_Argal => dmiguelez
2012-04-26 13:57dmiguelezStatusnew => scheduled
2012-04-26 13:57dmiguelezfix_in_branch => pi
2012-05-21 17:23hgbotCheckin
2012-05-21 17:23hgbotNote Added: 0048817
2012-05-21 17:23hgbotStatusscheduled => resolved
2012-05-21 17:23hgbotResolutionopen => fixed
2012-05-21 17:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1b61503d7d6a7049098feade90b6260d783f8bfe [^]
2012-05-21 18:39hgbotCheckin
2012-05-21 18:39hgbotNote Added: 0048832
2012-05-21 18:41hgbotCheckin
2012-05-21 18:41hgbotNote Added: 0048833
2012-05-21 18:41hgbotCheckin
2012-05-21 18:41hgbotNote Added: 0048835
2012-05-24 13:44hgbotCheckin
2012-05-24 13:44hgbotNote Added: 0048910
2012-05-25 12:13hudsonbotCheckin
2012-05-25 12:13hudsonbotNote Added: 0049180
2012-05-28 11:52hgbotCheckin
2012-05-28 11:52hgbotNote Added: 0049347
2012-05-31 13:59miruritaNote Added: 0049539
2012-05-31 13:59miruritaStatusresolved => closed
2012-05-31 13:59miruritaFixed in Version => 3.0MP12

Notes
(0048817)
hgbot   
2012-05-21 17:23   
Repository: erp/devel/pi
Changeset: 1b61503d7d6a7049098feade90b6260d783f8bfe
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon May 21 16:57:34 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1b61503d7d6a7049098feade90b6260d783f8bfe [^]

Fixes issue 20354: Added the possibility to define specific accounts
for COGS return and Revenue return.

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/ProcessInvoice.java
M referencedata/sampledata/F_B_International_Group.xml
M referencedata/standard/Initial_Setup.xml
M src-db/database/model/functions/C_ACCTSCHEMA_DEFAULT_COPY.xml
M src-db/database/model/functions/M_PRODUCT_CATEGORY_ACCT_COPY.xml
M src-db/database/model/tables/C_ACCTSCHEMA_DEFAULT.xml
M src-db/database/model/tables/M_PRODUCT_ACCT.xml
M src-db/database/model/tables/M_PRODUCT_CATEGORY_ACCT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
M src-util/modulescript/src/org/openbravo/modulescript/UpdateReversalDocumentTypes_Data.xsql
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
M src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
M src/org/openbravo/erpCommon/ad_forms/DocInOut.java
M src/org/openbravo/erpCommon/ad_forms/DocInvoice.java
M src/org/openbravo/erpCommon/ad_forms/ProductInfo.java
M src/org/openbravo/erpCommon/ad_forms/ProductInfo_data.xsql
M src/org/openbravo/erpCommon/businessUtility/InitialSetupUtility.java
---
(0048832)
hgbot   
2012-05-21 18:39   
Repository: erp/pmods/org.openbravo.document.massinvoicing
Changeset: 8ca35f73d1e74c8cfd69f959475aef74bc26b126
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon May 21 18:38:29 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.document.massinvoicing/rev/8ca35f73d1e74c8cfd69f959475aef74bc26b126 [^]

Related to issue 0020354: Adds compatibility with new Document Type.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0048833)
hgbot   
2012-05-21 18:41   
Repository: erp/mods/org.openbravo.storno.invoice
Changeset: a6dcc7a39567cf1e278bfc27590d73434b623385
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon May 21 18:40:45 2012 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.storno.invoice/rev/a6dcc7a39567cf1e278bfc27590d73434b623385 [^]

Related to issue 0020354: Adds compatibility with new Document Type.

---
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0048835)
hgbot   
2012-05-21 18:41   
Repository: erp/mods/org.openbravo.alerts.accounting30
Changeset: 68b26976798e3b2195bff2fcbf7b92c3e73a1637
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon May 21 18:41:29 2012 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.alerts.accounting30/rev/68b26976798e3b2195bff2fcbf7b92c3e73a1637 [^]

Related to issue 0020354: Adds compatibility with new Document Type.

---
M referencedata/standard/Accounting_Alerts.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0048910)
hgbot   
2012-05-24 13:44   
Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: ff2f2e5f9c482ce9c4975c045bce6645b4af19d0
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu May 24 13:43:15 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/ff2f2e5f9c482ce9c4975c045bce6645b4af19d0 [^]

Related to issue 0020354: Adds compatibility with new Document Type.

---
M src-db/database/model/functions/ACCDEF_GENERATE_PLAN.xml
---
(0049180)
hudsonbot   
2012-05-25 12:13   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test
(0049347)
hgbot   
2012-05-28 11:52   
Repository: erp/mods/org.openbravo.obtvb
Changeset: d93674dae5b88914bb74a6bd087e4cf7eadd2da6
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon May 28 11:52:22 2012 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.obtvb/rev/d93674dae5b88914bb74a6bd087e4cf7eadd2da6 [^]

Related to issue 0020354: Adds compatibility with new Document Type.

---
M src/org/openbravo/obtvb/process/DocFINAccTransactionVatPosting.java
M src/org/openbravo/obtvb/process/DocFINPaymentVatPosting.java
M src/org/openbravo/obtvb/process/DocFINReconciliationVatPosting.java
M src/org/openbravo/obtvb/process/DocPaymentVatPosting.java
---
(0049539)
mirurita   
2012-05-31 13:59   
Testing Plan
1) Create a new client from Initial Client Setup window
    - Include accounting and upload COA file
    - Select Accounting Dimensions: Business Partner, Product and Project.
    - Select "Standard document types for orders, invoices, etc. and settings - Core - English (USA)" dataset.
2) Create new org legal with accounting.
3) Create data needed to create/post: "Return from Customer", "Goods Shipment", "Return Material Receipt" and "Sales Invoice"
4) Check document types
    - Return Material Sales Invoice document should exists
    - Return Material Sales Invoice document is set as Document Type for shipment on RFC Order.
5) Create new product category - clothes
6) Go to Accounting Schema and check defaults.
    - Product COSGS
    - Product Revenue Return
7) Click on Copy accounts and verify that accounts have been populated on product category accounting.
8) Create new product - hat
9) Go to product category and copy accounts. verify that accounts have been populated on product accounting.
10) Create a new Goods Shipment
11) Create a new Return from Customer for previous shipment
12) Create a new Return Material Receipt
13) Create a entry on costing tab for the product (needed to able to post).
14) Post the Return Material Receipt document.
15) The account on credit should be the one selected on Product COGS return.
16) Remove this account from Product >> Accounting
17) Unpost the RMR and post it again
18) Now it should use the account defined on Product Revenue
19) Create a new Sales Invoice for previous RMR
20) Post it. The account on debit should be the one configured on product revenue return account.
21) Remove the account for Product revenue return on product >> accounting tab.
22) Unpost previous sales invoice and post it again. The account on debit should be the one configured on product revenue return account.

Changes on F&B
1) F&B should have two new document types with corresponding sequences
- Return Material Sales Invoice
- ES Return Material Sales Invoice