Here is something from one of our engineers. This is a general load balancing response based on years of load balancing our VPS environment and worki...

Can you take inventoryitem, left join artran, group by inventoryitem.inventoryID, and then do a count on artran entries?

If you put the condition of Branch=ABC in your GI join, you only get ones that meet your condition. You could then use isnull to show the normal valu...

I would first try to use Automation steps and adding the fields you want to edit to the fields tab. I believe that works for some of the fields. In ...

Glad we could help. I went to thank our accounting manager for her help answering your question and she had another suggestion - save it as a templat...

I talked to Accounting and basically we don't use the automatic tax bill feature of Acumatica. After getting the tax report, she goes to the FL websi...

We worked with Infosourcing to create a pretty nice customization. We take export the lines from the PR into excel. In excel, we built our own macro ...

@czarinan In HTML view, mine has the <foreach> look as well. It should still work correctly.

The trick with the table is that you have to do each row of the for each as a complete table. We hard coded the width of each column so everything lin...

@timrodman Have you ever messed with changing column names in excel when data is coming from oData? For someone who knows it well, it should be fairl...

You can probably do something by using OData and excel. Can I ask why you are trying to do this? I am interested to know the use case.

When I have tried to debug Auto Notifications in the past, I would remove the conditions and just put the field I want to monitor on the fields tab. ...

Ellie - glad it worked. We just happened to run into this exact issue a few weeks. Glad I could help.

We have our normal message embedded in our sales order report (mail settings section) and that adds the signature when we click send from print previe...

I just voted for this too. I can't believe with all the international versions of Acumatica that they don't have phone formatting at the country leve...

You could customize something pretty quickly that displays a pop up with the sales order note. Just be aware that the SO number is found on the shipm...

I did a demo and proof of concept with them and liked what they had. Their integration adds a task about the call and includes the recording if you e...

As you figure out a solution, something else you may need - notes from the customer to make it to the shipment. That way you won’t have to reenter not...

Checkout the link below. We just ran into similar issues and this fix from Microsoft allowed the links to work without having to log in every time. Th...

I just happened to get an email about DataSelf today. From their feature list, it looks like you could be able to schedule their dashboards to be sen...

Here is another option. You can use Capture from Techsmith (formerly jing). That allows you to take a screenshot and instantly saves it to the cloud...

I have not seen a scheduled dashboard email feature, but I would definitely be in favor of it! An idea I had while reading this that would also allo...

@dcote I am had you were able to find a variation that works for you guys!

Setup an import scenario that updates a custom field “complete date”. You schedule it to run every 15 minutes. It updated all records that are complet...

The override is handled by the objects in Acumatica. That’s one of the benefits of using them versus SQL. Check your ShippingContact object on your...

Here is an old help file that documents movement classes and the formula that it uses to calculate turns.

@nchyflyer As close as we could tell, something made Acumatica think that there was no sort defined for that GI for that user. The sort being used wa...

I wonder if you unlinked the attributes table of it would stop working again. We’ve seen some strange things with sorting sometimes. Like it working f...

It’s weird, but I have seen CTRL+F5 fix some things like this. Something gets stuck in the cache and needs to get cleared. I have also had some succes...

I am just theorizing a solution here. You could create the liability for the cost of the item being leased. You then create a generic inquiry that cal...

We don’t deal with approvals, but we do use business events to send out exception lists. On the notifcation template for the email subscriber, we use ...

Try using docbal. If not, then look over the data and see if there is any other combination of fields that would give you the same results as status=...

@erzi-zairbekova You're going to have to change the colors back to what you wanted. I did the multiple colors to better trace what was happening. ...

Just had a random thought while poking around Acumatica and it worked. Use the style below and it should work. Change colors to whatever you want. ...

I tried changing the order a little and then changing APInvoice to be CuryOrigDocAmy and got my new version to work change color as expected so the is...

Have you been able to get any color to show up? If you put something simple like ='red' into the row style, does it turn everything red? And then so...

I am not sure if you already found a solution, but if the switch doesn't work, I know nested if's work. You could do: =IIf( [APInvoice.Status]='op...

@kevin-ruppert I just saw that feature a few days ago and yes it will do exactly what we need. I played around with it in our test environment (looki...

@wendy-pratley We actually have field level audits turned on for most of our major input screens. It definitely helps understand what is an issue wit...

Native functionality. Below is an example from one of our business events. We have a scheduled event at 8AM each morning that alerts operations abou...

It looks like they would need access to view the files. I was testing last night and even tagging the attachment as public still required a login. T...

We only use a base currency so we didn't get into scenarios for multiple currencies. Since you are defining the formula to calculate the total extend...

I am just spit balling here in case this idea works. You could add a supplemental email that is sent via business events. You would have to write a ...

We had a similar problem because our purchasing team does some re-balancing on the receipt and had issues when the amount field was removed. We ended...

We needed something similar and ended up customizing a solution. You could have a drop of the contacts for the customer and then create an event that...