Develop Customizations

Hello Community,i’m working on a customization project and i want a grid to show some results of joining 2 tables, I wanted to ask how to join ARinvoice to MasterInvoice, because when i do it the form shows “ARInvoice duplicated many times in FROM clause”

I am very beginner to the Acumatica ERP.I have to do a customization which is in Sales Price Worksheet screen summary area invisible effectiveDate,expirationDate and Promotional fields  and add them into same screen but into the details area(Grid). and then when user insert the input on the grid and saving of the Sales Price Worksheet and press remove hold then the release button and the Sales Prices screen prices should updated properly.The inputs of those added fields to the grid of sales price worksheet screen should be pass to the sales prices screen similarly.In the sales price worksheet screen, the grid retrieve data from ARPriceWorksheetDetail Dac but Sales price screen grid retrieve data from ARSalesPrice Dac. The issue is those two Dac s are not connected in direct references. I couldn’t get same value of effectiveDate field in sale price worksheet screen to Sales Prices screen. Basically I need to know how to connect ARWorksheetDetail Dac and ARSalesPrice Dac

The below event works fine when the UI button is pressed, however when a business event calls it the PressButton() function returns a NullRefernceException. I can not figure out why. the exception stack is   at PX.Data.PXAction`1.<Press>d__38.MoveNext()   at PX.Data.GraphHelper.PressButton(PXAction action, PXAdapter adapter)   at GPGeneral.PM.PMTaskEntry_Ext.SendPendingNotifications(PXAdapter adapter) in C:\Program Files\Acumatica ERP\ACU-1\App_Data\Projects\GPGeneral\GPGeneral\PM\Task\PMTaskEntry_Ext.cs:line 511   at PX.Data.PXAction`1.RunHandler(PXAdapter adapter)   at PX.Data.PXAction`1.<Press>d__38.MoveNext()  public PXAction<PMTask> sendPendingNotifications; [PXUIField(DisplayName = "Send Pending Notifications", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select, Enabled = true)] [PXButton(CommitChanges = true, Category = "Notify", Connotation = PX.Data.WorkflowAPI.ActionConnotation.None)]//, ImageKey = Sprite.Main.P

On screen "Pick, Pack, and Ship", (SO302020) I am trying to make some changes, but it is an odd screen so any ideas would be welcome. I have managed to make some changes and I am spending a lot of time in the debugger trying to understand what I can do but I haven't got that far yet. I have been working with methods and events like:SOShipLineSplit_RowSelectingSOShipLineSplit_RowSelectedSOShipLineSplit_LineNbr_FieldSelecting These don't fire when I would expect. They don't fire when I click on the grid. Perhaps this is because the grid is is not editable. I don't see how to change this. Basically what I ideally want is to detect when a row is selected or clicked on and then run code populate the Scan field with the Inventory Code. I could also do this from the header on a button or something, but when I play with events on the header and get a link to the table I can't see a selected row in there so I am stumped.// Acuminator disable once PX1045 PXGraphCreateInstanceInEventHandlers [Jus

Hi All,I need to avoid the data saving once validation fails. I wrote a method in RowPersisting event. Validation message comes but data is going to save .So I need to return from the saving until validation sucess.Here is my code.protected void _(Events.RowPersisting<HMRCAPIConfigDetail> e)        {            HMRCAPIConfigDetail row = e.Row;            if(row != null)            {                if(String.IsNullOrEmpty(row.Description))                {                    string msg = "Description Cannot be Empty";                                        WebDialogResult result = HMRCAPIConfigDetails.Ask(ActionsMessages.Warning, msg, MessageButtons.OK, MessageIcon.Warning, true);                    return;                }                            }                    }Thanks 

I have a graph extension of the Project screen (ProjectEntry graph).  Included in this extension is a new view, and there is a new custom detail tab on the screen with a grid on it reading data from the new view.  In the grid, there is a column with a LinkCommand that calls an action method in the graph extension which opens a screen related to the column value.  This all works fine.I also have an extension of this graph extension that overrides the view mentioned (adds joins to it) by simply redeclaring the view with the same name.  So far so good.  However, the link command mentioned above is still called as expected, but it fails to behave as expected.  Inside the action method, it expects the view to have a current record (the record in which the link was clicked), but the view doesn’t have one (it’s null).  The exact same code running from the first extension class, but now with an overridden view somehow causes the view to not know its record pointer; so it doesn’t know the value

Hey all,I have and issue and I am trying to see if anyone else has seen this issue or may know what may be causing this.  We have custom fields on the Locations table and a customization that populates these fields when a new Customer/Vendor Location is added.  In 2020 R1, this customization worked on all added location.   In 2021 R1, this customization works great except for the first initial “Main” Location that gets created automatically when you create a new Customer/Vendor.  Does anyone have any ideas why the automatically created location skips any custom code but all subsequent ones don’t.Thanks,  

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?