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.
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 ...