Discussion Forums

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?

I have 2 quantities ordered on my PO but the system is not allowing me to receive items due to error saying “The purchase order does not contain any items to be received.”

Hello!I have a scenario where a user has requested a few reports (2 templates of the same report to be more specific) be automated to send weekly on Monday mornings. These templates have a Start and End Date parameter that need to be set to reflect data from the previous week.Playing around with the updated template scheduling in 2025 R1, I can’t seem to find a way to have those dates be dynamic (i.e. Today and Today-7). Is there a “proper” way to set a date field to not be a static date in the email template?

Hello,im a bit lost here as im trying to achieve the following: Im trying to set the “RequestDate” in the sales orders as a non required field. I tried to do it with setting the “requird” collumn to false, but im afraid i dont have the “false” option to choose from: Can you help me, which option i should choose or tell me if its even possible with this particular field?Thanks for your help.Best regards

I am trying to put my instance in Maintenance mode via REST API, as we are publishing Customization Projects VIA REST APIs, but cannot find anything on how to put instance in Lockout or Maintenance Mode ..

In Acumatica we sell stock and matrix stock items on two Shopify stores - D2C and Wholesale. We have both stores connected to Acumatica. The two Shopify stores share the same Stock items and Inventory, but we don’t sell the same items on both stores.In Acumatica, each item has an attribute that defines if it’s sold on the D2C Only, Wholesale Only, or Both stores.Using the Entity mapping per store, we’ve been able to accomplish restricting stock items (not matrix) from passing to one store or the other using a statement: IF Shopify Stores Is D2C Only or Both. This prevents Wholesale Only items from going to the D2C store.The issue is that we haven’t been able to do the same with matrix items.These attributes are mapped at the stock item level, not at the matrix template level. We tried applying the same logic at the matrix template level, but it simply removes the entire matrix template item from syncing.It seems that when the eCommerce connector for Acumatica pushes a matrix template i