Good News Everyone! This is really easy to do. If you have a customization for the screen containing the selector, open it. Finding the ID of the fiel...

@ellie that's a great use for the feature! No one has asked for colored rows yet, but I think I'll try adding some to a couple of our reports that won...

Thanks Tim, I have a few instances where other fields are also searchable (customer ref# on SO's is one example). When I get some time, I'll try hitt...

Assuming you're looking at Sales Order Lines, go to your results grid for the inquiry, open a new result line, the object doesn't matter here, but I u...

We had to purchase special code to apply HTS codes (variable percentages by item in a container) at the landed cost screen. It cost us about ~$9,000 U...

Well snap, I was hoping it wasn't going to come down to my PC hating me. No one else has this installed, but I may go and test it out on another box. ...

I'm likely going to push this on to my accounting department as it has a multitude of uses and is simple to implement/modify, but I personally abhor b...

No dice. Just ran through a fresh install. If it's not the writer, maybe it's the report? I've attached the report. openordersbydayandshipment.rpx...

I have never attempted to break on error with a delete command. In fact, I've never created a scenario like you have for deletions. I am thinking it m...

I got your PM and I'll try to get this resolved with you.

If you have the import setup, I'd be happy to take a pass at it in your test system and see if I can find any glaring errors. Please ensure you don't ...

You can mass delete using a GI. If you have a way to tag your list you can quickly delete items. That's been my go-to method. Just go to the entry tab...

Thanks @timrodman I am currently using a tabular version my vars made that I've tweaked and it's close to what I want, but it's still outputting rows ...

I have not had this issue, I frequently tell mine to ignore errors. Noob question: You did SAVE after un-ticking the box right?

That looks solid to me. I'd not tried concatenating the year on to a date so it's good to see a successful implementation of it. Thanks for sharing yo...

I have not tried this, but couldn't you use SOORder.OrderDate - January 1, 2018 to get the number of days, divide by 7 and round up? I think this woul...

I loaded up your inquiry and I set your SM to ='SC', because my item items ID's start with "SC". I got a list of my ID's, such as:

This is exactly what I was after, but I can't get the lines to appear. It'll pull the first line on the receipt, but not all of them (I have 4 lines o...

You set SM as a hard condition, like if you were looking for a system code. I have a feeling you want ='SM' which is a text string.

I shifted your headings into PageHeaderSection1 and had no issues. Did you duplicate the headers and footers? I have had issues when duplicating segme...

I was indeed discussing option #3. Option #1 would create kit bloat. I like having the smallest selection set possible and I feel revisions add a laye...

If you post your report, I can take a look at the settings. No guarantees I'll resolve it, the report writer can be a bit fickle at times.

So you're fighting visibility in your kit specs based on ITEM / CUSTOMER / LABEL right? If so, revisions are likely your easiest out. Set the Stock It...

If the Parent is ARPayment then yes. You are asking the system to look at a VARIABLE (RefNbr) in the ARPayment table and then you're saying it must eq...

Part of your join should include the reference number if it doesn't change. Or the customer/location combo if they're unique for this inquiry. The jo...

I'm a bit late to the party, but as @timrodman said, it's not an option. However, you can add the totals via the report writer if you're comfortable m...

My Guess: When it returns NULL, it fails your conditions tab, so you don't get a row at all. Conditions don't accept NULL unless you specify the optio...

I'm not clear on your question as I see it interpreted two ways: Publishing a Customization: Generally speaking, no. But, it very well might change de...

Here's how I do it in my system: Open the screen displaying the GI (not the GI creation tool) and set your PERSONAL columns by dragging and dropping e...

In order to run this I had to delete the sub report. But when I did, I got all of the lines to appear: If you were to drop the subreport do you g...

I would post this question in Stack Overflow. We don't usually handle code in this forum, the developers do lurk around in S.O. though.That being said...

Can you attach the .rpx file please?

This might be a terrible solution, but it's what I'd do... In the report writer, you can duplicate groups/sections. Make the group with your balances ...

That works! Sorry for the delay, got side-tracked from my upload. For anyone else following along: This will import lines into a Sales Pr...

If you are not getting a numeric value to post after your normal invoice lines, we can find the issue. However if you are seeing a single number appea...

FS NO.PKPPDReal Cost FS3349 12 2.95 35.40 F16544 4 6.25 25.00 F16545 4 7.00 28.00 F16547 12 1.8...

This forum is unlikely to have what you're after. I would suggest shifting this to Stack Overflow and tagging your post with Acumatica. Most of the de...

I've not tried that, but if you add a condition where the note field "is not null" you should get your desired result. Just slap it into the Condition...

@shawn-slavin +1 for the flexibilty and scalability of your answer. My answer is a direct solution, but if you have the time or the need for it, Shawn...

You are so close it's scary. On your line where you show the inventory totals, you have the logic that belongs in the "filters" tab of your report. Op...

Aggregates: If you decided to set a group, let's say you're grouping all your PO Lines by your PO Number, then you need to decide how to display the v...

Glad you got it working! The join will produce null fields. The conditions tab will take the table that is created from your join and only show what i...

You need to do this on your joins and not on your conditions. Say I am left joining two tables: Inventory and OtherTable. The OtherTable only contains...