Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
I have custom fields on Sales order header. I want the fields active and mandatory only when order type is “XR”. Please assist how i can achieve that in Acumatica customization. The fields will be invisible if order type is any other
I am trying to filter out/hide a location id in the selector for the Inventory Summary screen. Any ideas on this would be appreciated. Thanks in advance!
I made some changes to the Print Sales Orders (SO641010) report and saved it to the server. The action Print Sales Order always shows the same initial report for me. I did the following steps as well. New version description and checked Save as a new version Removed all previous versions in my local instance IIS resetHowever every time after loading the report, Ctrl + F5 hits (clearing cache) will load the report I expected with setting the parameters. But not from the Sales Order screen Print Sales Order action button.Is there something that I can do about this issue?Thank you.
I am trying to filter the data coming in from acumatica using an IN CLAUSE on the PMTask object.My URL Looks like this{{acumaticaurl}}/odatav4/PX_Objects_PM_PMTask?$format=json&filter=ProjectID in (683,684,687,686,685)&$select=ProjectID, TaskCD, TaskID,NoteID, ExtRefNbr,DescriptionNo matter, what changes I do to the filter, it is fetching all the tasks from the database. How do I get the IN filter to work?Edit:The same syntax is working on the PMCostBudget object. The operation filters the records being fetched.{{acumaticaurl}}/odatav4/PX_Objects_PM_PMCostBudget?$format=json&$filter=ProjectID in (683, 684, 687, 686, 685)&$select=ProjectID, Type, Qty, UOM, CuryUnitRate, Rate, CuryAmountThanks in advance!
Hi, We’re trying to import all our customization from 2022R2 to 2023R2 and we’re getting this error: Can someone help how to fix this namespace error?
Here’s the POSTMAN call: getPublished is working fine with the same Cookie:
Hi All,Need to know how to color grid rows based on grid value. Ex: if grid column value(x) equal to 1 then row color change to red else keeps default color.ThanksBhagya
I’ve trying to create a simple purchase order but running into all types of problems. Can anyone explain why this isn’t working and offer a solution?I’ve attempting to create a simple PO containing 1 inventory item. There are 2 methods below, both fail. Setting properties directly. public POOrder CreateTransactionPO1(InventoryItem inventoryItem){ POOrderEntry graphPOOrderEntry = PXGraph.CreateInstance<POOrderEntry>(); POOrder pOOrder = (POOrder)graphPOOrderEntry.Document.Cache.CreateInstance(); pOOrder.OrderType = POOrderType.RegularOrder; pOOrder = graphPOOrderEntry.Document.Insert(pOOrder); pOOrder.VendorID = ((BAccount)Base.Select<BAccount>().FirstOrDefault(x => x.AcctCD == "ABB001")).BAccountID; pOOrder = graphPOOrderEntry.Document.Update(pOOrder); POLine pOLine = (POLine)graphPOOrderEntry.Transactions.Cache.CreateInstance(); pOLine.OrderType = POOrderType.RegularOrder; pOLine = graphPOOrderEntry.Transactions.Insert(pOLine); pOLine.InventoryID = inventoryItem.Invento
HelloI am trying to add a custom field to the SO Line details, which will calculate Available Qty - Line Qty for each line on the sales order.We are trying to do this as we have orders which we import that contain thousands of lines, and after importing it is extremely tedious to scroll through to find the lines which have the “QTY will go negative” error tagged on them. We do not allow inventory to go negative in our system, and for our use case, we must put the “oversold” quantity of product onto separate orders.I dont know where to start with this, and any help will be greatly appreciated!
I wanted to check best practice about Custom Fields. If you add a field to the Customization Project, publish the Customization Project, remove the field, and then publish again, then I think the field is deleted from the database. What happens if you unpublish the customization project, does the field get deleted too? Does the project check if any values are in the column being deleted from the database? Do I need to Export and Import to make sure I don’t loose the custom field data.I know that you have to unpublish customizations before upgrading versions so I don’t want to lose custom field data. Also, as this is a SaaS environment, who does the unpublish/publish when the upgrade is done automatically? If you have a number of tenants and the customization project is on an old tenant that then gets deleted, can you load the Customization Project to the current tenant so you can manage the Custom Field, and should you do this before or after the other tenant is deleted? Is it ok to ha
I am adding various custom fields to Acumatica. All seem to work ok, except on one screen. I have done a test on a sales demo instance. Adding a field to Sales Orders screen works and the field updates and persists when saving and the reloading the record. Putting a field on the Kit Assembly screen allows you to edit it, but it doesn’t save. When you reload the screen the field value is gone. I guess I am missing something that I need to add but that the other screens don’t need, or I have done something wrong somewhere. Here are my screenshots of what I have changed showing one that works and one that doesn’t.
Hello, I am using RowPersisting event to pop up a confirmation message when user click on save button. This works fine until i save a record. After i save the record, the confirmation message pops up even when i click on Remove hold button. I just want the pop up message to occur only at the save button. Before saving anything it works fine. Nothing pops up when i click remove hold button. But only after the record is saved, the pop up message occurs at the click on remove hold. How can i fix this ? I only want the confirmation message to occur at the save button click even after saving.This is my codepublic void ARInvoice_RowPersisting(PXCache cache, PXRowPersistingEventArgs e, PXRowPersisting baseHandler) { if (baseHandler!= null) baseHandler(cache, e); ARInvoice invoice = (ARInvoice)e.Row; if (invoice != null && (e.Operation == PXDBOperation.Insert || e.Operation == PXDBOperation.Update)) { WebDialogResult result = Base.D
I have been asked to replace the Dollar and Yen sign icons with Sterling or Euro (both in the dashboard and around the application like Banking -> New Deposit etc). Is this an option currently available in Acumatica? If not, where can I find the acumatica-font-v1 files that contain Sterling and Euro as replacements or additional to current icons?For reference I'm looking at ac-banking, ac-account_balance, ac-attach_money, ac-finance etc.Thank you in advance
Hi Everyone, In Catalog screen I added non stock item PALLET as shown in screen shot. I want when I insert pallets quantity on stock item that all item quantity total update on non stock item pallets field.as shown screen shot. When click Add To Cart that non stock item also inserted on Cart.I write below code but non stock item not inserting on Cart.protected void InventoryLines_RowUpdated(PXCache c, PXRowUpdatedEventArgs e, PXRowUpdated del) { InventoryLines inventoryLines = e.Row as InventoryLines; UpdateNonStockItemPallets();} private void UpdateNonStockItemPallets() { PXResultset<InventoryLines> pxresultset = base.Base.FilteredItems.Select(Array.Empty<object>()); foreach (PXResult<InventoryLines> pxresult in pxresultset) { InventoryLines row = pxresult; // Fetch the non-stock item record InventoryItem nonStockItem = PXSelect<InventoryItem,
I’m trying to copy UDF values from a Project Quote to a Project when the quote gets converted to a new project. In my Project Quote graph extension, I have the following code... PMQuote quote = Base.Quote.Current;PXCache baseCache = Base.Quote.Cache;var udfONSITECUST = (PXStringState)baseCache.GetValueExt(quote, "AttributeONSITECUST");var udfDESIGNENGR = (PXStringState)baseCache.GetValueExt(quote, "AttributeDESIGNENGR");var udfSALESREPRE = (PXStringState)baseCache.GetValueExt(quote, "AttributeSALESREPRE");using (PXTransactionScope ts = new PXTransactionScope()){ ProjectEntry projectEntry = PXGraph.CreateInstance<ProjectEntry>(); PMProject project = projectEntry.Project.Current = PMProject.PK.Find(projectEntry, quote.QuoteProjectID); PXCache cache = projectEntry.Project.Cache; projectEntry.Project.Cache.SetValueExt(project, "AttributeONSITECUST", udfONSITECUST?.Value); projectEntry.Project.Cache.SetValueExt(project, "AttributeDESIGNENGR"
Does Acumatica support real-time data sync without implementing the Commerce Connector plugin functionality?
in screen reason code. I update description field from code and save it to database but when I go to screen reason code, I see blank field and I check in database data store there. Otherwise if I update data from screen it can show up
Hi All,I have added a customer field called “Qty. Carton”. It's a decimal type. but unfortunately filter not working for that field. Does anyone know why is it?
PXRedirectToFileException works fine on the web, however in the mobile app I get the following error.The Mobile app action has the following attributesbehavior = Voidredirect = True
It seems that since upgrading to Acumatica 23R2 from 22R2 the delivery confirmation box visibility is tied to the Ship Via code used. As far as I can tell if there is no external carrier associated the combo box gets hidden, We have a few Ship Via codes that need a delivery confirmation related to Drop Shipping to customers that don’t have any external carrier plugin associated. Is there a way to override the behavior and make sure this box is always shown? Thanks for any help, Phil
Access to the path 'C:\Program Files\Acumatica ERP\NipponDB\CstPublished\pages_ap' is denied from public url
I have an Acumatica partner that I do some customizations for. After doing a customization, they want me to do some data clean up because there are fields in a custom table that need to be back filled and it would be WAY easier for me to update my custom tables in SQL Query Analyzer. I could write "one time” scripts and put them in a customization project, but without visibility to see if the script did what I wanted, and without access to be able to query the tables, it is a mind numbing exercise to have the partner run the script in the project, create an extract and send it to me. I’m sure you know what I am talking about here.I have my own databases hosted on Azure for my primary business and I can connect to them from my local PC, but the setup necessary to do that is not easy and requires some firewall changes and setting up Active Directory accounts. So, is there any way I can get access to run queries on SQL databases hosted at Acumatica, the cloud etc.? If anyone has done
I'm encountering the terms "surrogate key" and "natural key" while diving into Acumatica data management. Can someone explain the difference between these two key types and how they're used in Acumatica? Understanding their purposes would be much appreciated. As you can see in documentation it has mentioned that for primary key use the suffix as ID and for natural key use the suffix as CD based on the requirement. But in some cases the natural keys and primary keys are two different columns. And in some cases both were in same column. Can anyone justify why so.
Hi guys, I am currently in the need of help to populate a custom field in the SOShipLine DAC that I have created. I want to populate this custom data field called UsrSerialCodes with the values of the Serial/Lot codes displayed per line number. Here is an example of a shipment with 3 entries with 3 different Line Nbrs: And here is the different serial nbrs for each line nbr when you go into Line Details: I have populated a list with these serial codes respective of the line nbrs and now I want to populate the data field (UsrSerialCodes) that I created respectively for each LineNbr in the SOShipLine DAC. It seems like when I trace log everything, it populates the data field, but doesn’t display the values of the serial codes. It still shows a blank. Here is the code that I am using in the SOShipmentEntry Graph Extension: The overall goal is to transfer the Serial Codes to the ARTran DAC in order to populate them per OrigLineNbr in the so643000 report. Any help on this matter would be
Hello all,I have the below code that works just fine and as expected in 2022R2. I am upgrading this package to 2023R2 and I am getting an error that “Cannot mark the record as updated because another record with the same key exists in the cache. Contact your Acumatica support provider for the assistance.” When I trace on the line that I try “journalGraph.Save.Press();” the problem is caused.Any idea what is going on or has someone come across the similar issues on upgrade to 2023R2? This is my code without any change from 2022R2 => 2023R2. #region Reverse Action & Method public PXAction<HCLPMWIP> HCLreverse; [PXUIField(DisplayName = HCLPMMessages.Reverse, MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton] public IEnumerable HCLReverse(PXAdapter adapter) { if (IsValidWIPDocument() == true) { try { JournalEntry journalGraph =
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.