Solved

I recently ran into an issue with a PXSelector. I defined the selector to use a unique key as the actual key, but to display a different value. The problem is the selector became confused when there were multiple identical display values.I can kinda understand why this would be a problem, but it seems to me that the selector should be smart enough to differentiate between the options based on the underlying key value. Is this a core limitation of a selector or simply in mind when it was designed?​@Dmitrii Naumov 

We have a need to completely isolate data between tenants into separate MS-SQL databases. As an example Company A and B cannot share a database due to parent company regulations. The two tenants will share a single instance and each set of tenant data will reside in a separate DB, e.g. DBA and DBB.The installation documentation reads: “ The following diagram shows an architecture with multiple application instances. Each instance has multiple tenants, and each tenant has its own database.”Here is the documentation link: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=4b65b79b-e09d-46bd-9a85-7c1c0bb4eba5I see that instances are tied to a single database and I do not see a way to get the desired configuration as described in the documentation.Can someone please help me? Either how to get the desired configuration or a concrete refutation of the documentation.Thank you

Hello everyone,i would like to link a subreport to the invoice document.This subreport is intended to display activities that fall within the date range defined by two custom fields on the invoice screen (a start date and an end date).Without applying the date filters, the subreport correctly displays all activities. However, as soon as the date parameters (FromDate / ToDate) are applied, the subreport returns no results, even though there are activities within the date range defined by the custom fields.I have attached some screenshots to illustrate the issue. Could someone help me identify the cause of this problem?Thank you in advance for your assistance.Best regards,PanteaInvoice-Screen:Hauptreport: Subreport-Parameter: Subreport-Filter: subreport in Invoice without Date Filter:subreport in Invoice with Date Filter: 

Hi All,I’ve installed Acumatica multiple times, but I’m still encountering an HTTP 404 error when trying to access my local instance. Could someone please advise on how I can resolve this issue?   

every single page on the DAC browser errors out with this. I’ve logged out, I’ve tried firefox, chrome, and edge. What’s up with acu’s websites lately? yesterday i was getting admin denial errors on the resources log in page; today this.  Is there something i could have possibly have turned off by mistake?

Hi, I have a problem when opening a report and creating a new report, Maybe someone knows why?I am using report designer version 17and acumatica version 2024 R2 

Hi, I just realized that the system stores the date and time in UTC. I need to display the Created Time in GMT.What formula can I use in a Generic Inquiry (GI) to convert the UTC time to GMT?Thanks!

Hi, A client is looking to have a side panel on the inventory screen that shows the customers who purchased the item They do not want to see every invoice but a total quantity.  That is very doable with a grouping by Item & Customer.They also want to see last purchase information, the Quantity & the Unit Price & Date of Sale.  When I do the grouping the Quantity & Unit Price total. The Date Of the last sale is correct but I can’t get the quantity & unit price to show for the associated last purchase.Any help is appreciated.Bill 

We are trying to add a custom action button “Rate Shipments” on the Checkout screen in Acumatica.The button is added using a graph extension on Acumatica SOOrderEntry, but the button is not appearing on the screen.We are extending the SOOrderEntry graph and using the following code: using PX.Data; using PX.Objects.SO; namespace PX.Objects.SO { public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry> { public PXAction<SOOrder> RateShipment; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Rate Shipments")] protected IEnumerable rateShipment(PXAdapter adapter) { return adapter.Get(); } } } Issue: The customization project publishes successfully. No compilation errors. The button does not appear on the Checkout screen.  

Hello guys, i am trying to import customers through import scenario and i am getting the following error “Please confirm if you want to update current customer settings with the customer class defaults. Otherwise, original settings will be preserved”please help me how to solve this error. thanksplease find the attached screenshot.

Hi everyone, i want to ask about the fund transactions. So, I want to send my money from bank account (USD) to the other bank account (IDR), so it’s different bank accounts and currency. I already fill the blank item in the Fund Transactions, but I don’t get it why my RGOL is still zero (0)?I mean in my source dan destinations have a different date but why it’s still zero RGOL.Please help me to answer this, I’m just confused, where I should put the adjustment transactions of RGOL?Here I put the screenshoot bellow, Please help me to solve this, I really appreciate it. Thank you 

Hi,In 2024R1 our Add PO/Add PO Line/Add Subcontract/Add Subcontract Line buttons on Bills & Adjustments only showed POs related to the Vendor/Project selected.When testing in 2025R2 it shows based off Vendor selected only - is it an easy fix to add in to each button to factor in project also?   

Does anyone have an equation that can turn a negative to a positive amount in integrations. Our client integrates several thousand transactions and a handful (maybe a hundred) sometimes have a negative amount in the Debit and Credit field. This is happening because of how they are entered in the originating system. I have tried a few equations but keep getting errors. =IIf( [Debit Amount]>0, [Debit Amount], [Debit Amount]*-1)Cannot perform the ‘*’ Operation on System.String and System.Int32.  I have tried double and decimal formats and still get this error. =ABS([Credit Amount])An error has occurred while the Abs(Identifier(Debit Amount)) function was being executed: ‘Type mismatch in the argument 1 of the Abs() function: Expected on of the Integer types.’ I have tried the Int32, double, and string types.  I use this in excel. Not sure if the function actually works in Acumatica but thought I’d give it a try. 

Hi - I am currently working on User Access and was wondering how you restrict access to the Delete Row Button on the Details section of the AP Bills and Adjustments Screen.  Below is a screen print of the button I am trying to limit.   Any help is appreciated - Thank you. 

We were super impressed at Summit with the new Modern UI Calendar board.  Now that we’re finally on 25R1, I’ve enabled Modern UI for the Calendar Board screen in our Sandbox.  And I’m having a deer in the headlights moment.  I’m trying to remember what I can do with it.I’m not sure if I can dig up the recording of the sessions from Summit, but I do know it’s getting used in the community.  Some of the things that our users have asked about are:Can the axes be flipped, putting the time along the Y axis? Can we control what the axes are?  Our team would rather look at staff specific (and I believe I can add filter tabs for different staff), and have the board display days across the top. Can we control color coding of the calendar appointments? Can we control what appears in the calendar box, as well as the pop up when you click the appointment?I know some of these were a “Yes” during the training, but I can’t remember for sure, and I definitely can’t remember how to do anything with it.

We are wanting to create a new tenant as the new company is not financially related to the other.   I want to copy the structure but not the data.  can someone provide the steps to copy the tenant to a new

Hello,I had a salesperson come to me and ask if I can make sure that the lines in her Project Quote match the lines that are printed in the report. I see for sales orders , SOLine.SortOrder can be used. However PMQuote.SortOrder doesn’t look to exist. Has anyone sorted the lines on a Project Quote?Thank You,Brent

Hi everyone,is it possible to change components from an Non Stock Kit in an Sales Order, Shipment or in the service order?I haven´t found a way to do that.Thanks a lot. 

We are a construction company - how have people been making notes on photos from the app/field as they go? What is the best way to capture a photo and make notes on it so we know what it relates to?

I am trying to create a new project in VS on a 25R2 instance. (first time working in 25R2).I open the project and simply try to compile it.  I have not added anything to the project...just the default that was created.I get this error:Unable to find package Microsoft.Bcl.AsyncInterfaces. No packages exist with this id in source(s): Microsoft Visual Studio Offline Packages, TestSDKI see that there was a similar error a couple of years ago, but it did not address my issue. From the above link, I tried removing Microsoft.Bcl.AsyncInterfaces from my csproj file.  It compiles after doing that.  But then the site will not load.After killing the site, I can get it back up by upgrading the site only using the installation tool.Note that simply attempting to compile my project in VS, it kills the site.Could not load file or assembly 'Microsoft.Extensions.Options.ConfigurationExtensions' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.

I have a GI that shows the Qty On Hand for each item by Warehouse. I want to get the total quantity on open Production orders at that warehouse for that item.  What tables/DACs do I need to join to my GI to pull in those numbers? 

Does Acumatica allow the ability to group multiple purchases to one Asset Under Construction?  A one to one relationship between a purchase and an Asset does not line up in all cases(Example--parts from one vendor and Service from another for one specific portion of an overall project).  

I’m attempting to create an AP Bill that should post to the FA Accrual Account (142920) in order to track the CIP of an asset. Since this is a project-related transaction, I used the FA Accrual Account, which is configured in the Account Groups on the AP Bill, so that the actual values flow through to the project.Below is a screenshot of the AP Bill entry The Journal Entries: Debit the FA Accrual Account (142920) and Credit Accounts Payable (205101) which is correct.Screenshot of the Accounting Group showing the GL Account linked to the AP Bill, ensuring project costs update correctly. When I try to convert the purchase to an asset, on the release of the entry, I get the error: Error: Inserting 'GL Transaction' record raised at least one error. Please review the errors. Project is Required but was not specified. Account '142900 ' used in the GL Transaction is mapped to Project Account Group message.  You will notice the error is referring to account 142900 (Project WIP Account) which i

On the print confirmation the lines and qty duplicate. lines nbrs 1 and 3.  

HiDoes anyone know if you can add to the Quick Filters. I want to add Workflow Stages but the filters seem to be hardcoded