Discussion Forums

On SOOrderEntry the Contact field has AllowAddNew set to True in the aspx. I’d like to default the BAccountID field value on the screen that pops up (CR302000).When you click the + button on the Customer screen under contacts, I see that button is really a PXAction hiding as a new record button. In that case, the contact that is created is automatically assigned to the Customer’s BAccountID.Is there an event that I can intercept when the AllowAddNew button is clicked? Or should I add my own button and hide the existing button?

Hi All, Close financial period in payable for 10-2024 Not able to close the period even all unreleased documents are cleared , But for other workspace all are closed only for AP  iam not able to closeattached screenshots for your reference

We’ve had contracts set up after a number of bills have been entered so I now have a mix of costs in a cost code - some recorded to a contract and some not.Since the contract was set up for it’s full value I now have open commitments that will never be release.I’m trying to find a query or a report that will show me all of the transaction for a project/cost code AND include the subcontract number for each line.  Once I’ve identified transactions that should have been part of the contract I can enter a reclassing entry reducing the amount recorded without the contract and increasing the amount billed to the contract.Here’s the kicker, I can’t find the subcontract number captured in PMTRAN nor GLTRAN.Besides the billing screen of the project, the only other place I see the subcontract is on the bill input screen.Can anyone point me to where this data is stored?

Hi,I am trying to setup a financial report template for a client and I am trying to have a different formula for the expenses. Currently, the budget variance is currently set to subtract the Budget amount from the YTD amount. However, they would like to have it set the opposite for only expenses. Is there a way to achieve this?   Thank you,Joey

I am trying to automate the creation of an AP bill to a specific vendor “AP5166791306” each time a particular payment method “AP CC” is used to pay a bill. To elaborate, the “AP CC” payment method will be used to record payments made with a credit card to close out open AP bills. Once that happens, we want to automate the creation of a separate AP bill to the associated credit card vendor “AP5166791306” for the amount of the payment.I am using a GI which only returns payments paid with the “AP CC” payment method. The business event is set to trigger by each record, each time a record is inserted. This part of the solution works consistently, meaning every time I create a payment in AP using the “AP CC” payment method, the business event runs successfully.The business event has an import scenario subscriber which is intended to create a bill in the AP bills and adjustments window, using some of the results of the GI used to trigger the business event. The GI is simply a copy of the “Che

Hi Team,I’m working on customizing the Modern UI in the 24R2 (24.193.0116) preview version. Specifically, I’m adding a new tab to the Sales Order screen and have created a new field, UsrIsMagentoOrder, which I’ve included in the corresponding .html and .ts files.However, I’m encountering issues when running the following commands:npm run getmodules npm run build npm run getmodulesnpm run buildI’m receiving errors with these commands and am unable to see the changes reflected on the screen. Any guidance on resolving these errors would be greatly appreciated.Thank you!

Hi, I have created a new endpoint in acumatica and then entity of payment in it, Then i tried to create a record using the API but the payment Tab is null and the main summary is created.My query is :http://localhost/PR00000009/entity/Bank/22.200.001/BankDeposit?body: Entity : Below is the screen shot of the screen. The summary is created by PUT API but payment is null. What should i do in this case ?  Response:  

We have used the Acumatica Instructions and created an AWS server, installed Acumatica, I can use RDP to login to the AWS and access Acumatica with the Local Host.   We now want to be able to access this sales demo from a public URL without having to open the RDP.   I believe this would be done with IIS, but havent had to configure anything like this is a long time.  Goal would be to access the SalesDemo as Https://<Domain>.AcumaticaDemo.Com Thanks

I am trying to create a CSV export with a fixed header line that has two fields and detail lines that have 4 fields. Is this possible from an export scenario? How can I format the data provider/export scenario to accomplish this?I am trying to achieve the format below 

Hi! I am trying to automatically assign task ID to tasks that are created from closed opportunities. Is there a way to assign task ID to these tasks if they don’t associate to any projects? I know Task ID are usually the identifier of the project task, and it can be defined by the PROTAST segmented key on the Segmented Key Screen. Is there another way to create these ID so they are not just project task because they don’t relate to any projects? 

Quick check was a wonderful quick easy way to correct the totals for a vendor on the 1099 report.I think it’s gone.Looking for a way to get this total changed.  Especially if the correction needs to a total of several invoices.For us, these corrections are usually needed when we make payments before we get a W9 and enter the 1099 info in the vendor set up. Sue Terrysterry@ex2technology.com

I am busy upgrading my projects to Build 24.113.0010. I keep getting this error when I publish the customization in the project editor:[2024-10-17 09:41:07.313] Failed to load types from the PX.Data.BQL.Fluent, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null assembly with the message: Method 'GetWhereExpression' in type 'PX.Data.BQL.Fluent.SearchFor`1' from assembly 'PX.Data.BQL.Fluent, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' does not have an implementation.[2024-10-17 09:41:07.442] Failed to load types from the PX.Objects.PR, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null assembly with the message: Method 'GetWhereExpression' in type 'Where`1' from assembly 'PX.Data.BQL.Fluent, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' does not have an implementation.[2024-10-17 09:41:09.142] Validation failed.I installed SmartFix_T200 to test a project and got the same result.

Hello Dear Community,My Controller came to me asking if there was a way to apply payments or create invoices while a customer is on credit hold? He said there are instances where they need to apply a payment to the customer but keep them “On Hold” status. So his team are having to remove the credit hold, apply the payment, then put the customer back on hold.Can you guys provide some input?  

Hello all,I have been building a dashboard and I am looking to apply a condition where only those project IDs should be displayed which have been created under the branch ID selected in the system menu. So if I select any of these branches, the dashboard should display the results of project IDs based on the selected branch ID. Since under projects screen we have the field to define for which branch ID would be project be lie.I have applied the following. Please correct me where I am making a mistake:  

Hello,We’ve recently upgraded from Acumatica 2023 R1 to 2024 R1 and are encountering an issue involving the Sales Order and Shipment modules. Specifically, we’ve noticed that the CustomerOrderNbr field, which is typically copied from a Sales Order to a Shipment during shipment creation, is not consistently transferred.This behaviour is managed by Acumatica’s core code and previously worked as expected on 2023 R1:public virtual bool SetShipmentFieldsFromOrder(SOOrder order, SOShipment shipment, int? siteID, DateTime? shipDate, string operation, SOOrderTypeOperation orderOperation, bool newlyCreated){ if (newlyCreated) { // Removed all of the other fields, only keeping below line for brevity [...] shipment.CustomerOrderNbr = order.CustomerOrderNbr; [...] if(string.IsNullOrEmpty(shipment.ShipmentDesc)) shipment.ShipmentDesc = order.OrderDesc; return true; } else { // In our case, it's all newly created shipments, s

Where is the the best place to put own code to manipulate the attached invoice PDF of an E-Mail before it gets send?What about PX.Objects.CR.Extensions.ActivityDetailsExt.CreateNotificationProvider()?How can i PXOverride it?Pascal

Hi Everyone,When I’m trying to create the PAYMENT from the Bills and Adjustments screen and I’m getting below error. Can you please help me to understand why I’m I getting this error?     

Hi, I want to know if there is a way to change the text displayed on the Sales order Transactions Grid ?And I would like to add this text to the Quote screen as well. is this possible  ? Thanks.

hi All, I am using configurator in my production order and I want the system to use this specific warehouse to issue the material from shed 2 if I select 1022 itemwhen I create the production order and I check the detail it is not assigning the one I had used on my configuration and instead used the warehouse on the finished good item. on the header of production order maintenance! why is that ? this is not what I am expecting based on the help.thanks for your help in advance Ghazal Warehouse This is the warehouse from which this material should be issued. If not specified, the warehouse from the assembly is used.  

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