Inventory control (Multiple Warehoses)

lineamovil

Hello!

Anyone has some tips on how to create an inventory control but with multiple warehouses?

I have been working always with 1 warehose, and no problem. But manage inventory with multiple warehoses really cannot figure it out best way to do it in AwareIm?

I would not like to use stored procedures.

Would it be something simple, and that could show fast results.

thank you!

customaware

I did an inventory app many years ago in another language (might convert to Aware one day if I ever get time) and it handled any number of warehouses.

When a warehouse was created it could be set up as a Main warehouse or a satellite warehouse.

Only a core warehouse can receive inventory from outside of the organisation.

A satellite can only receive inventory that is transferred from a Core warehouse or some other satellite.

The question you need to ask yourself is how to handle the varying values of new stock entering the warehouse, regardless of which warehouse it is.

There are a number of ways to do it. FIFO, Price averaging etc.

I chose Price averaging for a variety of reasons. The main reasons being...

Stock items were non perishable and generally had an indefinate shelf life
could never guarantee competent rotation of stock

Hence, if you follow this methodology, here is an example

10 widgets are added to Main warehouse @ $1.00 each
Average price is $1.00

4 widgets are used on a machine repair. 6 remaining in stock.
Average price is $1.00

5 widgets are purchased and added to Main warehouse stock @ $1.13 each

Average price = (6 X 1 + 5 X 1.13) / 11 = 11.65 / 11 = 1.059 each

Inventory value = 11 X 1.059 = 11.65

and so on.

Same methodology for transferring stock from one warehouse to the other.

This is rather trivial to implement. All stock in a single BO
One Attribute is Warehouse

Process to move stock from one warehouse to another

Calculate the SUM value and the number of same stock part in the destination warehouse. Add the sum value of the same stock parts being added to give the total value of all the same stock parts that will now be in the new warehouse. Divide that SUM value by the total number of same stock parts that will be in the destination warehouse. Apply the result rate to all the parts.

Does that help?

lineamovil

Thank you Mark!

Very helpful. I used that FIFO once too, In a MsAccess application, but, as the time passed, it ran slower.

Right now with the Warehose Im doing this:

Created a BO called Warehouses
Created a BO called Products.

Then realated Products to Warehouses.

Why?
Well all warehouses will be able to have the same products. And we dont need to duplicate products for each warehouse.

I was thinking to create a BO to select the Warehouse that will be afected.
Then select the products, and numbers.

But I dont know if making them recalculte the inventory will be a heavy load for the software.

In this part is where I get lost. Dont know which one is the correct way to make this process.

Any suggestions will be great.

Thank you!

ACDC

I am working with this now and have the following concept layout which seems to make sense. Ill only be sure once I get down and create the BSV and then work through the workflow. With the basics in place the configurator tool always makes it easier to get the design right.

Concept :

Sales (outgoing products)
Objects:

1.Invoice
2.InvoiceLineItem with (Product reference ) AND (WareHouse reference)

3.Product - with (InvoiceLineItem reference) AND (WareHouse reference)
4.Warehouse - with (Product reference) AND ( InvoiceLineItem reference)

Outgoing Totals are then summed up in Product.WareHouse.InvoiceLineItems

Receipts (Incoming Products)

Objects:

1.GoodsReceivedNote (GRN)
2.GRNLineItems with (Product reference ) AND (WareHouse reference)

3.Product - with (GRNLineItem reference) AND (WareHouse reference)
4.WareHouse -with (Product reference) AND ( GRNLineItem reference)

Incoming Totals are then summed up in Product.WareHouse.GRNLineItemLineItems

From the above all the necessary Totals regarding stock on hand, average costing etc, etc , can be calculated . Also to move stock to another Warehouse a ProductMovementObject with its MovementLineitemsObject similar to the above to examples can be created.

I hope that makes sense

Any other ideas or comments would be welcome

Let me know what you think

ACDC

lineamovil

BTW, I meant to ask why would you want to use stored procedures