Discussion Forums

We are experiencing issues with push notifications firing successfully but not being received on the mobile app. This was first identified when our clients wanted to enable multi-factor authentication, and upon investigating, we found that in our demo environment we could successfully create notifications but we didn’t receive them either. Here is a test notification I created that fires successfully, but no notification is received. We tested with multiple mobile devices, all with the notifications turned on for the Acumatica app, but nothing is received and the system shows no errors??   

I’m trying to pull in the date and time a Sales Order was created for some metrics for my shipping department.  They have a cutoff time, where and order entered before the cut off time should be shipped same day.  When I look at the SOOrder table, it looks like I should be able to use SOORder.CreatedDateTime, but in the GI, I only see the date, not the time.  Is there a way to make the time exposed.  And maybe even better, a way to split the date and time?

I recently created a pivot table off a GI that shows unit inventory and sales. The inventory piece is a bit challenging in that the Qty Available is correct, but on some lines it’s showing up as two separate numbers - always double what the actual available amount is.I’ve checked the GI and it shows the correct value, so I’m wondering why it’s doubling in the pivot table.not all records are like this. only a few. see below. Is there something wrong with the inquiry or is this a bug in the system?thanks!Joseph

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Congratulations to our 2026 Acumatica MVPs!The Acumatica Community is filled with customers, partners, and creators who are just as passionate about ensuring our ecosystem thrives as we are. Our Community members go the extra mile to serve each other, and one of the ways we like to show our deep appreciation for their efforts is by honoring those who selflessly share their time, expertise, and knowledge with the Community.Read the Blog Here Acumatica User GroupsNew! Piloting our first industry user group! Construction Customer User Group Request to join today!The Construction Customer User Group is a place for customer networking around construction-specific ideas, ques

Tags have gone missing and ticket opened with Gainsight. This post will be updated when issue has been resolved.

Hello morning guys,Is there a way to configure the access right by screen by disabling the delete button in header document and enabling the delete button in the line document? Is that possible?The screen ID is CA304000.Thank you in advance.  

Issue Description: We have locked down the Stock Item screen to prevent users from adding/modifying vendors on inventory items. However, we've discovered that users can bypass this restriction through the Purchase Order workflow:User creates a PO with a Stock Item and adds a vendor that isn't currently associated with that item When the PO is received, the system automatically adds the vendor to the Stock Item's vendor list This circumvents our intended security controls on Stock Item vendor managementCurrent Setup:Stock Item screen access is properly restricted for regular users Users have appropriate rights to create and receive POs This appears to be happening during the standard PO receipt processQuestion: What's the recommended approach to prevent vendors from being automatically added to Stock Items during PO receipt when users don't have direct rights to modify Stock Item vendors?I've considered:Purchase Order Preferences settings (but haven't found the right option) Stock Item

In 25R2, I have exposed custom generic inquiries via OData, set up a connected application, and can call the OData endpoints from Postman.  I handed-off the initial collection to our MS dev lead so that he could wire them into a custom application.  He is attempting to generate T4 templates against the v3 metadata using a VS extension tool, but the metadata is not well-formed according to the schema referenced.  First, all of the standard GIs exposed via OData have naming validation errors with dashes or spaces in the names, so I removed the OData checkbox and republished them.  Second, it appears that Acumatica does not add Nullable="false" to the fields in the Keys sections, no matter what the underlying field definition is, and thus there is a generation error for every key field indicating “All parts of the key must be non-nullable.”.  So, he is downloading the metadata file, scripting the addition of the attribute to every key field and then generating against the local copy of th

Hello, is there a way to change the Shipping destination Type under Requests? Currently it seems to default to Branch, we’d like it to default to Warehouse. Is this possible?” Thank You!

I am building a GI to track OutOfStocks from sales orders, but have gotten stumped on the inclusion of the sales order pop-up notes. (We track our OOS via notes, since the backordered SKUs get removed from shipment and then cleared out so the backorder status etc is not able to be tracked for just those SKU as it gets completed still.) It seemed like I only need PX.Objects.SO.SOOrder + PX.Data.Note, but when I access those note text fields it is not correct. When I use “inspect element” it doesn’t work on the open popup, only clicking the note symbol which only gives me “NoteShow”  Per the screencap above, I’m trying to get “OOS 183889” to show in the GI, but I can’t seem to target THAT note field.Note.NoteText pulled in the origin sales order notes from the external system and/or AP, not the notes in the pop-up record in Acumatica.Note.NotePopupText found no text to display, even though I can clearly see them on the sales order.Is this the wrong table? Here are my settings: Thank you

Acumatica does not allow us to apply a 2nd Prepayment against a Balanced Invoice if a Prepayment  already transferred to the Invoice from the Sales Order.Here is our process:Create SO Apply Prepayment of 10% to SO Create Balanced Invoice (do not release, we have to wait until our customer picks up the product to release the invoice) - Acumatica automatically pulls the SO Prepayment over to be applied to the Invoice. When customer makes final payment prior to picking up the product, we want to apply a 2nd Prepayment against the Balanced Invoice - Acumatica does not allow this (I found a quirky workaround that if you temporarily unapply the SO Prepayment from the Invoice, apply the 2nd Prepayment, then reapply the SO Prepayment, it will allow you to apply both Prepayments).  The reason we use a Prepayment for the final payment prior to pickup is because we have situations where a customer makes a final payment but doesn’t pick up until the next month.  If we would use a ‘Payment’ type tr

I have created a Daily Order Entry report to compare January 2025 and January 2026 side by side.My requirement is to group the data only by Day (1–31) and combine both years into a single row per day.In the report I have attached when I apply the year filter then in 2025 section I am getting the 2026 records as well and vice versa for 2026I have already: Updated the grouping conditions Modified the date field formulas Adjusted sorting Has anyone faced this issue? What is the correct way to group by day only and compare two years side by side without getting duplicate rows?I am attaching the screenshot and report file for reference.Thanks.

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