It's ok, I guarantee you that my Indonesian is much worse than your English. 1. Is there anything wrong with your first screenshots before you make th...

I only knew about it because I spent a couple of hours fumbling around a couple of years ago. I knew there had to be a connection, but it took me a wh...

Sue, You might try the "double slash" trick that is discussed at the bottom of this post:

Not that I can think of out-of-the-box, but what about this idea? Let's say the salesperson's name is Susan. What about creating two Salesperson recor...

Is the problem with Tabular that it won't flow to the next line after three columns? You probably had to change fonts because you need a monospaced fo...

It should still be free for one person, just paying when you share with others. See screenshot below which came from this website:

Wow, that second screenshot is not what I was expecting. Great to have this on file for the next time I need to do something like this.

Sorry about that, I should have said SOLine. I just updated my previous post to reflect that.

Sorry Iskandar, I'm still not understanding what you are trying to achieve. Can you highlight where in your screenshots there is something incorrect a...

Awesome technique Carl! I didn't realize that you could do that. Much cleaner than my suggestion.

I was actually surprised to find it there. And I agree with you that it's likely to change before Summit.

Personally, I like the idea of less formulas with more arguments, like you're doing with the existing formulas.

It's on the Builds website in the Preview folder.

Glad to hear that you got into Power BI. You won't regret it 🙂

You have 11 detail rows listed in your screenshots above. Do you want 6 lines to appear on the first page and 5 lines to appear on the second page? So...

Yes sir! My favorite 2019 R1 features so far:

Try joining from PX.Objects.PO.POOrder to PX.Data.NoteDoc on POOrder.NoteID=NoteDoc.NoteID. Then join from PX.Data.NoteDoc to PX.SM.UploadFile on Note...

Thanks for sharing this Gabriel. This is an exciting feature indeed. At first glance, it's just 7 new formulas in Excel (SORT, SORTBY, FILTER, UNIQUE,...

Awesome! Thank you for sharing. I don't see though the <Line Number> =-2 in your screenshot. Am I missing something?

Sorry Royce, I missed that, was reading too quickly. Doesn't that seem like buggy behavior to you? Seems like something that might get "fixed" in futu...

I just tried in 18.201.0050 and I get the same behavior as you do. Have you tried using two separate security groups for this, one in each screen?

I don't know a way to do this without customization. You might look at feeding a SQL View as a datasource to an Import Scenario that runs on a schedul...

Royce, Have you tried using a Customization Project for this? I find it works pretty well. The only issue is that you have to check-off all of the scr...

Great point. Just use IIf to detect the blank value and set it to NULL.

Hi Iskandar, Can you clarify if you're struggling with the page number or is it something else in the report?

Looks like this is going to get better in Acumatica 2019 R1:

Have you tried the Suppress Empty option on the Column Sets (CS206020) screen?

Can you include a screenshot of this screen?

Also, here are some useful video overviews:

Yes, use PUBLISH -> Publish to Multiple Tenants on the Customization Projects (SM204505) screen: Don't use Database Only unless you only want th...

Nice fix Michael! You're right Royce, looks like the Modern UI is on by default now with no way for a user to turn it off. I agree with you that it is...

The Acumatica response will be interesting on this one.

Take a look at the out-of-the-box Invoice form. There is an example of a formula in detailSection1 that I think is what you are looking for: =Assign( ...

So, it appears that this is not needed when using Excel. I assumed (incorrectly) that Excel was retrieving the data in the OData format since that's t...

Wow, very interesting. Thanks for sharing this Tim. Just curious, do you see an advantage to using the web service endpoint to get the JSON over using...

Learning a little more about the new Landed Costs (PO303000) screen in 2018 R2. In 2018 R1, when you added landed costs to the LANDED COSTS tab of the...

Not pretty, but you could do something like this where you define two hidden columns, then a third column that decides which column to print.

Ok, so I heard back on my support case. Looks like this is by design. So I created an idea that we can all vote on to change the design:

I think you just need to include the Warehouse ID when you join from SOLine to INSiteStatus to remove the duplicates. So use both InventoryID and Site...

Ironically, I just discovered today that the delete action on a Sales Order Line is not available in field level security. I have a feeling that the t...

Sue, Are you on an Acumatica SaaS Instance?

I've tried the import scenario, but I never got exporting to work the last time I tried it. I find it's easier just to use a Customization Project to ...