Which table store the total stock of a Product

[smartjsp]

Hi everyone,

I am performing an integration between adempiere and a third party product using activemq and jms, so far things are going well ,and for that purpose I should send the product information including the total stock.
From my preliminary review, I have seen the stock information in the M_Storage table, and I saw 1 row per document, so if I want to get the total I have to summarize the product rows.

However, looking at the sales order window, when we choose the product to sell per line, there is a column with the summarized stock per product, is that information available in other adempiere table, or should I summarize this total from the M_storage each time that I need it ?

Regards,


Pedro Rozo.

[hengsin]

yes, it is sum from M_Storage.

[red1]

In my implementation of the same here viewtopic.php?f=29&t=1356, I do not need to get the total stock but just the stock for that particular Warehouse Locator's 'Store'. Then i pass that store only OnHandQty as a message queue and the POS' has different locations which are regarded as an equivalent virtual store in the ERP. The POS synchronisation will check each record in the queue and accept only the one that says the same store location name and pick up that OnHandQty and ignore the rest.

The code to get the Store' OnHandQty is:

Code: Select all

      //get Storage Qty based on POS ID / OrgValue (this assumes that we cannot be sending Product that has no Storage
         int anyStorage = new Query(Env.getCtx(), MStorage.Table_Name, MStorage.COLUMNNAME_M_Product_ID+"=?", get_TrxName())
         .setParameters(product.getM_Product_ID())
         .count();
         if (anyStorage==0) continue;
               //the count will determine more XML details according to each storage (POS ID/Org) as separaet detail
               List<MStorage> stores = new Query(Env.getCtx(),MStorage.Table_Name,MStorage.COLUMNNAME_M_Product_ID+
                     "=?",null)
               .setParameters(product.getM_Product_ID())
               .list();
         
         for (MStorage store:stores){
        ...
               
                  //Warehouse Name as POS name
                  writer.writeStartElement("POSLocatorName");
                  writer.writeCharacters(loc.getWarehouseName());
                  writer.writeEndElement();
   ...
                 
                  //Storage Data - QtyOnHand
                  writer.writeStartElement("QtyOnHand");
                  writer.writeCharacters(store.getQtyOnHand().toString());
                  writer.writeEndElement();

and the code to pic it up at the POS side is:

Code: Select all

        else if (column.equals("QtyOnHand"))
                   product[cnt].setQtyonhand(Double.parseDouble(n.getTextContent()));


You can check out the projects complete coding in SVN to view its implementation by referring to the links in the above thread. A full PDF guide is also given.