Hello,

Sage BusinessVision allows you to print an Inventory Price List and a Vendor Specific Costs by item report.   Both are available in the Reporting Suite under the Inventory module.  These two reports will give you what you want but they have to be run separately.  

In your situation you are creating a report (I assume from sratch) you would need at least the Inventory, Unit of Measure, and the Pricing tables.  To add in Vendor Specific Pricing you will need to add the SPECIAL_PRICING table to the report.  All links must be left outer join.  

Creating this report can be challenging since you can have multiple price levels with the possibility of quantity breaks for each unit of measure and multiple vendor specific prices per part number.  However, if you want a basic report with the vendor price, simply add a sub-report based on the SPECIAL_PRICING table to the INVENTORY and link with the warehouse and part number.  In this way the Vendor Specific Prices can be separated from your Inventory Prices.

If on your report inventory is being skipped when a vendor price does not exist, then I can assume your links, tables, selection formulas, or a combination of those could be the culprit.  

Hope this points you in the right direction.

Printing the "Inventory Price List" and the "Vendor Specific Costs" reports would technically help me find what I'm looking for, but it would double the amount of paper I would have to print, and it would leave a lot of room for human error.

I am trying to create a report from scratch, and I do have those tables in it, so at least that's good.  However saying "something" is wrong with the way I've set things up doesn't help.

You might be on to something with the sub-report, however I don't know how to make those work.  I can create them, but it's not pretty.

Easier than sub-reports: In your report, open the Database Expert and select the "Links" tab.

You need two connections FROM your Inventory table TO your Special_Pricing table. Right click on either of the links and select Link Options; under Join Type, select Left Outer Join. This means that the inventory item will be selected whether or not there is a corresponding special price (vendor price, in this case). The default is Inner Join, which requires a Special_Pricing record in order to select the Inventory record. This method will give you one line per unit-of-measure, subject to your selection criteria.