Community
Discussion Forums
Develop Customizations

Develop Customizations

Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions

2,756 Topics
11,202 Replies

When you subscribe we will email you when there is a new topic in this category

2756 Topics

Recently active

Most replies Most views Newest first

ray20Captain II

asked in Develop Customizations

Is there a way to change customization field from "NonPersistedField" To "DBTableColumn"?

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?

3 years ago

jmckinnonJr Varsity III

asked in Develop Customizations

Activities per SO Detail Line

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? ;-)

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

How to pass values into a static processing delegate

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

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

How to hide the Schedules button on a processing screen

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:

3 years ago

Naveen BogaCaptain II

asked in Develop Customizations

Increase the Length of field - TaxZoneID

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?

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Looking for advice on how to create a new screen (easy question!)

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

3 years ago

RyanBrownXBYTEJr Varsity III

asked in Develop Customizations

Multiline tooltip

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 />&#013;&#010;\n

3 years ago

sean21Varsity I

asked in Develop Customizations

is it possible to use working links in the "other information" field of service orders/appointments that are functional in mobile?

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?

3 years ago

Naveen BogaCaptain II

asked in Develop Customizations

Unable to Login: The type initializer for 'PX.Data.PXCache' threw an exception.

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.

3 years ago

Giri KPro I

asked in Develop Customizations

how to get more than 24 hrs in a PXTimeList Dropdown Field??

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.

3 years ago

ggillFreshman I

asked in Develop Customizations

How to change default value for a field on a form?

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.

3 years ago

charlbester34Freshman I

asked in Develop Customizations

Copy into cost budget from new screen

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

3 years ago

michellec11Freshman II

asked in Develop Customizations

Creating and printing multiple sales orders at one time

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?

3 years ago

jmckinnonJr Varsity III

asked in Develop Customizations

Managing users across multiple tenants

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

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Getting a red X not a yellow exclamation for a warning

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

3 years ago

chris49Varsity II

asked in Develop Customizations

What does the 'sy_boolean;' / 'sy_guid;' / etc. comment in a database script mean?

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.

3 years ago

Naveen BogaCaptain II

asked in Develop Customizations

Pagination: Records NOT fetching properly in Custom Inquiry screen

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() {

3 years ago

chris49Varsity II

asked in Develop Customizations

Unable to select multiple Shipments on Process Form

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

3 years ago

jwestermann17Jr Varsity III

asked in Develop Customizations

Change Displayname from underlying field

Heyi would like to change a display name from a field within the attribute editorbut everytime i try to click on “Change Attributes” it shows i cant edit the attributes because the underlying field is a replacement. How can i edit it if this error message appears?i am looking since hours and cant find a solution.

3 years ago

mohamed1walhaJr Varsity II

asked in Develop Customizations

Problem in adding a new record by new endpoint

Hello, I have created a new screen with a new graph, Also I have created an endpoint with this screen. The problem persists when i want to save a new record by this API. In fact if the table in the database is empty he create a new record but when i have one record he edit it. Best regards.

3 years ago

jahnavik45Freshman I

asked in Develop Customizations

How can i override the process button in the Process order screen(SO501000)

3 years ago

DjangoCaptain II

asked in Develop Customizations

If I create a custom data provider in a .cs file, can I ask support to place it in App_Code?

As per the subject, if I create a custom data provider in a .cs file, can I ask support to place it in App_Code in the hosted environment? If not, how can I include it within a customization project so that it becomes available for use?

3 years ago

DjangoCaptain II

asked in Develop Customizations

Adding Branch column to Incoming Payments (AP301100)

The grid portion of the screen is coming from APTran so I tried adding Branch to the grid. However, the column remains invisible. I tried forcing Visible to True but that didn’t make it appear.Is there additional logic that’s hiding out somewhere preventing the Branch column from appearing?

3 years ago

sab

asked in Develop Customizations

Sending Sample Orders - Without Creating a Customer

I’m looking for feedback/ideas/solutions on if it is possible in Acumatica to send out a sample order from an Opportunity without having to create a customer or business account.The goal is to not create accounts aimlessly that are not TRUE purchasing customers.

3 years ago

Giri KPro I

asked in Develop Customizations

How do we achieve master-child relationship using Acumatica Warehouse management Scan Module?

We have a requirement to scan multiple vendor lot nbr for scan lot nbr.we have design screen like thiswe have used scan material and we are able to successfully scan on the master grid and we are not able to scan data on the child grid. what is the best possible way to achieve this??

3 years ago

Page 106 / 111

Badge winners

PatrickBaconhas earned the badge Easy talker
Dipak Nilkanthhas earned the badge Financials expert
kkraushas earned the badge Easy talker
ranjithduraisamy72has earned the badge Easy talker
jhoncandare04has earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.