Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Auto BOM For Retailmajoralways2018-06-01 14:092019-06-06 08:31
ReporterVictorVillarView Statuspublic 
Assigned Torqueralta 
PriorityurgentResolutionfixedFixed in VersionRR18Q3
StatusclosedFix in branchFixed in SCM revision43dd593fac94
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0038687: Autobom not working wth products that have attributes and if there is not stock.

DescriptionAutobom not working wth products that have attributes and if there is not stock.
Steps To ReproduceInstall [^] [^] module.

Login to Openbravo backoffice:
 * Go to Preference window and create a new preference for Property "Auto BOM: Allow negative stock in raw materials" with value "Y"
 * Go to "Lot Number Sequence" window and create a new record:
   - Name: LOT
   - Starting No: 100
   - Incremented By: 1
   - Next Assigned Number: 100
 * Go to "Attribute Set" window and create a new record:
   - Name: LOT
   - Lot flag checked.
   - Lot Control: LOT
 * Go to Product window and search "Mountain pack" product.
   - Check "Auto Generate BOM" property
   - Set "Attribute Set": Lot
   - In "Manufacturing" tab (In order to display this tab the instance needs to be active and "Apply configuration script" flag in Retail Template unchecked. After unchecking update.database is needed) add new record:
      * Organization: Vall Blanca Store
      * Storage Bin: VBS/001 0-0-0
 * Search "Europe mountains guide" product in Product window.
   - Set "Attribute Set": Lot

Login into Web POS:
  * Add "Mountain pack" product.
  * Pay and close the ticket.

Login into backoffice:
  * Open Errors While Importing window. The following error appears:

org.postgresql.util.PSQLException: ERROR: @20112@ - Mountain pack
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
    at org.postgresql.core.v3.QueryExecutorImpl.execute(
    at org.postgresql.jdbc.PgStatement.executeBatch(
    at org.postgresql.jdbc.PgPreparedStatement.executeBatch(
    at sun.reflect.GeneratedMethodAccessor811.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(
    at com.sun.proxy.$Proxy26.executeBatch(Unknown Source)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(
    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(
    at org.hibernate.jdbc.AbstractBatcher.prepareStatement(
    at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(
    at org.hibernate.action.EntityInsertAction.execute(
    at org.hibernate.engine.ActionQueue.execute(
    at org.hibernate.engine.ActionQueue.executeActions(
    at org.hibernate.engine.ActionQueue.executeActions(
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(
    at org.hibernate.impl.SessionImpl.flush(
    at org.openbravo.dal.service.OBDal.flush(
    at org.openbravo.dal.service.OBDal.getConnection(
    at org.openbravo.dal.service.OBDal.getConnection(
    at org.openbravo.dal.core.TriggerHandler.disable(
    at org.openbravo.retail.posterminal.OrderLoader.saveRecord(
    at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(
    at org.openbravo.service.importprocess.ImportEntryProcessor$
    at java.util.concurrent.Executors$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
Proposed SolutionThe behaviour should be exactly the same as in regular retail: If there is no stock of a product that requires attributes the warehouse transaction generated in the m_transaction is created without att values.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0038583 closedrqueralta Retail Modules Orders having BOM products made by raw materials with attributes give a weird error while processing if there is no stock 
related to defect 0038685 closedcollazoandy4 Openbravo ERP It is not possible to process a Physical Inventory for a product with attributes that has negative stock without attributes 
related to defect 0039120 closedrqueralta Retail Modules Order goes to Errors While Importing POS Data if the product is Auto Generate BOM and has a mandatory Attribute Set assigned 
causes defect 0044596 closedranjith_qualiantech_com Retail Modules Wrong M_STORAGE_DETAIL table when using AutoBOM with attributes and no stock 

-  Notes
hgbot (developer)
2018-06-10 05:35

Repository: erp/pmods/org.openbravo.retail.autobom
Changeset: 9a7c5890f72671d0b362dc73e3a0a85e23ace0e9
Author: Rafael Queralta <rafaelcuba81 <at>>
Date: Sat Jun 09 23:34:15 2018 -0400
URL: [^]

Fixed issue 38687: Autobom not working wth products that have attributes and if
there is not stock.

- If "Auto BOM Allow negative stock in raw materials" is enable, triggers are
disabled for Auto Generate BOM products with attributes set.

M src/org/openbravo/retail/autobom/
hgbot (developer)
2019-06-05 15:02

Repository: erp/pmods/org.openbravo.retail.autobom
Changeset: 43dd593fac945b14f252e7683e1f05700c966135
Author: Rafael Queralta <rafaelcuba81 <at>>
Date: Sat Jun 09 23:34:15 2018 -0400
URL: [^]

Fixed issue 38687: Autobom not working wth products that have attributes and if
there is not stock.

- If "Auto BOM Allow negative stock in raw materials" is enable, triggers are
disabled for Auto Generate BOM products with attributes set.

M src/org/openbravo/retail/autobom/process/

- Issue History
Date Modified Username Field Change
2018-06-01 14:09 VictorVillar New Issue
2018-06-01 14:09 VictorVillar Assigned To => Retail
2018-06-01 14:09 VictorVillar Triggers an Emergency Pack => No
2018-06-01 14:12 VictorVillar Relationship added related to 0038583
2018-06-01 14:15 maite Resolution time => 1529618400
2018-06-01 14:15 maite Issue Monitored: networkb
2018-06-01 14:16 VictorVillar Relationship added related to 0038685
2018-06-04 12:40 martinsdan Issue Monitored: martinsdan
2018-06-06 00:05 rqueralta Assigned To Retail => rqueralta
2018-06-06 00:05 rqueralta Status new => scheduled
2018-06-10 05:35 hgbot Checkin
2018-06-10 05:35 hgbot Note Added: 0105047
2018-06-10 05:35 hgbot Status scheduled => resolved
2018-06-10 05:35 hgbot Resolution open => fixed
2018-06-10 05:35 hgbot Fixed in SCM revision => [^]
2018-06-25 08:24 marvintm Review Assigned To => marvintm
2018-06-25 08:24 marvintm Status resolved => closed
2018-06-25 08:24 marvintm Fixed in Version => RR18Q3
2018-09-03 11:09 ngarcia Relationship added related to 0039120
2019-06-05 15:02 hgbot Checkin
2019-06-05 15:02 hgbot Note Added: 0112423
2019-06-05 15:02 hgbot Status closed => resolved
2019-06-05 15:02 hgbot Fixed in SCM revision [^] => [^]
2019-06-06 08:31 marvintm Status resolved => closed
2020-07-10 17:18 gorkaion Relationship added causes 0044596

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker