Is LeaseQuery the third party that you are looking at?

Have you tried the Warehouse Automation functionality in the mobile app? It's probably too limited, but maybe it could be customized to do this.

It looks great!

Looks interesting Paul. Do you have any screenshots?

I have found them to be very finicky too. I'm looking forward to a session on Business Events at Acumatica Summit 2023 where I'm hoping to learn more ...

@brendan-shepperd It follows the hierarchy mentioned above.

@mho You don't have to creat a Vendor Price Worksheet every time. It will pickup the cost that you enter on the Purchase Order.

I can't think of a way to do it. Maybe using an outside tool like Power Automate?

@roycelithgo one of those "gifts" that keep on "giving" 😀

Maybe store the previous value in an Attribute or User Defined field?

@jgoldberger I don't see why not. Just use SOLine rather than SOOrder.

@dave-ziskind That's weird. I haven't needed the +1 before. I wonder what's going on in your environment.

Maybe try CRActivity.RefNoteID instead?

Ah, good point. It seems like you can only pass stuff to a Generic Inquiry filter, not to a Generic Inquiry parameter.

@agupta That's brilliant! Thank you for sharing that post!

@mho Make sure you are doing a Max aggregation on the Order Totals rather than a Sum aggregation.

@zsolomon I would try opening a support case with Acumatica and ask them to make the change for you since a file on the server has to be modified. You...

@michaeltriffon Nice trick!

Here's another relevant link that might be worth checking out:

Ah, much better, that seemed to do the trick:

@lweinstein Try this:

@lweinstein Not in front of a computer right now so I'm replying from my phone and from memory, but those fields might be in the CR.Location table whi...

For your first question, try this:

Try joining to the DateInfo table 😀

Smells like a customization to me unfortunately

That report doesn't have the data that you'd need. You'd need to pull different data to look at the historical transactions to be able to figure that ...

What about using the INTran table since all of those transactions are inventory transactions?

@dave-ziskind That's a weird error. I haven't tried the Excel export, only the CSV export so far. I wonder if it's your first column since the tree ...

@roycelithgo I just updated the post with screenshots.

@stakaki Welcome! With your Crystal Reports background, I'd be curious to hear if you find that developing reports with Acumatica Report Designer take...

Duplicate lines have to do with what you have on the RELATIONS tab. I see <SPLIT> in the Location column which should mean there are multiple li...

I don't think it's possible, but I think @gabriel added this to the Velixo product which is another way to bring Acumatica data into Excel.

The License gets applied to the Instance and, as far as I know, the Instance can only be connected to one database. So, I'm pretty sure that all 10 Te...

The only thing that I can think of off the top of my head is the option in the user profile, but that's a default Warehouse globally, not specific to ...

You can also add it to the REPORTS area on the screen by using a Customization Project. In the Customization Project, expand the arrow next to the scr...

@edolan It's not intuitive to me when Acumatica wants to reference the User record vs. when it wants to reference the Employee record. Setting up an E...

Have you looked at Paya?

This might help:

@mikelupro Ya, they moved the Feedback area to somewhere in Community.Acumatica.com but, unfortunately, I don't have access to it since it's only avai...

Good move. Ya, I don't know of a cloud test environment that's just sitting out there to use.

@travisl Nice logo. You took "Avatar" literally 😀

@jhouser Maybe I'll see you at AUG Ohio (click here) in the near future?

@asisk I'll see you in Atlanta at AUG Summit 2022

I agree with Patrick. Also, I personally find that my SQL knowledge is very helpful when creating reports in Acumatica. I'm just not sure whether it...

I can't think of a way to do it other than using a SWITCH statement and converting the values manually.

Nice! Can you take a picture and post it back here? I can add it to this page:

@jeffrey-patch Thanks for the suggestion. I tried it, but it didn't seem to make a difference. There might be something in the Web.config file that wi...

Gabriel Michaud asked me via email if this works with any Generic Inquiry or just those tied to a data entry screen like the one used above. It seem...