Hi @jswartz, You might want to repost this Discussion Topic in the Import and Export Scenarios forum on the new official Acumatica Community website...

Hopefully this fix in Acumatica 2020 R2 helps solve the problem eventually:

Hi @dawnmms, You might want to repost this Discussion Topic in the Construction forum on the new official Acumatica Community website: Here on AUG...

Subqueries would be best for this, but they aren't available yet: A SQL View could be used, but that method might not work in future versions: You...

Hi @mudacon1, You might want to repost this Discussion Topic in the Everything Else forum on the new official Acumatica Community website: Here on...

Are you trying to modify what columns display when you click on the Vendor Selector / Lookup / Magnifying Glass on the Bills and Adjustments (AP301000...

For builds, try and it will forward you to a more complicated URL. For courses, I personally go here and then search for the course number: I'm s...

Hi @tianyu5201, You might want to repost this Discussion Topic in the Distribution forum on the new official Acumatica Community website: Here on ...

Welcome @garenmardirossian. Looks like you've been busy creating a bunch of ISV add-ons for Acumatica.

Hi @mkehoe, You might want to repost this Discussion Topic in the Distribute forum on the new official Acumatica Community website: Here on AUGFor...

@nicksm Overlapping fields with different colors is the only approach that I can think of unfortunately. Acumatica Report Designer ain't Crystal Rep...

Normally I'd be like, "hmmm, this post doesn't have anything to do with Acumatica", but @julian earned the right to post stuff like this since he came...

Hi @jlowry, You might want to repost this Discussion Topic in the Field Service forum on the new official Acumatica Community website: Here on AUG...

Good question @rbrink. I'm not sure. You might try reposting this Discussion Topic in the new official Acumatica Community forums here: Here on AU...

Hmmm, wishful thinking @infosourcing 🙂 @ryanxbyte, You might want to repost this Discussion Topic in the new official Acumatica Community for...

Hi @charlescrf, You might want to repost this Discussion Topic in the new official Acumatica Community forums here: Here on AUGForums.com, most of...

Great example of why it's a good idea to hire a consultant when implementing Acumatica. The devil's in the details 🙂

Hi @czarinan, You'll probably have better luck reposting this Discussion Topic in the new official Acumatica Community forums here: Here on AUGFor...

Try this for the Branch ID: Report.IntToUI('OrganizationBranchReportParameters.BranchID',@BranchName) And this for the Branch Name: Report.GetDes...

Hi @philtr, You might want to repost this Discussion Topic in the new official Acumatica Community forums here: Here on AUGForums.com, most of the...

Hi @brianmcmillin, It was somewhat of an experiment with magic to get the Tasks to work. I'm not even sure where to start with Activities. You'll ...

Hi @jugger, You'll probably have better luck reposting this Discussion Topic in this new official Acumatica Community forum: Here on AUGForums.com...

I haven't experienced this problem with users, but I have with other records. They get marked as deleted, but they don't get purged and there is no pu...

Welcome @mhernandez to the Acumatica journey.

Thanks everyone for the feedback.

I just voted for that feedback idea for getting dynamic column names in Generic Inquiries. Sounds like a cool idea. As for Excel and OData, you shou...

Phil, I saw your email response, but it didn't make it onto this Discussion Topic. I'm responding here on the Discussion Topic. You pointed out th...

I think you'd need a customization for this. I've run into something similar with the Tax lines that get added to a journal entry.

If you just need a visual, I would look at a Dashboard or Power BI. If you need to be able to adjust dates and have them write-back, that's where th...

@philtr Interesting idea. I'm not sure how to assign an outgoing email to a Workgroup. Sounds like you already tried the Default Email Workgroup field...

You just want to display a list of all emails? Have you tried adding the All Email (CO409070) screen to the Mobile App.

I see a Hold Document on Failed Credit Check option on the Order Types (SO201000) screen which affects the Sales Orders (SO301000) screen, but I don't...

I haven't, but it should be doable. I would start by mapping which fields you want to populate and in what order, then start building the Import Scena...

Not sure I understand what you mean by sort group. Can you describe more about the context?

Actually, here's an idea for how to get it on the report: If you can get it on the report, then I would think you'd be able to get it in the email.

Welcome @alger040304. I'd love to interview you on the Podcast (click here) in October about your first month-end close experience.

Excellent. Glad to hear it. What does the Trace look like now?

@chrismoreland nerds welcome here 🙂

Welcome @matthewjames. All the best to you there across the pond, making Acumatica a strong competitor against Sage on Sage's home turf. Speaking of S...

I've noticed strange behavior with sorting before and had to do random things to the formulas to try to get them to sort properly, sometimes successfu...

Regarding Posting Classes, the Expense Account should default from wherever the Use COGS/Expense Account from field on the Posting Classes (IN206000) ...

Also, to ensure that a Purchase Receipt happens for a Non-Stock Item, make sure to check the Require Receipt checkbox on the GENERAL SETTINGS tab of t...

Posting a link to a Podcast Episode where Harsha and I discuss the latest on the InfoSourcing Address Validation Plugin (towards the end of the episod...

@pmccormack Not a bad move. Sometimes it's easier to "build up" rather than "tear down" to the desired functionality.

I noticed that the Hold field is listed twice which looks funny to me. Other than that, nothing looks strange to me. Have you tried deactivating every...

@canawrot You're probably better off posting this at There are a lot of Acumatica developers on that site.

Ah, good point. I'm not sure how to incorporate that into replenishment without a customization.

If you like Excel, a few ideas: 1. Velixo. Probably most similar to Jet Reports in that it does cell by cell calculations. It's very efficient. Gabr...