It looks like you already know the answer 😀 You can do SQL-style commenting like this:

Not that I know of, but you could rename the item IDs to something like ZZZ... so they all sort to the bottom

I don't have any direct experience with this scenario so I can only provide some theoretical thoughts and questions: 1. Your company produces seeds ...

So you can't delete it and you also can't deactivate it?

You could add a variable to the section that is a running total that only calculates when the account number is one of those two accounts. Then you'd ...

Take a look at the Trial Balance Summary report in Report Designer to see what DACs are used there. That should give you a pretty good idea.

That's a good question, I'm not sure. I would try posting on Community.Acumatica.com and maybe someone from the Product Management team will respond.

Try joining from ARAdjust to ARPayment on ARAdjust.AdjgDocType=ARPayment.DocType and ARAdjust.AdjgRefNbr=ARPayment.RefNbr, then group by ARPayment.Doc...

Ya, it would be tedious to create the role because you'd have to assign each report individually. As far as I know, there isn't an "Add All Reports" b...

I would start with the ARTran table. That's the basis for the reports that start with Sales Profitability by... and it will allow you to analyze invoi...

That's a great idea. Unfortunately, I don't have any ideas on how to detect if a file has been attached.

Try joining from FSServiceOrder.ServiceOrderContactID to FSContact.ContactID

I've wondered the same thing. My assumption is that you'd have to modify all of the screens that use Customer Status to drive the special behavior. No...

Is the UNPUBLISH ALL button on the Customization Projects (SM204505) screen broken for you? Or are you looking for it to unpublish automatically on ...

My personal opinion is $150-$200 per hour

There might be a way to finagle the Import Scenario to do what you're trying to do, but it might be easier to just handle it in Excel using Power Quer...

@sqlrunner I agree, that does seem like a bug

Can you post the DAC code? It seems like a Data Type problem with the Ship Via field. It wouldn't be a problem with the SQL View, but with the DAC cod...

Is your buddy running a newer version of Acumatica? They added that custom title option fairly recently, but I can't remember in exactly what version.

Can you edit it if you put it on hold?

I haven't, but that seems like a good idea to me

@beninsyncer-com Welcome Ben!

@rduke You've been using Acumatica since 2014? Wow, you're a veteran!

@mnecaise Sorry about that. XML attachments are now allowed.

Is the 1.0 maybe a percentage that's getting stored as 100?

You could create a SQL View that does the UNION.

@pankaj-saluja Since 2016? You're a veteran!

Ah, that makes sense. Acumatica Payments is pretty new.

@tlaird Which is the build where the default cash account isn't working?

Thank you Yuriy. This is helpful.

@gmartin Looks like you "got a life" at XMAS. Good for you 😀

You need ItemClassCD, but unfortunately it doesn't look like it's available. You can add a View, but that's a skill that I don't have yet. Graham is...

What build number are you upgrading to? I agree, 3rd parties are always the biggest headache with upgrades. No need to fear mentioning 3rd party n...

We're now offering additional AugSQL licenses for sandbox environments at the rate of $99 per year.

There's a foreach statement that you can use to loop through rows, but I'm not sure if there's an if. Have you tried putting the formula in the Gene...

Ah, good find. I wasn't thinking about that way of adding something to the menu. To add a column to the Print Statements (AR503500) screen, you'd ne...

@kphillips I wish that Schema Field was just called Format because that's really what it is.

Aren't you missing the "else" part of your "if" statement?

Is it basically a mailto: link, but conisio: instead? Is the problem that it won't save in the field?

Ideally this would be available out of the box, but one way to accomplish this would be to use a SQL View that could then be used wherever you want.

@gmartin Feel free to post it in pieces as you create it. That way it won't be as daunting and you can get feedback as you work through it. Then I cou...

It should have been deployed using a Customization Project. You can see all existing Customization Projects using the Customization Projects screen.

I don't have the screen in front of me, but you have to publish the Customization Project after adding the new fields to the fields area. That creates...

@jowilliams Do you recognize the name Richard Duffy from the SAP Business One world? He worked at Acumatica many years ago (before going back to SAP B...

@lthalmann So you've got the software in place, now it's time to use the software to its full potential. Keep that digital transformation train moving...

Unfortunately, AugSQL (click here) doesn't support MySQL at this time which MYOB runs on, but I was able to do the following in an Acumatica SaaS envi...