Ideas for Acumatica

Important! Please note that we do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive.
This portal is for product ideas and feedback only. If you need customer service assistance, please contact your Acumatica Support Partner or submit a support case.  You can also get assistance from community resources:  LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal. 

Need to Add the Same table multiple times in Report Designer

I need the ability to add the same table multiple times in Report Designer.  I am trying to add the InventoryItem Table and link it to both the InComponentTran table and to the InKitRegister table.  I need to link the InventoryID in both the tables to the InventoryItem table so I can pull data from the InventoryItem table for both the Kit and the Components.  This is native in Crystal and the only work around I can think of is to create SQL view. 

  • jenni arant
  • Jan 16 2017
  • Already exists
  • Attach files
  • Gabriel Michaud commented
    January 16, 2017 13:44

    Hi Jenny,

    It is already possible. The table only has to be added once in the "Tables" tab, but defined multiple times in the "Relationships" tab (with an alias). Our support team can help you with your report design if needed, or feel free to come see me if you're at the partner summit and i'll be happy to assist.

    Gabriel