Community
Discussion Forums
System Health and Performance

System Health and Performance

Discussions about optimizing performance

143 Topics
539 Replies

When you subscribe we will email you when there is a new topic in this category

143 Topics

Recently active

Most replies Most views Newest first

dsimmerlySemi-Pro III

asked in System Health and Performance

Performance review checklist

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 ?

16 hours ago

materessapasion34

asked in System Health and Performance

MINOR SYSTEM UPGRADE IN ACUMATICA

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!

14 days ago

chidao

asked in System Health and Performance

Create PO from Project PM301000

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.

14 days ago

TimRodmanSemi-Pro III

asked in System Health and Performance

Why are ERP Transactions getting counted twice?!?

I’ve been hearing that Acumatica cares more and more lately about ERP Transactions (vs. Commercial Transactions) so it’s super important that companies keep an eye on how many ERP Transactions they have each month and that they aren’t going over the number of ERP Transactions that they are licensed for or they will start having to pay more for Acumatica. I’m ok with ERP Transactions, they make sense to me, but I noticed a scenario where what I consider to be 1 transaction actually counts as 2 ERP Transactions. Can someone from Acumatica (maybe @Aliya) explain why this is happening? You can see the scenario shown in my demo environment (no customizations) in this 4 minute video segment:

14 days ago

nhatnghetinhCaptain II

asked in System Health and Performance

The "VAT Taxable Total" field on Invoice is not displayed correctly

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

16 days ago

dgodsill97Varsity I

asked in System Health and Performance

Does anyone have a process to purge uploaded files

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.

30 days ago

TimRodmanSemi-Pro III

posted in System Health and Performance

Audit History Purge Customization

☘ 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 😀

1 month ago

RobLoweJr Varsity III

asked in System Health and Performance

Outlook add in no details

Every few days, our Outlook add in stops working for all users. In Outlook, you click on the ribbon and the add in does nothing and the sidebar is blank. The only way we’ve found to fix this is to uninstall then reinstall the add in. The add in is managed at a admin/company wide level and it can take a number of hours for the uninstall/reinstall process to work.

1 month ago

dsimmerlySemi-Pro III

asked in System Health and Performance

ERP Transaction count

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?

1 month ago

debbiereed72Jr Varsity II

asked in System Health and Performance

How to stop inbound emails unrelated to business accounts (ie: Junk mail)

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

2 months ago

ray20Captain II

asked in System Health and Performance

Is it safe to clean "Auidit history" and how?

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.

2 months ago

ChandraMSemi-Pro I

asked in System Health and Performance

Best Practices to Manage Acumatica Push Notifications

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.

2 months ago

mrhoades

asked in System Health and Performance

Snapshots - What "attachments" specifically are excluded in "Full except Attachments?"

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.

2 months ago

kristianharianjaSemi-Pro I

asked in System Health and Performance

Notification when Business Event failed

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.

3 months ago

smartinez

asked in System Health and Performance

Product Availability sync error

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

3 months ago

HarshitaCaptain II

asked in System Health and Performance

No data under Audit History

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

3 months ago

NetAdmin42Semi-Pro II

asked in System Health and Performance

System Email account error mail receive failed command

Ok, this is a VERY new error on me.Doing some testing in my development server and I came across this error below in the screenshot I have never seen before, nor do I even know where the start to fix it.It showed up when I click “TEST” and the UID number changes every time I click TEST. Does anyone have any idea what to point me to, to resolve this?

4 months ago

kudzaim20Jr Varsity II

asked in System Health and Performance

How to set lockout parameters on inactive users

I want to set up a rule that when a user has logged into Acumatica and remains idle the system must lock them out after a specific period. For instance if an user has logged on and remains inactive for 2 minutes, is this possible?

4 months ago

donnadeskins55Varsity I

asked in System Health and Performance

Session timeout default

Does anyone know what the value is for the session timeout in the web.config file for SaaS instances?I have a customer that is asking (and very frustrated with being kicked out frequently).

4 months ago

donnadeskins55Varsity I

asked in System Health and Performance

Trace screen timeout

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.

5 months ago

estebanperalta54Captain II

asked in System Health and Performance

How secure is the connection and the company data?

I have a client who asked me how secure is their Acumatica connection and the company data. Does anyone have some insight into this?

5 months ago

jwang1Freshman I

asked in System Health and Performance

The linked contact on the Contact tab cannot be found

When I clicked ‘closed as Won’- ‘OK’, I faced this error with my contact information empty, and when I went back to override the contact information it was not saved and kept empty.

5 months ago

dilysJr Varsity II

asked in System Health and Performance

Why can't I prepare a dunning letter even though the customer has an overdue invoice?

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.

5 months ago

jcavanaghFreshman I

asked in System Health and Performance

Acumatica Support: Report Outage Page Error

Hello, I would like to bring it to attention that the Acumatica: Report Outages page has been experiencing an error for about a month now. Here is a screen shot. Would someone please let me know how I can report connectivity issues, or if this is a problem with my login? Nobody wants to be caught in a position where the service goes down, and there is no clear procedure for reporting outages.

5 months ago

kyoung14Jr Varsity III

posted in System Health and Performance

Performance Improvements / Custom Indexes - Best Practices

Just looking to see what best practices others have around improving performance of GI’s, pivots, reports inside of Acumatica. We have a client that does a lot of transactions (Project trans, Inventory trans, Sales Order trans). We’ve created many custom GI’s, pivots and reports (some utilizing custom DACs) for their data reporting needs. As their data and transactions grow, some of these are getting very slow to run. Maybe some of these are written poorly but many I don’t think there would be a better way. Is anyone out there creating custom indexes to address performance issues? I know we can use Request profiler in Acumatica to identify problem queries or SQL tools if we have a local test instance. Any best-practices or “gotchas” anyone wants to share on custom indexes and Acumatica? I know there are requirements around multi-tenancy (i.e, include CompanyID in the index). Any other thoughts or tools people have found helpful? Or are people just moving to 3rd party data ware

5 months ago

Page 1 / 6

Badge winners

nhatnghetinhhas earned the badge Low Code | No Code Customizations or Integrations
johnh3has earned the badge Easy talker
andriitkachenkohas earned the badge Configuration and installation expert
andriitkachenkohas earned the badge Integrations and Web Services | APIs expert
andriitkachenkohas earned the badge Reports and Generic Inquires expert