Hi,
We have created a Inventory Transfer with added from Location and To Location. There are Two Items.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/73cf2ae4-386e-4d9f-a83a-2d42f1112f63.png)
We have created a report. We changed the Existing inventory transaction report.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8971d1db-bbca-4b1d-9804-bcf403a83404.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a5db2cc9-ea7f-400f-bb45-edf7c7a04e00.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/8257b44b-3e87-45ea-9374-114ab4cf7234.png)
Mainly we are using INtran table and if we have two different location system create two lines in same table.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/89c3f0ef-bb38-4fac-8e9d-18bea7f26735.png)
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.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/0bd77537-37df-42a8-97c3-4a38f5e6ac23.png)
Regards
Nethupul
Best answer by Concannon
View original