Is there an easy way to search items sold to customer?

1

Hello

We constantly need to search through sales invoices for customers to see the last price we sold a specific item to them.

my current method is in the inventory tab i search for the item, then click the (Qty owned) and ctrl-f the customer name and open the invoice

Is there any easier way?

2

You can go to Sales Invoices screen, then click Sales Invoices - Lines button in bottom-right corner.

This will give you list of all sales invoice lines across all sales invoices. You can set up advanced query to group all lines by Customer and Item, this will give you list of all customer/item pairs across all sales invoice lines to make it easier to find when particular item was sold to a specific customer.

2 Likes