Develop Customizations

Hello,  Can i consult the code source of the methods in PXCache. For example method : GetValueExt best regards. 

Hi Chaps,My goal is to have a GI to be used by portal users.  This GI should list all documents of a given type for the customer associated to the user running the GI (external user signed on the portal).For instance, let’s say I want to list all projects of customer ACME if the  John Doe , an employee of customer ACME, signs in. The same GI should list all projects of customer AXY if its employee Mark Doe is signed in.Would you know please what table should the GI access to get the ID of the signed in user ? (always on the portal site) Your comments are appreciated.  

I have been trying to setup additional functionality to the mobile app but one function keeps throwing a “Server Error (404)” message.  (Yes, I know that 404 is page not found).Even the example in the only documentation I have fails. (Documentation example for invoices from “2019 R1”.Basically all I am trying to do is after displaying the list of Shipments, then tap on that shipment to change or edit it.  But the error occurs whenever I add the command of     add containerAction "editDetail" {      behavior = Open      redirect = True    }Why does that generate that 404 error message?  And how do I correct that with 2020 R2?

Hi,Need you help to Open Business Account screen from Opportunity using (Create Account drop down list). In Acumatica 2020 R2 business account screen is not appear. Note: Earlier it was (Business account screen will be open from Opportunity) working on 2019 R2 version. Thank You,

Hello,   Customer  portal provided by acumatica is fully functioned. However, we have a lot of customers do not have computer or tablet. They only want to place orders from phone. Unfortunately, the customer portal is not specifically designed for phone use.   Are there any solution can make user place orders on a phone in the way they like?  We’ve tried Shopify, but Shopify does not support level price, which we need. 

I have a custom processing screen and would like to clear out values of other fields on my filter based on a combobox changing.  I’ve have CommitChanges set to true on my combobox but can’t get the text box values to clear.  I can set a breakpoint and see that the values are changing to null but they stay on the screen until I change the combobox back to Pallet then back to Truck and back to Pallet again.  But the first time the UI doesn’t show the change.Here is my FieldUpdated logic:           protected virtual void _(Events.FieldUpdated<PMTaskToAssignFilter, PMTaskToAssignFilter.assign> e) {            PMTaskToAssignFilter row = e.Row;            if (row.Assign != AssignTypes.Truck) {                 row.DeliveryNumber = null;                row.TrailerNumber = null;            }        }

I have a custom processing screen:In order to get the non-intrusive validation to work I had to create my own PXProcessButton vs. using the built-in processing delegate.  All is working, however, now that I have done this I don’t have a processing dialog, just a little green dot that shows everything processed.  How can I show the processing dialog in this scenario?  FYI, I used code in AR507000 (Calculate Overdue charges) as the example for hooking up a custom processing button and having my required fields validate in this way prior to processing.  Client didn’t like the behavior of just throwing PXExceptions.Here is my custom PXProcessButton:         public PXAction<PMTaskToAssignFilter> Assign;        [PXUIField(DisplayName = "Assign", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Update)]        [PXProcessButton]        public virtual IEnumerable assign(PXAdapter adapter)        {            PMTaskToAssignFilter filter = Filter.Current;            if

Hello, We are trying to move to R1 2021 (from our current version) but our API calls to create Project is failing with the Above error in the new version of Acumatica.Full details below…. would appreciate any pointers and assistance. Thanks.  Method: PUTURL:  https://xx-sandbox-21r1.acumatica.com/entity/GoXxxxxx/6.00.001/Project Body:{"Customer":{"value":"100743"},"Description":{"value":"Company 164 - MX - Bernadette Weinand (Bernadette)"},"Hold":{"value":false},"ProjectID":{"value":"100743-MX-129"},"Status":{"value":"Active"},"Currency":{"value":"USD"},"Tasks":[{"id":null,"AllocationRule":null,"BillingOption":{"value":"By Billing Period"},"BillingRule":{"value":"MULTISILO"},"Description":{"value":"Task Description"},"Status":{"value":"Active"},"TaskID":{"value":"00"},"RateTable":null}],"Attributes":[{"AttributeDescription":{"value":"First Name"},"Required":null,"RefNoteID":null,"Value":{"value":"Bernadette"}},{"AttributeDescription":{"value":"Last Name"},"Required":null,"RefNoteID":nu

This is my first time doing a customization outside the T190 training course. In a local environment I created a customization project with four new fields.  They are just text fields with no logic behind them.  Everything works fine in the local environment.  I then exported the customization and imported it into another instance.  On the second instance the database fields got created and the text boxes show on the form.  Unfortunately the fields don’t have any labels and data won’t save to those fields.  I’m not sure if the extension library I created got moved to the second instance.  The version of my local instance is 21.108.0032 and the version of the other instance is 21.104.0018.  Not sure if that will make a difference or not. Attached is my customization project.  

anyone know how to use onblur event in acumatica ? or anything idea can develop like function onblur event  ?

i need help for this bug action prepare invoice in Shipment Screen (SO302000)in Shipment Screen, Project Field and Project Task Field is customize.this is source code for Project and project task protected void SOShipment_RowPersisting(PXCache cache, PXRowPersistingEventArgs e, PXRowPersisting InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (SOShipment)e.Row; if (row == null) return; //if((e.Operation & PXDBOperation.Command )== PXDBOperation.Insert) //{ var rowExt = PXCache<SOShipment>.GetExtension<SOShipmentExt>(row); SOOrderShipment shipOrder = PXSelect<SOOrderShipment, Where<SOOrderShipment.shipmentNbr, Equal<Required<SOOrderShipment.shipmentNbr>>>> .Select(this.Base, row.ShipmentNbr); if(shipOrder != null ){ SOOrder order = PXSelect<SOOrder, Where<SOOrder.orderNbr, Equal&l

We’re using file synchronization to send payment batch files to an external site. File Synchronization only works on a per file basis so we have set up one file that our export scenario will populate.Because we need every version of this file to be sent to the external site, I need to make sure that every revision of the file is synchronized.My thought was to override the Export button on Batch Payments (AP305000) to call the Process All Files action, using the Export File operation, on the File Synchronization screen.  The challenge is that I can’t see to find the name of the graph to instantiate to access that business object.Here is where I’m at:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using PX.Api;using PX.Data;using PX.Data.WorkflowAPI;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CM;using PX.Objects.Common.Extensions;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.AP.MigrationMode;using PX.Obj

Hi All,When the item has two barcodes for different subitems.   The Scan and issue/Scan and receive screen will not match the subitem that I scanned barcode. It always find the default subitem. The item default subitem is WHT.For example : I scanned the REC-14-RDC barcode. The system will issue/receive WHT subitem not RDC subitem.   I checked the code. It looks good. Does anyone have any ideas on this? 

Hi Good night i have a query that works, but i need to aggregate groupBy and orderBy clauses. i saw some examples of the pdf guide but not working.I need group by :BAccount.bAccountId BAcount.acctName V_CEVendors.idEstimateEstimate V_CEVendors.vChecked  V_CEVendors.totalThis is my code that works. (without group by or OrderBy). [PXSelector(typeof(Search2<BAccount.bAccountID, LeftJoin<V_CEVendors, On<BAccount.bAccountID, Equal<V_CEVendors.vendor_Id>>>, Where<V_CEVendors.estimateNbr.IsEqual<CEEstimate.estimateNbr.FromCurrent>. And<V_CEVendors.idEstimateEstimate.IsEqual<CEEstimateEstimate.id.FromCurrent>.And<BAccount.type.IsEqual<SQLConstant.ONLYVENDORC>.And<BAccount.deletedDatabaseRecord.IsEqual<SQLConstant.DELETEDRECORDBOOLC>>>>. Or<V_CEVendors.idEstimateEstimate.IsNull.And<BAccount.type.IsEqual<SQLConstant.ONLYVENDORC>.And<BAccount.deletedDatabaseRecord.IsEqual<SQLConstant.DELET

I have problem with project and task in Issue screen (IN302000), after doing UPDATE IN from Shipments Screen (SO302000), automatic make a new Issue in Issue screen (IN302000) but project and task is not same with project and task in Shipments Screen (SO302000).(project and task field is custom and just calling data) how to solve that case ? thanks.

I have a custom processing screen that sets some custom fields (for stale dated checks, they get  a lot of these due to small amount refunds that never get cashed).  My client wants these to be voided automatically at the same time which means in code it needs to call the void action on the APPaymentEntry graph, remove the hold flag and call the release action.  Not having much luck pulling all of this together.  We had an import scenario to do the void after setting the stale dated info but they want it to be all in one step.Here is the main processing loop.  Most of these will be Quick Checks (but not all) Correction, these will only be quick checks        public static void Process(List<APPayment> payments)        {                     var globalError = false;            var graph = CreateInstance<APPaymentEntry>();            var checkNumber = string.Empty;            DateTime? currBusinessDate = graph.Accessinfo.BusinessDate;            Guid currUser = graph.Accessinfo

Hello,I created a new screen.In this screen I have a selector. the problem is when I want to change a selector value, the screen does not display the records linked to the selector from a table created in the database. But when i add “TableID=value“, he load data in Grid. I want to know is there a solution to add data in the url. Best regards.

Hi, Good Night. I need to "reload" my "VendorId" selector with the corresponding information from my EstimateNbr (Header) and Id (Grid). Currently in my DAC (corresponding to the grid: CEEstimateEstimate) I do the following in the VendorId.I use CEEstimate.EstimateNbr FromCurrent. (header) I use CEEstimateEstimate.Id From Current (grid) #region VendorId [PXDBInt()] //[PXDefault(TypeCode.Decimal,"0")] [PXSelector(typeof(Search<V_CEVendors.vendor_Id, Where<V_CEVendors.estimateNbr,Equal<CEEstimate.estimateNbr.FromCurrent>,And<V_CEVendors.idEstimateEstimate,Equal<CEEstimateEstimate.id.FromCurrent>>>>), typeof(V_CEVendors.vendor_Id), typeof(V_CEVendors.vendor_Name), SubstituteKey = typeof(V_CEVendors.vendor_Id))] [PXUIField(DisplayName = "Vendor Id")] public virtual int? VendorId { get; set; } public abstract class vendorId : PX.Data.BQL.BqlInt.Field<vendorId> { } #endregionIt works, but I must select the field

Dear Acumatica Developers,I just wanted to highlight a nice blog maintained by @brianstevens that I discovered yesterday. It is here: https://www.acumatica.dev/blog/brian/One article in particular caught my attention - it shows how to dynamically generate ZPL (Zebra Printer Language) code to print to a label printer using Acumatica DeviceHub.Happy reading!

Good Morning,i would like to search for a solution for my idea.As this idea might be interesting for someone else, i thought it would be interesting to share it here.We are currently in the process of creating new Standard Reports for our Customers that replace the 300+ Reports from Acumatica. To add a bit “color” to them, we often use textboxes or lines with a certain color. We would like to change the color based upon the main color of the logo that gets updated - or upon a user definied field that contains the hex of the color.Customization:» Step 1 | User uploads a Image at the Screen CS101500 (Most likely the company logo)» Step 2 | Code starts to look through the Image and return the most used color.» x--------| Example: For this Picture it would be “CornflowerBlue”» Step 3 | Code iterates through a defined set of reports (since they are able to get edited within a text editor, i could see this working quite well) and searches within each report for a Color» x------- | Example: C

I have created a line level field in AP303000 form and I need to have Attribute ID selector namespace MidayaCustomizations{ public class APTranExt : PXCacheExtension<PX.Objects.AP.APTran> { #region UsrAttributeSelection [PXDBString(250)] [PXUIField(DisplayName = "Attribute ID")] [PXSelector(typeof(Search<CSAttributeDetail.attributeID,Where<CSAttributeDetail.attributeID, Equal<CSAttribute.attributeID>>>), typeof(CSAttributeDetail.attributeID))] public virtual string UsrAttributeSelection { get; set; } public abstract class usrAttributeSelection : PX.Data.BQL.BqlString.Field<usrAttributeSelection> { } #endregion #region UsrAttributeValues [PXDBString(250)] [PXUIField(DisplayName = "Attribute Values")] public virtual string UsrAttributeValues { get; set; } public abstract class usrAttributeValues : PX.Data.BQL.BqlString.Field<usrAttributeValues> { }

HelloI am facing below issue when i am trying to  Prepare Orders using the Multi ThreadingSample Code :            var availableTasks = Environment.ProcessorCount - 1;            List<List<KCAPIOrder>> objliUsrMappingBatches = SplitIntoChunks(orders, ((orders.Count / availableTasks) + 1));            Task[] tasks = new Task[availableTasks];                      for (int x = 0; x < availableTasks ; x++)            {                int index = x;                tasks[index] = new Task(() =>                {                    foreach (KCAPIOrder order in objliUsrMappingBatches[index])                    {                        GetOrderDetails(store, request, order);                    }                }, cancellationToken);            }                      tasks.StartAndWaitAll(cancellationToken, logger); Can anyone Help on this

Hello--I am attempting a customization and ran into an issue:I need to use OrderNbr column from a sales order to populate fields in another table. The problem is, when a sales order is created, OrderNbr is not generated until after the record is saved (RowPersisted?).This value is required in order to generate rows in another table and relate them to this specific sales order. These rows will need to be edited during the creation of the sales order, so it cannot be done after the SO is saved. What are best practices for getting around this issue in general? Is there another column I can use to reference this specific SO before it is saved? Maybe I should be working in cache? Thank you!!! 

Hello Goodnight. I have the following problem. I have a “table A” with the columns: Vendor_1, Vendor_2, Vendor_3 and Vendor_4. I need to display these columns in a selector as if they were rows.In sql I solved the problem using "union all" but when I am investigating I see that acumatica does not have (or at least I have not found examples) this option. Aditional: I have work in a customization project.Can you help me please. Thanks! 

Made a custom form with Item, Customer and Packaging Option.I need to have a line level field in the Sales Order form called packaging option which has the given packaging option for that item and customer, how can I achieve this customization?packaging option which is linked to custom form’s item, customer and packaging option