The Vendor Purchase Report offers a way to track your vendor invoices in Bravo.
First, select Reports from the Bravo Dashboard:
Next, select "Vendor Purchase" from the list of Inventory reports:
Once you click "Preview" you will see a pop-up box that will allow you to configure your report:
The report is run by a range of dates based on when the Invoice # started aka was first used. You have the option to view one vendor at a time or all vendors. You can also run this report to view individual invoices, or you can see all outstanding invoices by vendor or for all vendors.
Click OK once you have entered your criteria.
(The following report was run for all vendors and all invoices)
This report shows each vendor broken out.
Under each vendor, every invoice for that vendor that was created within the report date range is listed.
Every invoice has an invoice total.
After the last invoice for the vendor, is the vendor total.
The Vendor Purchase report shows all items purchased, the date, the status, the MSRP, the Sales Price, the Cost and (if sold) the sales amount.
Vendor Purchase Reporting Dates based on Invoice Create Date
If you have an invoice that started earlier in the year, then any time an additional item is added to that invoice later in the year, the reporting date of that invoice will stay the same. Meaning that the report will need to run for a longer range of dates to pull up the invoice that was recently used. This will also mean that reconciling on the End of Month report may have discrepancies if only running the Vendor Purchase Report for the same date range as the End of Month Report.
Here is a Vendor Purchase where the invoice started on 10/21/2022.
An item has been added to this invoice # on 11/22/2022. Notice at the top how the Invoice has the Date field in the past: 10/21/2022
In Inventory you can find the Invoice by doing an Ad Hoc for Invoice #. Here we see how the Invoice # is the same across all the items, but only the bottom one has a different Date to Inventory.
When the Vendor Purchase report is now ran for 11/22/2022 this newly purchased item will not show. This is due to the Invoice Date being 10/21/2022
Now if the Vendor Purchase report is ran for that invoice on 10/21/2022 we will find this newly created item on 11/22/2022 in that invoice.
