Develop Customizations

Hi everyone, I wanted to bring to everyone’s attention the following two modules that I created to help work with site installations as well as deploying acumatica customization packages. First off, the AcuInstallerHelper. This powershell module is a wrapper for AC.exe,  and integrates with builds.acumatica.com to download and install different Acumatica versions. You can configure what directories you want the installers and the sites to install into.https://github.com/lekker-solutions/acumatica-installerHelperSecond, the Customization project tools package. This is a powershell module that interacts with both the services.asmx as well as the rest API endpoints for managing customization projectshttps://github.com/lekker-solutions/acumatica-customizationProjectTools Both are under the MIT license, so feel free to do with them as you wish!   

By passing some field from purchase receipt screen to receipt screen like below when release action in purchase receipt 

When I publish my customization, several fields do not show in the grid by default.  I want all columns in my grid showing by default.  When the customer publishes the package, I don’t want them to have to open the screen and manually add the columns to the grid. This is the list of columns in the project editor.Is there some setting that is making the three fields on the left not be included by default on the right?  I don’t see any options in the editor that would seem to handle this. 

I got this error \App_RuntimeCode\VendorMaint.cs(38): error CS0104: 'BAccountExt' is an ambiguous reference between 'PX.Objects.CR.BAccountExt' and 'PX.Objects.GDPR.BAccountExt'

I want to generate AR Aging report age based on a customized date field which added to invoice screen. Please check the below screenshot.So I think that to achieve this i have to add this custom data field to the “Age Based On” dropdown in the Statement Cycle screen. Please check the below screenshot.So can I know if is this possible and if it is possible how to perform it?So far I followed several previous community posts. However, it is confusing how to inherit the default workflow. So can you guys provide me some guidance to overcome this?Followed Posts    

All, the latest customization package I published left a minor bug that wasn’t apparent until a week later.Is it possible just to unpublish that single package? By looking at the screen, it seems as though you have to unpublish everything at once.Am I crazy, or is there a way to just unpublish a single customization package?

protected void Vendor_UsrAccountName_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)        {            var row = e.Row;            if (row == null) return;            Base.BAccount.Current.VStatus= "I";        }How can I invoke event that field ?

Hi, I have tried setting up a new System Email Account for a client, but when I go to test it, I get the error shown below. I tried setting it up using my own business email and it worked perfectly, so I was wondering if you had any ideas as to why this client email isn’t working? I should also note that this email has been created by the client’s IT Department recently for the purpose of sending emails from Acumatica. Let me know if I can provide any other information. Kind regards,Andrew  

I have created a custom field called GTRInvoice in my sales orders table and my invoices table and I would like that field to copy to the invoice when it is created from the sales order. I Cannot find any existing examples of how to do this that show the working code.I did override the  SOInvoiceEntry InvoiceOrder method but it is not the same as the old examples.This is what I have    public delegate void InvoiceOrderDelegate(InvoiceOrderDelegateArgs args);    [PXOverride]    public void InvoiceOrder(InvoiceOrderArgs args, InvoiceOrderDelegate baseMethod)    {      baseMethod(args);    } Any help is greatly appreciated.

I have a screen called Transaction Entry.When a certain criteria on a related Sales Order is not met, Transaction Entry should be read-only. And I’d like to let the user know that the condition on the Sales Order has not been met.Currently I’m using RowSelected to test for the condition on the Sales Order. If it fails, then I’ve been setting e.Cache.AllowUpdate = false. In addition, I have been setting:e.Cache.RaiseExceptionHandling<MyDac.transactionNbr>(e.Row, e.Row.TransactionNbr, new PXSetPropertyException(“Condition failed”))I’ve used this elsewhere so that the user can see the red X and know why they can’t edit the record.BUTSince RowSelected is fired while I’m creating the record when the Sales Order condition hasn’t been met, my code is throwing the exception.So, is there a more correct way to alert the user when they pull up a record as to why they cannot edit the record?At this point it feels like it will be easier to create a PXAction button that I can show/hide and giv

I have this error when deploying default event for FieldSelecting(No changes made yet). It is also happening with other events for ARDocumentResult

Hello,I am trying to setup Device Hub to print a label for a file folder on an action. However I keep getting 2 errors which I cannot figure out what is causing them. Here are screenshots of the errors.I am running DeviceHub as administrator on my device and I have given the user admin access rights. With the User, I am able to access the Printers page, Print Jobs page, and the report I am trying to print. Here is the code of the action:protected void printFileLabel() { PMProject project = (PMProject)Base.Project.Current; Dictionary<string, string> printParams = new Dictionary<string, string>(); string projectID = project.ContractCD.ToString(); string projectIDDash = $"{projectID.Substring(0,2)}-{projectID.Substring(2,6)}-{projectID.Substring(8)}"; printParams["ARRetainageReportParameters.ProjectID"] = projectIDDash; string actualReportID = "PM6210LB"; SMPrinter printer = PXSelect< SMPrinter, Where<SMPrinter.printerName, Equal<Required<SMPrinter.pri

Good day,I am working on a sequence for customer location that executes when the button is pressed. I can’t use AutoNumber Attribute because I need to be able to manually enter customer locations as well. The sequence works correctly in Numbering sequences screen, but in Customer Location I am having 2 issues, when I press the button and does the sequence, then I press the save button and it does save the new record but the save button stills available to be pressed even when I already saved and didn’t made any changes, and the other issue I will explain it with an example, if I made a customer location with the sequence, and the number is 1579, I save the record and then if I need to create another customer location for the same customer I press + and the button and what happens is that in the numbering sequence screen it does well the sequence, now the Last number is 1580 and if you save the location it saves 1580 but in customer location screen the button is retrieving the first cus

 I create PO from this code            RQRequisitionEntry instance = PXGraph.CreateInstance<RQRequisitionEntry>();            instance.Document.Current = ii;            instance.createPOOrder.Press();            instance.Document.Current.OpenOrderQty = new Decimal?(0M);            instance.Document.Current.Released = new bool?(true);            instance.Document.Current.Status = "E";            instance.Document.Update(instance.Document.Current);            instance.Save.Press();And after I debug the requisition.ReqNbr have value but query always return nullPOOrder pOOrder = SelectFrom<POOrder>.Where<POOrder.rQReqNbr.IsEqual<@P.AsString>>.View.Select(this.Base, requisition.ReqNbr); and check database value of this po is still null. I think instace.Save.Press() not save to database yet. So how to save po to db

Example one base screen is available in acumatica screenID: SO503050 & graph name: SOPickingWorksheetProcess for List button

Hello Community,in CRCase there is a field called “Priority” it uses the CRCasePriorityAttribute to get its values from a PXStringList. Now I want to values to be stored into the DB by a DAC.I created the DAC and I also tried building a DAC Extension on CRCase.However it seems it doesn’t work.So far the Extension looks like this:public class CRCaseExt : PXCacheExtension<PX.Objects.CR.CRCase> { #region Priority [PXDBString(1, IsFixed = true)] [PXDefault('M')] [PXUIField(DisplayName = "Priority")] [PXSelector( typeof(Search<CRCaseMyPriority.priorityId>), typeof(CRCaseMyPriority.priorityId), typeof(CRCaseMyPriority.priorityValue), typeof(CRCaseMyPriority.sortOrder), DescriptionField = typeof(CRCaseMyPriority.priorityValue) )] public virtual String Priority { get; set; } #endregion }When I publis this the DropDownList of the Priority gets empty and no values are there to select.The DB however is populated and also the

Hello, could you provide some guidance on how to maintain the status of a sales order as 'open' even after we've issued the invoice? This specifically applies to orders containing special items. I've already included a checkbox labeled 'Is Special Item' on the sales order screen, and I thought it might assist in achieving this situation.The rationale behind keeping the order in an 'open' status is to allow it to be marked as 'complete' only when the order associated with a purchase order (PO) has arrived at the warehouse.

Hi, i have Created a form and grid in a popup of action methrod. i have added a selector to the form and when i select a value from selector, grid gets triggered and its working fine, now i want to add another selector and that selector should trigger the same grid,   any help is highly appreciatedThanks in advance

I wish to display a smart panel showing some fields of a custom DAC but I'm faced to an issue I don’t succeed to understand : none of the fields in the smart panel is editable whereas I'd like the user to be able to modifiy some of them.Note : The action calling the smart panel is invoked using the 'LinkCommand' attribute from one of the column of the grid.Has anyone an idea about what’s going wrong ?ThxHere is my code snippet :1) The DAC EAPInvoiceSee embedded file EAPInvoice.cs.Below, the declaration of one of the field I’d like to be updatable.        [PXDBInt()]        [PXUIField(DisplayName = "Branch", Visibility = PXUIVisibility.Visible)]        [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]        [PXSelector(typeof(Search<Branch.branchID>),            typeof(Branch.acctName),            SubstituteKey = typeof(Branch.acctName))]        public virtual Int32? BranchID {get; set;}        #endregion2) The view as declared in the BLCpublic SelectFrom<EAPInvoice>

I created a Processing screen.  The grid is populated with SO Lines based on the filter. In the grid of items being processed, the Order Number is visible:When processing is complete, the Order Number is not displayed in the results screen:I added the SO number in the Message as a workaround, but I don’t know why the SO number is not showing in the results screen.I also noticed that as soon as I click PROCESS ALL, the grid is refreshed and the SO Number and Customer info is cleared from the grid during the processing.This is the select that shows the data in the grid. [PXFilterable] public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderType, Equal<SOLine.orderType>, And<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>>, OrderBy<Asc<SOLine.orderNbr, Asc<SOLine.lineNbr>>>> SOLinesToUpdate;The primary table has to be SOLine as that is what is being processed in the delegate: public S

Error: An error occurred during processing of the field RefNbr: Error: 'RefNbr' cannot be found in the system.  Stack Trace: PX.Data.PXSetPropertyException: Error: '[RefNbr]' cannot be found in the system. at PX.Data.PXSelectorAttribute.throwNoItem(String[] restricted, Boolean external, Object value) at PX.Data.PXSelectorAttribute.Verify(PXCache sender, PXFieldVerifyingEventArgs e, Object& item) at PX.Data.PXSelectorAttribute.FieldVerifying(PXCache sender, PXFieldVerifyingEventArgs e) at PX.Data.PXCache.OnFieldVerifying(String name, Object row, Object& newValue, Boolean externalCall) at PX.Data.PXCache`1.FillWithValues(TNode item, TNode copy, IDictionary values, PXCacheOperation operation, Boolean externalCall) at PX.Data.PXCache`1.FillWithValues(TNode item, TNode copy, IDictionary values, PXCacheOperation operation, Boolean externalCall) at PX.Data.PXCache`1.Update(IDictionary keys, IDictionary values) at PX.Data.PXGraph.ExecuteUpdate(String viewName, IDictionary k

Hello everyone, My apology for the lengthy question here but it needed to provide all pieces of the information someone might need to help.Also I have checked out these links:https://stackoverflow.com/questions/49264233/how-to-create-master-detail-grids-in-acumaticaand https://asiablog.acumatica.com/2019/04/grids-master-detail-relationship.htmlI am having a hard time understanding why deleting one record in the Parent Grid, deletes ALL records from the Child Grid instead of deleting only the records tied to that parent record. I have created a new screen made of Form-MasterGrid-ChildGrid. See the attached screenshot please.When I navigate in the Form the Master Grid refreshes correctly and when I navigate in the Master Grid, the Child Grid refreshes correctly as well. The only problem I am facing is when I delete a record from the Master Grid, the system instead of deleting only the deleted Master Record children, deletes ALL records in the Child Grid.Here are my partial DACs (Key Fiel

how to check two DAC values is equal in acumatica using if condition? ex: If the preferred warehouse is not matched between the sales order and transfer, it should not allow me to key the transfer ref no in the sales order line,Likewise, the SOnbr should not show in the transfer record eitherIf the preferred warehouse is not matched between the sales order and transfer, it should not allow me to key the transfer ref no in the sales order line,Likewise, the SOnbr should not show in the transfer record either

Hi Everyone, I’m currently customizing the ProjectEntry graph where I added a custom table to the tab. In my custom table, I have defined a date field, where I declared a default date [PXDefault(typeof(AccessInfo.businessDate))], but when I create a new empty project, I want to fill the date field with current date. Can anyone help me how to implement this? #Custom field from a custom table#region IBqlTable    [PXDefault(typeof(AccessInfo.businessDate))]    [PXDBDate()]    [PXUIField(DisplayName = "Date MOB Promised", Required = true)]    public virtual DateTime? DateMobPromised { get; set; }    public abstract class dateMobPromised : PX.Data.BQL.BqlDateTime.Field<dateMobPromised> { } #endregion #region Data Viewpublic SelectFrom<ProjectCustomFields>.            Where<ProjectCustomFields.contractID.IsEqual<PMProject.contractID.FromCurrent>>.View MyProjectCustomFields;#endregion I have tried to override the Initialize method but still no luck.public PXSelect<P