Ya, I think they might only work in the pageHeaderSection. Why not create two pageHeaderSections and conditionally print them based on whether it's Pa...

Ya, I think you'd need to put a Pivot Table on top of the Generic Inquiry.

I would definitely go with a Business Event here. The Automation Notifications (SM205040) screen is now largely obsolete in my opinion.

I'm not sure that Mailing Settings would work here because it's available on the Customers (AR303000) screen, but not on the Customer Locations (AR303...

Not sure. Never tried it before. The Sales Order report restricts the RefNbr options based on what the user puts in the OrderType field. Maybe you cou...

Interesting. I've noticed a similar issue, but hadn't found a workaround for it. Thanks for sharing.

Agreed. Same approach.

You should be able to do a Business Event for this. Your Generic Inquiry dataset would be Invoices that still have a balance. And you would send the e...

Checkout Lesson 6 about Tabular Reports in this course on Report Designer: That's the closest thing I can think of, but I agree with Royce. Report Des...

Been a while since I looked at PageIndex, PageCount, or PageOf, but, if I remember correctly, I think they are only available in the pageHeaderSection...

When you join to SOLine, are you using an Inner join? That would explain why you are missing some products. An Inner join will now only return product...

Nice Harsha! Are you using Acumatica Attributes in this screenshot? Or are they custom fields all added to a tab that you happened to call ATTRIBUTES?

You haven't seen a purge feature yet have you Harsha? I'm sure it's coming, especially now that more and more Acumatica customers have been running on...

Thanks for pointing out the file attachments Harsha! I hadn't noticed that.

What build are you using? I just tried adding a parameter to the PARAMETERS tab on the Dashboards (SM208600) screen for a Dashboard that already has a...

Uday, Do you want it to print to the screen automatically? Print to a printer automatically? Email automatically?

Can you include some screenshots Joe?

Can you include a screenshot of the Sales Orders (SO301000) screen before and after and also what you're clicking on to give you the desired result? I...

I haven't gotten too heavily into the Projects module yet, but are you talking about the Revised Budgeted Amount field on the COST BUDGET tab of the P...

Hey Hazen, Sorry about that, that post was causing trouble and slowing the site down for some reason so I had to rename it. I update my previous post ...

Thanks for sharing Daniel, especially the part about renaming to an .rpx extension. Very interesting.

Royce, I agree with your database level changes comment, but some database changes (like adding a field to a table) affect all Tenants. In general I'v...

Maybe you can reconcile one customer at a time to find the specific customers that don't match. Then you'd have some concrete differences to investiga...

Strange. I guess that's the downside of Excel. So many different versions. I'll keep this in mind in case I run into something similar.

Ah, now I see. As far as I can tell, a DateTime field only allows you to enter the Date portion. You might need a separate custom field for the Time p...

Looks like someone already created a similar suggestion:

What would make this a lot easier would be a FORMAT function in Generic Inquiries. For more on that: For now, what about something like this? It doesn...

I think that the Tax Category on the DOCUMENT DETAILS tab of the Sales Orders (SO301000) screen defaults from the Tax Category field in the ITEM DEFAU...

That might have been it. I'll try to remember to chime back in here the next time I need to configure consolidations.

Do you have a screenshot of where you want the totals? You might be able to accomplish this without variables. If you need to add variables, you can d...

It could probably be done, but it would take some work. The tricky thing with that report is that there are two joins to INItemSiteHist. I think it's ...

Good call on pointing out Velixo Reports Shawn.

The Load Records from File buttons are great, but as far as I can tell they only work on grids. I'm not sure if they could be made to work for somethi...

Hi Casey, Can you mockup what you are looking for in Excel? Bar Chart? Line Chart? Also, some other questions to consider: 1. Do you consider Sales to...

That's quite an ambitious list of joins Dwilk. Thanks for sharing. I'm especially interested in the join from InventoryItem to ARTran. Is this returni...

Thanks for posting the solution Myrcenary. Just curious here, have you tried removing it from the End Project field to see if it behaves the same? I h...

Hi Siva, So you want to run the report for 01-2019 and have, say, four columns print with the following headings? JULY AUGUST SEPTEMBER ...

Hi Travis, Have you seen this Help article? Also, you can import a starter kit into Postman: 1. Go to the Web Service Endpoints (SM207060) screen a...

Hi Bruce, The SQL View is looking for Accounts Payable accounts defined in the Vendor Classes: Is it possible that your Accounts Payable accounts are...

Hi Moira, You want them to enter a time like 8:04am and have it filter to show all appointments for 8:04am?

Hi Alisann, Thanks for posting your answer. I don't know the Service Order module very well, but I just checked the primary keys on those tables and i...