Hi,
I would like to create a report which will show only Customers who are Vendor and vice versa.
Suppose we have the following data in Customer table
Cusotmer code Customer Name Vendor ID
C001 ABC V001
C010 DEF V002
I can make a simple report from Customer table and show the data as above
But imagine the below scenario
in Vendor table, i created a new Vendor as below
Vendor ID Vendor Name CustAccount
V100 HIJ C099
But i forgot to update theCustomer Master (to select the customer C099 and go the Vendor field and mention there V100)
this can happen in a real life scenario
If i had run the report this record will not appear.
What i need is a report which will work in both ways
e.g in the first part it will be based on Cusotmer table where it will display all the records from Customer table whichever has been updated with a Vendor code
Then in the next part it will work on the Vendor table and display all the records from the Vendor table whichever has been updated with a Customer code
Cusotmer code Customer Name Vendor ID
C001 ABC V001
C010 DEF V002
(Total 2 customers)
Vendor ID Vendor Name CustAccount
V001 ABC C001
V002 DEF C010
V100 HIJ C099
(Total 3 vendors)
This report will show the information needed plus it will be a checking tool too.
regards
TP