This is turning into a really cool Discussion Topic!

Thanks for posting the solution. Just curious, is this local/hosted Active Directory or Azure Active Directory? And are you only using it for SSO or a...

I'm starting to take some notes on this as I go through the formula:

I wish Acumatica would prevent you from creating multiple screens with the same Screen ID. But I think it at least gives you a warning in recent versi...

Interesting. I guess even 1 or 2 pixels can add up to a lot of whitespace over multiple records.

Holy cow, this is an awesome technique! I love it! Thanks for sharing @wyatt-erp! I'm adding the phrase UNION ALL to this post since UNION ALL is how ...

I just checked the release notes and it looks like the EXPORT AS REPORT button was added in Acumatica 2018 R2.

I haven't seen anything unfortunately.

Interesting. Sounds like there must be a difference in the configuration between the two environments. The question is where.

Thanks for pointing this out Megan. I agree, this can be unexpected behavior. Personally, I try to avoid the Company Tree altogether and just assign i...

There is the Default Restriction Group field on the Customer Classes (AR201000) screen which should default any new customers created into a Restricti...

@nicholas-smith, I'm curious what you're having Acumatica do with your email after it reads it. I'm not sure if there is a way to turn off the "read" ...

I agree with Andy, especially since Acumatica seems to be moving away from Automation Steps and towards making it easier to make workflow changes in C...

@jerwin-alimuin, are you using a REST API or connecting to the Generic Inquiry over OData? You can get OData to return JSON by doing this: You can als...

That's an interesting idea. It might be possible, but I'm not sure personally how it could be done. Of course, you can add a schedule to the Process I...

1. Does the cost of the two items fluctuate and automatically need to be reflected in the sales price of the main item? 2. Does the warehouse need to ...

Hi C4, If I'm understanding correctly, it sounds like you want to have multiple BOMs in place for different customers. Then, when you create a Product...

Hi JMC, I would definitely recommend reconciling Manufacturing WIP to the General Ledger. You can use the Work in Process (AM654000) report which ...

Definitely remember that guy. Good example of why business is better learned hands-on rather than in a classroom.

Hey @shawn-slavin, I'm posting this picture here on the AUG Hello discussion topic from a few months ago when I saw you in Tulsa.

If you look on the Site Map for a Generic Inquiry, you'll see that every Generic Inquiry gets launched by the same .aspx page. Can't remember the page...

Good move. Velixo is great!

You can use the Raise an Error on Duplicate Vendor Reference Number checkbox on the Accounts Payable Preferences (AP101000) screen to throw an error w...

I haven't used it myself, but it looks promising and it seems like Gregg Mercede has used it with his customers.

I wonder if the Validate Inventory (IN505000) screen might help to get quantities and costs back in sync again.

Hey Royce, Maybe it's a bug in your version? I just tried this in 19.203.0042 and it worked for me.

Note that you can use Power BI inside Excel. Using Data -> Get Data -> From Other Sources -> From OData Feed on the Excel Ribbon will take yo...

This is my preferred solution:

Hey Kevin, Have you seen this?

What URL are you using?

Sweet! I love learning stuff like this. Thanks for sharing.

Beautiful!

Good point Ellie. The IN Order Type is not a solution to the original question on this Topic.

I would check the release notes for each version:

The only way that I can think to do it would be to use subqueries. And the only way I know of currently to do subqueries would be to create a SQL View...

If it's a Generic Inquiry, then there's the "fairly new" EXPORT AS REPORT button on the Generic Inquiry (SM208000) screen that allows you to get a fas...

I haven't, but I don't see any reason why they wouldn't work. Referencing the help article here with the list of commands that you mentioned:

Was the Chart working before and now it's not working? Or was it never working? I've never done a Chart before, but I just tested adding one to the ...

Did you paste the exact same formula into both the Data Field and Style fields on the RESULTS GRID tab of the Generic Inquiry (SM208000) screen?

For SaaS they normally send out a notification letting people know when they'll be performing maintenance. Did you get a notification?

Much cleaner in 2019 R2 because there is no more "Modern UI" and "Classic UI" concept. There is just one UI in 2019 R2 so you don't have to put the Da...

Try this for going back one year: =Format( '{0: MMM d, yy}', DateAdd( Report.GetPeriodEndDate(@StartPeriod), 'y', -1))

Not sure. I didn't have to do anything "special" for them to come up. Does your user have access to those screens on the menu? Did you try sorting on ...

I see, so not only is the same Item listed multiple times on your Sales Order, but the same Item and Lot Number are listed multiple times on the Sales...

Hi Siva, It looks like you are trying to import into multiple fields so it's hard to tell what the problem might be. My suggestion would be to sta...