Split Inventory Receipt Over Multiple Supplier Invoices

We have a need for selective invoice receipting for two main reasons, 1. Suppliers with multiple warehouses. 2 Consignment stock

Example 1.
We put a PO in for

3 x A

3 x B

3 x C

We receive all items today.

Tomorrow we receive an invoice for

2 x A

1 x B

We receive a second incoice for

1 x A

3 x C

and a third invoice for

2 x B

All items shipped the same day from the same company and arrived the same time but had an invoice from each warehouse due to supply shortages.

Example 2.

We have consignment agreements with vendors that we distribute for.

We create a PO and they ship the entire order.

We receive all goods (updating the stock on hand and the trade store availability).

We report at the end of the month on what was sold, they send us an invoice for those items.

We need to be able to receive the invoice against only those selected items on the PO

1 Like

Copying from another thread as requested with some overlapping requirements. I want to use the inventory receipts and push through in Xero as a control for stock and month end accruals but at the moment there’s quite a lot of fudging in Xero to make it work smoothly.

Occasionally suppliers are a law unto themselves. :woman_shrugging:

We have a couple of situations where the supplier has invoiced multiple deliveries on one invoice. They are recorded in Breww as a separate inventory receipt for each delivery (usually separate PO’s but also may be grouping multiple deliveries on one PO). Is there a way to link them or is this just way too complex at the moment?

Conversely I have one supplier (Amazon) who have a tendency to break up deliveries but they often still arrive on the same day so they’ve been booked in as one inventory receipt but I have multiple invoices.

2 Likes

Thanks, Helen. If anyone else would find this useful, please show your support by giving this thread a vote.

@tim-martin I’ve noticed you’ve not voted for this; if this is still something important to you, don’t forget to vote too :smile:

We will receive all the items from a purchase order on one delivery and will create an inventory receipt to receive all of those items. Sometimes the supplier will invoice those items on multiple invoices. Can we have a feature where when we say the item is invoiced by the supplier that we can only choose the items from the inventory receipt that were invoiced on that specific invoice?

Thanks for the request, Christian. This is the intended use of Breww allowing multiple Inventory Receipts from a single Purchase Order. If you receive the goods via multiple Inventory Receipts, even if they’re all on the same day, this should do what you’re looking for. Cheers.

Hi Luke,

The problem is that it will take several days from when an item is received and the invoice is sent. Also we have a different person inputting the receipts vs the person who receives and inputs the invoice and the person doing the receiving does not have access to the invoice so they do not know how the supplier is invoicing us at the time of the receipt.

1 Like

Thanks, Christian, that makes sense. I’ll keep this open to attract votes. Cheers.

Good news: this is now possible! :tada:

Breww now supports part-invoicing an inventory receipt, or creating supplier invoices that cover multiple inventory receipts.

As part of this feature, all related purchase orders, inventory receipts and supplier invoices are grouped into Goods in document pools (or just Document pools), which reconcile all related documents, and allow you to have you a single, simple view of what was ordered, what was received, and what was invoiced, regardless of how many partial deliveries or split invoices a supplier used to fulfil the order.

Even though we’ve introduced this more fine-grained control and robust functionality to goods in documents, we’ve ensured that creating a simple one-to-one supplier invoice from an inventory receipt is just as easy as before. To create a finalised supplier invoice for an entire inventory receipt, just go to the inventory receipt, click Create supplier invoice → Select Finalised → Click Create. Breww will then create a supplier invoice for all outstanding items on the inventory receipt and finalise it, just like clicking the previous Invoiced by supplier option on an inventory receipt.

To read more about document pools and supplier invoices, please see our guides here and here.

We hope this is helpful, and thanks again for the great suggestion!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.