Hi Bhav

I have a complete Program for a pharma business which includes:
Sales Forecast, Budgeting, Production Planning, BoM, Procurement, Inventory (Raw/Packing/WIP/Finished Goods), Sale, Costing.
Material is kept GRN-wise, Issued on Products Batch-wise.
I am busy these days, but i will try help you. email me.
Zahid


>Hi all
>
>I have generally handle inventory systems so I am generally aware of the basic theories. Now I have to plan for a Inventory database for a Pharma company and the items have the following specs.:
>
>- Each item has it own stock (obviously :)). For eg. Liters
>- Each item has it's stock distributed in various packing sizes. For eg. in bottles of 50ml, 100ml and 500ml
>- Each item has the above stock further distributed into Batch Numbers
>
>Making them create as a new item (new internal unique id) for each and every packing size may raise complaints and asking anything similar for Batch Number and I am sure to loose the contract.
>
>Can I get some database ideas regarding this wherein I have one internal unique id for an item and yet be able to records transactions that can aid me in providing details and stock for a given batch number or a packing size.
>
>I hope I have been able to explain my thoughts about the requirement.
>
>Please advise.