Syntax to get to inventory MinSOH, Safety Min, Safety max

[DannyC]

I've got this code

Code: Select all

        JiwaFinancials.Jiwa.JiwaApplication.Manager manager = item.Manager;
        JiwaFinancials.Jiwa.JiwaInventory.Inventory inventory = manager.BusinessLogicFactory.CreateBusinessLogic<JiwaFinancials.Jiwa.JiwaInventory.Inventory>(null);
      inventory.Read(item.InventoryID);


but I don't know the correct syntax to get to the data in the Figures tab, i.e. the MinSOH, Safety Min and Safety Max.
I assume it's something like

Code: Select all

inventory.OrderLevels

or maybe its

Code: Select all

inventory.Months

I'm guessing I need to pass in a INT for the month to get or set the relevant value?

Neither of those properties have subproperties to read and write the values for MinSOH, Safety Min and Safety Max.

Of course I can do it the cheats way and just do a SQL SELECT or UPDATE but I figure I could do it via the object model. Or do I just go down the SQL way?

[Mike.Sheen]

You need to use the RetrieveOrderLevel method of the OrderLevels property... eg:

Code: Select all

Inventory.OrderLevels.RetrieveOrderLevel(month, logicalWarehouse)

You can iterate the months :

Code: Select all

For Each month As JiwaInventory.Month In Inventory.Months

and that handles the first parameter you need. For the logical warehouses, either you use a specific logical warehouse (like as if you checked the "Specific Warehouse" checkbox on the inventory maintenance form), or you do a nested iteration of all warehouses:

Code: Select all

For Each physicalWarehouse As JiwaApplication.Inventory.Warehouse.PhysicalWarehouse In Manager.PhysicalWarehouseCollection
    For Each logicalWarehouse As JiwaApplication.Inventory.Warehouse.LogicalWarehouse In physicalWarehouse.LogicalWarehouseCollection

[Mike.Sheen]

Forgot to mention, it's not just OrderLevels.RetrieveOrderLevel but SalesHistorys.RetrieveSalesHistory, Budgets.RetrieveBudget, BOMUsages.Retrieve, BOMFinishedGoods.Retrieve, JobUsages.Retrieve and JobFinishedGoods.Retrieve as well.

[DannyC]

Thanks Mike.
Another question related to the logical warehouse. Here's my code:

Code: Select all

private void Check_MinSOH(JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrderLine item)
{
    JiwaFinancials.Jiwa.JiwaApplication.Manager manager = item.Manager;
    JiwaFinancials.Jiwa.JiwaInventory.Inventory inventory = manager.BusinessLogicFactory.CreateBusinessLogic<JiwaFinancials.Jiwa.JiwaInventory.Inventory>(null);
   inventory.Read(item.InventoryID);
   
   
   foreach(JiwaFinancials.Jiwa.JiwaInventory.Month month in inventory.Months)
   {
      if (month.Index == System.DateTime.Now.Month)
      {   
         JiwaFinancials.Jiwa.JiwaInventory.OrderLevel orderLevel = inventory.OrderLevels.RetrieveOrderLevel(month, item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn);
         MessageBox.Show(orderLevel.MinSOHUnits.ToString());
      }
   }
}

It doesn't like inventory.OrderLevels.RetrieveOrderLevel(month, item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn) because item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn should be JiwaApplication.Inventory.Warehouse.LogicalWarehouse. At least thats how I am interpreting the error I'm getting.
How can I convert one to the other?

[SBarnes]

One is JiwaFinancials.Jiwa.JiwaApplication.Entities.LogicalWarehouse but the second is JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouse which is just a class that implements INotfyPropertyChanged even though Jiwa uses it in a collection, not sure why it is not a real collection item, probably because it doesn't need to be and it means you don't need a collection item factory to create it.

So change

Code: Select all

JiwaFinancials.Jiwa.JiwaInventory.OrderLevel orderLevel = inventory.OrderLevels.RetrieveOrderLevel(month, item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn);


to the following that will create the second class in line and set the property

Code: Select all

JiwaFinancials.Jiwa.JiwaInventory.OrderLevel orderLevel = inventory.OrderLevels.RetrieveOrderLevel(month,  new JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouse() { IN_LogicalID = item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn.IN_LogicalID} );


Whilst that may make it compile it may not work because RetrieveOrderLevel uses object equality on the warehouse not just the logical id to find a match, you may actually need to do the following which will require a using clause for System.Linq

Code: Select all

var olevels = inventory.OrderLevels.Cast<JiwaFinancials.Jiwa.JiwaInventory.OrderLevel>(); //get the order levels collection as a list of order levels using cast
var olevel = olevels.Where(l =>l.LogicalWarehouse.IN_LogicalID == item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn.IN_LogicalID  && l.Month == month).FirstOrDefault(); // find the order level based upon which one matches the logical warehouse and month using linq where


[DannyC]

Still can't get this to play nicely.

I thought I might be able to get the correct warehouse by doing this:

Code: Select all

JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouse inventorywhouse;

foreach(JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouse in_warehouse in JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouseCollection)
{
   if (in_warehouse.IN_LogicalID == item.SalesOrderLines.SalesOrder.LogicalWarehouseResidingIn.IN_LogicalID)
   {
      inventorywhouse = in_warehouse;
   }
}

but despite the word 'collection' appearing in JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouseCollection it doesn't seem to be a collection of JiwaFinancials.Jiwa.JiwaApplication.Inventory.Warehouse.LogicalWarehouse.

EDIT: I'm getting error 'object reference not set to an instance of an object' on my MessageBox.Show line.
It's because orderLevel is null from this line even though I believe I have a valid month & warehouse

Code: Select all

JiwaFinancials.Jiwa.JiwaInventory.OrderLevel orderLevel = inventory.OrderLevels.RetrieveOrderLevel(month, inventorywhouse);

And the underlying cause might be that

Code: Select all

inventory.OrderLevels.Count

is returning 0!

Why would that be when I have a couple of warehouses with MinSOH levels saved?
I'm using a Jiwa demo database.

[SBarnes]

If you are after an explanation of LINQ take a look at https://www.tutorialsteacher.com/linq/linq-tutorials although there are plenty more around, the big advantage to LINQ is ORMLite

[Mike.Sheen]

Still can't get this to play nicely.

Take a look at this - it's ripped straight from the DisplayFigures() method of the Inventory Maintenance form:

Code: Select all

For Each month As JiwaInventory.Month In Inventory.Months
   For Each physicalWarehouse As JiwaApplication.Inventory.Warehouse.PhysicalWarehouse In Manager.PhysicalWarehouseCollection
      For Each logicalWarehouse As JiwaApplication.Inventory.Warehouse.LogicalWarehouse In physicalWarehouse.LogicalWarehouseCollection

         Dim orderlevel As JiwaInventory.OrderLevel = Inventory.OrderLevels.RetrieveOrderLevel(month, logicalWarehouse)
         Dim salesHistory As JiwaInventory.SalesHistory = Inventory.SalesHistorys.RetrieveSalesHistory(month, logicalWarehouse)
         Dim budget As JiwaInventory.Budget = Inventory.Budgets.RetrieveBudget(month, logicalWarehouse)

         Dim BOMUsage As JiwaInventory.Usage = Inventory.BOMUsages.Retrieve(month, logicalWarehouse)
         Dim BOMFinishedGoods As JiwaInventory.Usage = Inventory.BOMFinishedGoods.Retrieve(month, logicalWarehouse)
         Dim jobUsage As JiwaInventory.Usage = Inventory.JobUsages.Retrieve(month, logicalWarehouse)
         Dim jobFinishedGoods As JiwaInventory.Usage = Inventory.JobFinishedGoods.Retrieve(month, logicalWarehouse)
      Next
   Next
Next

[DannyC]

I'll try that Mike but

Code: Select all

inventory.OrderLevels.Count

is returning 0!

Why would that be when I have a couple of warehouses with MinSOH levels saved for this particular item (FYI it's a 11901 - External Slim DVD writer - DRXS77UB)?
I'm using a Jiwa demo database.

Might be why

Code: Select all

JiwaFinancials.Jiwa.JiwaInventory.OrderLevel orderLevel = inventory.OrderLevels.RetrieveOrderLevel(month, inventorywhouse);

is returning null

[Mike.Sheen]

I'll try that Mike but

Code: Select all

inventory.OrderLevels.Count

is returning 0!

Why would that be when I have a couple of warehouses with MinSOH levels saved for this particular item (FYI it's a 11901 - External Slim DVD writer - DRXS77UB)?
I'm using a Jiwa demo database.

Might be why

Code: Select all

JiwaFinancials.Jiwa.JiwaInventory.OrderLevel orderLevel = inventory.OrderLevels.RetrieveOrderLevel(month, inventorywhouse);

is returning null

Those figures are lazy loaded by the form - we don't read them unless you have the tab selected.

You need to call Inventory.OrderLevels.Read() to explicitly read them. Same goes for SalesHistorys, Budgets, BOMUsages, BOMFinishedGoods, JobUsages and JobFinishedGoods