Hi Fozzie, I think most people assume that if they have the Administrator security role, then they will be able to save reports to the server. And tha...

Do you mean this article? That's a really cool article with a great example. Did you try shrinking the width of the subreport? I probably didn't do a ...

Hi Beaker, I used to think the same thing because, as you pointed out, there is no export button on the Row Sets or Column Sets screens in Acumatica. ...

Hi Beaker, Probably the best place to control the formatting in this case is in the Column Set. If you put the following in the Column Set #,##0.00;(#...

The first thing I notice is that the allocated space on the Base report (ar641000.rpx) for the Subreport (ar641005.rpx) is only 504px: But ar641005.r...

Hi DWS253, Would it be ok to load the logos directly into the report? Or do you want to load them someplace else so you can use them on multiple repor...

Hi DWS253, Welcome to ARC Forums! Would you be able to attach the Report and Subreport to this Topic discussion? If so, I'd be happy to take a look at...

No problem. I can't even get the Overridden checkbox to get checked through the screen using Acumatica 6.10.0472. Maybe you can only get that behavior...

So the first red arrow in the screenshot above right?

Ah, so are you trying to drop one of these fields in a Generic Inquiry? Note: You can click on the picture to make it bigger.

Hi Scooter, One thing you might try is using the Active column to turn off all of the conditions. The advantage is that you can turn them off without ...

Hi Nheuer, Some questions: Are you using Automation Notifications or the PO emailing feature that causes the Status field on the Purchase Orders scree...

Great idea on the additional column Scooter! If you want to take it a step further, then you could connect your Generic Inquiry to Excel 2016 using th...

Hi Scooter, Yes, I think you can do this. First of all, I'm assuming that you've joined together the PX.Objects.GL.Batch and PX.Objects.GL.GLTran Data...

Hi Scooter, Try the trick in the screenshot below. Basically, this allows for two conditions: Either the parameter has a value and gets used to filter...

Ah, you want to create an entirely new Forum, not just add a Topic to an existing Forum. I'm going to keep the list of Forums fixed for a while. There...

Good idea. Go for it! Maybe you could break each BI tool into separate topics. BI360 would be another good one to add to that list.

I agree. Very likely that Power BI Embedded will prove to be cheaper than buying pro accounts for all the users. Definitely looking forward to hearing...

Hi Potato Ghost, I think we have two questions here: Why are you getting the "This visual type is not yet supported or cannot be displayed due to se...

Sounds great. Looking forward to the future questions.

Hey Potato Ghost, Congratulations on being the first non-muppet to post in the ARC Forums! I LOVE the username and animated avatar. Nice creativity. T...

Hi Rowlf, OData is just a protocol, just like HTTP for websites, POP / SMTP for email, or SMS for text messages. It's just a way for computers to talk...

Hi Fozzie, Try going to the properties on the field and in the Appearance section put the following code in the Format field: MM/dd/yyyy Note that th...

Hi Fozzie, You can go to the properties of the field in Report Designer and put the following code in the Format field: #,##0 That should set it to d...

Hi Fozzie, You've got two options here. The first option is to default the PDF format within the report definition itself. You can do this in Report D...

Hi Gonzo, You can join over to PX.Objects.GL.Branch and grab the AcctName field to get the Branch Name. To join PX.Objects.GL.Batch and PX.Objects.GL....

Hi Gonzo, Purchase Order header fields are stored in the PX.Objects.PO.POOrder data access class and Purchase Order line fields are stored in the PX.O...

Hi Gonzo, The Sales Order Header data access class is PX.Objects.SO.SOOrder. The Sales Order Lines data access class is PX.Objects.SO.SOLine. You'll n...

Hi Gonzo, Yes, there is actually an easy way to do this. I recommend taking a look at this post to learn how: Note: I would say that this works on 90%...

Hi Beaker, Yes, you should be able to do this. I'm going to give you some screenshots of what it would look like for 3 months trailing, but you can co...

Hi Beaker, First, let me say that I think it's rare to have a multi-part question where the answer is "yes" to every part. But I think we have that he...

Hi Beaker, Yes, you can do this in the Row Set. Your total row should have Total selected in the Type column. Just put in a row directly above your to...

Hi Beaker, As far as I know, this is not possible. But it would be really nice to have. FRx had a feature like this. I put in an idea that you can vot...

Hi Piggy, I'm seeing the same thing as you. As far as I can tell, there is no way to control who has access to the PIVOT TABLES menu on a Generic Inqu...

You could also purchase stock from another vendor like Deluxe.com if you want to get better pricing. It wouldn't take much to modify the check form, t...

Hi Piggy, It will look cleaner if you add it to the menu. Then you wouldn't open it from the Generic Inquiry, but instead by clicking a link on the me...

Hi Piggy, Yes, you can do this. Just highlight the field that you want to format and put #,### in the Format field. If you wanted to include the decim...

Hi Fozzie, You make a great point. It doesn't make sense that everyone would have to modify their check stock. And the good news is that they don't....

Hi Piggy, I think there is a "secret trick" that will get you what you are looking for. When you are creating the Pivot Table, if you add fields to th...

Hi Kermit, A Shared Filter is something that you can put on a Generic Inquiry. To do that, you go to the Generic Inquiry and click the Filter Settings...

Hi Kermit, Power BI is a business intelligence solution from Microsoft. You can securely pipe Acumatica data into Power BI using something called ODat...

Hi Kermit, Try using the CONFIGURE button within the Widget Properties to go into the Chart Settings, then checkoff the Show Sum of Other Entries chec...

I agree. I think that's the main problem: Dashboard software companies keep using Pie Charts in their demos. So people think that they are needed. I j...

Hi Kermit, You are correct. No Pie Charts. Just Doughnut Charts which are basically Pie Charts with a hole in the middle of them. I have no idea why t...

Hi Gonzo, This is a VERY popular question. Unfortunately, there isn't a schema browser, at least not at this time. However, you can go out and vote on...

Hi Beaker, Not pretty, but what about something like this in the Value field of the Column Set? =IIf(@RowCode='0102',C+D,C) Acumatica Version 6.10.0...

Hi Scooter, You'll need access to the SYSTEM -> Customization -> MANAGE -> Generic Inquiry screen in Acumatica to create a generic inquiry. F...