Discussion Forums

I’ve set up a business event to send out a report (attached below) once a week with a list of people. The report works fine when called on the site and brings up the right data, however, when called via the pictured Business Event, it produces a unique file (numbering in the hundreds) for every single client in the table, including the ones that should be ignored by the filter. I’ve attached images of the Business Event and Email template in addition to the report. Any help on locating the source of the issue?

Hello all  I’m upgrading our product to 25r2 and find that this code that redirects to a GI named ISPSAllocationWHOrderSOLineSplits&SOOrderNbr has an issue.  In 25r1 this forwarded to a GenericInquiry.aspx  and now it’s GenericInquiry.html.  The ‘Slot A’ text makes me think that the Modern UI might not be working correctly string inqName = $"ISPSAllocationWHOrderSOLineSplits&SOOrderNbr={WHOrderToRedirectTo.OrderNbr}&SOOrderType={WHOrderToRedirectTo.OrderType}&WHOrderNbr={WHOrderToRedirectTo.WHOrderNbr}";throw new PXRedirectToGIRequiredException(inqName, PXBaseRedirectException.WindowMode.New, true); sends me to a GI page that doesn’t seem to work correctly   

I have created a customization to convert a PO created from the Requisitions screen to a Project-Drop Ship PO.  It would be nice if that was an option on the requisitions screen, but it is not.When you create an order from the requisitions screen, it creates a standard PO.  I have an action on the Purchase Orders screen to convert it to a Project-Drop Ship PO.  The code is hacky, but it works.After the action completes, the PO screen is cleared ready for a new PO.  I want to redisplay the screen with the PO that was just converted.  It is a pain for the user to have to lookup the PO again after it was converted.I’ve tried MANY ways to try to do a PXRedirect back to the PO screen but I cannot quite get it working.If I do the convert, my current redirect sort of works.  The details grid gets populated, but the header fields do not.  If you click Cancel, it fills the fields.  I don’t know how I can click Cancel programmatically after the redirect.This is what the screen looks like after t

I already setup user role like the screenshot. Actually I don’t give user an access to Account Payable. But why a user still can insert data of Account Payable? 

Looking deeply at our cost budgets and trying to understand some of the headers so looking for some help and clarity!  On the line item for “open committed amounts” it appears that it shows things “open” that are invoiced and just aren’t paid yet.  Is that correct? But it ALSO appears this amount is reflected in “actual amount” because those pay apps have hit the GL.   I want to make sure I’m not double dipping on my cost remaining - can someone help me with this? I want the figure for invoices that are committed that haven’t even been invoiced yet - I don’t care if they’re paid or not.

I’m trying to change the Lot/Serial Class on a few stock items from LOTTRACKED to USER.When the items are allocated on Sales Orders, I get the expected error message:“IN Error: The lot/serial class of the xyz item cannot be changed because this item is allocated in the Sales Order SO1234 document.”After I deallocate the xyz item from all Sales Orders, I get a different message saying the Lot/Serial Class cannot be changed because the item has inventory.I went a step further and cleared out all the inventory, but the system still won’t let me change the Lot/Serial Class. My understanding is that once there are completed transactions (receipts, issues, shipments, etc.), Acumatica “freezes” the Lot/Serial Class to preserve transaction history.Before I commit to a solution, can anyone confirm if:This really means the Lot/Serial Class is locked forever once transactions exist, even if inventory = 0. The only supported approach is to create a new stock items with the desired Lot/Serial Class

I am trying to use a UDF attached to the customer for a numeric field (1-10) to subtract days from a date field (=DateAdd([SOOrder.RequestDate], 'd', -[Customer.AttributeCUSTRANSIT])), If I use a Number in place of the Attribute this works fine, I need to have the attribute value so this is dynamic by customer order. (Note: I am already using Lead time for another function, and this is a separate calculation). I have tried all the operators and cannot get anything that will use the attribute field in the calculation. I am open to any suggestions!

I’m trying to make some edits to this class and I’m not sure how to access it.

Source: windows - Http 2 Protocol error connecting to localhost web sites - Super UserSource: personal experience

Hi, is there a simple way to restrict creating POs from a sales order, if there is no active BOM?

Hi Team, We have a requirement where we are using the Acumatica OpenAPI Specification to make API calls to Acumatica. We are able to find and use the standard operations such as Create, Get, Update, and Delete for various entities. However, we couldn’t find any specification or endpoint for retrieving files or image data associated with these entities. Using the Contract-Based API and the Files entity, we are able to retrieve file data successfully. However, we are unable to locate the Files entity within the OpenAPI Specification. Could you please guide us on how we can achieve the same functionality using the OpenAPI Specification?

I have insert data in View (which is Temporary DAC) on LoadDelegate. But when use navigation it is not load the data.  When accessing a production order through the Production Order Detail menu, it is possible to view and edit the Order Attributes. However, after navigating among orders using the header arrows and returning to the same order, the Order Attributes are no longer visible. They only become visible again after reloading the page.   Example :-    

I am fairly new to import scenarios, at least in building them from scratch. I am importing Equipment records.  I can select multiple records to import and it will show successful with no errors, but will only import the last record on the list. I am probably missing something simple. We are on 25R1.101 below is my import scenario 

Hello, We are new to implementing Acumatica and have run into a major roadblock. I am wondering how are other companies handling the addition of freight costs to inventory movements between locations in Acumatica? Are you using standard features, customizations, or third-party solutions to ensure freight is accurately reflected in inventory value during transfers?

Hello!I have a concern related to bank reconciliations, where the supplier payment (Salary for Internal employees or external supplier payments for multiple Bills) made as a single entry in Acumatica is recorded with multiple lines in Bank Statement as the payment is going for different accounts (Salary for internal employees) or for different invoices (External Supplier Payments). Currently, I am unable to reconcile the Bank Statement transaction line with multiple payment lines of Acumatica due to the reason bank statement line is not fully matched with Acumatica payment. Is there any way that I can handle with this or a workaround that adjusting the Bank Statement manually and importing it to the “Import Bank Transactions” screen?Thank You!

I’m kind of lost on how to use OData with parameters on url using postman. Hoping someone could help me to make this work?​​​​Thank you

I have a billing rule that is just Project Budget Unit Price * Billable Quantity.The Unit Price on the Project = 213.75Whenever the quantity to bill does not end in .00 hours, the Unit Price on the Invoice is calculated to some other value.  There is no currency involved.  What would be causing this? Thank you in advance for your comments!  

Hi,We are dealing with a very large and complex GI that includes massive data, which is causing timeout issues even after applying filters.Is there a way to increase the server timeout, or are there other solutions you recommend for handling such GIs with large volumes of data? ErrorThanks,Prasad

Is it possible to set up a customer which has multiple locations for shipping and not assign any as the default?The intent is to have sales orders for that customer not prepopulate with any location on order creation - a sort of indicator that the customer has multiple locations and care should be taken that the correct location is selected. We would still want to have customers with a default location selected to have that location populate for expediency.Thank you for any insight you can provide,

I need to make a copy of an existing screen in Acumatica, and I’m looking for a way to do it that will allow the screen to follow through with an upgrade without breaking.I followed the instructions in this topic: Is it possible to copy existing screens? | Community .  That worked, but when we did an upgrade, the copied files were lost.  Also, that method requires direct access to the server.I know you can make a new screen in a customization, but I am not sure the correct way to use that to make a copy of an existing screen to then customize.  I would appreciate if someone could provide the steps to make a copy of an existing screen in a customization that could be published even after an application upgrade.  For example, I would like to copy and customize the service order screen FS300100.

I need guidance on how to set up pending VAT with a UK company specifically the 'reporting groups' to get the correct rules on the 'Report Setting' (CS.TX.20.51.00).This link does not have enough detail:-https://help.acumatica.com/(W(205))/Wiki/ShowWiki.aspx?pageid=ead5746d-beb4-4e47-afb6-9a778c36ac7f 

How can I hold the value of the Currency rate set within a Purchase Order screen so that it will populate through to the Purchase Receipt document as well as the attached Payment/Prepayment.This will override the system functionality to use the current Date of the Document to take the Currency Rate.Currency Rate [CurrencyInfo.curyRate] is updated with a Save in the Purchase Order, this value will be used to populate both the Purchase Receipt (PO302000) and the Bill and Adjustment Screen (AP301000) Screens when each screen is entered. Once a follow on (Receipt of Payment) Document has been created the Currency rate can then be updated but as a base the Rate from the Purchase Order Currency Rate.How can I achieve this in terms of a customization?Thank you!

I have a problem with this action when clicking on convert project.This is what I want. When I click "Convert to Project," the highlighted fields should be checked by default. I added this change, but it doesn't work. When I trace through code, I see that the fields are checked, but when I finish tracing and view the dashboard, they're still unchecked. Please tell me what I'm doing wrong. My code:namespace PX.Objects.PM{    // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active    public class PMQuoteMaint_Extension : PXGraphExtension<PX.Objects.PM.PMQuoteMaint>    {        #region Event Handlers        public delegate Boolean ValidateQuoteBeforeConvertToProjectDelegate(PMQuote row, ref Int32 productErrorsCount);        [PXOverride]        public Boolean ValidateQuoteBeforeConvertToProject(PMQuote row, ref Int32 productErrorsCount, ValidateQuoteBeforeConvertToProjectDelegate baseMethod)        {            if (Base.ConvertQuo

Row level security settings can be configured to limit access by user to certain email accounts for sending messages, but do these settings also apply to viewing Incoming and Sent message on those same accounts?  Or is there another way to configure this security setting?Thanks in advance!

Hi, i want to set up a new Cash Management Preference but when i try to input COA for Cash in transit account there’s no COA to select. The COA already import and set type as CASH.Please help me to solve this, there is step that i miss?? Thank you