Discussion Forums

Hi there! 👋 I’m Dipak Nilkanth, an Acumatica Developer at Tayana Solutions, passionate about building powerful solutions within the Acumatica ecosystem. With over four years of experience, I’ve had the incredible opportunity to explore, learn, and contribute to this ever-evolving platform.My journey with Acumatica has been nothing short of exciting—diving into customizations, solving complex problems, and engaging with the vibrant Acumatica Community. One of the best parts of this experience is connecting with fellow developers and experts, sharing insights, and continuously pushing the boundaries of what’s possible with Acumatica.Why I Love Being Part of the Acumatica Community 💙The Acumatica Community isn’t just a platform—it’s a powerhouse of knowledge and collaboration. From troubleshooting intricate workflows to sharing innovative solutions, I’ve gained so much from being an active member. Helping others while learning from their experiences has shaped

We have English and Chinese System Locales set up. Users are reporting randomly that the Sales Order Status is showing as Chinese characters while everything else is English. Is there any way to detect how or why this would happen? I’m wondering if this is user initiated somehow. Every time I investigate, the Sales Order Status is back to English...  

Is there a simple way I can display the default vendor remit-to address to show on the bills and payments screen?  I’ve checked and the RemittanceAddress view does not appear in the Data View dropdown under Add Data Fields tab in screen editor. 

Customer is wondering if there is a way to pull mileage information automatically from Google Maps from a customer address to pull onto an expense report.Acumatica Support is not aware of a way to do this but suggested I post here in case anyone created something to do this.Customer came from Concur where this was possible.

Hi! Sometimes in a report when I try to preview it, I’ll just get a blank data or a blank page, and other reports I’ll get data. Sometimes when I make a new report, my sub reports will show up, and sometimes they wont. The only consistent thing is that expressions mess up, but text still displayshelp!

Hi, All. I am trying to upgrade my 2022 R2 to 2024R2. I am aware that direct increment is not possible so I upgraded my instance to 2023R2 23.220.0007 but when i try from this to my 2024R2 it says Upgrade process has been interrupted. The database cannot be upgraded because your current build (23.220.0007) is incompatible with the build (24.207.0011) you want to install. Wait for the next update package that will be compatible with your current build. what should I do in this case? should i go with 2024 R1 first? DO i need to validate and publish customization packages before upgrading to 2024 R2?Thanks

Hi all.How do we change the default status of an AP Bill that was created from an Expense Claim? When we release an expense claim, the AP bill is automatically balanced. We want the AP Bill of an Expense Claim to be put on hold first for some reason. Thank you in advance.

Does anyone know of a way to have the AP Bills automatically Release when collecting the final approval? Our AP currently has to take an additional step to release all documents since they all just go into the Balanced status rather than Open when all approvals are complete.

Our employees that have basic access only to purchase requests are getting the following error when clicking “Print Request” on their request screen. Which access rights do I need to enable so they have the correct permissions? 

Hello Community, I was looking for a way to default the shipment quantity to 0 when creating the “Create Shipment” button on Sales Order or from the Process Orders screen. I thought I could just extend the “CreateShipment” method to accomplish this but not having much luck. See below for the code I have. Is there possibly a setting in Acumatica for this I missed or an issue with the code below? public delegate void CreateShipmentDelegate(CreateShipmentArgs args); [PXOverride] public void CreateShipment(CreateShipmentArgs args, CreateShipmentDelegate baseMethod) { // Call the original method to ensure default behavior baseMethod(args); Base.Transactions.Current.BaseQty = 0; Base.Transactions.Current.Qty = 0; Base.Transactions.Current.ShippedQty = 0; Base.Transactions.Current.BaseShippedQty = 0;

Hello,We have a custom PO form that was printing properly.  After an upgrade to 24R2, is prints smaller and does not use the entire page.  There are other reports doing this, I’m just using the PO as an example.  I opened and saved to server using the new 24R2 report designer without making any changes, but that made no difference.Wondering if anyone else has experienced this.Thanks,Larry

Hello! I am trying to get my user defined fields (attributes) on business accounts to copy over to the opportunity when an opportunity is created. Any ideas on how to make this happen? Thanks in advance :)

Hi,Our all customer sites are not accessible now. Server seems to be down. I have no notifications on version upgrades today. Is there any issue going on? 

its duplicating the ordernbrso how can i join the SOOrder and SOline, and make it pull from both side 

Our company uses LIFO accounting, which is generally only used in the United States, however it is GAAP compliant.I am just curious if there is any interest out there for a LIFO accounting module in Acumatica? We will probably write some software to calculate the LIFO reserve for our own purposes. We use dollar value LIFO. Thanks, Jonathan

Unable to open the report designer for a only for specific URL. I’m trying to do this in a upgrade sandbox and facing this issue. Even I have reportdesigner access in the access rights.  

All Transactions in the Move has Labor code assigned in the Work Center . what will the reason for not allowing to release 

Are Commercial Transaction counted across all Tenants including “test” tenants ?Are ERP Transactions counted across all Tenants including “test” tenants ?  

I successfully created a data provider for an external SQL database and can retrieve data using an import scenario. However, I’m struggling to build a Generic Inquiry (GI) that combines data from both the external database and Acumatica tables.My goal is to create a GI that pulls accounts on hold from our external production management system and compares them to the same account numbers in Acumatica. This would help our accounting team identify which accounts need to be placed on hold in Acumatica—an initial step toward future automation.Given that import scenarios can access external data, I would expect this to be a straightforward task. Any guidance on how to achieve this would be greatly appreciated.Thanks in advance!

Hello, I am getting this error message when logging onto the system. May you kindly assist? Thanks 

Hello. I would like the below report formatted like the one below it. The last picture is an export of the aged report modified in excel which requires some effort. If we can have the original report look like it then from the get-go, then that would be a great help.Basically, all accounts are listed under one heading instead of the heading being repeated for each customer. Modified report in Excel.  

Hi! I have an attribute that is using the EPEmployee Owner ID field. The schema field does not have an option to select owner description. This attribute is being used in business account, when selecting on the business account record, the owner name displays, example is Device Hub here: But in the generic inquiry, the attribute field is only pulling the ownerID number and not the name: Is there a way to link the employee owner ID to the owner name so the GI display the actual name not numbers?Thanks!

We went live with Field Service in July 2024.  The ONE thing we are struggling with is the requirement to add purchase order items as quickly as they are needed. If our guys are at the hardware store buying a variety of nuts and bolts, it is cumbersome to enter these details at the time of purchase for the techs in the field on their iPads or the people in the office.  In our former software (Sage 300 - and yes, we know it is antiquated), but we could have a blank Purchase Order and fill in the purchases later.  At the very lease, a blank purchase order alerted us that we have an vendor purchase against the appointment. Because of this limitation, we are not using purchase orders at all.  Have any of you figured out how to enter a blank Purchase Order in Acumatica?

I am trying to filter my API response to only make a get request of records from an endpoint of records that have to be greater than a specific date. I have tried to look at the documentation but unfortunately it does not contain any page on the documentation to give knowledge or show how this is done. When I add the filter parameters I get an error message as shown below : The error message is caused when I try to invoke the following endpoint also containing the filters required : {{endpoint_url}}ProjectBudget?$filter=LastModifiedDateTime_value gt datetimeoffset'11/10/2024 12:00:00 AM'​​​​​​​The endpoint URL is the specific company URL required to access the endpoints of the specific companyI require some assistance in being able to get past the error message so I can comfortably ingest da

For one of our projects, we set a single value to be selected from a box. However the box is still defaulting to one of the old value that we removed. I’m trying to have it default to the constant defined below, but everything I’ve tried either hasn’t worked or crashed the customization. Any way to set a default value for this box?public class custClass : PX.Data.BQL.BqlString.Constant<custClass>{ public custClass() : base("SB") { }}[PXDBString(2, IsKey = true, IsFixed = true, InputMask=">aa")][PXDefault(SOOrderTypeConstants.SalesOrder, typeof(SOSetup.defaultOrderType))] [PXSelector(typeof(Search2<SOOrderType.orderType, InnerJoin<SOOrderTypeOperation, On2<SOOrderTypeOperation.FK.OrderType, And<SOOrderTypeOperation.operation, Equal<SOOrderType.defaultOperation>>>>, Where<FeatureInstalled<FeaturesSet.inventory>.Or<SOOrderType.