Ideas for Acumatica

Feedback processing: 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. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or 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.

Allow DateTable to be joined in a Generic Enquiry

This would be very useful if it could be joined by the date field to another table, e.g. SOLine.

It would then allow the data to be filtered or grouped by the extra fields that DateTable contains

  • Ben Whiteside
  • Sep 2 2015
  • Shipped
  • Attach files
  • Vladimir Panchenko commented
    22 Jun, 2018 05:06pm

    It is available since 5.3 Update 7.

  • Gabriel Michaud commented
    2 Sep, 2015 12:59pm

    That's a very good idea, but technically impossible right now since the date table is not a real database table. It was added for PowerBI/PowerPivot/OData support, and when creating new data models with it you can join it with other tables.

    We'll discuss your idea internally and think of a way it could be a real table, and therefore give you the benefit of generic inquiry joins and report joins.

  • Justin Leflaive commented
    2 Sep, 2015 10:12am

    Would be very useful - would allow you to group reports by month for example.