Dianne - Thank you so much!!! I had been testing out various ways to do self-join but using the null condition never occurred to me. GOLD STAR TO YOU!

Hi Royce, thanks again for the suggestions! The same issue remains even with that table. When items have multiple vendors, this table will return m...

Hi Royce, Thanks for the reply. We have the system setup like that already. However, getting price from the item is a manual process and you have to...

Here's a little bit more color: I have the POLine table and I want to get the most recent unit cost for each inventory item. For example, in the fil...

You can use a formula with nested if statements in the row styles entry box. Also, to simplify, you re-use the formulas in the results table for the r...

Make sure the users have permission to both the GI and Pivot table.

I've created a GI that does the opposite - looks at item consumption over a period of time (single warehouse). If you also only have one warehouse, I ...

@timrodman - unfortunately no, adding to the Sales Order is not an option through the outlook Add-in and I can't figure out how to add this as an opti...

There's some more information about what causes this bug. It's still an issue with Chrome:/p>

So it seems that this special code is actually the Ticket field. It also seems that the ticket is a sequential ID that's internally generated. I think...

Hi Tim, Is there any way to know what that special code is when looking at the record? As you listed above, Acumatica adds [Demo78089] to the subjec...

I don't see why this wouldn't be possible... you should be able to use the @@ to lookup Sku2 in the document details and then change the inventory ID ...

There is a known issue with attributes & imports fixed in 20R120.107.0026. I'm running an earlier version so I had to contact support. They applie...

Which customization project did you use for the integration? Did you use the one in GitHub /p> We're thinking about testing this on 19R1.