sorting - custom fields - reports

[arturo]

Hi guys,

My firm has a purchase quota to buy 15% of their supplies from smal businesses. We need a way to indicate that a vendor was a small business. The custom fields were a great fix (thanks quickbooks programmers...)

What I 'm having problems with is getting a report showing transactions with vendors sorted by this "small business" field.
Anyone have any ideas?

-Arturo

[RobJoy]

Let's just get this out of the way, first: Why didn't you use Vendor Type to specify which was a small business? Then you could use Purchases by Vendor Summary, filtered by type.

Otherwise, you can use Custom Transaction Detail Report, bills & credits only, filter on your special field to show small businesses, then 'not' small businesses & do a bit of arithmetic.