Hi,
We have created a Inventory Transfer with added from Location and To Location. There are Two Items.
We have created a report. We changed the Existing inventory transaction report.
Mainly we are using INtran table and if we have two different location system create two lines in same table.
we tried removing the location columns. but we could not find any distinct column option.
We need see only two lines in above example.
Expected result as follows.
Regards
Nethupul
Best answer by Concannon
Group by INTran.RefNbr. The To Location field is InTran.ToLocationID. I have attached a simple GI to illustrate the outcome.
+13Try using the Grouping option
Hi Devid,
We could not find relevant function in grouping area. Appreciate if could you send further steps clarification in this regard?
Hi,
Is there any possibility to create the date View for this using INtran table?
Example:
Regards
Nethupul
+13If you have duplicates in a data query due to table joins, one way to resolve it is to add every field that is used on the report to the grouping.
Group by INTran.RefNbr. The To Location field is InTran.ToLocationID. I have attached a simple GI to illustrate the outcome.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
