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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014122
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Accruals and Deferralsmajoralways2010-08-04 11:462010-08-26 14:42
ReporternetworkbView Statuspublic 
Assigned Tosathiyan 
PriorityurgentResolutionfixedFixed in Version1.0.8
StatusclosedFix in branchFixed in SCM revisionda195ff37595
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerOBPS
Regression introduced in release
Summary

0014122: You can not complete an invoice with accruals and deferrals' data and 'Financial Invoice Line' checked

DescriptionIf you have an invoice with:

(header)
- Acc. and Def. Type
- Date From
- Date to

(lines)
- Financial Invoice Line (checked)

You can not complete the Invoice, this error appears:


Error:
el valor null para la columna «m_product_id» viola la restricción not null

If we don't introduce Acc. and Def. Type, Date From and Date to we can complete the invoice perfectly
Steps To Reproduce- As Openbravo Admin go to Financial Management || Accounting || Setup || G/L Item
- Select 'Sueldos y salarios'
- Check 'Enable In Financial Invoices'
- Tax category: exempt

- Go to Sales Management || Transactions || Sales Invoice
- Create a new record:
   - Acc. and Def. Type: Deferred income
   - Date From: 01-08-2010
   - Date to: 31-08-2010
- go to Lines:
   - check Financial Invoice Line
   - Account: Sueldos y Salarios
   - Net Unit Price: 5
- Complete it
- Realize that error appears
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0030167)
hgbot (developer)
2010-08-20 08:38

Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: da195ff37595b853cc56450b99f2bce89f5ba65d
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Fri Aug 20 12:07:26 2010 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/da195ff37595b853cc56450b99f2bce89f5ba65d [^]

Fixes Issue 14122: You can not complete an invoice with acc and def with 'Financial Invoice Line' checked

---
M src-db/database/model/functions/ACCDEF_GENERATE_PLAN.xml
M src-db/database/model/tables/ACCDEF_PLAN_LINE.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/accrualsanddeferrals/erpCommon/ad_forms/AccDefPlanLine.java
M src/org/openbravo/accrualsanddeferrals/erpCommon/ad_forms/DocAccDefPlan.java
M src/org/openbravo/accrualsanddeferrals/erpCommon/ad_forms/DocAccDefPlanLine_data.xsql
---
(0030226)
psanjuan (viewer)
2010-08-23 13:56

an issue can not be set as resolved until the module is published in test mode.
(0030240)
hgbot (developer)
2010-08-24 07:52

Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: acc93009b3cc459a88a5dbf229348e6e8aaa9de3
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Tue Aug 24 11:21:55 2010 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/acc93009b3cc459a88a5dbf229348e6e8aaa9de3 [^]

update the version to 1.0.8 to test the issue 14122.

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0030360)
psanjuan (viewer)
2010-08-26 14:42

Bug fixed. Tested for Sales Invoices and Purchase Invoices.
Fixed in Acc&Def module version 1.08
(0030361)
psanjuan (viewer)
2010-08-26 14:42

Bug fixed. Tested for Sales Invoices and Purchase Invoices.
Fixed in Acc&Def module version 1.08

- Issue History
Date Modified Username Field Change
2010-08-04 11:46 networkb New Issue
2010-08-04 11:46 networkb Assigned To => sathiyan
2010-08-04 11:46 networkb OBNetwork customer => Yes
2010-08-17 14:51 sathiyan Status new => scheduled
2010-08-17 14:51 sathiyan fix_in_branch => pi
2010-08-20 08:38 hgbot Checkin
2010-08-20 08:38 hgbot Note Added: 0030167
2010-08-20 08:38 hgbot Status scheduled => resolved
2010-08-20 08:38 hgbot Resolution open => fixed
2010-08-20 08:38 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/da195ff37595b853cc56450b99f2bce89f5ba65d [^]
2010-08-23 13:56 psanjuan Note Added: 0030226
2010-08-23 13:56 psanjuan Status resolved => new
2010-08-23 13:56 psanjuan fix_in_branch pi =>
2010-08-24 07:52 hgbot Checkin
2010-08-24 07:52 hgbot Note Added: 0030240
2010-08-26 13:31 sathiyan Status new => acknowledged
2010-08-26 13:32 sathiyan Status acknowledged => scheduled
2010-08-26 13:32 sathiyan fix_in_branch => pi
2010-08-26 13:32 sathiyan Status scheduled => resolved
2010-08-26 14:42 psanjuan Note Added: 0030360
2010-08-26 14:42 psanjuan Fixed in Version => 1.0.8
2010-08-26 14:42 psanjuan fix_in_branch pi =>
2010-08-26 14:42 psanjuan Note Added: 0030361
2010-08-26 14:42 psanjuan Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker