Skip to main content
Solved

Report Designer


Forum|alt.badge.img

hello again
i filter my report with BAccount.AcctCD

but i the main report data is from LegalGeneralLedgerParameters which contains only  ReferenceID

its the same as  BAccount.BAccountID so my question is can i filter with one field and i get in return another one 

thank you for your cooperation

Best answer by Gabriel Michaud

@khairi please don’t create multiple duplicate posts for this specific question here and on other platforms. It just makes it harder for the community to help you.

I have already looked at this problem and explained why it is happening here:

 

View original
Did this topic help you find an answer to your question?

5 replies

Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 521 replies
  • March 9, 2021

Hello @khairi, you can try to join these tables in the report to achieve the result needed.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 20 replies
  • March 9, 2021

thank you Irina

I tried to join the tables but its one to many relation so i got a lot of duplicated lines  the goal is to add 

a status filter from Batch in GL63CG00 

 


Irina
Community Manager
Forum|alt.badge.img+8
  • Acumatica Support Analyst
  • 521 replies
  • March 9, 2021

@khairi, try grouping to get rid of duplicate lines.

There is no way to filter out records from one table by the values from another.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 20 replies
  • March 9, 2021

Grouping is working for me know the only problem i have know is in the footer 

@Irina 


​​​​​

i still get the values (total) from all the lines duplicated even i tried to redo it i get the same values 

 


Gabriel Michaud
Captain II
Forum|alt.badge.img+11

@khairi please don’t create multiple duplicate posts for this specific question here and on other platforms. It just makes it harder for the community to help you.

I have already looked at this problem and explained why it is happening here:

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings