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,738 Topics
11,125 Replies

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

2738 Topics

Recently active

Most replies Most views Newest first

mhapsJr Varsity III

asked in Develop Customizations

Display message in event handler

Dear community, I would like to show a message to the user from an event handler. In my case it is Events.RowInserted.I tried throw new PXException and PXSetPropertyException. Both are logged to the Trace but nothing pops up in the browser. Any help is welcome.

3 years ago

ray20Captain II

asked in Develop Customizations

How to tell order line is created by "create transfer order"(SO509000) screen in coding?

Hello, We have an existed code customization that to set order line warehouse field to user’s default warehouse setting (which is a customization field) The main codes are like below Users currentUser = PXSelect<Users, Where<Users.username, Equal<Current<AccessInfo.userName>>>, OrderBy<Asc<Users.username>>>.Select(Base); UsersExt userExt = PXCache<Users>.GetExtension<UsersExt>(currentUser); cache.SetValueExt<SOLine.siteID>(row, userExt.UsrDefaultW); It is working fine， however we don’t like it to work when creating transfer orders by screen “SO509000”. we’d like to leave the line warehouse to Acumatica’s original logic when processing transfer order creation on screen "SO509000" So, how can I tell the line is adding by request from “SO509000”?

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

Discard Changes and Close does not clear the cache with Generic Inquiry

I have a Generic Inquiry screen showing batches to post. When I select a batch it brings up my form. If I make any changes to the form and click Cancel button, I get a warning that my changes will be lost. If I click to continue, the changes are undone. That works perfectly.However, if I click Discard Changes and Close, I get a prompt that I will lose my changes. I click ok to continue and it takes me back to the Generic Inquiry screen. When I select that batch again, the form still reflects any changes I made to the Grid. The Description field is in the form section and it DOES NOT get saved when I reselect the batch to edit.At this point, if I refresh the browser, it redisplays everything as unchanged (good).This is what it looks like before I change anything:If I untick the Errors to clear them, I am updating the details records to clear the errors on the line protected void _(Events.FieldUpdated<ICSPending, ICSPending.hasErrors> e) { ICSPending

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

PXProcessing result screen is messed up

I have a processing screen that works perfectly. After processing, all data is updated correctly and the screen looks and functions exactly as it should.However, when the processing is complete, the results window is screwed up.When I click POST ALL, the code posts any entries that are unposted (based on the drop down filter) and does not post entries with a batch error. WORKS GREAT!When the processing delegate fires, if the batch has errors, I throw an exception on that recordPXProcessing<ICSPendingHDR>.SetError(entriesToProcess.IndexOf(entry), e);On the web site, the processing screen temporarily shows an item in the ERROR box which is what I expect: Then, when both records have been processed, the results changes to 2 process successfully When I click the 2 Processed button, I get results that are messed up. The Batch Has Errors column should show a checkbox and not True or False. It is pushing the columns to the right. Also, the descriptions on the Messages are in the wr

3 years ago

KurtBauerJr Varsity III

asked in Develop Customizations

Unable to publish from customization project editor

We have a development environment that has many instances of Acumatica installed and in the past week or two publishing from the customization project editor no longer works. The log window at the bottom opens and nothing is logged. There is a warning in the windows application log for ASP.NET.4.0.30319.0. I have included the details at the bottom. This is happening for all 20+ versions of Acumatica installed in any application pool. There is a workaround to update any changes through the editor, but then publish from the customization projects list screen (SM204505).Thanks,Kurt Bauer Event Log DetailsEvent code: 3005 Event message: An unhandled exception has occurred. Event time: 10/15/2020 8:42:56 AM Event time (UTC): 10/15/2020 12:42:56 PM Event ID: 908185df7ee84a46bd4210f5c030eb43 Event sequence: 15 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT/XXXXXXX-2-132472393165235242 Trust level: Full Application Virtua

3 years ago

SadokHaniniFreshman II

asked in Develop Customizations

Unable to create Shipment by code - Acumatica

Hi,I trying to create shipment by code in Acumatica, it's working fine with Inventory item without Serial Number but im getting this error with item with serial number**PX.Data.PXRowPersistingException: 'SO Error: One or more lines have unassigned slots and / or lot / serial number**i m using this code to create the shipment:SOShipmentEntrysoShipmentGraph=PXGraph.CreateInstance<SOShipmentEntry>();soShipmentGraph.Clear();DocumentList<SOShipment>created=newDocumentList<SOShipment>(soShipmentGraph);SOShipmentsOShipment=newSOShipment();created.Add(sOShipment);soShipmentGraph.CreateShipment(newOrder,5,newOrder.OrderDate,true,SOOperation.Issue,created); what i m missing ? Thanks.

3 years ago

mohamed1walhaJr Varsity II

asked in Develop Customizations

Find the business logic of button "Process" (Screen SO503000)

Hello,I'm trying to find the Business Logic of the Button “Process” to customise it in SOInvoiceShipment (screen “SO503000”).anyone can me help please?

3 years ago

mohamed1walhaJr Varsity II

asked in Develop Customizations

How to create "LotSerialNbr" By code?

Hello,I want to know if there are any solution to create the "LotSerialNbr" in SOShipLine By code.Best regards.

3 years ago

sean21Varsity I

asked in Develop Customizations

business event - not recognizing a customer location that does exist

I’m a business event noob…. I feel like this is 99% complete and someone from this community could get this over the goal line. See screenshots below. I created a custom GI to list project records. The business event is supposed to create a new service order via import scenario when a new project has been created. The business event doesn’t process because “location can’t be found in the system”, however that location does in fact exist. Does anybody know what I’m missing or doing wrong?

3 years ago

Giri KPro I

posted in Develop Customizations

How to add custom column name to Base LotSerialNbr Selector in SOTranSplit table?

How to add custom field to Base LotserialNbr Selector ??I am able to add custom field in Lot Serial Nbr Selector.But Display names are showing Tablename_FieldName or fieldnames instead of DAC display names...How to get DAC displaynames in this scenario??In my custom screen I defind LotSerialNbr selector by Inheriting from INLotSerialNbrAttribute as LotSerialNbr Selector in My custom screen:--------------------------------------------------------------[TSLotSerialNbrAttribute.TSAllocationLotSerialNbr(typeof(TSProdMTranSplit.inventoryID), typeof(TSProdMTranSplit.subItemID), typeof(TSProdMTranSplit.siteID), typeof(TSProdMTranSplit.locationID), typeof(TSProdMTranSplit.lotSerialNbr), FieldClass = "LotSerial")] Inheriting from Base INLotSerialNbrAttribute--------------------------------------------------------------- public class TSLotSerialNbrAttribute : INLotSerialNbrAttribute { private TSLotSerialNbrAttribute() { } public TSLotSerialNbrAttribute(Type

3 years ago

SadokHaniniFreshman II

asked in Develop Customizations

Error when launching the report

Hello,I’m trying to launch the same report from another screen but i got this error belowFYI : the report that i m trying to launch : SO644000 error : the function IsInventoryLocationLocked is not defined. Thanks :)

3 years ago

saikiranb36Freshman II

asked in Develop Customizations

Unable to select value, it is disappearing

Hello! While selecting the value through selector ,it is disappearing.And also forward and backward buttons are not working.Can someone help me out.Here is the code for referenceDac: public abstract class assetCD : PX.Data.BQL.BqlString.Field<assetCD> { } /// <summary> /// A string identifier, which contains a key value. This field is also a selector for navigation. /// </summary> /// <value>The value can be entered manually or can be auto-numbered.</value> [PXDBString(15, IsUnicode = true, IsKey = true, InputMask = ">CCCCCCCCCCCCCCC")] [PXDBDefault] [PXUIField(DisplayName = "Asset ID", Visibility = PXUIVisibility.SelectorVisible)] [PXSelector(typeof(Search2<FixedAsset.assetCD, LeftJoin<FADetails, On<FADetails.assetID, Equal<FixedAsset.assetID>>, LeftJoin<FALocationHistory, On<FALocationHistory.assetID, Equal<FixedAsset.assetID>, An

3 years ago

Joe SchmuckerCaptain II

posted in Develop Customizations

How to set an unbound selector to another value from the same table

I have a table that holds a text value of the GL account code from an import. On the Grid in the form, I want to display a Account Selector on the same view that is defaulted to the GL account code from the text field.The PXSelector for AccountID is an unbound field.Here are the two fields from the DAC #region AccountID [PXInt()] [PXUnboundDefault] [PXUIField(DisplayName = "Account")] [PXSelector(typeof(Search<Account.accountID>), typeof(Account.accountID), typeof(Account.description), SubstituteKey = typeof(Account.accountCD), DescriptionField = typeof(Account.description))] public virtual Int32? AccountID { get; set; } public abstract class accountID : PX.Data.BQL.BqlInt.Field<accountID> { } #endregion #region AccountCD [PXDBString(10, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Account CD")] public virtual string AccountCD { get

3 years ago

Gabriel MichaudCaptain II

asked in Develop Customizations

Generic Inquiries in Customization Project and Screen IDs

What are some of the best practices regarding packing of generic inquiries in customization projects? Acumatica defaults the screen ID to GI.00.XX.XX, and if you try to publish a project with conflicting screen IDs it fails. I know we can change the screen ID ourselves, but I’ve seen issues in the past where this would completely break the automatic numbering when a user tries to add a new generic inquiry to the site map.

3 years ago

ray20Captain II

asked in Develop Customizations

How to determine all ship lines have been deleted from coding's perspective?

Hello, we have a little customization that to count each ship line’s qty according to the item’s temperature zone(which is also a customization field, but it does not matter here). It would be almost perfect, however it is having a little issue. If someone clear/delete all ship lines and save, the “totaldryunits” would not be set to 0. I read the code lines, it looks like foreach (SOShipLine line in Base.Transactions.Select()) this line would not be triggered, if all ship lines were cleared. I am not good at coding , can anyone help me how to trigger the total reset?

3 years ago

jakea80

asked in Develop Customizations

User filters are lost after publishing customization

Recently I’ve noticed an issue that after I publish customization projects our users report that their saved filters are lost. Has anyone else experienced this? Is this a known issue?

3 years ago

Joe SchmuckerCaptain II

asked in Develop Customizations

New row button on grid not working

I have a simple table and a grid to add records to it. The Account Mapping grid works. But on the Branch Mapping grid, when I click the “PLUS” icon, the icon goes grey and no new row is available on the grid.Before clicking PLUS This is what is looks like after clicking the PLUS icon: The table is very simple. When a Company is selected, the view for the grid is public SelectFrom<ICSBranchMapping> .Where<ICSBranchMapping.organizationID .IsEqual<ICSSetup.organizationID.FromCurrent>>.View BranchMapping; The ICSSetup table is even simpler: If I create a new record in ICSSetup, it lets me add 1 row to the ICSBranchMapping table But I cannot add another row.Here is the DAC for the ICSBranchMapping table The records in the DB all look fine after adding the 1 row it will allow me to enter.The action button is a dummy. The code has been commented out to ensure it has nothing to do with the issue.I forgot to mention, I CAN update the exi

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 this we 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

mohamed1walhaJr Varsity II

asked in Develop Customizations

Error in value of GetExtension code

Hello, When I set the value of GetExtension, the variable gets null. foreach (SOLine soline in listOfLine1) { SOLine line = new SOLine(); //…. code var lineExt = SOGraph.Transactions.Current.GetExtension<Objects.SO.SOLineExt>(); lineExt.UsrMargeLine = GetPercentMargin(line); SOGraph.Transactions.Insert(line); SOGraph.Actions.PressSave(); }Best regards.

3 years ago

SadokHaniniFreshman II

asked in Develop Customizations

Error Adding Buttons

HelloI dont know what wrong with this code : using System;using PX.Data;using System.Collections;namespace Attributs{ public class AttributsForm : PXGraph<AttributsForm> { public PXSave<ZattributsPlan> Save; public PXCancel<ZattributsPlan> Cancel; public PXSelect<ZattributsPlan> MasterView; public PXFilter<DetailsTable> DetailsView; [Serializable] public class DetailsTable : IBqlTable { } public PXAction<ZattributsPlan> CalcPrice; public PXAction<ZattributsPlan> CalcTest; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Param Liste 1")] protected void calcPrice() { } [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Param Liste 2")] protected void CalcTest() { } }} I have this Error:

3 years ago

SadokHaniniFreshman II

asked in Develop Customizations

Creating a shipment with a wrong shipment number prefix (brand Id problem)

Using this code, accumatica create my new SOShipment from the new SOOrder. The new SOShipment is associated in New BranchId and that we need extactly.Problem : the ShipmentNbr of new SOShipment get the perfix of the Old BranchIdSOShipmentEntry soShipmentGraph = PXGraph.CreateInstance<SOShipmentEntry>();soShipmentGraph.Clear();DocumentList<SOShipment> created = new DocumentList<SOShipment>(soShipmentGraph);SOShipment sOShipment = new SOShipment();created.Add(sOShipment);soShipmentGraph.CreateShipment(newOrder,5, newOrder.OrderDate, true, SOOperation.Issue, created);

3 years ago

SadokHaniniFreshman II

asked in Develop Customizations

Saving data to a custom form

I was able to create a custom Table + Custom FormBut when i try to save the record nothing Happen CREATE TABLE [dbo].[ZparamAttributs]( [CompanyID] [int] NOT NULL, [TexteLibre1] [nvarchar](35) NOT NULL,PRIMARY KEY CLUSTERED ( [CompanyID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO//*************************************************************************************************<%@ Page Language="C#" MasterPageFile="~/MasterPages/FormView.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="GL202599.aspx.cs" Inherits="Page_GL202599" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormView.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="PlanComptable.ParamAttributs" PrimaryView="MasterView" &

3 years ago

denizkaplanFreshman II

asked in Develop Customizations

Webservice Endpoint KeyError

Hi,I have created a new custom endpoint to retrieve required fields of Shipment. I could successfully add Packages and Inventory Details with Allocation info. I can expand that entities with the API call.After adding ShipTo Address same with Packages and Inventory Details, I couldn’t reach Address fields on the response. I added them in the same way which Object Type is Detail and fields are populated from dropdown.I’m currently working on Acumatica 2019R2. I’m not sure where I can find useful information for this but the error is:The given key was not present in the dictionary.I’ve checked field names and they seem correct.Why this error occurs with ShipTo Address information?

3 years ago

mohamed1walhaJr Varsity II

asked in Develop Customizations

Error custom project in 2020R1 "Revision code cannot be empty" after migration

Hollo,I have a custom project that runs fine on the 2019R2 version. I updated to 2020R1 and I imported the custom project. I encountered this error : “The insertion of the record 'Billing address' generated at least one error. Please correct the errors. Error: 'Revision code' cannot be empty.” Best regards.

3 years ago

maxp78Freshman I

asked in Develop Customizations

Restricting Warehouse Location based on Customer Tax Zone

Hello, does anyone know what part of the code chooses which locations are assigned to a shipment line?I am trying to restrict a warehouse location to customers who have a specific Tax Zone, so that only customers who have the tax zone can have quantity allocated from that location.Scenario:There are three locations in the warehouse: A, B, and C. A and B have higher pick priority than C.Two Tax Zones: A and BItem 123 is stocked in each of the locations. Stock in location A can only be allocated to customers with the Tax Zone A, stock in location B can only be allocated to customers with the Tax Zone B. Stock in location C can be allocated to any customer.Say that location A has 1 available, B has 2 available, and C has 10 available.If a customer in Tax Zone A orders 5 of the item, then the allocation should be 1 from location A and 4 from location C. Location B should be ignored even though it has higher priority than C. I am looking through the SOShipmentEntry graph to see how quantity

3 years ago

Page 108 / 110

Badge winners

aiwanhas earned the badge Distribution expert
ebenrouxhas earned the badge Easy talker
aiwanhas earned the badge Manufacturing expert
wfilipiak67has earned the badge Acumatica expert
MSwanson86has 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.