Configuration and Installation

Server Error in '/AcumaticaERP' Application.Found columns for index #0 not present in headersDescription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: Found columns for index #0 not present in headersSource Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:  [InvalidOperationException: Found columns for index #0 not present in headers] PX.DbServices.Points.MsSql.NativeMetadata.IndexReader.(IDataReader , IDictionary`2 ) +500 PX.DbServices.Points.MsSql.NativeMetadata.IndexReader.Load(Func`1 adapterSupplier, MsSqlScripter scripter) +1076 PX.DbServices.Points.MsSql.NativeMetadata.MsSqlSchemaReader.GetIndices(String table

Has anyone run into the following: We have configured MS Exchange with Modern Azure Authentication - that’s working fine except for emails that are triggered via a business event or an automation schedule. These are triggered using the admin user and without an Owner attached: This was fine when using Standard email accounts, but when we specify the account to send from on the Notification template, we get this warning - and true enough, the email generates but is never picked up in the Synching of Exchange and actually sent. It’s status stays as Pending Processing.  I have tried using an assingment map to assign an owner, but the owner field is non-editable at the time the email is generated so it never updates. I have also tried Linking it to an employee/contact/Entity - but this doesn’t seem to work either?  Any ideas?

We have a customization project from a third party that has a license which needs to be renewed this time of the year every year. How to setup a reminder to ourselves about this renewal date approaching. I know the exact date at which this license expires each year and it is available in the acumatica system as well . However we do not have anything setup in the acumatica system that could inform us about the license expiry. This year we found the license has expired only after the system threw an error while processing a transaction .I would like to achieve three things here , Acumatica system to let us know about the license expiry/renewal a month in advance Email to be sent to the third party inquiring whether the invoice is paid (whether they received money from us for renewal) Get confirmation from third party about the invoice and get a copy of the necessary API key to renew. Get confirmation from the third party that the new API is used and that the license is successfully renew

Hello all,I have been trying to limit the access to one of the User Roles but it looks like it is not getting applied.eg: I am looking to restrict the access to the “Pay” button in the Invoices & Memos (AR30000) screen for a particular user role to View Only or Revoked. I tried the following : Access Rights by Role screenWhat am I missing here?

Is there a way to connect a single scale, maybe two or three in time, to Devicehub without having to purchase "Automated Warehouse Operations"? It seems kind of silly that we can’t even connect one.Will we ever purchase "Automated Warehouse Operations"? Likely in time but we have a long way to go before getting into the Manufacturing and Warehousing aspects of Acumatica and we’d like to be utilizing this in Shipping now.Is there a compromise or work around anyone’s thought of that works? Thanks ;-)

What predefined User role gives access to the Storage Details By Item Warehouse Location screen in the Data Views workspace? Is there an easy way to find this information out (e.g. what role gives what permissions) without having to guess ‘what role does what’ each time?

Does someone have a import to user preferences?  specifically the default email account on the email tab?I am not sure it is possible  

Can someone explain the use of Work Calendars?   

Hi ALL,For example: Inventory Balance report > Click SEND   In the Email Activity screen > FILES > File name is the default.How to rename this default file in Email Activity screen before sending email ? Best Regards,NNT   

We had a user accidentally delete a custom object that uses automated number sequencing. I am able to restore the object from a copy from a different tenant. (<NEW>, then copy and paste). However, Acumatica generates a new ID for the object. Other objects reference this one based on the ID.Can I temporarily turn on Manual Numbering, restore the object, and use the old ID? If I do, does this operation impact anything outside of what I am attempting?

We would like to restrict visibility of Requisitions for a user to only have permission to view their own requisitions (ie, they can not see reqs submitted by other users).Is it possible to do this in Access Rights by Screen?

Hi All, @Tim Rodman , I have setup a Multistep PO Approval where I cant get the second step to work. The first step is for two users to approve where I have used the “Collect All Approvals….” (Rule Actions\On Approval which works fine).  If the PO is < $15,000 then it need not go further and can be approved.The second Step is where I am having the issue.  I have read the documentation and applied the rules but am still having issues. Please see attached for setup.Any help appreciated.Cheers,Laura

Is there a process to copy Access Roles between Tenants or sites?Thanks.

I’m looking for a best practice concerning SQL backup.  Is there a Acumatica-specific recommended recovery model (simple vs full) or is it based on standard recovery considerations?

As the topic says, I am trying to have a preview before emailing the invoices to customers. I would also like to add a link for our customers to access to. I would like to know how can I add the function for preview as well a link to the email that is send out. Thanks in advance

This business event is usually failing with a strange error and the occasional success since upgrade to 23 R2. Can anyone help me?  Business Event configuration 

Good dayIs there any size limit to  the database size of running a with MySQL database?If there is no limit what is the advantage of running Acumatica ERP with MySQL over Microsoft SQL Server?

Hi All,I am setting up a map with the following:Level 1: The employee is from the Department PR. When creating an Employee Time Card, it needs to be approved by the Group Project Admin Level 2: After Level 1 is approved, Group DM will be approved as Level 2 Level 3: After Level 2 is approved, Group Management will be approved as Level 3 Company Tree Setup With the current setup, I got issues as explained:If Approver Level 2 belongs to only Group DM, they can't open the Time Card If Approver Level 2 belongs to Group DM and Group Project, they can open the Time Card. However, they can approve a Time Card with the skip on Level 1This is quite similar to creating a multistage approval with instructions on  Acumatica. However, this document is out of date and can't be applied to my current version 23R1.Hope you all can help!Thank youYên Chi

Can an employee record that was deleted be recovered?  I deleted employee (0000709) because there was a duplicate.  But I actually need to use id 0000709 for an employee.  However, if I try to set an employee ID to 0000709 now it gives the following error.  I figured if I could recover the deleted record, then I can simply update the other information for that record.  What's the work around here?

I am able to configure all related web services, set up the database and even install a new instance of the application as per the installation guide for S100. However, when I actually try to launch the application from the Application Maintenance screen, I get the message “The system cannot find the file specified”. I don’t know what file it is looking for exactly, because the folder C:\Program Files\Acumatica ERP\AcumaticaERP does exist and is far from empty.I tried installing 2024 R1 Update 7 and 2023 R2 Update 8 to no avail. I am running SQL Server 2022 Developer and have no issues with connecting to the database with the SQL Server Manager.The log isn’t much use either. It just says “[08:13:34 ERR] The system cannot find the file specified” - again not specifying which file exactly it is trying to access. I am running ESET and Malwarebytes on my PC. I have disabled Malwarebytes completely and reinstalled Acumatica itself from scratch and created a new instance to no avail. I could

 Hello Experts, I am facing issue while approving po based on condition applied in Assignment and approval screen ,please have a look to the screenshot attached with it , do i have missed something in mapping.When Order total is >100 2.When order total is >10003.When order total is >10,000So i all the three conditions Assigned to and approver are the same. 

Hi, I have a client that wants to hide the Approve, Approve All, and Reject buttons at the top under Approvals. See print screen below. I went into security preferences and found the Approvals section but no additional options. I cannot find the option to do this. The Data Field is called EPApprovalProcess. Is this found somewhere else or can it even de done? Please let me know. Client is on 2023 R1.  Thanks,Frances   

Does the Pending Approval Notification template get sent again when an approval is reassigned or delegated?

I have a list of about 50-75 different Case Classes.  I want to add an attribute to all of them. Is there a way to mass update all of them?  Or do I have to do them “one at a time”?Just simply looking for an easy way.  If I have to do them one at a time that is fine.Thank you,

HelloI’m trying to submit create purchase orders screen Id: PO505000 the bellow images are my endpoints structure Top-Level from CreatePurchaseOrders endpoint, screen id PO505000 and Details from Details, in order to be able to submit multiple data at a timeand the action is Processthis is my url: https://{baseUrl}/entity/GTPDefault3/20.200.001.001/CreatePurchaseOrders/processwhile submit it with POST request it return 202 accept message,this is my json code: {    "entity": {        "VendorId": {"value": "V10106"},        "VendorName": {"value": "ABC"},        "Location": {"value":"05"},        "LocationId": {"value":"05"},        "VendorRef": {"value":"09078987"},        "CreationDate" : { "value" : "05/20/2024"}    },    "Details":[        {         "LineNbr" : {"value" : 2},         "Selected" : {"value" : true},         "OrderNbr": {"value": "Code-000395924"},         "InventoryId": {"value":"1MM650WHT-S"},         "OrderQty": {"value": 1.00},         "UnitCost": {"value": 20.00 },