Regular Expressions are a standard Linux thing and you can find examples all over the internet, but I think this is the kind of thing that ChatGPT is ...

Ya, if you can't get the size down by deleting the snapshots or trying a different export mode (eg. without attachments), then you'll have to request ...

@tlaird self-hosting totally makes sense to me for people like you who know what they're doing and self-hosting was a big reason why I got into Acumat...

It's not really an Acumatica problem huh; it's a math problem. And the only people who care about it are Accountants. Takes one to know one 😀 ...

@graemelm Just pulled it in as a Custom DAC fed by the SQL View. I didn't take it as far as separating the data out into columns.

@astra-mathis thank you for the detailed instructions. I just copied the PDF as text into the discussion.

@shess Hey Shu, regarding the not-so-friendly face, what do you think of the Modern UI? I know that it's not production-ready yet, but I've dabbled wi...

@jmccarter Glad you found a solution without a parameter. I haven't been able to figure out how to populate parameters in SQL Views from the Acumatica...

This should do the trick:

To remove the ones that have credit memos, you can use a formula like this to turn Credit Memo amounts into negatives: Then you can join to t...

Hey @tlaird, I just emailed you the sandbox license link.

Did you come up with a solution to this @tlaird ? I personally would probably reach for a Generic Inquiry with a Business Event, but that could just...

Did you figure this one out @nshah002 ?

Take a look at Example 2.5.9: Deleting Detail Lines in the I100 course on Acumatica University. I think you should be able to use the same technique h...

@lunar I'm sure there's a way to see it in the code, but I don't know it off the top of my head.

@lunar here's a tutorial:

Welcome @plambert ! These days, there's WAY more activity on Community.Acumatica.com, but you're also welcome to post stuff here.

Sorry @renzweiler, I haven't look at this in several years.

That would be great to see Sales Orders on the Projects screen. Have you added a side panel to the Projects screen for now?

Try =RIGHT([FinPeriodID], 2)It's stored in the database as yyyymm

One question. Did you set permissions on the Journal Transactions data entry screen to Insert? If not, they would be able to pull up any transaction i...

I would think so, but I haven't personally used SPS Commerce

SPS does integrate with Acumatica, but I've never used it personally.

I did something that's sort of like this using SQL here:

@jwright Sorry for the delay. The forums stopped displaying that post from @wyatt-erp on the front-end for some reason, but I could still see the cont...

@ctapiaaguilar I didn't unfortunately

I'm pretty sure that you have to release the Time Activities for them to show up in Project Transactions.

I have an idea, but I need to do some research. One question I have for you: to make it as frictionless as possible, how are they receiving the file i...

I haven't seen this. Sure seems like a buggy thing.

Piggy-backing on Alan's idea, you could set the status to No Purchase when you can no longer get it from a supplier. That will prevent you from being ...

@ballande Nice! Thank you so much for sharing.

I haven't noticed anything like that before. Is it the same build number in both environments?

If you want each one to have a separate page, you'll need a Group Footer because a Group Footer will trigger at the end of every Group while the Repor...

I haven't tried Code 128 before. Were you able to figure it out?

Try using ; instead of a , to separate the email addresses. You might also try only using one of the attributes to start to make sure that works. If...

ClickLearn would be my choice personally, but I haven't actually used it yet, only seen demos.

A Business Event might not be the best idea if you are entering the Payment Method on the Sales Order screen. The reason is that a Business Event gets...

I've heard good things about Lightspeed Voice. So much so that I had them on my Acumatica Podcast:

This is the only way that I know to do a UNION ALL technique in a Generic Inquiry: I haven't tried it yet, but I suspect that new technique i...

Can you take a screenshot of the table relationships in the build schema area?

This is a great, simple idea that makes a ton of sense. Thank you for sharing.

Very cool. Thank you so much for sharing.

@raphael-fournier Hmmm, I haven't looked at this in a while. I think we'd have to run a trace on a Generic Inquiry to see the SQL code that gets gener...

You actually don't even need a report variable for this. I'm typing this on my phone and going off of memory here, but I think you'll get the general ...

Seems fine to me. How are you joining between the AMProdOper and AMProdMatl tables? That could be the issue.

You can do something like this to detect what column you're in: