Solved

Hello everyone,I’m trying to create a new instance of an existing database but I get an exception with the following error.Kindly assistViolation of PRIMARY KEY constraint 'UPHistory_PK'. Cannot insert duplicate key in object 'dbo.UPHistory'. The duplicate key value is (5).The statement has been terminated. -------------------------------------- Inner Exception: Violation of PRIMARY KEY constraint 'UPHistory_PK'. Cannot insert duplicate key in object 'dbo.UPHistory'. The duplicate key value is (5). The statement has been terminated. ​​​​From the database this is how the situation looks like; NB:database was moved to a different server.​​Any kind of response will be highly appreciated

Hello everyone,I'm trying to connect Sql server in a DB server to App server so as to create the application ERP but i get this error.Kindly assist. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) -------------------------------------- Inner Exception: The network path was not found

The system names all the PDF’s ARInvoiceINV.pdf for the Invoice report AR641000. Has anybody tried to change this to include the invoice number in the report? Or does anybody know if this is possible. For example, can we change it to ARInvoice12345? Or something like that….

Hello all,I have been trying to add the tasks under Revenue Budgets tab of the Projects (PM301000) screen. i have selected Task under Cost & Revenue Budget level fields under Summary Tab. Even Empty Item Code has been set as <N/A> under the preferences screen, but still when trying to add the tasks the system is triggering the below mentioned error. The Inventory feature has also been disabled under Enable/Disable features. Kindly guide me to resolve this issue.Thanks in advance.

how do I resolve Row updated and row inserted getting called multiple times which executions logic twice 

Hi Team,I have create a new processing screen and in view delegate trying to access a Use Defined Field value from Customer screen to show on UI and I am using 22.106.0015 build version. I have referred some community posts but not been able to access the defined field value. Below are the samples I have verified:The customer’s user defined field value stored in BAccountKvExt table and in DB able to access it but in code not able to access this table. Access User Defined Field from business logic | Community (acumatica.com) from this community post tried to access using new cache object but that also does not helps. public sealed class SOLineExt : PXCacheExtension<SOLine>    {        public static bool IsActive() { return true; } #region UsrEmployer        [PXString()]        [PXUIField(DisplayName = "Employer")]        public string UsrEmployer { get; set; }        public abstract class usrEmployer : PX.Data.BQL.BqlString.Field<usrEmployer> { }        #endregion} public cl

Hi all,I am struggling with a report filter, when I attempt the below filter I am only receiving about 20 results and the GI has 370. Any suggestions? Thank you,Kage

Hello,     Our company has run Acumatica for nearly 3 years. We installed Acumatica on our own server and database. As an IT stuff, I checked there are large amount of history records when opening screen SM205035.    These records are not quiet necessary, so I want to clean them.     However, if I click “Delete ALL” button, I would get request timeout. Maybe these records are too much(we set some scheduler run in minutes interval).       I can select 1 page and delete 1 page’s record at once by clicking “delete”. but that is so time consuming.      Is there a better way to clean them?      To delete them directly from DB is probably a way to go, but I am afraid to broke the table constraints and reference of each other.       Can anyone give me some directions.

Have been trying to import an invoice into the system, but while importing it throws and error as shown below:  This error also gets triggered while I am trying to create the same invoice( Invoice Number: INV-0035) manually into the Invoices and Memos form.Whereas when I am trying to import other invoices (of different invoices numbers) the system is accepting it.Can anyone let me know the reason for this error getting triggered for this single invoice number and the resolution.Thank you in Advance.

Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen.  I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.

@Irina or someone, I am looking for advise/KB articles or anything else that can help me determine why a report is running so slow.  I know it could be the joins, subreports etc but I am hoping for someone to point out the typical culprits.My report takes about a minute + to run, has two subreports and only a few tables that are joined as recommended.  Any assistance would be greatly appreciated. 

Hello all,I am attempting to add a salesmen parameter to my AR Aging report so I can run that report as it is relevant to each salesman. I have attempted to add a parameter, however it still returns all invoices, and not just the invoices based on the salesmen entered into the parameter. Here is how it is currently set up -As stated, the report returns all invoices regardless on the salesperson ID entered into the parameter. Thanks all!

Hello: how create a transfer from sales order, but the item comes from secondary warehouse? Best regards

I’d like to setup Multi-factor authentication for all users in our tenant. I see options for sending an email or SMS but I would prefer using an authenticator app such as Microsoft Authenticator. Is this possible and I’m just not finding how to set this up?

I need to add the project manager employee ID (AcctCD)  to the PM-Projects GI but keep getting the Account ID (BAccountID) instead. This is my setup. EPEmployee is linked to PMProject. How do I get the employee id that starts with “E”? 

We just very recently had an issue come up where we have two copies of a production label printing from one production transaction. We are not looking for multiple copies and it is very hit or miss with transactions either printing one or two labels when performing a transaction. Has anyone else seen this or know of a setting I am unaware of? TIA

Hello everyone!I am trying to customize our SO workflow to change the state of a sales order based on conditions of sales order lines. By default I am not able to reference any of the SO Line fields in a condition for the SO301000 screen. Is there a way to add the SO Line fields so that I may reference them in a condition to automate the workflow changing the order status?For example I want to set up a condition like this:SO Line Description contains “Bar”ANDSO Line Qty over “200”Any and all help with this will be greatly appreciated! 

Does anyone know of or have a work around for default locations for transfers? I am talking specifically for automated operations. Acumatica has a default Issue from and Receipt to but there are no other defaults that I can see.  

Hi, In the Result Grid Tab, when i add a column and I set it to the attribute, it show the Attribute description by default. How to show the Attibute Value ID instead of the Description?I already tried a lot of workaround like Attibute.Value without any succes.I don’t want to use “schema field” because i will need to put this in formula .My starting point is from the Non stock list PX.Objects.IN.InventoryItemThanks  

Hello - does anyone know if the WA Cares tax for Washington state will be included in a future Tax Maintenance update? We are running payroll the first business day after the effective date, so we are very interested in the timing if this involves a Tax Maintenance update. Thank you.

Hi,  I’m a newbie to webhooks, so I might have missed something simple, please be patient with me 😀 I created a GI and created a push notification to send to a Zapier webhook. However the notification isn’t firing, and I’m not sure why. I attached the XML of the GI.  

Hi all, If I was wanting to add a new delegate to every active employee in the system, what would be the best way to do that? I don’t want to manually add the delegate to each employee profile, so I know there has to be a better way. I’m not familiar enough with import scenarios either. 

Version: { AcumaticaBuildVersion: 22.114.0029, OemBuildVersion: 2022.114.203.2690, DatabaseVersion: 2022.114.203.2690 },PUT: /entity/Default/20.200.001/Check{ "Vendor": { "Value": "A1", "Error": null }, "PaymentMethod": { "Value": "AUTODISBUR", "Error": null }, "CashAccount": { "Value": "100010", "Error": null }, "PaymentRef": { "Value": "8ed73344409a4a6f84afcf846f3bbc84", "Error": null }, "ApplicationDate": null, "Description": { "Value": "[Fleet Batch: 000001]", "Error": null }, "PaymentAmount": { "Value": 486.94, "Error": null }, "Status": null, "ReferenceNbr": null, "Type": null, "Details": [ { "DocType": { "Value": "Bill", "Error": null }, "ReferenceNbr": { "Value": "207668", "Error": null }, "AmountPaid": null,

See the attached screenshots. As you can see, the undeposited funds report shows Prepayment 009665 Ck#1389 with the amount of $3767, but when I add this payment to a deposit, it shows the deposit amount as $0.00. The reason I have a voided payment on there as well is that we tried just voiding this and reentering the payment to resolve. Unfortunately, the voided payment shows up as ($3767.00) causing my correction deposit to be negative. I have been using Acumatica for almost a year and have not seen this error before. Can someone tell me why this happened and how to resolve it?

 I’m trying to make an adjustment so my bank reconciliation ties. The Entry Type on “Create Adjustment” is blank.  I have a deposit and disbursements entries on “Entry Type”. Please let me know.