Currently this is what happens when you try to do BEGIN TRAN, then COMMIT TRAN:

I wonder if the clock entries might be marked as deleted, but still present in the database.

Maybe we could swap the SELECT and EXEC buttons so SELECT comes first, then use PgUp for the SELECT keyboard shortcut and PgDn for the EXEC keyboard s...

Version 0.6.0 handles this perfectly! I love it! And I like how the license check kicks in when a button is pressed rather than when a screen loads; I...

I like that technique that Royce linked to so much that I wrote a blog post about it: Note that you could also use a SQL View with a UNION st...

You could probably create a Generic Inquiry to put the data in the correct format, then put an Export Scenario on top of that.

When I've had this problem (and it was random, like you've experienced), unchecking Expose via OData, saving the GI, then re-checking Expose via OData...

You could just count certain Items or certain Locations to keep the population of stuff that gets locked to a minimum and allow you to get through the...

I think you'd need to use an Import Scenario if you want to see where the error occurred. You could also build some pre-validation in the Excel file...

Sounds like it could be a bug. I've definitely experienced some bugy-ness with Business Events. Is your Generic Inquiry grouping? I don't have the art...

@dguild Lack of better industry-specific reports is totally a common complaint. Unfortunately, you have to build it yourself at the moment.

I don't know of a way to put carriage returns in Generic Inquiry results, but that would be cool if it's possible. For your situation, I have you thou...

@jjavier Sounds like you have a fun role!

Ah, I forgot about this option. I've used Power Update, but I haven't used Power SQL Update. They are listed in the same manual though:

Ah, I forgot about this option. I've used Power Update, but I haven't used Power SQL Update. They are listed in the same manual though:

I haven't tried that. In general, Power BI is intended to pull data in, not send data back out, but you might be able to use the Power BI API to read ...

Wow, that was fast!

I think you have to click the Show previous replies... button on LinkedIn to see the comments since LinkedIn buries their nested comments. Does that w...

Once you convert the UNICODE(0) delimiter to a readable delimiter, I think this method could be used to split it into multiple columns. I still need t...

@AugSQL 1. I think this would be fine since the SQL View would be built specifically for the Import Scenario after the Import Scenario has been ...

@cgrigg Welcome Cary! I also like touting "sherpa" and "no financial relationship" because I think those things are important.

@muhammad-shaamel Nice! Since Acumatica's Mobile App doesn't currently work offline, Orangekloud is definitely a great option for companies that need ...

Thanks for the heads up. That's a big bummer! I really liked being able to put HTML code in header widgets.

Not that I know of, but that would be a nice feature.

@roycelithgo I prefer this method too. At a previous company that I worked at, I had over 200 email alerts running that caught bad data (we weren't us...

@astra-mathis Thanks for the comment Astra! And this is the first time that I've seen someone use "AOU" for "Acumatica Online University", nice!

I like the "K2 - don't uncheck the box" solution best 😀 But ya, editing the XML is the only real solution that I know of. Not the friendliest, but i...

I've experienced this before when you don't mark the Primary Key fields with IsKey. For some reason Report Designer gets confused. Search for "IsKey" ...

I think a Business Event would work well for this

@rpiester Hmmm, separate Cash Accounts is how I've seen this solved in the past. Is the problem that it's generating Inter-Branch transactions?

Does each Branch have a separate Cash Account?

@mandreottola Oh wait, it looks like the [APInvoice.DrCr] field returns a D or a C so you'd still need to use an IIf statement. I was thinking it re...

@roycelithgo Thanks for pointing that out. That's totally another way to do it.

Hi Marisa, It looks like you're referencing one of the examples from the Course. I agree that it's a little weird to have to do a formula to flip ...

@ddl I haven't looked at it in a while

@brleis Gotcha. That's the one that I'm aware of too.

I wish I could help, but it's been a while since I used allocations.