Develop Customizations

PXRedirectToFileException works fine on the web, however in the mobile app I get the following error.The Mobile app action has the following attributesbehavior = Voidredirect = True  

It seems that since upgrading to Acumatica 23R2 from 22R2 the delivery confirmation box visibility is tied to the Ship Via code used.  As far as I can tell if there is no external carrier associated the combo box gets hidden,  We have a few Ship Via codes that need a delivery confirmation related to Drop Shipping to customers that don’t have any external carrier plugin associated.  Is there a way to override the behavior and make sure this box is always shown? Thanks for any help, Phil

Access to the path 'C:\Program Files\Acumatica ERP\NipponDB\CstPublished\pages_ap' is denied from public url

I have an Acumatica partner that I do some customizations for.  After doing a customization, they want me to do some data clean up because there are fields in a custom table that need to be back filled and it would be WAY easier for me to update my custom tables in SQL Query Analyzer.  I could write "one time” scripts and put them in a customization project, but without visibility to see if the script did what I wanted, and without access to be able to query the tables, it is a mind numbing exercise to have the partner run the script in the project, create an extract and send it to me.  I’m sure you know what I am talking about here.I have my own databases hosted on Azure for my primary business and I can connect to them from my local PC, but the setup necessary to do that is not easy and requires some firewall changes and setting up Active Directory accounts.  So, is there any way I can get access to run queries on SQL databases hosted at Acumatica, the cloud etc.?  If anyone has done

I'm encountering the terms "surrogate key" and "natural key" while diving into Acumatica data management. Can someone explain the difference between these two key types and how they're used in Acumatica? Understanding their purposes would be much appreciated.  As you can see in documentation it has mentioned that for primary key use the suffix as ID and for natural key use the suffix as CD based on the requirement. But in some cases the natural keys and primary keys are two different columns. And in some cases both were in same column. Can anyone justify why so.

Hi guys, I am currently in the need of help to populate a custom field in the SOShipLine DAC that I have created. I want to populate this custom data field called UsrSerialCodes with the values of the Serial/Lot codes displayed per line number. Here is an example of a shipment with 3 entries with 3 different Line Nbrs: And here is the different serial nbrs for each line nbr when you go into Line Details: I have populated a list with these serial codes respective of the line nbrs and now I want to populate the data field (UsrSerialCodes) that I created respectively for each LineNbr in the SOShipLine DAC.  It seems like when I trace log everything, it populates the data field, but doesn’t display the values of the serial codes. It still shows a blank. Here is the code that I am using in the SOShipmentEntry Graph Extension: The overall goal is to transfer the Serial Codes to the ARTran DAC in order to populate them per OrigLineNbr in the so643000 report.  Any help on this matter would be

Hello all,I have the below code that works just fine and as expected in 2022R2. I am upgrading this package to 2023R2 and I am getting an error that “Cannot mark the record as updated because another record with the same key exists in the cache. Contact your Acumatica support provider for the assistance.” When I trace on the line that I try “journalGraph.Save.Press();” the problem is caused.Any idea what is going on or has someone come across the similar issues on upgrade to 2023R2? This is my code without any change from 2022R2 => 2023R2. #region Reverse Action & Method public PXAction<HCLPMWIP> HCLreverse; [PXUIField(DisplayName = HCLPMMessages.Reverse, MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton] public IEnumerable HCLReverse(PXAdapter adapter) { if (IsValidWIPDocument() == true) { try { JournalEntry journalGraph =

Hi,we have this Create AP Bill Action in the Details Tab of the Appointments (FS300200) Screen which will redirect to Bills and Adjustments Screen. we want this Action to display in the mobile application.  I have exposed the action form the Project editor.  And update the container with the Action name as follows.  now, even though the action is visible in the mobile application, it won’t redirect user to the Bills and Adjustments screen. it is showing a loading icon and do nothing. Help :)

Hello all,I am wondering how can I get the Data Type (string, decimal, int ...) of a field. I have a method like below and I need to know what is the Data Type of the “Field” public static void MyMethod<Field>(PXCache cache) where Field : IBqlField{ string fieldName = cache?.GetField(typeof(Field)); // This gets me the name correctly // I tried all below and they are returning null var aa = cache?.GetType()?.GetField(fieldName)?.FieldType; var bb = cache?.GetType()?.GetProperty(fieldName)?.PropertyType?.GetField(fieldName)?.FieldType; var cc = cache?.GetItemType()?.GetField(fieldName)?.FieldType; var dd = cache?.GetItemType()?.GetProperty(fieldName)?.PropertyType?.GetField(fieldName)?.FieldType; // Rest of my code} 

May I ask if there is a way to change the date formats in acumatica?I tried to format DAC, CreatedDateTime (Created On)  and ResolveDateTime (Resolved On) the format only working on CreatedDatetime column but the other column Resolved On though the dates are correct but the time was always 00:00. This how I format those columnsCreatedDateTimeResolveDateTime 

Think I already know the answer to this, but is it possible to make the grid on a process screen editable? Ability to change one or two fields.  I am pretty sure this is not possible but incase someone has a way around the norm would appreciate any insight.

Since upgrading to 2023R2 the Order Description is being automatically copied to the Shipment Description. This is not desirable and causing extra work as we have to remember to remove it manually.Is there a way to customize this to disable this copy? Thanks for any help, Phil

We use copy/paste all the time when creating new items and have noticed that since upgrading from2022 R2 Build 22.208.0012to 2023 R2 Build 23.208.0026when copying/pasting a stock item the Last Cost value is no longer included.Is there an existing way to include/exclude fields from the copy/paste routine?  If not is it possible to customize the stock item screen in order to re-enable that functionality?This is a significant issue as we have many items that need to be set up identically and it adds another step in the process which wasn’t there before. Thanks for any advice you can provide,Phil

Hi there, I would like to default the Text Formatting (as shown below) to Plain Text but there doesn’t seem to be a way to do it via any configuration.  I’ve looked into customization as well and confirmed that there are no such values in Customization Project Editor screen, and the whole thing is basically encapsulated under InventoryItem.Body. Is there a way to actualize this?  

Picture this:  One customization package adds a custom UI tab with grid and underlying view via graph extension.  A second customization needs to extend it by modifying the view and adding a new joined column to the grid.The problem: The custom tab needs added to the second customization package with a grid to make the change, and the result of publishing is that two of the same tab appear on the screen with different grid contents, because merging of a tab is problematic with the UI publish.I understand that modifying the first customization instead of adding a new customization would resolve this, but in this particular scenario, the first customization shouldn’t change for one instance, but for another it should.Any ideas for handling this?

In my customization code I create a prepayment, after the sales order is persisted.  How can I insert the prepayment record into the Adjustments cache?  I insert an SOAdjust record and attempt to persist.  But an error returns - a complaint about the field CuryInfoID.public delegate void PersistDelegate();        [PXOverride]        public void Persist(PersistDelegate baseMethod)        {                          baseMethod()                        ARPaymentEntry entryGraph = PXGraph.CreateInstance<ARPaymentEntry>();                        entryGraph.Clear();                        ARPayment payment = new ARPayment { DocType = ARDocType.Prepayment,                                  CustomerID = c.BAccountID };                                                payment.CuryOrigDocAmt = doc.CuryOrderTotal;                        payment.AdjDate = doc.OrderDate;                        payment.ExtRefNbr = doc.OrderNbr;                        payment.PaymentMethodID = detail.PaymentMethodI

Can you help me on how can I get the current user (username) then assign it to a variable?

I have a customization which updates a custom date field when another custom field (called UsrAIWHLPrice) is updated.  This has been working fine since 2022.  Since upgrading to 2023R2 the field doesn’t update any longer.  The code is below: protected void InventoryItem_UsrAIWHLPrice_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (InventoryItem)e.Row; if (row == null) return; try{ InventoryItemExt invItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(row); if (invItemExt.UsrAIWHLPriceChangeDate != null) { invItemExt.UsrAIWHLPrevPriceChangeDate = invItemExt.UsrAIWHLPriceChangeDate; } invItemExt.UsrAIWHLPriceChangeDate = PX.Common.PXTimeZoneInfo.Now; } catch (Exception error) { PXTrace.WriteInformation("error: " + error); } }There is no error in trace so I suspect it is b

Hey guys,  I am currently developing a customization where I need to attach files from the Invoices and Memos screen to the Email Activity screen. E.g from this screen: to this screen: I am currently implementing the following logic: But it looks like the trace log below the assigning of the emailActivity retrieves a noteID of null although retrieving a file from the invoice: Any help on this would be greatly appreciated! 

I have created a customization for our Pro Forma Invoices to include extra fields for submitting the Pro Forma Invoices to our finance department which is a simple check box on the pro forma invoice screen: PM307000I have built a generic inquiry to show these checkboxes which have been checked or not, but now the users want a way to update multiple pro forma invoices at the same time. I have edited the generic inquiry to add mass update fields which gives me the functionality with the actions → Update, but there is an Update All inside this action bar, I do not want this there as there is a potential that a user might update all pro forma invoices accidentally. Is there a way to either remove Update All or make it disabled with a role or completely remove it from this Generic Inquiry? 

Is it correct to filter on ARInvoice using a statement like : Where<ARInvoice.status.IsEqual<"Closed">>?

Hello all,I was wondering can we open the dialog shown using the Vie.AskExt() method (it shows a nice and neat grid) in a new tab by existing tabs instead of displaying a dialog in a new window without going the long way of designing a grid … and all other required works to use in redirect? Here is the code: public PXAction<MyDac> showHistory; [PXUIField(DisplayName = "Show History")] [PXButton] public IEnumerable ShowHistory(PXAdapter adapter) { MyView.View.AskExt(); // Can I show this in a new tab? return adapter.Get(); } 

There is a need to maintain an automated external reports repository. That means After executing a report and then clicking the save it as a PDF, automatically the downloaded report’s PDF should be uploaded to OneDrive. 22R2 is the current version. Can I know is this possible and if it is possible I kindly request please give some guidance regarding this. Thank you.

Is there a way to get the current user role or type in a code then assign it to a variable?

HI TeamWe have a requirement where we want to override the ChangeID button in customer screen and need to update the CustomerID value through code. We also want to do it at the time of Customer sync from Bigcommerce to Acumatica.Could someone be able to assist me with this? I would greatly appreciate any help.