Develop Customizations

I have a customer that would like the estimated margin amount on the sales order to show a value even if the unit cost is zero, i.e. 100%. I have located the formula in the SO/GraphExtensions/SOOrderEntryExt/Margin.cs code file. That code appears to be an override of the existing DAC attributes of the field.  Is it possible to override this from a customization project or is there another approach that should be used?Code from Margin.cs:        [PXMergeAttributes]        [PXFormula(typeof(Switch<            Case<                Where<                    SOLine.curyExtCost.IsEqual<decimal0>                    .Or<SOLine.behavior.IsEqual<SOBehavior.tR>>                    .Or<SOLine.pOCreate.IsEqual<True>.And<SOLine.pOSource.IsIn<INReplenishmentSource.dropShipToOrder, INReplenishmentSource.blanketDropShipToOrder>>>>,                Null,            Case<                Where<                    SOLine.curyExtPrice.IsEqual<dec

Hi,We are currently able to change the default Acumatica logo by setting it in the Branches screen on the Visual Appearance tab, but when the left side menu is collapsed, the small Acumatica “a” logo is displayed.Is it possible to set another custom image as the logo when this menu is collapsed?Thanks in advance

Hi Friends.I have the following screen. I need that when the screen loads (if it is a new record) the grid Alternates have a one row by default. This is the way I have been working but it doesn't work.using System;using PX.Data;using PX.Data.BQL.Fluent; using System.Linq;namespace Estimating{ public class EstimateEntry : PXGraph<EstimateEntry, CEEstimate > { protected void CEEstimateAlternate_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (CEEstimateAlternate)e.Row; if (row == null) return; CEEstimateAlternate line = new CEEstimateAlternate(); line.Number=1; line.Description = "Base Bid"; line.Type = "INCLUDED"; this.viewCEEstimateAlternates.Insert(line); }}}Aditional.The header view is: viewCEEstimate. The DAC header is: CEEstimate. The grid view (Alternate) is: viewCEEstimateAlternates. The DAC grid (Alternate) is: CEEstimateAlternate. The structure of alternates is simple: Number (int), Description (Text),

I have a problem when upgrade acumatica to 2025R2, my clissic ui input and save show error cann empty. But when I switch to moder ui cannot input and save normally. 

Hi. I have Prepayment on AR302000 screen. On Application of the Prepayment to a Normal AR Invoice, i need change debit account id. How I can do this? 

 I have created a new custom field in SOOrder, I want to retrieve SalesPerson.descr from SalesPerson table but not showing value. I want SalesPerson Description insert it into the SOOrder table.[PXDefault(typeof(Search<SalesPerson.descr, Where<SalesPerson.salesPersonID, Equal<Current<SOOrder.salesPersonID>>>>), PersistingCheck = PXPersistingCheck.Nothing)][PXDBString(60)][PXUIField(DisplayName="SalesPerson Description")] 

From the Inventory Allocation Details (IN402000 screen) page, I’m interested in these fields:I used to get these values from the database using this SQL query:select [QtySOBackOrdered],[QtySOShipping],[QtySOBooked],[QtySOPrepared]FROM [dbo].[INSiteStatus] (NOLOCK) sswhere InventoryID=19560 and CompanyID=2 Unfortunately, these values aren’t changing in the database on a daily basis even though they are changing on the Inventory Allocation Details (IN402000 screen) page.  In fact, they haven’t changed at all since the upgrade from 22R2 to 24R1.  It looks like the InventoryQtyByPlanType code is used to populate this grid in 24R1 but, looking at the refactored code, I’m not seeing how these fields are calculated or which database tables they are derived from. Does anyone know where these values are stored in the Acumatica SQL database?

Hi everyone,I am customizing report SO643000 (Invoice) and I need to show the tax amount for items that actually have tax. I joined ARTax to ARTran on TranType, RefNbr, and LineNbr. The tax value appears correctly, but after adding ARTax, the same item starts printing twice. One row shows the tax and the other is blank.My goal: Print each item only one timeShow the tax amount only for items that have taxDo not repeat or duplicate the item row Has anyone done this before on SO643000?Is there a recommended way to show ARTax.CuryTaxAmt for an item only if that item has a tax record, without causing duplicate ARTran rows?Any guidance, formulas, or examples would be greatly appreciated. I have attached Report 

I’m trying to transfer custom field values from ARInvoice (screen AR301000) to the GL Batch record created during release.I added matching custom fields to both DACs via customization:ARInvoice DAC fields: UsrCustomerExtContractNbr (nvarchar(30)) – N° contrat plateforme UsrCustomerExtJournal (nvarchar(30)) – Journal plateforme UsrCustomerExtRefNbr (nvarchar(30)) – N° de facture plateforme Batch DAC fields: UsrExtContractNbr (nvarchar(30)) – N° contrat plateforme UsrExtJournal (nvarchar(30)) – Journal plateforme UsrExtRefNbr (nvarchar(30)) – N° de facture plateforme I override the ARReleaseProcess.ReleaseDocProc method to handle the release logic, but when the batch is created, these custom fields remain blank in the GL Batch record.Question:Why aren’t the custom fields from ARInvoice being transferred to the GL Batch during release?Here is ARReleaseProcess graph code:using System;using System.Collections.Generic;using PX.Data;using PX.Objects.AR;using PX.Objects.GL;using Cegid.

I create moder ui in localhost in environment and It’s working and I include the file in customization project file like image above but after publishing in production it cannot show or display

Why is my hyperlink not working after I converted to the modern UI?  

Hi Community,Our Sprinterra dev team is setting aside a sprint to build an Acumatica add-on that fixes a pain point many of you hit every day. We will then release it on GitHub under an MIT license (free to use, fork, or modify) for all to use.What we need from you:Describe the problem in one or two sentences. Tell us where it shows up (screen, module, version). Explain the impact: time lost, errors, extra clicks, etc. Feel free to add mock-ups, sample data, or links to forum threads that show the issue.Example submission“On the Shipments screen it takes five clicks to print a label for each package. A batch-print button that grabs all open shipments would save 30 minutes per day in our warehouse.”How we’ll chooseShort-list the top three based on community up-votes + impact. Announce the winner here on Monday, 22 July. Deliver the working solution (source + install package) on GitHub within a month of announcing the winner. The entire build (spec, code, and docs) will remain open sourc

Hello everyone. I need to calculate the value of a field that is not stored in the database. I need to do this every time the BAccount form is opened. What is the best way to do this so that it only happens once when it is opened?

This topic may have been discussed previously but would like further confirmation When a customer has a second Process Node (with ;process’ in the url) what is the proper procedure to publish customizations and unpublished in this environment ?should customization be published twice?  once on each node or only the processing node? how should a single customization be “unpublished” in this environment ? is it possible to get the two nodes out of sync with customization projects? where can this information be found in documentation ?  

What are the numbering rules so that changes are not lost when updating acumatica version ? 

Can someone tell me (with certainty) if PXGraph contains a property to indicate that it is being currently used by the e-commerce sync?

I created an import to load data into the Payments and Applications screen, Documents to Apply tab. When running the import, it fails with the error: “Value cannot be null. Parameter name: row.” Please advise on the cause and required fix.My Settings:using PX.Data;using PX.Objects.AR;using ARAdjust = PX.Objects.AR.ARAdjust;using ARPayment = PX.Objects.AR.ARPayment;namespace import1.GraphExt{    public class ARPaymentEntryExt : PXGraphExtension<ARPaymentEntry>    {        [PXImport(typeof(ARPayment))]        public PXSelect<            ARAdjust,            Where<                ARAdjust.adjgDocType, Equal<Current<ARPayment.docType>>,                And<ARAdjust.adjgRefNbr, Equal<Current<ARPayment.refNbr>>>>,            OrderBy<Asc<ARAdjust.released, Asc<ARAdjust.adjdRefNbr>>>> Adjustments;     }}  

I have some problem. I have all right. But report parameters not availible. in 24R111 version. But in 25r1 its work. With some rights. With debug i see this error: 1️⃣ PX.Web.UI.PXReportViewer.SetReportSignFlagIfPdfCertificateIsPresent()    → C:\build\code_repo\NetTools\PX.Web.UI\Controls\Report\ReportViewer.cs:line 12182️⃣ PX.Web.UI.Metadata.AspxScreenInfoCollector.Collect(String screenId, String locale)    → C:\build\code_repo\NetTools\PX.Web.UI\Metadata\AspxScreenInfoCollector.cs:line 153In trace i have this  its error i have when i refresh report parameters. All report have this error and I can't set parameters

I have dac: using PX.Data;using System;using PX.Data.BQL.Fluent;using PX.Objects.GL;using static PX.Objects.AP.APTran;namespace ASAmazonIntegration.Ext{    [PXCacheName(Messages.SPAmazonTransactionMapping)]    public class SPAmazonTransactionMapping : PXBqlTable, IBqlTable    {        #region BindingID        [PXDBInt(IsKey = true)]        [PXDBDefault(typeof(SPAmazonStore.bindingID))]        [PXParent(typeof(SelectFrom<SPAmazonStore>.            Where<SPAmazonStore.bindingID.                IsEqual<SPAmazonTransactionMapping.bindingID.FromCurrent>>))]        public virtual int? BindingID { get; set; }        public abstract class bindingID : PX.Data.BQL.BqlInt.Field<bindingID> { }        #endregion        #region TranType        public abstract class tranType : PX.Data.BQL.BqlString.Field<tranType> { }        [PXDBString(15, IsUnicode = true, IsKey = true)]        [PXUIField(DisplayName = Messages.TranType)]        [PXDefault(PersistingCheck = PXPersistin

I tried adding a tab to the IN202000 screen, but it doesn’t show up.import { GridAutoGrowMode, GridPreset, PXFieldOptions, PXFieldState, PXView, autoRefresh, createCollection, gridConfig, viewInfo} from "client-controls";import { IN202000, ItemSettings } from "src/screens/IN/IN202000/IN202000"export interface IN202000_SKPriceIndexCST extends IN202000 { }export class IN202000_SKPriceIndexCST { @viewInfo({ containerName: "Price Index" }) xtStockItems = createCollection(xtStockItems_SKPriceIndexCST);}@gridConfig({ preset: GridPreset.Details})export class xtStockItems_SKPriceIndexCST extends PXView { }{ CategoryID: PXFieldState; EffDate: PXFieldState<PXFieldOptions.CommitChanges>; AsphaltPct: PXFieldState;}export interface ItemSettings_SKPriceIndexCST extends ItemSettings { }export class ItemSettings_SKPriceIndexCST { UsrSPriceIndex: PXFieldState;}<template> <qp-tab after="#tab-Description" id="tab-PriceIndex" caption="Price

Hi Guys, is there a way to overwrite an existing alternate ID without creating a new one ?   Thanks for anyhelp

Is it possible to have no-code Actions from multiple customization projects show on the same screenI’m only seeing the no-code action from the published customization project with the highest level.Do all no-code actions per screen need to be in one single project?Or is there a way to have them all added to the screen, from their various projects? Example:Project 1 (Level 50) - Sales Orders > Action AProject 2 (Level 60) - Sales Orders > Action BWhen both projects are published, only Action B shows on the Sales Order screen.When only Project 1 is published, only Action A shows on the Sales Orders screen.

I have process screen for some document. I add field project id. And old document have Null at this screen. New document have x project. At my process screen, I set x value to null documents by innumerable method. But when I selected line, project set null by Cache. How to set ,,x” project to old document on process screen ?    

Basically I’m running into an issue where I have a line on MPS that creates a line on the inventory planning display to create a production order.After created the production order from the inventory planning display screen and running regenerate inventory planning, the recommendation to create another order pops up again. Shouldn’t it see the production order that was already created?

I have action that want to link field. when I click it error like above