Solved

I am looking to install a new instance on my personal computer for training.How do I navigate the database Server connection request for - server type and server name per MYSQL server- not conversant with this.Can anyone help

I’ve been learning how to create screens from scratch using the new UI framework, and so far I’ve created a simple maintenance screen and a basic Inquiry screen.The maintenance screen is working just fine and the Inquiry screen is also working as expected except for one peculiar issue that I need help with that doesn’t even seem related to the new UI.(I’m suspicious I may be overlooking something obvious, but the solution has eluded me!) I am aware that the new UI is not ready for production use - I’m just trying to learn what I can so I’m ready for it!The inquiry screen is built on a simple projection DAC and combines information from SOOrder, SOLine, and SOLineSplit.The header of the screen has 2 filter fields.Inquiry header filtersThe “Only Show Completed Lines” filter is working correctly and when selected, only lines with an order status of “Completed” are shown.The “Warehouse” filter returns 0 records when a filter value is entered. No Matching Records FoundI’ve shared screenshot

Hi All,We have observed issue on project billing screen with respect to tax calculation.Scenario:C90000 – Customer created  with Avalara Tax Zone.C90010- Customer created with Manual Tax Zone. On Project Billing screen customer with Avalara Tax Zone , the tax calculation is zero always, and not calculating taxes from Avalara. When we use the Manual Tax Zone with Tax Schedule. the tax is calculated. Did anyone had this issue and what is the best option to solve, also if any later version which is available with the fix, please do suggest.  

Is there a out of the box solution / setting to always exclude credit or debit memos from Statements?

We are using Apple iPhones. Trying to add photos to the service appointment in the mobile app.Taking a photo in the app works fine, however if we select ‘Insert Photo or Video’ for adding a previously taken photo we get an error saying ‘File type pvt is not allowed.’.  We believe that because it has the ‘live’ option enabled on the photo so we turn the live off.With Option ‘Automatic’ we then get error ‘File type heic is not allowed’With Option ‘Current’ we also get error  ‘File type heic is not allowed’With Option ‘Most Compatible’ we get ‘File type thumb.standard is not allowed’Anyone have any idea what we need to do to get it to insert photos that have already been taken?

Hi all, Does anybody have a import Template for Fixed assets balances to share with me. thxDries

On the Purchase Orders Screen (PO301000), I’m trying to extend the View responsible for populating the Details Tab. Specifically, these details are made up of Purchase Order Lines (POLine) which each have an InventoryID, which is the identifier for an InventoryItem. I want to be able to add data fields from the Inventory Item to this View in order to be able to add them to the Details Tab Grid. Does anyone know how to do this? Below is my attempt to override the original PXOrederedSelect responsible for creating the Data View that populates the Details Grid. I add the PXOverride and the LeftJoin logic, but everything else is the original code.[PXOverride] [PXViewName(Messages.POLine)] [PXImport(typeof(POOrder))] [PXCopyPasteHiddenFields(typeof(POLine.closed), typeof(POLine.cancelled), typeof(POLine.completed))] public PXOrderedSelect<POOrder, POLine, LeftJoin<InventoryItem, On<POLine.inventoryID, Equal<InventoryItem.inventoryID>>>,

I am wondering why I don't see a blue-shaded area to drag an appointment to for most staff listed on the calendar board. I assume it should look like the image below: 

hello all,I found out that we have 3 types of LC docs. How can I record for Correction & Reversal types?  

Hello all,How can I add a visible expression for localization. I have 2 images. One is in english & other in German. I am looking to add a visible expression that when the Locale = English and my first image should be display and when Locale = German then my second image should be displayed.

How do I add the + sign for New Opportunities back to the Opportunities Page? The + sign/add new opportunity has disappeared. It used to appear between the Cancel button and the pencil (edit record) button.   

Hello, I have created a workflow action in screeens FS300200 with a dialog boxes associate to it. The dialog box is working well on web browser both on computer or mobile. When i use the mobile app, the screen dont show or is shown empty if the action “the Expose to Mobile” is cheked.Preview of the dialog box In customization project > mobile application, i have added an update FS300200. My issue is i dont see the dialog boxes created for the screen in the WSDL schema so the container is incorrect. Is there a way to have accces to those kind of dialog box or i will need to create a custom smarth panel for mobile? Code in mobile APP (I have try the container where is see my field)update screen FS300200 {  update container "AppointmentRecords"{    add containerLink "Attributes"    add recordAction "SurveyToDo" {      redirect = true      redirectToDialog = "FS300200D6"    }  }    add dialog FS300200D6{      type = FilterListScreen      openAs = Form      add dialogAction "Ok" {       

Hello, guys. How can I modify this report screen? For example, I want to add a button. Is this possible at all?  

Hi there, I am trying to update the status of an inventory issue using the REST API from On Hold to Balanced so that I can then invoke the release action. I am sending just the id and the status as you can see below:url: {{baseurl}}/AcumaticaERP/entity/Default/23.200.001/InventoryIssue { "id": "538ecce5-8c49-ef11-9061-e848b8c82000", "Hold": { "value": false }, "Status": { "value": "Balanced" } }I get a 200 response, but the status of the Issue is still On Hold. Using the same json I am able to update Inventory transfers without an issue. Is there something that I am missing? 

Hello,I have a custom report which uses the InventoryItem dac and i want to sort it by the UsrReportLine custom field which is in the InventoryItem dac and it is a nvarchar type. I have applied the sorting but the sorting doesn’t seem to be working properly.This is the report outcome. But the sorting doesn’t workRelationshipSort conditionI have also attached the rpx file below. Please if anyone could check and let me know i would greatly appreciate it! Thanks.

CASE :   Let's say we have attached a File on a Vendor.Process: 1. Create PO 2. More Options > Click On Email Purchase Order3. The File attached in the Vendor, should be displayed on the Email Activity Screen WHAT WE IMPLEMENTED :you can refer to the code mentioned below ISSUE WITH THE CODE :The implemented Code is that when we Create an Activity, it is not being attached on the first Time.But when we Create an Email activity for the Second Time for the Same PO, it is  Attached.We tried implementing Row Inserted, Row Persisted Events,  but the Event is not hitting when the email activity is Created. WHAT WE NEED HELP WITH :To fetch the files attached to the vendor, in the First Go Code we Implemented:  Image 01 Image 02 

Hello Friends We have an Acumatica 2021R1 instance with build 21.116 Using the Apply Updates screen, we are trying to upgrade it to 21.119 build.  Right after the upgrade process is completed, we are seeing this error messageCould not load file or assembly 'PX.Telemetry.Adapter, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. Could you please assist if there is anything that I am missing here on the upgrade or if anything needs to be done before initiating the upgrade?   ThanksSaikumar C 

Server Error in '/AcumaticaERP' Application.Found columns for index #0 not present in headersDescription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: Found columns for index #0 not present in headersSource Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:  [InvalidOperationException: Found columns for index #0 not present in headers] PX.DbServices.Points.MsSql.NativeMetadata.IndexReader.(IDataReader , IDictionary`2 ) +500 PX.DbServices.Points.MsSql.NativeMetadata.IndexReader.Load(Func`1 adapterSupplier, MsSqlScripter scripter) +1076 PX.DbServices.Points.MsSql.NativeMetadata.MsSqlSchemaReader.GetIndices(String table

I just need to know what the possibilities are for it and how to solve such issues. Here is an illustration  

In Projects screen (PM301000) When I click the Status changed to Active State (By clicking the Activate Project the status Change to active from In planning) , I need to Create a Task (CR306020) in the activities tab add added as a row to it. also I need to pass some parameters from summary tab to  task form. like;PMProject.ContractCD = CRActivity.SubjectPMProject.StartDate =CRActivity.StartDate_DatePMProject.OwnerID = CRActivity.OwnerIDbelow is the error I'm getting and the code any help to resolve this sss using PX.Api;using PX.Data;using PX.Data.DependencyInjection;using PX.LicensePolicy;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.CM.Extensions;using PX.Objects.Common;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.CT;using PX.Objects.EP;using PX.Objects.Extensions.MultiCurrency;using PX.Objects.GL;using PX.Objects.GL.FinPeriods;using PX.Objects.IN;using PX.SM;using System;using System.Collections;using System.Collections.Generic;using Syste

  I need to clear the inserted header notes values when the additional information field below gets updated. I tried the code below, but the value remains. The header value sets to empty only when I refresh the page. What am I missing here?  var note = PXSelect<Note, Where<Note.noteID, Equal<Required<Note.noteID>>>> // Clear the header note field note.NoteText = string.Empty; Base.Caches<Note>().Update(note); // Clear the caches to refresh the UI Base.Caches<Note>().ClearQueryCache(); Base.Caches<Note>().Clear(); Base.Views.Caches.Remove(typeof(Note)); Base.Caches[typeof(Note)].Clear(); Base.Caches[typeof(Note)].ClearQueryCache(); 

Hi All,I need to know how to create a lead from an email. I tried but couldn’t create a lead. 

 Hi All, Great idea having us MYOB users utilise the Acumatica forums and as per Kim's introduction post we linking how to utilise the existing Knowlege base and idea boards.I was a present Acumatica account user and previously I didn't have access to the Product knowledge and the Product idea areas.  Is there a process to get access to access to these areas now so we can help contribute our ideas and use the knowledge base?Knowledge Base: https://community.acumatica.com/knowledge-baseIdeas: https://community.acumatica.com/ideas

Hi Team,I have customized a screen and action button to insert list of records into my custom table. I can able to insert single record at a time, but array list fails. Could you please provide me the correct JSON format for inserting array of records.I tried the below format but it’s not working.[    {    "ScannedId": "14",        "ShipmentNbr": "SDO592042",          "LineNbr": 1,        "Quantity":  1.000000    }, {    "ScannedId": "15",        "ShipmentNbr": "SDO592042",          "LineNbr": 2,        "Quantity":  1.000000    },]   Regards,Ramya

In order to automate the Prepare Invoice process in Process Shipments I need to be able to filter for a specific group of customers. Unfortunately Customer Class is not an available filter, so I am wondering if anyone recommend another way of achieving the same thing ?