Develop Customizations

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

2,963 Topics
12,158 Replies

ray20Captain II

asked in Develop Customizations

customer place orders on mobile devices?

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.

653

3 years ago

rjean09Semi-Pro III

asked in Develop Customizations

Update dependent fields on Filter view for custom processing screen not working

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; } }

3305

3 years ago

rjean09Semi-Pro III

asked in Develop Customizations

Display processing dialog with PXProcessButton

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

7486

3 years ago

bghosh

asked in Develop Customizations

How to resolve : exception Message CuryID cannot be empty CuryID

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

17581

3 years ago

vpoulsonFreshman II

asked in Develop Customizations

Exporting customization project

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.

2735

3 years ago

yanuaralfianus37Jr Varsity II

asked in Develop Customizations

onblur event in acumatica

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

762

3 years ago

yanuaralfianus37Jr Varsity II

asked in Develop Customizations

action prepare invoice Error: An error occurred during processing of the field Project/Contract value PR00000006 Error: Project/Contract 'PR00000006' cannot be found in the system. Please verify whether you have proper access rights to this object.

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

6083

3 years ago

DjangoCaptain II

asked in Develop Customizations

How can I invoke File Synchonization Action via code (SM202530)

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

1711

3 years ago

larrylySemi-Pro II

asked in Develop Customizations

Mobile app scan issue/scan receive doesn't match barcode to different subitem

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?

741

3 years ago

eddiedacoVarsity I

asked in Develop Customizations

How to group by and OrderBy in PXSelector

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

8024

3 years ago

yanuaralfianus37Jr Varsity II

posted in Develop Customizations

Project and Task is empty / "X" value in Issue Screen

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.

2629

3 years ago

rjean09Semi-Pro III

asked in Develop Customizations

Void checks in processing screen

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

33111

3 years ago

mohamed1walhaJr Varsity II

asked in Develop Customizations

Load Data from selector

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.

751

3 years ago

eddiedacoVarsity I

asked in Develop Customizations

Porblem refresh/reload selector with row selection (grid)

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

6772

3 years ago

Gabriel MichaudCaptain II

posted in Develop Customizations

An interesting Acumatica Developer Blog

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!

2631

3 years ago

jwestermann17Jr Varsity III

posted in Develop Customizations

Dynamic Color for Reports

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

36810

3 years ago

TharidhiPSemi-Pro III

asked in Develop Customizations

Attribute ID Selector Determines Field Values in Custom Field

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> { }

5611

3 years ago

chandramoulib97Freshman I

asked in Develop Customizations

Using MultiThreading for Import Orders

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

2252

3 years ago

xkylewrightxSemi-Pro I

asked in Develop Customizations

Using SOOrder primary key as foreign key in another table

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!!!

25010

3 years ago

eddiedacoVarsity I

asked in Develop Customizations

How to create a selector with 2 tabs

Hi, can someone please help me how to create a selector with 2 (All records, project codes) tabs like this This screen is in the Daily Field Report y the tab Equipment in the coumn cost code I was looking on the internet but I did not find an example. Additional.My project is a customization. The Screen id of reference is: PJ304000Thank you very much I will appreciate any help

2145

3 years ago

eddiedacoVarsity I

asked in Develop Customizations

How to convert colums to rows (pivot) and put the result in selector

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!

622

3 years ago

TharidhiPSemi-Pro III

asked in Develop Customizations

Get values from Custom Form to appear on Line Level according to Item and Customer in Sales Order Form

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

1547

3 years ago

TharidhiPSemi-Pro III

asked in Develop Customizations

Multi-Select Combo Box Functionality Not Working

I have created attributes on the attributes form belowAnd these values should be shown as multi-select in Sales Order Line in a user defined field, code is below for getting those values, but in the field it only shows combo box (one value selection).public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry> { #region Event Handlers protected void SOLine_UsrAccessories_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { List<string> allowedValues = new List<string>(); List<string> allowedLabels = new List<string>(); foreach (CSAttributeDetail objCSAttributeDetail in PXSelect<CSAttributeDetail, Where<CSAttributeDetail.attributeID, Equal<Required<CSAttributeDetail.attributeID>>>>.Select(Base, "ACCITEMS")) { allowedValues.Add(objCSAttributeDetail.ValueID); allowedLabels.Add(objCSAttributeDetail.D

4083

3 years ago