Very cool. Thank you so much for sharing.

@raphael-fournier Hmmm, I haven't looked at this in a while. I think we'd have to run a trace on a Generic Inquiry to see the SQL code that gets gener...

You actually don't even need a report variable for this. I'm typing this on my phone and going off of memory here, but I think you'll get the general ...

Seems fine to me. How are you joining between the AMProdOper and AMProdMatl tables? That could be the issue.

You can do something like this to detect what column you're in:

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...