Product Purchase to Shipments Solution
I am quite familiar with FM but there are just some things I have never gotten into or understood. This is probably very simple to do. I buy products from local discount stores, flee markets, etc and ship crates to countries outside the US. The same products over and over again so I have created a products table with item #, description, weight. I have another table that is purchases with a date of purchase field, item #, description, and purchase price. when I buy something, for convenience when I enter the item it looks up and populates here I want to be able to create shipments or orders from my purchases. so with each shipment I can track ship date, total qty shipped, total shipping, etc. Any thoughts?
Have you looked at the starter solutions for purchase orders, Invoices and Inventory? They may provide you with a number of examples of how you might set this up.
And after you have examined them, you might find this thread on modifying an Invoicing system to also function as an inventory control system useful: Managing Inventory using a Transactions Ledger