Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004696Openbravo ERP03. Procurement managementpublic2008-08-24 20:282008-09-01 11:22
Wimt 
cromero 
normalmajorhave not tried
closedduplicate 
20Ubuntu 8.04
2.40beta 
 
No
Core
No
0004696: Pending Goods Receipt gives "Process failed during execution"
Running the Pending Goods Receipt process after creating a PO fails with an error.
Openbravo.log shows:

ERROR org.openbravo.erpCommon.ad_forms.MaterialReceiptPendingData - SQL error in query: SELECT AD_GET_DOCTYPE(TO_NUMBER(?), TO_NUMBER(?), 'MMR', null) FROM DUAL Exception:org.postgresql.util.PSQLException: The column name AD_GET_DOCTYPE(TO_NUMBER(:1),TO_NUMBER(:2),'MMR',NULL) was not found in this ResultSet.
20:13:19 [http-8180-Processor23] WARN org.openbravo.base.secureApp.HttpSecureAppServlet - Rollback in transaction
1. Create a PO and complete it.
2. Start the Pending Goods Receipt process
3. Check the box for the item to receive, enter receive date, number of items and select location.
4. Click "Process" button
No tags attached.
duplicate of defect 0004626 closed jpabloae Installing from binaries, window bankstatement does not work 
Issue History
2008-08-24 20:28WimtNew Issue
2008-08-24 20:28WimtAssigned To => cromero
2008-08-24 20:28Wimtsf_bug_id0 => 2072000
2008-09-01 11:22psarobeRegression testing => No
2008-09-01 11:22psarobeRelationship addedduplicate of 0004626
2008-09-01 11:22psarobeStatusnew => closed
2008-09-01 11:22psarobeNote Added: 0008806
2008-09-01 11:22psarobeDuplicate ID0 => 4626
2008-09-01 11:22psarobeResolutionopen => duplicate

Notes
(0008806)
psarobe   
2008-09-01 11:22   
The workaround is very easy. You have to compile the window goods receipts

Regards