Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015147 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2010-11-10 11:23 | 2010-12-09 16:07 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | mirurita | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | a0a27382dca7 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Advanced Payables and Receivables Mngmt | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0015147: Error "paymentrule" is null when using intercompany module | |||||||
| Description | When using IntercompanyDocuments module and APR module, you get the following error "null value in column "paymentrule" violates not-null constraint" when trying to process Inter-company Sales Invoice document. As you are using APRM, field paymentrule should not be required. | |||||||
| Steps To Reproduce | 1. Install last version of Intercompany Documents module and APR module 2. Apply APRM dataset 2. Follow http://wiki.openbravo.com/wiki/Projects/intercompanyinvoicing/User_Guide#Definition_of_Inter-company_Document_Types [^] 3. Create Financial Management || Receivables & Payables || Transactions || Financial Account 4. Create Financial Management || Receivables & Payables || Setup || Payment Method || Payment Method , and associate it to the Financial Account 5. Create 2 new Business Partner: BP1 y BP2, and set PaymentMethod for both 6. Go to General Setup || Enterprise || Organization || Organization >> Information for Org A and set BP1 7. Go to General Setup || Enterprise || Organization || Organization >> Information for Org B and set BP2 8. Go to Sales Management || Transactions || Sales Invoice || Header and create "Inter-company Sales Invoice document" for BP1 and Org B 9. Process and you will obtain error "null value in column "paymentrule" violates not-null constraint" | |||||||
| Proposed Solution | The problem is in function "interco_create_invoice". When selecting data from business partner, a COALESCE is performing for "paymentrule" but not for "PaymentRulePO". Due to that, when trying to create Purchase Invoice value is null. COALESCE should also be performed for PaymentRulePO field | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0032581) hgbot (developer) 2010-11-12 11:36 |
Repository: erp/pmods/org.openbravo.interco Changeset: a0a27382dca7c4dfd7e1d20fc32fafc0ee635262 Author: Mikel Irurita <mikel.irurita <at> openbravo.com> Date: Fri Nov 12 11:34:51 2010 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.interco/rev/a0a27382dca7c4dfd7e1d20fc32fafc0ee635262 [^] Fixes issue 15147: Error paymentrule is null when using intercompany module --- M src-db/database/model/functions/INTERCO_CREATE_INVOICE.xml M src-db/database/model/functions/INTERCO_CREATE_ORDER.xml --- |
|
(0032613) adrianromero (viewer) 2010-11-15 12:22 |
This fix modifies the CREATE_INVOICE process and CREATE_ORDER process to take into account the fields v_paymentMethod, v_paymentMethodPO when generating a new Invoice or a new Order. |
|
(0032614) adrianromero (viewer) 2010-11-15 12:24 |
* Testing the issue Kindly follow the steps to test and verify that now when creating Inter-company Sales Invoice document no error is thrown when APRM module is installed * Other areas affected No other areas affected just the processes of creating Inter-company invoices and orders. |
|
(0032638) adrianromero (viewer) 2010-11-16 16:56 |
Fixed in 2.1.6 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-11-10 11:23 | maite | New Issue | |
| 2010-11-10 11:23 | maite | Assigned To | => mirurita |
| 2010-11-10 11:23 | maite | OBNetwork customer | => Yes |
| 2010-11-10 11:23 | maite | Issue Monitored: networkb | |
| 2010-11-12 11:34 | mirurita | Status | new => scheduled |
| 2010-11-12 11:34 | mirurita | fix_in_branch | => pi |
| 2010-11-12 11:36 | hgbot | Checkin | |
| 2010-11-12 11:36 | hgbot | Note Added: 0032581 | |
| 2010-11-12 11:36 | hgbot | Status | scheduled => resolved |
| 2010-11-12 11:36 | hgbot | Resolution | open => fixed |
| 2010-11-12 11:36 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.interco/rev/a0a27382dca7c4dfd7e1d20fc32fafc0ee635262 [^] |
| 2010-11-15 12:22 | adrianromero | Note Added: 0032613 | |
| 2010-11-15 12:24 | adrianromero | Note Added: 0032614 | |
| 2010-11-16 16:56 | adrianromero | Note Added: 0032638 | |
| 2010-11-16 16:56 | adrianromero | Status | resolved => closed |
| 2010-12-09 16:07 | anonymous | sf_bug_id | 0 => 3133550 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |