Solved

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?

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? 

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.

Hello experts, i have created access right by role for sales user and have restricted user to create shipment but when i am creating sales order create shipment button gets enables and allow to create shipment. please check the screen shot for access right by role and please let me know what am i missing. 

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 had an employee create a bad Vendor Location ID. This ID was used in a transaction, so I can’t delete it. I need to change the Location ID code to something no one will ever use.I have inactivated it, but import scenarios bypass that status and bring them in as a vendor location to stock items etc. So how do I change this ID to something else inside of Acumatica?Thank you!

Is there an existing report in Acumatica that calculates the Average Days to Pay for Customers?   Needing a report that shows the metrics of payments for our Net 30 accounts.    

I updated our production site a couple of days ago and have encountered a strange issue where the site still works, the GIs, reports and customizations all still work, the updates screen is showing the correct version, the server is showing the correct version for the site and the database but the login screen says “Last update was unsuccessful”. I’ve tried running the update again and it does not show the correct update date, it still shows the original one from two days ago and the update history does not show a timestamp for when the update finished. Any ideas on what I can do to get rid of the error message and ensure that there is nothing wrong with the site? 

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 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   

Hi,Could you please anyone provide a quick guide to add attributes to Equipment form. When we add attributes to the customer/stock items we add to the customer/Item class. But here in equipment, there is no class and the plus button is not enabled to add attributes. Thank you,Dulanjana 

Hi:I am working with the Device Hub configuration and got this error today in the Server, RestApi Put.Have anyone seen this issue or have an idea of what it can be?Thanks

how to create a report to see history purchase by customer. i’d like to choose the customer and see all alternative id’s he bought. Maybe so and invoice can be included but main thing i’d like to see all alternative id’s per certain period of time.