Unless of course if you are a MYOB Advanced customer in Australia or NZ in which case it still counts against your 5 Tenant limit and so is therefore ...

I confirmed your issue. If you include the GroupMask field in the results, it is reported as System.Byte[] - so likely it's some kind of bit mask fiel...

Well your query design worked fine for me. I changed it to inner join to filter users with no RLS security enabled. The results were consistent wi...

Yep I have issues all the time. The worst used to be when exporting from one tenant and importing to another, sometimes the node in the site map where...

Yes RPX report

I've never done it but i am pretty sure you can do what you are looking for - refer step 12 of this: Not exactly sure how you would map "Sales" to "M...

We use a custom report for Sales Invoices so it was easy to fix this. You just need to set the InvoiceLine group sort to [ARTran.LineNbr]

Restriction Groups by User under the Explore menu of RLS already gives you this information.

I have this issue too and i am sure that its only a recent change that caused it. I have far too many roles and special cases for users to contemplate...

Cannot do calculations on aggregates in GI. Also be careful when calculating multiple aggregates on joined tables that you don't get partial cartesian...

I think you need to get help from Support on this one. Posting an unbalanced journal is a critical error.

Licenses are at site level. You can add new Tenants and don't need to worry about licenses, other than allocating them to the users in the Tenant. Use...

Aren't revaluation Journals set to auto-reverse at the start of the next period? My experience with CM is limited to Translations and I see the same b...

So no one's done Account / Subaccount restrictions ? Our partner can't help either it seems.

Licenses are shared by all Tenants (what you are calling Companies).

Open the journal and reverse it?

Ok so I thought I had sussed this out from the Advanced System Management training and came up with a few groups of account/subaccount (segment value ...

Still don't see how it adds any value over something like Power BI. It's an excel reporting tool. Reminds me of nVision from my PeopleSoft days. 🙂 Th...

Oh yeah, that would be nice. Although imgur isn't that bad once you get the hang of it.

It's already pretty awesome - I'm drawing a blank here

What do you mean not allocated - you mean the Sales Order was setup as an SO instead of an SA? Or allocation was forgotten on the Shipment? You can de...

Don't see how that solves the consolidations issue - which I've already done in Power BI anyway.

I eventually solved this with a horrendous Query. Would have been far simpler if the Condition "Does Not Start With" were available. Please vote for ...

I have done this. Here's mine, specifically for reversing AP batches: ps. next time recommend starting a new topic rather than posting on an unrelate...

+1 for Power BI. It is amazing. But it does have a steep learning curve so you do need the right person to build it.

Is it possible it is somewhere else on the Sitemap? I have never experienced this problem before. Perhaps read through the XML of the GI and look for ...

I don't think this can be done. To me a lifetime max cost seems a little pointless anyway. Maybe consider writing your own GI with an appropriate time...

Only issue i have is exporting and importing via XML file GIs from one tenant to another. The site map in the imported tenant usually gets messed up a...

It was more about how to extract and then report the data in Power BI and less about the visualisation used. But anyway, I finally managed to get thi...

Use Power BI - you will be able to accomplish so much more.

Perhaps you need to start thinking about Power BI for all your advanced reporting needs. I did, and I've never looked back. GI can only do so much. I ...

BTW, you may want to take a closer read of this for your next post:/p> You managed to link your images to imgur rather than embedding them inline. Mak...

Don't think this is possible because sadly GI doesn't let you perform functions on aggregated data. You'd probably need to build it in Power BI and th...

ARM Schema Builder and GI both have this annoying limitation of supporting grouping on data fields only - no functions.

I answered my questions above in Red. I've found the Consolidations process to be quite limiting and of little value. You could achieve the same thing...

Is it possible that the Expose via OData box got unticked while you were reassociating the GI to the Site Map?

I can answer all of these questions myself now. 😀 I will do so if anyone is interested in Consolidations. The help documentation on this topic isn't...

Can answer this myself now. Consolidations financial period selection works on Financial Period ID values as defined in the "Parent". So if you select...

Delete the Site Map entry for the GI and re-assign the Site Map Location on the GI. Screen ID should only appear on the GI when it has been linked wit...

What about using the customer statements facility? I don't think it's a good idea to resend the same invoice multiple times to a customer.

Try switching to HTML view and edit the HTML directly so that it is valid. Also confirm the object name is correct. I used this many times without iss...

Tim, just to clarify, when i was referring to database changes it was DML changes and not DDL changes. In other words, records in a table and not tabl...

If it were me, i would just return no results and train the users. or alternatively, i am sure you can come up with conditions which automatically ada...

Getting the inventory data isn't hard. But I would like to know how you plan to get dynamic columns (pivot table) in a GI. Columns are static in a sta...