Don't forget to add the new parameter to your conditions tab of the inquiry. Here's an example of one that will filter if a value is present or show...

My first instinct would be to check joins (particularly around CompanyID/SiteID/etc if it's a custom table) or if the subreport is being passed the co...

I don't see that POLine field in my version of Acumatica. Join to the InventoryItem table and your expression works just fine. =IIF([InventoryItem.Stk...

I was just playing with a similar query. My solution was to join INItemSiteHist.finPeriodID to FinPeriod.masterFinPeriodID. This gives you access to t...

Unfortunately, the GI is gone unless you have a snapshot, backup, or test instance you can copy it from. Your best option is to recreate the deleted g...

After you run a report or pull up a GI you can look at the trace to see the actual query used to pull the data (from the screen or request profiler). ...

It's possible through a self join, but I would recommend using the Quote or Sales Order form to really simplify the process. You don't even have to sa...

Can you provide a sample of the report?

Kits are always a headache. Try grouping by something like SOLine.LineNbr. I've attached a quick mockup for how I would typically tackle this. One t...

It's been a few years, but I remember going to our graphics department to request a specific variant of our company branding. Each logo had specific d...

This is an error we ran into occasionally. Although we never pinned down the exact cause, I do have some notes on how to fix individual orders. Hope t...

We print custom, branded packslips for one of our customers - and yes, they are very strict on the formatting. These packslips are printed out of our ...

My company ran into a similar issue. There were quite a few issues where the new price was only changed on 35/40 members and it was chaos keeping ever...

Here's a quick example on how to join AR documents to payments and memos by joining ARAdjust to ARPayment.

I'm still thinking there's some sort of permissions conflict on the screen level. It might be worth going in and resetting the perms on the screen or...

Looks like your formula has a rogue single quote after the <> in your formula. There are a few options to accomplish what you're looking to do...

Try joining SOOrder to the SOOrderDiscountDetail on OrderType and OrderNbr. Here is an example from a subreport that we use to display the disco...

What permissions do those user roles have on the Kit Specifications screen? Might just need to grant modify the access rights for those particular rol...

We're currently under stay-at-home orders, but are considered an essential business. It's been interesting to see how it shifted our priorities when ...

This was something that we explored during our implementation and couldn't find a good solution to manage our sales prices through bulk actions inside...

I would try consolidating your two groupings into just one (SOShipment.ShipmentNbr, SOOrder.SOOrderNbr, SOPackageDetail.LineNbr). The joins also seem ...

Sounds like you're close. If the label header info is in the page header section then all you should need is a page break in the detail section. ...

I was curious and tried this out in 2018R1. I created an order for an item (100 pieces total) that I wanted to ship on 5 different dates. The Requeste...

I'm not aware of an out-of-the-box report with that detail available. Luckily, the report you referenced could be easily modified to show that data si...