Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014122ModulesAccruals and Deferralspublic2010-08-04 11:462010-08-26 14:42
Reporternetworkb 
Assigned Tosathiyan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version1.0.8 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerOBPS
Regression introduced in release
Summary0014122: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-08-04 11:46networkbNew Issue
2010-08-04 11:46networkbAssigned To => sathiyan
2010-08-04 11:46networkbOBNetwork customer => Yes
2010-08-17 14:51sathiyanStatusnew => scheduled
2010-08-17 14:51sathiyanfix_in_branch => pi
2010-08-20 08:38hgbotCheckin
2010-08-20 08:38hgbotNote Added: 0030167
2010-08-20 08:38hgbotStatusscheduled => resolved
2010-08-20 08:38hgbotResolutionopen => fixed
2010-08-20 08:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/da195ff37595b853cc56450b99f2bce89f5ba65d [^]
2010-08-23 13:56psanjuanNote Added: 0030226
2010-08-23 13:56psanjuanStatusresolved => new
2010-08-23 13:56psanjuanfix_in_branchpi =>
2010-08-24 07:52hgbotCheckin
2010-08-24 07:52hgbotNote Added: 0030240
2010-08-26 13:31sathiyanStatusnew => acknowledged
2010-08-26 13:32sathiyanStatusacknowledged => scheduled
2010-08-26 13:32sathiyanfix_in_branch => pi
2010-08-26 13:32sathiyanStatusscheduled => resolved
2010-08-26 14:42psanjuanNote Added: 0030360
2010-08-26 14:42psanjuanFixed in Version => 1.0.8
2010-08-26 14:42psanjuanfix_in_branchpi =>
2010-08-26 14:42psanjuanNote Added: 0030361
2010-08-26 14:42psanjuanStatusresolved => closed

Notes
(0030167)
hgbot   
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   
2010-08-23 13:56   
an issue can not be set as resolved until the module is published in test mode.
(0030240)
hgbot   
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   
2010-08-26 14:42   
Bug fixed. Tested for Sales Invoices and Purchase Invoices.
Fixed in Acc&Def module version 1.08
(0030361)
psanjuan   
2010-08-26 14:42   
Bug fixed. Tested for Sales Invoices and Purchase Invoices.
Fixed in Acc&Def module version 1.08