Hmmm, could it be that JAMIS Prime doesn't have that field? That's a pretty standard field though so I'd be surprised if it doesn't have it.

Checkout this post:

@jmck Just sent you the info by email.

Would you be up for coming on my Acumatica Podcast to talk through this and share more details?

@ken-akltggmail-com You mean MyOB Advanced in Australia right?

Great formula @cwomack ! Also note that Acumatica 2023 R2 has a new WIDGETS tab on the Dashboards (SM208600) screen which is kind of the opposite of...

@garenmardirossian posted about a WooCommerce integration here:

I'd be very interested to see a OneDrive integration.

You can move one Tenant over the top of another Tenant, but I don't know of a way to move a Company or Branch into another Tenant.

@pwills Excel is a great logical foundation. Now you just need to map that knowledge into Generic Inquiries and Report Designer.

@bill-rosado Thanks for joining and thanks for being a sponsor!

@pwills Welcome! Checkout my GI Course (click here) if you're struggling with Generic Inquiries.

@rybanez I'm curious about your setup. How many entities are there? Did you use separate Companies? Or did you go with separate Branches?

@teckla-kapuenene You can join over to the Users table to get this info.

You might want to try the technique that's used on the Sales Order (SO641010) report. It's not using the fields that you want, but you can see the tec...

@infosourcing Good question. I'm not sure yet.

So it fails every time, but can be competed manually every time on the Business Event History screen? That seems like it might be a buggy thing with...

@joni-girardi might want to chime in on this

Just curious, did you look at Lightspeed Voice (click here)? They take care of the Acumatica integration for you. I believe it even can push the recor...

It seems like maybe you're suppressing the Orders rather than excluding them with Conditions in the report schema. If that's the case, you can still e...

It looks like they added the ability to do this without code in Acumatica 2023 R2. You would add an Automation Schedule on the Print Production Orders...

Are you talking about this survey solution that was built during COVID? The GitHub page looks like it was updated last year:

You could create a Business Event with a Mobile SMS Notification subscriber to trigger a mobile app notification.

Try this: As you can see, these top two records... Appear on the CONTACTS tab of the Projects (PM301000) screen:

I think you'd need to do a SQL View for this. Here's an example:

@shennelly knows MRP well

I would compare the .rpx files using something called WinMerge which will highlight the differences between two text files. That might help you spot t...

@jeffrey-patch You could create a SQL View to expose it. I've done that before for hidden fields (or hidden tables) and it works great.

@sam-stoltzfus Ryan used a Customization Project to create a new screen in Acumatica, but he didn't do anything too crazy. He copied and pasted the so...

@kyle-wright You can get the Preferred Vendor for the Item in the InventoryItemCurySettings.PreferredVendorID field. This is how you join from Inven...

@rpiester You'd have to use Report Designer to generate a dynamic label.

@jwaldron Since you have Acumatica reading the emails from that email address, it has to store them somewhere. You could probably do a database script...

This isn't what you want, but you could do the following if you wanted the Week Ending date (not Week Number) for each Sales Order. You would ne...

Since Pivot Tables group by each field, it has to apply the sorting one group at a time. In your case, it's first sorting on Vendor, then on Vendor Na...

@alec-axelblom I'm not sure what version of Acumatica Visma.net runs on, but User-Defined Fields were introduced in Acumatica 2018 R2. You can acces...

@alec-axelblom Hmmm, not sure why it works, but at least it works. I'm glad that you figured it out!

As long as there is data in the period, it will print, unless you use the Visible Formula line in the Column Set to suppress it. You could try somet...

@paul-rapnikas Nice! Thanks for circling back on this.

@ntrauscht You can use FOREACH in the HTML of the Notification to get it to loop through the tracking numbers. Here's an example:

@missionaiden Doesn't look to me like Ship Via Codes are available in the Segmented Keys (CS202000) screen unfortunately. Maybe you could put your c...

@vhaase Did you end up doing a customization?

Hi Lorne, Going through old posts here. You probably figured this out already, but here's a way to get what you're looking for with a Generic Inquir...

@bmorgan @nscyoc I'll throw another idea out there and that is to use a SQL View to do the calculation. Then you could use the SQL View in your Generi...

I haven't heard any updates on this from an Acumatica perspective. I suspect that it was a curiosity thing that didn't go anywhere. I did though hav...