Discussion Forums

Hey there! I notice that when I edit a generic inquiry that is a data source for another GI, depending on the number of edits/saves I need to do sometimes the final GI starts to malfunction. Are there “best practices” for when editing a generic inquiry that is a data source for another generic inquiry? 

I tried using @columnConfig({ textAlign: TextAlign.Left }) in ts for my field, but it does not change its position.

I’ve tried it all guys. Deleting browsing data including cookies, restarting my computer, making sure google chrome is up to date BUT when I press the parent activity of this task: I get a blank/new sales order I used to be able to go to the sales order page and go to the sales order from there but I’m still getting a blank new sales order This is happening in payments and applications as well. 

Trying to apply updates V26.101.0225 to 26.100.0175 and receive error message: “The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.”Web.config line causing the error is: “ <compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=4.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:default /nowarn:1659;1699;1701" />”Here is DotNetCompilerPlatform version (Bin folder of the instance) 

I read this post I need fill parameters from POOrder.VendorID and POLine.InventoryID. But RowSelectorClick  event not callback in tracnsaction grid. Can you any idea for help me?

We want to recognize COGS at the same percentage that we recognize project revenue.For example, if 10% of the contract value is billed to the customer, then 10% of the total cost of the parts (stock items) should be  posted to COGS. This ensures that revenue and the associated costs are recognized in the same accounting period, rather than expensing all material costs upfront when they are issued to the project. Note: We have Field service and Project integration- The service order type was created for Project transactions.Has anyone implemented this type of workflow in Acumatica using standard functionality, without a customization? 

Hello all,I have been trying to delete line item from SO Line using import scenario mapping as below where I am using Line Number as the sales order has same items being used in multiple lines, hence making use of Line Nbr to delete them out, however I am unable to delete them:  What is it that i am missing out or making a mistake?

Hello all,I have a scenario where I have a GI with thousands in lines in acumatica and I would like to import those lines on automation basis. So I would like to import 100 lines under one schedule/one go. How can I do so?

Hello all,I have been working on ARM reports where I have defined my start and end fin period as the param, has YTD & PTD as columns.So if I run for a periodic range of Jan-26 till May-26 both the columns show the same values. I am unable to understand if I’m missing something in here?   Any ideas?

I’m getting the below error when trying to Close a Production Order: Error: Updating 'Production Item Split' record raised at least one error. Please review the errors.Specify the quantity greater than 0.    Which screen/section should I review to find the split line with 0 quantity? What is the recommended fix for old production orders where the split record has 0 qty (update split, clear allocation, add a completion, etc.)?

I have two reports that we use in our Acumatica  AR610000 and SO643000.   Both reports are invoices.   Both reports have the inventory item quantity, price etc in detail section1.   The reports also have detail section 2 with line item note and the SO report has detail section 3 with a product attribute.   With a goal of having the body of the invoice more readable, I enabled borders in detailsection 1 in both reports.  However, regardless of the the settings being identical, the AR report shows the borders in the report around each item and the SO report does not populate the borders.  I am stumped.  Here is an image of the control box from the AR report Detail Section1 properties from AR641000  The following is an image of the same properties box from the SO reportDetail section 1 from SO643000Here is the output from AR report AR report showing top dotted line  Here is the output from the SO report SO Report - not showing border 

Client is taking pictures of packages during the shipping process and wants to send those pictures to the customer in the shipment confirmation report.  The link between the Shipment table and the UploadFile table works fine and assume that we are only returning .jpg files.There are two fields of interest in the UploadFile table:  Name and ShortName as they display in a text field.Name field:  Sales Orders (011110) ShortName field:  receipts camera352545645 20260602T203435 522.jpgTo display the image with database as the source, I used the formula: = [UploadFile.Name] + '\\' + [UploadFile.ShortName]The issue is that it errors with:The link ‘Sales Orders (011110)\receipts camera352545645 20260602T203435 522.jpg\receipts camera352545645 20260602T203435 522.jpg’ was not an imageI can’t find anyway to get the ShortName to not repeat.  I’ve tried substring, instr, and left functions.Any ideas?

We are seeing some order are failing with the below errorThe order is missing the ship via code. Please map it with the shipping option in the store settings or specify it on the Customer Locations (AR303020) form. We would like to understand how we can pass the ship via information from shopify to Acumatica. We have all the settings in store mapping as needed but still it is failing. For failed orders we are manually updating the ship via in customer locations and has to sync. can some one help how we can get the ship via information from shopify to Acumatica? currenty the customer created with blank ship via.

Issue Description :-When converting custom screens to the Modern UI, we encounter the following error:Error: The view doesn’t exist.This happens specifically of the custom screens when clicking the Convert to Modern UI action, the system shows the error. Expected Behavior :-Instead of the error, we should be able to download the Modern UI file that corresponds to the respective custom screen.  Thank you in Advance

Hello all,I want to design a P&L based on the item class as in the below screenshot. Now the only thing I am stuck is the . Is there a way we can design the same under ARM report? If not then under my report designer how can I design to include the COGS ? Because i need to calculate cogs based on COGS account class. 

Hi everyone, I am working on a report to display the monthly General & Administrative Expenses. I was able to create the report, but it runs into an error whenever I try to run the 13th period. I tried to research why this is happening and found out that it’s because of the formulas I used to display the column headers. However, I can’t find an alternative or a solution for it. Could anyone have any idea about this? I have attached the XML file for the report. 

Hi Everyone,When attempting to use the Mass Action from the Sales Order Generic Inquiry (GI) screen to print multiple Sales Orders, the system generates the report for only a single Sales Order, even though multiple records have been selected.Could you please advise if this is expected behavior or if there is any additional configuration or customization required to enable printing multiple Sales Orders in a single operation?Thank you. 

Is there a way to restrict what subaccounts can be used based on the account class?  We use subaccounts for departmental classification.  Like many companies, we do not departmentalize our balance sheet and use 000-000 as our balance sheet class.  With that, we do not want any departmental subacounts used on balance sheet accounts and likewise, we do not want the Balance Sheet 000-000 designation used on any P&L accounts.  We have to clean this up every month because mistakes will be made.

Customer does not have the Deferred Revenue module.Does anyone know of a way to accomplish the following scenario:Invoice customer for sold item and install is also invoice up front. The install credits a deferred revenue account rather than revenue When the install is complete, via a Field Service invoice, we need to debit the deferred revenue account and credit revenue- therefore recognizing the revenue when the service is comlete.Thank you for any input you can provide.

I’ve been asked to provide a sidepanel on a few screens that will display the Remit To address of the vendor on the current screen.  That part is pretty easy and I’ve already provided that to the users.But the sidepanel is displaying the results of a GI (the Sidepanel technically points to a Dashboard that has a Data Table widget on it that displays the GI results).  The results are displayed horizontally, and since it’s displaying 5 fields, the results are kinda squished.  I’d love to display the results vertically, like:Addr 1: 123 Main StreetAddr 2: Box 17City:  AnytownState: PAPostal Code: 12345I’ve tried a pivot table but that’s not really what pivot tables are designed for.The only solution I can think of is developing a custom form screen and tying the sidepanel to that.  That kind of form screen is pretty simple...but I feel like I’m going down a rabbit hole for something that doesn’t justify that much work.

Customer is asking to export various Acumatica entities to Salesforce using the Acumatica Data Provider.  Working with Acumatica support, we were led to believe that it was possible and that you could define the Salesforce schema objects in the data provider based on the exposed Salesforce API.  I thought we would start their first request.  Map Customers to Salesforce Accounts.  The Salesforce data provider is connected and the fill schema fields works.  The customer is using the modern UI.I created a new Export Scenario for Customers to Accounts.  On most of my initial attempts to update a single account, I kept getting an error that multiple accounts found where account = ‘’.  When I added a mapping for the Acumatica customer number to export to the Account ID field, I received the error filter error: select id from account where accountID = ‘0000002’.  Then I put the Salesforce account ID in the External Reference field of the customer and now I get The ID field should not be speci

We have a custom report used to review outstanding customer deposits. After our recent Acumatica upgrade from 24R1 to 26R1, the report began returning different results depending on the user running it.When I run the report as an administrator, the report displays the full data set correctly, including 2025 and 2026 activity. However, when our Controller runs the same report with the same parameters, the report only appears to show data from 2024 and prior. Any 2025/2026 activity is missing from his output.I initially suspected this was a security/access issue, but I have not been able to identify the cause. I checked user roles, GL access, and report access, and I also temporarily gave the Controller Administrator rights. Even with Administrator rights, the report still behaved the same way for him.A few additional notes:The issue started only after the upgrade from 24R1 to 26R1. The report is custom and is based on GLTran data. The Controller can see 2025/2026 transactions in Account

When trying to upload using mobile app, or having a business event trigger a push notification we are seeing No access token returned invalid_scopeHere are the errors:When uploading using mobileThis all started after upgrading to 2023 R2.  Currently on 23.201.0092.

Are there any implementation/training documents in Acumatica’s open university for inventory planning? I can’t seem to find it :) 

I have followed all the proper steps to set up the Outlook Plugin for Accumatica. I am able to click the add in and have it pull the name and contact from the email properly. I then want to log that email as an activity and I am able to do that properly. Once I am taken to the next page of the add in, I select the entity in which I want the email to be linked to. I then click “create” and then it loads for a second then I am taken back to the initial Log Activity screen. I check my accumatica and the email has not been uploaded. I am unsure of where the issue is occurring and I have checked that I have all of the proper permissions.