Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi, this should be simple but I must be misunderstanding something fundamental to Acumatica development.I want to create a stock item and I have the following code:InventoryItemMaint graphStock = PXGraph.CreateInstance<InventoryItemMaint>();InventoryItem newInvItem = new InventoryItem();newInvItem.InventoryCD = "TEST2";newInvItem.Descr = "TEST2";newInvItem.ItemClassID = 49;graphStock.Item.Current = graphStock.Item.Insert(newInvItem);graphStock.Actions.PressSave();I set the ItemClassID and when I call graphStock.Item.Insert(newInvItem) the Acumatica Framework refeshes the newInvItem object and sets fields such as ItemType, ValMethod and BaseUnit.Then I set the Current object and perform the Save Action, all basic stuff.The problem is this, if the ItemClass doesn’t have a Default Warehouse then the code above works fine and the stock item is created. However, if the ItemClass does have a Default Warehouse then the code returns the following error:Error: Inserting 'Inventory Item C
Hi,I have created a lookup to display SOAddresses. However I could not see any columns in the lookup and the only column there in the column configuration is AddressId(when I select it, it also gives an error). Any idea about this? Below are the related screenshots. Thanks
Hello, I understand we are having yellow alert and also the highlight frames like below. But I am still curious to ask, is there anyway that we could change the font color of “Credit Hold” to RED? Only this single element. No other fields. And also it is only red when it is “Credit hold”, it remains black when open or completed.
I have a custom inquiry screen that everything is working well on except users cannot save a custom filter. They receive this error message after hitting ok on the Filter Setting dialog. Error: The view doesn't exist. See the screenshot below. Is there some additional setup I need to do in my customization to support this feature?ThanksScott
I’m not sure if it’s possible but I would like to add tabs inside a tab on the Equipment Screen (FS205000). This is an image of our current system for our equipment. Under the Forklift Information tab we have tabs for more specific information: Setup, Motors, Batteries, Engine and Transmission, Service Data, Tires, Mast and Safety. It would be very difficult to add all those fields to one tab. Having all those tabs at the same level as General, Purchase, Components and Warranties, Attributes and Source would also be confusing. Let me know if it is possible to add sub tabs.
I need help with adding a new field on filter and grid on a matrix lookup. The searched orderNbr should be shown in the grid below as a custom field. Also need help with how to override the existing dataview as to be filtered by the custom field added on filter.
I have did a customization where using the pre assigned lot serial nbr feature to show the next lot serial nbr. i have did using the below code PXResult<InventoryItem, INLotSerClass> result = new PXResult<InventoryItem, INLotSerClass>(invitm.Current, iNLotSerClass); ILotSerNumVal numVal = INLotSerialNbrAttribute.ReadLotSerNumVal(this, result); numVal.LotSerNumVal = numVal.LotSerNumVal + iNLotSerClass.AutoNextNbr; string autoincrementnbr = INLotSerialNbrAttribute.GetNextNumber(invsetting.Cache, iNLotSerClass, numVal); // invsetting.Current.LotSerNumVal = INLotSerialNbrAttribute.GetNextNumber(invsetting.Cache, iNLotSerClass, numVal); Where it was working fine in 21R1 but when i check these in the 22R1 its not generating the next lot serial nbr using INLotSerialNbrAttribute.GetNextNumber(invsetting.Cache, iNLotSerClass, numVal);all the
Hello Everyone,I have a SQL View where I join some tables in each block and then, using UNION ALL, I combine all blocks and return a list. In Acumatica by using PXProjection, I should be able to replicate the result of each block as a flat DAC but I am not sure how then I can aggregate these Projections to get a unionized result of all DACs. As a very simple example, how I can replicate the below SQL example in Acumatica?CREATE VIEW [MyUnionView] ASSELECT 'AP' AS [DocType], [RefNbr] AS [RefNbr] FROM [APInvoice]UNION ALLSELECT 'PO' AS [DocType], [OrderNbr] AS [RefNbr] FROM [POOrder]UNION ALLSELECT 'PM' AS [DocType], [ContractCD] AS [RefNbr] FROM [Contract]GOSELECT [DocType], [RefNbr] FROM [MyUnionView]GO
Hi everyone,I want to share with you how my team has conditionally hide a Grid Column in an Acumatica Grid.Firstable, the context is that we wanted to hide the Quota % column of a grid when the Use Quota Flag of the header was set to No.To do so:1) Code in the RowSelected of the Grid (Not the parent) the field property SetVisible: PXUIFieldAttriute.SetVisible<DAC.Field>(cache, null, Conditional_Expression);2) Traditionally the Acumatica Event_Handlers are coded by addingif(e.Row == null) return;You must put the code block from 1) before 2) as it is depicted in the following image Event Handler Definition ExampleYou must add the CommitChanges propperty to the fied triggering the condition. In our case, the Use Quota field I´m sharing the grid propperties, nothing special at all Grid DefinitionResult -Before -After
Hi, We would like to print our checks to out dot Matrix printer we have the correct layout but printing from the AP.64.10.00. Its almost like the printer can not understand how to print this. We also cant add the check in the Device hub Q as this report can not be added to that Q this leaves us with the PDF check report that opens on the a new tab and this report is not printing to our dot matrix printer. is there a config in the Report Designer that would allow the dot Matrix printer to decode the strings and print them. Please let me know if someone has managed to print checks to a dot Matrix printer out of Acumatica.
Good Day,This is my first time to post here in the site, please bear with me. :)One of the requirements of our project is to duplicate an existing screen (Customer Contracts) into a new screen (Vendor Contracts) imitating the existing screen. I already saw one approach that the asp files can be copied and renamed but that is possible only for the ASP files.Could this be possible? If so, are there other things to consider (graphs, DACs of the existing screen to be duplicated as well?) Are there other ways to achieve this?I'm still new to acumatica btw. Any responses are very much appreciated.Thanks and stay safe.
Good day,This isn’t causing any particular issues per-say, but ever since we’ve upgraded to 22R1, we get the following warnings when publishing customizations.\Controls\PageTitle.ascx.cs(877): warning CS0219: The variable 'webItem' is assigned but its value is never used\Controls\PageTitle.ascx.cs(1105): warning CS0414: The field 'User_PageTitle.auditMenuEnabled' is assigned but its value is never usedCustomization Log SampleI’m more just curious where this might have crept in, and whether it’s specifc to our instance, or if more people are seeing this one.If anyone is aware of a solve for this warning, that’d be great too.
I have added the ‘Add PO Line’ action to the PO receipts screen on the mobile app by following the steps on the last few pages in the T410 manual. This works great to add the lines and release the receipt. To streamline the process, I would like to have the ‘Add PO Line’ action available on the Document Summary screen by default. To explain further, if I update the ‘formActionsToExpand=’ to 4, then I have all actions appear at the bottom in this order: Hold, Assign, Release, Add PO Line. If I update it to be ‘formActionsToExpand=’ to 2, I have Hold, Assign, … with the option to select … and Add PO Line.How do I get it to be displayed as the following: Hold, Add PO Line, … on the document summary screen for the PO receipt?It appears that when I added priority, listPriority and formPriority were not available options in current context. I have also attempted to add the action, as I’ve done, then below it say update recordAction in attempt to reorder the actions.
Hi, seeking for help on how I can implement the following: Sales Order Header & Details Tab: Description: We don't want to show the Status. Shipping Rule: Ship Complete Sales Order: Financial Tab: Credit Card Sales: Payment Method: AUTH NET Cash Account: WELLSFARGOAll other sales: Use companies default payment method (I think this is doing this already) Sales Order: Shipping Tab: FOB Point: Prepaid Shipping Rule: Ship Complete Sales Order: Totals Tab: Freight Price needs to populate in Premium Freight Price instead. Invoice Description: No Status (Assuming its the same information from Sales Order, but including in case it isn't) Order Comments: Can we have order comments printed as a line note on the packing slip? Preferable the very last line item. Thank you.
Does it concern anyone that the “Pick Pack and Ship” workflow seems to be completely devoid of units or measure? Once you had added an item, it will show the unit of measure for a second, but once you’re onto the next item it’s gone. And NONE of the other screens will show you which unit of measure you picked. All the below screens are examples of how this workflow is completely devoid of units of measure. This is kind of an important feature, since the difference between picking (and selling) 1 pound of something versus 1 each of something that weights 1000 lbs is pretty big. So you don’t want your warehouse people to be confused about which they’re picking.This is just another example of a workflow that never got vetted by anyone in a warehouse. Sure, we can customize it to add this back, but should we really have to?
When I’m doing a customization on Customer Portal I added a new DAC in PortalV1 namespace. However, Visual studio does not allow me to use that namespace in another class & it gives “The type or namespace name could not be found” error. Any idea about fixing this issue?Thanks.
I created a custom processing screen with the following data view:public SelectFrom<INLocationStatus>. InnerJoin<InventoryItem>. On<InventoryItem.inventoryID.IsEqual<INLocationStatus.inventoryID>>. Where< Brackets<INLocationStatus.siteID.IsEqual<PrintLabelsFilter.siteID.FromCurrent>. Or<PrintLabelsFilter.siteID.FromCurrent.IsNull>>.And<Brackets<INLocationStatus.locationID.IsEqual<PrintLabelsFilter.locationID.FromCurrent>. Or<PrintLabelsFilter.locationID.FromCurrent.IsNull>>>.And<Brackets<InventoryItem.itemClassID.IsEqual<PrintLabelsFilter.itemClassID.FromCurrent>. Or<PrintLabelsFilter.itemClassID.FromCurrent.IsNull>>>>. ProcessingView.FilteredBy<PrintLabelsFilter> Items;The view displays great and it processing like expected. However, when the processing has finished, the rows that were processed display, but there is data missing from the jo
Hello Everyone,I Have a field that is CustomerID in that field adding Baccount.Type PXSelector Attribute , but here showing some values are Empty. I need all data in Selector.can you plz let me know how can achieve this..!Note : When I selected the empty record that value is Stored in CustomerID field. This is my DAC field Selector [PXSelector(typeof(Search6<BAccount.type, Aggregate<GroupBy<BAccount.type>>, OrderBy<Asc<BAccount.type>>>), typeof(BAccount.type))]
I have an override on the SOShipmentEntry CreateInvoice action that works fine when the Prepare Invoice button is pressed on the Shipments screen, but not when it is ran through the Process Shipments screen. The screenshot below is a simplified version of the override. The Base.Document.Current.ShipmentNbr field is null and also Base.Transactions.Select() returns no records. What am I missing? I need a reference to the shipment nbr so I can reference back to the order to update some custom fields on the invoice that’s generated. ThanksScott
Hi all,I’ve implemented a customization to the Physical Inventory Review screen.In short, the customization is to accomodate the odd occasion where lot tracked items have multiple batches on a single location (technically shouldn’t happen, but in a retail environment it’s impracticle to have multiple locations, so we operate on 1 shelf location).I’ve implemented the customization in such a way that the staff can count all of the lot numbers of a particular stock item into 1 ‘fake’ lot number. I’ve then added a new custom action to the menu, which allows them to distribute the counted line item across multiple lots.I’ve managed to get all this done & working correctly, EXCEPT that the screen doesn’t update the details section & totals section until such time that the screen is reloaded manually. Am I perhaps missing some call in the code to refresh the screen sections?PS. we are on Build 22.111.0020Any assistance is highly appreciated.Screen before & After clicking the Distr
As I wrap my brain further around the framework I’m starting to ask myself questions on the ‘why’ I am coding things the way that I’ve coding so I get better at all of this.I’m not entirely certain what the first graph parameter of a PXSelect is being used for. I think I’ve read somewhere that I shouldn’t generate a generic PXGraph for the first parameter.So, in this example, I can see how my soOrderEntry graph becomes the source of the query so that it will return the lines from the soOrderEntry record that it currently holds.var lines = SelectFrom<SOLine>. Where<SOLine.orderType.IsEqual<SOOrder.orderType.FromCurrent> .And<SOLine.orderNbr.IsEqual<SOOrder.orderNbr.FromCurrent>>> .OrderBy<Desc<SOLine.lineNbr>> .View.Select(soOrderEntry);But, in the case where I need to find, say, a warehouse code and I use:INSite iNSite = INSite.PK.Find(this, siteID);I’ve used ‘this’ because this code resides within a
Hello Everyone,Is it possible to create a dashboard that will show the status as active/inactive instead of showing 0 or 1?Expected Result: I’ve tried like below but am not able to achieve this. Generic InquiryWidget propertiesDashboard
When I reset dialog answer (PaymentCalendar.View.Answer = WebDialogResult.None) in the PaymentCalendar view, my function ,,dublicateItems" Called again and the loop is executed again. How to continue loop execution instead of calling a function?My code public virtual void dublicateItemsOK() { foreach (DateTime dateTime in dateTimeList) { WebDialogResult result = PaymentCalendar.Ask(ActionsMessages.Warning, PXMessages.LocalizeFormatNoPrefix(textMessage), MessageButtons.YesNo, MessageIcon.Warning, true); if (result != WebDialogResult.Yes) { PaymentCalendar.View.Answer = WebDialogResult.None; continue; } }}
I’m getting an error when deploying a package with a custom screen to another instance of Acumatica.You can see in the screenshot below, that an extra comma is being added to the create table statement. I have other tables in the package that do not seem to have this issue.I deleted the table from the package and re added it to trouble shoot, but I got the same error.I did not see anything odd in the customization item. I included the xml below (slightly modified to rename the table) <Sql TableName="MyAddress" TableSchemaXml="#CDATA"> <CDATA name="TableSchemaXml"><![CDATA[<table name="AHSVendorCoreAddress"> <col name="CompanyID" type="Int" default="Zero" /> <col name="AddressID" type="Int" identity="true" /> <col name="MyNbr" type="NVarChar(15)" /> <col name="IsDefaultAddress" type="Bit" /> <col name="AddressLine1" type="NVarChar(50)" nullable="true" /> <col name="AddressLine2" type="NVarChar(50)" nullable="true" /> &
Hello.We would like to append a running operation number (custom field) for each batch of printed reports, but only when we print via bulk processing. For all printed records, it should be the same number and only increment when we start another operation via the bulk processing screen. This would be useful for a history and for the ability to sort records by operation number.Example:Order 2728# | Operation: 1Order 2872# | Operation: 1Order 2879# | Operation: 1#Stop - #Start of next mass processingOrder 2218# | Operation: 2Order 2389# | Operation: 2#Stop... and so onIs it clear what we want to achieve?If yes: Is this possible in any way?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.