>"Hope you accept my sincere apologies" you don't have to, in my eyes you did nothing wrong.
>
>but if you read the thread I would sincerely appreciate a agreement with the facts I was making.
>
>Because people kept trying to tell me I was wrong, but I highlighted key points that are facts and people where side stepping them. that got me pissed off, hence my attitude, so I am the one that is and should be sorry

Stephen;

Don't take anything personal - it is not worth it :) When emotions get in the way there goes everything. There are so many ways to create any program. The things to keep in perspective are customer requirements, business rules along with current industry practice. That goes for any thing you create. In the end you want to satisfy the needs of the client.

How many inventory applications have I written? Many! Several with teams of 5 to 6 other developers, and several by myself. Now I work at an automobile manufacturer (Toyota and General Motors). We have more inventory systems than Carter has pills in our one plant. We use many tools like People Soft, Visual Interdev, VB and other tools. One group has 80 developers. Another has 16 and so on. None of the totals agree and that is a fact of life. Toyota is acknowledged as the best automobile manufacturing system in the world. It uses a system that is the model of the industry called Toyota Production System (TPS) and that is why General Motors partnered with Toyota.

You should see how important inventory is to our plant. We make Toyota trucks on two lines and two different passenger cars on another line. Each vehicle manufactured has been defined by a customer order. The right parts have to be available at the right place at the right time. It is very interesting to see everything flowing on the production line. Just think of the wrong color door being attached to a new car. We use just in time inventory practices, which can drive a crazy man insane. One day there was a train derailment in the Mojave Desert and it caused our plant to shut down. 5000 people went home that day.

I began my working career at a Pharmacy, then the electronics industry and now programming. IMO you can give “accurate” information about inventory if a definition is first given as to what in fact the data represents. One way I allow the user to do this is with a query form that allows dates, customers, parts, invoices or whatever to be entered. A report is generated and dated and represents what should be reality. Does reality exist? Heavens no!

In virtually every industry I have worked in there are “inventories” held at least once a year to account for what in fact is “in house”. To reconcile inventory is no small matter. If you think (third person singular) of inventory as being an absolute mathematical concept with total accuracy you are in for a disappointment. What you try to attain with the creation of an inventory application is a representation of what is required. That can mean just about anything but it will not absolutely correct.

By the way each minute of down time at our plant costs $10,000. Not a pleasant thought but it is reality.

Never use an absolute – absolutely! :) Just an old joke.

Perhaps something to remember is what I have heard many Catholic Priests say when you go to them with a problem: "This too will pass my son"!

Tom