Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
How can I achieve below function by overriding the action/s.“ I need to add a record/s of inventory lookup view to Receipts screen Details tab when I click panel buttons (ADD, ADD & CLOSE)”Additional info:Used version: Acumatica 22.112.0018No customizations publishedUsed data set U100Below I have attached a sample demo (assume inventory lookup view consist of different set of records)
I'm trying to use UpdateDatabase to be able to insert my data into the UploadFileRevision table in the database without success.I don't know how to do the above request. ?
I am creating an Import Scenario that will import multiple sales orders and multiple line using a tab delimed csv file. I have gotten it to the point where it is creating the sales order and their lines. there is just one problem. it is creating the first sales order with all its line perfectly but from there on it always missed the first line in the sales order. I have created 3 sales orders with 10 Lines Sales order 1 or (241144) has 4 Lines Sales order 2 or (242111) has 2 LinesSales order 3 or (242130) has 4 Lines Sales order 2 and 3 have one line dropped i renamed the Quantities of my line from 1 to 10 to check what the pattern was. I do a look up on the Customer Order number I suspect this is where the problem is but no matter where I move it to in the file the bug persists. Please see my screen shots attached. Any help as to why I'm getting this strange problem would be great. Thanks Willem.
Hello!Is there any way to set a column filter from a custom action in the graph?Like:
Hello, Is it possible to create a default sorting option for a screen such as “MRP Display”? The customization tab in the top right shows it’s not a generic inquiry, so I can’t edit it that way. I guess I’m not familiar with what the difference would be here, because it looks very similar to a GI. Thanks!
Hi: I'm trying to create a GI of Invoiced Items, but I want to separate the items by an attribute. The GI is going to be summarized by Sales Rep and the Sales would be in 3 Columns. Attribute1 Value1, Attribute1 Value2 and Attribute1 Value 3. I create a formula like: =IIf( [InventoryItem.COMI_Attributes]='VO5', [ARTran.ExtPrice], 0.00), it validates. but when I run the GI I got this error. Error: The virtual field COMI_Attributes cannot be used in a condition expression. How can I get my GI to work. Thanks Jesus.
Hi,I need to integrate the Asian bank details with my acumatica ERP .Can you suggest any integration method/references to do that.Thanks
Hello Everyone, We are currently evaluating Acumatica for our company, which does both Distribution(Warehousing, etc) and we are also a Manufacturers Rep - which means we quote customers on behalf of a manufacturer, and then we submit the customers order to the Principal(Manufacturer) on the customers behalf. The manufacturer then pays us a commission which is then paid out to the salesman who handles that territory. Has anyone implemented a sales process similar to that within Acumatica? I know that Acumatica has a vast level of customizability with Web servies and/or AddOns etc, but just wanted to get some opinions on using this software for a business process like I’ve described. Thanks!
Hi all, I need to customize the process logic for a selected action in the Print/Email Orders screen. Currently, the action defined in SOOrderEntry graph is executed separately for each selected order when the process button is clicked. However, I want to process all the selected orders at once according to some logics.Can someone guide me on how to execute the action for all selected orders at once instead of processing them separately? Which method should I override to achieve this?Any help or suggestions would be highly appreciated. Thanks
Wondering if anyone can offer some insight here. I was working on adding screen SO509000 to the mobile app and I was having an issue with the site map schema which I have since figured out. When I went back in to create a new customization of the mobile app by adding SO509000 screen I am getting the following error: ‘The 'SO509000' screen is already used in the current customization project. Select another screen.’The issue is that I have unpublished and deleted the original customization project that had this screen in it. Since then I have attempted the following. I have unpublish all of our customizations and republished the ones that are relevant and verified that the screen SO509000 is not being used in any other customizations. Additionally, I can still see the initial object that was created on the mobile app even without a customization or a Mobile Workspace telling this to be here. I have tried to reset the Mobile Workspaces to the defaults as well. It would appear that the
Hello everyone,I published POS 2021 R2 version on my ERP 2021 R2, made all necessary configurations but on the pos orders after pressing the PROCESS button its supposed to take me to a screen to print the receipt but its not doing so. If I press the REPRINT RECEIPT button, no action is triggered.The payment created is also left status: open instead of closed. I’m not able to find solution to this.Kindly assistALL responses will be highly appreciated.Thank you.
Hi everyone,I’m using a generic inquiry to trigger a business event. The business event then has a custom data provider as a subscriber to send data to a remote API.Whilst this is mostly working, I’m trying to use the GI field “Captions” to provide a known name for columns that may have a function attached (or if the user wants to customise the column names). At the moment in the EventAction’s Process(MatchedRow[] eventRows, CancellationToken cancellation) method, Captions aren’t pulled through from the GI, only the original field names or randomly generated names for the columns containing functions.I’d like to be able to get hold of the GI that triggered the business event so I can retrieve the caption names for some of the fields.Is there a way to get a reference to the triggering object (in this case a GI) within the “Process” method or elsewhere?Many thanks
The following is the code causing the errors; Unable to cast object of type 'APDocumentResult' to type 'PX.Data.PXResult`1[PX.Objects.AP.APDocumentEnq+APDocumentResult] What could be the issue? Kindly assist Thank you
On the shipments form I have my shipped volume as shown belowI need the shipped volume to appear on transfer form on the summary area as shown below. Any ideas on how to go about with the business logic?
Hi Expert.I try disale field So Notes depends on the condition of the shipment in below:I try set break point at:PXUIFieldAttribute.SetEnabled(cache, row, true); PXUIFieldAttribute.SetEnabled<SOOrderExt.usrSoNote>(cache, row, true); break point ok, program touch here. protected void SOOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { InvokeBaseHandler?.Invoke(cache, e); var row = (SOOrder)e.Row; if (row != null && row.OrderNbr != null) { Base.Document.Cache.AllowUpdate = true; Base.Transactions.Cache.AllowUpdate = true; SOOrderShipment ship = PXSelect<SOOrderShipment, Where<SOOrderShipment.orderNbr, Equal<Required<SOOrderShipment.orderNbr>>>>.Select(Base, row.OrderNbr.Trim()); if (ship != null && ship.ShipmentNbr != null) { SOShipm
Hello Everyone,I am facing this error while publishing the customization.see below: Have tried to troubleshoot but couldn’t resolve it.Kindly assist,Thank you allany kind of response will be highly appreciated.
I am in the process of trying to connect a SQL Server View to Acumatica. Right now I am on the “Create Code File” and there should be, in the drop down the ability to select lBqlTable but it does not exist. The only selections that are available are:New Graph, New DAC, Graph Extension, DAC Extension, Code File, and Customization Plug-in.
Has anyone added /activated existing functions keys, that are currently not available on the mobile app. I had a case on this and was pointed to the following articles.Which are informative but disjointed and most likely over complicate what has to be done to activate the existing Action keys. I attempted to follow the instructions, I have supplied a image of the customization, and an image of what mobile functions are available. When the PO is in pending print status. A couple issues using the mobile app the PO cannot be opened (open Status) which is what is wanted. The print /no print options were deemed not essential an left off the mobile app, as space is limited. I checked this from my end. By default, due to the space constraints of a phone screen, not every function is available in the mobile application. Therefore, you will have to customize it based on the below help articles.https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=3484dde7-2027-4e12-a60e-223e5a518421
Hi,I have customized a new screen. To my screen I’m getting data from soorder DAC and soline DAC. This time, I need to get sales orders without duplicating from the view to my custom screen. When new row is inserted into my line level, I need to update TotalDiscount field of header level with soorder.curydisctot value which is taken from the soorder screen header level. To accomplish avoid duplicating when adding same sales order number , I tried the below code in the row inserted event but it didn’t work.protected void APProformaItemList_RowInserted(PXCache cache, PXRowInsertedEventArgs e) { var row = (APProformaItemList)e.Row; APProforma item = APProformas.Current; //add so discount into form var distinctSOLines = this.APProformaItems.Select().FirstTableItems.ToList().Select(x => x.Ponbr).Distinct(); foreach(var itemlist in distinctSOLines) { SOOrder order= SelectFrom<SOOrder>.Where<S
Hi,I create a new data field into my purchase order screen poline DAC,[PXDBString(10)][PXUIField(DisplayName="uomnew")]Then I try to set field value in rowselected event. public class POOrderEntry_Extension : PXGraphExtension<PX.Objects.PO.POOrderEntry> { #region Event Handlers protected void POLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (POLine)e.Row; POLineExt poLine = PXCache<POLine>. GetExtension<POLineExt>(row); poLine.Usruomnew= "news"; if(poLine != null){ poLine.Usruomnew= "new"; } } #endregion } After adding POOrderEntry_Extension and published It shows an error below like that.Can you please give solution for that.
I need to add new two columns with Item wise weight and UOM to the Sales Order form (SO301000) line level. Can you please provide the work around how it is archived from the customization project editor.
I set up a new sandbox and database and uploaded a backup of my production ERP to populate the database. I can see that the database tables populated, however my data is not showing up in the sandbox. Can someone please help me troubleshoot? Thanks!
Hi,I was trying to publish a new change I made to a client’s system and I got the exception shown below:System.IO.FileNotFoundException: The file '8670b8ca-b605-473b-9152-e7f09e536cba' has not been found.What would be the best way to resolve this issue?Kind regards,Andrew
Hi, I’m struggling to insert a new Customer Contract record into Acumatica using code. The screen is CT301000Here is the screen shot:and here is the important part of the code I’m using with added comments//create the graphContractMaint contractMaint = PXGraph.CreateInstance<ContractMaint>();//create a new instance of the dacContract contract = (Contract)contractMaint.Contracts.Cache.CreateInstance();//insert into the viewcontract = contractMaint.Contracts.Insert(contract);//set the contractCD, it's using a segmented key but I think this is the way to set the valuecontract.ContractCD = "D -D -<NEW> ";contract = contractMaint.Contracts.UpdateCurrent();//set the template id, update the contract record with contract template info//t has a value of coursecontract.TemplateID = t;contract = contractMaint.Contracts.UpdateCurrent();//set the customer id and update the contract record with customer info//c has a value of coursecontract.CustomerID = c;contract = contrac
I’m programmatically setting the value of a custom field depending on another field’s value. I want it to happen first thing when the page is displayed, before anything is changed by the user. I which event should I put the code?Thanks is advance for any suggestions.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.