Click here to watch the recording on YouTube with chat playback
Click here for upcoming broadcasts and previous broadcast recordings
0:00 AUGForums.com Live Introduction #Acumatica
3:17 #AcumaticaTnT – Tips and Tricks that will blow your mind
4:03 Getting the party started
4:45 What’s your Acumatica reporting story and how did you get started?
12:43 Acumatica reporting functionality vs 3rd party reporting tools
17:36 SQL vs Data Access Classes
27:02 Reporting functionality coming to Acumatica in the future
31:00 Audience Question: Report Designer visibility expression
37:25 Finding a Manufacturing step that was missed, a general technique that’s applicable to many situations
45:31 Audience Question: Challenges with building a Project Profit & Loss and choosing the right tool
47:59 Left Outer Joins vs Cross Joins
55:37 The history of #AcumaticaTnT
56:48 Audience Question: Converting a 4 decimal number to an integer
59:10 Final Thoughts
Today’s Guests
Arline Welty
Location: Chicago, Illinois
Laura Jaffe
Location: Cleveland, Ohio
Chat Transcript
Hi! from sunny Rochester, NY
Where’s everyone joining from today?
Hello everyone! from Lincoln, NE
Hi from Clifton Park NY
So I have a question about Visible expression formulas, let me know when I can ask
Hi, I am from Ontario, Canada.
Here from Nanaimo, BC, Canada
We’ve got a few questions queued up, then we’ll get to the comments.
From Hi from Calgary Canada
Doug from Venice Florida. LIghtspeed Voice.
Thanks
Doug from Alaska Indoor Sports
Do I ask in the chat or is there another place to post the questions?
Chat is perfect
Michael Triffon from Pabian Partners
I am trying to hide a box if the value of a field is equal to an FOB point. I tried using an iff statement.
Gregory from Alaska Indoor Sports
Currently I’m trying to use =[FOBPoint.FOBPointID]=’ORIGIN’ in the visible expression field but it hides the box regardless of the value.
hi, from India
I write VBA almost everyday! 🙂
Do we want Acumatica to focus on reporting functionality themselves or do a better job of promoting ISV products?
In Acumatica
Fist option
In Acumatica
In Acumatica
Rather be in Acumatica.
I agree with Laura.
Classic ERP was about looking at reports to know what you need to do whereas modern ERP is about moving transactions along and alerting people when intervention is needed. Passive vs active
Does anyone what ERP stands for? Excel replacement program.
ARM is such a weak tool compared to other financial reporting packages in other ERP systems.
We try to push toward GIs when possible vs. reports unless the output will be printed
The 3rdparty marketplace will always out feature the built-in reporting. Even if we pulled an existing tool into ACM, the 3rdparty would still find ways of differentiating.
Can you use projections instead of sql views?
Hi from California; I’m having to jump off for a conference call… will this be recorded/available to view later?
You can, but you need to understand how to write the BQL code. Not user friendly.
Yes, recording is available on AUGForums.com/Live
yes
BQL def. not user friendly though
I don’t think you can do union joins without writing code. But, you can build a DAC projection to give you any data. Alas, not as powerful as a SQL query.
Does Acumatica reveal database changes with upgrades (let alone updates)?
Decoupling: Imagine running a pivot in Excel and then using another worksheet to pull data from the pivot table results.
Me
I am trying to hide a box depending on the value of a field
The bottom of the Developer Release Notes has database changes from version to version. Here’s the Developer Release Notes for Acumatica 2020 R2: http://acumatica-builds.s3.amazonaws….
I will be trying your solution live
Yes
Report designer
Will try now
And make sure that you’re getting back ‘ORIGIN’ vs ‘ORIGIN ‘
(trailing spaces)
Thought about that and tried as well but didn’t work either
Did that
And I get the expression value
First thing I did was create a box to show the value, then used that
Good idea
SCTR is a good idea
You can bet I will
=CStr([FOBPoint.FOBPointID])
Maybe Acumatica will add functionality to trigger a event base on widget parm on a dashboard
When all you have a is a hammer, everything looks like a nail
Most consultants are more comfortable with one tool and that swhat they lean to.
I am working on a report that is using field xyz. When I try to modify the field it’s says the field doesn’t exist.
Was the field deprecated? It’s not in the tables yet still gives a result in it’s original form.
The performance issue is that the database cannot optimize the query so it looks at every record in both tables.
Michael: File -> Build Schema -> Refresh All
That worked, thanks! I thought loading the schema would do it.
Last question for the day: What is the best way to convert a 4 decimal number into an integer? I need to eliminate decimal place.
I tried CInt, Round, and formats but can get rid of it.
In report Designer
I tried
Thats what I did
Ok thanks!