Other Developer Topics

Hello Everyone,One of our clients wants to use Microsoft power apps to read and write data from acumatica. Acumatica power app connector only provides few objects which are not useful in our requirement and we want to add appointment screen to this connector so they can access required objects related to Appintments in the PowerAppsWe are not sure on how to proceed on this or way to customize the connector. Could you guys can provide the steps to customize the power app connector or inside acumatica to access required objects related to Appintments in the PowerAppsThanks

Good day,The MAIN Location is tagged with warning message :Record as Been Deleted. Any advice on correcting this issue would be grateful.  The MAIN location is active.  Don’t see any issues when using it on SO.  Below is a note from TC that they believe is causing an issue with the 945We are having some integration problems with our customer Home Depot Pom, when receiving the 945 we are getting a location missing not valid error from True Commerce. While investigating it appears that our customer master has an error for the “MAIN” location which is what we are mapping to. I met with the developer at True Commerce this morning and he thinks the issue is being caused by the customer master error below. The error says, “the record has been deleted.”Thank you.@Evan G   

When you create a new Action in Acumatica you have two ways of doing it:1) Using PXAdapterpublic virtual IEnumerable migrateSalesPeopleFromAcumatica(PXAdapter adapter){ ///Any Code return adapter.Get();}2) Without PXAdapter as parameterpublic virtual void migrateSalesPeopleFromAcumatica(){ ///Any Code} So my questions are:1)  What is the purpose of the PXAdapter parameter?2) When should I use one option over the other one? Regards

i am using servicegate like that for login. When I publish My endpoint in Live account .i found that error. when i call loginnasync method  

I'm currently trying to test some of Acumatica's command line functionalities. I created an Instance on a computer through the CLI Tool, and then copied the instance + database over to a different machine. I got the site running by starting it directly with IIS and up until now it’s been running succesfully.However, I am now trying to upgrade the site through the CLI Tool, and Acumatica doesn’t seem to recognize the site's existence. Is there any workaround to get Acumatica to detect the site so that I can run the upgrade/other additional commands?I’m attaching an image for reference on the error I’m getting. Just to be clear, I can only manage this machine through CLI.EDIT: this is the command I ran to start the Site with IISNew-WebApplication -Site 'Default Web Site' -Name 'Acumatica21.1' -physicalPath 'C:\AcumaticaInstances\Acumatica21.1')

when i  call serviceGate.LoginAsync method i get this response .  

Can I write a custom process (not a screen) and schedule it run within Acumatica? By a process I mean some code that says loops a Generic Query and calls some web services.  Not attached to particular screenThanks in advance.

Hello!I’m invoking a processing form through API, and all the process is executed correctly, but, how can I know when a record is processed with errors?I’m trying to get the processing result to know what records have been processed and what records have raised errors…  

If you Move code to an extension library (DLL), can that code be published to a hosted Acumatica Site.  By Hosted I mean a site that is like youcompany.acumatica.com.  An instance hosted by Acumatica, which you cannot access the servers. 

Hi,In Unit Test Framework can we fetch values from DB or using PXSelect Query for Table.I am getting null object when i use PXSelect in unit test frameworkThanks.

how to get account name and account balance in Acoounts through rest Api

Hello Acumatica Community,In standard procedure, Acumatica’s TestSDK relies on Wrapper/Extension combo to translate the UI screen elements to a code file(wrapper) then make that code accessible to your tests using an Extension file.This works in 98% of the cases, and is the recommended format for all tests.Some good reasons to use DynamicControl over the standard wrapper/extension format are:When you need to preconfigure your initial state test website before wrappers can exist, and you need to use your custom screens or enable a feature to complete the config (screens must be configured via TestSDK code before wrapper generation or else the screen will fail to generate successfully) When you add 1 or 2 simple buttons or fields to an existing Acumatica screen, and you want to test it without generating a new wrapper/extension combo. In the rare case a field is not generated through classgenerator.exeSome simple examples:Case.Attributes.DynamicControl<Input>("Testing Details").Typ

Hello,Some ISV Solutions contain externally hosted popup forms, or other UI elements that are missed by the Wrapper Generation process ClassGenerator.exeThe most common example being Credit card capture popup forms. The solution to access these fields require you create your own Wrappers manually.Below is an example Extension file that has the custom wrapper code inside of itFor selecting elements, if the field has an ID="firstName" you can simply putFirstName = new Input("firstName", null, null, null);otherwise you can use any other unique CSS attribute, such as label, text or any other attribute from the browser Inspection Element window.You can look at more examples by looking at any other wrapper class for similar structure, but in their case auto-generated by ClassGenerator.exe   Then use it like any other extension inside your test.HostedFormHandler Hosted = new HostedFormHandler();HostedFormHandler.City.Type(“Montreal”);HostedFormHandler.Add(); public class HostedFormHandler : W

Wondering how to use the TestConnection on a few different screens,  the behavior seems the same for them all.    Filling in a form with valid data,  will then invoke TestConnection.   From the UI, sure the respective dialog box  appears.  But the test code, not sure how to handle it.   Meaning nearly immediately an exception is thrown. I’ve tried with:ctpSetup.TestConnection();ctpSetup.TestConnection(true,"Successfully Connected to ClickToPay Server");    While the exception text is: ex.Message == “Long operation failed, did not start or resulted in a redirect, timer control is not available”   Not sure how to invoke the TestConnection() as it is a void, could understand if it allowed chaining some kind of Wait, but as a void…  Sure there is something i’m missing…  Couldn’t find anything the the TestSDK.pdf, the discussion forms here,  or anywhere covering this…  Is there a better more specific forum for the TestSDK? Thanks in advance.  

Hello, I have recently been working on the implementation of a customization publication project through the SOAP service type with api/ServiceGate.asmx, I encountered this problem when consuming the endpoint to upload the packages to the platform:  The method is:private static async Task PublishCustomizationPackage(string packageFilename, string packageName, string url, string username, string password) { BasicHttpBinding binding = new BasicHttpBinding { AllowCookies = true, Security = { Mode = BasicHttpSecurityMode.Transport }, OpenTimeout = new TimeSpan(0, 10, 0), SendTimeout = new TimeSpan(0, 10, 0), ReceiveTimeout = new TimeSpan(0, 10, 0) }; EndpointAddress address = new EndpointAddress(url + "/api/ServiceGate.asmx"); var gare = new ServiceGate.ServiceGateSoapClient(binding, address)) Co

Hi All,We need to implement action that will redirect a user to the external site via POST request that will contain request body with log-in details.PXRedirectToUrlException allows us to redirect to the URL, but does not allow us to specify POST request method and request body.Article on Asia Blog suggest to use "Redirect on PageLoad", but it seems that it's sending GET request by using Window.open(url, target). Plus at Page_Load() we don't have access to the db to retrieve all the data for request body.Is there a way to redirect with POST request and payload (preferably from code)?

need help

Can the ATTRIBUTES section of the Item Classes screen be extended downwards to fill the screen.

Hello Acumatica Test SDK Developers,Edit: Since this post we have updated our certification guidelines to require use of the GenerateWrappers() method found in this Template Project, https://github.com/Acumatica/Test-SDK-Starter-GuideThere are comments in the code/method with the updated advice of GI wrapper generation. Two common problems developers run into while developing and updating their Test SDK tests:Wrapper generation fails, “so301000.aspx not found” type error PL/Generic Inquiry screens being skipped during wrapper generationIssue #1 causes the classgenerator.exe to fail, and often break the website by locking the web.config, meaning you have to restore the original web.config, or reinstall the site from the installer to use the site again. A major Pain, a major waste of valuable time.Issue #2 will just skip generation of that PL screen if placed in the regular screen spot. Solutions:<add key="Username" value="admin@Company" /> must exist in the classgenerator.exe.conf

Hi Acumatica TeamCurrently , we would like create a scoring system to tie with individual/department KPI , not sure if Acumatica got this kind of function ?  Hope to hear from you soon.

Good day! We have heard that certification tests, now available only on the Partner Portal, will soon become available through Acumatica Open University. Is there a target date for this? Thank you!

I am getting an error on my unit tests after upgrade to 22R1, specifically as shown below:Am I missing an updated PX.Tests.Unit DLL or other ?   Message:System.MissingMethodException : Method not found: 'System.Threading.Tasks.Task PX.Licensing.IApiLicensePolicy.ApplyRequestThrottling()'.  Stack Trace:TestBase.RegisterServices(ContainerBuilder builder)LifetimeScope.CreateScopeRestrictedRegistry(Object tag, Action`1 configurationAction)LifetimeScope.BeginLifetimeScope(Object tag, Action`1 configurationAction)LifetimeScopeHelper.BeginLifetimeScope(ISlotStore slots, Object tag, Action`1 configurationAction) line 39TestBase.ctor() 

SQL Server 2016 introduced support for JSON objects as field values. As Microsoft explains, this allows the mixing of SQL and No-SQL methodologies in a single database:https://docs.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver15It occurs to me that Acumatica might experiment with using these features to store attribute data. The biggest advantage of JSON data structures is the ability to store multi-level data structures in a single value. For example, let’s say we wanted to describe all the possible values of multiselect attribute in Acumatica. With JSON, this is a single object, and a single request… i.e. {colors:  [“blue”, “black”, “red”, “brown”] }. Getting more complex, let’s say we want to describe an inventory item class with widths and lengths that are unknown at the time of the creation of stock item. We can store the object as{ItemClassID: “MYITEM”, Dimensions: {   Length: 0.00,   Width: 0.00,   Height: 0.00 }}, and then when we cr

Hello, Acumatica Community.We are planning to extend our Acumatica system to include our Portugal office, and we know the Portuguese government requires ERP certification and other procedures for AR invoices to be issued.Our VAR is looking into this, and I am also investigating.  Has anyone had experience using Acumatica in Portugal?  I am hoping there is a native solution or an ISV product.Thanks to all for your help.Greg

When we want to check button or any field’s UI attribute that is Enabled or not. how can we perform it?