Develop Customizations

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!!

Hi all,I have a new customized screen . I’m adding sales orders to the grid of the screen taken from sales orders screen line level. To select sales order lines, I use a custom smart panel as below. As highlighted above,  I need to avoid loading sales orders when the status is ‘Cancelled’ to my smart panel. To accomplish that, can someone help me to modify the below view definition which I already use to get values form both SOOrder and SOline DAC’s to the smart panel or any other suggestion to do it?public PXSelectJoin<SOLine, InnerJoin<SOOrder, On<SOLine.orderNbr, Equal<SOOrder.orderNbr>, And<SOLine.orderType, Equal<SOOrder.orderType>>>>, Where<SOLine.customerID, Equal<Current<APProforma.customerID>>, And<SOOrder.customerLocationID, Equal<Current<APProforma.locationCD>>>>> POrdersView;Thank you.

Hi I am stuck at a very basic requirement, where i have to make this field required at screen level. Below is Original attributes for that field.Field Name : ExpirationDateData Class : PX.Objects.CR.CRQuoteOriginal Attributes: [PXDBDate(BqlField = typeof(Standalone.CRQuote.expirationDate))] [PXMassUpdatableField] [PXUIField(DisplayName = "Expiration Date", Visibility = PXUIVisibility.SelectorVisible)]I tried this by using CustomAttribute for both Required and Default : [PXMergeAttributes(Method = MergeMethod.Append)] [PXCustomizeBaseAttribute(typeof(PXUIFieldAttribute), "Required", true)] protected virtual void CRQuote_ExpirationDate_CacheAttached(PXCache cache){}and [PXMergeAttributes(Method = MergeMethod.Append)] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] protected virtual void CRQuote_ExpirationDate_CacheAttached(PXCache cache) { }but still the form is allowing blank values. Please note field is a datetime type.Please help

I’d like to add an import from Excel button to the Payments and Applications grid on screen: AR302000I can see some stuff online, but it’s ancient. For 2021 R1, how do you add that feature to a screen? I’m barely competent with things like PXSelect<>, so brace yourself for crazy questions :D Thanks,

Hello,I want to create new status value “Archive” to screen Invoices and Memo and enable this field when the status is Open so that End-User could change status to “Archive”I tried add new status value as instruction in topics  and use following code to enable Status fieldusing PX.Data;namespace PX.Objects.AR{ public class ARInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AR.ARInvoiceEntry> { #region Event Handlers protected void ARInvoice_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (ARInvoice)e.Row; if (row != null) { PXUIFieldAttribute.SetEnabled<ARInvoice.status>(cache, row, true); } } #endregion }}However, I can’t find new value in list dropdown valuesand fields Status is still disableCould you please help me? Regards,Khoi

Hello community!I need to get the users phone current longitude and latitude information and record it into a custom screen. What library should I use?  Is there any documentation for this?I appreciate any help you could give me

Noob question, I apologise in advance.On a sales order I have these two fields that I am trying to add to a report. I reference the first field in a report with=[SOOrder.CustomerOrderNbr]and it works perfectly.However, I reference the 2nd field in a report with=[SOOrder.ExtRefNbr]and it produces an empty column.If that field isn’t ExtRefNbr, how can I determine the field ID?thanks.

How can I create a file uploader on request screen on the summary area.see belowLike this one, but this one is only for images On the following screen Kindly assist.All responses will be highly appreciatedThank you 

The customer requested a checkbox on the 22R2 Task screen CR306020. It was easy enough to add but now I run into the old issue of allowing the field to be edited when the task is complete, as seen below:I used several posts on the community to do this on other screens but they always start at the workflow or automation step.The issue with this screen is there are no automation steps or workflows. I tried to add a workflow and it just spins forever.Where should I start?  

Hi, all.I’m currently trying to create a customization project which uses a .dylib file to tell the runtime which .dll to use (These .dll files are the same name however are in different folders x86 and x64). However, acumatica does not seem to read the file so the .dll which is referred is not found by the application. To fix this I can force the application to use a version of the .dll file which works by copying it out from the x64 folder to the Bin folder of the system so it can be found.Is there a better way to do this? Thanks.