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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029812
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Service Contract Managementmajoralways2015-05-07 15:502015-05-13 18:13
ReporterngarciaView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision2788ad41280f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned Toumartirena
Regression introduced in release
Summary

0029812: Cannot launch Contract Billing Process if From Order is selected and the Invoicing Date - Month of the Period is not null

DescriptionCannot launch Contract Billing Process if From Order is selected and the Invoicing Date - Month of the Period is not null.

The problem is the v_invoicing_monthofperiod variable of the obscntr_get_dis_invoicing_day function has a char value and it is used in a condition with '<'

Definition in obscntr_get_dis_invoicing_day function:

v_invoicing_monthofperiod OBSCNTR_INVOICESCHEDULE.DIS_INVOICING_MONTHOFPERIOD%TYPE;

Definition in OBSCNTR_INVOICESCHEDULE table:

dis_invoicing_monthofperiod character varying(60),
Steps To ReproduceAs group admin role:
   Create a Contract Invoice Schedule
   Set the Invoice Frequency as Annual
   Select an Invoicing Date - Month of the period
   Create a Contract with that Contract Invoice Schedule
   Add a Invoice Plan Master
   Complete it (Generate Invoice Plan)
   Create a Sales Order, assign the previously created contract to it, Invoice Terms = Contract Billing and book it
   Launch the Contract Billing Process selecting the From Order option
   The following error message is shown:
      0: ERROR: operator does not exist: numeric < character varying
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0077379)
vmromanos (manager)
2015-05-13 13:30

Apply Service contract dataset to *

Create a Contract Invoice Schedule
 Org = *
 Name = Annual
 Inside regular services field group:
   Set the Invoice Frequency as Annual
   Set to false the checkboxes of the first column
   Set to 1 the * Day of month fields
   Set to 01 the * Month of Period
   Set to Current the * - Period field
 Leave the default values in the rest of the fields inside this window

Create a contract type
  Org = *
  Service Contract = Y

Test plan:
Create a new contract:
  org = FB España
  bp = Alimentos
  start date = today
  price list = tarifa de ventas
  payment terms = 30 days
  payment method = transferencia
  contract invoice schedule = Annual
  Duration = 3 Years
Create an invoice plan master line:
  start date = today
  product = Agua
  quantity 10
Complete and update the invoice plan


Create a new sales order:
  org = FB España
  bp = Alimentos
  contract = previously created
  invoice terms = contract billing
Add any line and book it

Go to contract billing process:
  start date = 01/01/2015
  end date = 01/01/2017
  From order = Y
  From contract = Y

Verify the process is launched successfully and that several invoice proposals have been created
(0077413)
hgbot (developer)
2015-05-13 18:12

Repository: erp/pmods/org.openbravo.contract.services
Changeset: 2788ad41280f4bf1496d6d1299b2fe1166dd7e0c
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Wed May 13 11:26:45 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.contract.services/rev/2788ad41280f4bf1496d6d1299b2fe1166dd7e0c [^]

Fixed bug 29812: data type error in pl functions,
The v_invoicing_monthofperiod pl variable was declared as varchar instead of numeric, creating a problem when the variable was used.
The solution is to force this variable to be a NUMBER(2,0)

---
M src-db/database/model/functions/OBSCNTR_GET_DIS_INVOICE_DAY.xml
M src-db/database/model/functions/OBSCNTR_GET_DIS_INVOICING_DAY.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0077414)
umartirena (reporter)
2015-05-13 18:13

Code Review + Testing OK

- Issue History
Date Modified Username Field Change
2015-05-07 15:50 ngarcia New Issue
2015-05-07 15:50 ngarcia Assigned To => Triage Finance
2015-05-07 15:50 ngarcia Resolution time => 1433887200
2015-05-07 15:51 ngarcia Issue Monitored: networkb
2015-05-07 16:27 ngarcia Steps to Reproduce Updated View Revisions
2015-05-12 16:31 aferraz Assigned To Triage Finance => aferraz
2015-05-12 16:56 aferraz Assigned To aferraz => vmromanos
2015-05-13 11:12 vmromanos Status new => scheduled
2015-05-13 13:30 vmromanos Note Added: 0077379
2015-05-13 18:12 hgbot Checkin
2015-05-13 18:12 hgbot Note Added: 0077413
2015-05-13 18:12 hgbot Status scheduled => resolved
2015-05-13 18:12 hgbot Resolution open => fixed
2015-05-13 18:12 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.contract.services/rev/2788ad41280f4bf1496d6d1299b2fe1166dd7e0c [^]
2015-05-13 18:13 umartirena Review Assigned To => umartirena
2015-05-13 18:13 umartirena Note Added: 0077414
2015-05-13 18:13 umartirena Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker