Changing requirements? Shocking 🙂 When you say notification, do they want an email notification or some other kind of notification? I don't think yo...

Hi Richard, If your specific use of Discounts is simple, then you might be able to pull off a Generic Inquiry. But to build a comprehensive Generic In...

Hi Jerwin, This looks like a Framework question that would be better suited for a developer. I'm pretty sure you can accomplish what you are trying to...

Nice solution. Here is the Tech Tuesday article that @shawn-slavin mentioned which uses the new Business Events feature: Business Events is better tha...

I would be curious to see what kind of SQL this gets turned into when the report runs. You can see this by going to Tools -> Trace after the report...

Hi Lindsay, Yes, you can build a tree structure. It will go through the tree from top to bottom and stop at the first place that is true. Here is an e...

You can go here to add a new group

You'll need to get the Subreport working first. Then you can drop it in the main report. To get the SO6210001.rpx Subreport working, you need to gro...

You're welcome. Glad you found it useful.

Ah, I see. What you really need is a DISTINCTCOUNT function like in Power BI, but there isn't such a function currently in Report Designer. You might ...

Hi Zanata, If you are starting with the standard Invoice, then I would recommend just adding a new group underneath the existing Invoice group. For yo...

Hi Sam, When coming off of another ERP product, there tends to be more fields that you have to find a home for. But with Quickbooks, the data should b...

Can you explain more about what data is in the report? I'm trying to picture it. Even better, if you could attach the .rpx file...

That's correct. Start with SOPackageDetail and join to SOShipment on SOPackageDetail.ShipmentNbr=SOShipment.ShipmentNbr.

Hi Stephanie, Even if you can get a formula to default the Parameter value, I think you might still have a problem because when I click the SAVE TEMPL...

Did you try copying your Production environment to a Test environment and performing the suggested change to confirm your suspicions? Maybe you'll get...

Awesome! Glad you were able to get it working.

It's not so intuitive unfortunately. To enable the section, you can right-click anywhere in the white area, then turn it on.

Hi Ron, You'll need to create a separate report that shows the multiple tracking numbers. Then you can drop that report onto your Shipment Notice as a...

Ah ha! That would do it. Interesting that DateDiff is smart enough to look at the time element. I wouldn't have anticipated that.

I can't think of a way to do this, but you could just start a new company file, import Chart of Accounts, Customers, Vendors, Opening Balances, etc.

Hmmm, so I guess that's not the issue. Are you getting your error when you click OK in your first screenshot at the top of this thread? Or does the er...

Sorry about that Shawn. Right now it's set to only allow you to edit for the first hour that the post is live. I think I cleaned up the links. Also, I...

I think the problem might be that you have your Conditional of Sale in the pageFooterSection1 area which causes it to print on every page. If you m...

I was able to add three widgets based on that Generic Inquiry. The First Widget is unfiltered. The Second and Third Widgets are using the same shared ...

Beautiful. I love it!

Ah, of course. Silly me. We're referencing the parameter from the report here, not the individual lines from the Row Set. Thanks for clearing that up.

Ah, ya, in my experience so far, ARM is definitely not as comprehensive as FRx was. Also, Report Designer is not as comprehensive as Crystal Reports.

Awesome. Thanks Richard for reporting back with your success.

So the unbilled amount is only sitting in a General Ledger account? Or the Project Accounting module knows the amount, but just can't break it down by...

Ah, I see. Thanks for the example, that explains it perfectly. So it seems that GLHistory only has a record for financial periods where there is activ...

Nice trick to find the DAC field! But I'm not able to get your formula to work. First, I told a line in the Row Sets (CS206010) screen to expand by ...

Just wrap the CreatedDateTime portion in CDate like this: =DateDiff('d',[SOShipment.ShipDate],CDat([SOShipment.CreatedDateTime]))

Hmmm, I was hoping you would say HTML. PDF usually handles the rendering better. Can you attach the .rpx file here? I can see if I have the same issue...

Hmmm, have you tried doing a partial shipment that is large enough to qualify for the discount? Seems like it's only applying the discount to the invo...

Hi Grant, I had exactly the same thought as Shawn before reading his response. This really seems like a situation where the customer needs a presentat...

Haha, naw, I just finally got around to knocking out some of the items that have been on my list for a while. Still a lot more on my list that I haven...

Are you using the HTML or PDF version of the report?

Hey Matt, That's strange, it doesn't look like the 2018 R1 folders have the AcumaticaTools folder that the Report Designer install file is located in....

Also, note that this was two separate topics, but I used the new combine topics feature that I have available in the forum software and it appeared to...

The only thing I can think is that your Acumatica version doesn't like the DateTime format of CreatedDateTime. Have you tried wrapping it in the CDate...

I'm trying to picture what that would look like. So one line for the GL Account in total, then separate indented lines underneath for each Subaccount ...

Hi @mmaxwell, Hopefully you have a Group section in your report. If so, there is a PageBreak option that you can use. I would set it to Before.