System Health and Performance

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.    

Hello, according to the below guide, I fully understand it is not allowed in some way to delete the "audit history".https://help-2020r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=5ce60e66-6997-4aa1-8496-b1bb106c41cfAuditHistory: Contains information about the database size used for saving the audit history. To review the audit history, you use the Audit History (SM205530) form. You cannot delete the audit history, so we recommend that you turn on the field-level audit for no more than few forms. But it is really large and obsoleted in database.  Can we delete, like more than 1 years old data? and how.The data is really large and grows rapidly. If the data can not be cleaned, it would be time consuming if we like to back up a snapshot, it would take hours.

Looking for advice on the managing the Acumatica Push Notifications that covers the below details.1. Ways to manage push notifications. How to identify the specific Push Notification that caused the issue on the Ques. The reason for the Ques not responding and finally why the data in the queue is deleted.2. How to prevent loss of push notification information on the que due to issues.

I’m hoping to confirm the scope of excluded “attachments” the “"Full except Attachments” and the “Full except Attachments and Wiki” actually refer to as Export Modes for snapshots.  I can see from a snapshot I’ve created with one of these modes that “Incoming Documents” within AP are all removed.  Are there any other modules where “attachments” are removed?  I can also see within Construction/Projects the attachments there are retained with the records, not removed, which is what I would hope to find.  Are there any “gotchas” these export modes may surprise me with?  Looks like the email files under “Time and Expenses” module are also removed for the most part.  I do find three incoming email with attachments, but only three.  We are 2022R2, Build 22.205.0026.

I am wondering someone has created a business event to push notification when a business event failed or when there are events build up in queue not running in System Queue Monitor.

We have this error on an items product availability in Sync history. It is not translating the inventory to the Shopify store and we can’t seem to figure out why. Has anyone had this issue and fixed it?  “The record has been assigned the Deleted status because it is related to an item that is missing, excluded from synchronization, or configured to not track quantity.:

Hello all,I have a doubt as to why for some of the scenarios the Modified fields column under the Audit History report is blank as highlighted in the below screenshot. In what scnearios & why are these rows blank?Thanks in advance