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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036856
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2017-09-14 11:092017-09-21 16:50
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q4
StatusclosedFix in branchFixed in SCM revisionb870a4109237
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036856: No data found error when completing a invoice in organization without legal accounting in oracle instance

DescriptionNo data found error is shown when completing a invoice in organization without legal accounting in oracle instance

Query in C_Invoice_Post

SELECT C_CALENDAR_ID INTO v_calendarId FROM AD_ORG WHERE AD_ORG_ID = AD_ORG_GETCALENDAROWNER(v_Org_ID) ;

raises the no data error in oracle instance.
Steps To Reproduce- Login as F&B International Group Admin role.
- Use the Initial Org Setup process to create a Legal Without Accounting organization with F&B International Group as parent organization.
- Navigate to created organization and set it as ready.
- Create the required master data in F&B International Group organization:
  - Price Lists (one for sales and one for purchase)
  - Define a payment method, financial account, add payment method to
    financial account.
  - Business partners and locations (one customer and one vendor). Assign
    previously created price list. Set default Payment Terms, payment method.
  - Tax Category and Tax Rate.
  - Product. Add price to it in both price lists
  - Document Type: Sales Invoice and Purchase Invoice

- Create a Sales Invoice in newly created organization for created customer.
- Select Sales Invoice document type
- Add previously created product.
- Try to complete it.
- Realize that no data error is shown.

- Create a Purchase Invoice in newly created organization for created vendor.
- Select Purchase Invoice document type
- Add previously created product.
- Try to complete it.
- Realize that no data error is shown.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0036846 closedAtulOpenbravo Modules Cannot complete an inter-company invoice if the target organization or one of their parents are not Legal With Accounting 

-  Notes
(0099033)
AtulOpenbravo (developer)
2017-09-14 12:37

 - Login as F&B International Group Admin role.
- Use the Initial Org Setup process to create a Legal Without Accounting organization with F&B International Group as parent organization.
- Navigate to created organization and set it as ready.
- Create the required master data in F&B International Group organization:
  - Price Lists (one for sales and one for purchase)
  - Define a payment method, financial account, add payment method to
    financial account.
  - Business partners and locations (one customer and one vendor). Assign
    previously created price list. Set default Payment Terms, payment method.
  - Tax Category and Tax Rate.
  - Product. Add price to it in both price lists
  - Document Type: Sales Invoice and Purchase Invoice

- Create a Sales Invoice in newly created organization for created customer.
- Select Sales Invoice document type
- Add previously created product.
- Try to complete it.
- Realize that invoice is completed successfully.

- Create a Purchase Invoice in newly created organization for created vendor.
- Select Purchase Invoice document type
- Add previously created product.
- Try to complete it.
- Realize that invoice is completed successfully.
(0099044)
hgbot (developer)
2017-09-14 13:48

 Repository: erp/devel/pi
Changeset: b870a4109237b9b32ce55bf56782a7cdedd14ee8
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Sep 14 10:47:00 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/b870a4109237b9b32ce55bf56782a7cdedd14ee8 [^]

Fixes issue 36856: No data found error when completing a invoice

No data found error when completing a invoice in
organization without legal accounting in oracle instance

Avoid no data exception in oracle using a null value check for value
returned by AD_ORG_GETCALENDAROWNER

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0099045)
hgbot (developer)
2017-09-14 13:49

 Repository: erp/devel/pi
Changeset: 5883f31bb38c7d931d3e9566fbf1834991f046ae
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Sep 14 13:10:51 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5883f31bb38c7d931d3e9566fbf1834991f046ae [^]

Related to issue 36856: Code review improvements

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0099046)
aferraz (manager)
2017-09-14 13:50

 Code review + Testing OK
(0099394)
hudsonbot (developer)
2017-09-21 16:50

 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/9750b78d3e5c [^]
Maturity status: Test
(0099395)
hudsonbot (developer)
2017-09-21 16:50

 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/9750b78d3e5c [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-09-14 11:09 AtulOpenbravo New Issue
2017-09-14 11:09 AtulOpenbravo Assigned To => Triage Finance
2017-09-14 11:09 AtulOpenbravo Modules => Core
2017-09-14 11:09 AtulOpenbravo Triggers an Emergency Pack => No
2017-09-14 11:15 aferraz Assigned To Triage Finance => AtulOpenbravo
2017-09-14 12:37 AtulOpenbravo Status new => scheduled
2017-09-14 12:37 AtulOpenbravo Note Added: 0099033
2017-09-14 12:39 aferraz Relationship added related to 0036846
2017-09-14 13:48 hgbot Checkin
2017-09-14 13:48 hgbot Note Added: 0099044
2017-09-14 13:48 hgbot Status scheduled => resolved
2017-09-14 13:48 hgbot Resolution open => fixed
2017-09-14 13:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b870a4109237b9b32ce55bf56782a7cdedd14ee8 [^]
2017-09-14 13:49 hgbot Checkin
2017-09-14 13:49 hgbot Note Added: 0099045
2017-09-14 13:50 aferraz Review Assigned To => aferraz
2017-09-14 13:50 aferraz Note Added: 0099046
2017-09-14 13:50 aferraz Status resolved => closed
2017-09-14 13:50 aferraz Fixed in Version => 3.0PR17Q4
2017-09-21 16:50 hudsonbot Checkin
2017-09-21 16:50 hudsonbot Note Added: 0099394
2017-09-21 16:50 hudsonbot Checkin
2017-09-21 16:50 hudsonbot Note Added: 0099395

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker