Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008208Openbravo ERP06. Material requirement planning (MRP)public2009-03-19 20:262009-07-17 11:57
RenateNieuwkoop 
areefbasha 
immediatemajorhave not tried
closedfixed 
5
2.50alpha-r11 
pi 
Core
No
0008208: 250 VM: Purchasing Plan: Error when Processing
Material Requirement Planning (MRP) || Transactions || Purchasing Plan || Header

When running the purchasing plan in 250 VM I get an error (see snapshot 1) and also when running in our 250 Training environment (based on 250 alpha r11) (see snapshot 2)
MRP || Setup || Planner: create John Planner
MRP || Setup || Planning Method: Pending Purchase Order and Pending Sales Order
update product Hammer:
Purchasing tab: minimum order qty=1, Purchasing leadtime= 14 Qty type= multiple, Standard qty=1,
Org specific tab: Planning method= as above created, Planner=John Planner, Minimum qty= 500, qty type= multiple, Standard qty=500, Minimum leadtime=7, safety stock=1000
PO: BP= Obelix, on the line 40 Hammers
SO: BP=Red bunny, on the line 350 hammers
Enter Purchasing Plan:
Time horizon=60
Safety leadtime=2
Planner=John Planner
Product=Hammer
rest of the filters blank
'Process Purchase Plan'
250 QA, 250MP1
related to defect 0008215 closed vmromanos 250 Alpha r11 Training: Error when processing Tax Payment 
has duplicate defect 0008413 closed rafaroda System throws error message when the user clicks the process purchasing plan button. 
related to defect 0008209 closed vinothbabu 250 VM: Manufacturing plan: Error when processing the plan 
jpg 190309PPVM250.jpg (250,032) 2009-03-19 20:26
https://issues.openbravo.com/file_download.php?file_id=1036&type=bug
jpg

jpg 190309PP250.jpg (215,924) 2009-03-19 20:28
https://issues.openbravo.com/file_download.php?file_id=1037&type=bug
jpg

jpg 100409ProcessTaxPaymentError.jpg (204,416) 2009-04-10 19:17
https://issues.openbravo.com/file_download.php?file_id=1167&type=bug
jpg

png 150409ProcessTaxPaymentSuccess.png (218,775) 2009-04-15 13:31
https://issues.openbravo.com/file_download.php?file_id=1183&type=bug
png
Issue History
2009-03-19 20:26RenateNieuwkoopNew Issue
2009-03-19 20:26RenateNieuwkoopAssigned To => rafaroda
2009-03-19 20:26RenateNieuwkoopFile Added: 190309PPVM250.jpg
2009-03-19 20:27RenateNieuwkoopNote Added: 0014806
2009-03-19 20:28RenateNieuwkoopFile Added: 190309PP250.jpg
2009-03-26 11:19psarobeAssigned Torafaroda => gorkaion
2009-03-26 11:19psarobePrioritynormal => high
2009-03-26 11:19psarobeSeveritycritical => major
2009-03-26 11:19psarobeStatusnew => scheduled
2009-03-30 13:17rafarodaAssigned Togorkaion => sathiyan
2009-03-30 13:24sathiyanAssigned Tosathiyan => areefbasha
2009-04-01 16:59psarobeTag Attached: 250 QA
2009-04-02 15:22pjuvaraPriorityhigh => urgent
2009-04-03 10:05pjuvaraPriorityurgent => immediate
2009-04-03 15:25hgbotCheckin
2009-04-03 15:25hgbotNote Added: 0015169
2009-04-03 15:25hgbotStatusscheduled => resolved
2009-04-03 15:25hgbotResolutionopen => fixed
2009-04-03 15:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/58809e59b61c24205927bc02e528b313c3222309 [^]
2009-04-03 16:43sureshbabuRegression testing => No
2009-04-03 16:43sureshbabuStatusresolved => closed
2009-04-03 16:43sureshbabuNote Added: 0015173
2009-04-03 16:43sureshbabuFixed in Version => 2.50beta
2009-04-09 08:33rafarodaRelationship addedrelated to 0008209
2009-04-09 17:34rafarodaRelationship addedhas duplicate 0008413
2009-04-10 19:16RenateNieuwkoopStatusclosed => new
2009-04-10 19:16RenateNieuwkoopResolutionfixed => open
2009-04-10 19:16RenateNieuwkoopNote Added: 0015321
2009-04-10 19:16RenateNieuwkoopFixed in Version2.50beta =>
2009-04-10 19:17RenateNieuwkoopFile Added: 100409ProcessTaxPaymentError.jpg
2009-04-11 14:45rafarodaNote Added: 0015343
2009-04-11 14:45rafarodaStatusnew => feedback
2009-04-11 20:13RenateNieuwkoopNote Added: 0015344
2009-04-14 11:40rafarodaStatusfeedback => scheduled
2009-04-14 11:40rafarodafix_in_branch => pi
2009-04-15 13:31areefbashaNote Added: 0015369
2009-04-15 13:31areefbashaStatusscheduled => feedback
2009-04-15 13:31areefbashafix_in_branchpi =>
2009-04-15 13:31areefbashaFile Added: 150409ProcessTaxPaymentSuccess.png
2009-04-22 14:25rafarodaNote Added: 0015536
2009-04-22 14:29RenateNieuwkoopNote Added: 0015537
2009-04-23 16:04psarobeTag Attached: 250MP1
2009-04-24 12:42rafarodaRelationship addedrelated to 0008215
2009-04-24 12:42rafarodaStatusfeedback => scheduled
2009-04-24 12:42rafarodafix_in_branch => pi
2009-04-24 12:43rafarodaStatusscheduled => resolved
2009-04-24 12:43rafarodaFixed in Version2.50 =>
2009-04-24 12:43rafarodaFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/58809e59b61c24205927bc02e528b313c3222309 [^] => 58809e59b61c
2009-04-24 12:43rafarodaResolutionopen => fixed
2009-04-24 12:43rafarodaNote Added: 0015688
2009-05-04 18:57psarobeStatusresolved => closed
2009-05-05 00:00anonymoussf_bug_id0 => 2786885
2009-07-03 13:12hgbotCheckin
2009-07-03 13:12hgbotNote Added: 0017827
2009-07-03 13:12hgbotStatusclosed => resolved
2009-07-03 13:12hgbotFixed in SCM revision58809e59b61c => http://code.openbravo.com/erp/devel/pi/rev/c51ac510f7d3759ef09ba2f9b8970bb240ebbc8e [^]
2009-07-17 11:57sureshbabuStatusresolved => closed
2009-07-17 11:57sureshbabuNote Added: 0018358
2009-07-17 11:57sureshbabuFixed in Version2.50MP1 => pi

Notes
(0014806)
RenateNieuwkoop   
2009-03-19 20:27   
I ran our 2.50 Training on Postgre
(0015169)
hgbot   
2009-04-03 15:25   
Repository: erp/devel/pi
Changeset: 58809e59b61c24205927bc02e528b313c3222309
Author: Areef Basha <areef.basha <at> openbravo.com>
Date: Fri Apr 03 18:53:22 2009 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/58809e59b61c24205927bc02e528b313c3222309 [^]

Fixes bug 8208: Purchasing Plan: Error when Processing.

Now the variable data type numeric has been changed to varchar2.

---
M src-db/database/model/functions/MRP_PURCHASEPLAN.xml
---
(0015173)
sureshbabu   
2009-04-03 16:43   
Tested working fine
(0015321)
RenateNieuwkoop   
2009-04-10 19:16   
Same error now occurring for the Tax Payment processing (will add snapshot)
(0015343)
rafaroda   
2009-04-11 14:45   
Renate,

If you want Create VAT Registers process to be fixed ASAP, please detail the steps to reproduce this issue.

Thank you.
(0015344)
RenateNieuwkoop   
2009-04-11 20:13   
First of all I'm using an imported client.

Financial Management || Receivables & Payables || Setup || Tax Payment
create a register type for Sales Tax (checkbox Sales transaction selected) for AR Invoice and for Purchase Tax (checkbox Sales transactions not selected) for AP invoice

Then enter and complete a Sales Invoice and a Purchase Invoice

Financial Management || Receivables and Payables || Transactions || Tax Payment
for starting date 1st of this month, end date last day of the month
select 'generate payment'
Click 'Create VAT Registers'

Then the error message appears: see the snapshot I added
(0015369)
areefbasha   
2009-04-15 13:31   
Renate,

I could not able to reproduce the attached screen shot(100409ProcessTaxPaymentSuccess.jpg).

I did the steps as you said.

Please let me know if any specific configuration(more detail steps) is needed to reproduce this issue.

A snapshot is added for success message.

Thank you.
(0015536)
rafaroda   
2009-04-22 14:25   
Reminder sent to: RenateNieuwkoop

Hi Renate,

Could you please provide the information required as soon as possible?

Thank you.
(0015537)
RenateNieuwkoop   
2009-04-22 14:29   
I saw that issue 8215 was fixed, which is for Tax Payment also, so I've asked Rok to put the changes in our environment (which he will do this afternoon) and I'll be retesting this afternoon then.

I'll let you know the outcome,

cheers
Renate
(0015688)
rafaroda   
2009-04-24 12:43   
Renate,

This issue has been properly resolved. Please refer to 0008215 for the Tax Payment problem.

Thanks.
(0017827)
hgbot   
2009-07-03 13:12   
Repository: erp/devel/pi
Changeset: c51ac510f7d3759ef09ba2f9b8970bb240ebbc8e
Author: Areef Basha <areef.basha <at> openbravo.com>
Date: Fri Apr 03 18:53:22 2009 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/c51ac510f7d3759ef09ba2f9b8970bb240ebbc8e [^]

Fixes bug 8208: Purchasing Plan: Error when Processing.

Now the variable data type numeric has been changed to varchar2.

---
M src-db/database/model/functions/MRP_PURCHASEPLAN.xml
---
(0018358)
sureshbabu   
2009-07-17 11:57   
Tested working fine