We have plan 1 and we are trying to manage inventory and warehouses (plan -operations is way outside the budget coz of licensing requirements).
Any way, so the "Product Inventory" in warehouses show the list of inventory for each product "Quantity on hand etc", what we want is to also show Batch number for each product (one product can have many batch numbers So we want to see how much on hand etc for each batch number). Any ideas?
If the above doesn't make sense to you, you can look at it like this:
1. I create a purchase order and add the products and quantities.
2. I create a "Purchase order receipt" then
3. When I create the "PO Receipt Product" I want to not only identify the product I am receiving but also the "Batch Number".
What the system does now at this point is create a new "product inventory" line based on the info from "PO Receipt Product" I created above or update the current lines (if a product inventory was already created). Instead, I want it to also record the Batch Number for the product inventory so I can track them by batch number.
If you have any ideas on how I can achieve this that would be great. I thought it was as simple as adding a Batch Number filed on the "Product Inventory" and updating but it doesn't seem possible. I am getting frustrated trying lol
Thank you in advance :-)
