Share
Report
3,795In the Tax Transaction report, I wish to show the "Vendor Document Number", but the result showing duplication of records, suspect the report result cause by the Many-One-Many relationship of those tables.
In the Tax Detail Transaction Report contains a list of Receipt Numbers (POP) that involving tax, and this report showing the Vendor ID and Vendor name, but it do not have "Vendor Document Number".
So, I added a new relationship in order to show the "Vendor Document Number" which can be found in the PM Transaction Open File. Due to the relationship
Tax History Print Temp >-M----1-> PM Vendor Master File <-1----M-< PM Transaction OPEN File
http://img62.imageshack.us/img62/623/20100415091340.jpg
Please advice me on how to enable the Vendor Document Number showing in the Tax Detail Report without duplication.
I am not too sure if this table relationship is named correctly (Many-One-Many or One-Many-Many), but both type of the relationship will resulting the duplication of records. To explain further :
The Tax report has "many" Receipt (POP) and each receipt may be from same vendors. There many "Vendor Document Number" also from the same Vendors.
Kindly advise me and many thanks in advance.
*This post is locked for comments
All responses (
Answers (
