Where can I find the cost of each customer shipment? Is there a specific table or form where I can view this information? I am particularly interested in calculating the margin.
PartTran has the cost of the shipment but if you are calculating margin the easiest place is InvcDtl has both price and cost in one place.
I would look at it from the invoice side. Since that’s what you actually billed the customer.
I created a BAQ to do that, starting with the Invoice Header to filter by date, and then pulling information in from the Invoice Detail for sales and cost. The connection to customer pulls in the full name instead of alias, while the sales order connection pulls in the reference field for me since we use that as a place for key info. but for what you’re trying to do the heart of it comes from the Invoice tables
