System Health and Performance

If acumatica is in azure, how often do they give maintenance to sql server, or how often, maintenance I mean (statics, indexes and base objects).

We are on a SaaS instance. In System Monitor we have many pages of “Requests In Progress”Are these hung processes that are really still running and reducing system resources? Is there anything we should do to stop these processes?

Hi,Our all customer sites are not accessible now. Server seems to be down. I have no notifications on version upgrades today. Is there any issue going on? 

Are Commercial Transaction counted across all Tenants including “test” tenants ?Are ERP Transactions counted across all Tenants including “test” tenants ?  

Hello, I am getting this error message when logging onto the system. May you kindly assist? Thanks 

Mail sent by Automation schedule is still in pending process and not processed why?How to overcome this issue? I need your inputs to resolve this issue.

Hello,      We use Acumatica to send emails often, and the outing going emails are actually not needed. It takes me a lot time and effort to delete them twice on screen “All emails” CO409070.           But I happened to find these records, even if I have clicked delete twice on screen to delete(first time make processed to deleted, second time makes it disappeared from screen.)          The table space usage are NOT actually reduced. Because it is still in DB, just with “DeletedDatabaseRecord =1 ”.        I am not quite understand why this is designed this way. My question is,  if we just Delete * from SMEmail where CreatedDateTime <='2022-09-30 20:30:55.027' and DeletedDatabaseRecord =1 .        Would it be OK?

Hi Team,  What is the best way to periodically mass delete import scenario files? We are seeing these add up in GB.  Best,Madison Clarke

I always have this problem when I am login to system. How can I do for this error? Thanks

As we try to track down the root cause of performance issues (with limited tools, since we don’t have server visibility), I’ve considered moving us from Acumatica Cloud to a private cloud.  For the cost of adding dedicated resources to our Acumatica Cloud hosting, we could spin up some pretty substantial resources out in Azure that we could directly manage.I know there are license/subscription concerns to be addressed with our partners, and I’m not too worried about those right now.  I’m more curious if anyone has made this move, what led to the decision, what the process was like, and if you feel it was a good decision in the long run.

Customer is asking for guideline that things to review when users are reporting performance issue Is there a document available for this ?  Has anyone create one ? 

Is there any way to increase the priority on running business events? It seems like when the system is busy during imports or automation schedules, it either does not process business events or delays it a very long time.Has anyone solved this before?

Is anyone experiencing issues when clicking into a project or task, the new window opens an empty project or task instead of the populated one you opened up? If I then go back to the original screen and open it again, the correct project or task will open up.

Hi! What would cause emails to be stuck in Email Pending Processing Screen?I am using expense approval email template to automatically send email to approvers that there is an expense pending approval. Some emails go out fine, but some remain in the Emails Pending Processing screen. When I hit the ‘Process” button, no error is given, and email goes out perfectly. But is there a way for email notification to send out automatically without having to hit “process”?

My AUNotificationTemplate table size is 10GB.We do hold a number of notification templates, none of them hold a full history (none of them even hold more than 10 executions in history).Does this table handle more than just automation notifications? What areas might I use to decrease the size of this table? Thanks!

Is build update restricted to SAAS accounts? Whenever we tried updating the site it says this error “Update could not be performed, because file 'c:\deployment\sites\PR00003841\siteroot\bin\CommandLine.dll' is locked by another process.”  

Hi everyone,Can anyone help me explain my business case with dụnning letter, the picture below is a dunning letter generated on Feb 13, but on Feb 14 there is another overdue invoice but when I go to the dunning letter screen to prepare on Feb 15 I can't see this customer.As a result, I sent a dunning letter to the customer and missed the overdue amount of the above invoice.I expect to be able to prepare a dunning letter when an invoice is overdue, or I misunderstood something, please correct me. Thanks in advanced.

Has anyone else been experiencing the “circle of death” when trying to open the trace screen to review errors: I and many of my customers are experiencing this. It’s not on any particular screen, it’s been all screens.It started happening a few weeks ago.It is not customer specific. I’ve had many customers complain about this.

Hi everyone, Just wanted to ask if it is required to republish the customizations in the system every time there’s a minor update on Acumatica (builds update)? Thank you!

Is it possible to Create Purchase Order from Project PM301000?We set all items we use for that project on Cost Budget Tab (including inventory id, qty). When creating PO, we will go to Purchase Order PO301000 and add ADD PROJECT ITEM, and only inventory id goes in. We expect the system will take the qty & unit from Project so we don't have to input that data again.  

Hi ALL,We have recently encountered many cases. The “VAT Taxable Total” field on Invoice is not displayed correctly as shown in the screenshot below. If you delete all the lines in the "DOCUMENT DETAILS" Tab, The "VAT Taxable Total" field is as shown below (it should be = 0) This is the Sales Order of the Invoice. The “VAT Taxable Total” field on Sales Order is displayed correctly. We would like to know the causes of this error. Is it an Acumatica system error? or a User error? or some other cause? Note: Acumatica Version 2020.R1 Best Regards,NNT

We see many client having outgrown or will outgrown their database sizes.  Has anyone found a solution to purge files?  A lot of these files are PDF’s of documents sent to customers/vendors, excel spreadsheets used to import data during implementation, images or documents like BOL’s and receiving tickets from vendors. etc. I have tried writing import scenarios and even asked for support but there just does not seem to an easy way to get rid of old files.

☘ Hoping I get lucky here!Has anyone developed a customization to purge the AuditHistory table?I’m thinking a simple screen called Purge Audit History with a PURGE button, a Days Old field, and a Save button so the Days Old value can be saved for the next time you launch the screen.When you press the PURGE button, it would delete records in the AuditHistory table that are more than the Days Old value that you input on the screen. The SQL Code would be something like Gabriel mentions here: Bonus points if you could add a schedule to this screen, but, honestly, I’d be perfectly happy to manually press the PURGE button. I just need a way to clear a table that has grown out-of-control.If no one has developed this, maybe someone like @Yuriy Zaletskyy or @Gabriel Araujo could develop this and resell it to interested people like me 😀

Customer is finding large number in there daily ERP transaction count on their Process screenCan someone confirm the ERP Transaction count in the example belowcustomer is running create shipment on a automation schedule of Proess Orders every 10 min there 173 - 175 records shown on history for each process - see below there are 171 -172 records that have a warning an do not create shipmentQuestion:  are the 171 - 172 records processed each 10 min but do not create a shipment considered in the ERP Transactions count? 

As Acumatica (understandably) is getting more strict on ERP transactions, I am trying to limit inbound email processing.