Add additional costs to stock items on an Inventory Receipt that impact the landed cost but don't show on the Supplier Invoice (e.g. 3rd party shipping costs)

A few of our purchases involve a separate freight invoice (from a 3PL or vendor we arrange transit with directly). Unfortunately, this means that the underly cost of the items on the purchase does not contain the full cost associated with the items.

The workaround right now are either to treat the freight as an “ingredient” and add it to the manufacturing process, or to just put it directly into a COGS account outside of Breww and not attach it directly to the product being manufactured.

We would like a way to be able to attach costs from another invoice or bill (much as an extra cost that’s ON the invoice is added on now), and have that be merged into the valuations of the stock. I think the mechanically this could be done with a second option to add an additional cost on the invoice (in the final invoicing step), where another inventory receipt or standalone invoice could be added in at that point.

Thank you!

2 Likes

Cin7 Core has a great system for this where a third-party bill (like a freight or processing fee) can be linked to the Supplier bill as a landed cost. It keeps the paper trail very clear, but changes the landed cost of the goods.

Hello.

Luke, not sure if this can be related here or is already accounted for, but we would like to be able to do one of two things so we can allocate additional costs like shipping correctly in our P&L:

  • Either be able to set the account for additional cost by ingredient category or type (I think there is another request similar to this), or;
  • Add other additional costs for allocation (like, shipping - international, or tariff) that can be mapped to the correct account.

Right now, all of the shipping costs end up allocating to a single account, and we need a little more control to send them to the right COGS account for tracking and reporting. We are working around this by just lumping the cost into the per-item total, but this makes it opaque and there’s no way to report on the additional costs.

Please let me know if that’s not clear.

Thanks.

Thanks, David, that makes sense.