Hey Wyatt.ERP, You're probably better off posting this on StackOverflow. There are a lot of developers that frequent that area. Mostly end users and p...

Looks like it does mention Budget data. I've never tried it though. Are you sure you aren't needing a budgeting tool like BI360? In my experience, the...

Hi Kalon, My advice would be to look through the training course PDF:

Agreed. Pop-ups are great. They are introduced in 2018 R2 for Customers, Vendors, and Items. I hope they expand that out to other areas in the future....

Very interesting. Thanks for sharing Daniel. I hope they create a product page for their integration.

Does checking the Relative box do anything?

Are you referring to this feature within a Variable? Do you want to reset a Variable in the Main Report based on a Group in the Subreport?

Sorry, looks like I didn't go to page 2 when I responded. My bad. I haven't used the Power BI Tile in a while. Personally, I like the Power BI reports...

Nice trick Carl! Looks like this works for 2 copies, but still would be a challenge to handle a dynamic number of copies.

Different behavior in different environments? Same build number? If so, there must be something different. I would check the underlying Generic Inquir...

I've never tried it before, but I think you could use the technique outlined on Page 111 in this document:

I wish there was a way to do this, but if there is I don't know how. The problem is that you can't choose another field in the SortOrder field. You ca...

18.201.0050

Weird. It works for me, even with the email generated within Acumatica by clicking the TEST MESSAGE button.

David, Are you using the Mass Emails (CR308000) screen and inserting images inline like in the screenshot below? But when the email lands in your inbo...

This is now a feature. Unread Forums/Posts should now appear in bold.

Try StackOverflow. There must be some technical reason why. My bigger question is what other situations cause Import Scenarios not to behave like the ...

I've noticed the same thing when creating a Data Access Class from a SQL View. It always makes the first character lowercase. Definitely annoying.

Looks like you are missing a . before com in the Redirect URL field.

Nice Carl!

Not that I know of because the Favorites Workspace disappears when you go do Edit Menu. Even if it didn't, most people wouldn't have Edit Menu availab...

I agree with Royce. Try it manually in the screen first. The Import Scenario should behave the same way. The problem might be that you are trying to u...

You can also create a Generic Inquiry based on the SiteMap table to accomplish the same thing. Then sort by the Screen ID.

Wow, sounds like a bug to me. You mean that, even if the Lot had a balance in that historical period, it doesn't appear unless it currently has a bala...

That's what I get for trying to sound intelligent about Fixed Assets 🙂 I'm not sure here, but that would indeed be strange if the Import Scenario beh...

I would try opening a support case with Acumatica then. Maybe they have another API key that will give you KM rather than you having to create your ow...

In addition to the material that Shawn mentioned, I also wanted to mention the team at PowerPivotPro: Writing measures in DAX can make your head spin...

Is this working for you Royce? I've always wondered, but never tested it myself.

I'm using Generic Inquiries right now for an EDI project and it's going well. The advantage is that you join to additional tables to get fields that a...

Thanks for the link Christopher! I have been getting braver and braver to start learning how to write code for situations like this. You definitely ge...

Hi Stefan, Are you referring to the Start Period and End Period fields in the Data Source field of the Column Sets (CS206020) screen? As far as I kno...

The formula above references Column C, but you could easily add an additional calculated column that references Column B.

Bummer. This is a situation where the Acumatica application is trying to be "too smart" in my opinion.

Alfred, I don't know of a way to do this unfortunately. Seems like a good opportunity for a customization though. I used to work at a company that did...

Hi Brian, I've always wondered what exactly determines the options available in Entry Screen field on the Entry Point tab of the Generic Inquiry (SM20...

Ellie, ha! I was wondering what that Reply button does. Now I know 🙂 Royce, a blog post is definitely better. Google favors them, that's why they ran...

I wonder if it would be easier to use the Restriction Groups by Item (IN103020) screen to do what you are looking for. Can one item be in multiple res...

I haven't used that feature before, but your Bing Map API Key idea makes sense to me. Did you have to create that API Key in Bing or did it come pre-p...

I built something in Microsoft Flow a long time ago, but it stopped working with the cookie based authentication. Apparently Microsoft broke cookie ba...

When I click the selected box, the Selected Quantity gets populated with the Open Quantity value and the Open Quantity value goes to zero. But the Sel...

Two more to checkout: From a company in Georgia: From a company in Indiana:

Why not just use a Generic Inquiry with OData for this? Is there something that you need from the endpoint that the Generic Inquiry with OData doesn't...

I agree with Royce. I would try entering manually to see if you get the same error first.

Sorry for the false alarm here. It seems to be related to a customization. My bad, I should have thought of that first.

Good idea, an attribute would be easier. Would still need to modify the Sales Order screen though to do something with it right?

Are you using a separate table for Dates? It's a good idea to. In that table, have a column for the Year. Then drag Year into a table and add a measur...