Sometimes we pay for freight for customer orders. When the sales order is created, we also create a purchase invoice for the amount we expect to pay for freight so we can plan for this amount in cash flows. When we get invoiced for the actual freight, the purchase invoice is updated to the final amount and posted.
How would we add the unposted purchase invoice totals to a financial report? We are familiar with the financial reports page and how to create your own ad hoc report there so we are trying to do that within the financial reports area of BC.
Thanks