Discussion Forums

Hello,I have a custom long run in a IEnumerable action and upon return, the Shipping_Contact fields return as disabled. Currently, I have to manually cancel the order to re-enable them- see below for my code:public PXAction<SOOrder> CustomAction;[PXProcessButton(CommitChanges = true, Category = "Processing", DisplayOnMainToolbar = true, Connotation = PX.Data.WorkflowAPI.ActionConnotation.Success)][PXUIField(DisplayName = "Custom Action", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]public virtual IEnumerable customAction(PXAdapter adapter){List<SOOrder> list = new List<SOOrder>() { Base.Document.Current };Base.Persist();PXLongOperation.StartOperation(Base, delegate (){ /*Logic*/ });return list;}To say I tried it.. I have tried adding Base.Cancel.Press(), Base.Shipping_Contact.View.RequestRefresh(); right before returning the list but as I expected, this does not work. I figure this is because the IEnumerable return overrides anything I

How can i connect a Acumatica server to Power BI so that i can visualize Top 20 customer, Top 20 Sales Order like that.

In Production Details screen’s extension, I have added an Action called ConnectToMRN.  In it’s workflow extension I have defined a dialog box also. I customized the Action such that it pop up the dialog box on click the button using the customization editor as bellow. Following is complete workflow customization code of the production details screen.public class ProductionOrderWorkflow : PXGraphExtension<ProdDetail_Workflow, ProdDetail>{ public sealed override void Configure(PXScreenConfiguration config) { Configure(config.GetScreenConfigurationContext<ProdDetail, AMProdItem>()); } protected static void Configure(WorkflowContext<ProdDetail, AMProdItem> context) { var formAssign = context.Forms.Create("FormAssign", form => form.Prompt("connectto").WithFields(fields => { fields.Add("ConnectTo", field => field .WithSchemaOf<MRMaterialRequest.refNbr>() .I

We are looking for exception reporting on Back Order Inventory Items, at the Sales Order line level: For Sales Orders that have Back Order Status, we want to pinpoint the specific Items which are on Back order.  Is there a Back Order Status at the Sales Order Line level to flag which Inventory Items caused the Back Order, for follow up?

Hi All,The Commerce Retail team has recently prepared a technical guide about import of Refunds supported by the Acumatica Shopify connector in version 2023r2. This guide covers the most common refunds scenarios for Shopify orders with cash or credit card payments. We believe that this document will help to improve users’ knowledge of the refund import process and what results they can expect.If there are any other frequent scenarios of refunds applicable for Shopify orders, please let us know in replays for this post. Thanks

Hello,Looking for a little guidance on how to get client side JavaScript to work. We are evaluating a platform called UserFlow the automates onboarding by guiding you through the product with prompts and such.The installation require injecting JavaScript into the body of the page then calling a couple of functions to initialize and start user flows.I placed the main JavaScript into a columns container in the header of the Customers page, then attempted to initialize in the Init property of the data source. I even put a couple of buttons on the screen to call the initialize and start functions. Does it look like this should work?   Thanks,Mark

Hello to everyoneIm doing a GI to show me the run out date, i already made to show me the date but it show me with the time.. how can i get to forces to show me only the date mm/dd/yyyy thank you 

I have created a custom screen called Material Reques Note (MRN). I need to add two button which crate an Issue and a Transfer base on the MRN data. When trying to create an INTran DAC instance for each inventory item in the MRN it does not works. According to the investigations did by me I assumes that INTran type instance did not initiated correctly. I hope that may need to Set more field values. Following is my action code for one button.  public PXAction<MRMaterialRequest> CreateIssue; [PXButton(DisplayOnMainToolbar = true, CommitChanges = true)] [PXUIField(DisplayName = "Create Issue", Enabled = true)] protected virtual IEnumerable createIssue(PXAdapter adapter) { MRMaterialRequest mrn = MaterialRequestView.Current; PXResultset<MRInventoryItems> items = MaterialDetailsView.Select(); PXLongOperation.StartOperation(this, () => CreateIssueDoc(mrn, items) ); return a

Currently all Restriction Group access screens are limited by the Header the Function example Vendor/Customer For Maintenance how do I create a GI that will show the Restriction group including all the included Vendors I cannot find a link?    

Having an issue trying to close a completed production order. When I hit process in the Close Production Orders Module, I receive this error message: “IN Error: Unit conversion EA is missing.”Is this coming from the stock item or the completed production order. The base unit for this stock item is listed as EA. Thanks!!

Hi All,Trying to setup a label report. It consists of two labels on one report with the next function on the second label. The first label prints fine without spaces but the second label add a small space. This then gets added on each subsequent label.On the preview you can see it here:The two detail sections are exactly the same:Then on Acumatica it also only shows one label per page and not 2 with a white space at the bottom. Footer sections has been set to invisiblelooks like this when printing: 

Hi everybody,Is there a native way to using the REST API to filter the list of ProjectTasks (for example) based on a single Attribute’s value? I tried a couple things for the $filter. I tried referencing attributes as if it they weren’t an array, like so.Attributes/AttributeID eq 'SCOPE' and Attributes/Value eq 'Test'But I got this error: “The parent value for a property access of a property 'AttributeID' is not a single value. Property access can only be applied to a single value” Then I tried using the `any` lambda, referenced here:Attributes/any(a: a/AttributeID eq 'SCOPE' and a/Value eq 'Test')But I got this error: “The method or operation is not implemented.” Is there any way to do this?

Hello,I am trying to tinker in the system to get project manufacturing working as it says it should (for my knowledge and understanding) but I feel like there is something I am missing. I am using standard sales demo snapshot and 23R1. Please see the below for steps I’ve taken to attempt to get project transactions generated through a production order. I am expecting both labor and materials to come through and am currently seeing neither.Create production order on project (‘Update Project’ is checked) Material and labor transactions created No corresponding project transactions created  

Trigger a Notification when the Particular Inventory received the Goods for the first time in the year ( is purchased for the first time in the year ).Any Suggestions.

Hello,I’m doing an import to create brand new Business accounts via Excel spreadsheet.  Everything is importing correctly except two attributes that are, of course, super important for us.  The attributes are COUNTY and TTM.  It errors immediately with “One or more Attributes are not valid.”  I have included the scenario and a small version of the Excel spreadsheet.  I have tried having Commit checked and unchecked for both of them.

How to automatically update project current margin estimate that equals total revenue budget minus total cost budget divided by total revenue budget?

Hello all,I am currently implementing token retrieval using HttpClient in the .NET Framework and have encountered an issue. I am using the SendAsync method to send the username and password in the JSON body as part of the request, but I'm experiencing difficulties with the token acquisition.Below is a snippet of the code I am using for this operation:public PXAction<INRegister> PrenderAntena;[PXButton][PXUIField(DisplayName = "Prender Antena", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = true)]protected virtual IEnumerable prenderAntena(PXAdapter adapter){    Prueba();    return adapter.Get();}public async Task Prueba(){// Use specific classes to define the JSON structure    var credentials = new Credentials    {        usuario = new FieldValue { value = "MyUser" },        contraseña = new FieldValue { value = "MyPassword" }    };       string jsonPayload = JsonConvert.SerializeObject(credentials, Formatting.Indented);    string url = "M

Hello! I am trying to pull all historical Sale Orders via the REST API. Given that we have a lot of orders, the request takes over 10 minutes. However, I noticed that every time I run the request, I hit this error around the 10 minute mark:If I add a time filter, eg get all Sales Orders after some date, the api returns results as long as it finishes in under 10 minutes. Anyone know what’s going on? Is there a way to set the timeout to be > 10 minutes?[OperationCanceledException: Operation Cancelled] PX.Data.PXCancellationToken.CheckCancellation() +197 PX.Data.PXAccess.GetConnectionString() +15 PX.Data.PXDatabase.get_Provider() +143 PX.Data.PXViewQueryCollection.Unload() +87 PX.Data.PXGraphQueryCacheCollection.Unload() +105 PX.Data.PXGraph.Unload() +2267 PX.Api.ContractBased.EntityExportContextBuilder.Dispose() +49 PX.Api.ContractBased.<GetListAsyncFromEnumerable>d__8.MoveNext() +2117 System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32 Sys

Hi, All. I am trying to get the UDF on customer screen using the GET in rest API. But the problem is the get call is returning the value null. Even the value is present in the UDF in UI. Any suggestion what should i do? Secondly when I am trying PUT request with empty body there is a value in the custom dict. Any one please help or guide me on how to over come this and what will be the best approach to fetch all udf values with customer id.GET: http://localhost/entity/Default/22.200.001/Customer?$filter=CustomerID eq '000002'&$custom=Baccount.AttributeAGDCRAN PUT: with same query 

Hello,I’m trying to make a form in report designer that has text in boxes.  The problem is that there are tiny gaps and the lines of adjacent boxes don’t touch leaving a gap of white space.  This method worked fine in the header section, but in the detail section I cannot get this gap closed.It looks good in report designer showed below.I have tried increasing the size by the smallest amount, but then report designer shows it in error.The form is covered in boxes and this looks sloppy.Any thoughts on how to overcome this?  I’ve tried panels with broders and have the same problem.Again, this worked fine in the header section which makes no sense to me.I am just putting borders on these text boxes to create my printed boxes. Thanks!

We have an external system that makes REST API calls to the SalesOrder endpoint. Every once in a while the resulting JSon has null for all Usr fields.  I can refresh the data and the result will have all field values.The other day we added code in the graph extension’s initialization routine to access some custom fields in a setup table.  Then we started to see the occasional error because those calls to GetExtension were failing. But only once in a while. But when they started to fail, they continued to fail, over and over, for a period of time. Sometimes we restarted Acumatica, sometimes the error just went away.I removed the code from the initialization routine and things were better.Doing some stress testing today, forcing ACM to send me the GET result from the order over and over, we’d get to a point where the JSon result was showing null values in all custom fields. The base fields still contained data. No change to the underlying transactional data - just sending multiple GET re

Hello,Trying to get the Historical Inventory Valuation report to show Lot #.   Is this possible in 24R1?I see it on the report designer model:  However, running the report on both Summary & Detailed versions does not yield any result for this column, OOB visibility expression set to “D” = detailed mode.Seems like the regular Inventory Valuation also does not provide any LOT #’s. Looking at the source data in the “InCostStatus” DAC it does not seem like LOT info is stored here anymore?!  Anyone have some fresh ideas here. 

We need a billing rule for mileage.  There is no cost transaction.  I guess we enter the actual mileage qty in project transactions.  Rate would be defined by the project revenue budget unit rate.

I have an unbound DAC that I’m using to display ARSalesPrice records in a grid in a pop-up screen. It works fine.The SalesPricesView view I’m using for the grid uses a public IEnumerable routine to collect and populate the view.After .Inserting the records into the view, I call SalesPricesView.Cache.IsDirty = false;When the pop-up screen is closed, I call SalesPricesView.Cache.Clear();Now when I try to save the order and I’m calling the base Persist I get this error:The table schema of the MyDACTable table was not found in the cache. The table is locked by another process. Please try again later.MyDACTable is made up of all Unbound fields and has the [PXVirtual] attribute.  The view definition is:[PXVirtualDAC]public PXSelect<MyDACTable> SalesPricesView; I don’t why Persist would care that the MyDACTable table was in the cache since it isn’t being asked to save anything.

The AR invoice for projects is showing the same inventory IDs on different lines because they are for different project tasks. Is it possible to adjust the report format so that it groups those lines into 1 line per inventory ID?I’ve tried playing around with the groupings but that is not working-I get a separate page for each inventory ID (and it still has more than 1 line).