Discussion Forums

Hello everyone,I'm working on an Acumatica Report Designer report and need some assistance with displaying an image from Stock Item attachments.Here's my scenario: I have two image files attached to a single Stock Item record in the Acumatica UI (under the Files tab). I want to display only one specific image on my report for each Stock Item. Currently, the image that appears on the report is the last uploaded file (which happens to be a QR code image). The image I want to display is typically the first uploaded file for that item, and it can be identified by its filename: it does NOT contain the word "qrcode". The QR code image, conversely, always contains "qrcode" in its filename.  

I want to introduce a new button inside that Activities panel (next to the Add Task action), and I’d like to do this in a centralized or reusable way rather than customizing each screen individually. Is there a recommended approach for this?these are the parts i wanna customize 

I have several Sales Orders from Shopify that failed to sync >5 times. Now in aborted status. Can’t work out how to sync them manually. I tried moving one Set as Prepared, which returned it to Failed Status. Then tried to Sync it from there. Same error – “The status of the #### order does not allow modifications. Please synchronize records manually.” What is the correct manual method?Gillian  

Hi, Possibility to remove "Restrict visibility to" from particular vendor after creating transactions? Thanks,Prasad

 My reason for asking is we have different size attributes depending on size run. For example SIZESSXL is for Small through X-Large, SIZESS2XL has Small through 2X-Large and so on. If I want to add 2X-Large to a shirt with SIZESSXL, we would change it to SIZESS2XL and create the extra matrix item. This leaves the existing items pointing to the previous size attribute which causes problems all over the place.Is there is a way to point it to the new size attribute?

Hello Community, While exploring the Controller dashboard I tried to modify the Cash Position widget to display the Account Description instead of the Account Code.  I took at look at the underlying GI, CA0002DB, which has the Account Description selected, active, and visible. However, when you view the GI results the Account Description does not appear and it is not available in the Column Configuration window.I have tried removing the field and then adding it but there is no change.What am I missing?  

Hello Guys, I hope can u help me.I want to import the "Type" Constant with a value.   

Hi All,In some instances, we have to move AP invoices to other projects. This is something we were able to do in our old system but cannot seem to do this in Acumatica.For some reason, you can still move the purchase order to another project but the AP invoice does not move meaning the figures are incorrect against the projects.This is mainly for part-billed or closed invoices. Thanks 

Hi everyone,Does anyone know how to make the "Salesperson" field in customer mandatory?I’ve already set the field as required, but unfortunately, it has no effect — I can still save the record without entering a value.    Thanks in advance!

Hi,I need to get a list of unreconciled fixed assets in the system. I tried building a generic inquiry but the system says the data class “GLTranFilter” is not available in the system.Further, I tried running Unreconciled Transactions for the Period report and it gives only transactions which are credited to the Fixed Assets Accrual account. Does not show any assets created manually and not reconciled. Kindly expect your assistance.Thank You,Dulanjana

Hi all,We're on Acumatica 2024 R2 (Build 24.206.0014) and have a scenario we’re unsure how to handle:Use CaseWe need to pay a single AP Bill to multiple vendor payment locations (e.g., 70% via ACH to LOC A, 30% via Check to LOC B).Splitting the bill is not an option – we need to preserve the original bill detail for 1099 reporting and analytics.Questions Is there a native way to pay a single AP Bill to multiple locations? Has anyone implemented or used a custom payment allocator for this? If customization is needed, what’s the best approach ?

Hello everyone,I would like to enter multiple serial numbers at once in the screen Receive and Put Away (PO302020), for example, separated by a semicolon.For instance, if I order 100 pieces of "002092 Testarticle", I don’t want to manually enter each serial number one by one. Instead, I would like to scan or input a barcode that contains all the serial numbers and have them automatically assigned.In my specific example (as shown in the attached images), I ordered 4 pieces, but I still have to input each serial number individually or assign them one by one. I would like to have a way to process all serial numbers at once instead of doing it manually for each item. Hope you can help me. The Receive mode is in use.The scanned quantity exceeds the quantity in the EL00000224 PO receipt for the 002092 item.Confirm receiving 002092 x 1 STÜCK. The following quantity of the item will be added to a receipt line that is not linked to a purchase order: 1 STÜCK. To confirm, click OK.  When I click

I wanted to start T190 Quick Start in Customization course but I’m not able to deploy the instance for it. Here are the steps I did:In Acumatica ERP Configuration Wizard I selected “Deploy a New Acumatica ERP Instance for T-Series Developer Courses” I followed all the steps in the wizard up to the Finish (configuration file is attached) After clicking Finish the Wizard silently crashed Log file is attached as wellI’m able to deploy an empty instance (Deploy a New Acumatica ERP Instance) and also T200, T210 and T210 training instances. Only T190 doesn’t work. What’s wrong?Thanks, Marek

Hello Community,I'm trying to meet a requirement and expect your ideas here.I have a scenario which is the sales order needs to be invoiced to tow customers. Ex : The company sells motor vehicles. The invoices are raised to the end customer and also the leasing company when customer pays a part of the amount and the rest is paid by the leasing company.The credits should be able to follow up (AR Aging)  and checked against both customers. Can you let me know how in Acumatica this is feasible.  Thank you,Dulanjana

I’ve been trying to set up some custom wikis for my team, however, once I leave the wiki and return, or anyone else tries to open the page, the custom wiki doesn’t load and says “Not Found.” I’m the administrator, so I should have access to this, but even I can’t get into it anymore. Any idea of how to fix this? Here’s the wiki details: 

I have a snapshot that I am trying to delete. The Processing popup has been up for over an hour…..How long should this process take?

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 Tara Hodgkins - Acumatica Community Featured Member for July 2025Meet Tara Hodgkins our Acumatica Community Featured Member for July 2025. It’s great to have you as part of the Acumatica Community ​@Tara Hodgkins! SAVE THE DATE: Coffee & Code - Dependency Injection [July 22nd]In this Coffee & Code session, we will be joined by Nicholas Bova (Acumatica) to discuss Dependency Injection. We'll explore how Acumatica developers can use the Autofac framework to manage and resolve their external services. We will also demo a logging service that showcases how the dependency injection design pattern can be used to write more modular and testable code. We hope developers

We’re in the process of setting up our Fixed Assets in Acumatica. When we dispose of an asset, Acumatica posts a debit to our depreciation expense equal to all of the depreciation posted in the current fiscal year and calculates the gain as Proceeds less NBV at the start of the Fiscal year. We’ve set our depreciation method to New Zealand Diminishing Value Evenly by Periods. I wasn’t able to find anything in the literature for that method that would indicate a full reversal of current year depreciation on disposal.I’ve also tested the following scenarios without any change in results:  Page Field Value Scenario 1 FA Preferences Depreciate in Disposal Period FALSE   Dispose Assets Before Disposal Depreciate Scenario 2 FA Preferences Depreciate in Disposal Period FALSE   Dispose Assets Before Disposal Suspend Scenario 3 FA Preferences Depreciate in Disposal Period TRUE   Dispose Assets Before Disposal Depreciate Scenario 4 FA Preferences

We’re trying to create Project time activities via API endpoint   The endpoint is custom, mapped to the Employee Time Activities screen, EP307000.If you try and set the Earning Type to anything other than the default, the system clears the “Project Task” field, and the create/update operation fails.  This can be seen in the UI… if you change the Earning Type column in the grid, the Project Task column is unexpectedly cleared.  In the UI, you can fix it before saving.  With the API, you can’t. Does anybody know a workaround for this apparent bug?

I am trying to create a delete log record if a shipment is deleted after item has been picked and/or packed.  I do not know what event to use that will allow me to save to the table.protected void SOShipLine_RowDeleting(PXCache sender, PXRowDeletingEventArgs e){    var row = (SOShipLine)e.Row;    if (row == null) return;    foreach (SOShipLineSplit split in SelectFrom<SOShipLineSplit>        .Where<SOShipLineSplit.shipmentNbr.IsEqual<PX.Data.BQL.@P.AsString>        .And<SOShipLineSplit.lineNbr.IsEqual<PX.Data.BQL.@P.AsInt>>>        .View.Select(Base, row.ShipmentNbr, row.LineNbr))    {        if (split.PickedQty > 0 || split.PackedQty > 0)        {            MSPSOShipmentDeleteLog newLog = new MSPSOShipmentDeleteLog()            {                OrderType = row.OrigOrderType,                OrderNbr = row.OrigOrderNbr,                LineNbr = row.LineNbr,                SiteID = row.SiteID,                SplitLineNbr = split.SplitLineNbr,         

Hello Everyone, We are looking to start using Incoming Mail Processing to automate web inquiries. We would prefer not having a dedicated email account for this, is it possible to conditionally create a lead based on who the sender of the email is? Aleks

We need your input on this matter. The company has started using the Intercompany process, which is functioning well. However, we are encountering an issue when the sales order is generated from the other company. Here's a sample scenario:Create a Sales Order in ‘Company A’ for ‘Customer X’  - In this scenario Items are not available to ‘Company A’ so a PO will be created to order the items to Company BCreate the Purchase Order from the Sales Order in Company A. In the Vendor select Company B. Purchase Order was generated from Company A to purchase the item to Company B. From here It’s still looks fine.Then next step is to generate the Sales Order to Company B from Company A. (PO Screen > … > Intercompany > Generate Sales Order ). Sales Order is generated then switch companies to Company B.Here is the issue: instead of defaulting to Warehouse 20 for Company B, the sales order is still defaulting to Warehouse 30 for Company A.I've already checked the community, and it was menti

Hi everyone,We are using Acumatica SaaS and don’t have direct access to the production database.We get a .bak file from the portal to restore a copy locally.We can restore that .bak to our local SQL Server — that works fine.  But we want to keep our local DB up to date without restoring the whole .bak each time.Is there a best practice to replicate only new or updated data or  only way is ODATA/API?Please GuideThanks

Anyone know how to prepare a positive pay file to upload to the bank?

For some reason the videos for the T2xx series arent showing up for me in acumatica open university. Are they showing up for anyone else?