That's really strange that it can't merge somehow, it has to replace everything. Acumatica has the same problem with the Manufacturing Edition and Con...

Hey Kevin, You might want to try StackOverflow for this one. I'm wondering if something additional needs to be done to the graph on the Customers (AR3...

Thanks so much for sharing your solution Alex. Personally I lean towards this option now:

Never seen this before. Was Acumatica able to fix it?

You'd probably need to remove SOShipLineSplit from the joins to eliminate the duplication. Do you need anything from SOShipLineSplit? Can it be remove...

Welcome, Lindsey. Thanks for taking the time to introduce yourself.

Interesting, so install Query Store (click here), then change the schema on the tables that it creates to "dbo"? It's funny, I haven't looked at SQL s...

Was it the Customization Project for the Construction module or Manufacturing module? I've heard that those Customization Projects can destroy your me...

This is pretty cool. Never tried something like this. Ellie, can you include a screenshot of what it looks like on the REPORT PARAMETERS tab when you ...

Does this help?

Weird, I guess I just never noticed it.

I haven't done much with Tabular in Report Designer because it's limited. You might be able to do totals, but I'm not sure. Have you considered using ...

The "IN" Order Type allows you to Invoice against a Sales Order without doing a Shipment. Just be aware that I think there are some limitations with...

Something might be possible with those Application functions, but I just made an attempt and wasn't able to get anything to work. Maybe @gabriel-...

Nice tip Carl, just make sure to sing this song while installing Staying Alive 🙂

Thanks for sharing your solution Thomas!

Glad to hear that there is a script to fix this. Probably one of those things where putting it on the front-end isn't a high priority since there is a...

Interesting, I never noticed that Align option before. Left is the default and I've always just gone with that. In my experience with Segmented Keys...

For your line that is Active, have you tried using <Line Number> in the Field / Action Name column instead of Line Nbr.?

Sounds like a bug to me. Do you have anything listed in the Chrome Payment Methods settings? chrome://settings/payments Maybe Chrome auto-fill is mess...

Interesting. I didn't realize that shift work all gets booked to the day when the shift started. At least Acumatica handles that part correctly. Hopef...

I don't have it saved anywhere and wasn't able to find it. Bummer. Looks like they are hosting the training examples for the I300 courses on GitHub no...

I'm not sure that Acumatica would do a good job of hosting images externally. My concern would be that it would slow down the system. Something like A...

Interesting. Does the other environment have the same number of Companies and Branches?

Bummer. I haven't tried it personally. There are certain things that are only available in Power BI Premium and maybe this is one of those things. I d...

Very interesting. I've been trying to avoid SQL Views because I'm nervous that they'll disappear in a future version due to the fact that they make Ac...

I like your #2. Great workaround. Good to know there is a way to do this. I've always found it funny that Salespersons kind of hover out in space with...

I would go with one Ledger, even with multiple Companies that are separate legal entities. I've done that before and it worked great. You can still fi...

Nice move to use Power BI. It's a great reconciliation tool, among other things. I'm sure Acumatica would love to hear the discrepancy scenarios that ...

Nice idea Carl!

Maybe you can resell that customization to others who need it.

Is your Instance Acumatica SaaS, hoted in-house, or hosted with a 3rd party?

Does this help?

I think Julian found a screen that had a Subaccount lookup that didn't behave like a normal Subaccount lookup where F3 validates the segments individu...

I agree, not ideal, but I wasn't able to figure out how to do it on the Account rather than the Description field either. And your solution totally ge...

Ya, not the best solution. It would be nice if we had a feature that functioned kind of like a Subreport where you can call another report from within...

Glad to hear that you were able to get it working.

Thanks for sharing Nazar!

I think that would work if you're ordering from multiple Vendor Locations, but it seems like you might want to indicate to the Vendor on a PO Requisit...

Royce, I chuckled reading this part. Thanks for clarifying for us Americans. We really are pretty clueless about non-American dates. Although the way ...

I've found Acumatica to be lacking in a number of out-of-the-box reports. I assume it's because Acumatica has only been around since 2008, not the 198...

Hey Uday, I merged your Discussion Topic into this existing Discussion Topic.

Using the Sales Demo data, let's say that you wanted to restrict Balance Sheet GL Accounts to only use the 000-000 Subaccount. You could use the GL Ac...

Clever solution. I like it!

I learned a cool trick from Olesia on the Acumatica support team today related to this. If you want to import a Role of Related Entity and a Type of L...

I don't think you want to combine ARTran (the invoice line level) with ARInvoice (the invoice header level), but I'll use your fields to outline a tec...

FYI, my guess is that the extra line is for freight which gets added as the last invoice line if you're using the AR Invoice report.

You're on the right track with ARAdjust, but I wouldn't do a join for this because there could be more than one Credit Memo or Payment applied to the ...