Solved

Need to distinct table column(Removing Duplicate values)

  • 23 June 2022
  • 5 replies
  • 365 views

Userlevel 3
Badge

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

 

 

 

 

icon

Best answer by Concannon 24 June 2022, 23:11

View original

5 replies

Userlevel 7
Badge +9

Try using the Grouping option 

Userlevel 3
Badge

Hi Devid,

We could not find relevant function in grouping area. Appreciate if could you send further steps clarification in this regard?

 

Userlevel 3
Badge

Hi, 

Is there any possibility to create the date View for this using INtran table?

Example:

 

 

Regards

Nethupul

 

 

Userlevel 7
Badge +9

If 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.  

Userlevel 2
Badge

Group by INTran.RefNbr. The To Location field is InTran.ToLocationID. I have attached a simple GI to illustrate the outcome.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved