Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015147
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersmajoralways2010-11-10 11:232010-12-09 16:07
ReportermaiteView Statuspublic 
Assigned Tomirurita 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiona0a27382dca7
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Review Assigned To
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015147: Error "paymentrule" is null when using intercompany module

DescriptionWhen 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 Reproduce1. 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 SolutionThe 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  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 (manager)
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 (manager)
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 (manager)
2010-11-16 16:56

Fixed in 2.1.6

- 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 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker