Solved

We have an import scenario that we have built that we want to import Sales Orders on a daily basis. We want to schedule the Import Scenario so that on weekends and public holidays it will process the updated file without intervention.The file is overwritten on a daily basis by an external process. I have tried using the “Link to existing file” option as well as editing the URL. I have been using my C Drive as well as a link to a Dropbox file. I have tried every option, but it seems to load the historic contents and not look at the updated file. Has anyone got any suggestions of what is needed?

Is it possible to link a Sales order line item to multiple  Drop ship Purchase orders  

Hello! I want to create Purchase Orders by using “Mark for PO” function on the Sales Order form. But I do not need to create Purchase Orders for the full quantity mentioned in the line but a less quantity.  Is there any way of doing this? 

We just upgraded to 24R2 and are having issues trying to create a compliance line for insurance under the customer. This has never been an issue before. When trying to save the following warning is given:This is directly under the customer record and there are no other compliance lines listed for this customer. Has anyone else run into this and how did you fix it? Thanks!

Hello - I received a request to add Vendor InvoiceNbr to the Purchase Order screen under the PO History tab but am not seeing this field as an option. Is there another way to go about getting this added?  

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. 

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?

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. 

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. 

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