Hi Edward,

I think that we need a better understanding of what you are trying to accomplish.

"Track the expiry dates" - to what end? To discard the drugs past their due date? My guess is that you just want to make sure that the earliest to expire are used first - but that's a racking and picking issue, not an accounting issue. It makes no difference to the accounting system which drugs are dispensed in what order.

At the AOC it was pointed out that there is no way that the accounting department is going to tell the warehouse what item to ship. Also, to get any kind of accuracy, bar coding of the inventory is mandatory. That's why Peter is pointing you at a Warehouse management solution and I said at the AOC that the likelihood of us developing any form of Lot tracking as part of Adagio is slim to none.

One approach is to make a segment of the item number the Year/Month it expires, but this means a separate item number for each lot. Another is to track the earliest expiry date in an optional field and update the information when drug counts are done. Finally, you could track the quantities and lot number by entering it in each line of an invoice, and then have a GridView View that totaled sales by lot number (see where bar coding would be useful?).

Feel free to call me if you'd like to chat - or I can set up a web meeting with Pete joining us.