Discussion Forums

Can anyone tell me where I can find a description of the json objects for importing data via api?

Can we add columns (user and date file upload) to attach files form? 

Hi everyone,I’m trying to customize SOLine.AlternateID, but the original Acumatica logic is interfering with my functionality. Specifically, I need to remove the AlternativeItemAttribute from SOLine.AlternateID.Here’s what I tried so far: #region AlternateID [PXMergeAttributes(Method = MergeMethod.Merge)] [PXRemoveBaseAttribute(typeof(AlternativeItemAttribute))] [PXDBDefault(null, PersistingCheck = PXPersistingCheck.Nothing)] [BZAlternativeItemAttribute(INPrimaryAlternateType.CPN, typeof(SOLine.inventoryID), typeof(SOLine.subItemID), typeof(SOLine.uOM))] protected virtual void SOLine_AlternateID_CacheAttached(PXCache sender) { } #endregionHowever, this doesn’t seem to remove the attribute completely. Has anyone successfully removed or replaced the AlternativeItemAttribute from AlternateID? Any guidance or best practices would be greatly appreciated.

public override void Initialize() { base.Initialize(); PXCache cacheBase = Base.Caches[typeof(INLotSerialStatusByCostCenter)]; cacheBase.Interceptor = new BZAccumulatorAttribute(); }public class BZAccumulatorAttribute : PX.Objects.IN.InventoryRelease.Accumulators.QtyAllocated.LotSerialStatusByCostCenter.AccumulatorAttribute{ public BZAccumulatorAttribute() : base() { _SingleRecord = true; } protected override bool PrepareInsert(PXCache cache, object row, PXAccumulatorCollection columns) { bool ret = base.PrepareInsert(cache, row, columns); SiteStatusByCostCenter siteStatusByCostCenter = (SiteStatusByCostCenter)row; InventoryItem item = InventoryItem.PK.Find(cache.Graph, siteStatusByCostCenter.InventoryID); if (item != null) { BZInventoryItemExt itemExt = item.GetExtension<BZInventoryItemExt>(); if (siteStatusByCostCenter.SkipQtyValidation != true && siteStatusByCostCenter.ValidateH

Hi everyone,I am currently working on improving our CI/CD pipeline for our Acumatica customizations. My Idea is to automate the synchronization between our Acumatica environments and our Git repositories.Right now, if a developer makes a UI modification directly through the Customization Project Editor (e.g., modifying an ASPX page layout), they must manually click the "Save Project to Folder" button to generate the granular XML files (like ProjectMetadata.xml, ScreenWithRights_FRXXXXX.xml, etc.) into the _project folder for Source Control.I tried using the official CustomizationApi/getProject REST endpoint, but I noticed it doesn't behave like "Save Project to Folder". Instead, it downloads the compiled .zip package (containing a screens/ directory instead of the _project directory), which isn't useful for Git versioning.My question is there an undocumented API endpoint, a C# Customization Plugin approach, or an Acumatica CLI command (like ACU) that can programmatically trigger the ex

Hello everyone!We’re new to 2025R2 and currently testing in our sandbox. Of course being a Construction client and having been to Summit we’re excited about all of the new bells and whistles, most importantly we are looking forward to the Construction 360 Dashboard. Much to our dismay, we ran into a “lot of zeroes” after turning on the Modern UI and trying it out. However, we learned that most of the information can be populated through the Cost Projections By Date, and now have 13 out of the 15 columns populated with stats. This of course leads me to a few questions which I hope the community can help with:For setup purposes, does every Construction customer have to run the ‘Cost Projections By Date’ report each and every time they want to see updated stats? If that is the case, have you just created a Business Event to run this for all of your projects? (We currently have 43 active projects) And if so, do you run your Business Event to update on a daily, weekly or monthly basis? Even

Hi everyone,I am currently setting up multiple Email Accounts (Exchange Online SMTP/IMAP/POP3) for a client in Acumatica 2025 R1.I have noticed a significant change in how the system handles External Applications (SM206540). When I create an External Application and link it to my first Email Account, that specific External Application completely disappears from the selector when I try to configure the second Email Account.It appears the system is now enforcing a strict 1:1 relationship between an Email Account and an External Application. In previous versions, it was standard practice to use a single Azure AD App Registration (i.e., one External Application record in Acumatica) to authenticate multiple mailboxes under the same tenant.My Questions: Is this strict 1:1 mapping an intended security design change in 2025 R1, or is it a known bug? If this is the intended behavior, what is the recommended best practice for setting up 20+ email accounts? Creating 20 separate External Applica

The client has a large number of non stock kits with stock components. They require allocation before the shipment is created. I was wondering if this was a setting in Acumatica itself, or if it requires customization to achieve.

This is what I’ve been able to build but I want to make section that gives me a final number of how many I can build. Not have it show me what the lowest number in stock that I have. I want to see a section that says I can only build 6. 

We gave a pay advance to an employee and set the deduction limit to $160. He had 2 paychecks of $80 each but then it didn't stop it still pulled another $80 out on the next paycheck. Can anyone tell me what I am doing wrong? The deduction limit frequency is set to No maximum.

When importing a Shopify Sales order, I would like the item description to be transferred to the sales order item that corresponds to the language stored in the customer. A corresponding translation for the item description is available.If you enter a sales order manually, it works, but not when importing.Does anyone know if and how this can work?Thanks in advance.

How can you see what the Project Accountant role actually provides access to?We would like to allow some users to use the ‘Reclassify Bill’ feature in AP, without giving them the ability to post costs to closed Projects.

Our process is Engineering creates BOM, Production Planning creates the Production Order under the Project, and the BOM is linked to the Production Order to generate material demand. Purchasing then procures material based on that demand.Our challenge is with ECO driven BOM revisions. If the Production order is still in Planning status, we can update the order with the new BOM revision and regenerate the demand successfully. However, after the Production Order is Released and material has been Issued, the status moves to In-Process, and we are no longer able to update the Production Order with the latest BOM revision.In this situation, the only option we currently see is to reverse the material issues, delete the existing Production Order, recreate a new Production order with the updated BOM revision, and then proceed again. This is operationally heavy and inefficient.I would like to know whether Acumatica provides any standard functionality, recommended process, or best practice for h

Hello, We have created a rather large report. One column is for AR Margin Percent. This shows as a standard 2 digit number in Acumatica (no % sign). When we export into Excel, then format to a percentage, the number grows by 1000. Example 33 would equal 3300%. I know how to correct this in Excel, but seeing as we pull this report often, then the adjustment can become very time consuming. I would like to correct the GI in Acumatica so I do not have to correct it in Excel. Any ideas how to accomplish this? Below is a screenshot of the formula in the GI:  

Invoice, click print.  There is a green email button.  For some users it is greyed out.  Where is the security setting for that button?

Hello, I have a user that needs access to the Side Bar in Sales orders. See Here. She needs access to the ‘Invoices and Memos’ button. I was pretty sure they were run by GIs but I’ve given permissions to the invoices one and that didn’t help. Any ideas?Thanks!

In Modern UI Trying to save a new card in the Sales Order with the Prepament option. But card entering option is non editable. Does anyone experienced this issue.  

We are building a remittance automation tool that needs to create an AR Payment and apply it to multiple invoices (1,300+ lines) via the REST API in Acumatica 25.200.001.What we've tried:PUT to /entity/Default/25.200.001/Payment with DocumentsToApply array containing AdjdDocType, AdjdRefNbr, and CuryAdjgAmt — returns HTTP 200 and updates LastModifiedDateTime but AppliedToDocuments stays 0. Documents are not applied. Import Scenario via the UI with a CSV provider mapping to the Payments and Applications screen (AR302000) — fails with "The system failed to commit the Adjustments row." Screen-based API POST to AR302000 — modern Acumatica 25.x loads the screen via JavaScript so DataSourceSessionID and DataSourceLoginID are not present in the initial HTML response. REST API /entity/Default/25.200.001/ImportScenario — returns 404, endpoint does not exist.Question:What is the correct method to programmatically create an AR Payment and apply it to multiple invoices in version 25.200.001? Is th

Hello Acumatica Community!I’m Mike the product manager for Acumatica WMS. We’d like to explore some aspects of returns with serialized items as we continue to improve our product.How do you handle vendor returns for serial-tracked items?We're exploring how customers manage vendor returns when serial numbers are involved, and we'd love to hear about your real-world experience!Specifically, we're curious which approach your team uses when processing a return:Pre-select the serial numbers — You identify and enter the specific serial numbers directly in the return before warehouse picking begins, so the warehouse team knows exactly which units to pull. Select item and quantity first — You enter the item and quantity on the return, let the warehouse team pick freely, and then record the actual serial numbers afterward based on what was physically pulled.We're also interested in whether you've run into any situations where a serial number was entered on a vendor return that wasn't actually r

Hi Acumatica CommunityI created a Sales Order (TR) and Transfer Shipments.to Process Shipments, I used Pick, Pack and Ship functionality.But when I tried to receive this using Receive and Put away. I didn’t find what process do I need to scan.Do we have a documentation for this process?Thank you!

Hello,I am trying to process application in Acumatica to create invoice. I used Resource Owner Password to generate the tokenHTTPPOST<Acumatica ERP Instance URL>/identity/connect/tokenvar request = new HttpRequestMessage(HttpMethod.Post, configuration["Acumatica:TokenUrl"]);var collection = new List<KeyValuePair<string, string>>{ new("grant_type", "password"), new("client_id", configuration["Acumatica:ClientId"]), new("client_secret", configuration["Acumatica:ClientSecret"]), new("username", configuration["Acumatica:Username"]), new("password", configuration["Acumatica:Password"]), new("scope", configuration["Acumatica:scope"])};var content = new FormUrlEncodedContent(collection);request.Content = content;var response = await client.SendAsync(request);response.EnsureSuccessStatusCode();I am getting error API Login Limitfor the first time call. any help would be appreciated. 

How to override Receipt Nbr in adjustment for stock without receipt 

Are dialog box workflow actions supposed to be unavailable to an import scenario? I was hoping to automate a field update the field/dialog box via import scenario, but the action is unavailable in the import scenario. Workflow actions usually show up in an import scenario, so I was surprised to see this limitation.  

Hello, I was wondering if Acumatica had an email response time tracking feature where we could pull data on how quickly customer service reps our emailing clients. The system it would tie into is outlook. Does anyone know if Acumatica has a feature like this?

General Information:Microsoft has announced the end of support for their Bing Maps tool on June 30, 2025. If you currently have a Bing Map Key, it will continue working until June 2025. Microsoft has discontinued issuing Bing Map Keys to new users as of July 1, 2024. Microsoft recommends Bing Map users register to use the Azure Map tool.Issue:Acumatica Field Services supports Bing Maps in our various map views tied to the calendar.  These include Appointment History on Map, Staff Appointments on Map, Routes on Map and Staff Routes on Map.Acumatica introduced support for Azure Maps in the 2023R2 update 17 release, which was made available for customers in October 2024. This support will cascade into 2024R1 update 14 and 2024R2 update 3 per our normal development roll-up process, so by the end of the year, 2024R1 and 2024R2 versions will include support for Azure Maps.Solution:Steps for Field Service customers who want to use Azure Maps:The company using Acumatica must go to https://port