Develop Customizations

Using V2023R2 trying to retrieve quantities from INSiteStatus in a processing program.Error: Error is on the .Select line that is in red in the code shown below:using System;using System.Collections;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Linq;using System.Diagnostics;using PX.Data;using PX.Objects;using PX.Data.BQL.Fluent;using PX.Data.BQL;using PX.Data.ReferentialIntegrity.Attributes;using static PX.Api.SYMapping;using MCB_Custom.MspData;using PX.Objects.IN;using PX.Objects.SO;namespace MCBCustom{    public class FixMSPDataAlloc : PXGraph<FixMSPDataAlloc>    {        public PXCancel<MSPDataResult> Cancel;        public PXProcessing<MSPDataResult> ResultView;        public FixMSPDataAlloc()        {            ResultView.SetProcessDelegate(ProcessFixMSPDataAlloc);            ResultView.SetProcessCaption("");  // not used in this program            ResultView.SetProcessAllCaption("Process All");        }        publi

Several times recently, I’ve had to add a simple attribute above a data view declaration. For a simple data view, this is as easy as redefining the data view and adding the attribute. However, if the data view has a data view delegate, and the data view delegate calls private methods, the amount of copy/paste code needed in order to add a single line of code is ridiculous.Am I missing an easier way to do this? It feels like there should be an event or something to use, similar to adding an attribute to a DAC field on CacheAttached.

I am wondering is there a built-in function/method in Acumatica that we can pass a document NoteID and that method returns the Document Type. For example can I pass the NoteID of an AP Bills and Adjustments document NoteID and it return “Bill”, “Credit Adj.”, “Debit Adj.” … or for AR Invoice it rturns “Invoice”, “Debit Memo”, “Credit Memo” … and so on?

I’m trying to enable a field for edits during any document state.I created the field. I made it into a ComboBox I added it to a screen I enabled it via the workflows to be editable I cannot get the cache to unlock though Attached is my error:  But that field exists and does have that name:  Did I mistype the cache segment?  I selected the field, I chose EVENTS, I chose ROW SELECTED, I chose ADD HANDLER, KEEP BASE METHOD.I then inserted two lines into that generated code brick:      if (row == null) return;      PXUIFieldAttribute.SetEnabled<ARInvoiceExt.usrIsRebate>(cache, row, true); Can someone save me here?

Hi All,I have a grid and it has check box type field called Select. Now I need to create an option to check All and uncheck all. Can someone please help me to do this?ThanksBhagya

From what I can tell there are two types of printing to Device Hub with Acumatica: The type that filters a report using a Dictionary and sends it to Device Hub andthe type that you build a ZPL low level printer file for say labels pasting data in with commands, then you send that to the printer. From everything I have read, the second method is the way to print custom labels.  The first method seems to be used when you are printing a report not labels (but sometimes I see one off labels printed this way).  Not for printing labels en mass.  For printing labels in general the ZPL file with the printer in raw mode in Device Hub is the way to go.  Am I off base here or not? As I side note a requirement here is to be able to rotate labels and I know the only way to do that is ZPL. Thanks in advance 

Hi everyone! Recently I encountered a weird issue when implementing contact-creating logic in Acumatica 23R2. I have added several custom fields in Acumatica’s contact table. During creating the new contacts, after assigning values to those custom fields, the values were assigned to the wrong contact record. Here are some screenshots of the detailed issue:So, after the logic in the first screenshot is executed, the two added contacts are the ones that have email and phone numbers. But while assigning the custom b2b fields, the value has been assigned to the 1st and 2nd contacts (The first contact is not created by the logic above) instead of the 2nd and 3rd contacts. I have tried many things but cannot get the custom fields assigned to the correct contacts. Any help is appreciated!

I have added a URL field to the Sales Order Details tab and it works correctlyIs there a way i can hide the URL itself as some of them will be very long and instead just display an image or the word URL in the column so the column width can be kept small. If the user clicks on this then it will take them to the embedded URL

Hi, I get the following error when created a Sales Order and not sure how to resolve this. “An error occurred during processing of the field InventoryID: Invalid mask specified in segment 1 for Combine Sales Sub. From..”Can you, please, help

Hey guys, So whenever I try to add an inventory ID to a sales order - I get the following error: Error: An error occurred during processing of the field InventoryID: CS Error: Invalid mask specified in segment 1 for Combine Sales Sub. From.. But I can use the inventory in AR no problem - can someone help with this 

Good day,I need to build PXSelector BQL to get all vendors for current sales order. Something likePXSelector(typeof(Search2<Vendor.bAccountID, InnerJoin<PO.POVendorInventory,                On<PO.POVendorInventory.vendorID, Equal<Vendor.bAccountID>                    , And<PO.POVendorInventory.inventoryID, In<SOLine.inventoryID>>>>>)

I have created a screen showing records on grid, I have also created a redirection to invoices and memos screen which is working perfectly from web. however from my acuamtica application it is not working.see below Acumatica ASPX <%@ Page Language="C#" MasterPageFile="~/MasterPages/FormDetail.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="SO302110.aspx.cs" Inherits="Page_SO302110" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormDetail.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="GDLOrderCustomization.DeliveryMasterMaint" PrimaryView="deliveryMaster" > <CallbackCommands> </CallbackCommands> </px:PXDataSource></asp:Content><asp:Content ID="cont2" ContentPlaceHolderID="phF" Runat="Server"> <px:PXFormView ID="form" runat="server" DataSourceID="ds" DataMemb

I have a requirement to calculate taxes based on Ext. Cost instead of the Amount of bill’s lines. If I go to Taxes tab and change the taxable amount of the tax transaction the tax amount, bill tax total and bill balance are updated accordingly.I’m trying to implement this behaviour programmatically. I can change the taxable amount (setting APTaxTran.CuryTaxableAmt value) but the other figures are not updated. I tried to fire RaiseFieldUpdated for different fields but no luck.Any pointer very welcome or any alternative solution to achieve this.Thank you

Hello Everyone,I need to add “REQUEST DETAILS”  button on acumatica mobile app as shown below but it is not defined on the WSDL.Have tried my ways but not going through, How can I achieve this? Please assist. Thank you all in advanceAny kind of response will be highly appreciated.​​​​​​​

Hi,I want to use PXOrderedSelect for multiple view but the view which I have created are of single table.So, is there any way that I can use PXOrderedSelect  for multiple view for a single table .Here primary is different but table is same for all view.Also, can you tell me if PXOrderedSelect  can be use instead of PXSelectJoin and if not than what I can use in place of PXSelectJoin so that I can perform drag and drop functionality of PXOrderedSelect .I am using PXOrderedSelect for drag and drop and using it in place of PXSelect. Thanks,Dhruv

I am able to add a project task to an existing project using an API. How can I add multiple tasks using the same API? Is this possible? What is the syntax?

Hi Team,I know this is pretty abnormal question to ask. But I have to raise this and need a solution. In my screen I have a grid. Based on the current selected vendor history data is coming to the grid. Data is loading correctly but when I mouse click or hover on the grid, grid data disappeared. Once I refresh the screen data filling based on the vendor. After mouse click or hover on the grid. (Cleared the grid data).  public SelectFrom<HMRCVendorRegisterDetailHistory>.            Where<HMRCVendorRegisterDetailHistory.bAccountID.                IsEqual<HMRCVendorRegisterDetail.bAccountID.FromCurrent>>.View.ReadOnly SavedVendorRegisterDetail;HMRCVendorRegisterDetailHistory = History table.Also In my graph no refresh event included.  Can someone help me out to solve this?ThankBhagya 

Hello everyone,I had some fields that I needed to rename to comply with Acumatica’s Prefix Validation Standard.I Unpublished the customization The fields are renamed in SQL Database and now have the new names. Custom Scheme fields are updated accordingly in the customization project The DAC is updated accordingly in my C# project and any dependent events as well. ASPX DataFields are updated accordingly in the customization project The Project is compiled and the project is updated with the modified dll and published without any error.When I look into the CstPublished folder and open the customized screen, I see the new names are in the file, and NONE of the names which are raising errors exist. But when I try to open the Project screen and I get the invalid column error. For testing when I add any of the columns to the SQL DB, the error gets resolved. Long story short I do not have these fields that the system is picking on them neither in my C# project nor pages aspx but somehow the s

Hello Everyone, When the Business account is selected on the opportunity screen, the 'SHIP-TO Address' panel address fields on the shipping tab will be updated with business account address.We will, however, create an Opportunity without a business account and add the address by clicking the override address checkbox. The business account will then be assigned to the opportunity later.Even if the override address checkbox is ticked, Acumatica will override the currently available address with the selected business account address.We wanted to restrict this functionality such that the address from the business account is not updated if the override address checkbox is ticked.The "OpportunityAddressID" field of the CROpportunity DAC handles this logic with the "CROpportunityAddressAttribute" class, which is inherited from the "CRAddressAttribute" and "AddressAttribute" classes.We tried to change/override the methods in these classes, however we were unable to access already entered data

I have a new project which is always great!  The customer wants to run a bunch of validations on a Sales Order when it is being saved.  None of the validations will prevent the saving of an invoice.  The result of the validations will simply set some values in some User Defined Fields on the Sales Order.Since I am not doing validations that will produce any exceptions, I am not sure where in the process I would run these validations (i.e., in a method, override an action or process etc.).I can dig into the Acumatica code but before I start that process, I would love a recommendation as to the best approach to do this.  FYI, I cannot debug the Acumatica code as I cannot seem to get my breakpoints to hit.  I added the bin folder to the symbols to load in the debug options, but it still doesn’t work.  That’s another topic, but since I cannot get debugging to work on Acumatica pdb’s, it is hard to determine where I should inject my code.  I haven’t been able to get debugging of Acumatica c

I set up a business event to a customer screen, but I do not see how to add it to inventory (IN.20.25.00).Is there any setting to make stock-item screen available for business event? 

Enabled Disabled User Defined Fields on Shipment screen when Status is closed.Whether it is possible or not?I am checked with workflows but its not working.   

Hello! I am trying to add a selector attribute to the detail line section of the Purchase Order screen but am having some trouble. I figured out how to add the new field, however I am unsure of how to link the attribute to it. This is as far as I have gotten. Can someone please tell me what I need to do next? Also, when I try to save the Control as “Selector” it reverts back to “TextEdit” so not sure I am taking the correct steps.  

Hi all, I have customized report and I wanted to attach it using notification template which is triggered by a Business event and Generic inquiry. But the issue is I am getting error saying “Object reference not set to an instance of an object”. Business Event HistoryBut when I’m running report in usual way it is generating without any issue. Also I can generate that report programmatically from code side as well.  I tried passing fixed parameters and passing parameters through the GI as well in notification template. however, it is not working and it always gives above error message.  what can be the issue here?

when setting up a customer currently there is one “Notes” section can a second or even a third notes section be added.  In our old system we had multiple notes one for contract information one for delivery information and one for common purchased items. we had no limit to the number of notes we could add. You just chose the one you needed by the title.I only see one “notes” in Acumatica can a second be added so we don’t have to scroll the only Notes to find the one that will answer a question about the customer needs.