Develop Customizations

Hello Is Multi-Combo Select Available in Parameters in Report Designer? Thanks

I wrote a customization to add a link for any files uploaded to a SO Line item into a Production Order.It works, but I am breaking all kinds of rules.  I am not supposed to update a cache or do BQL statements in the RowSelected handler.  The goal is that each time a Production Order is opened on screen AM201500, I do a check against the SO Lines related to the Sales Order for that Production Order and create links to the “Files” on the Production Order.  Each SO Line could have multiple attachments and we want those attachments available on the Production Order.  Also, there is most likely a better way to accomplish this regardless of which handler I use, but this is the only way I know to do it. I would appreciate any inputs/critiques you might have.          protected void _(Events.RowSelected<AMProdItem> e)        {            var row = (AMProdItem)e.Row;            if (row.OrdNbr != null)            {                using (new PXConnectionScope())                {            

Hello,Regarding the Attributes screen and setup (CS205000). This is a great way to add custom fields to something, such as business account profiles.However there a way to make attributes an option on the Activities screen, and for the individual Activity types?So that if Activity Type X is chosen, there is an option to add an attribute regarding that Activity Type.Is this possible? 

I have created a Custom Filed on the Production Order called Job Number. Historically we have used this work with complex Parent Child issues (Yes I know we could use Product Number however we manually assign these job codes) I want the Job Number to auto populate on the linked order. What is the best way to accomplish this? 

Hello,How do I customize the behavior of Role and Type under Relation tab of Business Account? I add new role via Automation Steps below but how can I default a Type based on Role selected? For example if IT Consultant is selected in Role the default Type is Prospect.  

Hello,          With other’s help, I was able to add a selector of employees on shipment screen.I’ve created an employeeclass (Which is referred to VendorClassID in DAC) named “PICKER”,I’d like to limit the selector only shows the employees from “PICKER”,I write the below code, but it gives out errors: [PXSelector(typeof(Search<EPEmployee.bAccountID,Where<EPEmployee.vendorClassID,Equal<"PICKER">>>), typeof(EPEmployee.acctCD), typeof(EPEmployee.acctName), typeof(EPEmployee.vendorClassID),SubstituteKey = typeof(EPEmployee.acctCD))]         What is the right way to write the codes. Please advise. Thank you.

Hi,I developed one new Screen Consist of OrderNbr and RevisionNbr fields as two Primary Keys(Same as Kit Assembly/Specification revision Functionality).For first time I am able to save the data with OrderNbr -0001 and RevisionNbr-1.If I change the RevisionNbr as 2,Then I am Inserting Data of RevNbr-1 to RevNbr-2.But When I am saving OrderNbr -0001 and revisionNbr-2 error is getting ”Another Process has Added To TableName,Your changes will lost”.This error is Getting only in 20R2, But Its working in 19R2.Could you pls provide any solution to resolve this ?ThanksGiri.  

Hello,     Previously, I’ve added a caculation field on shipment, and it is non-persisted.Now, for reporting purpose, I’d like to make it as a DB persisted field.      Is there an easy way to do it? 

Hopefully this isn’t a repeat of something but… is there a way to add multiple Activities to a Sales Order’s Detail Line?In this particular case, I’d be inserting the data via an API so I’d have access to information not normally attainable by a user, like the actual id of the line and not just the sort or row number.It would be grand to be able to see/access this information by clicking on a custom icon per Detail Line but it would also be acceptable if the records were simply accessible by the Activity feature at the top of the SO screen. Thoughts? Has anyone already done something like this? ;-)

I have created a screen to change items in a sales order using a processing screenThe top of the form has two fields, the “From” item and the “To” item.When you kick off the PROCESS ALL, I need to have the values in those fields available to the process delegate.  Since the UpdateOrders delegate is static, I don’t know how to get the from and to item numbers.  I’ve tried creating public properties and setting the values of the properties on the rowselected event.  But when UpdateOrders fires, and ultimately fires the UpdateOrder method, the properties are null.  In the code below, I hard coded the inventoryID’s just to verify the code actually changes the sales order and it works great.  I just don’t know how to access the values in the top of the screen in the code. ItemNumberToChangeFilter filterValues = Filter.Select();  returns nulls. Other than that, I’m almost done!  :-)        public PXFilter<ItemNumberToChangeFilter> Filter;        public PXFilteredProcessingJoin<SOOrd

I have searched this forum and stackoverflow but I cannot find anything on how to hide the “Schedules” button on the processing screen.  Does anyone have any way to do it?This has no effect: 

Hello Everyone,We have specific requirement to increase the TaxZoneID length  from size 10 to 30  from TaxZone table.Since, this field is having dependency with many table fields, unable to modify the length and giving SQL error is ALTER TABLE ALTER COLUMN taxzoneid failed because one or more objects access this column.. I know that we can drop the Foreign Key relationships and make it work but I don’t think this proper way of doing in Acumatica database. Hence posting this question here and seeking for help.Can you please help me with this?

I am going to create a program to allow a user to change an item number on all open Sales Orders.  They want to do mass updates to change item numbers on SO’s.My plan is to create a process screen that would allow the user to select the item number to change in the header of the form as a filter.  Then, a grid would be presented showing all SO’s that have that item number on it.  They will have the option to select individual orders to change or “process all”.I think I should create a DAC that is made of all unbound fields as this does not require any custom tables and I will not be writing to any tables directly as I will be using the SO graph to do the changes.  My DAC would just be used to create the view for the grid.Does that seem like the way to do this?  Or, does anyone foresee any issues I would have creating a DAC using just unbound fields?Thanks!!Joe

Has anyone played around with tooltips and doing multiple lines.  We want to add some helpful information for new sales reps to understand the different statuses of sales orders (and other fields).  To do that, we want to put each status on a line of the tooltip for status along with a definition.  The problem is that we can’t get any new line trick to work.  We have tried all of the following without any luck.  Any other suggestions? <br />
\n 

When we add a link to the “other information” field of an appointment, it is not clickable in the mobile app. It appears in the comment section, but when you touch to open the comment section, the entire field is editable and the link is not editable? What we are trying to do is provide a link to a project collaboration web tool that we have within the corresponding appointment in Acumatica (for the techs). Is there a way to do this at all without customization?   

Hello Everyone,We are unable to login to Acumatica instance due to this error: The type initializer for 'PX.Data.PXCache' threw an exception.Can anyone help me to resolve this issue.Thanks in advanse.   

Hi,I developed new screen. Inside that added one new Field “Labor Time Hrs” which consist of PXTimeList Attribute.Currently PXTimeList is showing up to 24:00 Hrs.How to customize that Field to show More than 24 Hrs in a Time dropdown.ThanksGiri.

Hello all, How would I go about changing the default value in the customization project for a specific field on a form?  I though it would be under this section, but I haven’t had any luck so far.

I have created a new form tab screen(Project Sub Tasks) which consists of two tabs, Bill of Quantities and Sub Contractor quotes.What I would like to achieve is, when I have added a new record to one of the tabs, to write it to the project’s cost budget it’s associated with. I have tried the following code:        // 1. Create an instance of the BLC (graph)        ProjectEntry graph = PXGraph.CreateInstance<ProjectEntry>();        protected void _(Events.FieldUpdated<PMBillOfQuantity, PMBillOfQuantity.amount> e)        {            var row = (PMBillOfQuantity)e.Row;            // 2. Create an instance of the DAC, set key field values (besides the ones whose values are generated by the system),            //    and insert the record into the cache            PMCostBudget CB = new PMCostBudget();            CB.AccountGroupID = 35;            CB = graph.CostBudget.Insert(CB);            // 3. Set non-key field values and update the record in the cache            CB.Amount = ro

Trying to figure out a solution to create shipments on multiple sales orders and print them all at once vs. going into each sales order individually and creating the shipment then using quick process. Ideas?

Howdy! I figured it might be wise for me to introduce myself before diving into my call for help… I’m a home brewed IT/Developer/Operations Manager that’s responsible for integrations between Acumatica and our internal systems that I’ve built over the years. I’m not a “professional” by any regard though I do great deal of practical experience with coding online applications, PHP, AngularJS, Classic ASP VB, MS SQL, etc. side note, I’m really enjoying and admire how Acumatica’s been built and functions. moving on… We’re currently in the process of rolling our Acumatica 2020 R2 for our company through a phased approach and will be utilizing multiple tenants for the purposes of development, training, etc, 5 in total including our live/production tenant. The idea is that we will, periodically, schedule a snapshot of our Live tenant and restore it into the other tenants.The users will be disabled in some tenants and enabled in other while others will have increased security access into one o

I am not a good programmer so please feel free to tell me all the things I could do better…  :-)I am working in 2021R1.I have a field that I am validating to make sure that it does not exceed a total amount on the header record.  My screen is functioning properly, but I should be getting a warning indicator, not an error.My RaiseExceptionHandling is set at the Warning level BUT, I get a red X on the screen.  What am I doing wrong here?         protected virtual void _(Events.FieldVerifying<GRGrantsCustomers, GRGrantsCustomers.allocatedAmount> e)        {            GRGrantsCustomers row = e.Row;            GRGrants grant = Grant.Current;            decimal? newValue = (decimal)e.Args.NewValue;            decimal? total = 0;            foreach (GRGrantsCustomers item in Customers.Select())            {                total += item.AllocatedAmount;            }            if (total - row.AllocatedAmount + newValue > grant.GrantAmount)            {                decimal balanceB

Good day,I’ve been noticing some comments on database creation scripts such as 'sy_guid;' / 'si_autoincr;' / 'sy_boolean;', and have wondered what they mean/do.I think they might have something to do with easing things up when a DAC is generated via the Customization screen, but I’m probably completely wrong So… Does someone know what they mean, and more specifically, are there more ‘indicators’ like these that I can use?Thanks in advance.

Hello Everyone,I have created a custom inquiry screen with pagination, which will load the POReceipts by applying a few conditions.After applying the pagination code records are loaded very fast and working as expected expect the below scenario.Issue details.When I filter a grid column, it is filtering and showing only the current page records but the filter is NOT applying to all the records. Could you please help me with this?Ex: If I have total of 900 records and per page, if it is showing only 25 records. When I apply a filter to the grid column, it is filtering by taking only 25 records but NOT 900. When I debug, PXView.MaximumRows is taking 25 records and filtering them.Sample Pagination Code:[PXFilterable] public PXFilteredProcessing<Customer, FilterDAC, Where<Customer.bAccountID, Equal<Current<FilterDAC.customerID>>, Or<Current<FilterDAC.customerID>, IsNull>>> Records; public IEnumerable records() {

Good day,I'm attempting to select multiple shipments on the Create and Print Pick Lists (SO503050) form using the screen-based API, but only the last one in the list is ever selected when performing the Process action.I'm able to populate the Header Filter section and am getting the shipments (as per the specified filters) back in the Content result.I'm also able to generate a worksheet using the Process Action, however, it only contains the last shipment that was iterated over and not the 4 shipments that are expected.Am I missing something? What are the commands needed in order to select more than 1 shipment, so that the worksheet contains more than 1 shipment?Please see below for additional information & code blocks.Any and all assistance will be highly appreciated .--------------------------------------------------------------------------------------------As can be seen in the screenshot below, the iterative section of the code is able to iterate over all of the shipments that