AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
General Question on...
 
Notifications
Clear all

Questions General Question on SQL Knowledge and ACU

 
Everything Else
Last Post by Tim Rodman 1 year ago
3 Posts
3 Users
1 Likes
363 Views
RSS
byates
Posts: 20
 byates
Topic starter
August 31, 2022 4:29 pm
(@byates)
Eminent Member
Joined: 2 years ago

Hello all,

Somewhat off the cuff question. I am hiring for a new position in my company and one of the responsibilities will be to help the ongoing implementation of ACU and more pointedly around developing more reporting/dashboard capabilities. I have been able to fuddle my way through my most basic needs. 

But my question is someone with strong SQL coding skills a real benefit with ACU GI and report creations?

 

I am trying to evaluate how much of a strength in depth knowledge of SQL would be to report building and GI creation. 

2 Replies
Patrick Kohler
Posts: 24
 Patrick Kohler
August 31, 2022 6:17 pm
(@pmkohler)
Eminent Member
Joined: 3 years ago

From my perspective as a SQL developer, I often get frustrated when working with Generic Inquiries and Report Designer because what would normally be easy in SQL requires you to jump through hoops in Acumatica if what you are trying to accomplish can even be done.

My strength in depth of SQL knowledge has helped me design some work arounds to get the results I needed. I have had to read the SQL generated by Acumatica and try different approaches in the generic inquiry and report builder environments to achieve the desired results.

I think the more experience one has with different building tools and data access methodologies the better.

This forum is full of clever techniques used by some very talented individuals, therefore being able to check your ego at the door and not be afraid of asking basic questions is a plus. I have found it much faster to ask if someone has already solved a particular issue than spending a lot of time reading the SQL code generated by Acumatica. While you may not get an exact match all the time you will find techniques used by others that you can adapt.

Sometimes it is as easy but not as intuitive as using a different DAC or just adding one more DAC.

In my opinion, at the end of the day, you want someone who has great understanding of business and accounting concepts with experience using a variety of report writing tools and not afraid to ask basic questions.

Reply
byates reacted
Tim Rodman
Posts: 3044
 Tim Rodman
Admin
September 2, 2022 11:59 pm
(@timrodman)
Famed Member
Joined: 8 years ago

I agree with Patrick.

Also, I personally find that my SQL knowledge is very helpful when creating reports in Acumatica. I'm just not sure whether it needs to be a "requirement" or just a "nice to have".

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,359 Topics
  • 10.3 K Posts
  • 3 Online
  • 1,979 Members
Our newest member: Penny Tingle
Latest Post: Timecard reports/queries
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×