Solved

Hi,  I am adding a pop up note in one of the customer.  Should this pop up note can also be displayed when creating project?Currently it does not show the pop up note and wondering if this is just normal not showing up in creating project.  Thanks 

Hi, I’m trying to create a current time with =Now() and =NowUTC() for the UK time zone but GI gives me the same result for both functions. system not calculate daylight savings.I ran the GI at 11.40 am local time but GI gave 10.40 am for both =Now() and =NowUTC(). Please help to fix this.Thank you.Desh

Hi Community,I created a custom Acumatica screen, and I wanted to restrict users from deleting records.However, in my custom screen, the Delete action was not listed, so I couldn’t control it through access rights.

Hey everyone! 👋Quick question — what's the exact navigation path to access the tool Customization Project Editor in Acumatica?For context, I need to open and edit my customization projects, manage access rights, generic inquiries, and other project components.Could someone share the step-by-step menu navigation?Thanks in advance! 🙏

Hello Experts, I am unbale to figure out how to view the total number of production order with ageing category. I Tried creating GI but still facing problem how to group .Please let me know where am i missing .So my output result should look like:- 

Dear All,We are following the consigned inventory process in this articlehttps://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-1/ the default setting for the transfer receipt is transferred type 2-step, which means we have to create a Purchase Receipt for that transaction.is it possible to change it to 1-step? It means skip the step creating Purchase Receipt and auto release transferThanks in advance.Yên Chi

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?

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.  

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

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.