Develop Customizations

Hello,         I like Acumatica’s user defined fields feature, I can add fields without writing code.But these fileds are disabled when the shipment is completed, while I’d like to keep it being enabled.    Is there a way to do it?         I’ve found a similar question above, but as I checked, I can not find the “UDF” in automation steps. So I can not enable it.      Is there any other way to do it?

Hello All,I am trying to retrieve data using OData V4 but I get the error in the subject line. Everything is on my local machine and works with OData V3. Any help is appreciated why does V3 work but not V4?

When I create unit tests, I reference PX.Tests.Unit.dll, but always have this error.although I don't use this 'Microsoft.Bcl.AsyncInterfaces’. Is there any good way to solve this problem?“Could not load file or assembly 'Microsoft.Bcl.AsyncInterfaces, Version=1.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)”  

I have a custom field that is throwing the following error:Error: An error occurred during processing of the field PD Inches/SQIN: Specified cast is not valid..I have the following  #region UsrPDinches [PXDBInt] [PXUIField(DisplayName="PD Inches/SQIN")] public int? UsrPDinches { get; set; } public abstract class usrPDinches : PX.Data.BQL.BqlInt.Field<usrPDinches> { } #endregionWhat could be causing this issue?Another questtion,This field is on a production order. I can’t find how to disable the field when the production order status is completed. How do I do that?

Hello all, How would I go about changing the default value in the customization project for a specific field on a form?  I though it would be under this section, but I haven’t had any luck so far.

Hi all,I want to add a new field to the SO that the value is from the customer’s buying group. The buying group is under the Attributes. I tried to use PXDefault to search the attribute’s value. But I have a problem is I need to use fixed attribute ID. The value is not linked with the buying group value. I need to save the value to the database at that moment. Because the buying group value may changed later. Does any one knows how to do it ? Thanks.     

Hello there,We can add side panels to Entry screens now, and that’s awesome!  However, I can’t figure out a way to add a side panel, that would be filtered according to the selection on the SO Line.  I have created a couple GIs, added them onto a Dashboard that uses InventoryCD as a parameter.  Now, I would like to be able to add this Dashboard as a side panel to Sales Orders screen, and filter data based on what line item is selected on the sales order.Any ideas?  Thank you!

Has anyone created a customization to automatically attach files to an invoice? We need a solution where we can attached service order reports to SO invoices upon emailing. Someone submitted an idea on this matter 2 years ago, with several upvotes, but Acumatica hasn't acted on this yet.  

Hello Goodnight. How can I put de sum of the “Vendor # 2 Amount” column (grid) in the Total field ( Vendor # 2).the result in the “Vendor #2” field should be: 180. I need to update the total value (Vendor #2 field) for each record the user adds in the grid (the user does not necessarily have to save the record to reflect the update in the “Vendor #2” field) too. Additional: is a master detail form could someone help me please.

Hello everyone!I’ve recently been upgrading several custom pages—and extensions of standard pages—to the Acumatica Modern UI. Below is a collection of notes, lessons learned, and practical tips that I hope will help others going through the same process. If you have additional insights or best practices, please feel free to add them in the comments!  1. Quick-Start Process for Converting Classic Forms to Modern UIThe process flow for converting Classic forms is not always intuitive. Here is a simplified guide to get your custom forms converted quickly. (Note: For extensions of standard forms, I’ve had the most success creating the Modern UI files manually and then moving them into the development folder.)Steps:In your web.config, set the screenConverter attribute shouldFilesbeDownloaded="False". Navigate to your custom form. Open the Customization menu and click Convert to Modern UI. Acumatica will place the generated files in: site\FrontendSources\screen\src\development These files wi

I am new to Acumatica and our company is a customer.  I’m an experienced developer but I’m having trouble getting started with Acumatica customizations.  It doesn’t seem that our var has much experience with customizations so they have not been able to help me get my system setup correctly.  From what I’ve researched it seems that I must have a local instance of Acumatica installed on my local machine and that the database used in customizations has to be created using the Acumatica Framework Configuration Wizard.  We had previously setup a database and web site for development through Azure but I’m not seeing a way to use those now.  If someone can help me understand exactly what I need to do to get started with customizations it would be a great help.  This is what I think I need to do:Install Acumatica ERP on my local machine Deploy Acumatica Framework Tools Deploy New Instance of Acumatica Application Template or should I use the Deploy New Application Instance for Training Course?

Hi,Though I have added all the references and dll to the customization project and solution, I am getting the below error. Thanks,

Hey Everyone, The other day I created a GI to fetch all Payments done by Invoice and I think I achieved what I wanted. However, when I try to create a connection via oData on PowerBI I get the following error: DataSource.Error: We couldn't parse OData response result.  Error: Unexpected end of file while parsing Name has occurred. Line 31, position 19.Details:    DataSourceKind=OData on Acumatica I can view the Inquiry and even export via Excel, I just don’t seem to be able to connect to Excel or PowerBI via oData. Has anyone experienced this before? Please see below some snapshots of the Inquiry. Tables Relationships ConditionsGrid Or if anyone could suggest a better way of grabbing all payments done within the month (including credit card and cash). Sorry, I’m very new to this :) Thank you so much!!Brian SIlva

I just completed the quiz for T200. How can I get my certificate for that ?

Should user-defined fields be created using a customization project or just adding them directly into Acumatica is fine? I have not setup a customization project before but I have heard that creating customizations within a customization project is recommended since you can apply and unapply with the upgrades. I am trying to consider if there will be any issues with upgrading and user-defined fields. 

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

We have a development environment that has many instances of Acumatica installed and in the past week or two publishing from the customization project editor no longer works.  The log window at the bottom opens and nothing is logged.  There is a warning in the windows application log for ASP.NET.4.0.30319.0.  I have included the details at the bottom.  This is happening for all 20+ versions of Acumatica installed in any application pool. There is a workaround to update any changes through the editor, but then publish from the customization projects list screen (SM204505).Thanks,Kurt Bauer Event Log DetailsEvent code: 3005 Event message: An unhandled exception has occurred. Event time: 10/15/2020 8:42:56 AM Event time (UTC): 10/15/2020 12:42:56 PM Event ID: 908185df7ee84a46bd4210f5c030eb43 Event sequence: 15 Event occurrence: 1 Event detail code: 0  Application information:     Application domain: /LM/W3SVC/1/ROOT/XXXXXXX-2-132472393165235242     Trust level: Full     Application Virtua

Hi I’m getting an error when over supplying lot\serial numbers. Is there a way to override this validation ?There’s a settings that allows negative quantities on inventory items. Is there a similar settings for lot\serial numbers ? Shouldn’t these two go hand in hand ?  Thanks Roderick

Hello, I manage to create a custom filed and set it to dropdown list but only with static values code below : [PXDBInt][PXIntList(new int[] {0, 1, 2, 3}, new string[] {"North", "East", "South", "West"})][PXUIField(DisplayName="ListLibre1")] I want to modify the dropdown list values dynamically and directly on the screen.How it can be done ? Thanks :) 

I will gloss over the absurdity, for now, of a “low code/no code” platform requriing this kind of technical solution to do something as simple as redirect the user to an external website by clicking a button:https://asiablog.acumatica.com/2017/08/redirecting-to-external-page-from-button.html I have implemented the solution described in the article, with a button in the Sales Order toolbar to launch a custom item lookup screen (it’s an external webpage that lives outside Acumatica and communicates to Acumatica via webhook).That all works well, except for one thing. If I try to pass any query parameters in the url (standard http get request….i.e Redirect8: http://www.mysite.com?myqueryparam=bob, then for whatever reason the query parameters are all stripped when the page loads. This seems to be happening with some sort of Javascript perhaps (I haven’t traced the source yet), because it’s very clear that the url is requested with query params, but then ends up without them. If I load the

Hi All!I have been trying to figure out how to customize an existing screen to add a tab in the stock item that is the same set up as cross reference tab, but for customer forecasting. I also would need to be able to have a user input field so we can manually input/update/change the customers forecast for that part. Then we would be able to run a report of actual vs. forecast for each item by customer. Any help or input is greatly appreciated, and any other ideas as to how to accomplish this is welcomed as well. Thanks!!

Hi,I was thinking if there is a way in acumatica to add a custom field that will store a web address and that somehow on the screen the user can click on it and take it to the site.I was going through each of the acumatica screens but I have not found examples, only some similar functions at the grid level.If anyone has the knowledge or some guidance on how to do it or if it is feasible to do it in acumatica, I would appreciate it very much.

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

Browsing the Forums, it seems many people have Easypost working with Acumatica to generate their Customs Documentation automatically from Acumatica.  I’ve installed the Easypost customization and have Fedex and UPS working, but I can’t determine which fields on the shipment I’m supposed to enter the required Customs information (Commodity type, Customs Value, Harmonized Code, etc.) to generate the commercial Invoice.It seems easy enough to create the Customs Object for the Easypost API, but I can’t find any documentation on the Easypost customization project (that I believe Acumatica maintains) that shows what fields map to what.  The project does add some extra fields to the shipment.   thanks!

In my code I’m looking to see if an invoice already exists before proceeding.  I was using this query: ARRegister invoice = PXSelect<ARRegister, Where<ARRegister.docType, Equal<Required<ARRegister.docType>>, And<ARRegister.refNbr, Equal<Required<ARRegister.refNbr>>>>>. Select(this, receiptRow.ApplyToDocType, receiptRow.InvNbr);But it would not find the record.  I confirmed that it is in the ARRegister table (local install, local database).So I decided to try this:ARInvoice invoice = SelectFrom<ARInvoice>. Where<ARInvoice.docType.IsEqual<@P.AsString>. And<ARInvoice.refNbr.IsEqual<@P.AsString>>>. View. Select(this, receiptRow.ApplyToDocType, receiptRow.InvNbr);and that worked.  It is a different table but the primary keys on both tables are the same.So, my question is, what’s the difference between the PXSelect and the SelectFrom calls? In case it matters ‘this’ is within an Action bu