Solved

Report Designer

  • 4 March 2021
  • 5 replies
  • 197 views
K
Rank
Badge

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

icon

Best answer by Gabriel Michaud 9 March 2021, 14:55

View original

5 replies

Irina
Rank
Userlevel 7
Badge +8

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

Best regards, Irina
K
Rank
Badge

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
Rank
Userlevel 7
Badge +8

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

Best regards, Irina
K
Rank
Badge

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
Rank
Userlevel 7
Badge +10

@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:

 

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica

Reply


Terms & ConditionsCookie settings
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