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,I have to add another two more conditions to my custom view.*get sales orders when InventoryItem.itemType == charges or soline.openQty > 0The sql query is something like this to get an idea,Select * from soline lineinnerJoin soorder order on line.orderNbr/ordertype= order.orderNbr/ordertypeleftJoin solinesplit split on line.orderNbr/orderType/lineNbr = split.orderNbr/orderType/lineNbrleftJoin inventoryItem item on line.inventoryId= item.inventoryIdwhere other conditions....and order.status != "Cancelled" and (item.itemType == "Charges" or line.openQty > 0) I tried to apply above condition in the below bql query but it doesn’t look like as what I wanted. so could someone please to help me on this?public PXSelectJoin< SOLine, InnerJoin<SOOrder, On<SOLine.orderNbr, Equal<SOOrder.orderNbr>, And<SOLine.orderType, Equal<SOOrder.orderType>> >, LeftJoin<SOLineSplit, On<SOLine.orderNbr, Equal<SOLineSplit.orderN
I know this is “not possible”. However, Acumatica can do it. Why can’t I?When creating the Sales Demo data starting in 21R2 or so, someone extended AACUSTOMER to a Vendor, then deleted that vendor account. This returned AACUSTOMER back to just a CU. However, it leaves a record in the Vendor table with DeletedDatabaseRecord = 1.I want to programmatically “re-extend” the customer to a vendor again. I can’t. If I try to insert a new record in the Vendor table, it sees it as a duplicate. Also, since it is deleted, I can’t edit the existing “deleted” record.Acumatica has some way to do this. If you use Acumatica to Extend to Vendor for AACUSTOMER, it either 1) permanently deletes the existing vendor record prior to inserting the new record, or 2) it changes the flag on the deleted field to zero. I am guessing it has some way to change the flag.I thought I could try to re-use the business logic to extend the customer to a vendor using the CustMaintenance graph, but that will throw a
I created a customization that creates a view of manufacturing labor data and adds it to the DAC so it can be used in a GI. However, I am getting the following error when I try to release manufacturing transactions. What could cause this?
Hi Team,I have created few side panels in Project screen using my local instance through customization Project “action” properties. But when I publish the same package to server instance, the side panels disappear. May I know how I can rectify this issue. Local Instance: Server Instance: Regards,Ramya Krishna
I’m working through a project and I’ve been looking up code examples here and there.My question is: When do I use the primary view and when do I use the CurrentDocument view?This SO answer shows the creation of a Sales Order and references CurrentDocument but the primary view of SOOrderEntry is Document:SOOrder order = new SOOrder();SOOrderEntry graph = PXGraph.CreateInstance<SOOrderEntry>();order.OrderType = "SO";order = graph.CurrentDocument.Insert(order); order.CustomerID = project.CustomerID;graph.CurrentDocument.Update(order);graph.Actions.PressSave();Whereas this SO answer shows the creation of a Purchase Order and references Document and POOrderEntry.cs has Document (primary view) and CurrentDocument (second view).protected void createPO(){ var graph = PXGraph.CreateInstance<POOrderEntry>(); var order = graph.Document.Insert(new POOrder()); order.OrderType = POOrderType.RegularOrder; // This is the default so not necessary order.OrderDesc =
If the quantity is 0 in any row, a confirmation dialog box will appear, if you click on OK, the value will change, if you click on cancel, the old value will be returned. It will be applied to the entire grid.
Hi All,I want to customize Message field (show some additional information in it) in Pick, Pack and Ship Screen.Is there any way of doing this?
Hi,I have customized a new tab called ‘Discount’ to my custom data entry screen. There are two fields called Discount Amount and discount percentage in the grid as below.When I changed a value of discount percentage, I want to set value to discount amount based on discountable amount just after the field updated. For that I used below code but it get executed when adding a new row.protected void APProformaDiscount_DisctPercent_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (APProformaDiscount)e.Row; APProforma item = APProformas.Current; decimal? amount = (row.DiscountableAmt * row.DisctPercent) / 100; //row.DisctAmt = amount; cache.SetValue<APProformaDiscount.disctAmt>(row, amount); }Even I tried with cache.SetValueExt but it also didn’t work.Note: this is custom graphCan someone help me on this to find a solution please?Thank you.
I added a new field of type PXNoteAttribute to the DAC to enable file attachment.i.e #region NoteID public abstract class noteID : PX.Data.IBqlField { } protected Guid? _NoteID; [PXNote()] public virtual Guid? NoteID { get; set; } #endregionOn testing I got the following error what could be the issue? Kindly assist.Thank you all.
Hi All, I want to get expense claim approvers’ details to expense claim details report. What are the tables that should be joined in Build Schema to get details such as EmployeeID, Name etc. Thanks
Hi all,I have created a new screen & two new tables. But when I’m saving a record I got this error. And now I can not access that screen. ErrorError: An error occurred during processing of the field Tstamp: Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. See https://mysqlconnector.net/connection-options/.Here is DAC Tstamp field. #region Tstamp [PXDBTimestamp()] [PXUIField(DisplayName = "Tstamp")] public virtual byte[] Tstamp { get; set; } public abstract class tstamp : PX.Data.BQL.BqlByteArray.Field<tstamp> { } #endregion Anyone know how to fix this?Thanks.
Hi,What would be the best way to reverse the code below so that I can update the original DAC field with the custom DAC field? The reason for this reversal is that I created the new custom field to replace the original Description field. This is because I wanted the descripition field to hold 4000 characters, but reports would still be pulling it in as having only 250 characters since I didn’t update the SQL. Now that I realise my mistake of not updating the length of the description field via SQL, I will need to reverse the code below so that I can move the text back into the original description field as this custom field is no longer needed. Kind regards,Andrew protected void PMRevenueBudget_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { PMRevenueBudget row = (PMRevenueBudget)e.Row; if (row is null || row.Description is null || row.Description == "") return; var value = row.Description; cache.SetValueExt<PMBudgetExt.usrDescriptionExt>(row, value)
Hi expert. I’m not found solution how to enable button “Update IN” by SO Order Type and SO Status in Shipment screen.can you help me? Thank everyone so much.
Hi All,We are trying to add the Branch field on the Approve Clock Entries screen. I was able to add the field to the screen, but now we would like it to be editable. (Sometimes the Branch is wrong and needs to be updated before Approval.) We would like a selector similar to the Production Nbr field. I added the column to the grid using the screen editor. I also added this field to the Levels and set AllowEdit=True. I also tried setting Enabled=True. In all cases the field is visible but read-only.I looked at the attributes for BranchID field on the DAC and it is simply [Branch].I would appreciate any help from the customization gurus out there on how to make that field editable.Thanks in advance!Layout properties for the Branch ID control:
Hello,I’ve created code to overwrite a protected method called Bill in the contract billing class, by extending the CTBillEngine graph.This is quite an involved method which calls out to other protected methods within the same CTBillEngine class. I’ve used [PXProtectedAccess] to create abstract methods, so I can call the protected methods and this is working great.One of the protected methods references a field which is defined in the following way:protected Dictionary<int?, decimal?> availableQty = new Dictionary<int?, decimal?>();I know how to access protected properties and methods in a base class using the PXProtectedAccess attribute, but how can I access a protected field from an extended class? In standard c# this is simple, the inherited class has automatic access to a protected field, but this isn’t the case with the Acumatica framework. I’ve tried using PXProtectedAccess on a field but it displays a message saying PXProtectedAccess is only valid on ‘class, method,
Hello, I would like to override the method called ‘IssueAvailable’ in class ‘SOOrderLineSplittingAllocatedExtension’.The class is abstract so I’m not sure how to perform the override or even if this is possible.namespace PX.Objects.SO.GraphExtensions.SOOrderEntryExt{ [PXProtectedAccess(typeof(SOOrderLineSplittingExtension))] public abstract class SOOrderLineSplittingAllocatedExtension : PXGraphExtension<SOOrderLineSplittingExtension, SOOrderEntry> { protected virtual void IssueAvailable(SOLine line, decimal? baseQty, bool isUncomplete) { //acumatica code } }}The code for the original class and method is show above (I’ve removed the from the IssueAvailable method). The method is protected virtual so I believe i should be able to override this, but the class is abstract and uses [PXProtectedAccess]. I’ve not sure how to handle these. namespace PX.Objects.SO.GraphExtensions.SOOrderEntryExt{ public abstract class SOOrderLineSplittingExtension_Extension : P
Hi all,I need to get SOLine.POrderNbr filed to my custom smart panel . This customized smart panel consists fields of both SOOrder and SOLine DAC’s. But After adding the SOLine.POOrderNbr field, unlike other fields, it’s not visible in smart panel preview. When I checked SOline DAC, it shows that the POOrderNbr field is not existing in DataBase. How can I set this kind of fields into my custom screen? Appreciate if you can help on this as well. Thank you.
I’m working on a customization to add customer groups for discounts. The goal is that multiple customers and multiple items (with adjusted pricing) can be added to a “Customer Group” that can be maintained and edited as needed. Currently I have 3 DACs for my master (JptCustomerGroup) and detail (JptItem & JptCustomer) relationship. Once the user adds items / customers to a group, they get saved to a new table, JptCustomerGroupCustomer that stores relevant customer ID’s / items and their adjusted prices.So far, I’m able to create new groups with my “Add to Group” action. the relevant data is than stored to the database (in JptCustomerGroupCustomer): However, no matter what I seem to do, I can’t get the detail grids to refresh when I choose a new Group with the “GroupID” selector in the master part of the form. I messed around with callback commands a bit and was able to get the items to update, but then the customers wouldn’t properly refresh, or the items would get messed up when a
Hello Everyone,In the Balances info on the Projects screen, by default the data is grouped by AccountGroup. I need to group by the records using the ProjectTaskId, so I have created a custom field for ProjectTaskID on the PMProjectBalanceRecord DAC.For these changes, I used the base ViewDelegate, to which I have added the PMTask Table to the BQL and grouped by the ProjectTaskID; however, during debugging, getting the records as needed but, on the screen, I am getting the duplicate records.Below is my Duplicate Records Screenshot and the code behind for the BQL. Please help if there is anything wrong in the approach.public class ProjectEntry_Extension : PXGraphExtension<PX.Objects.PM.ProjectEntry>{ [PXCopyPasteHiddenView] [PXVirtualDAC] public PXSelect<PMProjectBalanceRecord, Where<PMProjectBalanceRecord.recordID, IsNotNull>, OrderBy<Asc<PMProjectBalanceRecord.sortOrder>>> BalanceRecords; private re
On the generic inquiry Production Order Maintenance, I’ve added column which is a multi-select field (Production Line(s)). “Production Line(s)” is a custom field on InventoryItem. On InventoryItem, I am storing the IDs of the production lines as a comma-separated string (eg. 1,4,5). When I try to filter the Production Order Maintenance GI, the filter misbehaves.The results will sometimes show blank pages (although I know there are rows that match the filter) and the record count will show something like “1 to 0 of 1151” Has anyone tried something like this? Is there a way to get this to work?
We are trying to create a concept of a Customer Group assignment. These groups would link many items/prices with many customers. We want these customer groups to be eligible for agreed upon pricing for a list of items where the total purchase qty would be added together to meet the agreed upon purchase quantities.Additionally, customers in this group may designated some of their distributors or their customers to also be able to purchase these same items directly at the same prices and be included in the total qty purchased reporting. If any partners have ran into the same issue with their customers, or if you have any suggestions on how to do this in Acumatica, please comment!
Hi,I have a new tab Called ‘Discount’ in my custom screen. In the grid level of this tab, I need to set values taken from ‘Discounts’ screen under the Profiles of Receivables workspace. First I set pxselector to DiscountCode field to set the value DiscountSequence.DiscountID. Then I need to set Sequence ID related to the discountID which already set. To set SequenceId from DiscountSequence.SequenceID, I defined pxselector for sequence id like below.[PXSelector(typeof(Search<DiscountSequence.discountSequenceID, Where<DiscountSequence.discountID, Equal<Current<APProformaDiscount.discountCode>>>>))]ref: APProformaDiscount is the DAC for the Discount Tab.but when click on selector, it shows nothing even there is a sequence Id for each discount code.can someone help me to resolve this issue please?thank You.
Hi Expert. I use RowPersisting to validate row and set error by:PXUIFieldAttribute.SetError<EPTimeCardSummary.earningType>(cache, row, null); cache.RaiseExceptionHandling<EPTimeCardSummary.earningType>(e.Row, row.EarningType, new PXSetPropertyException(String.Format(ConstantsEP.MsgEarningType, item.EarningType, contr.ContractCD.Trim(), PXErrorLevel.Error))); Now i want show error field in multi row (above image). How i do that? Thank you so much.
In the PX.Objects.EP.TimeCardMaint class I would like to add additional fields to the ‘EPTimecardDetail’ DAC. I created a new DAC Projection inheriting from EPTimecardDetail, this seems to work well. My issue is in trying to replace the Activities data view in TimeCardMaint with my extension.I thought PXSubstitute might work but it does not. [Serializable] [PXCacheName("EP Timecard Task")] [PXSubstitute(GraphType = typeof(TimeCardMaint), ParentType = typeof(EPTimecardDetail))] [PXProjection(typeof(Select2<PMTimeActivity, LeftJoin<CRActivity, On<CRActivity.noteID, Equal<refNoteID>>, LeftJoin<CRCase, On<CRCase.noteID, Equal<CRActivity.refNoteID>>, LeftJoin<ContractEx, On<ContractEx.contractID, Equal<CRCase.contractID>>, LeftJoin<PMProject, On<PMProject.contractID, Equal<PMTimeActivity.projectID>>>>>>>), new Type[] { typeof(CRActivity) })] public partial class EPTimecardTaskExt : EPTimecardDetail
Hello!I am attempting to add some conditional formatting on the SO Order Details grid where the SO Lines are viewable when looking at a Sales Order.I have implemented a customization on the SO Order Entry graph which calculates the mark up of each line amount over total average cost of the line, which then puts this number into a custom field on an SO Line DAC Extension.I want to highlight the SO Line rows in red where the the custom field(usrMarkupPct) is less than 0.1.Everything I am finding says to edit the ASPX file of the Sales Order screen but I am not sure that is the best way to do this.Does anyone have any experience with applying formatting conditionally to SO Lines?As always, any help will be greatly appreciated!!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.