Hi Ellie, This is a good question, but unfortunately I don't know how to do it. I've deleted header records before, but you need to be able to delete ...

Do you get the same error if you enter the data manually into the screen?

Yep, building a SQL View and feeding it to a Generic Inquiry is my workaround for this situation.

Ah, interesting, I didn't realize that checking the box automatically causes the header to re-print.

Have you looked at the InvoicedItems generic inquiry that is in the SalesDemo database? Attaching it here in case you don't have it: Right-...

Have you tried something like this? Haven't tried it in a Row Set, but can't think of reason why it wouldn't work.

Seriously, tell me about it. We have the same problem on the Invoice side. At the last Acumatica Summit my team did a project on Accounts Payable Invo...

Great question Clark. My personal views have been evolving on this, but here is my current response. Acumatica's Report Designer is really best for pr...

The only special parameter variables that I am aware of are @Me, @MyGroups, @MyWorktree, and @Today. But it would be nice if we had a @Company and @Br...

Hi Lloyd, Glad to hear that you got it working. Did you use a Type of Header?

Wow, that's awesome! Thanks for sharing Michael!

Hi Pamela, Can't you enter the Quantity on the main screen without going into the Allocation screen?

Thanks Ahmed for the link. I think that's the answer to Jean's question. Just needs to be applied to the AP screen. About the parameters, I agree with...

Nice trick @ellie !

Shaded columns is the only way that I can think of as well. Seems though like your rows with a Type of Caption are the only ones with problems. What i...

Maybe it's because you Australians spell Cheque incorrectly 🙂 Just kidding. I see what you mean now. I reproduced this on Acumatica 18.200.0075. f I ...

Cool! Thanks for sharing! I could see this technique being useful in a number of places. FYI, I'm in JAMS M200 training this week. Finally found my wa...

Ah, yes, that would make sense.

It would be nice to have an Account & Sub option in the Expand field. Unfortunately, the only way I can think to accomplish what you are looking f...

I can't think of a way around doing a credit memo in this situation unfortunately. You might just to a Credit Memo in the Accounts Receivable module t...

Hmmm, good question, not sure. Maybe try clearing them out before saving the template to see if they get populated dynamically?

Good idea to just hardcode it in the report since it likely won't change very often.

As far as I know, magnifying glass selectors only search the ID and Description consistently across the system. You might try StackOverflow though to ...

Thanks for sharing Royce! I think though that might be a screen that MYOB built. I don't have that screen in Acumatica.

Hi Royce, Are you adding a filter to the initial inquiry that you see when you go to the Bill and Adjustments (AP3010PL) screen like this? Or do yo...

I'm not familiar enough with the Hubspot integration to know if it's possible. It could be an API restriction on the Hubspot side. But if you are inte...

Seems to be working ok for me. I entered a note on the Issues (IN302000) screen and it appears on my Generic Inquiry: Here is the definition of my ...

I can't think of a way to do this unfortunately. On the customer side, you could accomplish something like this with Discounts. But I can't think of a...

Wow, that's really cool. I thought you had to create the SQL View, then see it listed in the SCHEMA tab of the Data Providers (SM206015) screen and se...

Thanks for pointing that out Carl. Here is another option that people might want to look at: I'm not sure if either option does what VJW is looking f...

I think you'd probably have to identify row numbers in your import scenario which would get really messy since the number of rows could vary.

Interesting idea Kristi. I'm not sure how to do it though without having to press the RUN REPORT button. When you launch a report off of the REPORTS m...

The next thing you might need to define is what Accounts each Subaccount is valid for. Oftentimes there is only one Subaccount that is valid for Balan...

Thanks for chiming in Gabriel. No one knows more about ARM than you. And your Velixo Reports application is awesome. Great way to put it: bringing the...

Hey Geremy, You have to click the SAVE TEMPLATE button to save your preferred settings as a template (make sure you set the PRINT AND EMAIL SETTINGS -...

Hi Jo, I've never done this before, but here are some thoughts. At first I was thinking that we would just need to add a new field to the AGING SETTIN...