Custom SQL Queries : Finding POS Products where Preferred Vendor does not match Vendor Products

Knowledge Base Article

Knowledge Base Index : Custom SQL Queries

Finding POS Products where Preferred Vendor does not match Vendor Products

This article will describe how to run a custom report to find POS Products where the Preferred Vendor in POS Products does not have a corresponding Vendor Product listing with the same Vendor Name
In order for TRS to correctly calculate replacement cost in both the Profit by Department report and the Inventory Summary Report the Preferred Vendor name in POS Products has to exactly match the Vendor Name in Vendor Products. This custom report will help to find POS Products that don't have a matching Vendor Name in Vendor Products.

1. In TRS, click on File then click on Custom Query Report enter your
security code if prompted.

2. In the Manual SQL Form window copy and paste the following:

select prodbarcode from products A where not exists (select * from vendorproducts B where B.vpvendor=A.prodsource and B.vpupc=A.prodbarcode)

3. Click on Execute and your report will be displayed.

Article Details

Date Created May 10, 2010

Author Robert Pirone

Article Options [e-Mail this Article] [Print this Article] [Bookmark Article]

© Copyright JMM Software, Inc.
http://www.jmmsoftware.com/

Finding POS Products where Preferred Vendor does not match Vendor Products
This article will describe how to run a custom report to find POS Products where the Preferred Vendor in POS Products does not have a corresponding Vendor Product listing with the same Vendor Name In order for TRS to correctly calculate replacement cost in both the Profit by Department report and the Inventory Summary Report the Preferred Vendor name in POS Products has to exactly match the Vendor Name in Vendor Products. This custom report will help to find POS Products that don't have a matching Vendor Name in Vendor Products. 1. In TRS, click on File then click on Custom Query Report enter your security code if prompted. 2. In the Manual SQL Form window copy and paste the following: select prodbarcode from products A where not exists (select * from vendorproducts B where B.vpvendor=A.prodsource and B.vpupc=A.prodbarcode) 3. Click on Execute and your report will be displayed.
Article Details
Date Created	May 10, 2010
Author	Robert Pirone
Article Options	[e-Mail this Article] [Print this Article] [Bookmark Article]
© Copyright JMM Software, Inc. http://www.jmmsoftware.com/