Discussion Forums

I’ve been asked to provide an estimate for a new customization.  I’ve done several advance things in Acumatica but this one I’m wondering if a) is this possible? and/or b) should it even be attempted?They want to use Matrix Items with 8 attributes in a template.   They want to be able to add cost/labor to each attribute value and have the price calculated during entry and saved directly to AR prices when item is createdAdd custom fields to Attribute values: Use these values to calculate a price during matrix entry: This does not look like traditional graph extension with overrides.  I’ve tracked down some code PX.Objects\IN\Matrix\GraphEx

The quick question: Is there a list of the Transaction Type 3-character codes for inventory transactions (INTranDetail DAC) or, more generally, a way to view a field’s value before it is translated to the display version? As part of a larger Generic Inquiry that brings together a variety of inventory-related statistics, I am attempting to create a ‘Most Recent X Date’ column for several of the different transaction types, such as Most Recent Receipt Date and Most Recent Transfer Date. However, I am unable to filter to the desired transaction type in a formula without knowing the codes. [INTransfer.TranType] = 'Transfer' Doesn’t work, as the DAC Schema shows that the field is only 3 characters, but gives no list of what those codes are. I had to do something similar with Cross Reference codes and thankfully another po

We have a large landscaping client who is migrating from General Edition to Construction Edition. Implementation has been paused, however, because the client is disappointed in the lack of functionality of estimating. We are now vetting ISVs. ProEst is a possibility. RedTeam is only serving commercial contractors. Does anyone have any other suggestions for an ISV? One function our client needs is the ability to drop estimates into projects (not sales orders).

I am trying to add report to the Acumaca customer portal and having error as follows. Any help appreciated Server Error in '/AcumaticaERPPortal' Application.Error: You don't have enough rights on 'CR632072.rpx'.Description: 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: PX.Data.PXException: Error: You don't have enough rights on 'CR632072.rpx'.Source Error:  Line 317: }Line 318:Line 319: var pars = PXReportRedirectParameters.UnwrapParameters(passed);Line 320: passed = PXReportRedirectParameters.UnwrapSet(passed);Line 321: Source File:

We are trying to install the self service portal and cannot seem to do so on our instance.  It continually gives the error that it cannot copy the files if I try to name the instance “Portal”:Or it gives the error that it cannot find the files if I try to name it ANYTHING else even if I change the installation file path. If I create a brand new database and instance on this same server, all works fine. For a period of time it would not even run the configuration wizard.  This is on my self hosted NFR instance on Azure. We have a ticket open with Acumatica, but I thought I'd try here as well since we haven’t been able to make any headway.

I Create a new screen called material request note. I need to add a numbering sequence to its ref Number field.Firstly’ a numbering sequence was created as bellow.Then add a field to Inventory preferences and set its value to required numbering sequence ID // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class INSetupExt : PXCacheExtension<PX.Objects.IN.INSetup> { #region UsrCustomField [PXDBString(15, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Material Request Note Num Sequence", Required = true)] [PXSelector(typeof(Numbering.numberingID), DescriptionField = typeof(Numbering.descr))] public virtual string UsrMaterialRequestRefNbr

Customers are being alerted by FedEx that the development for the FedEx Web Services (SOAP) integration has been discontinued in preparation for its retirement.  FedEx is suggesting to modernize the integration by using the FedEx API (REST) solution.  Does Acumatica have a schedule for the conversion of the FedEx plugin to use the FedEx Rest API services?

I’ve created a sales order with one line and a production order by Rest-API. I would like to link these orders by API. PUTing "SOLineNbr", "SOOrderNbr", "SOOrderType" into production order object doesn’t work. These fields stay null. The other way i get an error: "An error occurred during processing of the field AMProdOrdID: A numbering sequence for the order type is not configured.." Which is wrong.Any ideas?

We are attempting us better use Acuamtica CRM.  We have come across two issues when we send an email from Acumatica CRM to a customer. First, when the cutomer replies to these CRM emails, the replies are not being sent to the saleperson that sent the emails.  Instead, the reply email returns to the email address it was sent from (in our case “sales@alaskapulltabs.com).  So the salesperson never knows his customer replied to his email.  How to we address this issue? NOTE: we were told we should not set up “sending” emails for each salesperson, but instead use just a “sales” email. Second, the reply email is not being recorded in the customers profile “activities” tab.  How do we fix this issue? 

Our client is using CRM for quoting and then they convert to a Sales order.  Wondering if anyone knows how to define the relations on the SALES ORDER RPX to get the CRM Quote number to appear on the document. I am able to link to the BAccount but not the specific sales order number, using the CRRelations 

Hello Everyone,We are working with 23 R1 build version 23.106.0055.We have a scenario where we need to get the Invoice Status and Released flag status when we are releasing the invoice.On releasing the invoice, the status will change form Balanced to Open. But when we are trying to get the value in Base.Document.Current.Status, we are getting the status as Balanced.At the same time on Invoice Release action, the Released flag will also set to true but when we are trying to access this value we are getting this as false only.On creating invoice directly:On Save action, under Persist method, we observed that Released flag is false.On Invoice release, Persist method triggering 2 times first time Released flag is false and when it triggered second time Released flag is true.On Creating Invoice through Sales Order:On prepare invoice it triggered and release is false

Is there a way to export products and all known attributes into excel?

Is there a place where I can see all the release / publish dates for all the builds of 2023 R2 ?

Hello all,I just added some new Attributes for us to expand functionality of our stock items. When I go to the Stock Items > Attributes tab, I see our current/live attributes, but I see no way of adding (+) the new Attributes I just created.Do these need to be added/enabled via a customization?

Hi I created a payment plugin to integrate Cybersource, based on ICCProcessingPlugin,but not sure why after validating and publishing, when I go to add new Processing Center, I can’t find that plugin in the plugins list In the payment plugin list I should see the new plugin I created , but not showing, maybe I’m missing something? thanks.

Would anyone know why a GI would not allow the ability to use a Sum function on a specific line for the Total Aggregate? Every other line has the ability to select a dropdown and choose a function - this is the only line which does not.   

We have configured an Import Scenario which works when it is executed from the Import by Scenario screen. When we try to process it from the Process Import Scenarios screen it does not work.  Clicking the Process button with either the Prepare option or the Prepare and Import options simply does nothing.  Neither the Status nor the Number of Records changes, even though there should be data to process.I tried to process a different Import Scenario as a test and that also did not work.Any idea what could be going on?Trace:9/14/2022 3:57:13 PM Information:SELECT TOP (13) [Customer_BAccount].[BAccountID] AS [Customer_BAccountID], [Customer_BAccount].[AcctCD] AS [Customer_AcctCD], [Customer_Customer].[CustomerClassID] AS [Customer_CustomerClassID], [Customer_Customer].[TermsID] AS [Customer_TermsID],

We currently have the company tree setup in Workgroups for Visibility of timecards and expense receipts. We would like to set up something similar so an Operations Manager can see all of the approvals his direct reports have in their list.  Do you have to set up something in the Approval Mapping?  Or can this be done an easier way? Thank you.

Receiving a lot of feedback from our company regarding the ease of submitting Time & Expenses. Generally speaking, the feedback has been negative and the UI can be a bit daunting to someone who doesn’t want to fully understand what they are submitting.I am curious- has anyone ever leveraged PowerApps to create a simpler submission for Time & Expenses? Is it even possible to do so?I fully understand that there are other solutions out there for these, but I am not necessarily looking to add another vendor to our mix. I would prefer to leverage the investments that we have made in the Microsoft environment, ex. PowerApps, PowerBI, PowerAutomate.With that being said, if possible, does anyone have any recommendations for outsourcing this development, if possible? We had a larger firm give us a quote for setting up the infrastructure for PowerBI reporting, and it was an outrageous amount of money. 

Unlike the orders with SO Order Type, the Create Payment is not Enabled for the MO Types Orders.Is there a settings to change this behavior or do we have a workaround to show the Create Payment when the order is on Hold Status.FYI, in Open status, the Create Payment option is shown. Screenshots: MO order on hold status. the Create Payment is disabled.MO order on Open status. The Create Payment is Enabled.  

Where is Incoming Documents? I do not see this in Enable/Disable Features and it does not appear in our Payables workspace. I saw a video from June 2024 called “What's New in 2024 Acumatica: Forgotten Features of Past Versions” where this is referenced. It seems this would be a very helpful feature. Thank you. 

Hello Community. I am working on a project to create shipment receipts through code and running into the error message “SO Error: Order RM 3034042 does not contain any items planned for receipt on '9/20/2024 12:00:00 AM'.” This only happens when calling the code, I can click the “Create Shipment Receipt” button from the front end without the same error. Below is how I am calling “CreateShipmentReceipt”. Any ideas?orderEntry.Document.Current = orderEntry.Document.Search<SOOrder.orderNbr>(s.OrderNbr, s.OrderType);orderEntry.Transactions.Current = s;adapter = new PXAdapter(new PXView(orderEntry, false, orderEntry.Document.View.BqlSelect));PXTrace.WriteInformation("Receipt 1.1: Checking if line needs receipt created");if (s.ShippedQty != s.OrderQty){ PXTrace.WriteInformation("Receipt 1.2: Begin receipt line creation"); orderEntry.Document.Current.ShipDate = filter.TransactionDate;

We have a situation where landed cost needs to be applied before PO Receipt and landed cost is paid before receipt. Landed Cost Vendor is different from the PO Vendor. Landed Cost paid is to be linked to the PO. Acumatica does not allow Landed Cost creation before PO receipt. Has anybody got an workaround?

Are there any retail store operators out there that have a good process for receiving that relies on vendor UPCs to match products on a PO against your Stock Items? Our receiving team struggle to know which product is which amongst our large truck deliveries and they need a screen in Acumatica to be able to scan the vendor’s UPC/barcode and pull up the Stock Item in Acumatica. The standard Stock Item screen doesn’t seem to search through the Cross Reference. Is there a way to change that search function or is there another screen where we can do a quick check?

Issue description Authorize.net is currently reporting connectivity issues they are investigating. Please be aware that it can affect processing credit cards payments in Acumatica ERP.On a user attempt to process credit card or testing credentials, the system shows the following error: ‘AR Error: Credit card processing error. ProcessingCenter: The request cannot be processed. Probably there are some network issues.’For more details about this issue and status update please refer to the Authorize.net status page.