Hi,
I customized our income statement that we can run by customer to see sales and expenses, and total profit by customer. There is one thing that is missing and thats shipping costs. We have a GL account for shipping cost, but its not by customer, its simply totals. We have a filed on the item fulfillment that tracks the shipping cost per order. What is the best way to add shipping costs to the income statement? Is there a way to create a calculated custom field to view on income statements? Alternatively, is there a transaction i can make to associate shipping costs by customer? I know on journal entry, i can add the entity to the transaction, but i cannot make a journal entry in this scenario because its adjusting the same GL account, only adding an entity.
Thanks!