Report Designer is quite limiting. For Pivot Table you could use a Pivot Table object in Acumatica or better yet, Power BI.

Maybe check the Conditions tab.

Power BI is the best tool for this kind of thing. But you need to be able to understand how the data is stored in Acumatica and develop an appropriate...

I already have a list of My Approvals on My Dashboard. You can add that page directly to a Dashboard via Data Table widget. For Inquiry Screen just pi...

I don't use Modern UI - What opens when you click the link? I assume its the standard Organization -> Communication -> Tasks -> Approvals pag...

Not sure to which Page in Vendor Management you are referring.

Fundamental rule of GI - you can't modify fields that are inaccessible in the UI. In other words, you can't change the Status. You would need to find ...

I've written GIs to lookup Lot Nbrs on Inventory transactions. Nothing particularly complex about them. Just build the GI as you would any other GI - ...

That's only true for Site level customisations - database level changes (eg. Site Map) will not be published to all Tenants through a single publish (...

Probably a join issue then if the result doesn't match. If you have aggregations in the query, turn them off and make sure no duplicate data or data m...

Edit the report, open Build Schema, compare the report Query logic to yours. Or even clone the query from the report.

I think you would need to setup multiple templates and parameterise whatever user level filtering is required so that each user only gets the data app...

Don't see the problem - GI should easily be able to handle that Condition. Please share a screen shot of your GI Conditions. If you don't know how to ...

Add a parameter for Approver ID. Use the parameter in Conditions to filter EPApproval.ApprovalID. On the dashboard for each approver, specify the corr...

Tim, I think you might have missed the issue asked here about customisations applying to one Tenant but not the others. If these customisations are Fr...

No. Scheduled reports are distributed via email only.

I built our entire suite of master data imports for implementation. I don't see the need to integrate these with pages. They are on-time imports durin...

Yes, works fine for me.

I highly recommend you bracket the OR conditions, even though there are currently only 2 conditions at the moment, it's a good practice. If in the fut...

Using Shawn's solution, you just need a 2nd condition to allow for [POLine.OrderNbr] having a null value - both conditions should be surrounded in bra...

Because the field is not a date, the Hour(), Minute() formulas cannot be used: I assume it's designed to represent time spans in english, as per your...

Sorry i thought you knew GI well enough to understand my example - you need to put the data object in square brackets, like what you did for your 2nd ...

I had a similar problem with FA trying to automate depreciation for current period. Unfortunately this appears to be a limitation in the scheduler tha...

Isn't this what you need? Perhaps they moved it from Purchase Orders to Sales Orders.

I can't see any other way of solving this without customising the code.

So does this means that at the website end, you are unable to identify whether the website user is either a "random customer" or an "employee of a tax...

"Any differences between the standard cost and the unit cost on receipts multiplied by the quantity on the receipt are recorded to the standard cost v...

off the top of my head: =Hour(ActualDurationTotal) + Minute(ActualDurationTotal) / 60 For simplicity I am assuming seconds aren't relevant.

So instead of using a default "website customer" record, update your web code to first match the web customer to the Acumatica customer record, if non...

I would be looking to have the website update/create the Customer record in Acumatica as part of the order being created. And then ideally, pass the c...

Yes, I know this error. Same thing happened to us during our FA import. You need to Generate FA Calendars - I did it up to 2050. note that this is al...

I don't see any screenshot showing the actual error message and therefore cannot answer your question.

You want to Setup an Automation Notification for the Purchase Receipts Screen. Read the help screen on that page and go from there (that's how I got g...

Because you put the <Dialog Answer> AFTER the line that triggers the confirmation message. As per my example, it needs to be BEFORE.

Your screenshot image is broken. You need to useto share images.

Or perhaps this is the user unfriendly error that appears when consolidation companies calendar's don't align.

Response from MYOB: this is not a bug and create an idea on the ideas portal. There was already an idea, but it's over 4 years old so i don't see this...

I scheduled ours for every minute. Works well.

I can answer this myself... discovered that CreatedDateTime is in UTC and so needed to add 10 hours to that to get the actual local time. This formula...

My exported PDFs have no clickable URLs at all, whether viewed with Chrome internal viewer or Adobe Reader DC. All links are converted as plain text o...

Well this worked for me. When I first tried it without _blank, it loaded in the same tab. With _blank it opened in new tab. I tested in the Report Vi...

We are also a MYOB Advanced customer and Report Designer bundled with that includes mod operator. Version I am running is 18.108.16.168.

When you said "doesn't show any information if/when a row has been deleted" I thought you meant that it doesn't Audit deletes, which it does. But the ...

Are you using native PDF support or Adobe Reader browser handler? Exactly how are you users running this report?

I spoke too soon - I simulated the above procedure in an Acumatica training database. I published a small "customisation" project with a couple of tri...

It needs to be "_blank" and not "blank". Here's a basic test you can do to check your browser. Paste this in to notepad and save as test.html. Drag te...

In hindsight, this is probably what i should have done: I would imagine that when followed this way, the copy project would only appear as published ...

Just to play Devil's Advocate here, I'd really want to give a lot of consideration before importing crusty old finance data into a new ERP system. The...