Discussion Forums

Hi Acumatica Community,I'm working on a customization in Acumatica 24R2 (sandbox) where I want to show a confirmation dialog box before the "Remove Hold" action is executed on the Sales Order Invoice (ARInvoiceEntry) screen.I’ve overridden the ReleaseFromHold method and added a dialog box like this:Public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter);[PXOverride]public IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod){ ARInvoice doc = Base.Document.Current; if (doc != null) { // Show confirmation dialog if (Base.Document.Ask("Confirm Freight Surchage, "Please confirm the Freight Surcharge Amount before proceeding. Do you want to continue?", MessageButtons.YesNo) == WebDialogResult.No) { return adapter.Get(); // Expected to cancel the action } PXTrace.WriteInformation("After confirmation check."); } // Proceed with the original Remove Hold logic return

Hi,After 2024R2 upgrade we are getting custom report error Cannot resolve the table name :[PX.Objects.Localizations.CA.CS.UnitOfMeasureI have read and followed some other suggestions about resolving these kinds of report issues but the issue has not resolved. Quick summary of what was attempted: removed UnitOfMeasure table from build schema, reloaded schema, and then add it back inWe do not have Canadian Localization enabled on the Enable/Disable form. Multiple reports are affected but, am specifically working on the invoice report, ar641000.rpx, which holds our custom report not the localization report, ar641000.ca.rpx

Using 24R2.  I have a purchasing group who emails their POs to vendors via a Purchasing email account in Acumatica.  The purchasing group does not want the sales team to be able to open the purchasing emails.  The sales uses a different email account to send sales related emails.  The sales team does have view only access to vendor records.I’ve tried row level security to no avail.  If I could control (automatically) access to attachments, that would work, but it seems the access permissions are propagating from the email activity screen.Ideas?

I know that there’s a plugin that does something similar, but is there a way within base Acumatica to record when customers open emails?

I have a client that wants to email several reports at month-end.  They have a schedule setup and have added the reports to the schedule.How do you indicate you need the parameters to change each month.  For instance, several have a financial period parameter.  I don’t see in the schedule where you can mark these as “Relative” like you can in other automation schedules.

Hi All. I am trying to get BI Ar-Invoices data into Power BI using query filter by invoice date. But on querying it shows me either authentication error (even i am admin) or some time   My query is :https://local.acumatica.com/odata/BI-ARInvoices?$filter=InvoiceDate ge datetime'2025-04-03T00:00:00'Do I need to run the query in Postman and then import that data into Power BI? Please suggest a better approach Thanks

New to Acumatica and have been using Project Quotes since January. Google Chrome is our browser, users are experiencing the following error throughout the day and randomly. Does anyone have any insight on this error and how to remedy ? It is not related to the timeout setting in the UI / Security. 

Does anyone know if there are efforts to create an Authorize.net module that is community supported? The depreciation of this module seems like a may have an adverse affect on many businesses. If anyone is developing an alternative module I would like to assist.  Thanks,   

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 Samvel Petrosov - Acumatica Community Featured Member for April 2025Meet Samvel Petrosov our Acumatica Community Featured Member for April 2025. It’s great to have you as part of the Acumatica Community ​​@Samvel Petrosov! Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumatica User Group, NorCal Acumatica User Group Request to join today!Upcoming meetup! NE Acumatica User Group Meetup – May 6th, 10:30am-2:00pm ET Note - You need to be a member of the group in order to access/RSVP. If not a member, go to the  NE Acumatica User Group site, Request to Join, once approved, RSVP there to the event.Upcoming meetup! SAVE THE DATE: SE Acumatica

Hello,I see a couple posts that reference my issue but they are not clear, and the help is a bit murky too.  I’d like to get some community thoughts.  Here are the 2 threads that hit on my issue:  What I’m experiencing in 24R2: IF the posting class is supposed to be what drives the GL Accounts, the Order Type Posting Setting seems to override posting classes, essentially making the posting class not viable, because there is no way to “NOT” select a value for this drop down:  as an example, if I have the standard SO Order Type as ABOVE, this setting is set to use ‘posting class’ for sales account.If I create an SO add 2 linesA stock item that has a posting class that uses the “posting class” for sales (therefore the GL account is populated) it will derive the correct Sales Account.   See below - AACOMPUT01 A non-stock item that has a posting class that uses the “inventory item” for sales (therefore the GL Account on the posting class is NULL).   It will NOT place a sales account on the

I have a GI for shipment tracking report created and hoping to add Invoice Number & Unpaid balance.Unfortuantely I cannot figure out how to get the field to populate due to the relations. “invoiceNbr” field cannot be used because the table to ARInvoice alias is not joined with other tables on the Relations tab.The same applies for CuryUnpaidBalance.Hoping I could get some guidance on how to operate the relations tab. I have tried to navigate through the DAC Schema but I am not getting the correct options. Thanks 

Is there a way to extend the Set Qty state logic in Scan and Transfer screen? The class is sealed and not able to do so. I would like to define my own custom logic in certain cases. Basically we are developing a putaway mechanism inside Scan and Transfer. I am defaulting an origin location for putaway using another button and then they are able to select destination location and the entire available qty should be defaulted. They also need to be able to change the defaulted qty using Set Qty and that is where the problem comes in. The qty just keeps appending to existing one.I have tried combination of RowInserted and RowUpdating events to force the qty in case of putaway mode and nothing worked so far.An example of what I have tried so far: public class CFINScanTransferExt : PXGraphExtension<INScanTransfer, INScanTransfer.Host> { public static bool IsActive() => true; public INScanTransfer Basis => Base1; protected virtual void _(Events

Hi Everyone,I have added a barcode field to the PO screen. The functionality is working fine, but I am facing an issue where, whenever I scan a product for the first time, the OrderQty is automatically set to 2. When I scan the same product again, the OrderQty increases to 3 which is correct .But i for the first time it should be 1 not 2.However, for a different product, the OrderQty is correctly set to 1 on the first scan. I have attempted to resolve this issue but have not been successful yet.Please guide me on how to fix this.Thanks!Code:// Check if a POLine for this InventoryID already exists            POLine existingLine = Base.Transactions                .Select()                .RowCast<POLine>()                .FirstOrDefault(l => l.InventoryID == item.InventoryID);            if (existingLine != null)            {                PXTrace.WriteInformation($"Existing Line Found: {existingLine.InventoryID}, Current Qty: {existingLine.OrderQty}");                // If fir

I have a grid where I have sales orders and service orders in the same field. I want to make this a hyperlink, so I used the callback command and a custom redirect action. That works and redirects properly, but it pulls the data from the first row instead of the one currently selected. I’ve tried the SyncPosition = true and making sure the dac has a key field, but to no avail. Would anyone be able to help me out? Thanks. <CallbackCommands> <px:PXDSCallbackCommand CommitChanges="True" Name="ViewDocument" Visible="False" DependOnGrid="Details" ></px:PXDSCallbackCommand></CallbackCommands>.....<px:PXTabItem Text="Details"> <Template> <px:PXGrid SyncPosition="True" Height="100%" Width="100%" AutoAdjustColumns="True" runat="server" ID="Details" SkinID="Inquire" AllowPaging="False"> <Levels> <px:PXGridLevel DataMember="Details"> <Columns> <px:PXGridColumn

Hello all,I am looking for ways to reverse the sign for some of the row sets in ARM. For eg: in cash flow statement the AR A/c displays the correct figure but in negative manner. Thats not smooth for the end user whenever they see this negative figure. So how can I reverse it to positive figure? What shall I follow in Row Set or Column set?

hello all,i am curious to know why does, for eg, the AR a/c display a negative figure in the cash flow statement whilst it is positive in reality : Doesnt it should display in positive? since its an increase?

Why the system would force a refresh on order type change. Order types are used for a classification. In this case, the order is already new and no information has been entered, so changing the Order type field itself does not need to create a brand new record because there has been no action taken on the existing record. 

Hi,Client have updated the Acumatica Non-stock Item master weights for some ittems (They are only doing the Drop-Shipping) and seeking a solution to update the weights in some documents (Ex: Sales Orders, etc) which are created before the weight update. Someone kindly advise in this regard. 

Meet Samvel Petrosov our Acumatica Community Featured Member for April 2025. It’s great to have you as part of the Acumatica Community ​​@Samvel Petrosov!Hi everyone! I’m Samvel Petrosov, Senior Analyst at Information Integration Group, Inc. I have been with IIG for almost 10 years now. I started as a developer and got recognized as developer MVP since 2019. Currently, I still have some development projects, but most of the time I am working on system implementations and custom solutions design.I enjoy solving complicated cases and finding solutions to everyday challenges coming with the variety of projects.On a more personal note, I live in Glendale, CA with my wife and our frenchie “Lady”.I enjoy playing chess and recently started looking into golf.We love traveling and recently came back from Cairo, Egypt. 

How can we setup a different description that would appear on customer-facing forms (sales orders, invoices, etc.)? We have some stock items that have slightly different configurations but we would like them to have the same description on a SO or invoice. We do however need the additional detail for our team to be able to differentiate which stock item we are putting on the transaction. 

I am trying to create process for users here to use Activity Tasks for order/quote follow up.  I keep getting an error stating  Custom Week cannot be found. Custom Week's must be generated with date greater than 4/24/2025.  What am I doing wrong? 

HI, I am trying to add total of each colum at the end of the report. But report is just populating 0 instead of sum of all values. Can any one give me idea on how to add it? I use variable of total end qty. But its nor working. Even its repeating again and again for every row. I have attached the report 

Hi,I've been using Acumatica for a year, and I still don't understand if the system will look for the .rpx or .ca.rpx report, or a mixture of the two. The sitemap always points to the .rpx but I see that "often" I have to make my changes on the .ca.rpx in order to see them.In the actual case I want to modify the report from site map AR64100 which point in the sitemap on ~/Frames/ReportLauncher.aspx?ID=AR641000.rpx so logically, i need to customize the .RPX but it seems to use .CA.RPX . I’m confused.I found very little documentation on this topic.Can anyone explain to me how it works?THANKS

Hello,Is there a way to have the production order you create via the MRP display screen automatically linked to the sales order creating the demand?Or is it required that you manually create the linkage?Thanks,Larry

i did a customization to my training tenant.  but after publish it,some how it looks like it have affect our live tenant.how do i resolve this