adempiere/adempiere

ADempiere Business Suite ERP/CRM/MFG/SCM/POS done the Bazaar way in an open and unabated fashion. Focus is on the Community that includes Subject Matter Specialists, Implementors and End-Users.

ADempiere

Short status:

Issues and Pull Requests:

Social Media:

The ADempiere Business Suite ERP/CRM/MFG/SCM/POS is done the Bazaar way in an open and unabated fashion.
Focus is on the Community that includes Technical Specialists, Functional Specialists, Implementors and End-Users.

• Official Page: http://www.adempiere.io
• Official Docs: http://adempiere.io/docs
• Download and debug source: https://www.adempiere.io/product/source-code.html#cloning-the-repository-with-a-slow-connection
• Business process: https://www.adempiere.io/product/business-process.html
• If you need to report a bug: https://github.com/adempiere/adempiere/issues

adempiere's Issues

Issue when a new column is created and have not Entity Type

Issue when a new column is created and have not Entity Type

Access ADempiere 3.8 the "Blank Window or Toolbar Issue" will appear

Steps to reproduce the problem:

1. Access ADempiere 3.8 (latest version) via: http://postgres.adempiere.io/webui/index.zul
2. Login with: Username: GardenAdmin; Password: GardenAdmin;
3. Use the default value in the next screen and proceed by clicking "Tick" button;
4. Open up windows from the ERP (by selecting from the menu tree from the left or search in the Lookup field)
   E.g. Sales Order window, Invoice (Customer) window.
5. Keep switching between windows, the "Blank Window or Toolbar Issue" will appear;
6. If not, refresh the page and switching between the previously opened windows, the "Blank Window or Toolbar Issue" will appear

Add payment id in HR_Movement

To link payment with movement is necessary add C_Payment_ID

Add field employee type to generate HR payment selection

Add field employee type to generate HR payment selection

Currently only allows create HR payment selection based on partner group and is necessary add employee type

fixes the precision duration real , setup time real in manufacturing workflow

fixes the precision duration real , setup time real in manufacturing workflow

Currently migration xml not is generated

Currently migration xml not is generated

Standard cost not is created from inventory line cost

When an inventory is imported with cost and costing is setting standard cost not is load from inventory line.

Increase field SQL size for migration script

Increase field SQL size for migration script

Replace log severe for launch exception in Time expense line

Replace log severe for launch exception in Time expense line

Add opportunity and add sys config parameters to check credit for Proposal document

Add opportunity and add sys config parameters to check credit for Proposal document

The Order BOM line not should be updated when exist a variance

When extra product is add into Order BOM line and is issue an method variance is created , this transaction not should update Order BOM line so that is updated by issue;

Client Account Processor remove static filter

Client Account Processor remove static filter

POS terminal error with transactions over $1000

Adempiere 380 lts. i'm using a MacBook with the terminal, Adempiere Language=English
I can complete transactions in the POS up to $999,99 and all right : orders invoices and payments. But
if i sell over that amount the message i get is "payment processing failed :null", then the order and the invoice are created but not the payment
(client , price list and cash book are with the same currency)
thanks in advance

Log:

16:03:55.938 MRole.get: AD_Role_ID=1000000, AD_User_ID=100, reload=false [32]
16:03:55.938 AccessSqlParser.parse: AccessSqlParser[AD_WF_Responsible=r|AD_WF_Responsible=r|AD_WF_Responsible=r,AD_User_Roles=ur|AD_WF_Activity=a|3] [32]
16:03:55.938 MRole.addAccessSQL: Record access - (a.AD_WF_Activity_ID IS NULL OR a.AD_WF_Activity_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 644 AND AD_User_ID <> 100 AND IsActive = 'Y' )) [32]
16:03:55.939 MRole.addAccessSQL: SELECT count(*) FROM AD_WF_Activity a WHERE a.Processed='N' AND a.WFState='OS' AND ( a.AD_User_ID=? OR EXISTS (SELECT * FROM AD_WF_Responsible r WHERE a.AD_WF_Responsible_ID=r.AD_WF_Responsible_ID AND COALESCE(r.AD_User_ID,0)=0 AND COALESCE(r.AD_Role_ID,0)=0 AND (a.AD_User_ID=? OR a.AD_User_ID IS NULL)) OR EXISTS (SELECT * FROM AD_WF_Responsible r WHERE a.AD_WF_Responsible_ID=r.AD_WF_Responsible_ID AND r.AD_User_ID=?) OR EXISTS (SELECT * FROM AD_WF_Responsible r INNER JOIN AD_User_Roles ur ON (r.AD_Role_ID=ur.AD_Role_ID) WHERE a.AD_WF_Responsible_ID=r.AD_WF_Responsible_ID AND ur.AD_User_ID=?)) AND a.AD_Client_ID IN(0,1000000) AND a.AD_Org_ID IN(0,1000000) AND (a.AD_WF_Activity_ID IS NULL OR a.AD_WF_Activity_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 644 AND AD_User_ID <> 100 AND IsActive = 'Y' )) [32]

The Wrong Table Name I_SalesHistory -> Qty Column amount reference and should be Qty

Table Name I_SalesHistory -> Qty Column Qty reference

Change approach to get business partner group more efficient

Change approach to get business partner group more efficient

Implement interface for order line to support average cost purchase

Implement interface for order line to support average cost purchase

fix behavior in HR Pay selection window

Incorrect and link column and tab level.

Solve issue for reserve and order quantity

Solve issue for reserve and order quantity

So sometime the reserve and order quantity qty need be consumed from a null instance or attribute set instance with 0 if this condition not is accomplished
then any instance with quantity is used.

Error in migration in document sequence

When migration is processed the document sequences not is migrate rightly

The field processed and processing in Distribution Order should have default value N

Current when try save a distribution order it show always save icon in on , the reason is that the processed and processing are null.

Add support Key Store Mgt for Java 1.8

Add support Key Store Mgt for Java 1.8

Smart Browser Sales Order to Picking not should to have all criterial field as mandatory

DRP not generate distribution order because business partner not link organization.

DRP not generate order , the issue that business partner are try find is based on source locator organization.

The system should use of organization from target locator

Parameter list values not refresh when other users login in web client.

@e-Evolution parameter list values not refresh when other users login they see list values of first logined user, it is working properly for GUI client, i think it retrieve from the cache when i delete the cache and login to other user it shown its values accordingly. I am using Adempiere 3.7.

NPE when try post a collector cost with cost dimension

When try post a collector cost transaction and not exist cost dimension a NPE is launch.

Bugfix error when Standard cost is created

Bugfix error when Standard cost is created

Error in payment rule when an payroll payment selection is create

The logic to setting payment rule should be :

1.- Try find payment rule from HR_Employee
2.- If Payment rule have not employee then use C_BPartner
2.- If Payment rule have not business partner then use HR_Payroll

Add IsAllowsCopy method in GridFieldVO and GridField

This method will allow callout business logic can be valid when an copy action is executed from a window

The BOM and Workflow rollup need resource and warehouse to try find a planning data

The BOM and Workflow rollup need resource and warehouse to try find a planning data this way of cost can be calculated

There is a risk that some document was marked as posted by the accounting engine and but there is no accounting fact

There is a risk that some document was marked as posted by the accounting engine and but there is no accounting fact, this can cause an incorrect accounting information for financial statement.

The accounting reset process now validate if exist the accounting generated for a document with an accounting open period, if not then the document is set as un posting to generate accounting

Fix get transactions only with real instances

Fix get transactions only with real instances

Solve incorrect accounting with standard cost variance posting

Solve incorrect accounting with standard cost variance posting

Browse remove unnecessary method

Add HR Concept Type

Is necessary a new group in payroll concept to define an type for concepts

Add payroll process into payroll selection

Is convenient add HR_Process_ID into payroll selection

Trigger an exception when not exist UOM conversion

When a component have an UOM in BOM Line different to UOM of product , System try make UOM conversion , if the alternate UOM is defined and not exist of system should send an exception

Product Info shows no data in ZK web interface

In the InfoProductPanel on line 449 there is an error that makes that the Product Info window shows no data.

Instead of:

new ColumnInfo(Msg.translate(Env.getCtx(), "Warehouse"), "Warehouse", String.class),

It should be :

new ColumnInfo(Msg.translate(Env.getCtx(), "WarehouseName"), "WarehouseName", String.class),

Same applies to lines 461 - 462 :

m_sqlWarehouse += " Group By M_Warehouse_ID, Warehouse ";`
m_sqlWarehouse += " Order By sum(QtyOnHand) DESC, Warehouse ";

Should be :

m_sqlWarehouse += " Group By M_Warehouse_ID, WarehouseName ";
m_sqlWarehouse += " Order By sum(QtyOnHand) DESC, WarehouseName ";  

I was getting the following stack trace :

-----------> InfoProductPanel.refresh: SELECT M_Warehouse_ID, Warehouse, sum(QtyAvailable), sum(QtyOnHand), sum(QtyReserved), sum(QtyOrdered) FROM  M_PRODUCT_STOCK_V  WHERE (QtyOnHand <> 0 OR QtyAvailable <> 0 OR QtyReserved <> 0 OR QtyOrdered <> 0) AND M_Product_ID = ? AND M_PRODUCT_STOCK_V.AD_Client_ID IN(0,1000001) AND M_PRODUCT_STOCK_V.AD_Org_ID IN(0,1000001,1000002) Group By M_Warehouse_ID, Warehouse  Order By sum(QtyOnHand) DESC, Warehouse  [59]
org.postgresql.util.PSQLException: ERROR: column "warehouse" does not exist
  Position: 24; State=42703; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
        at com.sun.proxy.$Proxy68.executeQuery(Unknown Source)
        at org.adempiere.webui.panel.InfoProductPanel.refresh(InfoProductPanel.java:702)
        at org.adempiere.webui.panel.InfoProductPanel.recordSelected(InfoProductPanel.java:2075)
        at org.adempiere.webui.panel.InfoPanel.reselectRecord(InfoPanel.java:1752)
        at org.adempiere.webui.panel.InfoPanel.onQueryCallback(InfoPanel.java:1702)

Diff :

---
 zkwebui/WEB-INF/src/org/adempiere/webui/panel/InfoProductPanel.java | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/zkwebui/WEB-INF/src/org/adempiere/webui/panel/InfoProductPanel.java b/zkwebui/WEB-INF/src/org/adempiere/webui/panel/InfoProductPanel.java
index dabb0df..0ba5884 100644
--- a/zkwebui/WEB-INF/src/org/adempiere/webui/panel/InfoProductPanel.java
+++ b/zkwebui/WEB-INF/src/org/adempiere/webui/panel/InfoProductPanel.java
@@ -446,7 +446,7 @@ public class InfoProductPanel extends InfoPanel implements EventListener, ValueC
        //
         ColumnInfo[] s_layoutWarehouse = new ColumnInfo[]{
                new ColumnInfo(" ", "M_Warehouse_ID", IDColumn.class),
-               new ColumnInfo(Msg.translate(Env.getCtx(), "Warehouse"), "Warehouse", String.class),
+               new ColumnInfo(Msg.translate(Env.getCtx(), "WarehouseName"), "WarehouseName", String.class),
                new ColumnInfo(Msg.translate(Env.getCtx(), "QtyAvailable"), "sum(QtyAvailable)", Double.class, true, true, null),
                new ColumnInfo(Msg.translate(Env.getCtx(), "QtyOnHand"), "sum(QtyOnHand)", Double.class),
                    new ColumnInfo(Msg.translate(Env.getCtx(), "QtyReserved"), "sum(QtyReserved)", Double.class),
@@ -458,8 +458,8 @@ public class InfoProductPanel extends InfoPanel implements EventListener, ValueC
         String s_sqlWhere = "(QtyOnHand <> 0 OR QtyAvailable <> 0 OR QtyReserved <> 0 OR QtyOrdered <> 0) AND M_Product_ID = ?";
 //      String s_sqlWhere = "M_Product_ID = ?";
         m_sqlWarehouse = warehouseTbl.prepareTable(s_layoutWarehouse, s_sqlFrom, s_sqlWhere, false, "M_PRODUCT_STOCK_V");
-       m_sqlWarehouse += " Group By M_Warehouse_ID, Warehouse ";
-       m_sqlWarehouse += " Order By sum(QtyOnHand) DESC, Warehouse ";      
+       m_sqlWarehouse += " Group By M_Warehouse_ID, WarehouseName ";
+       m_sqlWarehouse += " Order By sum(QtyOnHand) DESC, WarehouseName ";      
        warehouseTbl.setMultiSelection(false);
         warehouseTbl.autoSize();
         warehouseTbl.setShowTotals(true);
-- 

Any issue component not should update of ASI field into Orden BOM Line

Any issue component not should update of ASI field into Orden BOM Line, So ASI only should be update from BOM Line when a specific ASI is strictly defined

Remove restriction to close manufacturing order when required quantity is minor that delivered quantity

Current when try close an order if exist components that the required quantity is minor that delivered quantity not allow close

Remove severe log to exception and rectory variable name

Remove severe log to exception and rectory variable name

Error in allocation because of payment amount return null vs zero

Error in allocation because of payment amount return null vs zero

Incomplete Batch Journal reverse

1.- Create a Batch Journal
2.- Add some Journals into Batch Journal
3.- Complete of Batch Journal
4.- Execute Revert Correct.

The result is that a new batch Journal is generate but with draft status. So the behavior not is same that other documents

Fix the cost level to get an cost dimension

Fix the cost level to get an cost dimension

Error when try complete material receipt for Average Cost PO method

https://adempiere.atlassian.net/browse/ADEMPIERE-441

Order Receipt and Issue not allows return components when not exist quantity on hand

Manufacturing Order Receipt and Issue not allows return components when not exist quantity on hand

Smart browser criterial query only work to (String , Timestamp , BigDecimal)

The smart browser issue when of field are other type that (String , Timestamp , BigDecimal)

Improve Un posted window now show Amount , Business Partner , Document Type

Improve Un posted window now show Amount , Business Partner , Document Type
Adding all documents payroll process , asset addition , asset depreciation , asset disposal , cost collector

Find window not work with range selection column and two column layout

If you have more 7 column selection and range fields , the find window not work

Add User 1 and User 2 Dimension for Report Source Type Combination

Currently of Report Source Type Combination not support User 1 and User 2 dimension
http://www.adempiere.com/New_Functionality_Financial_Report_Source_Type_Combination
Jira tracker
https://adempiere.atlassian.net/browse/ADEMPIERE-431

NPE some time when you try save in a grid table launch NPE GridTable