Discussion Forums

I want to fire an import scenario to update a user field on multiple stock items when the Vendor Price Worksheet is released.  The BE will work only when Raise Event is For All Records which means the import scenario is run multiple times.  I would like it to only run once.

When add row to grid have error:Object reference not set to an instance of an object.View:[PXCopyPasteHiddenView]        [PXViewName(Messages.WorkOrders)]        public PXSelect<AMProdWorkOrder,           Where<AMProdWorkOrder.orderType, Equal<Current<AMProdItem.orderType>>,               And<AMProdWorkOrder.prodOrdID, Equal<Current<AMProdItem.prodOrdID>>>>>           WorkOrders; var wo = new AMProdWorkOrder                {                    OrderType = prodItem.OrderType,                    ProdOrdID = prodItem.ProdOrdID,                    NbrUI = nbrUI,                    SubWorkOrder = $"{prodItem.ProductOrdID}-{nbrUI}",                    Date = dateRow.Date,                    WcID = dateRow.WcID,                    Capacity = dateRow.Capacity,                    PlanQty = dateRow.PlanQty                };

PXResultset<CSCalendarDate> calendarResults = PXSelect<CSCalendarDate,                Where<CSCalendarDate.calendarID, In<Required<CSCalendarDate.calendarID>>>,                OrderBy<Asc<CSCalendarDate.calendarID>>>                .Select(Base, (object)calendarIDs); List<CSCalendarDate> calendarDates = new List<CSCalendarDate>();            foreach (PXResult<CSCalendarDate> res in calendarResults)            {                CSCalendarDate dateRow = res;                 calendarDates.Add(dateRow);            }I have error at this  in calendarResults row. Cannot create an abstract class.Its my DAC:    [Serializable]    [PXCacheName(Messages.CalendarDate)]    [PXProjection(typeof(SelectBase<CSCalendarDate,         LeftJoin<CSCalendarExceptions, On<CSCalendarDate.date, Equal<CSCale

Hi. Currently, I’m having some issues by expanding the following item of the endpoint (in order to retrieve the Email of a Contact related to a Project’s Address): The Tab, DAC, View and wanted field to retrieve in the endpoint (Project - PM301000)The wanted field to retrieve in endpoint, mappedThe error I got by trying to retrieve the field I would like to add, that the the View (Billing Contact) does not have any ContactID field to map, and also fails the endpoint even if I add it m

I feel like I know nothing about SQL even after spending 10 plus years using it on other systems when it comes to trying to use Generic Inquiries to create reports. Which I have to do because Acumatica does not have the ability to write SQL directly against the database and produce results (This is a massive feature that I can’t believe is missing and hope 2025R2 addresses it). I need to create a Generic Inquiry that looks at Customer records takes a parameter for CreatedDateTime FROM and CreatedDateTime TO. All I need to do is look at Customers whose CreatedDateTime field falls between those two parameters and run a simply COUNT function to see how many customers were created between those two dates. This seems literally impossible to do via Generic Inquiry. In SQL all I would write is SELECT COUNT(*) FROM CustomersWHERE CreatedDateTime>=1/1/2014 AND CreatedDateTime<=1/31/2014Though if you look at t

If we have Installment Terms in the Credit Terms for Customers, is there any way to create those Invoices before shipping the Product?Basically, our client has Terms for Customers that require progress/installment Payments including the Invoice before Product is shipped.I am running into two issues. If trying to create a PrePayment, I cannot do that if the Credit Terms have Installments.If I want to use the Installment functionality to create Invoices, I can't do that until the Product is shipped Any ideas on how we can solve this ?Ideally creating Invoices ahead of Shipment and utilizing the native Installment functionality on the Credit Terms. I know both my issues are apparently expected,  but we need to find a good way to have Installment payments done before Shipments.This is very common in the Manufacturing industry / custom machinery

So i created this report. I'm grouping the customers first and ARtran.RefNbr. But it is not working, how can i fix it.This is the relationIts not working. 

First, I tried to eliminate duplication of lines on multi-package shipments by moving the ShipLine fields to a new Group Section as suggested. When that didn’t work, I undid the changes and saved. But now I have all of this space although the height is still 0.16667in.Even publishing the previous version .rpx file to the server doesn’t eliminate the space.Any help out there?

How do we give access to the Screen Configuration for a user without granting ‘Administrator’ role?

I need to customize the Report definition of Balance Sheeti.e. Adding custom texts , Changing to custom header Is this possible? and How ?

-Version 25 R1-Ms Edge autofill is turned off (e.g. edge://settings/autofill/personalInfo). On the customer master general screen (or on the customer contact screen), when I enter the customer contact phone, I get blocked. Specifically, I select the field by either tabbing or clicking on the field and one of our IT admin phone numbers is displayed, but not entered.I can’t enter a phone number while I have the field selected, thus I am not allowed to enter a phone number. Here it is:  When loading the customers, I did use a generic email address at my first loading for all our customers and this phone number was used with this because I didn’t want testing correspondence to go to customers. Future import scenarios removed this email address and phone number. → I tested with oth

When sending SO to customer, how do I add the salesperson’s email in CC in my notification template? I’ve tried the below which doesn’t work. Appreciate if someone can help please. 

We upgraded from 25R1 to 25R2 and the add-in for classic Outlook 365 stopped working.  I reviewed help and it seems there are some updated steps for registering the Acumatica instance in Entra.  Under the Expose an API section, we need to add an Application ID in the format of api://<fully-qualified-domain-name>/<app-id>.  We are on SaaS - what do we use as the fully-qualified-domain-name?  Entra does not accept mycompany.acumatica.com since its not verified.  I can’t verify it since I can’t add it to my DNS.  Any insight?

Is there a way to have a certain payment type always post as a prepayment instead of a payment? For context:We create sales orders and send them to customers so they can pay for their items before they are delivered. The payments made through the integrated payment processor all post as "Payments" which creates a negative AR and really throws the AR Aging reports and overall AR out of whack. Especially since it can be a month or more before an animal is delivered and the SO is converted to an invoice, thus balancing out the AR. Manually generated payments can be posted as "Prepayments" and thereby coded to Customer Deposits instead of AR on receipt and don't cause that issue. Ideally, we'd have specific payment types automatically generate as "Prepayments" instead of "Payments" so that they post to our Customer Deposits account until the item is delivered and the transaction completed. Does a

Hello all, I have a generic inquiry created that is supposed to calculate the quote to order conversion rate. The formula we are using is (Number of SO orders with QT type as an original order type) / (Number of QT order type in the system). This is the result: All three fields are calculated fields, using Sum() directly in the formula. Since I am using aggregate function, the GI requires a group by on Order Type. Else it would throw an error. The calculations are all correct by order type, but I don’t want it to be by order type. Using the screenshot above, I want the GI to only have one line, where 2 / 1123 = 0.001809Any idea on how this can be accomplished? Thanks all! 

I am creating a GI and need to pull for a Date, however the field i need to use is a DATETIME field.  I feel like it should be easy to convert it to a DATE field only but it doesn’t seem to be.  Any hints?  I’ve tried every scenario that i can think of and google...I’ve added things to the Data Field, Schema Field, Style etc.  i can do a LEFT(Start Date,11) but then when i try to add a condition that it pulls @Today, nothing will show.  I am assuming it’s b/c of the timestamp attached to the Date.  

 I am facing an issue with a customization on the Acumatica 2025 R2 Receive and Put Away screen and would appreciate your guidance.Issue Description:I have added a custom Action Button on the Receive and Put Away screen. When the button is clicked, a popup window opens that displays a list of active locations in a grid with selection checkboxes.The expected behavior is that when I select multiple locations in the popup and confirm the action, all selected locations should be processed and set to inactive.Actual Behavior:When more than one location is selected, only the last selected location is being processed and inactivated. The previously selected locations are ignored.Expected Behavior:All selected locations in the popup grid should be processed together, and

Hi, I had to create a custom EFT Export file from scratch for a client without the Canadian localization due to cost. It does export and we sent to the client’s bank CIBC for testing. We did get some errors back. For the most part the I believe most of the errors can be corrected but need help formatting the file to comply with the 1464 characters requirement per line. I have attached a copy of the export file and CIBC requirements. Would anyone be able to provide guidance to update the export file?     Thank you,Frances  

Hello i need help on sales tax. December was inadvertently closed and i need to retrieve the December invoices. They are not showing up in the tax detail report in any other months. I thought they would show in Jan but they are not. We need in order to file taxes. 

Hi All,I have created a Project and a PO against the project when the commitments are allowed to the Project. When i lock commitments to this project and go back to the PO, put the PO on hold and add new lines to this, the system is allowing me to change it instead of restricting it.    

Hi Community,Our client requires that all newly created Inventory Items are reviewed for quality control and approved prior to activation.My initial thought was to simply change the default status of new stock items to “Inactive” so that the item can be placed in a review queue GI/Dashboard.  As I was thinking about this, I realized the client may have a legitimate reason for marking an Inventory Item as “Inactive” for reasons other than the item having been newly created.  I thought that I could couple this with a “reviewed” attribute, but we don’t have a viable to lock down a single attribute prompt without locking them all down for a group of users.  This led me to add a new drop down value to the Item Status field called “RE - Needs Review” which we would use to drive the review.  The problem with this is that there are no business rules to prevent the newly created from being used with this status.   

Currently the Acumatica to Avalara/ Avatax ECM connector requires that the customer record have the Primary Contact.  Many clients do not use these fields and certainly wouldn’t use them for requesting a sales tax exemption certificate.  They would use the information on the Bill-To Info tab.  This has the correct emails and phone numbers for these types of requests.  There is also an Account Name or Attention field that can be used as the contact for the request.  The current mapping is not useful,  it would make the connector usable if it mapped to the Bill-To Tab and not the primary contact.

Hello!I am required to get selected the Credit Term on the Sales Order based on the Customer Location or the Order Type, but currently it only provides the option to maintain the term for customer.Is there any way that I can alter this credit term selection?Best Regards 

When exporting a Generic Inquiry (GI) to Excel, the Debit/Credit column is showing Count in the Excel status bar instead of Sum, even though the values appear numeric. This happens because Excel interprets the exported data as text, not numbers.Details:Acumatica Version: 2025 R1 GI Column Expression:   =Round(IIf([GLTranR.DebitAmt] <> 0, [GLTranR.DebitAmt], -[GLTranR.CreditAmt]), 2) GIDespite using CDec() and numeric formatting, the exported Excel file still treats the column as text. This results in:Excel status bar showing Count only. Long trailing zeros in the values (e.g., 5273651.000000000000000000)Is this behavior expected in 2025 R1? Is there a way

We are using the “entity/Manufacturing/23.200.001/MoveEntry/ReleaseMoveEntry” REST API Endpoint to release the move entry at the end of the process.  We get a 202 Accepted response even when the release was unsuccessful.  A couple of reasons for the release being unsuccessful is duplicate serial numbers being received and backflush not being setup properly in the BOM.  In both of these scenarios, we still receive the 202 Accepted response with no body.  How can we “trap” these errors so we can report them to users to make the corrections?  Is there a different API call to use?  Any thoughts would be appreciated.Thank you in advance.