Discussion Forums

I have a strange problem that bugged me for ages. For certain records there is a mismatch with the number of attached files vs the count of files. In the example below, you can see it has one file, but states two for the count. I’ve come across a similar thing in the Companies screen on the Visualization Tab, where the Logo File file URL has remained. In this instance, it is fixed by clicking Upload, which ‘nulls’ the path name due to no file being there.In this example though that little trick doesn’t work. Please, any advice would be great, as it is confusing to see a file in the screen, but have no actual linked.

We have items we stock and count in whole eaches. We buy those items in pounds. Pounds can be a smaller unit than eaches, but we don’t want partial eaches in stock. We had our Company’s Quantity Decimal Places set to 0 and this worked fine. We assumed the risk of minor rounding errors during receipt, they never caused a problem.Recently we increased our Company’s Quantity Decimal Places to 2 to support other items. Now we cannot receive parts in pounds unless we uncheck the Divisible Base Unit box, but we don’t want partial eaches in stock. How can we get the system to round like it did when we had Quantity Precision at 0? 

Hello, with Entra ID SSO, if a user attempts to log into a tenant they don't have access to, Acumatica will create a record in the Users table for that user with no roles assigned.  They will receive an error and are unable to log in, but the user creation is a compliance issue for some clients.  Is there a way to prevent this from happening?For clients with SOC 2 Type 2 and other security certifications, how are you managing this?Thank you,

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

Hi.  Our client is looking for best practices in tracking vehicle and equipment loans.  How have you addressed this?   Do you create a separate GL account for each loan?  Have you found a way to tie it to the Fixed Asset in the FA module?  Has anyone successfully used subaccounts to make 1 GL account and then use subaccounts to distinguish between particular loans?I know there is this idea out there.  If you need this as well, you can go to the post below and upvoteFixed asset Loan Tracking | Community

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?   

I want to know the flow of Audit History for every page1. How the histories are maintained for every Page?2. What is the database flow for the tables used? Below is the query I have created according to my understanding for the Sales Order Screen (SO301000). Is it correct to check the history for every OrderNbr.Select Distinct u.username,sl.OrderNbr,au.ScreenID,au.UserID,au.ChangeDate,sl.LastModifiedDateTime,au.ChangeID,au.BatchID,au.Tablename,au.ModifiedFieldsFromSOLineSplit slInner JoinAuditHistory auON sl.LastModifiedByID = au.USerIDInner Join Users uON au.UserID = u.PKIDWHERE sl.OrderNbr = `ordernbr`and au.ScreenID = 'SO301000' and sl.LastModifiedByID = `userid`

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.

This thread will be updated when issue has been resolved.

Hello all!We’re exploring ways to improve the demo experience inside Acumatica, especially demonstrations across different industry verticals (Manufacturing, Construction, etc.) easier.Here’s what we would love to hear from you:How does your team currently demo Acumatica? (Self-hosted, SaaS demo environment, sandbox, etc.) Which roles do you demo most often? (Sales, Pre-Sales, Consultants, Customers, Prospects) What seems to work really well when your team demos Acumatica today? What are the biggest pain points when demoing Acumatica? What would make demos easier, faster, or more compelling for your team?Your feedback will help us make demoing Acumatica easier, more consistent, and more impactful for everyone involved. You can also reach out to me directly with your feedback either on Community or sending me an email (Vlad.Sushkin@acumatica.com).Thanks! 

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.