Develop Customizations

Hi Everyone, I wouldn’t mind some direction before I get stuck into this. In short I want a processing screen that performs a single action over all the selected records instead of one action per record.A bit of background first, our company doesn’t quite a manufacture our products, but we do build them using the kitting feature. (Packaging and labeling and basic assembly done in house etc) I have developed a customisation that takes a forecast of what we are expecting to sell (sale units) and it then calculates how much of the purchase components that we will need, compares this to our current inventory levels and then looks at things like the vendor lead time, safety stock etc and generates recommendations for what we should by and when. A small example of this looks like below (The actual run of this would have a lot more lines with larger spread vendors)We intend to run this with a fresh forecast every week, so while the plan may generate multiple purchase recommendations within th

Hi,I'm noticing more and more that there are big buttons in the mobile app. I wonder how to add some to my customization? for now the ones I'm adding are in the [...] button of top right.THANKSEmployee Time cardExpense Claim 

I get this error. Who can help me how resolve this problem? 

Hi Team,I want to know, how we can split Tax entry into multiple line in Journal transaction.For example, I have a Tax amount of 5$, while posting into journal entry, it should be splitted into 5 lines with 1$ each. Could you help me on this.I tried to customize using row inserting events, but I’m getting “Document Out of Balance” error. Regards,Ramya

Hi, I’m running into an issue where I’m trying to get the first value of Alternate ID in the mobile app but it’s not showing. Is there anyway where I can get the first value of Alternate ID for each Inventory ID. I’m trying to do this modification for the service orders screen in the mobile app.  

hi Todays date defaults on Gi even though it has no default value. How can i remove this to empty box? Below is the screen shot   

Hi Team,Could anyone let me know the procedure to add “Activity” Tab in a new screen. Regards,Ramya

Hi,iam pulling SOLines items in a new grid using Soline view, but i Dont need all the SOLines and i need to apply a  filter, How can i modify my view to acheive that? any help is greatly Appriciated Thanks in Advance

We had a fairly complex workflow defined via the GUI in Customization Projects, but the last upgrade gave us a lot of errors trying to upgrade the workflows for custom screens.  The recommendation was to move from GUI based workflow to Code based workflow, so I’ve been learning about writing custom workflows via code in Visual Studio and even wrote a series of blog posts on my personal blog to share my “one step at a time” learning approach for the basics of coded workflows.Although almost all of our workflows have been converted to code, one challenge still stands in the way.  Auto-Run Actions.   We have 2 actions (1 per screen on 2 different screens) that need to run automatically under a specific condition.  We had them working in the GUI version, but I cannot find how to code this in the workflow.  The only examples in the code repository are for InitializeState, but “copy cat” programming isn’t giving me any results on this one.GUI versionThe action called is defined as PXAction i

I have a custom unbound field on the Kit Specifications grid UsrQtyOnHand.   public class INKitSpecStkDetExtCummings : PXCacheExtension<PX.Objects.IN.INKitSpecStkDet> { #region UsrQtyOnHand [PXDecimal] [PXUIField(DisplayName = "Qty On Hand", Enabled = false)] [PXDefault(typeof(Search<INItemStats.qtyOnHand, Where<INItemStats.inventoryID, Equal<Current<INKitSpecStkDet.compInventoryID>>>>), PersistingCheck = PXPersistingCheck.Nothing)] [PXFormula(typeof(Sum<INItemStats.qtyOnHand>))] public virtual Decimal? UsrQtyOnHand { get; set; } public abstract class usrQtyOnHand : PX.Data.BQL.BqlDecimal.Field<usrQtyOnHand> { } #endregion }I want to go to the INItemStats table and pull the QtyOnHand value for the current inventory id on the grid line.I can do it in the row selected handler, but I don’t know why my PXDefault is not working.I added a PXFormula but that didn’t hel

I published customization in a production tenant, assuming it would add the new screens to the test tenant also. It did not, so attempted to publish in test tenant. I got the error below:I then unpublished in the first tenant, then tried publishing in test. Same error. I found this: acumatica - Error when attempting to Publish Customizations (Cannot access the uploaded file) - Stack OverflowI located the missing file within the customization, but I don’t understand what the above post means by “remove file link reference”. Nothing I’ve tried works. I tried deleting the file itself and re-uploading, but it says invalid file type. Then I found this: How to resolve the 'Cannot access the uploaded file' error on publishing a customization project | Community (acumatica.com)Tried and didn’t work. I’m sure the missing file I found is the problem, but I can’t figure out how to fix it. Anyone know?

Hi, I created a new form and add a grid control. I added all necessary fields but when I try to use the column header filter and click the enter key, the grid refresh but do not filter the grid. If click the ok button, the grid filter successfully. How I can fix it?In other Acumatica windows works well. thanks,EV

I’m having trouble figuring out the code to allow me to modify the workflow of preventing a field from becoming disabled at shipment confirmation. The field I want to allow edit’s is ISPSUCC128 Here is the code I’m attempting to use but I’m getting a validation error   public class SOShipmentEntryExt : PXGraphExtension<SOShipmentEntry>    {        protected virtual void SOShipment_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler)        {            InvokeBaseHandler?.Invoke(cache, e);            SOShipment row = e.Row as SOShipment;            if (row != null)            {                Base.Document.Cache.AllowUpdate = true;                PXUIFieldAttribute.SetEnabled<SOPackageDetailEx.ISPSUCC128>(cache, row, true);                            }        }    } Thanks,Justin

I have extension code like this    #region StateID    [PXDBString(50, IsKey = true, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "State ID")]    [PXDBDefault(typeof(State.stateID))]    [PXParent(typeof(SelectFrom<State>.        Where<State.stateID.        IsEqual<District.stateID.FromCurrent>>))]        public virtual string StateID { get; set; }    public abstract class stateID : PX.Data.BQL.BqlString.Field<stateID> { }    #endregion and in other custom field, I want to select district from state but in district, I cannot filter it by state field. What am I missing ?    #region UsrDistrict    [PXDBString(50)]    [PXUIField(DisplayName="District")]    [PXSelector(typeof(Search<District.districtID,Where<District.stateID,Equal<Current<State.stateID>>>>),            typeof(District.districtID),            typeof(District.name),            DescriptionField = typeof(District.name))]        public virtual string UsrDistrict {

I try to customize by using pxsplitcontainer, everything working fine but only delete in second grid not show save action    <px:PXSplitContainer runat="server" SplitterPosition="250" ID="splitConditions" Orientation="Horizontal">      <AutoSize Enabled="true" Container="Window" />      <Template1>        <px:PXGrid runat="server" ID="grid11" Height="150px" SkinID="DetailsInTab" Width="100%" SyncPosition="True" Caption="Province">          <AutoSize Enabled="True" MinHeight="150" />          <Levels>            <px:PXGridLevel DataMember="CountryStates">              <Columns>                <px:PXGridColumn DataField="StateID" Width="200px" AllowShowHide="False" />                <px:PXGridColumn DataField="Name" Width="350px" AllowShowHide="False" />                <px:PXGridColumn DataField="SalesTerritoryID" LinkCommand="<stub>" Width="100" CommitChanges="true" />                <px:PXGridColumn DataField="S

Dear ALL,How to change the format of date fields on screens to: DD/MM/YYYY  Is there any way to change the format of date fields on all screens in the simplest way? Best Regards,NNT

Has anyone successfully added an existing screen not normally in the mobile application using the new Mobile Workspaces Screen? Prior to go-live we had added the SOShipment screen SO.30.20.00 to the app to allow the shipping team to upload photos of outbound pallets to the shipment. This worked beautifully until the upgrade but the screen is now not showing in the drop down to add to the list of items on the WAREHOUSEMANAGEMENT workspace. I can’t find anything in the help about what to do if the screen does not show in this list.There is no error in publishing the page via the customization package.Any help/advice on what to try next is greatly appreciated

 I have a question related to an issue with SO Line Details Allocated flag. After the receipt is released for an SO line linked to PO, the Allocated flag is automatically set in the SO Line Details but unchecking and checking the Allocate flag again result in error, though the Allow Negative Quantity flag is set on the Item Class of the SO line Item and the “Ship in Full if Negative Quantity Is Allowed” flag is set on the Order Type:Have anyone faced this issue? I would like to note that the issue happens only if the Item Available Qty  is negative.      

Hi,I need to change what displays on the SO screen when selected a Location.    By default, it isLocationCD - Descr  We want to change it to LocationCD - AddressLine1I can add the field easy enough in the Selector, but how can I add it to the DescriptionField ?  If I change it toDescriptionField = typeof(Address.addressLine1),It just shows the locationCD on screen. I realize it is from a different DAC, so I guess the question is how do I get the info from the other DAC? Thanks in advance. [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.Location.locationCD), typeof(PX.Objects.CR.Location.descr), typeof(PX.Objects.CR.Address.addressLine1))][LocationActive(typeof(Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<MatchWithBranch<Location.cBranchID>>>), typeof(InnerJoin<Address, On<Location.defAddressID, Equal<Address.addressID>>>), De

Hi,I created a custom processing screen and is working as expected. I configured an schedule and is running fine, but in the Automation Schedule History window the total records always is zero.For the DAC I’m using an SQL View. public class NewWindow : PXGraph<NewWindow >{ public override bool IsDirty => false; public PXFilter<Filter> filter; public PXCancel<Filter> Cancel; [PXFilterable] public PXFilteredProcessing< ShipmentToProcess,Filter, Where<ShipmentToProcess.processflag,Equal<Current<Filter.processflag>>>> Document; public NewWindow () { Document.SetProcessCaption(PX.Objects.IN.Messages.Process); Document.SetProcessAllCaption(PX.Objects.IN.Messages.ProcessAll); } public void _(Events.RowSelected<Filter> e) { IUtilService serv = new UtilService();//inside this method I set the PxProcessing<class>.SetError or Info ... Document.SetProcessDelegate

I have had something similar to this happen before, and I really want to know what is causing it.Here is the scenario. I made some changes to our base customization package. It has NO MOBILE customization in it at all (and never has).We publish it to two different customers. (We’ll call them Customer Lucky and Customer Unlucky.)At Customer Unlucky,  the appointment header on the mobile app loses it Total Appointment Total field. At Customer Lucky’s the appointment screen on the mobile app was fine.They both had a separate Mobile Application Customization, that was identical (it added a button to the Appointment screen). Unpublishing this customization made no difference. Both were running the same version of the Web software and the same version of the Mobile software.WHAT IN THE WORLD IS GOING ON HERE???I was able to create a customization for Customer Unlucky, and add the Appointment Balance field back on to the screen, so there was a workaround. But I want to know why such a thing c

I want to join a table (EPEmployees) twice to get employee and supervisor info and based on the user logged in I want to show either only an employees customers or the supervisors customers + the employees that report to them. This is what I have tried among a couple other ways:public SelectFrom<Customer>      .LeftJoin<Address>          .On<Address.addressID.IsEqual<Customer.defAddressID>>      .LeftJoin<CustSalesPeople>          .On<Customer.bAccountID.IsEqual<CustSalesPeople.bAccountID>>      .LeftJoin<SalesPerson>          .On<CustSalesPeople.salesPersonID.IsEqual<SalesPerson.salesPersonID>>      .LeftJoin<Users>          .On<SalesPerson.descr.IsEqual<Users.email>>      .LeftJoin<EPEmployee>          .On<Users.pKID.IsEqual<EPEmployee.userID>>      .LeftJoin<Supervisors>          .On<EPEmployee.supervisorID.IsEqual<Supervisors.bAccountID>>      .Where<        Brackets

Hello,I am trying to embed a webpage into a tab item on an existing screen but it is not working. I am trying two different ways based on some code snippets I found. The first, utilizes standard containers and redirect exceptions (Redirect Option). The code gets validated but every time I go to check the output, I get the following: I checked to ensure that the website is iFrame compatible and it is so I am not sure why I am getting this if it has worked for others. Below is my code, very simple.. using System;using PX.Data;namespace SampleiFrame{ public class SampleIFrame : PXGraph<SampleIFrame> { public SampleIFrame() { throw new Exception("Redirect:https://**WEBSITE**.com$target=main"); } }}​​​​​​The other option is to just modify the aspx directly since I don’t need any standard containers. I followed the following code (ASPX Option). I haven’t been able to make this work in the validation stage because every time I update the aspx and