Checkout this article from Doug Johnson about how to make a SQL View available as a Data Access Class in Acumatica. Once it's available as a Data Acce...

I agree with others that you probably need to customize the screen. You can try going here for questions about how to customize:

Hmmm, I just checked the release notes between our versions and didn't see anything. I wonder if you'd get the same behavior if you move to the same b...

Perfect! That's the one I was thinking of too Royce. To use it, the TR Order Type has to be active on the Order Types (SO201000) screen: And you sh...

Weird huh? Apparently it makes sense to programmers why the order is reversed, but not to me. Just the way it is.

Clever use of Import Scenarios Royce!

You could pull off something like this using Power Update (click here) if you were ok with designing the reports in Excel using OData and having the o...

If Acumatica's Dashboards do the job for you, that's definitely a better option. Then all the data is live. Power BI comes in handy when you need more...

Sounds like a bug to me. I've seen where you can change the UOM on the Sales Orders (SO301000) screen and it automatically updates the Unit Price acco...

I haven't looked at them since you can now embed Power BI Reports. I just don't really see a use for them anymore.

I don't think you can do Automatic Packaging for Non-Stock Items. There is an AUTOMATIC PACKAGING section on the PACKAGING tab of the Stock Items (IN2...

I don't know the Projects module well, but my understanding is that the out-of-the-box reports are limited. Have you tried building reports using the ...

I'm not sure how it would be done. You could accomplish the same thing with OneDrive and Excel Online, but it doesn't look like that is an option. You...

What about attaching the sheet as a file attachment to the Shipment transaction?

I've noticed the same thing as Shawn. There is a difference between sending the email from an ACTION vs. using the SEND button. In general, I've found...

I think the challenge would be the same. The problem is that the Salespersons (AR205000) screen is only set to define commission percentages at the Cu...

Are you sure that any records are printing in the Subreport? It doesn't look like it from the last screenshot. Since you put the variable in the detai...

Try this. Two reports. The first is the Main report and the second is the Subreport. Notice how I'm calling the $Var1 from the Subreport in the Main...

You should be able to do this. The Data Source field is basically the same whether you put it on the Row Sets or the Column Sets. How are the Contract...

👍

Have you tried wrapping it in the IsNull function?

I've worked with SkyKnack before and had a good experience:

If you leave the Financial Period field empty when you save the Template, it should default to the current period according to the System Clock. But a...

What version are you running? I just tried in 18.206.0011 and I'm not able to see the Inactive item when I use the Kit Inventory ID lookup field on th...

Hmmm, I never noticed this feature before. Could the Transfer Order act as the Transfer Request? Maybe put an approval process on it before it becomes...

Morgan, Right, Report Designer is only needed to edit reports. When you run a report, it's running through your web browser using the Acumatica Framew...

Thanks for sharing MWA. I didn't know about the UPLock table.

What a great way to get the job done. I love it! I hope your AUG experience has been good on mobile.

That's a bummer 🙁

I love that good old fashioned screenshot 🙂

I think you want to handle this by assigning the appropriate Tax Zone to the DELIVERY SETTINGS tab on the Customers (AR303000) screen. This same field...

Good point Shawn. If you have multiple Items in the same Bin Location, but you aren't Lot Tracking, then they aren't labeled appropriately and you don...

Seems like a bug to me with the Excel manual export.

So it looks like two Excel versions: Microsoft Excel 2016 MSO (16.0.9126.2336) 32-bit Microsoft Excel for Office 365 MSO (16.0.10730.20102) 32-bit Whi...

Interesting. Seems like a bug with the Excel manual export then.

Are you Lot/Serial Tracking your Inventory? Also, what Valuation Method are you using?

As far as I know, you can't control anything on the TOOLS menu, unfortunately.

Looks like it's POLine.SortOrder