Hi Andre,

If we added three numeric fields for LxWxH, do you also need a unit of measure associated with the units (meters / ft.in.)? Is the total volume of the order equal to the sum of all the individual volumes?

I understand that you cannot use the weight as a replacement for the volume. The volume measurement is unlikely to be "central" to the information flow, but my guess is that it might impact the number of things you include in a single order (to minimize the shipping costs in "container units"). You are definitely not the only company cubing containers, and are not the only company using Adagio cubing containers. Some software is capable of automatically computing the total number of shipping containers needed without any human intervention. However, it costs more to purchase, install and maintain than Adagio (by a lot).

Adagio Inventory has over 200 fields per item, and we're happy to add more. However, someone has to enter, maintain and report on the fields we provide, so we are somewhat cautious in expanding the record. Generating a PO is rarely straightforward, someone always wants to make adjustments to it, and everyone has their own idea of what a printed PO should look like (same as with an invoice or order confirmation).

I don't know what kind of "subroutines" your boss might be thinking of. Perhaps if he could describe the calculations being done, we could implement them and provide the resulting numbers he needs.

Personally, I don't think that you'll ever get away entirely from using Excel for this type of thing.

I would be interested in seeing one of the spreadsheets that you use to keep track of the information about an item that we aren't maintaining for you in Adagio Inventory. It might give me some insight into how we might improve the product for you.